The Complete Microsoft Excel Course: Master All Levels

Learn to enter and format text and numbers, manage dates as serials, and build basic conditional formulas in Excel, including sum, average, max, and if.

Master auto fill and flash fill in Excel to automatically fill data and recognize patterns, from numbers and dates to custom lists and data transformations.

Master alignments, font styles, and borders in Excel to improve readability and create professional, clearly formatted spreadsheets.

Master conditional formatting to highlight cells in Excel with rules such as greater than 5000 and below the target, using colors and formulas for clearer data analysis.

Master inserting, deleting, and resizing rows and columns in Excel using right-click, the home tab ribbon, and keyboard shortcuts, with tips on auto fit and undo safety.

Master freezing panes and splitting windows in Excel to keep headers visible and compare data across sections while working with large spreadsheets.

Learn to write simple Excel formulas using the equals sign to perform additions, subtractions, multiplications, and divisions with cell references for dynamic results.

Master relative, absolute, and mixed cell references in Excel to control formulas. Learn to drag formulas, lock values with dollar signs, and use F4 for quick switching.

Master four essential Excel functions, sum, average, min, and max, to analyze data in a range, calculate totals, mean values, and identify minimum and maximum values.

Explore count, counta, and countif to analyze data in Excel, counting numbers, non-empty cells, and conditional data such as values greater than 200 or specific text like apples.

Master Excel decision logic with if, and, or to evaluate conditions, combine criteria, and automate pass/fail decisions for data analysis and streamlined workflows.

Master nested if statements in Excel to evaluate multiple conditions, assign grades from scores, and improve formulas with IFS or helper columns.

Master today, now, and datedif to automate date calculations in Excel dashboards. Use these dynamic functions to track deadlines, calculate ages, timestamps, and time-sensitive data.

Learn to create and format tables in Excel, apply styles, rename headers, adjust column widths, and use sorting, filtering, and a total row, with automatic expansion and convert-to-range options.

Master sorting and filtering in Excel to organize large data sets by regions and sales amount, using the data tab, A to Z, and filters such as greater than 1300.

Explore vlookup, hlookup, and xlookup, powerful Excel lookup functions that search vertical or horizontal data, utilize exact or approximate matches, and handle not found messages.

Learn to use index and match in Excel for dynamic lookups that go beyond Vlookup. Use them to retrieve employee salaries and product prices with flexible row and column searches.

Learn to combine text from multiple cells with concatenate and text join, using delimiters and ignoring empty cells to create clean full names.

Master left, right, mid, len, and find functions in Excel to extract text, measure length, and locate positions.

Identify and fix common Excel formula errors, such as value, reference, division, name, and null errors, by correcting data types, references, and separators.

Create and customize pivot tables in Excel to summarize and visualize data. Arrange fields in rows, columns, values, and filters; apply currency formatting and use pivot charts and slicers.

Group and collapse data in Excel to create high-level views, then apply filters to display only the records you need.

Explore calculated fields and items in pivot tables to build custom profit calculations from revenue and cost without altering data, and learn pitfalls and best practices for performance.

Explore interactive data filtering in Excel using built-in filters, slicers, data validations, and pivot tables to dynamically filter and visualize sales data.

Restrict input types in Excel with dropdown lists to keep data clean and accurate. Build dynamic lists using named ranges and data validations, with input messages and error alerts.

Master sumproduct, sumifs, and countifs to analyze data with multiple conditions, calculate revenue, and create dynamic filters for financial reports and a dashboard.

Explore dynamic arrays in Excel and learn how filter, sort, and unique spill results to automate data processing. Combine these tools to extract, order, and deduplicate data.

Learn to import and transform data in Excel using CSV, text, workbook, and web sources, preview and adjust delimiters, load into workbooks, and refine with the Power Query editor.

Master Power Query to merge and append queries in Excel, using Get Data from tables or ranges, matching columns, selecting joins, and loading results into a single table.

Record and run macros in Excel to automate repetitive tasks, format tables, and improve workflows by enabling the developer tab and storing macros in the workbook.

learn to edit excel macros using visual basic for applications, enable the developer tab, edit macro code, specify range and colors, and run macros with f5.

Learn essential keyboard shortcuts and productivity hacks in Excel, from copy-paste, paste specials, undo/redo, navigation, formatting, filters, data swapping, table creation, and pivot table insertion.