advanced excel courses london

Public Excel Training Courses

Learn Excel at our  public  Excel Training courses which cover  all levels of Excel all year around at our London training rooms.      Read More…

advanced excel courses london

Online Excel Training Course

Learn Excel   with a  personalized Online Excel Video  Course  with your own Tutor, personalized study plan and timetable.    Read More…

courseimage copy

Group Online Excel Course

Our Group  Online Excel Training Course is an easy and cost effective  way to train your staff in Microsoft Excel. Why not try out our Free Trial.   Learn More…

desk_bgr_dark
Group Online excel course

Quick Video tour of the course


Personalized Online Excel Training Course.

 

For Individuals and Groups

To learn  Excel at your own pace and  concentrate on what you need to know  for your own particular job, try our personalized online Excel Video Course,  available on your laptop,  tablet or  smart phone 24/7.

Our Online Excel course includes all levels of Excel in one package.

  • Beginners Excel
  • Intermediate Excel
  • Advanced Microsoft Excel
  • Pivot tables

After joining,  your Tutor will get you to do a quick online assessment so we can  measure your current Excel  skill levels.

From this, your job position and your daily  Excel usage,  we will create a personalized program for you to follow –indicating which Excel techniques and functions to concentrate on together with a timetable to follow.

Your tutor will be available for questions and  help  until you reach your Excel Goals.

Our course has over  200 five to ten minute high Definition videos created by experienced tutors who mix theory with practical examples of every day tasks.

You can take an online Exam at the end of each Level  to get up to 4  different Excel Certificates to  prove to employers your level of knowledge.

The course covers Excel versions 2007, 2010 and 2013.

Cost: £157 for one year access to all modules.

Learn More


Our 2 day Excel Public Course.

 

Location: Central London.

If you prefer an instructor led public course then our 2 day intensive  Excel training course will bring your basic Excel skills up to Advanced Level.
Held in a modern  training environment in Southwark, central London. Each student will have use of PC as the course is very proactive. You can expect

  • Small class sizes.
  • Modern training conditions.
  • Hot meal at lunchtime.
  • Certificate of completion.
  • Six months email support
  • Courses cover both Excel 2007, 2010 & 2013
  • Post Course Support with Free access to our  Excel e-learning centre with over 100 videos & case studies.
Learn More


Train your Staff with our Group Online Excel course.

 

Productivity Savings  occurring as your staff progress through the course.
Administrator Dashboard to monitor the progress of your team in real time.
Each employee gets their own unique logon  username & password.
Suitable  for all your staff as our course gives access to all levels of Excel.
Full Email support to all your employees  as they study the course.
All Login accounts and group administrator account  will be set up for you.
Web based so No IT integration required.
Test their understanding with online assessments.
learn excel online

Why choose online excel training for your business

Measure Effectiveness

Measure your staffs’ progress via online assessments and employees can replay the videos again and again, if necessary.

Productivity Increase

Each student will will save up to 30 minutes per day by being more efficient in Excel, that’s nearly  12 working days per year.

No Installation headaches.

As a web based training system, there’s no IT integration required and no time spent organizing training, as we set up everything for you.

Save Money

Online training provides a cost effective alternative to traditional classroom based training, with no lost working days or travel expenses.

Excel Online.

Excel Training Course Syllabus .

Overview of Excel

Title Level Duration
Preview
What can Excel do? Beginners 7 mins monitor
Excel Ribbons and commands Beginners 22 Mins
What different in Excel 2013 Beginners 12 Mins

Beginners Excel Training Course

Title Level Duration
Preview

Inputting & Formatting:

All types of Formatting,especially number and currency formatting will be covered in this Excel courses online. Also shows you how to delete formats correctly and how Excel views Formatting.

Beginners Excel Online. 9 Mins

Introduction To Excel Formulas:

Shows the difference between a Formula and a Function. This module’s of our online Excel training course emphasis is that Formulas ,like Functions simply automate a ‘Human Process’. Viewing it from this point of view makes Formulas and Functions must easier to understand. This module in our online Excel training course finishes by providing a simple but powerful Two step method to create even complex formulas.

Beginners Excel training London
11 mins

monitor

Introduction to Excel Functions:

This Beginners Excel training course explains what Functions are and how to use them to their full potential. Covers the SUM,AVERAGE,MIN, MAX and COUNT Functions.

Beginners Excel Course London
12 Mins

Linking Worksheets & Workbooks:

An extremely important Excel skill to learn in our Excel training course: As in real life workplace situations, data is kept in different worksheets and workbooks. This module shows various methods to access data from different worksheets & workbooks.

Beginners Excel Training Course London
14 Mins

Learn Excel:
Controlling Your Worksheets & Workbooks:

This module in our beginners online Excel training course will teach you how to freeze rows and columns, split your screen, size and hide your rows and columns. Also how to rename, move or copy your worksheets.

Excel Course Beginners London
11 Mins

Printing Your Worksheets and Workbooks:

Everything you need to know about printing your worksheets and workbooks.

Beginners Excel Course London 8 Mins monitor

Protect your Spreadsheets:

Its vital,especially if others will be using your spreadsheets that they are protected fully to insure integrity of your data. This module in our online Excel training Course shows you how.

Beginners Excel

Important Excel Concepts

Title Level Duration
Preview

Fundamental Excel Concepts:

Probably one of the most important module in our online Excel training course. I am always amazed that so many Excel courses online only give a few minutes to these concepts. This module explains the concepts of ‘Relative Reference’, ‘Absolute Reference’ and using ‘Cell references”. There is no point going any further in the course until you have mastered these three concepts. They are the very oxygen of Excel.

Intermediate Excel Course
19 Mins

Named Ranges In Excel:

We will show how to create proper lists or databases in Excel. What is an Named range and how to create them?

Intermediate Excel Training Course London
9 Mins

Excel Tables

Like the above modules this is another essential module you need to master, especially if your work in Excel involves analyzing large chunks of data. What is an Excel Table ?. How to create and use them and how they differ from ordinary lists and Named ranges.

The key points is that if you add data to the end of ordinary Excel lists, your Lookup Functions, your Named Ranges or your Pivot Tables will not automatically pick them up. The module will explain the answers and solutions to all these important questions

Intermediate Excel Training London
17 Mins

Excel Techniques

Title

Level

Duration

Preview

Conditional Formatting:

Conditional formatting allows you to format a cell or cells if a certain condition or conditions are met.
We will learn about the various conditional formatting methods including data bar, color scales and icon sets based on criteria like traffic lights. In the Advanced level, we will study how to combine conditional formatting with
formulas.

Excel Course Intermediate London
20 Mins

Data Validation:

A lot of heartache can be avoided by using data validation techniques in your spreadsheet.
For example, if a cell requires a date, you can program that cell only to take a date, with it also flashing a warning notice to your users, ensuring data integrity.

Intermediate Excel Training London
12 Mins

Drop Down Boxes:

Drop-down lists should always be used in Excel if users have to input ‘constant data’ as only that data on the list can be chosen. This ensures data integrity. We will show various ways to create these drop-down lists.

Intermediate Excel training London
7 Mins

Consolidate Data:

This technique will show how to consolidate data from various worksheets into one worksheet using the consolidation Tool.The great thing is that the data
can be of different length.

Intermediate Excel Course London
9 Mins

Error Types explained and How to handle them?

This section explains the various Excel errors types you might meet and how to handle them.Perticular attention is given to the powerful IFERROR Function with plenty of examples.

Intermediate Excel Training london
12 Mins

Formula Auditing:

Mistakes will occur in the best of spreadsheets. This module goes through the various formula audting techniques available to help you find these errors.

Intermediate Excel Course london
11 Mins

Form Controls

You can use software components like check boxes, combo boxes, spinners etc in your spreadsheets. Here you will learn how to create and manipulate these controls to give greater flexibility to your spreadsheets and forms.

 Advanced Excel Course London 18 Mins

The Camera Tool In Excel:

You can take a picture of your data in Excel by using the camera tool. We will also use this tool later on when creating dynamic and interactive charts.

Beginners Excel Course London
4 Mins

Hyperlinks in Excel:

You can go to another worksheet by clicking on a hyperlink.These can be very useful if you a large number of worksheets and need to access them quickly. In this module, we will build such an example.

Beginners Excel Training London
4 Mins

Templates In Excel:

This module will show how to create Excel Templates, which can be used again and again. Various Templates are built to illustrate the required techniques.

Intermediate Excel Course
20 Mins

The SubTotal Tool:

If you need to subtotal your data by various categories, this is a great tool to use. This module shows you how.

Excel Beginners Course
9 Mins

Charts in Excel

Title Level Duration
Preview

Introduction to Excel Charts:

Learn about the various chart types in Excel, when you use each one and how to create and format them.

Excel Beginners Course London
12 mins

Solutions to common Chart Problems:

This module will show how to tackle many of the common problems you might encounter. For example, if one data series value is much lower that the other values, it won’t be seen clearly in your chart.The solution to this and other problems will be shown in this video.

Excel Intermediate Course london
17 Mins

Solutions to common Chart Problems: Part Two

More charts solutions including automatically highlighting the largest data series, formatting charts with negative values and others.

Excel Intermediate Training london 15 Mins monitor

Dynamic Charts In Excel:

Techniques to create dynamic charts , very useful if space is an issue and for using in dashboards.

Excel Intermediate Course london 12 Mins

Interactive Charts In Excel:

Create charts which allow your users interactive with your charts.Great for comparative purposes. We build a few examples.

Intermediate Excel Course london 11 Mins

New Chart Features in Excel 2013.

In this module,we will learn about the new chart features introduced in Excel 2013.

Intermediate excel training london 6 Mins

Intermediate Functions

Title Level Duration
Preview

The IF Function: The First Work-Horse Function.

In most work-place spreadsheets, two Functions can often accounts for over 50-60% of the functions used. They are Excel’s two work-horse Functions, the IF Function and the VLOOKUP Function. The IF function allows you automate decision making processes in Excel.
You will learn how to use the IF Functions and see it’s usage in various workplace situations. Special attention will be given to maximize its use by incorporating the three Essential Excel concepts. In the advanced section of the course, we build up the power of the IF Function by learning about nested IF functions and the AND & OR Functions.

Excel Intermediate Course
15 Mins

The VLOOKUP Function: THE Second Work-Horse Function.

Imagine I asked you to look up 100 phone numbers in a paper-based phone book? What would you do? Firstly, you would notice that the book was sorted alphabetically , you would then search for the name and when you found it , you would move your eyes over the relevant record until you found the telephone number.
Well that’s what the VLOOKUP Function does. It just automates that human process of searching for a value in a record. But it will do the job in a fraction of a second.
Now imagine if all the thousands of pages of the phone book was mixed up. It could take you a week to find those 100 phone numbers but even that’s no problem to the VLOOKUP Function, it will still get you those 100 phone numbers in a fraction of a second.
This module will show you how to understand and build powerful VLOOKUP Functions in various situations. It will also explain the common problems that occur with VLOOKUP Functions.

Excel Intermediate Course London
19 Mins

The SUMIF & COUNTIF Functions: Two Useful Lieutenants

These two functions are very useful. They allow you to add or count items based on a condition. How many sales did Mary make and how much revenue occurred from these sales. The COUNTIF Function is
also used a lot in combination type functions. We will show you how to use these Functions with plenty of examples of using them in real life workplace
situations. In the advanced course, we will meet a new relation of these
Functions, the SUMIFS and COUNTIFS Functions. They arrived in the Excel 2007 version and are Functions you need to master, as they allow you to add or count items for Not just one condition but up to 100 conditions.

Excel Intermediate Course london
17 Mins

Working with Text:

This module shows how to manipulate Text in Excel. It looks at the’ &’ concatenate operator and the main Text Functions like LEFT, RIGHT, LEN,MID and FIND, STUBSTITUE Functions. These can be very handy if you need to clean up your text in Excel to make it ready for further analysis. It gives plenty of examples of these in use –like extracting a name or a city from an address text string.

Excel Intermediate Course London
26 Mins

Dates and Date Functions:

This module helps you understand dates in Excel, that they are just Numbers.We will then learn about the various date functions like DATE,DATEVALUE, WORKDAY, EOMONTH etc with plenty of reallife examples.

Excel Intermediate Course London
11 Mins

Time and Time Functions:

Learn to understand Time in Excel and the various Time Functions.

Intermediate Excel training london
7Mins

Excel Intermediate Test and Certification:

Advanced Excel Functions

Title Level Duration
Preview

INDEX & MATCH Functions: Dynamic control over all your Data.

The INDEX and MATCH Functions along with SUMIFS and SUMPRODUCT are the most important advanced type functions.
The INDEX and MATCH Functions when combined do everything that the VLOOKUP Function can do but more.

Unfortunately the VLOOKUP Function can only search from Left to Right from the first column in your defined table but the INDEX and MATCH Functions when combined can search from Right to Left or Left to Right from any column in your table. To be able to extract data from your table dynamically ,no matter where it is, you need to master these two Functions.

Advanced Excel course london
16 Mins

The SUMIFS, AVERAGEIFS AND COUNTIFS Functions.

We have already met the SUMIF & COUNTIF Functions but these only allow you test for one condition .
These new Functions, which came in the Excel 2007 version allow you to test for up to 100 conditions. Very powerful dynamic reports can be created from using these new functions. We will show you how to use them and also show their use when your data is in a Excel Table Format.

Excel Advanced London
15 Mins

SUMPRODUCT Function: Your First Glimpse of Arrays:

The SUMPRODUCT Function, does as it says , its sums the various products.

This Function is different from all the other functions you have used before because its takes a range of cells(array) as an argument.

This module will show you how to use this function with many examples but it will also introduce a very important advanced technique on how to deal with arrays in Excel. Once you get your mind around this techniques you will have no problem dealing with any array formula in Excel.

Excel Advanced Course London 14 Mins

OFFSET & INDIRECT Functions:

If you want to ask Excel to move from a certain cell to another cell by itself and then grab some cells from this cell point, then call on the OFFSET Function. We will show practical examples of this Function in use and show how to build your own powerful OFFSET Functions.

The great practical use of the INDIRECT Function is that it can accept a text sting as a cell reference. This is great for creating dynamic ranges. We show many practical uses of this function in this module.

Advanced Excel Training London
12 Mins

Nested IF Functions with AND & OR Functions:

We will in this module build powerful nested IF Functions with AND & OR Functions, to create complex automatic decision making processes in your spreadsheets.

Advanced excel course london
15 Mins

ARRAY FORMULAS IN EXCEL.

Study the module on the SUMPRODUCT Function before you start this module.

In this module we will learn what is an Array and an Array Formula with examples of them in use in practical commercial situations. We will show how to create and use an Array Formula and look again at the important concept of Conditional Evaluation in an Array Formula.

Excel Advanced Training london
17 Mins

Custom Formatting

In this module, we will learn how to create customized formats.

Advanced Excel london 15 Mins

Excel Expert Test and Certification:

Pivot Tables in detail

Title Level Duration
Preview

Overview of Pivot Tables:

Examples of what Pivot tables can do. Using a large data set, we will create various reports showing what you can achieve with Pivot tables. You will learn about the various ribbons and each Pivot table command button.

Advanced Excel course London
10 Mins

Pivot Table Formatting:

Master the techniques to format your pivot tables.

Advanced Excel course London 7 Mins

How to summarize Pivot table Values:

By default, Pivot Tables sums values.In this module we will learn how to summarize these values by averaging, counting , maximizing and minimizing them.

Advanced Excel course London 6 Mins

Pivot Tables : Show vales as:

This section show how to manipulate the values in your Pivot Tables. By default, a pivot table sums values up. We show how to show these values in different ways. See your values as percentages, in relation to other subtotals, differences from other time periods etc

Pivot table course London
14 Mins

Pivot Table Pictures:

In this module, we will learn how to take pictures of your pivot tables, maybe you want to insert them into a PowerPoint Presentation or a Word Document.

Pivot table course London 2 Mins

Grouping Pivot Table data:

This module explains how we can group data in to bespoken group. We will especially look at the very important technique of grouping dates as most data has a date field.

Pivot table course London 10 Mins

Understanding the Pivot table cache:

We will see in this module that Pivot tables are automatically created from the same internal memory. This can cause problems especially if you are grouping data, as changing the grouping of a set of values will change all the others groupings in your other pivot tables. We will show you how to create independent Pivot tables.

Pivot table course London 7 Mins

Calculated Fields in Pivot Tables:

We can create new calculated fields in our Pivot Tables based on existing data. This module explains all you need to know.

Pivot table course London 15 Mins

Calculated Items in Pivot Tables:

Learn about Calculated Items in Pivot tables. What they are, how to create them, how to use them and pitfalls to look out for.

Pivot table course London 9 Mins

The GETPIVOTDATA Function in Pivot Table:

Pivot data is quiet volatile and it is quite difficult to grab data from pivot tables for further analysis. We will show in this module a possible solution to this problem whereby we can populated per-formated reports from our live Pivot Tables.

 

Pivot table course London 18 Mins

New Pivot table Features in Excel 2013:

In this module, we will examine how Pivot tables have changed in the latest version of Excel ..version 2013, in particular the new Excel data model which allows you combine data from different tables into one pivot table.

 

Pivot table course London 10 Mins
Pivot Table Certification: