Mastery Courses - Microsoft Excel, Word, Unlock Macros & VBA

Create your first Excel workbook from scratch and build an inventory list with headers using tab and enter. Edit data in the cell or formula bar, resize columns, and save.

Learn how to adjust column width and row height, apply styles and fonts, borders, and currency formats, and use the format cells dialog to preview changes.

Learn to use alignment, wrap text, and merge and center functions on the home tab to align content, wrap long text, merge cells, and adjust text orientation.

Master basic math in Excel by building formulas, using addition, subtraction, multiplication, and sum ranges with auto sum, and exploring relative and absolute references.

Learn how to build formulas in Excel using the equals sign, ranges, and basic arithmetic. Explore the order of operations and shortcuts like auto sum to quickly compute results.

Discover how absolute and relative cell referencing affect formulas when copying in Excel, and learn to lock references with dollar signs and use mixed references for robust calculations.

Explore how Excel functions simplify calculations with prepackaged algorithms, parameters, and ranges; learn to build and copy sum formulas, handle optional arguments, and subtract costs to compute gross profit.

Master core Excel math functions such as sum, subtotal, and round to compute the grand total, handle ranges, and apply nested formulas.

Master text functions in Excel by extracting left, right, and middle characters, concatenating results, locating text with find and search, and handling errors with iferror.

Learn to audit Excel formulas with trace precedents and dependents, color-coded input boxes, and the Evaluate Formula tool to understand calculations and prevent reference errors.

Master conditional math functions in Excel, using SUMIF, COUNTIF, and SUMPRODUCT to sum salaries by experience criteria and count qualified employees, including multiple criteria.

Master Excel temporal functions like EOMONTH and EDATE to shift dates by months, compute end-of-month and same-day future dates for finance and monthly schedules, including negative offsets.

Learn to use vlookup on large tables to pull salaries and joining date by exact employee I.D. matches, selecting the correct column across sheets for fast, accurate data retrieval.

Master nesting vlookups by using an inner vlookup to derive region from state, then an outer vlookup with reason and experience to fetch value via exact matches and absolute references.

Explore Excel lookup methods including hlookup, index, and match, and learn to combine index with match for two-dimensional lookups across vertical and horizontal tables.

Record macros in Excel to automate repetitive tasks by capturing actions with the developer tab, then run or assign the macro to a button or shortcut.

Explore naming ranges in Excel to make formulas readable and auditable across a workbook, using names like incentive_rate and salary_sheet with the name box and Name Manager for exact-match lookups.

Convert data lists into formatted Excel tables in 2007 and later. Ensure visible header rows, sorting, and filtering, with automatic expansion and structured table referencing for formulas.

Format pivot tables to improve readability by adjusting value fields and renaming columns, using accounting number formats. Switch between tabular and outline layouts, set subtotals, and refresh to preserve formatting.

Learn to use slicers to filter and manipulate pivot table fields in Excel, enabling quick, multi-item selections and focused views for compelling presentations.

Learn to group pivot table data by date—month, quarter, or year—and create custom groupings, such as departments, to produce compact, meaningful views.

Learn to use the solver in Excel to optimize a total by changing multiple variable cells within defined constraints.

Master cell formatting by using the format cells dialog to apply alignment, borders, and fill colors, center data across selections, rotate headers, and merge cells for a polished, readable worksheet.

Create custom number formats in excel to display dates, enforce six-digit codes with leading zeros, format currency with dollar signs, and indicate favorable or unfavorable values with semicolons.

Master the basics of conditional formatting in Excel by applying top and bottom rules, greater-than highlights, data bars, and icon sets (including stars) to reveal key data insights.

Create a column chart in Excel, add data labels, remove gridlines and axis lines, adjust series overlap to 50 percent, position labels inside base, bold the font, and rename header.

Learn how to create effective pie charts in Excel, when to use them, limit to three data series, and add percentage labels with readable formatting.

Learn to build a waterfall chart in Excel by formatting data with opening balance, ending balance, and successive increases or decreases to visualize movement.

Create a combination chart in Excel that blends area and line for three data series: revenue, expenses, and cost of goods sold—highlighting key trends and comparisons over time.

Learn to build combination charts in Excel by turning actuals into a column chart and budget into a line chart, using data series and markers.