Microsoft Excel - Excel from Beginner to Advanced 2026

Learn to customize the Excel ribbon by creating tabs and groups, adding commands like fill color, shapes, and text to columns, and unhiding tabs for fast access.

Explore how to convert text to multiple columns in Excel using delimited (space, at symbol) and fixed-width methods, and discover a quick autofill shortcut with ctrl+e.

Use the speak cells data reading tool in Excel to read data aloud vertically or horizontally, and add it to the quick access toolbar for easy use.

Add, edit, delete, and copy comments in Excel using Shift+F2 and the review tab, show all comments, then customize background colors and print options via page layout.

Master applying and removing filters in Microsoft Excel with ctrl+shift+l, filter data by government and country (Mexico), and sort products and prices for quick analysis.

Explore how to use freeze panes and split screen in Excel to keep the top row and first column visible while scrolling, and compare data across panes.

Learn how to use Excel's autofill to create fill series with or without formatting, including fill only formatting and week days or weekends via the autofill options.

Master advanced fill series in Excel by creating intervals with two numbers, autopopulating months, weeks, and custom lists, and using CTRL shortcuts for fill across right, down, left, or up.

Master flash fill in excel to automatically generate data patterns by training the tool with examples, then press ctrl+e to fill series and join text.

Apply conditional formatting in Excel to highlight pass and fail in green and red, and use greater than, less than, and equals rules to color total marks.

Learn to create and manage hyperlinks in Excel to navigate between sheets, open files and web pages, and add update notes for salaries processed.

Learn how to set up header and footer in Excel, add page numbers, date, time, file path, and a logo, with different first page options and PDF export.

Learn to print in excel with Ctrl+P, choosing between active sheet, entire workbook, or a selection, and adjust margins, orientation, paper size, and set or clear the print area.

Learn to import live web data into Excel from Worldometer, map the correct table, load into an existing sheet, and enable auto refresh every minute when the workbook opens.

Import text data from a notepad into Excel with auto refresh, enabling updates to an existing worksheet every minute as the notepad changes.

Learn to import objects into Excel using create from file, with or without a link, display as icon, and manage file size while supporting text, PDF, and video formats.

Identify how Excel recognizes text, numbers, expressions, and formula errors in a cell, and how each type aligns—text left, numbers right, and true or false expressions centered.

Explore Excel cell references: relative, absolute, and mixed, using F4 toggling to lock rows or columns; learn how dragging formulas updates addresses.

Learn to set up custom views in excel, using the view tab to create boss and sales person views by hiding or revealing fields such as gross sale, profit, date.

Learn to encrypt a workbook with a password, protect the workbook, and protect individual sheets to restrict edits, then remove protection when needed.

Learn how to protect cells in Excel by unlocking specific cells and protecting the sheet with a password, so users can only enter data in designated unlocked cells.

Learn to compare two sheets in a single workbook in Excel by opening multiple windows, arranging them side by side, and using synchronize scrolling to compare data efficiently.

learn to compare sheets across multiple excel files by arranging windows in tiled, vertical, horizontal, or cascade layouts using the view tab.

Master inserting and deleting cells, rows, and columns, resizing with manual and autofit, and applying an autofit code to automatically adjust widths and heights in Excel.

Learn how to manage Excel sheets by inserting, deleting, renaming, hiding, unhiding, coloring, grouping, and moving or copying sheets for simultaneous formatting.

Master starting formulas in excel by always using the equals sign, identifying cell references, respecting PEMDAS, avoiding circular references, understanding data types, and using named ranges for easier formulas.

Learn to sum in Excel with the sum function, the equals sign, auto sum, and range notation (D3:D8, F8:I8), including multi-range and multi-sheet totals.

Learn how to use the sum if function in Excel to sum by a single condition, and use sum ifs for multiple conditions, managing range, criteria, and sum range.

Learn how Excel sumif and sumifs calculate totals with one or multiple conditions, including left-to-right and right-to-left criteria, using product, region, and month examples.

Master subtotal and aggregate in Excel to sum visible data with filters and compare it to sum. Understand data ranges like F5:F404 and how inputs affect results.

Learn to use the aggregate function to sum data while ignoring errors, compare it with sum and subtotal, and apply it with an array reference (F4:F404).

Master the sumproduct function in Excel to multiply cost per item by estimated or actual sales using array1 and array2 and sum the results into a grand total.

The sum square function in Excel returns the sum of squares of its arguments, using data1 as x and data2 as y, giving 125 and 650 for the examples.

Examine formulas—sum X2 M Y2, sum X2 P Y2, and sum X M Y2—for computing differences of squares, sums of squares, and squares of differences via completing square.

Learn to apply the DSUM (database sum) formula in Excel to pull total quantity and total sales by selecting the database, output field, and criteria with correctly named labels.

Learn how to use IMSUM and IMSUB for complex number calculations in Excel. See IMSUM add 13+2i and 1+7i, and IMSUB subtract them, illustrating complex number calculations with alpha-numeric inputs.

Master the Excel average formula to obtain the average of selected cells, using the range directly instead of sum and division, demonstrated with B4:B5 yielding 300.

Explore the difference between average and averagea in Excel. Learn how averagea treats text as zero and counts all range cells, while average uses only numeric inputs.

Compare average if and average ifs to compute averages under one or multiple conditions, using average range, criteria ranges, and practical examples with apples and north region.

Learn how to implement weighted average in Excel, using either the built-in formula or a VBA code solution, with a clear data and weights example.

Learn how to use count related formulas in Excel to count numbers, all non-empty cells, and blank cells using count, counta, and countblank.

Master countif and countifs in Excel to count with single or multiple criteria, such as age less than 30 and experience greater than 5, and report the results.

Explore logical functions and comparative operators in Excel, using equals to, not equals to, greater than, less than, and greater than or equals to and less than or equals to.

Learn how the Excel if function performs a single logical test, using its syntax to return a value if true or false, with text results like pass or fail.

Explore how to use Excel's if and and if or constructs to perform multiple logical tests, distinguishing all-subject pass criteria from at least one subject pass for student promotions.

Explore how the IFS formula handles multiple logical tests in Excel and compare it with nested IF. Learn when to use each to print multiple results for different score ranges.

Use the IFERROR function to trap and handle errors in a value 1 divided by value 2, returning the result or zero when the division isn't possible, protecting other formulas.

Explore how the switch function in Excel replaces nested ifs and ifs for multiple tests, by mapping a single input cell like A5 to grades A to E.

Master left, right, mid, and len functions to extract characters from text strings and measure their length in Excel, including starting positions and character counts.

Explore two Excel formulas Find and Search to locate a character's position in a cell. Find is case sensitive and requires exact match, while Search ignores case for any match.

Compare replace and substitute in Excel: replace uses a start position and character count, while substitute replaces text without specifying position.

Learn how to use excel's concat and concatenate formulas to join multiple text strings, insert spaces between items, and handle ranges.

Learn how to convert numbers and dates to text in Excel using the TEXT function, format as currency, date, time, and decimals, with practical keyboard shortcuts.

Convert text in Excel using the upper, lower, and proper formulas. Learn to select input and apply these formulas to transform data into uppercase, lowercase, or proper case.

Master the trim function in Excel to remove extra spaces from text. Apply the trim formula to clean up text like Hello world and Vedanta Academy, preventing double spaces.

Learn to add a VBA spell number function in Excel to convert numbers to words, with default dollars and optional currency and decimals.

Learn how to convert text to numbers in Excel using a text-to-number VBA code, add the macro via alt+f11, and apply spell number and text-to-number conversions for large values.