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 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: Formula – Vlookups, IF Statements, SumIf, CountIf, Text formula, Concatenate, linking spreadsheets. Utilities – Protecting data, hide and unhide data, named ranges, working with dates,...

Event Series Time Management

Time Management

Edinburgh 4 Queen Street, Edinburgh, 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 to manage your time – will save you hours! What you will learn: To take an objective look at how you spend your time at...

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 our certified Adobe Instructor. Classes are small group sessions guaranteeing time for practical training and questions and feedback from our tutor. What you will learn:...

Event Series Influencing Skills

Influencing Skills

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

The aim of this course is to learn how to develop and apply the skills of influential communication. What you will learn: To understand how we are influenced. How to tailor your communications for different people and situations. To communicate confidently and with purpose. How to put across complex ideas in simple, understandable ways. How...

Event Series Report Writing

Report Writing

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

This 1-day workshop will help you choose the correct style and tone for a report and clearly define your purpose. It will revisit the key principles of grammar, punctuation and spelling and is aimed at anyone involved in writing on behalf of their employer, and those for whom reports are or will be integral to...

Event Series Excel Intermediate

Excel Intermediate

Edinburgh 4 Queen Street, Edinburgh, 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: Formula – Vlookups, IF Statements, SumIf, CountIf, Text formula, Concatenate, linking spreadsheets. Utilities – Protecting data, hide and unhide data, named ranges, working with dates,...

Personal Development Workshops – Assertiveness

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

Assertiveness This workshop is about helping you recognize your own type of behavior and how you come across to others. It will help you to identify situations in which you would like to be less aggressive or less passive and learn how to be assertive in these situations. The course will show you how to...

Event Series Power BI Intermediate

Power BI Intermediate

Edinburgh 4 Queen Street, Edinburgh, 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 enterprise business intelligence (BI) that’s easy to use and helps you gain deeper data insight. What you will learn: Design a data model. Introduction to...

Event Series Excel Advanced

Excel Advanced

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

For Individuals who already use Excel to an Intermediate level. This course will teach you how to use Excel to analyze, collaborate and validate with Advanced features and tools which are extremely useful for auditing and streamlining your workflow. What you will learn: Macros – Editing and deleting macros, recording macros, customizing ribbon. Review Data...

Event Series Communication Skills

Communication Skills

Edinburgh 4 Queen Street, Edinburgh, United Kingdom

This practical workshop is ideal for those who need to build effective working relationships or depend on effective communication in critical situations. It will also benefit those who would like to develop their own skills and confidence in communication generally. What you will learn: Practical verbal and non-verbal communication The importance of rapport and how...

Microsoft Project Introduction

Glasgow First Floor 82 Union Street, Glasgow, United Kingdom

For Individuals who have never used Project. The course is designed to cover all aspects of Project at an Introduction level; to provide you with a good overall grasp of the application – it’s different areas, features and how these can be adapted within a working environment. What you will learn: Project Environment – Starting...

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 and informal meetings. How to set out an agenda. Tips and techniques for note taking. The role of the minute taker What minutes are and...

Testimonials

Upcoming Events

Calendar of Events

M Mon

T Tue

W Wed

T Thu

F Fri

S Sat

S Sun

2 events,

Microsoft Project Complete – 2-day course

Event Series

Project Management Principles

Event Series

1 event,

- Event Series

Better Business Writing

2 events,

- Event Series

Management Skills

0 events,

0 events,

0 events,

0 events,

3 events,

Adobe Photoshop

Event Series
- Event Series

Time Management

- Event Series

Excel Intermediate

2 events,

- Event Series

Influencing Skills

- Event Series

Report Writing

2 events,

- Event Series

Excel Intermediate

0 events,

0 events,

0 events,

1 event,

- Event Series

Power BI Intermediate

2 events,

- Event Series

Communication Skills

- Event Series

Excel Advanced

2 events,

- Event Series

Microsoft Project Introduction

- Event Series

Meetings and Minutes

2 events,

- Event Series

Time Management

- Event Series

PowerPoint Introduction

1 event,

- Event Series

Word Introduction

0 events,

0 events,

0 events,

2 events,

Executive PA – 2-day workshop

Event Series
- Event Series

Power BI Introduction

2 events,

1 event,

- Event Series

Telephone Techniques

0 events,

0 events,

0 events,

0 events,

4 events,

Train the Trainer – 3- day workshop

Event Series

Adobe Illustrator

Event Series

Train the Trainer – 3- day workshop

Event Series
- Event Series

Excel Introduction

1 event,

- Event Series

Excel Intermediate

0 events,

0 events,