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 Word Intermediate

Word Intermediate

Edinburgh 4 Queen Street, Edinburgh, 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...

Adobe Illustrator

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom +2 more

IT and Adobe Training Workshops AVAILABLE IN GLASGOW & EDINBURGH ON DEMAND - PLEASE CONTACT US FOR MORE DETAILS Adobe Illustrator For Individuals who are new to illustrator or have...

Event Series Word Introduction

Word Introduction

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

For individuals who have never used a word processing package before or have only used Word for limited tasks. At the end of the day, you will be able to...

Event Series Time Management

Time Management

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

This workshop is ideal for anyone who wishes to improve their self-managing techniques, achieve more in their working day and gain more balance in their lives. Spending 1-day learning how...

Event Series Management Skills

Management Skills

Glasgow First Floor 82 Union Street, Glasgow, 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, manage others...

Event Series Excel Intermediate

Excel Intermediate

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

For individuals who are already using Excel, this course will streamline and perfect their Excel skills by teaching the more intermediate features available in the application. What you will learn:...

Testimonials

Upcoming Events

Calendar of Events

M Mon

T Tue

W Wed

T Thu

F Fri

S Sat

S Sun

0 events,

1 event,

1 event,

2 events,

0 events,

0 events,

0 events,

2 events,

2 events,

Adobe Photoshop

Event Series

2 events,

1 event,

0 events,

0 events,

1 event,

2 events,

2 events,

2 events,

1 event,

0 events,

0 events,

1 event,

3 events,

Adobe Illustrator

Event Series

2 events,

1 event,

0 events,

0 events,

2 events,

1 event,

2 events,

0 events,

0 events,

0 events,