What-If Analysis Tools in Excel

About this course

**This course includes downloadable course instructor files and exercise files to work with and follow along.**Welcome to our course "What-If Analysis in Excel". This course will teach you essential Excel functions and tools to perform advanced analysis and make informed decisions. You'll discover how to use Goal Seek and the PMT Function to solve complex problems effectively and forecast financial scenarios. With the Scenario Manager, you'll learn to create and compare different data sets to understand their impact on outcomes. Additionally, you'll explore Data Tables, both one-variable and two-variable, enabling you to analyze multiple scenarios quickly and efficiently.By mastering these tools, you can enhance your analytical skills, make more informed decisions, and increase your efficiency in Excel. Whether you're a student, professional, or business owner, this course will empower you to excel in data analysis and problem-solving tasks.In this course, you will learn how to:Apply Goal Seek and PMT function for financial forecasting.Create and manage scenarios using Scenario Manager.Perform advanced analysis with one and two-variable Data Tables.Make informed decisions based on data analysis.This course includes:35 minutes of video tutorials7 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion