Advanced Excel Functions, Macros, and VBA Bundle

Record, save, and run macros with Excel's macro recorder, which converts steps to VBA code. Access it via the developer tab or status bar and set names, storage, and shortcuts.

Record macros with relative referencing to apply the report heading and formatting across worksheet locations. Learn absolute vs. relative referencing, start cells, and test across sheets with relative references.

Master a complex Excel macro that reformats table by splitting names, removing zeros and hyperlinks, masking credit cards to last four digits, auto fit, with backups and a runnable button.

Record macros to sort by department and date and filter by job title with absolute referencing, then create buttons and assign these macros to the quick access toolbar.

Learn to protect cells and worksheets with macros by unlocking input cells, locking formulas, and protecting the sheet, then create a macro and assign it to an icon.

Master the VBA editor to edit macros, write code from scratch, and organize modules with meaningful names. Use the immediate window to run code, ask questions, and inspect worksheets.

Explore how the macro recorder builds VBA code while you run and modify fonts and headings. Learn to view the VBA editor, manage modules, and test macros.

Edit VBA macros in Excel to adjust font styles, such as bold and italic, and manage range selections, then test changes and adjust final cursor positions like A4 or EF1.

Master debugging macros in Excel by stepping through code with the VBA editor to identify errors. Ensure correct currency formatting and headings after running the macro.

Create a macro from scratch in the VBA editor to insert a top row with headings first name, last name, department, and job title, then bold and color the row.

Learn to create a custom ribbon in excel to house macros, organize them into two groups, rename items for clarity, and assign icons for easy access.

Master the end-to-end macro workflow in Excel, from running and saving macro-enabled workbooks to creating a macro from scratch, exploring the VBA editor and debugging.

Explore ten common advanced Excel formula challenges and learn to construct task-focused formulas using newer functions in Excel 365 or 2019, with practice files and ten modular lessons.

Watch this essential video to prepare for the training experience, including downloading and unzipping the downloadable instructor files, configuring high-definition playback, adjusting speed, and noting review prompts.

Utilize the Excel filter function to dynamically filter a dataset by testing center and fail status, using a table and the unique function to create a dropdown that spills results.

Sort a dataset in Excel 365 using sort and sort by formulas, with dynamic arrays that update automatically, and define variables with let and left to streamline multi-column sorting.

Create cascading or multiple dependent dropdown lists in Excel using the unique function, filter, and data validation, then use a v lookup to pull salaries with dynamic updates.

Master two-way lookups with index and match to retrieve revenue and profit across rows and columns, using tables and data validation to build flexible, updateable queries.

Explore how to use Excel's logical functions, including if, and, or, and nested ifs, to test conditions, return true/false results, and automate discounts with multi-criteria and cell locking.

Master Excel text functions to extract codes, usernames, and domains using left, mid, right, find or search, and then derive year, month, week, and weekday with text formatting.

Create a dynamic chart title that updates with slicer selections using a helper table and text formulas (text join or concat) alongside pivot tables and pivot charts.

Learn two methods to extract the last occurrence of a value in a data set using index and lookup formulas, with a real‑world example of employee absences and dates.

Discover how XLOOKUP, a flexible direction-agnostic function, handles exact, approximate, and wildcard matches across vertical or horizontal data to retrieve current team, bonus, and salary.

Discover how to find the closest match to a value in Excel by using absolute differences, MIN, and INDEX/MATCH, including array formulas to identify the closest result.

Explore 22 advanced Excel functions to return values, filter data, create unique lists, use sortby and let for variables, and build dynamic chart labels with text, logic, and math capabilities.