Complete Excel Guide: Beginner to VBA Expert, Be Job Ready!

Open Excel from the start menu and choose a blank workbook or templates to begin. When closing, save with a name and location or choose don't save or cancel.

Learn to enter and edit data in an Excel worksheet, use autofill for series or repeated values, and master copy, paste, cut, navigation shortcuts, and cell addressing.

Explore cell formatting in Excel, applying font styles (bold, italic, underline), font color and background color, borders, and alignment, then use wrap text and merge options to control layout.

Learn cell formatting in Excel, including alignment, merge and center, text orientation, and number formats with Ctrl+1. Explore fonts, subscripts, and currency options such as rupees and dollars.

Discover the basic content types a cell can hold in Excel—text, numbers, boolean values, and errors—and how each type aligns differently, with a practical example of division by zero.

Learn how to use absolute cell reference in Excel by locking the total marks with a dollar sign to ensure correct percentage calculations when dragging formulas.

Enable speak cells from the quick access toolbar, add the command, and hear the table values read aloud in a horizontal flow, noting legacy options like pixels by rows.

Learn basic Excel formulas, including addition with sum, using cell references like B4 and B5, and ranges such as B4 to B7, plus subtraction, multiplication, and division.

Explore calculating shopping cart totals in excel using basic formulas, apply 5% tax, 2% discount, and correct bracket bodmas order to get the final price.

Explore the basics of Excel's common functions, including sum, average, max, min, count, and counta, with range selection and an if function example for pass/fail outcomes.

Explore practical Excel functions for a class of students, calculating total, average, max, min, and count, then use autofill and if to determine pass or fail.

Learn how to sort data in Excel using ascending and descending order for numbers and alphabets, and how sorting one column automatically rearranges related rows.

Sort data by color in Excel to enable advanced grouping of students by total marks, using cell color and font color options in the data tab.

Master multi column sorting in Excel by first sorting names from A to Z, then sorting sales from smallest to largest.

master basic data filtering in excel by using filters, shortcut ctrl+shift+l, and applying text, number, and date filters to view specific records, then clear filters and sort

Learn how to apply and manage filters in Excel using keyboard shortcuts and the data tab, including activating and clearing filters and copying filtered data to other tables or worksheets.

Master advanced data filtering in Excel using the Advanced Filter tool to apply multi-criteria ranges, copy results elsewhere, and filter by name or sales with comparison operators.

Apply data validation to restrict cell input to whole numbers, decimals, dates, times, or text length, with optional input messages, error alerts, and dropdown lists from a source.

Master advanced fill in Excel by using the fill handle to generate sequences, odd numbers, and custom lists. Learn how patterns are detected and how ctrl+d and ctrl+r speed fills.

Explore how to create and customize tables in Excel, including filtering, sorting, and table design options such as header row, total row, and banded styles.

Rename the table with a valid name, then resize the range to include or exclude columns using the table design. Remove duplicates across columns and convert table to a range.

Learn how pivot tables summarize data and stay flexible, update data as needed, and create them in Excel via insert, pivot chart, and an existing worksheet.

Learn how a pivot table acts as a flexible summary tool by arranging dates in rows, classes in columns, and calculating sum and average values with filters for terms.

Discover practical pivot table hacks by creating a pivot table from source data, viewing detailed records with a double click, and showing counts versus totals while managing totals and layout.

Explore pivot table hacks, including analyzing and designing pivot tables, applying banded rows and columns, customizing grand totals, and choosing report layouts and design colors.

Learn to customize pivot table results by changing value field settings to sum, count, max, mean, or average, and apply filters to summarize sales by region.

Learn to format pivot table values as currency in rupees using value field settings, and switch layouts between compact, outline, and tabular while showing or hiding subtotals.

Expand or collapse pivot table sections to show subtotals, remove plus-minus controls, and rename the sum of sales to total sales while reordering fields for region and name.

Learn essential Excel shortcuts from Ctrl+A to Ctrl+Z, enabling quick table selection, formatting, copying, pasting, filling, finding, replacing, hyperlinks, table creation, and undoing actions.

Navigate Excel with the alt keyboard shortcuts, access the data tab, A to Z sorts, manage filters, and jump to view or insert options without a mouse.

Master vlookup for vertical value lookup and exact matches, and learn how the leftmost column rule limits lookups with examples on price, availability, and brand data.

Learn to speed up vlookup by using data validation with a drop-down list, enabling exact-match lookups for items like mobile or laptop and avoiding manual typing.

Explore vlookup's approximate match, comparing exact vs approximate, and learn how range_lookup and ascending data affect results, including handling values outside the table and the need for numeric first column.

Use the VLOOKUP function for price lookups and fix errors caused by spaces with the trim function. The lesson demonstrates trimming lookup values and source data to return correct prices.

Identify why a price in a cell appears as text due to spaces and learn to convert it to a number by adding plus zero, resolving alignment issues.

Learn how to use hlookup for horizontal lookups with exact match in excel, compare it with vlookup, trim data to avoid errors, and fetch prices from a table.

Explore Excel's lookup function and its two formulas, replacing vlookup, to retrieve prices, brands, and incentives from a table using first and last column rules.

Explore the first lookup formula in Excel, using the lookup value, lookup vector, and result vector to retrieve full column data such as SKU, brand, and price.

Explore how the index function retrieves a cell value from an array or reference using row and column numbers in Excel. Learn to select data by specifying row and column.