Skip to content

 

What’s New In Microsoft Excel 2010?

Bookmark and Share

Here’s a quick summary of what’s new, relative to Excel 2007:

  • 64-bit version:
    If your hardware supports it, you can install the 64-bit version, which lets you create much larger workbooks.
  • Sparkline charts:
    Create small, in-cell charts to summarize a range of data graphically.
  • Pivot table Slicers:
    A new way to filter and display data in pivot tables.
  • Pivot table formatting options:
    You have more control over the appearance of pivot table reports.
  • File tab:
    The File tab replaces the Office button, which is located to the left of the other tabs. Clicking it displays Backstage View, a screen that lets you perform various operations on your workbook. This view essentially replaces the traditional File and Print menus — plus quite a bit more.
  • Draft mode for charts:
    If you use many highly formatted charts, you can choose to display them in draft mode for improved performance.
  • Conditional formatting enhancements:
    Data bar conditional formatting can display in a solid color, and the bars provide a more accurate display.
  • Function enhancements:
    Many of Excel’s statistical functions have been improved in terms of numeric accuracy. The old versions of these functions are still available and have been relegated to a new function category called Compatibility.
  • Image editing enhancements:
    You have much more control over the appearance of graphic images inserted into a workbook.
  • Paste preview:
    When you copy a range, the Paste command displays various options (with preview).
  • Ribbon customization:
    End users can customize the Ribbon by adding new tabs and groups.
  • Equation editor:
    Create and display (noncalculating) mathematical equations.
  • Faster processing:
    Microsoft made some improvements to the calculation engine, and files load a bit faster.
  • New security features:
    Workbooks downloaded from the Internet or from e-mail attachments are opened in Protected View mode. Workbooks can be designated as “trusted,” and they don’t need to reside in special trusted folders.
  • Updated Solver:
    Excel 2010 includes a new version of the Solver add-in.
  • Enhancements to VBA:
    Many operations that used to require old XLM macros can now be performed directly using VBA macro commands.