fbpx
excel_training_courses_singapore_logo

Excel 2016 Programming with Visual Basic for Applications (VBA)

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.

Share on facebook
Share on twitter
Share on linkedin

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

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