Call us on:
    07477 578417

Intermediate Microsoft Excel 2013 trainingIntermediate Microsoft Excel 2019 training

We are now back to full face-to-face training at client site. We are also offering training by videoconferencing means, usually via Microsoft Teams or Zoom, if this is your preference. Click for more information about remote training.

If you’re looking for really great Intermediate Microsoft Excel 2019 training you’re in the right place.

Companies large and small choose us – why? Your own tailored, Intermediate Excel 2019 training course, at your own premises at the same price as a standard course from elsewhere.

The JMD Training difference is clear:

  • We come to you – your Microsoft Excel 2019 training will be given on your site
  • You get to keep the manuals – Intermediate Microsoft Excel 2019 training manuals are provided as PDFs
  • We can train using your own Microsoft Excel workbooks
  • There will only be people from your company on your course
  • We offer a money-back guarantee if any delegates are not completely satisfied
  • The training date is around you, not us!
  • Our prices are astounding
  • We can assess all learners in advance for free
  • Our courses are never cancelled

Training locations

Our Microsoft Excel training courses London, are available not only in London, but Surrey, Middlesex, Richmond, Twickenham, Hounslow, Kingston, Woking, Reading, Croydon, Epsom, Banstead, Brentford, Putney, Wimbledon, Staines, Egham, Feltham, Farnham, High Wycombe, Crawley, Sutton, St Albans, Fulham – in fact anywhere within the Home Counties and M25 corridor. We have Microsoft Excel trainers in Twickenham, Richmond, Ashstead, Lightwater, Ascot, Central London, New Barnet, Ilford, Surbiton, Slough, St Albans, Bushey, Crowthorne, Basingstoke, etc! If you are based within 30 miles of any of these locations we would not charge travel expenses for the trainer. We can still provide Microsoft Excel training courses outside these areas but would then need to charge for the travel expenses of the Excel trainer.

Request Course Now »

Course Type Cost per day
1 to 1 training £315
2 to 4 delegates £495
5 to 8 delegates £645

Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £645. All prices exclude VAT.

Provisional course outlines:

Visit our blog If Only I’d Known That,; we have called it that because we hear it so many times in training sessions. In fact, if only we had an extra £100 for every time someone says “If only I’d known that.” …. There are many useful hints and tips about using Microsoft Word on the blog; why not visit it to find out how many you knew!

Organisations who have benefitted from our Intermediate Excel training include:

“Janet’s style was excellent, including outstanding knowledge.”

Ray Barrett, Hampton School

Aims of the Intermediate Excel 2019 course

This course aims to give delegates a greater understanding of MS Excel 2019.

Course Objectives

On completion of the course delegates will have improved their skills in using Microsoft Excel 2019. They will be able to:

  • Manipulate worksheets
  • Use templates
  • Apply conditional formatting
  • Use various functions, including logical and date/time functions
  • Manage Excel databases and tables
  • Customise charts
  • Use Excel in conjunction with other applications

The course is of one day’s duration.

How the course is run

This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.


Familiarity with the Windows environment, and a basic knowledge of Excel.


  • Revision of basic formulas
  • Using absolute cell references

Manipulating Worksheets

  • Renaming worksheets
  • Inserting worksheets
  • Deleting worksheets
  • Freezing row and/or column titles
  • Splitting worksheet window into panes
  • Hiding/unhiding rows and columns
  • Grouping and ungrouping worksheets
  • Copying data between worksheets
  • Formatting multiple worksheets in one operation
  • Entering a formula to link related worksheets


  • Applying templates
  • Editing templates
  • Creating templates


  • Applying number formats
  • Creating conditional number formats
  • Using conditional formatting
  • Flash Fill


  • The IF function
  • Nested IF functions, IFS
  • The TODAY function
  • NOW function
  • COUNT functions
  • TEXT functions

Excel databases and tables

  • Creating an Excel table
  • Sorting
  • AutoFilter
  • SORT and FILTER functions
  • Filtering data
  • Totalling and manipulating filtered data
  • Grouping and outlining
  • Creating subtotals
  • Data validation


  • Plotting non-contiguous data ranges
  • Pie charts
  • Adding new data to an existing chart
  • Chart formatting techniques

The Quick Analysis button and how it relates to the above topics

Use of Excel with other applications

  • Paste special options
  • Linking vs Embedding
  • Linking data from other worksheets
  • Linking data from other applications
  • Exporting to other applications

Request Course Now »

We provide Microsoft Excel training courses, Microsoft Office training courses, other IT training courses and Personal Development training courses in London, Richmond, Twickenham, Kingston, Hounslow, Brentford, Putney, Kingston, Wimbledon, Walton-on-Thames, Chiswick, Teddington, Hampton, Feltham, Acton, Ealing, Heathrow, Egham, Staines, Reading, Croydon, Epsom, Banstead, Hanwell, Sunbury, Hammersmith, Fulham, Greenford, Clapham, Chertsey, Woking, Weybridge, Wandsworth, Middlesex, Surrey, the M25 corridor, High Wycombe and beyond. We will travel further if expenses are covered.

For Microsoft Excel training courses Sydney, Australia, please visit our sister site