Microsoft Excel Ultimate Excel Beginner to Advanced Bootcamp

Master the basics of Excel by exploring core elements, including workbooks, worksheets, cells, and the ribbon, and learn cell naming like A1 and B2 to optimize your workflow.

Master Microsoft Excel shortcut keys to navigate cells with arrow keys, jump to data edges with Ctrl, select rows or columns with Shift, and insert or delete rows and columns.

Discover the anatomy of a function in Excel, from the equal sign to selecting a function and supplying arguments, with access to over 500 built-in functions in the function library.

Discover how Excel's ribbon system surfaces key tools—from backstage file management and home formatting to insert pivot tables, charts, and data visuals—empowering you to craft polished, insightful workbooks.

Get started in Excel by exploring the file menu's home, new, and open sections, using templates, blank workbook, and print settings such as margins and page orientation.

Learn to copy, cut, and paste in Excel, including format painter, undo and redo, and smart fill down with patterns. Apply shortcuts to maintain data and formatting across cells.

Master printing in Excel by selecting print options, choosing active sheets or a selection, adjusting orientation, margins, and scaling, and printing to a printer or pdf.

Learn the fundamental ingredients of formatting in Excel to transform boring spreadsheets into a fresh, spice-filled data presentation.

Master formatting basics in Excel to clean and organize data, including auto-fitting columns, date and currency formats, converting text to numbers, and moving data with Alt H O I.

Understand the difference between relative and absolute references in Excel, using dollar signs to lock a cell (F4), and apply it to inventory and markup formulas.

Explore why Excel remains essential for organizing, calculating, analyzing, and visualizing data. Learn to use rows and columns, formulas and functions, charts, and automation with macros and pivot tables.

Learn dynamic text extraction in Excel using left, right, mid, and find functions based on character count, then master Flash Fill's pattern sensing and three initiation methods.

Highlight the entire data set, use go to special to select blanks, and delete entire rows to remove all blank cells at once.

Learn to round numbers in Excel with round, round up, round down, and m round, and apply multiples to calculate case packs and inventory needs.

Master practical Excel tips and tricks, from autofill and flash fill to keyboard shortcuts, freeze panes, quick analysis, and conditional formatting for faster, error-free data work.

Learn to use extraction functions in Excel to pull text by character count, exploring left, right, and mid, plus text before, text after, and text split in Microsoft 365.

Explore if statements and nested ifs in excel to perform logical tests, assign buckets, and apply and, or, not with absolute referencing for efficient formula copying.

discover the new functions introduced by Microsoft in Excel and apply them to practical tasks across beginner to advanced levels.

Learn how the FV schedule function in Excel computes future value with a principal of $5,000 and a year-by-year rate schedule from 8% down to 3.5% over five years.

Use ppmt function to determine how much of a loan payment goes to principal versus interest, using rate, periods, and present value for $11,500 loan at 6.25% over 20 years.

Calculate the internal rate of return (IRR) for a series of cash flows by entering the initial investment and projected annual returns in Excel, with an optional guess.

Use the rate function to calculate the rate per period for a loan or investment by inputting the number of periods, annual payment, and loan amount as shown.

Master the filter function in Excel to pull all matching records without changing source data, compare it to dropdown filters, and understand spill behavior and if empty results.

Group columns to organize large spreadsheets and create year buckets you can hide or show. Use subtotals to summarize by exhibits, and sort data before applying the subtotals menu.

Master Excel's Goal Seek to set a revenue target and determine the required percentage increase by adjusting the changing cell in the revenue formula.

Learn to create and analyze data with pivot tables in excel, turning a ton of data into insights and building your skills from beginner to advanced.

Master the index and match combination as a dynamic lookup alternative to vlookup, hlookup, or xlookup, using coordinates and exact match positions to pull item prices.

Master the XLOOKUP function in Excel 365, a game changer that works vertically or horizontally, returns multiple columns, and helps you replace VLOOKUP limitations.