Practice Video: Modelling Functions: SUMPRODUCT

Loading...
View Syllabus

Skills You'll Learn

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

Reviews

4.8 (1,234 ratings)
  • 5 stars
    1,045 ratings
  • 4 stars
    168 ratings
  • 3 stars
    18 ratings
  • 2 stars
    1 ratings
  • 1 star
    2 ratings
GK

Aug 05, 2019

Excellent course, well structured and presented. To get the total benefit of this course, I would recommend completing all courses in the Excel Skills for Business Specialization.

CA

Apr 24, 2019

A rewarding experience because I have been able to learn very valuable information. It is an excellent course. It has helped me in the personal and professional field. Thank you.

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

  • Dr Yvonne Breyer

    Dr Yvonne Breyer

    Program Director, Design and Experience, Global MBA

Explore our Catalog

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