How to Use Excel Macros to Automate Anything

Подписаться 53 тыс.

Просмотров 55 тыс.

50% 1

In this RU-vid video, you will learn how to create and use Macros in Excel to automate repetitive tasks. Using a real work example, we will show you how to utilize macros to create a weekly sales report with calculations and charts in just one click. Throughout the video, we will guide you on how to prepare a workbook for macros, record a macro, run a macro, view and edit a macro's VBA code, and more.
We will start by teaching you how to save the Excel file as a Macro enabled workbook to avoid accidentally erasing your macros. Additionally, we will demonstrate how to add the developer tab to your ribbon for easy access to macro commands. Next, we will cover the process of recording a macro using the macro recorder, naming the macro, assigning a shortcut key, and following best practices. You will also learn how to create a dynamic range within the macro, eliminating the need to adjust data ranges when adding or removing data. Finally, we will explain how to stop the macro recording, run the macro, and view and edit the macro's code in VBA.
By the end of this video, you will have the skills to save hours each week by creating Excel macros. #Excel #Macros #Automation
📖RESOURCES
- Download the workbook and follow along: excel-dictionary.com/pages/yo...
🤓SHOP EXCEL DICTIONARY
- COURSES: excel-dictionary.com/collecti...
-GUIDES: excel-dictionary.com/collecti...
-MERCH: excel-dictionary.com/collecti...
-TEMPLATES: excel-dictionary.com/collecti...
📩NEWSLETTER
-Unlock the full potential of Excel and PowerPoint with expert tips delivered to your inbox each week: www.excel-dictionary.com/subs...
📺SUBSCRIBE
-Subscribe to never miss a video: / exceldictionary
🕰️TIMESTAMPS
‘0:00 Intro
‘0:18 Macro Recorder Overview
‘0:31 Example 1
‘1:04 How to Save Workbooks with Macros
‘1:37 Add the Developer tab to the Ribbon
‘1:50 Start Recording a Macro
‘2:37 Create the Weekly Report
‘4:30 Stop a Macro Recording
‘4:41 How to Run the Macro
‘5:04 Example 2
‘5:39 How to View and Edit the Macro’s VBA Code
‘6:54 Example 3
‘7:16 Wrap Up

Опубликовано:

1 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 19

@gkwithsourabh6996 Месяц назад

I like your presentation good day take care and lots of thanks for your videos please upload all subjects marathon class theory you are the best beautiful teacher in the world

@markfitzgerald7897 4 месяца назад

I could’ve used this many years ago when I started out. Excellent video.

@darcyg852 3 месяца назад

You're just awesome, thank you!

@Nickschtyle 4 месяца назад

I love your channel so much!! Thanks for all these tips on how to better use Excel

@mohammedalhamad5039 4 месяца назад

انت رائعة جدا ... شكرا لك ... عمل مفيد كثيرا

@chickypie75 4 месяца назад

I use VBA a lot to speed up processes, I like to save them in the Personal Macro Workbook and add the macro to my Quick Access Toolbar so I can use them across multiple spreadsheets.

@minhajabbasy9582 4 месяца назад

Superb way of explaining all the steps.❤

@meggrau3873 4 месяца назад

Thank you!!!!

@ademolaibitayo 4 месяца назад

Great video. Thank you for sharing!

@AB-dp7pw 4 месяца назад

Good and easy explaination

@faisalabadeducator5468 4 месяца назад

Love you too much Madam Better Video

@terri24601 4 месяца назад

Love this. What’s the best way to get the new data into the macro enabled workbook each week? Is there something better than cut and paste?

@istvanlevai8365 4 месяца назад

Hey @terri24601! You can build a macro extension which automatically opens source files and does the copy paste in between the source and the Excel file with the macro. Source file name/path could be set in a specific cell of the Excel easy to manage by folks not having any macro/VBA knowledge. Cheers