Microsoft Excel Automtion Training Course
Save Time & Money with Excel Automation
Want to save hours, if not days, when working with Excel?
Discover how relatively simple this can be with our Excel Automation Course!
Most of us who work in Excel do what we call repeatable tasks. Each Day, Week
or Month we clean up the same data, merge the same files or create the same report.
Each time the process is the same but with different data.
Wouldn’t it be great if we could get Excel to do most of that repeatable work for us?
The good news is that we can, and we don’t need to be Computer Programmers to
achieve it either!
By combining Excels Advanced Tools of Power Query and Macros (VBA), this
course will expose you to the timesaving world of Excel Automation.
There are 2 versions of this course:
A 1-day Public Course and a 2 or 3-day Onsite Course.
In both cases the full course content is covered in 1 day by using generic solutions. The benefit of the onsite course is that on the remaining day(s) we focus on your company’s actual automation requirements and help you to automate your very own Excel Processes.
I would just like to thank Mark for his support over the training sessions, the team are totally pumped at what they learnt and are already putting it into practice which is saving them hours if not days of time.
– Patrick Mason, Kerry Ingredients
What you'll learn: MS Excel Automation Training Course
MACROS - VBA
What are Macros and VBA?
Recording a Macro
Tips and Tricks on Recording a Macro
Stepping through a Macro
Editing a Recorded Macro
VBA Code Snippets
Manipulating VBA Code Snippets
VBA Coding Basics
Objects, Properties and Methods
Object Hierarchy and VBA Context
Declaring and using Variables
Implementing basic loops and If statements
What is Power Query?
Connecting to various Data Sources
Manipulation of Source Data
Working with the Manipulated Data Table
Merging and Appending Data
Troubleshooting Connection Issues
FROM SOURCE TO REPORT
Integration with PowerPoint and Word
Report Version Control
VBA or Power Query?
2020 Course dates TBC
Course Costs (excl. VAT):
1-Day Automation: R2 270
3-Day Advanced & Automation: R6 250
PUBLIC & CORPORATE ONSITE EXCEL TRAINING
DATA ANALYSIS, REPORTING & EXCEL SPECIALISTS
DEMO VIDEOS & RECAP SHEETS SUPPLIED
ACCESS TO WEBINAR'S
& EXCEL TIPS
SOLUTIONS BASED TRAINING WITH REAL LIFE EXAMPLES