Getting More Out of Excel™ – Advanced Functionality – Training Course Outline

If you’ve ever wanted Excel to do just that bit more for you, for example:

• process the values across a range of workbooks automatically;
• use a form to input details such as values, criteria etc.;
• use a configuration sheet to define how your formulae should behave;
• automatically create graphs;
• automatically create summary worksheets;

…then this course is for you.

If you would like to add extra functionality to your Excel spreadsheets, you can create buttons, drop-down lists, toolbars etc, and run custom code behind them to carry out pretty much any task you want.

So don’t struggle! Attend this course to learn from the experts how to improve the functionality and usability of your spreadsheets.

What you will learn on this course

By the end of the course, you will understand how to use a variety of advanced functions in Excel, including:

• Manipulating data
• Creating toolbars
• VBA coding

This course teaches the basics of VBA coding, but assumes at least a rudimentary understanding of programming concepts.

Course Duration

We can provide this course as a one-day intensive or a more interactive two-day workshop.

One-day intensive

This course concentrates on showing you, step-by-step, the process of using advanced functions in Excel. Exercises are used to illustrate various points throughout the day.

Two-day workshop

Over the two-day workshop, delegates practise the skills needed to enhance Excel, learning the techniques through group discussion, exercises and working on real examples, including those you bring to the workshop.

If you’re unsure which course is best for you, give us a call on 01635 202013 for more details or email

Course Contents

Basic concepts

An introduction to the main functionality of:

• Toolbars
• Controls
• Macros/VBA

Creating controls

• Buttons, Labels, Text boxes, Combo boxes, Check boxes

Creating and using toolbars

• Defining Custom Toolbars
• Using Custom Buttons and Menu Items
• Attaching a Toolbar to a Workbook
• Managing Command Bars Using VBA Code

Recording and running macros

An introduction to VBA coding, and an easy way to generate and run code:

• Using the Macro recorder
• Running macros
• Viewing macro code

Programming – the basics

• Functions and subroutines
• Declaring variables
• Loops
• Conditional statements
• Referencing text in Word documents
• Interacting with the user

Using the Visual Basic Editor

• Editing
• Using the project browser
• The “immediate” Window
• Debugging
• Using the object browser

Practical applications

• Interacting with controls
• Opening, closing and processing files
• Automation tasks
• Running code from toolbars

Book Now!

For details of timetabled courses, see the schedule. For prices, see the costs table.

To reserve your places you can either book on-line or call us on +44 (0)1635 202013/+44 (0)207 0960 749.