Cost Calculator

Price per head:

£ .

Duration:

1 Day

* Price is exclusive of VAT.

Tell Me More

Testimonials

Ottolenghi Ltd

"I found the basic excel training useful and excel cheatsheet is very handy. I learnt some new things from the exercise and looking forward to the next session. "

Balfour Beatty

"Great course, trainer was very interactive and enthusiastic."

GKN Aerospace

"Very informative and fun energy. I really enjoyed it and will be able to use what I leaned."

Prominate

"Excellent, informative, fun and engaging. Learnt a lot!"

"It was excellent. Easy to follow, engaging, structured and delivered with humour and patience."

Locations outside Oxford

Microsoft Excel 2016 Training Course Intermediate Oxford

Oxford Intermediate Microsoft Excel 2016 Course Overview

Intermediate Microsoft Excel 2016 Training Course training course in Oxford - Radcliffe Camera

The university town of Oxford. They say that people go to Cambridge to study science, and Oxford to study politics. Whatever the reason, Oxford a fantastic place to conduct your Intermediate Microsoft Excel 2016 Training Course training course.

Other training courses in Oxford.

Oxford, the City of Dreaming Spires, is famous for its prestigious university and beautiful architecture.

Course Duration: 1 Day

Course Prerequisites for your training in Oxford

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

Complete Course Outline

Working with Formulas in Excel Intermediate 2016

Conditional Functions
If Function
Flash Fill
VLookup
Loan Repayment (PMT Function)

Working with Tables

Creating Tables
Using Functions with Tables
Sorting Data in Tables
Adding & Deleting Rows
Converting Table back to a Range

Working with Charts in Excel 2016

Creating Charts
Formatting Charts
Formatting Individual Parts of the Chart
Changing Font Size
Moving the Title or Legend
Creating Charts with non-adjacent Data
Moving a Chart to a different Sheet
Data Labels

Pivot Tables

Creating a Pivot Table from existing data in Excel
Formatting Pivot Table Data
Renaming the Pivot Table Headers
Filtering and Sorting Data in Pivot Tables

Graphic Objects

Inserting Images
Modifying Pictures
Smart Art
Organisation Chart
Drawing Shapes
Stacking Order and Grouping

Customising the Excel Environment

Customising Workbooks
Colour Schemes
Default Number of Sheets
Manage Themes
Create and Use Templates
Creating Templates
Using Templates
Editing Templates
Sharing Files

Have a look at our range of Excel Training Courses

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.

Other related courses:

Microsoft Excel 2019 Beginners Training Course

Microsoft Excel 2016 Training Course Beginners

Microsoft Excel 2016 Training Course Advanced

Microsoft Excel Pivot Tables Training Course Beginners