What you'll learn

Microsoft Excel offers an excellent balance between power and ease of use. This makes it a primary candidate for many enterprises to create reports. However, creating these documents can be onerous and repetitive. In this course, Record and Manage Macros in Microsoft Excel, you’ll gain the ability to record scripts to automate repetitive tasks. First, you’ll explore how to use Excel to create a macro. Next, you’ll discover how to refine generated macros to improve their robustness and usefulness. Finally, you’ll learn how to create user-facing controls so that anyone can activate the macros when they are needed. When you’re finished with this course, you’ll have the skills and knowledge of creating Excel macros needed to eliminate repetitive tasks while also improving the consistency of your output.