Duration: 2 days

Course Content:
  • Functions Intro

    • Absolute and Relative Referencing
    • Error types
  • Functions – Conditional Calculation, Lookup

    • SUMIFS, COUNTIFS
    • VLOOKUP
  • Functions – Logical

    • IF, Nested IF
  • Functions – Text, Date

    • Text Operations, Text to Columns, Flash Fill
    • Date Calculations
  • Working with Large Tables

    • Sorting & Filtering Data
    • SUBTOTAL Function
  • Working with Templates

    • Creating & Saving Templates
    • Creating data validation
    • Protecting your worksheets & workbooks
  • Reporting

    • Conditional Formatting
    • Pivot Tables