The UK's Leading Professional Training & Business Solutions Provider

Email or CALL NOW on 01952 581550

Excel Level 3 Gurus

Course Overview

On this TWO HALF DAY course you’ll learn how to use Logical functions to work out ‘What IF’ questions. We cover The 5 Most Popular Math and Statistical Functions for Geeks but in a way that makes them easy to understand and conquer! Financial, Date and Time Functions and Array Formulae, together with VLOOKUP, (and it’s new replacement XLOOKUP) will ensure you’ve got all the tools to manipulate Advanced Formula.

You will cut down on data entry errors with Advanced Data Management; cover Importing and Exporting Data into Excel, how to use built in Analytical Tools like Goal Seek and Solver and finally discover how to cut down repetitive tasks by creating your own Macros.

The ability to use advanced formulas will set you apart giving you that all important edge in knowledge and skills enabling you to do your work faster and more effectively.

Course Content

  • Become an Excel Expert using Logical Functions to work out ‘What IF’ questions. We cover 5 Popular Math and statistical functions but in a way that makes it easy to understand and conquer!
  • Want to speed up data entry on your spreadsheets? Then validating cell entries is one lesson you won’t want to miss. Build Drop Down lists, data entry conditions like ‘not before date’ and fix how many characters can be input. A sure-fire way to cut down data entry errors!
  • If you need to know how to use Financial, Date and Time functions and Array formulas, you’re on the right course!
  • Now we’re uncovering some of Excel’s best kept secrets such as how you can use Goal Seek and Solver to find the answer to your business questions! Take a peek at the Analysis ToolPak and see how you can easily create ‘Scenarios’ to show different ‘What if’ situations and choose the best options.
  • Need to know the fundamentals of VLOOKUPs? Take a first peek at the new replacement for VLOOKUPS XLOOKUP! We’ll make sure you understand all the essentials and give you some great examples. Depending upon your needs we may also cover creating Data Tables.
  • You know you’re on your way to being an Excel Guru when you can create macros in Excel. We’ll even show you some of the behind the scenes VBA code and how to use functions within your Macros.
  • Need to be a whizz at Exporting and Importing files? If you work with external databases and want to manipulate that data in Excel this lesson is for you!
  • Hands-on exercises and demonstrations help you gain in-class practice creating engagement programs. Take-home your very own Microsoft Certified Manual to help extend your learning beyond the class as you apply what you have learned back in your job.

We offer various Live Online training courses so please get in touch if you are interested in a different topic!

Who is this for?

This TWO HALF DAY course is specifically designed for office workers, managers, accountants and data analysts. Delegates on this course should have existing Intermediate knowledge of Excel, and we will turn you into an Excel expert.

How much does it cost?

£300 + VAT per person on Public course dates

     
Imagine Training Ltd is rated 5 out of 5 based on 1425 reviews from around the Web.
2020-02-06
     
I thought the training day was great, everything that was taught was done in a very professional way and was spaced out well with plenty of time to get a good understanding of everything that was being shown. Getting involved with the learning helped massively with understanding and remembering everything we was being taught. I would definitely recommend this course to my colleagues.
2020-01-10
     
Excellent as per all imagine courses I’ve been on. Would highly recommend people to attend.
2020-01-29
     
Excellent course.
2019-12-10
     
Very good course and very informative. I would recommend it fully to others, worthwhile to put all staff through this training.
2020-01-28
     
I will be more in depth when doing my PC work and using the shortcuts.