Excel XP Advanced
1. INTRODUCTION
2 ADVANCED DATA ENTRY AND FORMATTING TECHNIQUES
2.1 Introduction
2.2 Restricting Cell Entries to Specific Numbers, Dates or Times
2.3 Restricting Cell Entries to Specific Entries in a List
2.4 Creating a Custom Number Format
2.5 Applying Conditional Formatting to a Worksheet
2.6 Summary
3 NAMING RANGES
3.1 Introduction
3.2 Defining a Range Name
3.3 Using a Range Name in a Formula
3.4 Selecting a Named Range
3.5 Summary
4 USING LOOKUP FUNCTIONS
4.1 Introduction
4.2 Using the VLOOKUP Function
4.3 Using the HLOOKUP Function
4.4 Summary
5 CREATING A CUSTOM WORKBOOK TEMPLATE
5.1 Introduction
5.2 Creating a New Workbook Template
5.3 Modifying the Default Workbook Template Style
5.4 Basing a New Workbook on a Custom Workbook Template
5.5 Summary
6 AUDITING A WORKSHEET
6.1 Introduction
6.2 Tracing Precedents and Dependents in a Worksheet
6.3 Tracing Errors in a Worksheet
6.4 Summary
7 LINKING MULTIPLE WORKBOOKS
7.1 Introduction
7.2 Entering a Formula to Link Multiple Workbooks
7.3 Creating a Workspace
7.4 Summary
8 REORDERING AND SUMMARIZING WORKSHEET DATA
8.1 Introduction
8.2 Sorting the Records of a List
8.3 Adding Subtotals to a List
8.4 Applying a Custom Filter to a List
8.5 Outlining a Worksheet
8.6 Summary
9 ANALYZING WORKSHEET DATA
9.1 Introduction
9.2 Creating a PivotTable Report
9.3 Resetting the Summary Function in a PivotTable Report
9.4 Creating a PivotChart Report
9.5 Creating and Displaying a Scenario
9.6 Summary
10 IMPORTING AND EXPORTING DATA
10.1 Introduction
10.2 Importing Data in a Text File into Excel
10.3 Importing Data in a Database File into Excel
10.4 Importing Data from a Web Page into Excel
10.5 Exporting Excel Data to Other Applications
10.6 Summary
11 WORKING WITH OTHER EXCEL USERS
11.1 Introduction
11.2 Tracking Changes in a Workbook
11.3 Responding to Proposed Changes and Comments in a Workbook
11.4 Protecting a Shared Workbook
11.5 Protecting an Unshared Workbook
11.6 Merging Revised Copies of a Workbook
11.7 Additional Workgroup Topics
11.8 Summary
12 ADDITIONAL ADVANCED EXCEL FEATURES
12.1 Introduction
12.2 Using the Data Consolidation Feature
12.3 Adding a Trendline to a Chart
12.4 Saving an Excel Workbook as an XML Spreadsheet
12.5 Summary
13 FINAL CASE STUDY