How to Create & Use Excel Macros (Real world
example)
Complete
Course: https://courses.xelplus.com/p/excel-v... 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
No comments:
Post a Comment