832.204.4909

Exploring Microsoft Excel 2010

by Yehuda Cagen 22. February 2011 12:01

 

Welcome to Part 3  (see Part 1 and  Part 2) of a series of tech tips on Microsoft Office 2010.

In this edition, Houston IT Consulting expert, Cheryl Smith, shares some of the new and improved features of Excel 2010.

New features in Excel 2010:

·         Sparklines-tiny, word-sized charts that can appear in a cell. (Insert tab)

·         Slicer-allows you to filter your pivot table similar to the way Filter fields filter in a pivot table. The difference is that Slicers offer a user friendly interface, allowing you to see the current filter state easier. Provides a rich visualization of your pivot table. (Insert tab)

Improved features of Microsoft Excel 2010:

  • Pivot Tables-(insert) now possible to fill-down labels in pivot tables.
  • Charting-(Insert) Improved chart feature:
    1.  Ability to double-click chart with a format dialog box.
    2. Macro recording is available and
    3. The limitation of data point that can be created has been removed.
  • Named Sets-(formula)create your own named sets, field, items & sets on Ribbon allows you to define your own sets.
  • Filter Capabilities-(data) New search filter-use this when searching in Excel tables, pivot tables, and pivot charts which allows you to also deselect what you don’t need.
  • Conditioning Formatting-(home) makes it easier to highlight cells or range of cells & new icon sets, more options with data bars, along with the ability to refer to values in other worksheets in your workbook.
  • Performance Enhancements - It is more responsive when you move or resize charts, work in page layout view and interact with shapes on a worksheet. Also takes less time to perform commonly performed task on large data sets such as; filtering, sorting, and copy/paste. Opening and saving large files is faster than before.

 

We hope you have found this information helpful. If you would like to learn more about this subject, please feel free to contact us:

        Questions about this article?

        Suggest a topic

        Learn more about our Houston computer services 

 

Tags:

Microsoft Training

Comments

Add comment


(Will show your Gravatar icon)

  Country flag

biuquote
  • Comment
  • Preview
Loading



About IsUtility®

IsUtility® is a turnkey  Houston infor-
mation technology
solution that
brings accountability back to the IT
services industry. We've already
invested in your business - all the
servers and remote pc support -
eliminating the costs and risks of
owning  an onsite IT infrastructure.

Ask The Experts!

Send your IT questions directly to our knowledgeable experts. Since 2000, we’ve helped executives just like you make sense of business technology!
Name
Email
Your Question


Message was successfully sent

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Join our FREE Email Mailing List
For Email Marketing you can trust
Follow Us facebook twitter LinkedIn