Computer Tutoring Logo
Est. 2002
Menu Button

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
Total Price:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

First Name:

Last Name:

Email:

Tel:

Location:

Num Students:
First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.

Testimonials

The Frank Lee Centre

"Really Good. I felt very at ease and comfortable considering it was only me, and I actually enjoyed it!"

EasyJet Airline Company

"Very helpful."

"Excellent course- Well prepared, well delivered."

Lotus Cars

"Great- would Recommend."

Greenfinch

"A very flexible course, the trainer adapted the course to our specific needs."

Microsoft Excel 2016 Training Course Intermediate

Lists, lists, lists it seems as if the whole world is a bundle of lists. It doesn''t matter what industry you are associated with you will need to analyse and present data. You don''t have to have attended the beginners Excel training course to join this one. However being a little familiar with Excel will, of course, be a great help.

Other Excel training courses

Course Duration: 1 Day

Course Prerequisites:

A working knowledge of Excel is recommended before taking this course. If you aren't using Excel regularly may we recommend that you look at taking our Excel 2016 Beginners training course beforehand.

If you know the following you will be very helpful to you:

  • Entering data in cells
  • Editing data
  • Performing basic calculations
  • Understanding Functions SUM, AVERAGE

Course Outline

Working with Functions in Excel 2016

  • Work with Ranges
  • Use Specialised Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions
  • VLookup, Index Match Functions

Working with Lists

  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data

Analysing Data in Excel 2016

  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting

Visualising Data with Charts

  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features

Using PivotTables and PivotCharts

  • Create a PivotTable
  • Analyse PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Timelines and Slicers in Excel 2016

Intermediate Excel Prices from:

If you are interested in this course but want to know the price beforehand then use the the following form to calculate how much.

Number Students?
Laptop hire?
Offsite training?

Per Person £ *
Total Price:
£ .

Duration:
1 Day

* Price is exclusive of VAT.

If you are interested in this course fill out the following form for further details:

First Name:

Last Name:

Email:

Tel:

Location:

No. Students:

First NumberPlusSecond Number  = 
Please enter the answer to prove that you are human and not a machine.

There are many other courses you could take from this point on. Especially with regard to data analysis and manipulations. Please take time to check out the following courses.

Green Pivot TablePower Pivot Training Course - Take your Pivot Tables to the next level with our introduction Power Pivot training course. If you feel that your Pivot Tables and/or Pivot Charts are someone limited then this is the course for you.


Power BI training course - If you have the data you need prepared but need more appetising charts, graphs and other visualisation to make your data palatable then look no further than a Power BI training course.



Microsoft Excel 2016 Training Course Intermediate