Computer Tutoring Logo

Cost Calculator

Training delivery
Number of students?
Laptop hire?
Offsite training?

Course price: £ *
Price per head:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

Tell Me More

Live online Face to face
First name:

Last name:

Email:

Tel:

Location:

Number of students:
First NumberPlusSecond Number  = 

Please enter the answer to prove that you are human and not a machine.
I would like to receive software tips and special offers

Testimonials

Financial Services Organisation

"The resources are excellent and I will be able to learn independently from the notes"

Microsoft Excel VBA 2010 Training Course Beginners Coventry

Coventry Beginners Microsoft Excel VBA 2010 Course Overview

Beginners VBA  training course in Coventry

In in the middle of the West Midlands we are now delivering training courses in the conveniently located city of Coventry. Computer Tutoring has already provided VBA training for many companies in the surrounding areas so delivering Microsoft Excel VBA 2010 Training Course training in Coventry is a natural step.

We can come to you, or you can come to us for your Beginners Microsoft Excel VBA 2010 Training Course training course.

Explore Coventry, a city steeped in history with its iconic cathedral and vibrant arts scene.

Other training courses in Coventry.


Course Duration: 1 Day

Complete Course Outline

Developing Macros using Microsoft Excel 2010 VBA

  • Create a Macro with the Macro Recorder
  • Edit a Macro
  • Debug a Macro
  • Customize the Quick Access Toolbar and Hotkeys
  • Work with Macro Security

Formatting Worksheets Using Macros

  • Insert Text
  • Format Text
  • Sort Data
  • Duplicate Data
  • Generate a Report

Creating an Interactive Worksheet

  • Determine the Dialog Box Type
  • Capture User Input

Working with Multiple Worksheets

  • Insert, Copy, and Delete Worksheets
  • Rename Worksheets
  • Modify the Order of Worksheets
  • Print Worksheets

Performing Calculations

  • Create User-Defined Functions
  • Automate SUM Functions