Professor Teaches Excel 2007 Advanced
Also compatible with Windows® Vista™ or XP SP2
Custom Tutorial Set
Create your own Custom Tutorial Set that contains just the courses you want.
The Fastest, Easiest Way to Learn Excel 2007 Advanced!
Professor Teaches courses use real-world settings and accurate simulations to help you apply your new knowledge directly to daily tasks and the knowledge you gain becomes an asset for life.
Chapter 1: Applying Formatting to Numbers
• Creating Custom Number Formats
• Applying Conditional Formats
• Using Formulas in Conditional Formats
• Absolute and Relative References
• Naming a Range
• Using a Named Range in a Formula
• Using Lookup Functions
• IF Functions
Chapter 2: Applying a Template
• Using a Template
• Creating a New Template
• Editing a Template
• Linking between Workbooks
• Importing Data from Text Files
• Importing Data from Other Applications
• Importing an HTML Table
• Publishing Data to the Web
Chapter 3: What is a List?
• Validating Data Entries
• Sorting Data
• Subtotaling and Outlining Data
• Extracting Data with Filters
• Using Advanced Filters
• Using Query
• Querying the Web
• Using XML to Share Data
Chapter 4: Using PivotTables
• Managing PivotTable Reports
• Creating PivotChart Reports
• Using Charts and Trendlines
• Working with Scenarios
Chapter 5: What is a Macro?
• Recording a Macro
• Running a Macro
• Editing a Macro
• Auditing Workbooks
• Tracing Errors
Chapter 6: Creating a Shared Workbook
• Consolidating Data
• Protecting Columns
• Protecting Worksheets
• Protecting Worksheet Contents
• Protecting Cells
• Assigning a Password
• Tracking Changes
• Adding Comments
• Preparing a Workbook
Professor Teaches courses use real-world settings and accurate simulations to help you apply your new knowledge directly to daily tasks and the knowledge you gain becomes an asset for life.
Chapter 1: Applying Formatting to Numbers
• Creating Custom Number Formats
• Applying Conditional Formats
• Using Formulas in Conditional Formats
• Absolute and Relative References
• Naming a Range
• Using a Named Range in a Formula
• Using Lookup Functions
• IF Functions
Chapter 2: Applying a Template
• Using a Template
• Creating a New Template
• Editing a Template
• Linking between Workbooks
• Importing Data from Text Files
• Importing Data from Other Applications
• Importing an HTML Table
• Publishing Data to the Web
Chapter 3: What is a List?
• Validating Data Entries
• Sorting Data
• Subtotaling and Outlining Data
• Extracting Data with Filters
• Using Advanced Filters
• Using Query
• Querying the Web
• Using XML to Share Data
Chapter 4: Using PivotTables
• Managing PivotTable Reports
• Creating PivotChart Reports
• Using Charts and Trendlines
• Working with Scenarios
Chapter 5: What is a Macro?
• Recording a Macro
• Running a Macro
• Editing a Macro
• Auditing Workbooks
• Tracing Errors
Chapter 6: Creating a Shared Workbook
• Consolidating Data
• Protecting Columns
• Protecting Worksheets
• Protecting Worksheet Contents
• Protecting Cells
• Assigning a Password
• Tracking Changes
• Adding Comments
• Preparing a Workbook