Excel 2013 Programming with Visual Basic for Applications (VBA)

excel_training_courses_singapore_logo

Excel 2013 Programming with Visual Basic for Applications (VBA)

In this course, participants will examine the Visual Basic for Applications Environment and create custom procedures to enhance the functionality of Excel.

Share on facebook
Share on twitter
Share on linkedin

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

Get Brochure and Pricing

More Like This

Get the course Brochure & Pricing

Our course consultant will contact you within 1 working day

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Stay-Home-Series-main-header-v2

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Open chat
Get in touch with our consultant