Finding And Replacing
Understanding Find And Replace Operations
Finding Text
Finding Cell References In Formulas
Replacing Values
Using Replace To Change Formulas
Replacing Within A Range
Finding Formats
Finding Constants Using Go To Special
Finding Formulas Using Go To Special
Finding The Current Region
Finding The Last Cell
Conditional Formatting
Understanding Conditional Formatting
Highlighting Cells Containing Values
Highlighting Cells Containing Text
Highlighting Duplicate Values
Using Top and Bottom Rules
Using Data Bars
Using Colour Scales
Using Icon Sets
Creating Custom Rules
The Conditional Formatting Rules Manager
Managing Rules
Clearing Rules
Conditional Formatting - Examples and Guidelines
Advanced Filtering
Understanding Advanced Filtering
Using an Advanced Filter
Extracting Records Using Advanced Filters
Using Formulas in Criteria
Understanding Database Functions
Using Database Functions
Using DSUM
Using DMIN
Using DMAX
Using DCOUNT
Validating Data
Understanding Data Validation
Creating a Number Range Validation
Testing Data Validation
Creating an Input Message
Creating an Error Message
Creating Drop-Down Lists
Using Formulas As Validation Criteria
Circling Invalid Data
Removing Invalid Data Circles
Copying Validation Settings
Formula Auditing
Understanding Tracing Precedents
Understanding Tracing Dependents
Tracing Precedents and Dependents
Showing Formulas and Cell Arguments
Common Error Messages
Understanding Error Checking
Checking for Errors
Tracing Errors
Evaluating Formulas
Using the Watch Window
Dealing with Circular References
Goal Seeking
Goal Seeking Components
Using Goal Seek
Data Tables
Data Table Components
Using a Simple What-If Model
Creating A One-Variable Table
Using One-Variable Data Tables
Creating A Two-Variable Data Table
PivotTables
Understanding PivotTables
PivotTable Basics
Working with the PivotTable Field List
Creating the PivotTable
Adding Fields to a PivotTable
Value Field Settings
Applying a Filter to a PivotTable
Changing The PivotTable Report Layout
Manipulating PivotTable Detail
Creating a PivotTable Report
Summarising Data
Summarising Data Features
Subtotalling a List
Using a Subtotalled Worksheet
Creating Nested Subtotals
Copying Subtotals
Data Consolidation
Understanding Data Consolidation
Consolidating Data with Identical Layouts
Consolidating Data With Different Layouts
Consolidating Data Using 3D Sum Functions
Custom Views
Understanding Custom Views
Adding a Custom View
Creating a Custom View
Working with Custom Views
Working with Comments
Understanding Comments
Adding Worksheet comments
Managing Worksheet Comments
Printing Comments
Deleting Comments
