You can’t keep all the information you need in your head. A well-compiled cheat sheet is a nice way to quickly find questions to your answers and what’s more, structured data is easier to remember and keep in mind.
While Excel is an awesome tool for storing, structuring and organizing data, it has so many features and options that it is almost impossible to remember them all, so the following cheat sheets should be useful:
Keyboard Shortcuts and Function Quick Reference
This cheat sheet is broken down into 4 sections:
- Working in documents;
- Selections;
- Editing and formatting;
- Useful functions.
Excel Basics Cheat Sheet
This cheat sheet (pdf) is not really brief; it’s rather a short overview of most useful Excel features presented in a handy format. This makes it a perfect choice for those who only start using Excel. The main sections include:
- Shortcuts for Getting Around
- Know Your Mouse Cursors
- Select Exactly What You Want
- Work with Worksheets
- Edit a Worksheet
- Create a Basic Formula
- Format Cells and the Worksheet
- Preview and Print
Excel 2007 Quick Reference Card
That’s another one meant for beginners: it will turn useful for those who are currently learning Excel and want to know how everything is properly named there to understand reference guides and tutorials, especially in terms of excel security and excel password recovery. The cheatsheet consists of the following sections:
- The Excel 2007 screenshot (naming all its bars and boxes);
- Basic keyboard shortcuts;
- The list of fundamentals (creating, saving, previewing, etc files);
- Editing (the quick overview of editing options).
ALL Excel Shortcuts
This is the most comprehensive list of Excel shortcuts you’ve ever come across. It is available online and also can be downloaded as Excel work book.
Excel Function Cheat Sheet
This guide (pdf) contains a great table listing all Excel functions with a short explanation, syntax and even a usage example (you will need to scroll down to page 7 to find it). You can print it alone but the first 6 pages also contain some useful Excel function tips and tricks you may want to check out.
{ 0 comments… add one now }
Leave a Comment