Microsoft Excel Basic to Advanced: Ultimate Excel Mastery

Explore date and time functions in Excel to compute differences between dates, extract parts of dates and times, format values, and use today, now, and network days for data analysis.

Explore pivot tables and pivot charts to dynamically summarize data, visualize totals, and interact with slicers, filters, and grand totals in pivot charts.

Explore how Excel enables basic data analysis through sorting, filtering, and calculating metrics on a sales dataset. Create a table, then generate charts to reveal insights and support decision making.

Explore VLOOKUP, LOOKUP, and XLOOKUP to quickly retrieve data from large spreadsheets by IDs, names, or salary amounts, using vertical and horizontal lookups and exact matches.

Learn advanced lookup and reference functions in Excel using INDEX and MATCH as flexible alternatives to VLOOKUP. Apply them to an employee salary dataset to retrieve salaries and identify positions.

Explore array formulas and dynamic arrays in Excel to perform multi value calculations, compute totals and averages, and use unique to extract names.

Discover how to clean, format, and extract insights from text data in Excel using text functions like left, right, mid, length, and concat on a sample employee dataset.

Explore advanced conditional formatting in Excel using color scales, data bars, and icon sets to visualize sales data, highlight trends and top performers in a simple dataset.

Create and customize charts in Excel using column, line, and pie charts. Improve readability and insight by applying chart elements like data labels, axis titles, legends, and styles.

Demonstrate how to create sparklines in Excel to visualize data trends within cells, using line, column, and win-loss sparklines, with customization and quick trend analysis.

Build interactive dashboards in Microsoft Excel to dynamically visualize sales and profit by month, with charts and slicers for region and month.

Explore advanced data visualization techniques in Excel, creating waterfall charts, combo charts, map charts, and sparklines to tell a data-driven sales story across months and regions.

Learn how to automate Excel tasks with VBA by creating macros, writing simple code, and using the Visual Basic editor, including enabling the developer tab and summing data ranges.

Record and run basic macros in Excel to automate repetitive tasks, using the developer tab, macro names, and shortcut keys to apply formatting to new data sets.

Learn to use Excel's solver to minimize total cost under constraints, like at least 40 units produced and nonnegative production, with steps to enable and run the solver.

Explore how what-if analysis in Excel uses Goal Seek and Scenario Manager to forecast, budget, and make data-driven decisions by testing different inputs and outcomes.