If there are tasks and processes around data stored in Excel you want to automate, then this course is ideal.
For many people this is their first experience of programming, so there are no prerequisites in that direction. However, you need to be an experienced user of Excel and ideally have previously used the recording process to create basic macros.
Introduction
- What is a Macro?
- Recording & Running a Macro
- Relative References
Assigning Macros to Buttons and Objects
- Assigning a Macro to a Button or a Drawn Object on a Sheet
- Assigning a Macro to a Button on a Toolbar
- Customising a Toolbar
- Creating a Toolbar
- Button Image Editor
- Changing a Button’s Screen Tip
Editing Macros
- Visual Basic Editor
- Project Explorer
- Procedures, Inserting Comments
- Printing a Visual Basic Module
The Range Object
- Cells & Range Method, Flexible Ranges
- Virtual Worksheets, Range Contents
Workbooks and Sheets
- Activating a Workbook & Worksheet
Objects, Properties & Methods
- Controlling Objects with their Properties
- Performing Actions with Methods
- Performing Multiple Actions on an Object
Variables and Constants
- Variables, Data Types & Constants
Control Structures
- Conditional & Looping Control Structures
- Non-Structured Statements
- Sub Procedures
Controls Dialogue Boxes and Forms
- Built-In & Predefined Dialogue Boxes
- Custom, Worksheet & User Defined Forms
- Adding Form Controls
- Form Control Properties
- Control & Dialogue Box Events
- Displaying & Dismissing a User Form
Storing Information
Toolbars & Display
- About Toolbars & Menus
- Customised Menus
- Display
Debugging & Error trapping
- Errors, Break Mode: Instant Watch
- Stepping & Error Handling
Worksheet & Workbook Events
- Worksheet Object Events
- Workbook Object Events
Function Procedures
Appendix A - Naming Conventions
- User Form Controls
- Memory Variables
The course runs from 9:30am through to 4:30pm on both days. Refreshments are available from 9am.
We provide:
- Full course material
- Certificate of attendance
- 90 days post course support
- Note pad and pen
- Polos!
Also includes:
Our Norwich on-site parking (NR3 1UB) is free and situated 5 minutes walk along the river to our training centre at St James Mill. If you arrive by train it is about 20 minutes on the Riverside walk or a short taxi ride to get to us. View full directions for Norwich and all our other venues.
You will learn in a relaxed environment with a small group of up to 8 people. A specialist tutor will guide and encourage you through all the learning necessary to develop your skills and questions are always welcome.