Practice Video: Data Tables

Video placeholder
Loading...
View Syllabus

Skills You'll Learn

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

Reviews

4.8 (7,992 ratings)

  • 5 stars
    84.50%
  • 4 stars
    13.10%
  • 3 stars
    1.80%
  • 2 stars
    0.36%
  • 1 star
    0.22%

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

EK

Dec 17, 2020

Thank you, dear all Prashan, Nicky and Yvonne! The teaching course has been concise, clear and very user friendly!

I have enjoyed my learning of MS Excel Intermediate II with MacQuarie University.

From the lesson

Data Modelling

This module is all about data modelling. Learn to model different scenarios based on input, assumptions and/or outcomes. Also learn the use of functionalities like Goal Seek, Data Tables and the Scenario Manager to make your models more robust.

Taught By

  • Placeholder

    Nicky Bull

    Lecturer and Lead Content Designer

  • Placeholder

    Dr Prashan S. M. Karunaratne

    Senior Lecturer - Teaching & Leadership | SFHEA

  • Placeholder

    Professor Yvonne Breyer

    Deputy Dean, Education and Employability

Explore our Catalog

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