Microsoft Excel Masterclass :Ultimate Microsoft Excel and AI

Meet the Excel ribbon cast, from Backstage to Home, Insert, Draw, Page Layout, Formula, Data, Review, and View ribbons, plus the Help ribbon.

Learn how to manage worksheets in Excel by creating, renaming, moving between workbooks with move or copy, and using hide, unhide, and delete to organize your workbook.

Learn to print in Excel, manage printers and PDF outputs, and tailor settings from active sheets to the entire workbook with orientation, margins, and scaling.

Master Excel to organize, analyze, and visualize data with formulas, charts, and automation. Use Excel for budgeting, project management, inventory, and data-driven decision making to advance your career.

Learn the fundamentals of formatting in Excel by acting as restaurant consultants who shape and style sandwich data, giving boring spreadsheets a fresh, spice-filled look.

Master absolute referencing in Excel by using dollar signs to lock a cell like K3 and contrast it with relative references. Drag formulas while keeping H3 fixed so references adjust.

Master essential Excel tips and tricks to boost efficiency, using Autofill, Flash Fill, keyboard shortcuts, Freeze Panes, Quick Analysis, Conditional Formatting, AutoSum, and data tools for cleaner, faster spreadsheets.

Master the find and replace tool in Excel using Control F or Control H to search, replace, and format across a workbook, including removing INV- prefixes and changing colors.

Master Excel extraction functions to pull data from cells using left, right, and mid with precise character counts, and explore text before, text after, and text split for advanced parsing.

Discover Excel's combination functions—the and sign, concatenate (concat), and text join—and learn to glue text and cell references with spaces, delimiters, and ignore empty.

Use the FV function to calculate the future value of an amount with periodic payments and a constant rate, using rate, total periods, payment, present value, and payment timing.

Calculate net present value with the npv function using an 8% discount rate, initial 3000 investment, year 1 and year 2 cash flows, to evaluate the farmers market investment.

Learn how to use the rate function to calculate the interest rate per period for loans or investments, using a $2,500 loan, $375 annual payments, over eight years.

Explore building charts in Excel to visualize dashboard data, using recommended charts, such as clustered bar charts, and customize axes, titles, labels, legend, and filters.

Learn to forecast with Excel's goal seek by setting revenue to a target (e.g., 900,000) and solving for the percentage increase in the revenue formula based on tickets and price.

Learn to add slicers and timelines to pivot tables to filter revenue by class type, use multi-select with ctrl or shift, and clear filters for dashboards.

Explore the VLOOKUP limit that prevents pulling data to the left of the lookup column, causing #N/A errors, and learn workarounds with index‑match and XLOOKUP.

Learn how to perform a horizontal lookup with HLOOKUP, the counterpart to VLOOKUP, for data laid out across rows, using a table array, row index, and an exact match (false).