Microsoft Excel 2019 – Part 2

About the course

The course consists of 10 modules and includes media demonstrations, hands-on activities, and knowledge check questions. At the end of the course, you will complete a consolidation exercise, which will help you review what you have learned and assess your understanding.

The course also contains quizzes at the end of each module and a Validation Test at the end of the course. With successful completion of the course, you will receive a Pitman Training certificate to verify your achievement.

Microsoft Excel 2019 – Part 2

Your details

Training Centre

Hidden
Hidden
Hidden
Hidden
Hidden
Hidden

Course Info

Duration 17 hours. This will vary from individual to individual based on prior knowledge and ability.
Training Type Course
Study Type In centre, Online

Awards & Qualifications

Awarded 17 CPD points upon successful completion

Is this course right for me?

In this course, you will learn intermediate and advanced-level features of the Microsoft Excel application, such as how to create and edit charts, sort and filter data, use advanced formulas, and more.

Is this course for you?

This course is for those who are proficient with the basic concepts and features of Excel and wish to increase their productivity and enhance their spreadsheet skills using Excel’s intermediate and advanced-level features.

Awarded 17 CPD points upon successful completion
Duration 17 hours. This will vary from individual to individual based on prior knowledge and ability.

Course Content

Course Content

Module 1: Using Charts

Creating Charts; Types of Charts; Editing Charts; Using Graphics to Enhance Charts; Linking Chart Titles; Creating Sparklines

Module 2: Working with Names

Creating Range Names; Managing Names; Using Names in Formulas

Module 3: Sorting and Filtering Data

Removing Duplicate Rows; Sorting Data; Filtering Data; Using Advanced Filters

Module 4: Outlining and Subtotaling Data

Creating an Outline; Adding Subtotals

Module 5: Working with Views

Arranging Files; New Window Feature; Custom Views

Module 6: Linking Files

Creating Formulas Between Files; Working with Links; Consolidating Data

Module 7: Advanced Formula Creation

Using IF Statements; Using Functions to Look Up Data; Working with Data Validation; Formula Auditing; Using the Watch Window

Module 8: Overview of PivotTables and PivotCharts

PivotTables; PivotCharts; Slicers

Module 9: Customizing Excel

Excel Options; Customizing the Ribbon; Modifying Workbook Properties

Module 10: Additional Excel Features

Text to Columns; Conditional Formatting; Hyperlinks; the Spell Checker and Translate Features; Quick Analysis Tool; the Document

Course Overview

Aims and Objectives

The aim of the course is for you to build on your knowledge and skills with the Excel 2019 application to gain intermediate-level proficiency.

Career Path

Microsoft Excel is used across a wide range of job roles. Your new skills with the software will make your work more efficient and more valuable to employers.

Pre-Requisites

This course is the continuation of Excel 2019 – Part 1.

Event Series Speedwriting

Speedwriting

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

This course is ideal for anyone involved in taking notes at all levels in both work and personal life. The course is particularly beneficial to those for whom taking minutes...

Event Series Power BI Introduction

Power BI Introduction

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

Learn how you can leverage Power BI to easily build reports and dashboards with interactive visualizations. Connect to and visualize any data using the unified, scalable platform for self-service and...

Event Series Telephone Techniques

Telephone Techniques

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

This 1-day workshop has been developed for people who would like to improve their telephone communication skills. It is particularly aimed at those who use the telephone as an important...

Event Series Leadership Skills

Leadership Skills

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

For managers who are developing into senior leaders. You are even less involved in the day-to-day delivery of the work; your success depends on your ability to manage your managers...

Event Series Meetings and Minutes

Meetings and Minutes

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

For anyone who organizes and takes minutes at meetings and those who would like to do this role to a professional standard. What you will learn: The difference between formal...

Adobe Photoshop

For individuals who are new to Photoshop or have only used Photoshop for limited tasks. During the course you will learn the fundamentals of the Adobe Photoshop Creative Cloud from...

Event Series PowerPoint Introduction

PowerPoint Introduction

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

For Individuals who have never used PowerPoint or have only used it for limited tasks. At the end of the course, you will be able to create professional-looking presentations. What...

Event Series Word Intermediate

Word Intermediate

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

For Individuals who are already using Word to an introductory level – this course will streamline and perfect your Word skills by teaching you intermediate features available within the Word...

Testimonials

Upcoming Events

Calendar of Events

M Mon

T Tue

W Wed

T Thu

F Fri

S Sat

S Sun

1 event,

2 events,

2 events,

3 events,

0 events,

0 events,

2 events,

3 events,

Adobe Photoshop

Event Series

2 events,

2 events,

1 event,

0 events,

0 events,

3 events,

Adobe Illustrator

Event Series

2 events,

1 event,

2 events,

1 event,

0 events,

0 events,

0 events,

2 events,

2 events,

1 event,

0 events,

0 events,

0 events,

0 events,

1 event,

- Event Series

Speedwriting

1 event,

1 event,

0 events,

0 events,