Fine tune your Microsoft Office 2010 Excel skills with a few masterful tricks.
By Edward Mendelson, Jill Duffy
June 16, 2011
100 Essential Tips for Microsoft Office 2010
Like learning a foreign language, trying to become a Microsoft Excel master comes with a “use or it lose it” quandary. You can learn all the tips and tricks in Excel you like, but if you don’t practice them often enough, they slip from your mind, fleeing your memory without a trace—not even the name of the darn thing you’re trying to remember. Pick up a new idea for Excel on Monday, and if you don’t use it Tuesday or Wednesday, it’ll be gone by Thursday.
The five tips in this article are things we think all advanced users of Microsoft Excel will not only learn quickly, but also use often enough to remember them tomorrow. They cover some of the most important features that spreadsheet makers should know, as well as some of the new features in the latest version, Microsoft Office 2010 Excel. For example, we take a walk-through creating the new Sparkline Microcharts, or charts that fit inside a single cell. We also cover in detail working with transposed tables, including how to make them “live.” We even go over how to add content or formatting to more than one sheet at once, and explain when and why you should ungroup sheets.
For more Microsoft Office 2010 tips, including beginner tips for Outlook, Excel, and Word, see the complete list of links at the end of this article. Also see our complete reviews of Microsoft Office 2010 ($389 street, 4 stars) and Microsoft Office 2010 for Mac ($99 street, 4.5 stars). You can either read our tips in the slideshow below or page through them in the Table of Content.—Next: Insert a Transposed Copy of a Table with Two Mouse Clicks >
View Slideshow See all (5) slides
Insert a Transposed Copy of a Table with Two Mouse Clicks
Transposition Even Better: Create a
Create Sparkline Microcharts In Excel
Add content or formatting to multiple sheets at once
• 8 Essential Microsoft Outlook 2010 Tips for Intermediate and Advanced Users
• 9 Essential Microsoft PowerPoint 2010 Tips
• 10 Essential Microsoft Access 2010 Tips for Beginners