0. Getting started
  • 1. Welcome
  • 2-Downloading the course files
1. Excel Formula Essentials
  • 1. Anatomy of an Excel Formula
  • 2. Understanding Relative References
  • 3. Using Absolute References
  • 4. Mixed References
  • 5. Operator Precedence
  • 6. Using Named Ranges
2. Text functions
  • 1. Flash Fill Revision
  • 2. Using The TRIM Function
  • 3. Changing The Case Of Text
  • 4. The LEFT And RIGHT Functions
  • 5. The MID Function
  • 6. The CONCATENATE Function
3. Conditional functions
  • 1. Using the IF Function
  • 2. Using the IFERROR Function
  • 3. Using Nested IF Statements
  • 4. Using the OR Function
  • 5. Using the AND Function
4. Conditional number crunching functions
  • 1. Using the COUNTIF Function
  • 2. Using the SUMIF Function
5. Lookup functions
  • 1. Using VLOOKUP Exact Match
  • 2. Using VLOOKUP Approximate Match
  • 3. Using INDEX and MATCH
6. Project - Creating an invoice template
  • 01-Overview of the final project
  • 2. Creating basic formulas
  • 3. Creating a drop-down list
  • 4. Using VLOOKUP and concatenation
  • 5. Using CHAR to insert line breaks
  • 6. Using IF to suppress blank address lines
  • 7. Protecting the worksheet
  • 8. Saving the model as a template