merger merger

Welcome to your new course portal!

On October 15th, hotcourses.com moved to findcourses.co.uk - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show findcourses.co.uk as: Mobile

Microsoft Excel 2016 / 365 Intermediate

Focus on Training
Course summary
2 hours
595 GBP excl. VAT
English
Open / Scheduled
Next available date: 28/11/2019 - Leeds
Course Dates
Leeds
28/11/2019   (English)
595 GBP
16/12/2019   (English)
595 GBP
London
16/12/2019   (English)
595 GBP
16/01/2020   (English)
595 GBP
Reading
09/01/2020   (English)
595 GBP

Course description

Microsoft Excel 2016 / 365 Intermediate

The goal of this course is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyse data in spreadsheets, such as sorting, filtering, conditional formatting and auditing. You will also organise table data and present data as charts. You will discover how Excel spreadsheets are constructed and be given a clear path on how to create templates. The course emphasises hands-on experience, with a series of self-guided exercises integrated into the training.

Please note this course contains a taster session on PivotTables. Detailed training on this subject is covered in our Microsoft Excel 2016 / 365 Advanced course.

Suitability - Who should attend?

Target Audience

This course is aimed at end users who have taken the following course or have equivalent knowledge: Microsoft Excel 2016 Introduction / 365 Introduction.

This course is suitable for users of Microsoft Excel 2016 or 365 subscription editions.

For more information Visit University Website.

Training Course Content

Learning Objectives

Participants will learn how to:

  • Calculate with advanced formulas
  • Audit formulas using the auditing tools
  • Work with Excel tables
  • Organise worksheet data so that data can be sorted and filtered
  • Create and modify Charts
  • Create Excel templates
  • Apply Conditional Formatting
  • Analyse data with Recommended Pivot Tables

For more information Visit University Website.

About provider

Focus on Training

Focus on Training: Best Practice Skills from the Specialists

Focus on Training is a professional training company specialising in offering accredited Project Management and IT programmes. With over 10,000 courses offered in over 100 locations throughout the United Kingdom, Focus is a premier training provider. All programmes can be booked online...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Microsoft Excel 2016 / 365 Intermediate.

  Contact the provider

  Get more information

  Register your interest

Contact info

Focus on Training

Olympus House, Werrington Centre
PE4 6NA Peterborough

 Show phone number
www.focus-on-training.co.uk


Request Information

Find out more about this Microsoft Excel 2016 / 365 Intermediate course - simply fill out your details:

Reviews

There are no reviews available yet.

U.K. L&D Report: 2019 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!

uk-ld-report-2019

Learn more