Microsoft Excel 2019 – Part 1

About the Course

The course offers an exciting and innovative approach to Excel training. It 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 1

Your details

Training Centre

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 how to use the core features of Excel 2019, such as how to create and format worksheets, use functions, create formulas, and more.

Is this course for you?

The course is designed for those who wish to learn how to use this powerful spreadsheet program. You will learn the key concepts and techniques necessary to work with Excel’s most commonly used features and functions.

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: Introduction to Excel

The Excel 2019 Window; Mouse Basics in Excel; Backstage View.

Module 2: Creating Workbooks

Entering Text and Numbers; Creating Basic Formulas; Relative References; Order of Operations; Working with Ranges.

Module 3: Saving and Sharing Workbooks

Saving a Workbook; File Extension; Sharing, Exporting, and Publishing Files.

Module 4: Navigating Workbooks

Opening Files; Working with Larger Files; Creating Freeze Panes; Split Screen

Module 5: Page Setup and Print Options

Headers and Footers; Print Titles; Working with Comments; Page Setup Options; Printing Workbooks

Module 6: Working with Rows, Columns, and Cells

Adding and Deleting Rows, Columns, and Cells; Changing Column Width and Row Height

Module 7: Moving Data

Cut, Copy, and Paste; Copying Formulas

Module 8: Formulas and Functions

Overview of Formulas; Creating Formulas Using Functions; Using Absolute Values

Module 9: Working with Sheets

Adding, Deleting, Renaming, and Grouping Sheets; Additional Sheet Tab Options; 3-Dimensional Formulas

Module 10: Formatting Worksheets

Formatting Cells; Formatting Numbers; Borders and Shading; Formatting a Range of Cells as a Table; Using Styles and the Format Painter; Protecting Sheets; Using the Fill Handle and Creating Custom Lists

Course Overview

Aims and Objectives

The aim of the course is for you to learn the core features and functions of the Microsoft Excel 2019 spreadsheet application, so that you will be effective in creating and manipulating spreadsheets.

Career Path

Microsoft Excel is used across a wide range of job roles; learning this spreadsheet program will demonstrate your commitment to continuing professional development and help towards your career progression opportunities.

Pre-Requisites

Familiarity with the Windows environment and experience using a computer keyboard.

Communication Skills

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

Effective communication is key in every situation we find ourselves in, whether it is work related or in our personal life. We all know or work with people, whom we...

Event Series Supervisory Skills

Supervisory Skills

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

Supervisory Skills – Tutor Led Get better results from your team. Would enhanced supervisory skills be of benefit to you or any other of your employees? Are you a supervisor...

Leadership Skills

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

As you develop as a senior manager you need to start to think and handle yourself very differently. You are even less involved in the day to day delivery of...

Excel Introduction

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

For individuals who have never used the Excel spreadsheet package before or have only used Excel for limited tasks. At the end of the day you will be able to...

Telephone Techniques

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

The telephone gives you the opportunity to make a positive first impression of both yourself and your company. Think of the many times you have used the telephone to call...

Excel Intermediate

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

The Microsoft Excel Intermediate training course is available at the Edinburgh Pitman Training Centre. For individuals who are already using Excel to an intermediate level. This course will streamline and perfect...

Time Management

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

Are you frequently interrupted by your colleagues with questions about the job or requests for advice or decisions? Do you sometimes find yourself doing the job of one of your...

Management Skills

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

As you develop as a manager you are even less involved in the day to day delivery of the work. Your success depends on your ability to manage your team,...

Excel Introduction

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

For individuals who have never used the Excel spreadsheet package before or have only used Excel for limited tasks. At the end of the day you will be able to...

Event Series Presentation Skills

Presentation Skills

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

Talk and present with confidence and impact Do you find yourself avoiding situations where you will be asked to talk or present an idea? You know your stuff but the...

Excel Advanced

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

The Microsoft Excel Advanced training course is available at the Edinburgh Pitman Training Centre. For individuals who are already using Excel to an advanced level. This course will teach you how...

Testimonials

Upcoming Events

Calendar of Events

M Mon

T Tue

W Wed

T Thu

F Fri

S Sat

S Sun

0 events,

0 events,

1 event,

2 events,

Word Introduction

Event Series

2 events,

Assertiveness

Assertiveness

Event Series

Meetings and Minutes

Event Series

0 events,

0 events,

2 events,

2 events,

Supervisory Skills

Event Series

2 events,

Leadership Skills

Event Series

2 events,

2 events,

Time Management

Event Series

Excel Intermediate

Event Series

0 events,

0 events,

2 events,

Management Skills

Event Series

1 event,

Presentation Skills

Event Series

3 events,

Excel Advanced

Excel Advanced

Event Series

1 event,

Word Advanced

Word Advanced

Event Series

1 event,

0 events,

0 events,

2 events,

2 events,

Power BI Intermediate

Event Series

1 event,

Word Introduction

Event Series

1 event,

Word Intermediate

Event Series

0 events,

0 events,

0 events,

0 events,

0 events,

0 events,

0 events,

0 events,

0 events,

0 events,