Zero to VBA/Macros Expert

HomeZero to VBA/Macros Expert
 

Zero to VBA/Macros Expert

***PLEASE NOTE: OUR PUBLIC TRAINING FOR Q1 AND Q2 2018 IS SOLD OUT FOR THIS COURSE ***
For those who work with Excel daily and would like to get a lot more done with Excel in less time.

Course length: 1 day (9.15am – 4.30pm)
Location: London, venue details confirmed closer to date
Course Objective
This is a very focused introduction to VBA and Macros by the end of which you will have enough skills to start saving time on everyday tasks you carry out with Excel.

£380.00

Clear
SKU: ct3 Category:

Description

***PLEASE NOTE: OUR PUBLIC TRAINING FOR Q1 AND Q2 2018 IS SOLD OUT FOR THIS COURSE ***
Reminder of what Excel is
We begin all our sessions with the question, what Excel is confused for, what Excel really is and how to get the most out of Excel for your work.
Benefit: Rather than jumping from feature to feature and learning arbitrary Excel skills, we want to take a few minutes to establish clear goals with Excel so we can get the most out of it.

Finding Data (Intermediate)
Using the INDEX/MATCH combination which is arguably the most powerful way to find the data you need, Using Data Validation to put useful restrictions on cells and to build drop down lists, Mastering one of Excel’s greatest functions: The Autofilter.
Benefit: As data becomes more extensive, we need to up our game for wading through it and finding what we need, the techniques you learn here will go a long way in doing that.

Dealing with Non-Numerical Data (Intermediate)
Cleansing external text data with CLEAN, Removing extra spaces with TRIM and Fixing capitalisation of words with PROPER. Introduction to text formulas such as LEN, LEFT, RIGHT, MID and SEARCH to so we can do more effective analysis of names in our work.
Benefit: Not glamourous work but very necessary to ensure that our data will stand up to the analysis and summarising we need to do with it later.

Treating Data with Rules (Intermediate)
Nesting IF Formulas for to create various outcomes for data such as project RAG status, Combining IF with VLOOKUP for powerful automated analysis, a powerful technique for automatically updating a ‘top 10’ list with just formulas.
Benefit: Sophisticated methods for getting insights from more and more data.

Summarising Data (Intermediate)
Pivot Tables in 15 minutes, Using Conditional Summarising formulas SUMIF/COUNTIF for quick flexible results, Taking Autofilters to another level with SUBTOTAL, Conditional Formatting introduction and using formulas in conjunction to make the most out of visual automation.
Benefit: Wider summarisation techniques will help to communicate our data seamlessly.

Goal of course: Build a Dashboard
Using all the technique from this session, we will put together a living breathing Dashboard with real world value.

60-minute Q & A with Instructor (Optional)
Delegates can stay back and ask questions, reinforce skills learned over the day and get guidance on implementing the skills in your actual work. You are encouraged to bring in any files report you work on for input on improving them.

Additional information

Date

09/02/2018 – London, 13/03/2018 – London, 19/02/2018 – London, 20/01/2018 – London, 28/03/2018 – London

FAQ's

What is VBA
Visual Basic for Applications is the programming language used to control Excel and other Microsoft applications automatically. When you can control Excel programmatically then you can get tasks done in seconds instead of minutes/hours. The benefit to your company is huge.

I am not very technical minded; will this go over my head?
Not at all, this course has succeeded in teaching programming to very non-technical people. It’s designed with a proprietary curriculum that avoids jargon and focuses on the most important aspects of controlling Excel.

What skill level do you need to be at with Excel?
This is not for beginners in Excel, it’s an intense but transformative course. You should be an experienced, though not necessarily advanced user of Excel.

What are the prerequisites for this course?
The more advanced you are the better but you should be comfortable with Finding data with VLOOKUPS, Sorting Data, Charts and Conditional Formatting. If you are not entirely confident, we will give you access to online materials that will prepare you for the course as soon as you register for the course. Our Beginner to Intermediate course prepares you well.

What skill level do you need to be at with Excel?
This is not for beginners in Excel, it’s an intense but transformative course. You should be an experienced, though not necessarily advanced user of Excel.

What are the prerequisites for this course?
The more advanced you are the better but you should be comfortable with Finding data with VLOOKUPS, Sorting Data, Charts and Conditional Formatting. If you are not entirely confident, we will give you access to online materials when you register that will prepare you for the course. Our Beginner to Intermediate course prepares you well.

Will I forget these skills?
This is a very real occurrence for many delegates who don’t get a chance to use their skills. We have countered this in two ways:
1. Our curriculum focuses on teaching only the most useful practical Excel skills. It has been designed by Sohail Anwar who has 10+ years of using Excel in consulting for major organisations. The course material and teaching approach has been extensively tested on over 1000 students and refined over the last 5 years.
2. We have a strong support aspect which is detailed below.

What kind of support is there for delegates?
At the end of each day there will be an extensive open-ended Q & A with the instructor. The instructor will have some one on one time which each delegate and after the course the instructor will follow up with each delegate with a progress check and a recommended roadmap to improve skills further. Delegates will also get e-mail /forum support for up to a year afterwards.

Who is the ideal attendee?
This is for Analysts, PMO’s, Portfolio Analysts, Management Accountants, Finance Business Partners, Finance Analysts and Controllers with at least intermediate level Excel skills.

Which sectors is this course suitable for?
The approaches have been proven over dozens of projects/organisations in Finance, Energy, Retail, Pharma, Consulting and Public Sector.

Which version of Excel will be used?
We will be using Office 365 which is equivalent to Excel 2016, however you are welcome to bring your own laptop providing your version of Excel is at least 2007.

Will the course have breaks?
Yes, there will be two short breaks and a 30-min lunch break. All food and refreshments will be provided by us.

Where is the venue?
We will let you know the venue details closer to the actual course date.

When does the course start?
We recommend getting to the venue for 9am with a strict 9.15am start. The course will go on till 4.30 pm with an optional 60minute Q & A after with the instructor where delegates can get further guidance.

Can you deliver the course at our company’s premises?
Yes, please get in touch and we can arrange an on-site course, fully tailored to give maximum benefit to your company.

Our promise to you:

If you have taken the time and cost to learn from us then us will make the most of that time, we will ensure the skills you learn will give you a great return on your efforts.

What we’ve found is that the more things we try to teach in one day the more overwhelmed people become and retention of the skills diminishes quickly. So, the goal isn’t to teach you lots of things but to really focus on the few key things that will have the biggest impact to you and your company when you go back in to work the next day.

Following the session, if you are not happy about the training, you can get in touch with us within 30 days and we can arrange for you to attend another course free of charge or issue a full refund.