Data Analysis with Spreadsheet

Learn to use Excel's powerful lookup functions. This lesson covers the modern XLOOKUP, the classic VLOOKUP, and the situational HLOOKUP with practical business examples.

Learn how to enable and use Excel's powerful, built-in Data Analysis Toolpak to generate descriptive statistics, create histograms, and perform other advanced analyses.

Learn to use Excel's powerful decision-making tools: Goal Seek for working backwards, Scenario Manager for comparing futures, and the Solver add-in for complex optimization.