The Complete Microsoft Excel Course: Beginner to Expert

Perform basic arithmetic operations in Excel, including addition, subtraction, multiplication, and division, using formulas, cell references, and iserror functions to handle errors.

Master relative, absolute, and mixed cell references in Excel to build smarter formulas and copy them accurately. Use F4 to cycle references and plan your references for dynamic, time-saving spreadsheets.

Explore Excel's logical functions: if, and, or, not, to build conditional formulas, label data as high or low, and combine criteria for dynamic, automated decisions.

Master essential text functions in Excel, including concatenate, len, upper, lower, and proper, to combine names, measure character length, and normalize capitalization for clean data and reports.

Master essential Excel date and time functions, including today, now, datedif, edate, and eomonth, to auto update dates, calculate date differences, and manage deadlines and subscriptions.

Explore essential Excel statistical functions, including average, sum, count, max, min, and round, to quickly summarize data ranges, compute totals, identify means, and reveal data extremes.

Sort and filter large Excel data sets by single or multi-column rules, organize sales and regions, and apply numeric filters and conditional formatting to highlight key figures.

Learn to use filter and unique functions in Excel to extract and identify data. Apply conditions, ranges, and simple combinations to obtain east region results and distinct values.

Learn to summarize large sales datasets with pivot tables and visualize insights using pivot charts. Build, customize, and refresh interactive reports by dragging fields, filtering regions, and formatting charts.

Master index, match, and exact in excel to perform dynamic lookups, case-sensitive comparisons, and error-free data management, including price lookups and product code validation.

Master Vlookup and Hlookup to quickly retrieve data in Excel, using vertical and horizontal lookups with exact or approximate matches, guided by table arrays and index numbers.

Learn how xlookup replaces vlookup and hlookup by searching ranges and returning values. Use horizontal and vertical lookup, optional not found messages, and configurable match and search modes.

Create a dynamic drop down list in Excel that updates automatically as you add items to the source data, using a named range, offset, counta, and data validation.

Create a dependent drop down list in Excel by naming city ranges per country and using indirect with data validation to link country selection to cities.

Apply conditional formatting to highlight cells, show icons, and text matches, and use data bars and color scales to visualize values, making data trends easier to interpret.

Learn to create four essential Excel charts, including line, bar, pie, and scatter plots, by organizing data in neat rows and using the insert tab for clean, insightful visuals.

Master how to customize Excel charts by adding a chart title, data labels, and trendlines to create polished, informative visualizations with clear titles, precise values, and trend insights.

Explore Power Query in Excel to import data from csv files, clean and transform it in the editor, and load a ready-to-analyze dataset.

Enable PowerPivot in Excel, load and model data from multiple sources, and create relationships to analyze data across tables using dd (data analysis expressions) to create calculated fields or measures.

Learn to automate Excel tasks with macro recording and VBA basics, from enabling the developer tab to writing simple VBA code and running macros.

Master financial analysis in Excel by organizing data into income statements, balance sheets, and cash flow, applying key formulas, charts, and pivot tables to reveal insights.

Master data validation and error handling in Excel by using drop-down lists to prevent typos, enforcing minimum and maximum values with custom rules, and delivering clear error messages.