Recommended renewal: 3 years.
Our certifications have no expiry dates, but we recommend renewing them to stay up to date with industry best practices.
Microsoft Excel 2019 for Beginner
1743 Students
Microsoft Excel 2019 for Beginner introduces the essential tools needed to create, organise, calculate, format, and manage spreadsheets. Learners explore the Excel interface, data entry, formulas, functions, worksheets, workbooks, charts, and basic data analysis. It is suitable for beginners, office workers, administrators, students, and anyone developing everyday spreadsheet skills. The course progresses into useful techniques including PivotTables, PivotCharts, lookup functions, …
Microsoft Excel 2019 for Beginner introduces the essential tools needed to create, organise, calculate, format, and manage spreadsheets. Learners explore the Excel interface, data entry, formulas, functions, worksheets, workbooks, charts, and basic data analysis. It is suitable for beginners, office workers, administrators, students, and anyone developing everyday spreadsheet skills.
The course progresses into useful techniques including PivotTables, PivotCharts, lookup functions, formula auditing, workbook protection, forecasting, templates, sparklines, and mapping data. These skills can support reporting, record keeping, data analysis, tracking information, and presenting figures clearly across Canadian workplaces.
Study online at a convenient pace with structured lessons designed to build confidence step by step. By completing the training, you can strengthen your Excel knowledge and add a valuable digital skill to your workplace toolkit, particularly for administration, finance, data entry, customer service, and office-based roles.
Key Features
- Accredited by CPD
- Instant e-certificate and hard copy dispatch by next working day
- Fully online, interactive course with audio voiceover
- Self-paced learning and laptop, tablet, smartphone-friendly
- 24/7 Learning Assistance
- Discounts on bulk purchases
Sneak Peek
Learning Outcomes
The course helps learners build confidence with Excel 2019 through a structured introduction to everyday spreadsheet tasks and data management.
- Gain understanding of Excel 2019 tools and interface.
- Understand how to organise and format spreadsheet data.
- Learn how to create formulas and use common functions.
- Develop skills in analysing and presenting data.
- Build knowledge of charts, PivotTables, and worksheets.
- Improve confidence in managing Excel workbooks.
Who Should Take This Course
This course is designed for beginners who want to develop practical Excel knowledge for study, work, or everyday data management.
- Beginners with little or no Excel experience.
- Office and administrative workers.
- Data entry and customer service staff.
- Students developing workplace computer skills.
- Small business owners managing business records.
- Employees who regularly work with spreadsheets.
Why Take This Course
Excel remains a useful workplace tool across many Canadian industries, from administration and retail to finance, education, healthcare, and business operations.
- Strengthen digital skills for Canada's job market.
- Develop useful spreadsheet and data-handling knowledge.
- Learn Excel through a flexible online structure.
- Build confidence with beginner-friendly lessons.
- Support career growth and employability.
- Add Excel knowledge to your professional development.
Job Opportunities & Salary (CAD)
Excel skills can complement many administrative, business, and data-focused roles. Salary ranges vary depending on province, employer, experience, industry, and additional qualifications.
- Administrative Assistant – CAD $40,000–$60,000
- Data Entry Clerk – CAD $38,000–$55,000
- Office Administrator – CAD $42,000–$65,000
- Accounting Clerk – CAD $42,000–$65,000
- Administrative Coordinator – CAD $45,000–$70,000
- Reporting Assistant – CAD $45,000–$70,000
Entry Requirements
The course is designed for beginners and does not require previous Excel qualifications or advanced computer experience.
- No formal qualifications required.
- Basic English reading and writing skills.
- Basic computer literacy.
- Interest in learning spreadsheet skills.
- Access to an internet-connected device.
- Suitable for beginners in Canada.
Accreditation
All of our courses, including this Microsoft Excel 2019 for Beginner, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.
CPD Accredited
All of our courses are accredited by the CPD Certification Service as conforming to universally accepted Continuing Professional Development (CPD) guidelines.
QLS Endorsed
The Quality Licence Scheme (QLS) is a trusted endorsement framework that certifies high-quality, non-regulated training programmes across various sectors.
Association of Healthcare Trainers
The Association of Healthcare Trainers (AoHT) promotes high-quality healthcare training, supporting providers to deliver relevant, industry-aligned education and improve professional standards.
Certification
Once you’ve successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost CA$9.99). All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.
↻
Course Curriculum
The detailed curriculum outline of our Microsoft Excel 2019 for Beginner is as follows
Module 1: Microsoft Excel 2019 New Features
Get familiar with the Excel 2019 environment and the features that make spreadsheet work more organised and efficient. This provides a starting point before moving into everyday Excel tasks.
Module 2: Getting Started with Microsoft Office Excel
Learn your way around workbooks, worksheets, rows, columns, cells, the Ribbon, Name Box, and Formula Bar. You will also practise entering and managing basic spreadsheet information.
Module 3: Performing Calculations
Turn Excel into a useful calculation tool by working with formulas, mathematical operators, and cell references. The focus is on building confidence with calculations rather than relying on manual working.
Module 4: Modifying a Worksheet
Discover how to edit worksheet content, adjust rows and columns, move information, and make changes efficiently. These basic editing skills are useful in almost every Excel task.
Module 5: Formatting a Worksheet
Make spreadsheet information easier to read and understand through appropriate formatting. You will explore fonts, alignment, borders, number formats, and other worksheet presentation options.
Module 6: Printing Workbooks
Learn how to prepare spreadsheets for printing and control how information appears on the page. Topics include print settings, page layout, and preparing worksheets for clearer output.
Module 7: Managing Workbooks
Build better file-management habits by working with Excel workbooks and their different components. You will learn how to save, organise, and manage spreadsheet files effectively.
Module 8: Working with Functions
Go beyond basic calculations by using Excel functions to work with information more efficiently. Common functions can help automate calculations and reduce repetitive manual work.
Module 9: Working with Lists
Learn how Excel can be used to organise lists and structured information. The section introduces techniques that make larger sets of records easier to manage and work with.
Module 10: Analyzing Data
Explore Excel tools that can help you identify useful information within a dataset. Learners develop an understanding of sorting, filtering, and other approaches to reviewing spreadsheet data.
Module 11: Visualizing Data with Charts
Charts can make numbers easier to understand at a glance. You will learn how to create and work with charts to present spreadsheet information in a clearer visual format.
Module 12: Using PivotTables and PivotCharts
Discover how PivotTables can summarise larger amounts of information and make patterns easier to examine. PivotCharts extend this by presenting summaries visually.
Module 13: Working with Multiple Worksheets and Workbooks
Learn how to work across different worksheets and workbooks without losing track of information. This is particularly useful when managing related datasets or larger projects.
Module 14: Using Lookup Functions and Formula Auditing
Develop your spreadsheet skills by exploring lookup functions and tools for checking formulas. These features can help you retrieve information and identify potential formula problems.
Module 15: Sharing and Protecting Workbooks
Understand ways to share Excel files while maintaining better control over their contents. Workbook and worksheet protection features can help prevent unwanted changes to important information.
Module 16: Automating Workbook Functionality
Explore ways to reduce repetitive spreadsheet tasks and make workbook processes more efficient. The section introduces automation concepts that can save time when working with recurring tasks.
Module 17: Creating Sparklines and Mapping Data
Use sparklines to show quick trends within cells and explore mapping features for presenting location-based information. These tools add alternative ways to communicate data.
Module 18: Forecasting Data
Learn how Excel can be used to examine patterns and make forecasts from existing information. This provides an introduction to using spreadsheet data for forward-looking analysis.
Module 19: Excel Templates
Finish by exploring templates that can provide ready-made structures for common spreadsheet tasks. Using templates can help save time and provide a consistent starting point for new workbooks.
FAQ
What will I learn in Microsoft Excel 2019 for Beginner?
You will learn how to create and manage workbooks, enter and format data, perform calculations, use functions, organise lists, analyse information, create charts, work with PivotTables and PivotCharts, use lookup functions, protect workbooks, and explore forecasting tools.
Do I need previous Excel experience?
No. Previous Excel experience is not required. The course begins with the basics and builds your knowledge progressively.
Can I learn Excel 2019 online?
Yes. The course can be completed through online learning, allowing you to study the lessons at a convenient pace and fit learning around work, education, or other commitments.
What are the basic Excel skills I will learn?
You will learn core skills such as entering data into cells, adjusting rows and columns, formatting worksheets, creating formulas, using functions, managing worksheets, saving workbooks, and preparing spreadsheets for printing.
What Excel formulas and functions are covered?
The course introduces learners to calculations and functions used for working with spreadsheet data. You will also explore lookup functions and formula auditing to help retrieve information and check formulas.
Can Excel skills help with employment in Canada?
Yes. Excel is commonly used for tasks such as record keeping, reporting, budgeting, data entry, scheduling, inventory tracking, and information analysis. Excel knowledge can complement roles in administration, finance, customer service, data entry, business operations, and other office-based areas.
Original price was: $125.$20Current price is: $20. ex VAT
SAVE 84% - OFFER ENDS SOON
 |
Take All course
for $99-
01 Year of full Course access -
Intermediate
-
Endorsed Certificate of Compleiton
-
10 hours, 55 minutes of total Unit + Quiz duration - 10 CPD Points
- Item added to cart