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.
I would like to receive training special offer emails
I would like to be notified about free software hints and tips

Testimonials

Huxley Bertram

"Very good, Alan made it fun and interesting. I now want to apply some of what he showed us today. It should be extremely useful".

Fontus Health Limited

"An enjoyable day and Simon was very professional and approachable."

Middlesbrough Council

"Excellent. Learnt lots of new knowledge on Excel."

Motorplus

"Good fun easy to learn and great trainer very friendly and approachable"

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

Sharing Files via Office 365

  • Sharing your workbook - the Office 365 way
  • Using Excel Online

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.

I would like to receive training special offer emails
I would like to be notified about free software hints and tips



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