EX16VBA – MS Excel VBA 2016

Enquire/Book this course

  • This field is for validation purposes and should be left unchanged.
Print this page
  • Code: EX16VBA
  • Duration: 2 Days
  • Price per delegate: £550.00 +VAT

Trained over 60000 delegates

Course delivered by industry expert instructors

Highly competitive pricing

Overview: You use Microsoft Excel 2016 to work with data and need to improve the processes involved. This course looks at how you can work directly with Excel 2016 and its components to manipulate the application to help you work with your data.

Target Audience: Experienced Excel 2016 users who work with data and need to create tools and solutions in Excel 2016 to streamline workflow, manage and present information.

Delegates will learn how to:

  • Work with Excel 2016 components using VBA
  • Manipulate and present data in Excel 2016 using VBA
  • Work with files and folders in Excel 2016 using VBA

Pre-Requisites:

  • Delegates should have attended the Introduction to VBA in Office 2016 course, or have equivalent knowledge
  • Experience of recording and writing simple macros
  • Please note this course is not suitable for Excel 2016 users who have no VBA knowledge

Course Content

Excel 2016 Object Model

  • The Excel Component Object Model
  • Using Methods and Events
  • Object Variables and Binding
  • Creating User Defined Types and Classes

Working with the Range Object

  • Range Objects Defined
  • Referencing Ranges using VBA
  • Dynamic Range Handling
  • Copying or Moving Range Data
  • Creating Array Variables

Working With Data in Excel

  • Importing Data into Excel
  • Data Types and Formatting
  • Validating Data
  • Filtering and Sorting Data with VBA
  • Using Database Functions
  • Excel Tables

Presenting Data in Excel

  • Applying Conditional Formatting with VBA
  • Working with Charts
  • Pivot Tables

Working with the Excel Interface

  • Working with Page and Print Options
  • Controlling Visual Elements of a Workbook
  • Workbook Sharing and Track Changes
  • Workbook Security using VBA

Managing Files and Folders from Excel

  • FileSystemObject
  • Managing Folders from Excel
  • File Management Tasks using Excel
  • Working with File Properties and Attributes from Excel
  • Reading a Text File from Excel