Advanced Features of Microsoft Excel (Digital Learning Experience)

Name: Advanced Features of Microsoft Excel (Digital Learning Experience) (English version)
SKU: W33318

Kyle Maclean, Tiffany Bayley, Lauren Cipriano, Gregory Zaric, John Lyons

Product #:W33318

Supplier:Ivey

Discipline:Management Science

Details:Digital Learning Experience (Virtual) • 230 min • 2023-02-28

Subjects:

Analytics and data science Data science

Your Price:

$16.95

Purchase this material with a free Educator Account and enjoy more benefits:

Free Educator Copy
Free Teaching Notes
Build your coursepack
Discounted academic price

The purpose of this Digital Learning Experience (DLE) is to focus on interpreting quantitative models, and using built-in Excel tools in order to do so. Specifically, it will cover “What-If” analysis tools, some common functions in descriptive statistics, and building a histogram to explore data visually.

Learning Objectives

After working through this Digital Learning Experience, participants should be able to:

Calculate break-even or target scenarios using the Goal Seek tool.
Use Data Tables to construct sensitivity analyses for quantitative models.
Apply built-in Excel functions to summarize data statistically.
Build a histogram to understand the distribution of your data.

Step by step screenshots of Excel tools and methods. Videos explaining and walking through key features.