Excel 2010 Advanced

Chapter 1: ADVANCED CALCULATIONS (97 min)
1. Using Lookup Functions
2. Using Text Functions
3. Breaking Apart Text Entries
4. Using Date & Time Functions
5. Using the Net Workdays Function
6. Using Logical Functions & Fixing Errors
7. Using Text in Calculations
8. Using Financial Functions
9. Using the Cumulative Interest Payment Function
10. Using Aggregate vs. Math Functions

Chapter 2: SUBTOTALS & OUTLINES (25 min)
1. Creating Subtotals
2. Working with Outlined Data
3. Manually Creating Subtotals & Outlines
4. Creating Custom Views

Chapter 3: PIVOTTABLES© (57 min)
1. Constructing PivotTables
2. Modifying PivotTable Calculations
3. Setting PivotTable Properties
4. Using Filters & Slicers in the PivotTable
5. Using the Report Filter & Updating Data
6. Working with PivotTable Data in Formulas & PivotCharts

Chapter 4: ADAPTING CHARTS FOR COMPLEX DATA (19 min)
1. Adding a Secondary Chart Axis
2. Working with a Scatter Chart
3. Hidden & Empty Cell Settings, Formatting Error Bars
4. Adding a Trendline

Chapter 5: ADVANCED DATA TOOLS (44 min)
1. Importing Data & Adding Hyperlinks
2. Converting Text to Columns
3. Linking to Databases & Removing Duplicate Records
4. Consolidating Data
5. Validating & Protecting Data

Chapter 6: AUDITING CALCULATED VALUES (34 min)
1. Working with Circular References
2. Tracing Precedents & Dependents
3. Evaluating Formulas
4. Using the Watch Window
5. Error Checking

Chapter 7: PERFORMING A WHAT-IF ANALYSIS (28 min)
1. Finding an Input Value with Goal Seek
2. Displaying Options via Scenarios
3. Including Variable Values through Data Tables

Chapter 8: MACROS, VBA & SECURITY 60 min)
1. Macro Concepts
2. Creating a Basic Macro
3. Manipulating Cell & Range References
4. A Brief Introduction to VBA
5. Viewing & Editing VBA in Excel
6. Making Macros Accessible
7. Applying Security Settings
8. Credits