Microsoft Excel Masterclass :Ultimate Microsoft Excel and AI

Master Excel shortcut keys to navigate, reach data edges with control arrows, highlight columns or rows with control/shift space, and insert or delete with plus/minus.

Explore the anatomy of an Excel function, a predefined formula from a library of over 500 options. Learn to enter =, pick a function, input arguments, and press enter.

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

Discover the basics of getting started in Excel by exploring file menu's home, new, and open sections, using templates or a blank workbook, and adjusting margins, orientation, and print settings.

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.

Learn to freeze panes in Excel to keep key rows or columns visible while scrolling, using the view ribbon to lock from a chosen row or column.

Create and configure drop-down menus in Excel using data validation with a list source for vegetables, copy down, and reuse formatting with format painter to test options.

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.

Explore how to use the unique and sort functions together in Excel to pull unique values and sort by the two-letter codes inside account numbers.

Spin the wheel of functions to reveal which Excel functions you will explore. The host guides you as you dive into each function.

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.

Explore the new functions introduced by Microsoft in Excel and learn how they boost productivity in this Microsoft Excel masterclass focusing on AI-powered capabilities.

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.

Use the present value function to find the initial investment needed to reach a $10,000 goal with $300 monthly contributions at 4.75%.

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 to use the pmt function in Excel to calculate quarterly loan payments, given a $24,000 loan to reduce to $5,000 in four years, resulting in quarterly payments of $2,119.

Explore the PPMT function to calculate the principal portion of loan payments, using a $11,500 loan at 6.25% over 20 years, with examples for the 12th and 20th payments.

Learn how to compute the modified internal rate of return (MIRR) in Excel by accounting for the initial investment, cash flows, finance rate, and reinvestment rate.

Use the xirr function to compute the internal rate of return from a schedule of cash flows and dates. Include the initial investment and projected returns, and optionally a guess.

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.

Join the pivot table team as you become co-owner of Zen Yoga Studios and pivot a ton of data using pivot tables.

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.

Master the VLOOKUP function, including its vertical lookup mechanics, required arguments (lookup value, table array, column index, range lookup), and how to handle exact versus approximate matches and its limitations.

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).