Intermediate Excel Training Modules

Intermediate modules

Our intermediate Excel modules are aimed at individuals who have some previous knowledge of Microsoft Excel but need to develop their understanding further.

These modules are designed to provide you with a strong grounding in core Excel functions and formulae. As with all of our bespoke Excel courses we tailor the content to your specific needs and where possible work with examples based on your own data.

Our bespoke modular approach to Excel training allows you to tailor your Excel course by selecting only the modules that are relevant to you.

 

Intermediate Excel Functionality

Module title Duration (hrs)
Conditional Formatting 1.5
Tables 1.5
Pivot Tables 1.5
Named Ranges 1.5
Data Validation 1.5

 

Intermediate Excel Functions

Module title Duration (hrs)
Logical functions 1.5
Summing based on conditons 1.5
Lookup functions 1.5
Working with text 1.5
Days, dates and times 1.5
Error management functions 1.5

Advanced Excel Training Modules

Advanced Excel ModulesOur advanced Excel modules are aimed at individuals are already experienced in using Excel within their roles but need to learn specific advanced Excel functionality.

As with all of our bespoke Excel courses we tailor the content to your specific needs and where possible work with examples based on your own data.

Our trainers use Excel for modelling and analysis every day whilst providing solutions to client's specific needs. They can share their wealth of knowledge gained from using Excel in business to ensure that you apply best practices when working with Excel spreadsheets.

Our bespoke modular approach to Excel training allows you to tailor your Excel course by selecting only the modules that are relevant to you.

Alternatively we can design a tailored course for you by discussing your role and business needs.

Advanced Excel Modules

Module title Duration (hrs)
What if analysis 1.5
Auditing Spreadsheets 1.5
An Introduction to VBA 1.5
Structured Reference Formulae 1.5

 

Advanced Excel Courses

Module title Duration
Spreadsheet Best Practice 1 day
Financial Modelling - The FAST Level 1 certificate 2 days
The FAST Level 1 certificate - 1 day fast track
1 day

 

Money Back Guarantee

For your piece of mind

Money back guarantee


"I cannot praise the instructor highly enough. Our requirements for the training were clearly reviewed, discussed and tailored to a group of very different abilities. Pacing, delivery and passion for the subject and level of knowledge was excellent.

The instructor used his knowledge and experience to advise how we could apply improvements to our existing ways of working. Thank you."

S Sewell, Defra


HHP

"We have spent a long time looking for the right training company to deliver our excel training.

In Clarity we found just what we were looking for - tailor made excel training for each and every one of our employees. Not only did we get excellent excel training at all levels, but they also understood how we were using excel in our work, making the sessions much more relevant.

We would highly recommend Clarity and will certainly continue using them in the future."

Bettina McLean, Senior Associate, Hamilton Hotel Partners Ltd


“My team and I found our bespoke Excel training course covered everything we had requested and more.  It was perfectly pitched for the various abilities in the group and the materials are very useful.

Our trainer was very knowledgeable and able to work with our real life scenarios as well as the course content examples.”

Sally Lawrance, Senior Marketing Manager, Kohler Mira Ltd


 

"Thank you so much for the bespoke Intermediate / Advanced Excel course that you carried out on-site at Zuken.

The training was for myself and one other person and was delivered friendly and efficiently. It was well organised and our trainer was really great at adapting it to each of our individual needs. He assisted us in applying the new techniques to  some of our existing reports and this has really helped reduce time in our day to day reporting.

I would certainly recommend Clarity to anyone wanting Microsoft Excel training and will not hesitate to use you again."

Katerina Banwell, UK Accountant, Zuken UK Ltd


"Excellent bespoke training course and has progressed my knowledge of Excel immensely. Good training materials and knowledgeable tutors. Have used on a couple of occasions and will definitely use again in the future."

Russell Beake, Financial Planning & Analysis at Mercer Ltd


"Truly bespoke training that accommodated our different knowledge levels and was excellent value for money."

Dawn Batchelor, Business & Finance Manager, Prospects Services Ltd