Menu

    Call us on:
    07477 578417

Microsoft Advanced Excel 2016 trainingMicrosoft Advanced Excel 365 Training Courses

We are now back to full face-to-face Advanced Excel 365 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 Advanced Microsoft Excel 365 training you’re in the right place.

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

Uncover the power of pivot tables to transform your large data sets into meaningful reports. Learn more complex functions and formulas. We can explain the mysteries of “What-If Analysis”. You will be taught how to write a simple macro. We will show you how to protect particular cells, worksheets or workbooks to save people inadvertently overwriting the formulas you have so painstakingly created. Your trainer will also demonstrate auditing a workbook to look for errors. This will help you work out which cells are included in any formula.

The JMD Training difference is clear:

  • We come to you. Your Microsoft Advanced Excel 365 training will be given on your site
  • You get to keep the manuals. Microsoft Advanced Excel 365 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

Visit our blog If Only I’d Known That,. Ee 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.” ….

Clients who have benefitted from our Advanced Excel 365 training include:

“All the information and shortcuts taught were made relevant to spreadsheets used in the business on a day to day basis which will be extremely useful for my future use of Excel” – Annabel Nash, Lateral Property Group

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:

If you are new to Office 365, you may also be interested in our Office 365 upgrade training, workshops and floorwalking

Our Microsoft Excel training courses London, are available not only in London, but Surrey, Middlesex, Richmond, Twickenham, Hounslow, Brentford, Putney, Wimbledon, Staines, Egham, Feltham, Farnham, High Wycombe, Crawley, Sutton, St Albans, Fulham , etc. In fact, we train Microsoft Excel 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.

“The most fun Excel has ever been.”

Cath Day, GAME

Aims of the Advanced Excel 365 course

This course aims to give delegates an in-depth knowledge of Excel 365 features.

Course Objectives

On completion of the course delegates will have advanced skills in using Microsoft Excel 365. They will be able to:

  • Use a variety of Excel functions
  • Name cells and ranges
  • Successfully manipulate workbooks
  • Audit a worksheet
  • Create and use PivotTables and reports
  • Use Solver, Scenario Manager and Goal Seek tools
  • Create and use macros

 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.

Pre-requisites

Familiarity with the Windows environment, and a reasonable knowledge of Excel. Prior attendance of the Intermediate Excel course would be an advantage.

New Features in Excel

  • Quick Analysis Tool
  • Flash Fill
  • New Functions
  • Using the new Charting features
  • Maps
  • 3D Maps
  • Stocks and Geography Data Types and other Linked Data Types
  • Forecast Sheet

Excel Functions

  • IF, NESTED IF, IFS
  • AND, OR
  • SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, MAXIFS, MINIFS
  • VLOOKUP, XLOOKUP
  • IFERROR
  • TEXTJOIN
  • TODAY, DATEDIF, DAYS
  • COLUMN,ROW
  • INDEX, MATCH
  • UNIQUE
  • TEXTJOIN

Naming Cells and Ranges

  • The Name Box
  • Using names instead of absolute cell references
  • Using names across worksheets
  • Using the Name Manager

PivotTables and Reports

  • Creating an Excel table
  • Creating a PivotTable report
  • Creating a PivotChart report
  • Grouping data in a PivotTable
  • Refreshing data
  • Filtering pivot data
  • Row and column details
  • % of Total
  • Creating new fields
  • Slicers
  • Timelines
  • Show report filter pages
  • Adding tables to the data model

 Auditing a worksheet

  • Tracing errors
  • Tracing dependents
  • Tracing precedents
  • Adding, removing and editing worksheet comments
  • Displaying all formulas in a worksheet

Data Analysis Tools

  • Sparklines
  • Using one-input or two-input data tables
  • Goal Seek
  • Solver
  • Scenario manager

Manipulating workbooks

  • Custom views
  • Applying and removing worksheet and workbook protection
  • Data Consolidation

Macros

  • Recording macros
  • Running macros
  • Editing macros
  • Running macros from keyboard shortcuts
  • Adding a macro button to the Quick Access toolbar

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, 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.