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.

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.

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 training course.