Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel: It's Not Magic, It's Macro
Welcome
This Is How It's Going Down AKA Rules (3:21)
Module I: Intro to Macro Recording
Section I: Where Do I Begin? (10:19)
Section II: Let's Record Our First Macro (15:01)
Section III: Did It Work? (19:52)
It's Your Turn: DIY Activity
Module II: Real Life, Flexible Macros
Section I: Absolute vs. Relative References - Say What, Now? (8:37)
Section II: Keyboard Shortcuts Are Your New BFF!!! (9:58)
SPECIAL RESOURCE: Keyboard Shortcut
Module III: Using Formulas & Functions in Macros
Section I: Quick Review: Functions & Formulas (4:59)
Section II: Creating Flexible Macros with Functions (15:45)
Section 3: How to Autofill (AKA Drag) Formulas (10:27)
Section 4: More AWEESSSOMMMEEE Functions (8:34)
Module IV: How to Use Macros in Multiple Files
Section I: The Best Thing Ever - Personal Macro Workbook (6:29)
Section II: I Work With Multiple Files, Can Macros Help? Watch Me! (12:38)
Section III: How Do I Bring Data to One Place with Macros? (13:56)
It's Your Turn - DIY Activity
Module V: Macros for Data Entry
Section I: Let's Break It Down (24:02)
It's Your Turn - DIY Activity
Thank You!!
Let's Connect
Teach online with
Section II: I Work With Multiple Files, Can Macros Help? Watch Me!
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock