Week 3 Introduction

video-placeholder
Loading...
View Syllabus

Skills You'll Learn

Lookup Table, Microsoft Excel Vba, Data Validation, Microsoft Excel Macro

Reviews

4.8 (7,620 ratings)

  • 5 stars
    84.59%
  • 4 stars
    12.97%
  • 3 stars
    1.83%
  • 2 stars
    0.35%
  • 1 star
    0.23%

DM

Mar 7, 2019

Love this course....It taught me a lot. It was little more challenging but I passed it. I definitely need more practice at doing these formulas and equations. Thank You for offering this great course

UA

Jul 20, 2020

Practice Challenge of Week 6 is very difficult. It would be great if the team could add the step by step video on how to solve that challenge. It will be a big help for all the future learners.

From the lesson

Automating Lookups

How do you find information from different parts of a workbook? This module introduces you to functions like CHOOSE, VLOOKUP, INDEX, MATCH and other dynamic lookups to find and display data from several sources.

Taught By

  • Placeholder

    Nicky Bull

    Lecturer and Lead Content Designer

  • Placeholder

    Dr Prashan S. M. Karunaratne

    Senior Lecturer - Teaching & Leadership | FHEA

  • Placeholder

    Professor Yvonne Breyer

    Deputy Dean, Education and Employability

Explore our Catalog

Join for free and get personalized recommendations, updates and offers.