Mastering Microsoft Excel 2019 - Intermediate - Online Training Course - CPDUK Certified
Mastering Microsoft Excel 2019 - Intermediate - Online Training Course - CPDUK Accredited.
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)
