0845 450 6120

Microsoft Excel 2010 – Advanced VBA

Target audience

Experienced Excel 2010 users who work with data and need to create tools and solutions in Excel 2010 to manage and present information.


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


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

Learning Objectives

Delegates will learn how to

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


Before attending this course, delegates should have:

  • Attended the Introduction to VBA – Office 2010 course or have equivalent VBA knowledge
  • Experience of recording and writing simple macros
  • Please note this course is not suitable for Excel 2010 users who have no VBA knowledge

Course Content

Delegates will learn how to

  • Record and edit a Macro recorded within Excel/Word
  • Use different techniques in order to run any macros available such as keyboard commands, the use of the Quick Access Toolbars or Buttons
  • Use VBA and examine the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures
  • Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope
  • Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks
  • Create an error handling routine in case things go wrong with VBA code
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