Learn advanced formulas, VLOOKUP, IF functions, data validation, database functions, formulas with dates, macros & more!
Course Outline:
Unit 1: Logical and statistical functions
- Topic A: Logical functions (IF, OR, AND, NOT, IFERROR)
- Topic B: Math and statistical functions (SUMIF, COUNTIF, AVERAGEIF, ROUND)
Unit 2: Financial and date functions
- Topic A: Financial functions (PMT)
- Topic B: Date and time functions (DATE, TODAY, YEAR, NOW, NETWORKDAYS)
- Topic C: Array formulas
- Topic D: Displaying and printing formulas
Unit 3: Lookups and data tables
- Topic A: Using lookup functions (VLOOKUP, HLOOKUP)
- Topic B: Using MATCH and INDEX
- Topic C: Creating data tables
Unit 4: Advanced data management
- Topic A: Validating cell entries
Unit 5: Exporting and importing
- Topic A: Exporting and importing text files
- Topic B: Exporting and importing XML data
- Topic C: Getting external data
Unit 6: Analytical tools
- Topic A: Goal Seek and Solver
- Topic B: The Analysis ToolPak
- Topic C: Scenarios
Unit 7: Macros and custom functions
- Topic A: Running and recording a macro
- Topic B: Working with VBA code