Microsoft Excel Crash Course 2026: Masterclass for Weekend

Learn to add numbers like a pro in Excel by using autosum, the sum function across ranges, and conditional sums with sumif.

Learn how to split data into first and last names in Excel using flash fill, autofill, and text-to-columns, with shortcuts like Ctrl+E to speed up data separation.

Learn to sort data from smallest to largest and filter to show only the needed values, using department and color filters for quick results.

Analyze data quickly in Excel by turning data into a table (Ctrl+T) and using the Quick analysis tool (Ctrl+Q) to create charts, data bars, and spark lines.

Explore Excel essential functions, including mathematical, logical, and date-time formulas, and learn how to apply lookups with match and index to real data in hands-on training.

Master basic formula operations in Excel by learning how to insert functions, use auto sum, and explore built-in categories like financial, logical, and text functions for real-world data tasks.

Learn to use counta, countif, mod, and round in Excel to analyze datasets like employee counts by gender and department, across data ranges.

Learn to apply and, or, and xor logical functions in Excel using practical team-tournament data to determine win status across multiple cells.

Learn how to use the VLOOKUP formula to map values across two tables, matching a leftmost key and returning a salary or related data with exact or approximate matches.

Learn how to use HLOOKUP for horizontal lookups in Excel, retrieving employee ID and salary from a master data table with exact and approximate matches.

Apply HLOOKUP with MATCH formula to pull employee id data, including name, department, and salary, using exact match and absolute references across multiple rows.

Learn to use index + match in excel to retrieve salary data from a master table by matching employee id, an alternative to vlookup.

Explore how Excel's Xlookup works with functions and formulas, handle not exact matches, exact and approximate matches, and wildcard searches to improve data retrieval and analysis in charts and reports.

Learn to use the xlookup function in excel to fetch country dialing codes from a data table by specifying the lookup value, lookup array, and return array.

Learn how to handle #N/A errors in XLOOKUP and use approximate matches to map scores to grades, including exact, next smaller, and next larger values.

Learn how to use wildcard characters with xlookup to match data across source and destination arrays, handling not found cases and dynamic criteria.

Master flash fill in excel to quickly extract digits, text, and names using left, right, and middle operations, automate with ctrl+e, and concatenate names.

Master removing duplicates in Excel with data tools, headers, and column selections, then use advanced filter and conditional formatting to isolate or copy unique records.

Learn how to enforce clean data in Excel by applying data validation rules to cells, setting criteria, messages, and error alerts for numbers, text, dates, and more.

Learn how to import data from a CSV into Excel by selecting comma as the delimiter, loading the data as a regular table, and organizing columns and dates.

Learn how to create pivot tables, adjust value field settings, and format numbers with decimals using the pivot table design wizard.

Create a pivot table from clean source data to summarize sales by region and name, using rows, columns, and values, with drag-and-drop of fields and refresh when the data changes.

Learn to configure value field settings in pivot tables to summarize data with count, average, max, min, and standard deviation, and to customize totals and number formats.

Master pivot table design by beautifying data with subtotals, grand totals, and header styling, and choose from layouts and table designs to present data clearly for beginners.

Practice this Excel exercise to understand pivot table preparation and how to enable quarters in the pivot output, then cross-check your solution with the provided one.

Master pivot table techniques by enabling quarters, dragging fields, and generating subtotals for a complete analytical report in Excel.

Explore Excel chart categories, including column, bar, line, pie and donut charts, plus advanced types like sunburst, histogram, scatter, waterfall, stock, and map charts, accessed via insert charts.

Learn to create charts in Excel by selecting data, inserting a chart, choosing 2D or 3D column and bar types, and customizing titles and chart design options.

Learn to create column or bar charts in Excel by selecting data, inserting charts, applying 3D designs, switching rows and columns, and adding a chart title.

Learn to create line charts in Excel by selecting data, inserting a line chart, and customizing the year-wise data range (98 to 2028) with design options and borders.

Master area charts in excel by selecting data, inserting a 3d area chart, and adjusting the plot area to automatically populate years with real-time data.

Learn to create pie and donut charts in Excel by selecting data, inserting pie or donut charts, and adjusting data ranges, slice separation, and chart elements like data labels.

Learn to create and customize area and XY charts in Excel, format axes and plot areas, adjust data series, apply fills, borders, shadows, and number formats for clear, polished charts.