Intermediate Microsoft Excel 2016 Training Courses

JMD Training and Consultancy
4.7
5 reviews
  • During the past couple of years, we have been using JMD training for external courses. The level of training that our employees have had has always been to the highest standard. JMD have been continually flexible with the courses that we ask and will tailor them to suit the needs of our business. Employees who always evaluate the course they attend have expressed how much they have enjoyed the training, the tutor explaining things in a way that they can relate to in their day to day working environment and will always attend to any need or concerns that they have with reference to exam/Assessments. JMD are very approachable and efficient in any dealings that we had had with them.
    ← | →
  • During the past couple of years, we have been using JMD training for external courses. The level of training that our employees have had has always been to the highest standard. JMD have been continually flexible with the courses that we ask and will tailor them to suit the needs of our business. Employees who always evaluate the course they attend have expressed how much they have enjoyed the training, the tutor explaining things in a way that they can relate to in their day to day working environment and will always attend to any need or concerns that they have with reference to exam/Assessments. JMD are very approachable and efficient in any dealings that we had had with them.
    ← | →
  • Wonderful course – thoroughly enjoyed it and learnt heaps
    ← | →

Course

In Twickenham

£ 295 VAT inc.

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Location

    Twickenham

  • Start date

    Different dates available

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

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

Facilities

Location

Start date

Twickenham (Middlesex)
12 Northcote Road, TW1 1PA

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.7
excellent
  • During the past couple of years, we have been using JMD training for external courses. The level of training that our employees have had has always been to the highest standard. JMD have been continually flexible with the courses that we ask and will tailor them to suit the needs of our business. Employees who always evaluate the course they attend have expressed how much they have enjoyed the training, the tutor explaining things in a way that they can relate to in their day to day working environment and will always attend to any need or concerns that they have with reference to exam/Assessments. JMD are very approachable and efficient in any dealings that we had had with them.
    ← | →
  • During the past couple of years, we have been using JMD training for external courses. The level of training that our employees have had has always been to the highest standard. JMD have been continually flexible with the courses that we ask and will tailor them to suit the needs of our business. Employees who always evaluate the course they attend have expressed how much they have enjoyed the training, the tutor explaining things in a way that they can relate to in their day to day working environment and will always attend to any need or concerns that they have with reference to exam/Assessments. JMD are very approachable and efficient in any dealings that we had had with them.
    ← | →
  • Wonderful course – thoroughly enjoyed it and learnt heaps
    ← | →
100%
4.6
excellent

Course rating

Recommended

Centre rating

Lynne McAvoy

5.0
02/05/2017
What I would highlight: During the past couple of years, we have been using JMD training for external courses. The level of training that our employees have had has always been to the highest standard. JMD have been continually flexible with the courses that we ask and will tailor them to suit the needs of our business. Employees who always evaluate the course they attend have expressed how much they have enjoyed the training, the tutor explaining things in a way that they can relate to in their day to day working environment and will always attend to any need or concerns that they have with reference to exam/Assessments. JMD are very approachable and efficient in any dealings that we had had with them.
What could be improved: Nothing.
Would you recommend this course?: Yes

Lynne McAvoy

5.0
02/05/2017
What I would highlight: During the past couple of years, we have been using JMD training for external courses. The level of training that our employees have had has always been to the highest standard. JMD have been continually flexible with the courses that we ask and will tailor them to suit the needs of our business. Employees who always evaluate the course they attend have expressed how much they have enjoyed the training, the tutor explaining things in a way that they can relate to in their day to day working environment and will always attend to any need or concerns that they have with reference to exam/Assessments. JMD are very approachable and efficient in any dealings that we had had with them.
What could be improved: Nothing.
Would you recommend this course?: Yes

Janet Pether

4.5
20/01/2017
What I would highlight: Wonderful course – thoroughly enjoyed it and learnt heaps
What could be improved: Nothing bad.
Would you recommend this course?: Yes

Jordan T.

5.0
15/02/2016
What I would highlight: Good facilitator, easy to follow
What could be improved: Nothing.
Would you recommend this course?: Yes

Teresa Chan

4.0
12/02/2016
What I would highlight: Janet’s product knowledge is excellent and very approachable and helpful
What could be improved: Everything OK.
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 14 years

Subjects

  • Microsoft
  • Microsoft Excel
  • Excel 2016
  • Excel for Accounting
  • Excel table
  • Excel Sheet
  • Excel Formula
  • Excel
  • MS Excel
  • Microsoft excel training

Course programme

Review of formulas

Using BODMAS
Autosum
Absolute cell references
Percentages of totals
Editing

Data - naming cell ranges in a worksheet, the Name Manager, importing text files, using Paste Special options
Formatting - applying formatting to a cell range by the use of styles, creating custom number formats, using conditional formatting options
Display - inserting a new worksheet, renaming a worksheet, deleting a worksheet, adding colour to worksheet tabs, formatting worksheet backgrounds, freezing row and/or column titles, splitting worksheet window into panes, freezing panes, hiding/unhiding rows and columns, hiding/unhiding worksheets, grouping and ungrouping worksheets
Using subtotalling features
Linking - Linking data within a worksheet, between worksheets and between workbooks, link charts within a worksheet, between worksheets and between workbooks, linking to a word-processing documents, consolidating data in adjacent worksheets using a 3D sum function
Charts and graphs - Changing angle of pie chart slices, formatting chart axes numbers or text, re-positioning title, legend or data labels in a chart, 'exploding' all the segments in a pie chart, adding or deleting a data series in a chart, modifying the chart type for a defined data series, widening the gap between columns or bars in a 2D chart, inserting an image in a 2D chart
Functions

Resizing the Formula Bar, Formula AutoComplete
Using date and time functions: TODAY, DAY, MONTH, YEAR
Using mathematical functions: SUMIF, SUMIFS, ROUND
Using statistical functions: COUNT, COUNT, COUNTBLANK, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS
Using Flash Fill
Using financial functions: FV, NPV, PMT, PV, RATE
Using lookup functions: IF, AND, OR, ISERROR, ISNA
Using nested functions
Excel tables

Creating an Excel table
Editing an Excel table
Table quick styles
Inserting and deleting rows and columns in tables
Sorting
Using the AutoFilter with tables
Totals
Removing duplicate rows from worksheets
Creating a dropdown list for table entry
Structured references

Additional information

Course Type Cost per day
1 to 1 training £295
2 to 4 delegates £455
5 to 8 delegates £595
Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £595. All prices exclude VAT

See related categories

Intermediate Microsoft Excel 2016 Training Courses

£ 295 VAT inc.

The best Excel courses

See all

See all