Advanced data entry and formatting techniques
- Restricting Cell Entries To Specific Numbers, Dates Or Times
- Restricting Cell Entries To Specific Entries In A List
- Creating A Custom Number Format
- Applying Conditional Formatting To A Worksheet
Naming ranges
- Defining A Range Name
- Using A Range Name In A Formula
- Selecting A Named Range
Using lookup functions
- Using The VLOOKUP Function
- Using The HLOOKUP Function
Creating a custom workbook template
- Creating A New Workbook Template
- Modifying The Default Workbook Template Style
- Basing A New Workbook On A Custom Workbook Template
Auditing a worksheet
- Tracing Precedents And Dependents In A Worksheet
- Tracing Errors In A Worksheet
Linking multiple workbooks
- Entering A Formula To Link Multiple Workbooks
- Creating A Workspace
|
Reordering and summarizing worksheet data
- Sorting The Records Of A List
- Adding Subtotals To A List
- Applying A Custom Filter To A List
- Outlining A Worksheet
Analyzing worksheet data
- Creating A PivotTable Report
- Resetting The Summary Function In A PivotTable Report
- Creating A PivotChart Report
- Creating And Displaying A Scenario
Analyzing data Part 2
- Using the Solver
- Outlining a Worksheet
- Additional Data Analysis Topics
Workgroup features
- Tracking Changes in a Workbook
- Responding to Proposed Changes
- Protecting a Shared Workbook
- Protecting an Unshared Workbook
- Merging Revised Copies of a Workbook
- Additional Workgroup Features
Additional advanced excel features
- Using The Data Consolidation Feature
- Adding A Trend line To A Chart
- Saving An Excel Workbook As An XML Spreadsheet
|