You Can Trust Our Reviews
Deeper Dive: Our Top Tested Picks
Buying Guide: 5 Essential Microsoft Excel 2010 Tips for Advanced Users
Contents
- 5 Essential Microsoft Excel 2010 Tips for Advanced Users
- Insert a Transposed Copy of a Table with Two Mouse Clicks
- Create a 'Live' Transposed Copy of a Table
- Create Sparkline Microcharts In Excel
- Add Content or Formatting to Multiple Sheets at Once
- Be Careful When Working With Grouped Sheets
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 >
For more Office tips, see:
• 5 Essential Microsoft Office 2010 Tips for Everyone
• 15 Essential Microsoft Word 2010 Tips for Beginners
• 10 Essential Microsoft Excel 2010 Tips for Beginners
• 14 Essential Microsoft Outlook 2010 Tips for Beginners
• 14 Essential Microsoft Excel 2010 Tips for Intermediate Users
• 10 Essential Microsoft Word 2010 Tips for Advanced Users
• 5 Essential Microsoft Excel 2010 Tips for Advanced Users
• 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