Home Courses Enquiries Online Training Testimonials Locations Prices

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:

Testimonials

Anixter Ltd

"Very good, enjoyed the course!" "Interesting and enjoyable"

Blaby District Council

"The trainer.. had the ability to explain in a clear and concise manner and had a deep knowledge of excel but kept his training very relevant to the group. The course did not feel rushed or pressured and there was no feeling of embarrassment if more help or explanation was needed. The trainer offered assistance at every stage and was able to explain in a way that was relevant. His diction and pace were perfect."

Bokomo Foods (UK) Ltd

"Informative & engaging" "Very good & well presented"

Bokomo Foods Ltd

"Very good, the trainer kept our attention throughout"

Print & Desktop Publishing

Apple

Presentation

Online Videos

Locations

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.

If you have Excel 365 then this is the course for you.

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.

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

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 Table Power 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 raining course.