Course curriculum

    1. 1 - Excel Advanced Introduction

    2. 2 - Advanced Shortcut Keys

    1. 3 - Tracing Precedents

    2. 4 - Tracing Dependants

    3. 5 - Watch Window

    4. 6 - Show Formulas

    1. 7 - Protecting Cells in a Worksheet

    2. 8 - Protecting the Workbook Structure

    3. 9 - Encryption with Passwords

    1. 10 - Name Ranges

    2. 11 - Simple IF Function

    3. 12 - IF, AND

    4. 13 - Nested Formulas

    5. 14 - CountIF and CountIFs

    6. 15 - SumIF and SumIFs

    1. 16 - Advanced VLookUp

    2. 17 - IF and IS Error - Part 1

    3. 18 - IF and IS Error - Part 2

    4. 19 - Advanced Index Match

    5. 20 - Dates - Part 1

    6. 21 - Dates - Part 2

    7. 22 - Replace and Substitute - Part 1

    8. 23 - Replace and Substitute - Part 2

    1. 24 - Left, Right and Mid Function

    2. 25 - Search Function

    3. 26 - Concatenate and Search

    4. 27 - Indirect - Static

    5. 28 - Indirect - Dynamic

About this course

  • $8.00
  • 35 lessons
  • 2.5 hours of video content