Welcome to Insight

A Business to Business training specialist
Delivering Business Skills and IT training nationwide

At your Convenience
We come to you or
you come to us
Wherever you are!

Flexibility
Build your own tailored course
Lots of options available

Good Value
Your company saves money
and your staff save time

What's New?
Remote Classroom Training...
...coming shortly!

It's Your Training!
When and Where
You want it

Welcome to Insight

Delivering private IT training from businesses,
public sector and voluntary organisations

Microsoft Excel VBA

< Back to Microsoft and Office Courses | Insight IT Training

Course Details

vba

Course Duration – One day

Benefits of Microsoft Excel VBA Course

Our Microsoft Excel VBA course is intended for advanced Microsoft Excel professionals that need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA). VBA gives you the ability to do what you normally do in Excel, but much faster and allows you to work with ease with enormous sets of data.

We have designed a one day course structure that is relevant for business use. This is a hands-on learning experience which is more instructive than textbook. Our Microsoft Excel VBA course looks at creating and developing macros, working with worksheets and performing calculations. Please refer to the course content for a full list of topics covered.

At the end of the course the delegate will have covered the fundamentals of VBA. Our trainers are qualified and experienced professionals with years of experience in teaching the Microsoft suite of products.

For successful completion of this Microsoft course you would need knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Course Content

Developing Macros

  • Create a Macro Using the Macro Recorder
  • Edit a Macro
  • Debug a Macro
  • Customize the Quick Access Toolbar and Hotkeys
  • Set 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

Prerequisites

Knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Contact Us

Interested in our service? Then get in touch today with Insight IT to see how we can tailor your training to suit your needs.

Call us on: 08452 306 099 or contact us online here.