Main Profile

At A Glance

Up and Running with Excel What-If Analysis

Make better decisions for your business by taking a deeper dive into your data with Microsoft Excel's analysis tools. In this advanced course, Curt Frye shows how to analyze hypothetical business cases using formulas and variable data. He'll show you how to build data tables, define alternative data sets with scenarios, find target values with Goal Seek, and analyze complex problems with Solver. The last two chapters show you how to create a configurable model with sliders and check boxes and...

Cost: $25 Per Month

Contact

Up and Running with Excel What-If Analysis's Full Profile

Overview

Description

Make better decisions for your business by taking a deeper dive into your data with Microsoft Excel's analysis tools. In this advanced course, Curt Frye shows how to analyze hypothetical business cases using formulas and variable data. He'll show you how to build data tables, define alternative data sets with scenarios, find target values with Goal Seek, and analyze complex problems with Solver. The last two chapters show you how to create a configurable model with sliders and check boxes and how to run a Monte Carlo simulation.

Details

  • Level of Difficulty: Beginner
  • Size: One-on-One
  • Cost: $25 Per Month
  • Institution: Lynda

Provider Overview

About Lynda: lynda.com is an online learning company that helps anyone learn software, design, and business skills to achieve their personal and professional goals. New courses and topics are added every week at no extra cost. They carefully select the world’s top experts who are the best in their field, passionate about their subject matter, and know how to teach.

Latest Tweet

Questions about Up and Running with Excel What-If Analysis

Want more info about Up and Running with Excel What-If Analysis? Get free advice from education experts and Noodle community members.

  • Answer