How to Create & Use Excel Macros (Real world example)




About this tutorial:

Video duration: 00:10:09
Complete Course:
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…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads