Course curriculum

  1. 01
  2. 02
    • Excel Must-Know Formulas and Functions - 1 - Building basic math formulas

    • Excel Must-Know Formulas and Functions - 2 - Autosum and Relative references

    • Excel Must-Know Formulas and Functions - 3 - Absolute references

    • Excel Must-Know Formulas and Functions - 4 - Named Ranges

    • Excel Must-Know Formulas and Functions - 5 - Linking sheets and workbooks

    • Excel Must-Know Formulas and Functions - 6 - If, And, Or, and the nested If functions

    • Excel Must-Know Formulas and Functions - 7 - Countif, Sumif, Averageif, Sumifs, and Countifs functions

    • Excel Must-Know Formulas and Functions - 8 - Vlookup and Hlookup functions

    • Excel Must-Know Formulas and Functions - 9 - Match and Index functions

    • Excel Must-Know Formulas and Functions - 10 - Date and time formulas and functions

    • Excel Must-Know Formulas and Functions - 11 - Text functions

    • Excel Must-Know Formulas and Functions - 12 - Tracing formulas

  3. 03
    • Excel Must-Know Formulas and Functions

  4. 04
    • Sample Excel File