Learn everything about Analytics

Up and Running with Excel What-If Analysis – Lynda

Lynda
0-6 Month Online
Intermediate Contact Institute
Online Business Intelligence
Online Self Paced 811
DescriptionProgram StructureToolsContact

Make better decisions for your business by taking a deeper dive into your data with Microsoft Excel’s analysis tools. In this advanced course, you will learn how to analyze hypothetical business cases using formulas and variable data. You will also learn how to build data tables, define alternative data sets with scenarios, find target values with Goal Seek, and analyze complex problems with Solver.

Topics:

  • Creating a scenario
  • Defining data tables
  • Finding a target value with Goal Seek
  • Defining constraints and running Solver
  • Creating a configurable model
  • Manipulating your model
  • Running a Monte Carlo simulation

Fees: – INR 15, 00 (assuming $ = INR 60)

Duration:

1 hour 10 minutes

  • Excel
Name :
Email :
Contact Number :
Message :
Code :

 

This article is quite old and you might not get a prompt response from the author. We request you to post this comment on Analytics Vidhya's Discussion portal to get your queries resolved
%d bloggers like this:







Download Brochure
Join 250,000+ Data Scientists in our Community

Receive awesome tips, guides, infographics and become expert at:

Interact with thousands of data science professionals across the globe!




 P.S. We only publish awesome content. We will never share your information with anyone.

Subscribe!
%d bloggers like this:







Download Brochure
Join 250,000+ Data Scientists in our Community

Receive awesome tips, guides, infographics and become expert at:

Interact with thousands of data science professionals across the globe!




 P.S. We only publish awesome content. We will never share your information with anyone.

Subscribe!