Excel MACROS to Automate Your Reports in 2025 (Real World)

แชร์
ฝัง
  • เผยแพร่เมื่อ 17 ธ.ค. 2024

ความคิดเห็น • 4

  • @launchexcel
    @launchexcel  วันที่ผ่านมา

    *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

  • @guitars0206
    @guitars0206 13 ชั่วโมงที่ผ่านมา +1

    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?

    • @launchexcel
      @launchexcel  13 ชั่วโมงที่ผ่านมา

      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) 🚀

    • @guitars0206
      @guitars0206 11 ชั่วโมงที่ผ่านมา

      @@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.