Course in Microsoft Excel 2019 Beginners
Online USA
Course
DURATION
4 hours
LANGUAGES
English
PACE
Full time, Part time
APPLICATION DEADLINE
EARLIEST START DATE
TUITION FEES
STUDY FORMAT
Distance Learning
* free online course
Key Summary
This free online Microsoft Excel 2019 course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. You'll learn everything from how to create basic formulas in Excel, to how to print the correct part of your spreadsheet! In this course, your expert author gives you a solid grounding in the basics of Excel and guides you towards becoming more confident with spreadsheets.
This is a free online course with a certificate. Interested? Simply click the button and start today.
This Free Online Course Includes:
- 3-4 Hours of Learning
- CPD Accreditation
- Final Assessment
Alison Certificates
All Alison courses are free to enrol, study and complete. To successfully complete this Certificate course and become an Alison Graduate, you need to achieve 80% or higher in each course assessment. Once you have completed this Certificate course, you have the option to acquire an official Diploma, which is a great way to share your achievement with the world.
Your Alison Certificate is:
- Ideal for sharing with potential employers
- Include it in your CV, professional social media profiles, and job applications.
- An indication of your commitment to continuously learn, upskill & achieve high results.
- An incentive for you to continue empowering yourself through lifelong learning.
Alison offers 3 types of Diplomas for completed Diploma courses:
- Digital Certificate: a downloadable Certificate in PDF format immediately available to you when you complete your purchase.
- Certificate: a physical version of your officially branded and security-marked Certificate, posted to you with free shipping.
- Framed Certificate: a physical version of your officially branded and security-marked Certificate in a stylish frame, posted to you with free shipping.
As we are an online platform, we do not offer degrees or scholarships.
Microsoft Excel remains the go-to spreadsheet software for millions of people around the world. If you've been meaning to learn Excel for years but haven't quite got around to it, or if you use Excel every day but feel lost when you log in, then this course is for you.
The course begins by introducing you to entering numbers and text into Excel, creating basic formulas and how relative references and Order of Operations work. You will then learn how to work with larger Excel files and utilize split-screen and freeze panes, as well as how to insert headers and Footers in Excel. The course also teaches you how to add rows and columns and change column widths, how to use copy, cut and paste to save time, and how to print the correct part of your spreadsheet!
Simon Sez IT has been helping students master Excel for more than ten years. With a simple-to-follow approach and instructors that explain everything thoroughly, you can rest assured you are in safe hands. This course was recorded using Excel 2019 but is suitable for Excel 2013, 2016, and 365 users. Start this course today and you will gain a solid grounding in the basics of Excel 2019, and become more confident with spreadsheets.
Module 1
Introduction to Excel 2019
Learn Microsoft Excel 2019 and conquer your spreadsheet demons with this free online Excel video course. You will be confident in your knowledge of Excel terminology, tools, mouse features and creating workbooks after you successfully complete this course.
Module 2
Creating Workbooks
In this module, you will learn how to create workbooks. This section's topics are: entering text and numbers, creating basic formulas, relative references, order of operations and working with ranges. At the end of the module, you will also undertake a practical exercise.
Module 3
Saving Workbooks
The third module focuses on Saving Workbooks. You will learn about the following topics: Working with Save and Save As Commands and File Extensions (sharing, exporting and publishing). The module concludes with another Practice Exercise which allows you to showcase your new skills.
Module 4
Navigating Workbooks
In this module, you will learn how to navigate workbooks. The topics outline how to open a file, how to work with larger files, how to use the freeze panes option and how to operate the split screen option. The module concludes with another practical exercise.
Module 5
Page Setup & Print Options
In this module, you will learn about Page Setup and Print Options, including topics such as inserting Headers and Footers, using the Page Setup Options, how to Fit to Print on One Page and print entire workbooks. You will also learn how to print titles and use comments.
Module 6
Working with Rows, Columns and Cells
In this module, you will learn about working with Rows, Columns and Cells. This section includes topics on adding and deleting rows, columns and cells, and how to change column and row widths. It concludes with a practical exercise in which you will use all the new skills you have learned.
Module 7
Moving Data
In this module, you will learn about moving data. The topics will show you how to use Cut, Copy and Paste commands, which will ensure you have the tools to work efficiently. You will also learn how to copy formulas.
Module 8
Formulas & Functions
In this module, you will learn about formulas and functions in Excel. Topics include creating formulas using functions, and how to use absolute values. The module will conclude with a practical exercise.
Module 9
Working with Sheets
In this final module, you will learn about working with sheets. The topics covered are Adding, Deleting and Renaming Sheets, how to use the Additional Sheet Tab Options, and using 3 Dimensional Formulas. The module will conclude with another practical exercise.
Module 10
Course assessment
What You Will Learn In This Free Course
- Describe how to create basic formulas in Excel
- Explain how Relative References and Order of Operations works in Excel
- Explain how to save your work and use file extensions
- Explain how to insert headers and footers in Excel
- Explain how to print the correct part of your spreadsheet
- Describe how to add rows and columns and how to change column widths
- Describe how to use copy, cut and paste commands to save time
- Explain how formulas in Excel work and how to use essential functions
Complete This CPD Accredited Course & Get Your Certificate!
Certify Your Skills
A CPD-accredited Alison Diploma/Certificate certifies the skills you’ve learned.
Stand Out From The Crowd
Add your Alison Certification to your resume and stay ahead of the competition.
Advance in Your Career
Share your Alison Certification with potential employers to show off your skills and capabilities.