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:
- Ability to double-click chart with a format dialog box.
- Macro recording is available and
- 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