Learn time savers in Excel such as setting up a Macro and using a vlookup formula to compare two different tables. Slides for Filters & Sorting are at the end and practice files are provided but there was not enough time to cover these topics during this session.
Resource files to follow along: https://tccsanet-my.sharepoint.com/:f:/g/personal/rosecrans_tccsa_net/IgDqvki86Nt5TJkNm-F2UvtzAX5Z-a55JoLiLroolGHLhjA?e=eW2una
Recorded date 1/8/26
Clicking a chapter link below will open the video in a new window. Or Hover over the video timeline to view chapters in this window.
CHAPTERS
2:00 Creating Macros
32:20 Add a button to a Macro
35:25 Editing Macros and where they are stored
40:13 How to make Macros Dynamic
44:30 Adding a Macro to the Quick Access Toolbar
47:28 VLOOKUP and XLOOKUP
1:05:32 Common Errors