*Watch this video next* 🔥 STOP Wasting Time on Repetitive Tasks with Excel VBA go.launchexcel.com/macros-vba-school-vsl-youtube *Download the Free Excel Workbook* Step 1: Sign up for free: go.launchexcel.com/email-signup-youtube Step 2: Log in here: courses.launchexcel.com/dashboard/en/login Step 3: Download: courses.launchexcel.com/school/course/workbook-downloads/lecture/5074882#headline-f994c1cf And you can stay logged in for quick access to future workbook downloads. *Click here for the article with full VBA code:* www.launchexcel.com/excel-macros-for-reporting (coming soon) *Chapters:* 00:00 The Power of Excel Macros 00:43 STEP 1: Create Sheet Header (save as XLSM) 04:33 STEP 2: Format Table 06:03 STEP 3: Add Column Chart 10:08 STEP 4: Keyboard Shortcuts (incl. FLOATUP) 11:23 ↳ What CTRL + SHIFT combos are available? 11:50 Learn Excel VBA 10x Faster
@guitars02065 сағат бұрын
Thank you for creating that video-it is one of the better ones I have watched. I am just starting to learn how to create macros in Excel. Do you have a video that shows how to connect all three of those macros into one? What program did you use to record yourself running Excel and record the video of you outside of Excel?
@launchexcel5 сағат бұрын
Glad you enjoyed the video and that you're learning about Excel macros! While I don't yet have a video on how to connect all three macros into one, here's a starter: ➡️ Combining macros To connect all three macros into one, you just “call” them inside a single macro like this: Sub MasterMacro() Call Step_1_Macro Call Step_2_Macro Call Step_3_Macro End Sub You'll need to go inside the VB editor to create a new master macro. Think of it like lining them up in a queue, each one runs in order. ➡️ Recording setup I used Screen Studio (Mac only screen.studio/) to record while running Excel in Windows with Parallels Desktop. For recording myself outside of Excel I used Tella.tv (www.tella.tv/). Plus Descript for overall editing (www.descript.com/). P.S. 🚀 I take people through all these steps and a whole lot more in my online course (go.launchexcel.com/macros-vba-school-youtube) 🚀
@guitars02063 сағат бұрын
@@launchexcel Hi Victor, thank you for getting back to me so quickly. Combining macros looks easier than I imagined. Can you suggest a Windows version to record video while running Excel. Thanks again for your help. Will check out your online course.