Top 12 Excel Function Cheat Sheets

Everyone likes a good cheat sheet! And for Excel, functions are so important in how the spreadsheet operates that it’s imperative to get the formulas and functions correct. So to learn the basics or to check what you’ve entered is doing what you actually want it to do, check out the following pages…

1) http://www.socialphy.com/posts/do-it-yourself/6879/The-Ultimate-Excel-Cheatsheet.html     An excellent array of cheat sheets available here from shortcuts to functions and formulas. If you learn all these you’re sure to be an Excel power user! Includes links at the end for even more cheat sheets for advanced users.

2) http://lca.lehman.cuny.edu/lehman/itr/html/library/Excel-Formulas-manual.pdf  Everything you need to know about formulas from constructing them to inserting them. Includes a table at the end with a list of the formula names, what they do and an example.

3) http://www.computerworld.com/s/article/9028228/Excel_2007_Cheat_Sheet?taxonomyId=86&pageNumber=1 A really excellent 8 page online guide to the general Excel interface and what all the buttons do. Less about functions and more about how to navigate and complete tasks. Plenty of screen shots to help with that.

4) http://www.wallstreetprep.com/blog/excel_resources.php Downloadable sheets aimed at financial modelling for investment banking but this is an Excel skill that financial consultants often use so get learning the keyboard shortcuts! Includes 2003, 2007 and 2010 as well as a list of shortcuts for Macs.

5) http://www.xlfdic.com/ This ‘Excel function dictionary’ is very simple but is good for general reference and can also be downloaded

6) http://equity-research.com/printable-excel-cheatsheet/ Very pretty printable cheat sheets here, starting with the basics and moving to functions and includes examples. Definitely worth printing!

7) https://www.udemy.com/blog/excel-formulas/ A really simple 10 point guide to most commonly used formulas in Excel.

8) http://www.dummies.com/how-to/content/excel-formulas-and-functions-for-dummies-cheat-she.html The Dummies have a good beginner’s list here of likely functions, cell references and error messages you might come across. Quite brief, but a good starting point.

9) http://cgi.unc.edu/uploads/media_items/k-12-program-evaluation-manual-appendix-c.original.pdf  A free 8 page document detailing basic formatting and with some examples of functions in action.

10) http://www.scribd.com/doc/4762568/advexcel Step by step points on 30 issues for advanced Excel users.

11) http://www.cogniview.com/convert-pdf-to-excel/wp-content/uploads/2008/11/cogniview-excel-cheat-sheet.png   A simple table of keyboard shortcuts for general editing and formatting as well as some commonly used functions.

12) And finally, although not quite about function, here is a list of 10 useful keyboard/mouse cheats to save time when navigating Excel all day. Includes animations to see them in action. You’ll be pleased you learnt these! http://searchenginewatch.com/article/2292786/10-Quick-Time-Saving-Excel-Shortcuts-Mouse-Tricks-for-Marketers

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s