Microsoft Excel Masterclass: Beginner to Advanced Excel 2026

Learn data analytics fundamentals, including cleaning data and finding patterns. Apply descriptive, diagnostic, predictive, and prescriptive analyses to drive decisions with Excel, SQL, Python, Power BI, and TABI.

Explore data entry in Excel and learn auto fill, auto complete, and flash fill. See how to enter text, numbers, and dates and use the fill handle to pattern data.

Explore date and time formats in Excel, including short and long date formats, 12-hour and 24-hour time formats, and custom date-time formatting for precise calculations.

Master formulas in Excel with operators for add, subtract, multiply, divide, exponent, and concatenation, and learn that all formulas begin with = and use relative and absolute references.

Explore Excel functions by mastering predefined formulas, three function parts (equals sign, function name, arguments), and practical examples of sum, average, sumif, and sumifs across ranges and criteria.

Explains count, countif, countifs, and countA function in Excel for numerical data and blanks. Also covers wildcards such as asterisk, question mark symbol, and escapolators.

Explore Excel text functions left, right, mid, lower, upper, and proper, and learn how they extract substrings and help data cleaning, data preparation, and validation for analytics.

Explore Excel text functions such as find and search, including case sensitivity and wildcards, and the replace function for text modification. Preview substitute, trim, length, and concatenate with examples.

Explore the four text functions in Excel: trim, length, concat, and text; learn to trim spaces, concatenate text with ampersand, and format numbers as currency.

Explore logical functions in Excel, including if, and, and ifs, to test conditions and classify outcomes such as pass/fail and high/mid/low bonuses, and learn to handle errors with iferror.

Explore how to use VLOOKUP to perform vertical lookups in Excel by searching the first column, with syntax, arguments, and exact versus approximate matches, illustrated by employee data.

Master pivot tables in Excel to quickly summarize large data sets without formulas. Drag fields to group, sort, and calculate sums, averages, counts, and running totals for dynamic analysis.

Group data in pivot tables to create meaningful categories for easier reporting. Explore date grouping, number grouping, and manual grouping with practical examples.

Learn how to filter data in pivot tables using report, row label, value, and label filters, and enhance reports with slicers to create interactive dashboards and dynamic, readable analyses.

Power Query enables data transformation and cleaning in Excel, executing ETL—extract, transform, load—from various sources; it removes duplicates and loads clean data into Excel tables or dashboards with automatic refresh.

Extract data from sources and transform it in Power Query by removing duplicates to ensure accurate totals and dashboards; select columns, set data types, and apply steps for automatic refresh.

Identify and fix wrong data types in Power Query by converting text to numbers, dates, booleans, and percentages to ensure accurate calculations, sorting, filtering, and reporting.

Learn to merge two or more columns into a single column in Power Query, creating full names, addresses, and IDs with custom separators for reports.

Learn to append queries in Power Query to vertically combine data from multiple tables or files, creating a unified dataset for monthly sales, employee data, and reports.

Create a PyChart pie chart to show percentage contributions of categories as slices. Limit categories to 5–7, add percentage labels, and use clear category names for easy interpretation.