Microsoft Excel 365 VBA Training Course Beginners Hammersmith

Hammersmith Beginners Microsoft Excel 365 VBA Course Overview

If you're wanting to book your Microsoft Excel 365 VBA Training Course and are wondering about the following:

• You don't know what course to take!
• You have no idea of your skill level.
• You are wanting training for your team.

Then we'll be happy to help you choose or design a course that suits you. We can come to you but should you want to get away to do the Microsoft Excel 365 VBA Training Course then the offices we use in Hammersmith are at:

Hammersmith
Crown House
72 Hammersmith Rd
Hammersmith
London W14 8TH

An ideal location for your Microsoft Excel 365 VBA Training Course Beginners training course. The training centre is situated in the heart of west London between Hammersmith and Kensington.

The building, Crown House, is bright and modern with large windows giving the training course location a spacious, airy and comfortable feel. Within easy walking distance of Hammersmith High Street.

The training course location is close to major roads, local bus routes and several London Underground stations the closest being Barons Court.

There are many other computer training courses in Hammersmith & Fulham available. Please see if there is a course for you.

Hammersmith is a lively area with a thriving arts scene, including the famous Hammersmith Apollo.

Course Duration: 1 Day

Course Prerequisites for your training in Hammersmith

• 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

You may also be interested in:

Microsoft Excel PowerPivot 365 Training Course - Beginners

Microsoft Excel 365 Training Course - Advanced

Microsoft Excel Power BI Training Course - Beginners

Power BI DAX Training Course - Beginners