Microsoft Office Tutorials and References
In Depth Information
Shockingly, many Office users have no idea that Excel can be used for something other
than budgets and simple lists. If your only exposure to Excel is the monthly ritual of adding
your department’s numbers to the corporate budget template, we have some surprises for
you. In the four chapters we devote to Excel, we cover the fundamentals of formulas,
formatting, and filtering data; we also help you unlock the magic of PivotTables, which sound
intimidating but are easy to master and incredibly useful once you learn how they work.
The most obvious improvements in Excel 2010 are related to data analysis and
presentation. Most professional number crunchers use charts and visualizations to help other people
understand the impact of a mass of raw numbers. The new sparklines feature embeds
graphic representations of data trends directly within those numbers (and updates them
automatically as the numbers change), as shown in Figure 1-7.
Figure 1-7 Using sparklines allows you to visualize trends and patterns alongside the data in an
For cutting large data sets into manageable workloads, Excel 2010 offers several useful
tools: Use PivotTables, for example, to quickly and easily create crosstabs and summaries
of even very large data sets with just a few clicks. In traditional lists or PivotTables, you can
create search filters to help find relevant items.
Although OneNote has been a part of Office since the 2003 release, many experienced
Office users are unlikely to have spent even a minute with it. That’s because OneNote
was previously included only with the Home and Student and Ultimate editions of Office.