Create a new Excel file, name it, and save it to desktop or OneDrive, then explore the title bar and the ribbon's show tabs and commands feature.

Explore how to customize the ribbon and quick access toolbar in Excel, including adding a new group, launching dialog boxes, and managing commands across tabs.

Master cell properties, selection, moving, and autofill, then format data with alignment, borders, colors, fonts, and text options to create well-structured, print-ready spreadsheets.

Master autofill in Excel by distinguishing copy vs fill series, forming numeric, date, and weekday sequences, while controlling formatting, direction, and stop and step values.

Explore how Flash Fill in Excel automatically completes data patterns—extracting names, formatting phone numbers, and concatenating fields—with typing cues, and applying or undoing changes via Enter, Ctrl, or accept options.

Explore cell reference types—relative, absolute (constant), and mixed—and see how autofill and dragging affect row and column changes, with F4 toggling absolute references.

Learn to use Excel operators and the Bodmas rule to build formulas, calculate with brackets, power, division, and multiplication, and apply relative cell references and cross multiplication for weighted scores.

Learn how to use math functions like sum, average, count, max, min, large, small, count blank, and subtotal, with ranges, arguments, and filters.

Master advanced excel functions such as sumif, averageif, and countifs, using criteria ranges and wildcards to count patterns like Yahoo IDs in data.

Learn to use the database function with database, field, and criteria ranges to compute sum, average, count, max, and min based on city and region.

Master the subtotal function in Excel to dynamically compute sum, average, count, max, and min. Learn to apply it with filters to update totals on the dashboard.

Master excel text functions, including uppercase, lowercase, and proper case, plus trim to remove extra spaces. Discover nesting and combining functions with cell references for data cleaning and formatting.

Explore left function, right function, and find function to extract characters from text and identify position, with examples like hyphen and name lengths.

Learn to use the text find function to extract names and mobile numbers and to determine name character counts, while locating city starts using in and spaces under case sensitivity.

Learn to extract names and mobile numbers in MS Office Excel using left, right, and find functions with nesting, handling character counts and delimiters.

Learn to extract a mobile number with the mid function in Excel by identifying starting position from a hyphen, using find to locate it, and specifying the number of characters.

Discover how the concatenate function joins text with literals, cell references, and function outputs, including examples like adding prefixes and spaces to phone numbers using the left function.

Format a ten-digit phone number as 3-4-3 using the concatenate function with left, mid, and right, inserting hyphens between segments.

This lecture introduces Excel's concat and textjoin functions, contrasting them with concatenate. It shows using a delimiter and ignoring empty cells to join ranges with spaces or commas.

Learn to use the replace function and replace tool, including replace all and replace only, with find and starting position, and masking last five digits of mobile numbers with x.

Apply the replace function in Excel to alter the last five digits of a mobile number by locating the hyphen, reaching the sixth position, and replacing five characters.

Learn how to use the substitute function to replace text by matching text rather than position, with optional instance numbers and examples of replacing all occurrences.

Master two MS Office text functions: repeat and length. Use examples to repeat text and count characters, tackle a task counting how many times the letter a appears in sentences.

Count how many times a character appears in a sentence by removing it with substitute and comparing lengths using the length function.

Learn how the numbervalue function converts text numbers into numeric values in excel, using the right function to extract digits and handle apostrophe-prefixed text for calculations.

Learn to use Excel's text to column to split a single column into multiple columns, with delimited or fixed width options and custom separators.

Protect the workbook at the structural level in Excel to prevent sheet changes like insert, delete, or rename, while still allowing edits; password protect and unprotect via the review tab.

Protect a sheet with a password, allowing only specific actions like selecting or formatting cells. Use allow edit ranges to permit changes in designated cells.

Learn to protect a sheet, hide formulas by marking cells as hidden, and manage locked versus unlocked cells so users can select only allowed cells.

Encrypt your Excel file with a password via file, info, protect workbook, encrypt with password, then save; opening requires the correct, case-sensitive password, which cannot be recovered if forgotten.

Master the if function and logical test in spreadsheets, using four operators (>, <, =, ≠) to evaluate scores and return pass or fail.

Master nested if functions in Excel to handle multiple conditions and score ranges, such as below 40 fail, 40–60 compartment, and above 60 pass.

Learn to use Excel's if function with max and min to identify topper and lowest scores, apply absolute references, and nest if statements to assign fail, compartment, or pass.

Use advanced if function to calculate bonuses from sales, applying profit thresholds: 12% under 10,000, 25% for 10,000-25,000, 32% for 25,000-40,000, and 45% above 40,000.

Master the nested if function in Excel to compute bonuses from profit and sales, applying thresholds at 10k, 25k, 40k and using round to control decimals.

Learn how to use the IFS function in Excel to evaluate multiple logical conditions, replacing nested ifs, with grade ranges such as less than 40, 40–60, and above 60.

Explore how the and and or functions evaluate multiple conditions in Excel, using pass/fail scoring example with unit test, final exam, and the if function to return pass or fail.

Understand the exclusive or (xor) function and its difference from and/or, showing how xor outputs true when exactly one condition is met in exam score scenarios.

Master pivot tables in Excel by turning raw data into reports using field lists, filters, rows, columns, and values, with sorting, grouping, and slicers for dynamic analysis.

Learn to use the getpivotdata function to retrieve specific values from a pivot table, and build data validation lists with client and item drop-downs for dynamic results of number sold.

Master Goalseek in what-if analysis to set a formula cell to a target value by changing a non-formula cell, with examples on profit, sales, cost, and EMI calculations using PMT.

Activate the solver add-in, set objective to 5000, adjust loan amount, loan year, and rate with constraints to achieve EMI 5000.

Explore scenario manager in what-if analysis to set high, low, and average cost scenarios, save changing cells, and merge and summarize results across sheets for quick decision-making.

Learn to use the pmt function to compute emi for loans with reducing interest, by inputting rate, nper, pv, and repayment mode to get emi and totals.

Create a data table in Excel to analyze loan scenarios by year, using the PMT function to compute EMI, total interest, and total amount.

understand the duration function in MS Office and its compounding growth. Calculate years to reach a goal using investment amount, rate, and goal.

Explore the Excel page layout and print options, including print preview with Ctrl P, margins, orientation, paper size, and print area.

Master how to print in Excel by configuring print titles, repeating rows, and custom headers and footers, including patterns, page numbers, and even-odd and first-page options.

Enable the draw tab in Excel (2016 onward) via file options. Use the pen with adjustable thickness and color to draw, erase, select, and convert drawings into shapes.

Master how to create and customize charts in Excel, using data selection, recommended charts, chart types, axes, legends, titles, data labels, and gridlines.

Master the chart design in Excel by using chart elements, quick layouts, color schemes, and chart styles. Then switch row/column, adjust data, and format individual chart parts.

Create a secondary axis and convert the cost series to a line to compare costs with sales in Noida and Delhi. Learn to format data series and change chart types.

Learn to customize chart legends in MS Office by editing series names, changing data sources, reordering, hiding, or removing entries, and updating axis labels using cell text or manual input.

Learn to create and customize Excel pie charts from single-series data, including 2D/3D formats, pie of pie and bar of pie, data labels, legend, titles, and value or percentage splits.

Explore Power Map in Excel to create 2D and 3D maps from sales data, visualizing by country, states, and districts, including India.

Explore quick analysis and chart recommendations in Excel, as selecting data prompts recommended chart options (cluster, scatter, line), with totals or averages and insert options for visualization.

Master the Excel filter tool to extract data by qualification, location, and email using text and number filters, advanced options, and multi-condition criteria.

Learn to apply date filter and color filter on a DOB column, using equals, before, after, and between options, month/quarter filters, and color filtering (yellow).

Explore the advanced filter option to copy filtered data to another location using list and criteria ranges, with examples for qualification, location, date of birth, and sales data.

Learn how to sort data in Excel, including A–Z and numeric sorts, and apply custom sort with a custom list to enforce a specific order while keeping related columns aligned.

Master grouping and ungrouping in Excel, create multi-level groups, apply subtotals by city or region, and use sorting to organize data for clear totals.

Apply conditional formatting to color schemes for value-based data, quickly identifying good versus poor performers with green and red highlights, and learn how to set rules in the home tab.

Master conditional formatting in Excel with rules for greater than, less than, between, equal to; text and date conditions, duplicates, top-bottom values, averages, data bars, color scales, and icon sets.

Learn to manage conditional formatting rules in Excel, including deleting individual rules, editing icon sets and data bars, and choosing thresholds by percent, number, or percentile.

Master data validation by configuring input messages, criteria, and alerts to guide users without altering data, including errors and warnings for first name and full name.

Learn to apply data validation in Excel to enforce input rules, including input messages, error alerts, name length, gender and qualification lists, and custom formulas for scores and scholarships.

Explore the define name feature in Excel, naming ranges or cells with the name box or name manager, set scope to workbook or sheet, and use in formulas and navigation.

Explore how the indirect function returns the value of a referenced cell, such as D3, and observe array behavior using the top named range with ctrl shift enter.

Create a dynamic dependent drop down list in Excel using data validation, named ranges, and indirect to display department-specific employee names.

Explore how to create and use hyperlinks in Excel to navigate between sheets, link to ranges by name, external websites, email addresses, and create new files.

Explore how the Vlookup function retrieves a name's contact number from master data in vertically organized tables, using exact match, table array selection, and column index.

Learn how to use iferror with vlookup to handle hash errors and display custom messages like no match found, then extend it to multiple master data.

Learn to apply the array Vlookup function to retrieve multiple columns in one go, using curly brackets for column indices and Ctrl+Shift+Enter, with optional iferror for no match.

Learn how to use the hlookup function to retrieve data from horizontally oriented tables, and how to align horizontal and vertical data using transpose, with a practical name-to-contact lookup example.

Use the match function to locate a name in master data and return its row; then combine index with match to fetch a value from a table.

Learn how to use nested match and index to pull a contact name from master data by locating a phone number with match and returning the corresponding name with index.

Learn to use vlookup with approximate match to categorize scores into grade ranges, using a table array, absolute references, and a column index of 2 with range_lookup true.

Learn a time-saving lookup and reference trick by using the match function to dynamically determine the column index for VLOOKUP, with absolute references to ensure correct dragging across many columns.

Learn to use the offset function in Excel to build dynamic reports by selecting a reference, rows, columns, height, and width, and aggregate with sum, count, or average.

Learn to enter dates and times in Excel by checking system date formats, avoiding US vs Indian formats, and using month names or Jan typing; adjust regional settings as needed.

Master date and time formats with custom placeholders like d, dd, ddd, dddd for days, m, mm, MMM, MMMM for months, and H, h, m, s with am/pm.

Master date and time functions in MS Office, extracting day, month, year, building dates with the date function, and using now, today, hour, minute, and second in 24-hour format.

Use the networkdays function to count working days between two dates, with optional holidays and weekend settings; the networkdays.intl variant lets you customize weekends.

Learn how to automate Excel tasks by recording macros with VBA, using the developer tab and relative references, and saving as a macro-enabled workbook.

Master macro recording in Excel by creating a result macro with a nested IF to classify scores as fail, compartment, or pass, and by recording a calendar template.

Learn three ways to run macros in Excel: keyboard shortcuts (ctrl q, ctrl w, ctrl e), a shape button, and a custom ribbon.