More Nuggets
Functions are the nuts and bolts of Excel and allow you to do calculations and tasks ranging from from very basic to very complex.
For Accountants
If you are in the accounting profession, this section focuses on topics that may be of particular interest to you.
Tips and Tricks
There are a virtually unlimited number of tips and tricks and shortcuts to help you be the most productive you can be with Excel.
The Basics
If you are relatively new to Excel, a solid grasp of the basics are very important to getting the most out of Excel.
Functions
Functions are the nuts and bolts of Excel and allow you to do calculations and tasks ranging from from very basic to very complex.
Welcome!
Excel Nuggets is a new and growing Excel reference and help site. Our goal is to provide you the most relevant help in an easy to read format. It's that simple!
| Keyboard Shortcuts |
| Skills Test: Common Keyboard Shortcuts |
| Skills Test: Advanced Keyboard Shortcuts |
| Skills Test: All Keyboard Shortcuts |
| Quick Reference Card of Keyboard Shortcuts (PDF) From Microsoft |
| Five Excel Quick Tips From Journal of Accountancy - March 2011 |
| Tips and Tricks for Excel From Microsoft |
| Excel 2010 Shortcuts From shortcutworld.com |
| Excel Tips and Tricks From MIT |
| Amortization Schedules |
| Depreciation Formulas |
| Dashboard Your Scorecard From Journal of Accountancy - February 2011 |
| Pivot Tables |
| Advanced Criteria |
| Inserting Symbols |
| Quick Reference Card of Keyboard Shortcuts (PDF) From Microsoft |
| Pivotal Advance Boosts Excel's Power From Journal of Accountancy - September 2011 |
| Microsoft Excel 2010 Support From Microsoft |
| MS Office Personal Budget Worksheet From Microsoft |