Overview
In this course, participants will examine the Visual Basic for Applications Environment and create custom procedures to enhance the functionality of Excel.
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
- Deciding what to do when an Error occur
- Creating Charts
- Excel Power with sample
- Working with multiple files from folders
