5 Essential Microsoft Excel 2010 Tips for Advanced Users

 

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

More

 

• 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

via 5 Essential Microsoft Excel 2010 Tips for Advanced Users | PCMag.com.

Related posts:

Share

About Kathy

I love being involved in education because I am always learning something new and exciting. I have been teaching and helping students for over 25 years with computer applications and keyboarding classes. Before computers, I helped students learn how to use dedicated word processors. It was a long time ago! Currently, I work at MiraCosta College, a community college in California, where I teach computer applications for the Computer Applications Department and keyboarding classes for the Business Office Technology Department. I teach one- and two-day computer courses through Community Services, and work as an Instructional Assistant II for the Academic Information Services Department. I’ve been enjoying my jobs at MiraCosta for over 20 years! Prior to MiraCosta, I worked at Eldorado Business College teaching word processing and business courses. And, for about 15 years I’ve been teaching online courses (PowerPoint 2010, 2007, & 2003, and Keyboarding) through Education to Go, a division of Cengage Learning. I find teaching and learning online an awarding experience. I enjoy reading, learning, traveling, and spending time with my family. Kathy

, ,

2 Responses to 5 Essential Microsoft Excel 2010 Tips for Advanced Users

  1. Kathy August 8, 2012 at 11:18 am #

    You’re welcome!

    Kathy

  2. windows tips August 5, 2012 at 1:30 pm #

    It is fantastic. And help me a lot and save times from my life. Thanks a lot for sharing such a nice article.

Leave a Reply