Lesson 1. Introduction to Excel formulas
  • The New Excel Learning Curve
  • 1.1. Basic mathematical formulas
  • 1.2. Formulas in the entire column
  • 1.3. Blocking the address of a formula
  • 1.4. Formulas in the table
  • 1.5. Defined names
  • 1.6. Keyboard shortcuts for working with cells and formulas
  • 1.7. Formula errors and problems
  • 1.8. Basic formulas - DIY exercise
Lesson 2. Sprint through Excel formulas
  • 2.1. Logical formulas
  • 2.2. IF, CONDITIONS, SWITCH (Excel 365)
  • 2.3. Date and time formulas
  • 2.4. Text formulas (Excel 365)