ObjectivesLearn the ins and outs of macros and learn Visual Basic for Application (VBA).
Targeted audienceAnyone with good knowledge of Excel who wishes to automate repetitive tasks using macros, and discover Visual Basic for Application.
PrerequisiteModerate to advanced knowledge of Excel.
- Key concepts used to create customized solutions using Microsoft Excel macros
- Basic techniques for recording, writing, executing and managing macros, and how integrations, use and modifications are made in Excel
- Preparing an Excel workbook containing macros and toolbars for deployment to other users and computers
- Activating source code protection
Use of macros covered in this course apply to the 2003, 2007, 2010, 2016 and 2019 versions of Excel.