For most of us, Excel is one of those programs where you use 10% of the functionality and only even know of 50% of it. Regardless of whether or not you fall into this category, an brief article you might want to take a look at is “Hidden gems in Excel 2007“.
This points out and walks you through 3 functions which most of us would probably find very helpful:
- Quick worksheet selection.
- Filtering data based on conditions.
- Aggregate grouping setup.
The first entry alone is worth reading if you were not already aware of this.
Anyone else have any Excel tips/shortcuts they would like to share?
Loading ...
LaptopBags
23. Mar, 2009
Thanks for the post. I’m afraid I have not tips as one of the 10%ers. I am greatly in need of someone to de-baffle Excel for me!
Rickard Warnelid
24. Apr, 2009
I quite like the summary of Excel Shortcuts on the following site. Download the PDF and pin up next to your desk, it is quite useful.
http://navigatorpf.com/training/tutorials/excel-keyboard-shortcuts-basic