How to Create & Use Excel Macros (Real world example)
Complete Course: https://courses.xelplus.com/p/excel-vba-excel-macros
In this video you'll learn the basics of Macros and VBA in Excel. Plus you learn all of this in 10 minutes! Macros allow you to automate repetitive tasks in Excel. I'll show you how to to enable the Developer Tab, which allows you to record and run macros. We'll do an example on how to automatically create and format an Excel chart based on a dataset. This dataset has different ranges so we want to record the macro in such a way that its dynamic depending on the size of the data. You'll learn to avoid a common mistake when referencing ranges in Excel. Instead of hardcoding a certain data range with excel macros we'll use dynamic cell referencing.
I'll show you what the macro recorder can record and which actions you have to add yourself to the visual basic editor. I'll add an example by using the IF statement in VBA and also referencing a range for the chart title. Learn how to save your spreadsheet so you can access your Excel macros again in the future.
Timestamps
00:00 Excel Macro Tutorial for Beginners
01:12 How to Record a Macro in Excel
06:36 How to Manually Adjust Code in Visual Basic Editor
07:33 Add IF Condition to Avoid Errors
09:10 How to Save Excel Workbook With Macro
09:34 Wrap Up
⯆ DOWNLOAD the sample workbook here: https://www.xelplus.com/learn-excel-macros/
LINKS to related videos:
► Relative Referencing - Copy Data from one Sheet to Another: https://youtu.be/8IreWUk1Al4
Check out the FULL VBA Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #ExcelVBA
Видео How to Create & Use Excel Macros (Real world example) канала Leila Gharani
In this video you'll learn the basics of Macros and VBA in Excel. Plus you learn all of this in 10 minutes! Macros allow you to automate repetitive tasks in Excel. I'll show you how to to enable the Developer Tab, which allows you to record and run macros. We'll do an example on how to automatically create and format an Excel chart based on a dataset. This dataset has different ranges so we want to record the macro in such a way that its dynamic depending on the size of the data. You'll learn to avoid a common mistake when referencing ranges in Excel. Instead of hardcoding a certain data range with excel macros we'll use dynamic cell referencing.
I'll show you what the macro recorder can record and which actions you have to add yourself to the visual basic editor. I'll add an example by using the IF statement in VBA and also referencing a range for the chart title. Learn how to save your spreadsheet so you can access your Excel macros again in the future.
Timestamps
00:00 Excel Macro Tutorial for Beginners
01:12 How to Record a Macro in Excel
06:36 How to Manually Adjust Code in Visual Basic Editor
07:33 Add IF Condition to Avoid Errors
09:10 How to Save Excel Workbook With Macro
09:34 Wrap Up
⯆ DOWNLOAD the sample workbook here: https://www.xelplus.com/learn-excel-macros/
LINKS to related videos:
► Relative Referencing - Copy Data from one Sheet to Another: https://youtu.be/8IreWUk1Al4
Check out the FULL VBA Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyzmbDy6QoBuUDrU5D-jD-Se
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #ExcelVBA
Видео How to Create & Use Excel Macros (Real world example) канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Beginners Guide to Excel Macros - Create Excel ShortcutsDiscover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)FREE Windows Apps You Should be Using (who thought these are ACTUALLY FREE?!)Progress Circle Chart in Excel as NEVER seen before!50 Ultimate Excel Tips and Tricks for 2020Consolidate & Clean Multiple Excel Sheets in One Pivot TableExcel VBA: Copy Data from one Sheet to Another (Absolute Vs. Relative Macro Recording)Don't Use Excel Filters! Use This Incredible Excel Formula Instead ...TOO MANY EMAILS? Use THESE Proven Techniques | Outlook tips includedExcel VBA Beginner TutorialEASILY UNLOCK Protected Excel Sheets WITHOUT PasswordBuild Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel)How to Create Macros in Excel TutorialExcel shortcut keys you SHOULD know!Properly Convert PDF to Excel6 FREE Add-Ins for Excel to Start Using NowExcel VBA tutorial for beginners: The Visual Basic Editor (VBE)How to Use OneNote Effectively (Stay organized with little effort!)Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)