Microsoft Excel Macros & VBA Training Course
Our Excel Macros & VBA Course brings you up another step by giving you the ability to build your own macros and to write simple Visual Basic code. This course covers the following items:
- Record and edit macros
- Understand the Object Model
- Write Visual Basic routines
- Reuse & adapt existing code
Booking for one?
Are you looking for a public course? Browse our list of public events and book today.
Get in touch
Course can be either one day or two and a half-days duration
After completing this course you will be able to record, edit and troubleshoot macros, understand the Excel Object Model, write manually simple programming routines in the Visual Basic Editor (VBE) environment as well as reuse and adapt existing code.
Who is this Course for
This Excel Macros and VBA course is for existing Excel users with a good understanding of Excel features who need to be able to automate a variety of tasks. Note: Unfortunately, Mac users can no longer programme using VBA.
Familiarity with Excel at the intermediate level is sufficient. No prior knowledge of programming is required to attend this Excel Macros & VBA course.
Click on the headings below for more information on course topics:
Macros and Visual Basic
The Power of Excel:
Knowing Your Tools:
The Developer Tab / Macro Toolbar
Adding a Trusted Location
Overview of Recording, Storing, and Running a Macro
Understanding the VB Editor
Recording Macro Basics
Examining Recorded Macro Code:
Using the VB Editor and Help
Properties Can Return Objects
Using Debugging Tools to Figure Out Recorded Code
Referring to Ranges with Excel VBA
The Range Object
Use the Cells Property to Select a Range
Using the Cells Property in the Range Property
Use the Offset Property to Refer to a Range
Use the Resize Property to Change the Size of a Range
Use the CurrentRegion Property to Select a Data Range
User-Defined Functions in Excel VBA
Creating User-Defined Functions
Useful Custom Excel Functions
Looping and Flow Control in Excel VBA
Looping and Flow Control:
Using Variables in the For Statement
Variations on the For…Next Loop
Exiting a Loop Early After a Condition Is Met
Nesting One Loop Inside Another Loop
VBA Loop: For Each
VBA Loop : Do Loops
Flow Control: Using If…Then…Else
Flow Control: Using Select Case
Event Programming in Excel VBA
Levels of Events
UserForms in Excel VBA
Userforms in Excel:
Programming the Userform
Using Basic Form Controls
Do you feel limited with the tools you use to represent your organisation’s information? Instead of learning to use Visio confidently, are you still fumbling with Excel charts, drawing basic flowcharts with PowerPoint shapes and AutoShapes? Or are you starting from no knowledge of diagrams at all?
Learn to use Visio which is the tool you should be using by joining one of our Visio courses.
Get in touch
Create Complex Diagrams In Minutes
Developing complex professional diagrams shouldn’t take so long so why are you stumbling to present the information in your head in a compelling visual? Become an expert when you attend our Visio training courses, whatever your level and needs, and discover all the features which make your job a pleasure not a chore. Visio unleashes your creative side and gives you instant results. Learn the proper techniques and see the results quickly.
Take your Diagramming to a New Level
Once you have completed our Visio training you will be comfortable using the program and will be able to create expert level diagrams and plans with ease. So, whether you need to illustrate your processes for ISO certification or compliance regulations or simply would like to learn Visio as a way to communicate technical representations of ideas, structures, concepts, blueprints and a variety of other purposes our Visio training can do just that! So, if you have been looking for the best Visio training program around, look no further!
Learn Visio The Right Way
Learn to draw flow charts, process flow; represent information in swimlanes / cross-functional flow charts; map organisational charts; manipulate shapes and link data; create complex layouts; visualise floor plans and floor layouts; create complex diagrams and apply layers of information; bring real-time data together from multiple sources, link to Microsoft Excel and Microsoft SQL Server; manage processes with sub-processes; apply rules and logic validation; implement rules and validation; ensure accuracy and consistency across the organization; share dynamic diagrams over the web; icons and data bars; create SharePoint workflows.
Which Microsoft VIsio Training?
We offer three levels of Visio and customised training to suit your specific business needs.
- Microsoft Visio Introduction Course for those who are completely new to Visio and want an overview of the main drawing types you can create effortlessly in Visio.
- Microsoft Visio Intermediate Course for existing Visio users who can create simple drawings but need to understand the full capabilities of Visio and need to be more effective in creating large amounts of drawings quickly.
- Microsoft Visio Advanced Course for existing users with Pro versions of Visio who want to use it in multiple business environments. We talk about Visio programmability and integration with data.
- Microsoft Visio Customised for those who have specific needs and want to focus on specific drawing types, e.g. architecture, engineering drawings and diagrams.