0845 450 6120

Excel - 2013 VBA Advanced

Our new Microsoft Excel 2013 curriculum  allow adequate time to cover the technical subject matter in sufficient depth to ensure a full understanding. The courseware  covers the key topics required by users of this software, including the brand new features of this version, with lots of in-depth explanations, step by step instructions, key questions and group and individual activities.

Overview

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

Target Audience

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

 

Special Offer   Multiple Delegate / Course Discounts Available - Contact Us for Details

 

We don't currently have any courses listed for Excel - 2013 VBA Advanced , would you like to view all courses for Microsoft Office?

Learning Objectives

Delegates will learn how to

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

Pre-Requisites

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

Course Content

Lesson 1: Excel 2013 Object Model

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

Lesson 2: Working with the Range Object

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

Lesson 3: 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

Lesson 4: Presenting Data in Excel

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

Lesson 5: 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

Lesson 6: 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
One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Our Customers Include