MS Office Excel Intermediate Training Course (1 Day In-Company)

Overview

By the end of this course you will be able to use some of Microsoft Office Excel’s more advanced features to calculate more complex calculations.

Virtual training option available.

Objectives

You will be able to correctly use Range Names to make your formula easy to understand
You will be able to add protection to all or part of your spreadsheet so that your formulas cannot be changed
You will be able to work with formulas across multiple worksheets
You will be able to correctly use the Paste function to help you create more complex formulas
You will be able to correctly use the IF function to create calculations based on a condition
You will be able to correctly use AutoFilter to quickly filter data

Who should attend?

Anyone with a good basic knowledge of Microsoft Office Excel ideally gained from attending a basic course and / or you have been using the package for at least six months.

Testimonials

Enjoyed the programme and met some great people in the process
Birmingham, Oct 2017

Very thorough, very well conducted and detailed where required
– Edinburgh, July 2018

Brilliant programme, should be rolled out throughout the company

All the training programme was beneficial

Really enjoyed it, as well as getting other peoples opinions, it has given me a focus for moving forward – Thank you!

I’m looking forward to returning to the office with the fresh ideas and developing a stronger team

MS Office Excel Intermediate Training Course (One Day In-Company)

In-House and Virtual Training and Coaching

In-Company Training