Cost Calculator

Price per head:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

Tell Me More

Testimonials

Ottolenghi Ltd

"I found the basic excel training useful and excel cheatsheet is very handy. I learnt some new things from the exercise and looking forward to the next session. "

Balfour Beatty

"Great course, trainer was very interactive and enthusiastic."

GKN Aerospace

"Very informative and fun energy. I really enjoyed it and will be able to use what I leaned."

Prominate

"Excellent, informative, fun and engaging. Learnt a lot!"

"It was excellent. Easy to follow, engaging, structured and delivered with humour and patience."

Locations outside Ipswich

Microsoft Excel 365 VBA Training Course Beginners Ipswich

Ipswich Beginners Microsoft Excel 365 VBA Course Overview

Microsoft Excel 365 VBA Training Course Beginners training course Ipswich Willis building

With its historic docks, Ipswich combines a rich maritime heritage with modern attractions.

Belstead Road
Ipswich
Suffolk
IP2 9HB

The Belstead Brook Hotel sits in nine acres of tranquil gardens, alongside a willow-lined stream. The original 16th Century hunting lodge is still very much at the heart of the hotel, housing a restaurant, bar and private dining rooms. An ideal place for training the Microsoft Excel 365 VBA Training Course Beginners.

Alternatively if you live in and around Ipswich and wish to have your training on-site the we can provide all the equipment, included laptops and projector, required. All we ask is that you provide a little space for the trainer to set up.

Apart from Microsoft Excel 365 VBA Training Course training we conduct many other training courses in Ipswich.

Course Duration: 1 Day

Course Prerequisites for your training in Ipswich

Understands the basics of using a Windows-based computer.
Can use the Internet and download files.
Comfortable with the Microsoft Excel interface.
Firm understanding of Excel's functions and uses.
Experience with formulas, functions, and PivotTables in Excel is strongly recommended.
No previous experience with Visual Basic for Applications is required.

Complete Course Outline

Developing Macros with VBA

Get to Know Macros
Create a Macro
Edit a Macro
Debug a Macro
Customise 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

Microsoft Excel training is available in person and online.

All you need to know about our Live Online Training.

Live Online Training

Have a look at our range of Excel Training Courses