Analysing Data

Lesson 1-1: General Excel Tips
Lesson 1-2: CTRL, ALT Function Keys
Lesson 1-3: External Data
Lesson 1-4: Importing External Data in Excel
Lesson 1-5: Import Wizard
Lesson 1-6: Calculator
Lesson 1-7: Comparative Analysis
Lesson 1-8: Excel Databases
Lesson 1-9: Sorting Data
Lesson 1-10: Filtering Data
Lesson 1-11: Database Subtotals and Outlines
Lesson 1-12: Database Form
Lesson 1-13: Pivot Tables

Reporting with Excel

Lesson 2-1: General Reporting Tips
Lesson 2-2: Drop-Down Lists
Lesson 2-3: Conditional Formatting
Lesson 2-4: Hyperlinks
Lesson 2-5: Text Boxes
Lesson 2-6: Charts
Lesson 2-7: Camera and Dashboards

Functions and Formulas

Lesson 3-1: General Excel Tips Functions and Formulas
Lesson 3-2: Naming Fields
Lesson 3-3: Signs and Formulas
Lesson 3-4: Absolute and Relative References
Lesson 3-5: ISERROR Function
Lesson 3-6: SUBTOTAL Function
Lesson 3-7: SUMPRODUCT Function
Lesson 3-8: INDEX/MATCH Formulas
Lesson 3-9: Date & Time Functions and Formulas
Lesson 3-10: Financial Functions and Formulas
Lesson 3-11: Information Functions and Formulas
Lesson 3-12: Logical Functions and Formulas
Lesson 3-13: LookUp & Reference Functions and Formulas
Lesson 3-14: Math & Trig Functions and Formulas
Lesson 3-15: Statistical Functions and Formulas
Lesson 3-16: Text Functions and Formulas
Lesson 3-17: Array Formulas
Lesson 3-18: Obsolete Functions

Obsolete Functions

Lesson 18A: SUMIF Function
Lesson 18B: COUNTIF Function
Lesson 18C: HLOOKUP Function
Lesson 18D: LOOKUP Function
Lesson 18E: VLOOKUP Function

Appendix

App. A: Database Functions
App. B: Date & Time Functions
App. C: Engineering Functions
App. D: Financial Functions
App. E: Information Functions
App. F: Logical Functions
App. G: LookUp & Reference Functions
App. H: Math & Trig Functions
App. I: Statistical Functions
App. J: Text Functions