Microsoft Excel 2019 Beginners
Course facts
- Payment: Free to learn, certificate paid
- Credits: CPD Credits
- Learning style: Self-paced, start anytime
- Format: Video Based
- Video access: Offline Download (App)
- Refund: Conditional Refund
| Course Details | ||||||||
|---|---|---|---|---|---|---|---|---|
|
||||||||
| Languages | ||||||||
|
||||||||
| Outcomes | ||||||||
|
||||||||
| Price & Terms | ||||||||
|
||||||||
| Technical | ||||||||
|
||||||||
| Specification | ||||||||
|
||||||||
Learn Microsoft Excel 2019 basics: workbooks, navigation, printing, rows and columns, moving data, basic formulas, relative references, and functions.
Excel is the spreadsheet software many people use every day, yet plenty of users never get past the basics. Through video lessons with downloadable exercise files, this course covers entering numbers and text, creating, saving, and navigating workbooks, file extensions, split screens and freeze panes, headers and footers, page setup and printing the right part of a sheet, adding rows and columns and changing column widths, copying, cutting, and moving data, working with sheets, and basic formulas, relative references, order of operations, and essential functions.
What You Will Achieve
- Create, save, and navigate Excel workbooks
- Create basic formulas using relative references and the order of operations
- Add rows and columns and move data with copy, cut, and paste
- Set up pages with headers and footers and print the correct part of a spreadsheet
Program Overview
Creating, Saving, Navigating and Printing
Getting started with workbooks and printing them.
- Introduction to Excel 2019
- Creating, saving, and navigating workbooks
- Page setup and print options
Rows, Columns, Data and Formulas
Organizing data and doing calculations.
- Working with rows, columns, and cells
- Moving and reordering data
- Formulas, functions, and working with sheets
Certificate Awarded (Paid)
Pass the final course assessment to earn it. The course is free to study; the certificate is optional and has a fee.
Job Outlook
Excel skills are used every day in accounting, operations, administration, and almost any office role that works with numbers.
- Accounting Associate
- Operations Analyst
Good for: Excel beginners, and occasional users who feel lost in spreadsheets, who want a confident start.
Keep in mind: It was recorded in Excel 2019 but suits Excel 2013, 2016, and 365; it covers the basics, not advanced analysis.
Bottom line: A clear, practical start in Microsoft Excel.
Frequently Asked Questions
Will the course work with newer Excel versions?
The course was recorded using Excel 2019 but is suitable for Excel 2013, 2016, and Microsoft 365 users.
Are there practice files?
Yes. Course exercise files are available to download so you can practice alongside the videos before moving on to the next function.
What is a relative reference?
The course explains how relative references and the order of operations work in Excel formulas, as part of creating basic formulas.
User Reviews
Write your review
You must be logged in to post a review.
Reviews can only be posted by registered learners. Log in or create a free account, then you will return here to post.
There are no reviews yet.