Microsoft Excel 2019 – Part 1

About the Course

Experience an exhilarating and cutting-edge Excel training course that comprises ten modules encompassing media demonstrations, interactive activities, and knowledge assessments. Conclude your journey with a consolidation exercise that reinforces your learning and gauges your comprehension.

The course includes quizzes at the end of each module and culminates in a Validation Test upon completion. By successfully finishing the course, you will be awarded a Pitman Training certificate, validating your achievement.

Microsoft Excel 2019 – Part 1

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?

This course will equip you with the necessary skills to proficiently utilse Excel 2019. Discover the key features, including worksheet creation, formatting, formula implementation, and more. Enhance your mastery of Excel and unlock new possibilities.

Is this course for you?

This comprehensive course is tailored for individuals seeking to master the utilization of this robust spreadsheet program. Gain proficiency in key concepts and techniques essential for effectively harnessing Excel’s widely employed 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 course is designed to equip you with the essential skills and knowledge of Microsoft Excel 2019, empowering you to efficiently create and manipulate spreadsheets. By mastering the core features and functions of this powerful spreadsheet application, you will enhance your effectiveness and productivity in spreadsheet management.

Career Path

Microsoft Excel is widely utilised in various job roles. Acquiring proficiency in this spreadsheet program showcases your dedication to professional growth and opens doors to career advancement opportunities.

Pre-Requisites

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

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,