Friday, January 17, 2014

Spreadsheet tips: Microsoft Excel and Google Docs

Microsoft Excel

Microsoft Excel is one of the most important tools for any type of analytical or quantitative work.

One of the best ways to get quicker at Excel or any process is after using it for awhile, notice what steps take you a while, and see if there are faster ways to execute it.  This way, you don't have to memorize a ton of shortcuts that you rarely use.

Some sites with useful Excel shortcuts:
http://searchenginewatch.com/article/2292786/10-Quick-Time-Saving-Excel-Shortcuts-Mouse-Tricks-for-Marketers

http://office.microsoft.com/en-us/excel-help/excel-shortcut-and-function-keys-HP010073848.aspx


Google Docs Spreadsheet

Good, free, alternative to Microsoft Excel.  Excel also has a free ad-supported starter edition that you can download at http://www.techspot.com/downloads/6255-microsoft-office-starter-2010.html

One of the best things about Google docs is that it's online, meaning you can access it from a computer anywhere.  Plus it's constantly backed up so you don't have to worry about your computer crashing and losing your work.  It has most of the basic features needed for spreadsheets.

You can access Google Docs at http://drive.google.com



No comments:

Post a Comment