Week 3 Introduction

Loading...
View Syllabus

Skills You'll Learn

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

Reviews

4.8 (4,666 ratings)
  • 5 stars
    83.41%
  • 4 stars
    14.10%
  • 3 stars
    1.97%
  • 2 stars
    0.32%
  • 1 star
    0.19%
UA

Jul 21, 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.

AJ

Sep 02, 2020

This full video courses provided by your university has helped me to increase my analytics skill to a whole new level. Thanks fr making this I'm sure it would many students like me in future.

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

    Excel Consultant
  • Placeholder

    Dr Prashan S. M. Karunaratne

    Lecturer - Teaching & Leadership | FHEA
  • Placeholder

    A/Professor Yvonne Breyer

    Director, Learning & Teaching| Head, Learning Futures

Explore our Catalog

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