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?
Like what you read?
If so, please join over 28,000 people who receive our exclusive weekly newsletter and computer tips, and get FREE COPIES of 5 eBooks we created, as our gift to you for subscribing. Just enter your name and email below:
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!
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