• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 14. Advanced Spreadsheeting > Opening the Excel Toolbox

14.4. Opening the Excel Toolbox

Like a good piece of Swiss Army Software, Excel provides tools that go beyond the basics. Using features like PivotTables, Scenarios, and Goal Seeking, Excel lets you look at your data in new and interesting ways.

14.4.1. Making a PivotTable

A PivotTable is a special spreadsheet entity that helps summarize data into an easy-to-read table. You can rotate the table's rows and columns (thus the name PivotTable) to achieve different views on your data. PivotTables let you quickly plug different sets of numbers into a table; Excel does the heavy lifting of arranging the data for you.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint