Overview
In this course, participants will learn how to simplify their work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development.
Prerequisites
Prospective participants will require intermediate skills in Microsoft Excel 2010/2013/2016. It is also recommended for participants to complete Excel 2016 before sitting for this program.
Course Outline
- Create a Macro Using the Macro Recorder
- Edit a Macro
- Debug a Macro
- Customize the Quick Access
- Toolbar and Hotkeys
- Set Macro Security
- Insert Text
- Format Text
- Sort Data
- Duplicate Data
- Generate a Report
- Determine the Dialog Box Type
- Capture User Input
- Insert, Copy, Delete Worksheets
- Rename Worksheets
- Modify the Order of Worksheets
- Print Worksheets
- Create User – Defined Functions
- Automate SUM Functions
- Defining the Pivot Cache
- Creating and Configuring the Pivot Table
- Adding Fields to the Pivot Table
- Creating a UserForm
- Using ActiveX Controls in the Userform
- Verifying Field Entry
- Using Events and Events Parameters
- Commonly used Events for Workbooks and Worksheets
- Different types of Error in VBA
- Directing what to do when an Error occur
- Creating Charts
- Excel Power with sample
- Working with multiple files from folders
