Microsoft Excel 2016 Intermediate - Online CPD Training Course & Certification

The Mandatory Training Group
Delivery Method: e-Learning

Microsoft Excel 2016 Intermediate - Online CPD Training Course & Certification

Learners will gain a fundamental understanding of the Microsoft Excel 2016 environment and the ability to complete tasks independently. This online Microsoft Excel 2016 Intermediate training course will help learners know and demonstrate the correct application of the principal features of Microsoft Excel 2016.

Study method - Online, self-paced (4-6 study hours)

Course format - Online (24/7 access), modular

Course Duration - Part-time (1 year access)

Qualification - Certificate of completion

Course Delivery – via desktop PC/MAC, laptops, tablets or smart phones

Awarded Body – CPD Certification Service

Objectives: You will be able to:

    • Explain the importance of named ranges
    • Write nested functions
    • Create and modify tables of data
    • Develop visuals on your table, based on the data, using conditional formatting
    • Organize large amounts of data into smaller, more specific tables using PivotTables

What is covered in this Microsoft Excel online training course?

If you learn to use Microsoft Excel 2016 Intermediate, you will start to see how useful it is in your life – from formatting your grocery list to calculating complex ROI values. If you are just getting started with Excel, let our Microsoft Certified training course walk you through the basics of what you need to know.

This Microsoft Excel 2016 Intermediate online training course covers the following modules and content:

    • Working with Named Ranges and Tables
    • Using Logical, Text, Date, and other Functions
    • Sorting, Filtering, and Summarizing Data
    • Creating PivotTables and Pivot Charts
    • Using Conditional Formatting
    • Adding Slicers and Timelines to Analyze Information

The World Is Filled With Two Kinds Of People:

"A Handful Of People Who Are Masters Of Excel, And The Millions Of Others Who Wish They Were."

This is our most requested Microsoft training course. If you have mastered Microsoft Excel 2016 Intermediate, then you have one of the most practical and valuable skill sets in all of modern business.

Quickly Search For And Find The Skills You Want To Master – Then Just Point, Click, And Learn

Who is this Microsoft Excel 2016 Intermediate online training course for?

This Microsoft Excel 2016 Intermediate online training course is suitable for anyone who wants to improve their knowledge of Microsoft Excel 2016. These skills will enhance their knowledge and employability opportunities.

This Microsoft Excel 2016 Intermediate online training course can be purchased as an individual course or as part of our integrated Microsoft Office programs.

Course accreditation

The content of this Microsoft Excel 2016 Intermediate online training course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines.

Why train with The Mandatory Training Group?

The Mandatory Training Group is the leading UK provider of accredited Microsoft Office training courses and programs. All our training materials are developed by fully certified Microsoft Office instructors with extensive industry experience.

Microsoft Excel 2016 Intermediate - Online CPD Training Course & Certification
Microsoft Excel 2016 IntermediateMicrosoft Excel 2016 Intermediate - Online CPD Training Course & Certification - The Mandatory Training Group UK -
Book Now Make Enquiry

Write A Review Of Microsoft Excel 2016 Intermediate - Online CPD Training Course & Certification

e-Learning
£83.99 £35.99 (inc VAT)
Book Now Make Enquiry Add To Wishlist
All prices include VAT where applicable