Excel 365 in 30 Minutes – Data Analysis (Advanced 6 of 11)

In this Bigger Brains course, you’ll explore advanced data analysis features in Excel 365 that help you quickly turn raw data into actionable insight. You’ll learn how to create forecast sheets from historical data, adjust forecasting options, and evaluate future trends. You’ll see how scenario tools allow you to compare multiple outcomes using the same dataset, edit and merge scenarios across worksheets, and generate clear summary reports to support data-driven decisions. 

You’ll also learn how to use Excel’s advanced add-ins designed for deeper analysis and optimization. You’ll explore the Solver add-in to model complex problems, apply multiple constraints, and evaluate optimal solutions. You’ll also explore the Data Analysis ToolPak and apply core statistical tools, including descriptive statistics and sampling. Designed for advanced Excel 365 users, this fast-paced course shows you how to apply powerful analysis tools with confidence and efficiency. 

Topics covered include: 

• Creating a forecast sheet using historical data 

• Changing forecast options 

• Creating multiple scenarios for the same dataset 

• Editing a scenario 

• Creating a scenario summary report 

• Merging scenarios from multiple sheets 

• Adding the Solver Add in 

• Adding multiple constraints to obtain a Solver solution 

• Creating reports and scenarios from Solver solutions 

• Adding the Data Analysis ToolPak 

• Reviewing different analysis tools 

• Using the descriptive statistics, rank and percentile, and sampling tools 

Enjoy award winning HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style! Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives and include captions and transcripts, downloadable handouts, and optional LinkedIn digital badges on course completion.