Excel Macros & VBA for Beginners
Want to learn Excel Macros & VBA with me?
✅ Check out my course: https://go.launchexcel.com/macros-vba...
Download the FREE Excel Workbook
Step 1: Sign up for free: https://go.launchexcel.com/email-sign...
Step 2: Log in here: https://courses.launchexcel.com/dashb...
Step 3: Download: https://courses.launchexcel.com/schoo...
TIP: Stay logged in for quick access to ALL workbook downloads
Click here for the article with full VBA code:
https://www.launchexcel.com/excel-mac...
Chapters:
00:00 Are you driving Excel in first gear?
00:29 WHAT IS A MACRO?
01:14 Record your first macros
↳ 02:45 View Tab & list of macros
↳ 04:23 Customize Ribbon
↳ 05:00 Relative vs Absolute References
↳ 05:51 Record macro 1 (Highlight)
↳ 07:45 Test macro 1
↳ 08:28 Record macro 2 (Un-highlight)
↳ 09:31 Test macro 2
10:08 Mission: Use VBA to upgrade our macros
↳ 10:41 How will we fix our macros?
↳ 12:00 Access the Visual Basic Editor
↳ 13:50 Switch back to Excel (ALT + F11)
↳ 14:21 Combine VBA code
↳ 18:02 Assign keyboard shortcut (CTRL + SHIFT + K)
↳ 18:46 Assign to button
20:57 Use macros to filter data
↳ 21:22 Turn data into a Table (CTRL + T)
↳ 22:07 Reveal the Developer Tab
↳ 22:49 Record new macros
↳ 25:13 Add shapes to run macros
27:45 Use macros to sort data
↳ 27:59 Turn off relative references to record
↳ 28:45 Add macros to shapes
↳ 31:47 There is no undo!
↳ 32:01 Sort by original row order
↳ 33:10 Custom sort on several columns
36:21 The Time I Almost Got Fired...
38:36 A Chance Encounter Leads to...
40:29 Will You Take This Opportunity?
Learn Macros and VBA with me
STOP Wasting Time on Repetitive Tasks with Excel VBA
https://go.launchexcel.com/macros-vba...