Seasonal Savings: 20% off selected memberships for a limited time. Give now

Learn it fast with expert-taught software and skills training at lynda.com. See what you can learn

By Bonnie Bills | Tuesday, May 25, 2010

Office 2010 for Business: Focus on Excel

lynda.com has been rolling out training on Office 2010, which launched to business customers earlier this month. I’ve been talking to our Office 2010 authors about their experiences with the latest version of Microsoft Office. Today’s Q&A features Bob Flisser, author of Excel 2010 New Features.

Q: In your opinion, what’s the most interesting new feature in Excel 2010?

A: Since Excel was already a mature application, I couldn’t imagine how Microsoft could improve it for 2010. Now that I’ve been using it for a while, I’d have to say the most interesting–which to me means fun–new feature is Sparklines. (Yes, I said a spreadsheet program is fun.)

Let’s say each row on your worksheet lists a product you sell, and each column shows the amount of a different month’s sales. With a couple of clicks, you can insert a tiny trend line or bar graph contained inside a cell at the end of each row, showing how sales of the product rose or fell over the months. If there are 20 rows, there are 20 miniature charts. With a couple more clicks, you can apply formatting that brings out exactly the information you need.

Get the latest news

  •   New course releases
  •   Pro tips and tricks
  •   News and updates
  
New releases submit clicked

You can change your email preferences at any time. We will never sell your email. More info

Featured articles

A lynda.com membership includes:

Unlimited access to thousands of courses in our library
Certificates of completion
New courses added every week (almost every day!)
Course history to track your progress
Downloadable practice files
Playlists and bookmarks to organize your learning
Become a member

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.