Course details . . .

Day 1 - Intermediate Table of Contents

10. Validations
1. Validation Techniques
2. Data Validation By Number Range
3. Testing Data Validation
4. Input Messages
5. Creating Error Alerts
6. Creating Drop-Down Lists
7. Using Formulas As Validation Criteria
8. Creating Custom Validation Criteria
9. Number Formats With Built-In Logic
10. Conditional Formatting
11. Copying Data Validation Settings
12. Validations Quick Reference
11. Protecting Data
1. Unlocking Cells
2. Protecting A Worksheet
3. Working With A Protected Worksheet
4. Disabling Worksheet Protection
5. Password Protecting A Worksheet
6. Protecting Data Quick Reference.

Day 2 - Advanced Table of Contents

1. Labels And Names
1. Labels And Names Explained
2. Accepting Labels In Formulas
3. Using Text Labels
4. Creating Labels
5. Creating Names Using The Name Box
6. Using Names To Select Cells
7. Using Names In Formulas
8. Creating Names Between Workbooks
9. Creating Names For Constants
10. Creating A List Of Names
11. Changing The Range For Names
12. Deleting Names
13. Labels And Names Quick Reference
2. Absolute Referencing
1. Absolute And Relative Referencing
2. Problems With Relative Formulas
3. Tracing Precedents
4. Creating Absolute References
5. Creating Mixed References
6. Circular References
7. Absolute Referencing Quick Reference
3. Logical Functions
1. Logical Function Concepts
2. Displaying Information Using IF
3. Displaying Values Using IF
4. Nesting An IF Function
5. Using The AND Function
6. Using The OR Function
7. Using The NOT Function
8. Logical Functions Quick Reference
 

4. Lookup Functions
1. Requirements Of Lookup Functions
2. The CHOOSE Function
3. The ISERROR Function
4. The VLOOKUP Function
5. Testing Lookup Functions
6. Using VLOOKUP For Exact Matches
7. The Index Function
8. Lookup Functions Quick Reference

5. Nesting Functions Workshop
1. Scoping A Formula
2. Developing A Nested Function
3. Creating A Nested Function
4. Editing A Formula With Nested Functions
5. Copying A Formula With Nested Functions
6. Concatenation
7. Nesting Functions Workshop Quick Reference
6. AutoFilter
1. Applying & Using AutoFilter
2. Creating Compound Filters
3. Creating Custom Filters
4. Multiple Value Criteria
5. Using Wildcards In Custom Criteria
6. AutoFilter Quick Reference
7. Advanced Filters
1. Advanced Filter Concepts
2. Using An Advanced Filter
3. Extracting Records With Advanced Filter
4. Using Formulas In Criteria
5. Using Database Functions
6. Advanced Filters Quick Reference
8. Goal Seeking
1. Goal Seek Components
2. Using Goal Seek
9. Data Tables
1. Using A Simple What-If Model
2. Creating A One-Variable Table
3. Using One-Variable Data Tables
4. Creating A Two-Variable Data Table
5. Data Tables Quick Reference

10. Scenarios
1. Creating A Default Scenario
2. Creating Scenarios
3. Using Names In Scenarios
4. Displaying Scenarios
5. Creating A Scenario Summary Report
6. Merging Scenarios
7. Scenarios Quick Reference
11. Pivot Tables
1. PivotTable Theory
2. Creating A Simple PivotTable
3. Adding Row Fields To A PivotTable
4. Using The Page Field In A PivotTable
5. Filtering Row And Column Values
6. Formatting A PivotTable
7. Counting With PivotTables
8. PivotTable Summary And Display Options
9. Show Data As Percentages In PivotTables
10. Calculated Fields In PivotTables
11. Calculated Items In PivotTables
12. Creating A PivotChart
13. Modifying A PivotChart Via The PivotTable
14. PivotTables Quick Reference
12. Recorded Macros
1. Setting Macro Security Levels
2. Recording A Simple Macro
3. Running A Recorded Macro
4. Relative Cell References
5. Running A Macro With Relative References
6. Viewing A Macro Module
7. Modifying A Recorded Macro
8. Recorded Macros Quick Reference
13. Recorder Workshop
1. Preparing Data For An Application
2. Recording A Summation Macro