Want to learn Excel Macros & VBA with me?
✅ Check out my course: https://go.launchexcel.com/macros-vba-school-youtube
*Download the FREE Excel Workbook*
Step 1: Sign up for free: https://go.launchexcel.com/email-signup-youtube
Step 2: Log in here: https://courses.launchexcel.com/dashboard/en/login
Step 3: Download: https://courses.launchexcel.com/school/course/workbook-downloads/lecture/5612592#headline-9a3b3ace
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-macros-and-vba-tutorial-victor-consulting-company
*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-school-vsl-youtube