Tel: UK 0845 757 3888 | Ireland: 01 284 6796
Advanced VBA – Microsoft Excel 2007
Course type Performance (What does this mean?)
| Course title | Advanced VBA – Microsoft Excel 2007 |
|---|---|
| Delivery method |  Classroom |
| RRP | £570 exc. VAT |
| Days/Duration | 2 |
| Code | QAEX07VBAA |
Secure online payment
- view dates / book course
- course description
- blogs
Course dates
| Location | May | Jun | Jul | Aug | view later dates |
|---|---|---|---|---|---|
| Location | Sep | Oct | Nov | Dec | view earlier dates |
London
King William Street, EC4 |- |18 |- |- 
Location Sep Oct Nov Dec view earlier dates King William Street, EC4 |- |- |- |- King William Street, EC4location information and directions
18 Jun limited availability £570 exc VAT 
Advanced VBA – Microsoft Excel 2007 training in King William Street, EC4
Midlands
Birmingham |- |- |- |- Location Sep Oct Nov Dec view earlier dates Birmingham |- |25 |- |19 Birminghamlocation information and directions
25 Oct 5 or more places available £570 exc VAT 19 Dec 5 or more places available £570 exc VAT Advanced VBA – Microsoft Excel 2007 training in Birmingham
North
Manchester |- |- |9 |- Location Sep Oct Nov Dec view earlier dates Manchester |17 |- |12 |20 Manchesterlocation information and directions
09 Jul 5 or more places available £570 exc VAT 17 Sep 5 or more places available £570 exc VAT 12 Nov 5 or more places available £570 exc VAT 20 Dec 5 or more places available £570 exc VAT Advanced VBA – Microsoft Excel 2007 training in Manchester
Leeds, City Centre |- |- |- |- Location Sep Oct Nov Dec view earlier dates Leeds, City Centre |6 |- |- |6 Leeds, City Centrelocation information and directions
06 Sep 5 or more places available £570 exc VAT 06 Dec 5 or more places available £570 exc VAT Advanced VBA – Microsoft Excel 2007 training in Leeds, City Centre
Scotland
Edinburgh |- |- |31 |- Location Sep Oct Nov Dec view earlier dates Edinburgh |- |- |- |- Edinburghlocation information and directions
31 Jul 5 or more places available £570 exc VAT Advanced VBA – Microsoft Excel 2007 training in Edinburgh
Overview
You use Excel 2007 to work with data and need to improve the processes involved. This course looks at how you can work directly with Excel 2007 and its components to manipulate the application to help you work with your workbooks and data.
Target audience
Experienced Excel 2007 users who work with data and need to create tools and solutions in Excel 2007 to manage and present information
Prerequisites
- Before attending this course, delegates should have attended the QAVBA07INT course or have equivalent VBA knowledge
- Experience of recording and writing macros which include control structures and the declaration of variables
- Please note this course is not suitable for Excel 2007 users who have no VBA knowledge
Delegates will learn how to
- Work with Excel 2007 components using VBA
- Manipulate and present data in Excel 2007 using VBA
- Work with files and folders in Excel 2007 using VBA
Course Outline
Lesson 1: Excel 2007 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
- Apply 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
Related blogs
Do a better Disk Cleanup as Administrator
Posted by Andrew Mallett on 14 May 2012
Many of us will know the Windows 7 Disk Cleanup feature but how many of us miss some features by not running as an administrator?
I know the name but what is the printer driver
Posted by Andrew Mallett on 09 May 2012
SUPPORT: “Which printer is it?” USER: “Darth Vader” Of course naming your printers other than by the print driver is useful and more fun for you users but does not really help you identify the printer. See how PowerShell can help you out....
what are you wearing
Posted by Bob Simms on 03 May 2012
Data mining and its use in business, or how to stop those annoying phone calls
What are your time stealers?
Posted by Jennie Marshall on 02 May 2012
I frequently facilitate learning sessions on time management, and one common theme for many, in this age of higher expectations on staff, is increased work load. But is it really more work that’s affecting our ability to be productive, or are we experiencing more ‘time stealers’ than we used to.
Windows : Open a command window to a directory
Posted by Andrew Mallett on 01 May 2012
Some things in both life and IT are simple and this is one of those items. Have you ever wanted to open the command window to a folder that you have navigated to with Windows Explorer? Read on help is at hand.
