Excel Mastery: Beginner to Expert — Integrated with AI

Explore worksheet basics, including managing sheets in a workbook: add, delete, rename, move, adjust rows and columns, resize, hide or unhide, and zoom for clear data.

Edit cell data by double-clicking or the formula bar, and learn textual, numeric, and formula data types along with number, currency, date formats, and decimals.

Master basic data handling in Excel by cutting, copying, and pasting data, navigating tables with keyboard shortcuts, selecting ranges, and using undo and redo to safeguard edits.

Explore how to use the file tab to create, open, save, and print workbooks in Excel, including save vs save as, password protection, and print preview.

Explore basic formula operations in Excel, including adding two numbers, applying cell references, and using absolute references with dollar signs to multiply, average, and fill columns efficiently.

Explore sumproduct to weight scores by subject credits, multiply corresponding elements in ranges, and rank students, then use randbetween to pick a representative while fixing values with paste as value.

Explore text functions in Excel, including trim to remove unwanted spaces and concatenate to join first and last names with a space or ampersand.

Explore Excel text functions, including substitute for replacement and case sensitivity, and uppercase, lowercase, and left, right, and mid to extract year, course ID, and enrollment number.

Explore logical tests and conditional formulas in Excel, using equals checks, the and function, the or function, nested ifs, and sumif and countif to grade scores and summarize results.

Master date and time handling in Excel, including formats, today and now, serial date numbers, and extracting day, month, year while calculating days between dates with datedif.

Master lookup functions in Excel using VLOOKUP, HLOOKUP, INDEX, and MATCH to retrieve scores from tables, with exact and approximate matches, edge lookups, and nested if usage.

Explore Excel mastery by sorting data, applying powerful filters, and enforcing 0–100 data validation with drop-down lists for clean, reliable spreadsheets.

Apply advanced filter to extract records between 50 and 100 using two conditions, then copy results to a location, and use wildcards to filter and identify unique values.

Master data formatting in Excel by styling headers, borders, alignment, wrap text, and center across selection; apply autofit, conditional formatting, data bars, and format painter for professional tables.

Discover essential Excel shortcuts for fast navigation, selection, worksheet switching, and editing, including Ctrl shortcuts, page navigation, and basic find, spell check, and file commands.

Learn how to handle not found errors with Xlookup, customize not found messages, and perform exact, next smaller, and next larger matches for vertical and horizontal lookups in Excel.

Learn to master xlookup with wildcard matching to retrieve salaries from partial names, using star wildcards and handling not found results.

Learn to create and customize pivot tables to analyze sales data by month, channel, and gender. Explore arranging fields, applying filters, grouping dates, and using slicers for interactive insights.

Learn to create a basic bar chart in Excel with one-click from data using the insert and recommended charts features. Explore design options to make charts clear and informative.

Master creating column charts and bar charts, including clustered, stacked, 2D and 3D variants, with legends and titles, by selecting data and adding multiple series like Myntra, Amazon, and Ajio.

Learn to format Excel charts by editing chart elements such as title, axes, legend, and plot area, and applying borders, fills, and effects, including currency formatting and data labels.

Learn how line charts visualize continuous data, reveal trends over time, and compare daily sales across brands using axis details, legends, and chart types.

Explore how area charts differ from line charts, adjust transparency and fills for multiple data series, and apply stacked and 100% stacked area charts (including 3d) to improve readability.

Learn to create pie charts in Excel to show relative proportions with few data points, add data labels and category names, and explore donut and pie of pie options.

Explore scatter plots, or x y charts, to reveal relationships between two variables and learn to create simple and bubble plots in Excel.

Learn to organize data with frequency distribution, group scores into intervals, and visualize frequencies in Excel using histograms and Pareto charts.

Master how waterfall charts visualize value changes from a starting point to a final result, with hands-on examples and step-by-step Excel guidance on creating and setting totals.

Explore sunburst and treemap hierarchies in Excel, demonstrating how hierarchical data with categories and subcategories is represented with proportional sizes using concentric circles or rectangles.