Mastering Microsoft Excel 2019 - Intermediate - Online Training Course - CPDUK Certified

The Mandatory Training Group
Delivery Method: eLearning

Mastering Microsoft Excel 2019 - Intermediate - Online Training Course - CPDUK Accredited.

Mastering Microsoft Excel 2019 - Intermediate - Online CPD Course - The Mandatory Training Group UK -

Welcome to The Mandatory Training Group's online Mastering Microsoft Excel 2019 intermediate training course. All our online training courses, programmes and qualifications are accredited by the CPD Certification Service (CPDUK).

Mastering Microsoft Excel 2019 - Intermediate

This intermediate training course will teach you the features of Microsoft Excel 2019. Kathy Jones will train you to use links, lookup functions, data validation, macros and data tables.

Course Content

This online Mastering Microsoft Excel 2019 Intermediate training course includes the following:

  • Unit 1: Working with functions
  • Unit 2: Working with lists
  • Unit 3: Analysing data
  • Unit 4: Visualising data with charts
  • Unit 5: Inserting graphics
  • Unit 6: Using pivot tables and pivot charts.

Who is this course for?

This Mastering Microsoft Excel 2019 intermediate e-learning course is suitable for learners who have a working knowledge of Excel 2019 or Excel 365 but want to use more complex functions and features to analyse data.

Course aims

The aims of this Mastering Microsoft Excel 2019 intermediate eLearning course aims to:

  • Develop your skills needed to organise lists, create multi-layered and interactive reports.
  • Broaden your knowledge on how to use links, lookup functions, data validation, macros and data tables

Learning objectives

On completion of this Mastering Microsoft Excel 2019 intermediate e-learning course, the learner will be able to:

  • Create and use named ranges
  • Insert functions into spreadsheets, including: Date and Time functions, Logical functions, Text functions, Math functions, Database functions, Subtotals, and nested functions
  • Sort and filter column data
  • Create and modify tables, and apply advanced Conditional Formatting
  • Create and modify charts and graphics
  • Apply advanced charting tools
  • Create a Pivot Table for the group and summarise data
  • Apply advanced Pivot Table features, create a Pivot Chart, and filter data using Slicers and Timelines.

Learning outcomes

Once you have completed this online Mastering Microsoft Excel 2019 intermediate training course, the learner will be able to:

  • Create multi-layered, interactive reports
  • Use formulas and functions.
  • Create and modify charts.
  • Convert, sort, filter, and manage lists.
  • Insert and modify illustrations in a worksheet.
  • Work with tables.

Download Full Course Description (PDF)

Mastering Microsoft Excel 2019 - Intermediate - Online Training Course - The Mandatory Training Group UK -

Mastering Microsoft Excel 2019 - Intermediate – Online Training Course - CPDUK Accredited.

Book Now Make Enquiry

Write A Review Of Mastering Microsoft Excel 2019 - Intermediate - Online Training Course - CPDUK Certified

eLearning
£47.99 (inc VAT)
Book Now Make Enquiry Add To Wishlist
All prices include VAT where applicable