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. 14 - Nested Formulas

    5. 15 - CountIF and CountIFs

    6. 16 - SumIF and SumIFs

    1. 17 - Advanced VLookUp

    2. 18 - IF and IS Error - Part 1

    3. 19 - IF and IS Error - Part 2

    4. 20 - Advanced Index Match

    5. 21 - Dates - Part 1

    6. 22 - Dates - Part 2

    7. 23 - Replace and Substitute - Part 1

    8. 24 - Replace and Substitute - Part 2

    1. 25 - Left, Right and Mid Function

    2. 26 - Search Function

    3. 27 - Concatenate and Search

    4. 28 - Indirect - Static

    5. 29 - Indirect - Dynamic

About this course

  • Free
  • 35 lessons
  • 0 hours of video content

Discover your potential, starting today

Enroll today