Advanced Formulas

In this lesson, you will learn about advanced formulas.

Contact Us or call 1-877-932-8228
Lesson Goals
  • Learn about naming and labeling cells and ranges of cells.
  • Use names and labels in formulas.
  • Create formulas that span multiple worksheets.
  • Use the conditional IF function and its variants in formulas.
  • Use the PMT function to calculate payments for loans.
  • Use the VLOOKUP function.
  • Use the HLOOKUP function.
  • Use the CONCATENATE function to join the contents of numerous cells.
  • Use the PROPER, UPPER, and LOWER functions to alter the casing of text.
  • Use the LEFT, RIGHT, and MID functions to return characters from the start or end of a string, or a specific number of text characters.
  • Use various date functions.