Microsoft Excel - From Beginner to Advanced 2026 Ready

Open Microsoft Excel from the start menu and create a blank workbook or use templates; learn to save, name, and locate files, or close without saving.

Select and customize templates in Excel to build a monthly budget, viewing income and expense graphs that update automatically as you modify figures.

Create, rename, delete, hide, unhide, and move or copy worksheets within a workbook. Use the plus icon, double-click to rename, and right-click to access options.

Learn to enter and edit data in Excel cells, use autofill for series or values, and copy, cut, and paste with shortcuts to manage cell addresses like A11 and E58.

Master cell formatting in Excel, applying font styles (bold, italic, underline), font color, background color, borders, and font size. Learn alignment, wrap text, and merge and center.

Learn advanced Excel cell formatting, including merge and center, text orientation, number and currency formatting with Ctrl+1, date formats, and font effects like bold, italic, underline, subscripts and superscripts.

Explore the basic characteristics of a cell’s content in Excel, including text, numbers, booleans, and errors, and how each type aligns differently (text left, numbers right, booleans and errors center).

Master relative cell references to calculate percentages in Excel using a simple equals formula and drag to fill. See how the first-cell formula is replicated across rows with relative references.

Master absolute cell references in Excel by locking the total marks cell with dollar signs to maintain correct percentages when formulas are copied.

Enable speak cells from the quick access toolbar to read table values aloud, and explore by rows and by enter options.

Master text to column in Excel by splitting data into separate first and last names and other fields, using delimited and fixed width options with spaces, commas, and ampersands.

Learn how to create basic formulas in Excel using sum for addition, cell references like B4 and B5, and ranges from B4 to B7, then perform subtraction, multiplication, and division.

Learn to calculate item totals in Excel using basic formulas, then apply 5% tax and 2% discount to determine the final bill.

Learn to use Excel's basic functions—sum, average, max, min, count, and counta—by selecting cell ranges and applying simple if logic for pass/fail scenarios.

Explore practical applications of common Excel functions—sum, average, max, min, count, counta, and if—using autofill to calculate totals, averages, and the minimums and maximums across English, science, and maths.

Master basic data sorting in Microsoft Excel, including ascending and descending order for numbers and a-to-z and z-to-a for text, with automatic row integrity.

Master advanced data sorting in Excel by color, using the data tab to sort by cell color or font color, and organize by total marks.

Learn how to perform multi column sorting in Excel, prioritizing the name column from A to Z and then sorting sales from smallest to largest to organize data efficiently.

Explore the basics of data filtering in Excel, including applying and clearing filters, using text, number, and date filters, and basic sorting to reveal targeted records.

Apply filters in Excel using keyboard shortcuts such as ctrl+shift+l or the data tab, view only matching records, and copy filtered results to another table or worksheet.

Explore Excel's advanced filter to query a source data table with a criteria range, copy results to another location, and apply conditions like name John or sales greater than 500.

Explore how to use data validation in Excel to restrict inputs to whole numbers, decimals, dates, times, text length, and dropdown lists, with input messages and error alerts.

Learn to use Excel's autofill to create a full fill series of months and weekdays, manage formatting versus data, and apply the fill weekdays option to exclude weekends.

Learn to use advanced fill in Excel to auto-complete sequences, custom lists, and months by dragging the fill handle; apply control d and control r to fill down or right.

Convert data into an Excel table via insert > table or Ctrl+D, then apply header row, total row, and banded options to enable filtering and sorting.

Explore advanced features of Excel tables, including renaming with valid names, resizing to include or exclude columns, removing duplicates, and converting a table to a range.

Use a slicer to filter a table in Excel. Insert the slicer from table design, pick the item column, view mobile, laptop, or HD, then delete the slicer to remove.

Explore creating and customizing a pivot table in Excel, organizing dates as rows and class as columns, using sums, averages, and term filters to flexibly analyze data.

Explore pivot table hacks to quickly see detailed sales data by region and product, double-click to reveal specifics, and adjust totals and views with ease.

Explore pivot table hacks in Excel, including using Analyze and Design tabs, applying banded rows and columns, customizing grand totals, and choosing report layouts and color designs.

Learn to summarize data with pivot tables in Excel, switch value fields from sum to count, apply filters, and analyze regional sales by Daniel across Asia, Europe, and the USA.

Format pivot table values as currency in rupees to display sales and cogs accurately, and adjust layouts between compact, outline, and tabular while managing subtotals.

Explore pivot table controls such as expanding and collapsing sections with plus minus, toggling field headers, renaming totals to total sales, and adjusting field order to change display.

Master Microsoft Excel shortcuts from Ctrl+A to Ctrl+Z, including select all, bold, copy, paste, fill down, flash fill, find, replace, and create tables.

Navigate the Excel ribbon with the Alt key to reach data, view, insert, and more. Learn quick actions like sorting A to Z and applying filters without a mouse.

Explore how the Vlookup function performs a vertical lookup in a table to fetch price and availability, using exact match (false) or approximate match (true) and the leftmost column limitation.

Using data validation with vlookup, this lecture shows creating a drop down list to select items like mobile or laptop, enabling exact match lookups and faster price updates.

Master VLOOKUP approximate match in Excel, exploring range_lookup behavior, and how ascending numeric leftmost data affects the closest larger value for incentives.

Learn how to fix vlookup errors by trimming spaces in lookup values and source data, ensuring exact matches and correct price retrieval from the second column.

Explore the trim function in Excel and how spaces affect data in vlookup scenarios. Learn to convert text to numbers by adding zero to ensure proper numeric handling.