Learn Advanced Excel: Formulas, Functions, VBA Macros

Build a solid foundation in Microsoft Excel, mastering advanced formulas, pivot tables, data validation, and macros (VBA), then automate repetitive tasks and create sophisticated reports.

Learn to identify and highlight duplicates in Excel using conditional formatting, countif, and formula-based techniques for row and column data.

Learn how to create a pivot table in Excel, distinguish it from a table, and use its four components: filters, rows, columns, and values to summarize data and generate reports.

Learn to build an interactive Excel dashboard powered by pivot tables and charts, using slicers and timelines to filter by country and month for dynamic insights.

Learn how to build a Gantt chart in Microsoft Excel using workday formulas, calculate end dates and lengths, and customize charts to create a clear, interactive dashboard.

Learn to build an Excel dashboard template by creating shapes with gradient fills, adding text boxes, and integrating pivot tables and pivot charts to visualize income and spending data.

Create a dashboard template in Excel by building shapes, charts including a pie chart, a pivot table, aligning elements, adding a slicer, and formatting for consistency.

Explore advanced d functions in excel, including d min, d max, d sum, d average, d count, and d count a, plus the get formula for multi-criteria scenarios.

Explore how the xlookup function replaces vlookup and hlookup by supporting wildcards, multiple criteria, and exact or approximate matches, while handling multiple results and common issues.

Master how to create, customize, and analyze graphs and charts in Microsoft Excel, including recommended charts, pivot charts, trend lines, sparklines, and slicers for dynamic data visualization.

Learn to create dynamic drop-down lists in Excel, with dependent data validation that updates by name and uses VLOOKUP to fetch age, gender, and niche.

Master offset and match, xlookup with wildcards, and other advanced excel formulas to analyze data and compute revenues. Use data validation, filter, and sort to organize insights.

Build a fully automated data entry form in Excel using two sheets, headers, conditional formatting with icons, and developer tab controls to capture and count entries.

Develop a fully automated data entry form in Excel by building data validation lists, conditional formatting, and a macro-driven transfer to a database sheet, with data entry and submission controls.

Record and run macros in Excel using the Developer tab and relative references, save them to a workbook, and automate formatting, calculations, and find/replace tasks.

Create a Gantt chart in Excel by selecting data, building a bar chart, and adding start and end dates with no fill, to visually plan, schedule, and track project progress.

Learn how xlookup finds an exact match in a range or array and returns the corresponding value, enabling horizontal and vertical lookup with two criteria, beyond vlookup and hlookup.