Using Multiple Worksheets
Working with Multiple Worksheets
Inserting and Deleting Worksheets
Moving and Copying Data between Worksheets
Moving and Copying Worksheets
Grouping Worksheets
Creating 3-Dimensional Formulas
Consolidating Data from Multiple Worksheets
Manipulating the Screen Display
Working with Multiple Workbooks
Displaying Multiple Workbooks
Navigating among Open Workbooks
Freezing Worksheet Panes
Freezing Rows
Working with Advanced Functions
Using the NOW Function
Using the DATE Function
Using the VLOOKUP Function
Using the PMT Function
Using Advanced Formatting Features
Using Conditional Formatting
Creating Custom Number Formats
Grouping Data
Outlining Data
Using Advanced Print Options
Defining Page Setup Options
Changing Print Size and Page Orientation
Creating Headers and Footers
Printing Titles
Setting and Printing Print Areas
Printing Multiple Worksheets
Printing Workbooks
Filtering Lists Using AutoFilter
Specifying Single Comparison Criteria
Specifying Custom Criteria
Removing Filters
Working with Names
Naming Ranges
Using Range Names in Formulas
Deleting Range Names
Protecting Data
Protecting Workbook Elements
Protecting Worksheets
Hiding Data
Assigning Passwords to Workbooks
Using Basic Integration and Web Features
Importing Data from Text Files
Importing Data from Other Office XP Applications
Saving Workbooks as Web {ages
Publishing Workbooks to the Web
Using Comments
Creating and Printing Comments
Displaying and Hiding Comments
Editing and Deleting Comments
Working with Charts
Creating Charts
Moving and Resizing Charts
Changing Chart Types
Editing Chart Data
Printing Charts