{"id":8847,"date":"2014-08-05T05:04:30","date_gmt":"2014-08-04T19:04:30","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=8847"},"modified":"2019-10-16T10:52:58","modified_gmt":"2019-10-16T00:52:58","slug":"emailing-microsoft-excel-spreadsheet-primer-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/emailing-microsoft-excel-spreadsheet-primer-tutorial\/","title":{"rendered":"Emailing Microsoft Excel Spreadsheet Primer Tutorial"},"content":{"rendered":"
\"Emailing<\/a>

Emailing Microsoft Excel Spreadsheet Primer Tutorial<\/p><\/div>\n

Having seen computer desktop work being overtaken by work taking place on the web, in the iCloud, in Google Docs, in dropboxes, or hosted data places, it should come as no surprise that spreadsheet work using the Microsoft Excel spreadsheet format should be able to be conducted by email (for example, Gmail) without “consciously” (ie. there are probably temporary files you can find) touching your laptop’s hard drive. Even so, this still strikes me as pretty good in that you can stay within your email application and do a whole lot of work related tasks without leaving that environment. Probably it was the use of tablets that pushed the need for such functionality, as tablets are not so keen on local storage of files.<\/p>\n

I like to think of this as doing things in “mid-air” (or in the “ether”), but (this) is not purely correct, because, as you would expect, to restore the data before your eyes during your email session, the data more than likely came from a file on a web server, cloud server, dropbox, database or “centralized storage that is not your hard disk” … should we say. It is like “mid-air” though, in the sense that your work can hover around you as you travel, and you don’t have to use your<\/i> laptop or tablet or phone to get at it at the other end (Gmail usage only relies on web browser access to the Internet).<\/p>\n

Call me naive, but I can’t help but think that that is cute! Call me backward, perhaps, because it is probably par for the course for many people today who “Sync”<\/a> their devices on a regular basis (often tablets and mobile phones).<\/p>\n

As with many good things, the progress can come at the expense of your control over data, because you hand it over, really, trusting this data is not used illegitimately, or without permission, or without your complicity or knowledge. All this, though, is not much to do with this tutorial. In this tutorial we show you a spreadsheet, created perhaps on a laptop’s hard disk, maybe a long time ago, but not needing to land back at that laptop’s hard disk, to be useful, anytime soon. So what sort of data suits such arrangements? Most obviously, a daily planner, or daily reporting arrangement, or regular anything, in the format of an Excel spreadsheet, at least, for today’s case<\/a>. That (Microsoft) Excel spreadsheet functionality and usage is discussed in previous tutorial such as Microsoft Excel Spreadsheet Home Budget Tutorial<\/a> below.<\/p>\n

You may notice watching the tutorial that the spreadsheet is attached to the “mid-air” email, and that if it gets to the point where some security restriction would stop the email recipient opening an Excel spreadsheet email attachment (and some (mail servers) might (restrict such attachments), because of the concern about viruses in relation to Excel macros, for example) you can, in Gmail, send the attachment in PDF format<\/a>. The other alternative could be to zip up the Excel spreadsheet and send that instead, but then you’d probably be using your laptop’s hard disk, whereas today’s scenario, in its pure sense, was trying to show that this was not necessary.<\/p>\n

\n

Previous relevant Microsoft Excel Spreadsheet Home Budget Tutorial<\/a> is shown below.<\/p>\n

\"Microsoft<\/a>

Microsoft Excel Spreadsheet Home Budget Tutorial<\/p><\/div>\n

One of the oldest topics regarding personal computers and software is the spreadsheet … the first “killer app” (read Wikipedia’s spreadsheet information and VisiCalc<\/a>) that got so many people on board the enthusiastic embrace of the personal computer in the early 1980’s.<\/p>\n

Given this history there is not much chance you’ll see anything that is “new under the sun” here, but can offer a strategy to teach yourself about spreadsheets, using Microsoft Office’s Excel application.<\/p>\n

The first recommendation tackling spreadsheets is that you should have a plan regarding the spreadsheet before you open Excel to create a new spreadsheet style you do not create via other data sources as we showed with the previous Microsoft Excel Spreadsheet Primer Tutorial<\/a> as shown below.<\/p>\n

Another good suggestion regarding a spreadsheet design is to follow the lead of a good example in a book, and for this would recommend Computing for Seniors<\/i> by Sue Price, with her Home Budget spreadsheet ideas. Just a few pages of good instructions and you are on your way to the creation of a useful and practical Home Budget<\/a> spreadsheet.<\/p>\n

Excel is part of the Microsoft Office suite of software and here is a download<\/a> link.<\/p>\n

Here is a good link for Microsoft Excel training resources at this link<\/a>.<\/p>\n

\n

Previous relevant Microsoft Excel Spreadsheet Primer Tutorial<\/a> is shown below.<\/p>\n

\"Microsoft<\/a>

Microsoft Excel Spreadsheet Primer Tutorial<\/p><\/div>\n

One of the oldest topics regarding personal computers and software is the spreadsheet … the first “killer app” (read Wikipedia’s spreadsheet information and VisiCalc<\/a>) that got so many people on board the enthusiastic embrace of the personal computer in the early 1980’s.<\/p>\n

Given this history there is not much chance you’ll see anything that is “new under the sun” here, but can offer a strategy to teach yourself about spreadsheets, using Microsoft Office’s Excel application.<\/p>\n

The first recommendation tackling spreadsheets is that you should have a plan regarding the spreadsheet before you open Excel to create a new spreadsheet style you do not create via other data sources.<\/p>\n

So, for the scenario of starting from scratch with an Excel spreadsheet, that you design yourself:<\/p>\n