BIS Safety Software
Mastering Excel 2019 – Basics
You can be divided into two groups: those who have mastered Excel, and those who aspire to. By mastering Excel, you acquire one of the most valuable and useful skill sets in the world of business today. A proficient spreadsheet user can do marvels—from organizing lists, constructing multi-layered, interactive reports, to resolving crucial business queries like ROI, budget allotments, expense monitoring, and more. This course, "Mastering Excel 2019 - Basics", is your stepping stone towards becoming an Excel 2019 specialist.
You can be divided into two groups: those who have mastered Excel, and those who aspire to.
By mastering Excel, you acquire one of the most valuable and useful skill sets in the world of business today.
A proficient spreadsheet user can do marvels—from organizing lists, constructing multi-layered, interactive reports, to resolving crucial business queries like ROI, budget allotments, expense monitoring, and more. This course, "Mastering Excel 2019 - Basics", is your stepping stone towards becoming an Excel 2019 specialist.
Upon completing the course, you will be capable of:
- Navigating through the interface, creating and saving workbooks, quickly accessing commands, and selecting and entering data
- Performing calculations using formulas and functions
- Inserting and deleting rows and columns
- Applying formatting to text, numbers, and cells including Conditional Formatting, Comparative Analysis Formatting, Cell Styles, and Themes
- Controlling the print of your worksheets using Page Layout options, Page Breaks, and Headers and Footers
- Managing multiple worksheets within a workbook including adding, removing, renaming, reordering, copying, and color-coding worksheets
- Utilizing multiple View features to compare multiple workbooks, compare worksheets, or save Custom Views.
- Customizing your Excel instance including adding Groups to the Ribbon and modifying the Quick Access Toolbar.
The course "Mastering Excel 2019 - Basics" covers the following topics:
- Navigating the interface
- Creating and saving workbooks
- Selecting and entering data
- Performing calculations
- Formatting data
- Managing multiple worksheets
- Customizing your options
Approximately 4 hours
Testing is conducted throughout this online course to reinforce the information presented. A score of 80% must be achieved to pass this course. The course can be attempted three times to achieve the pass mark.
Upon successful completion of this online course, a certificate of completion will be available for download and printing.
Course Details
Course Length
This course will take roughly 240 minutes
Passing Mark
To pass this training course, you need to score 80% or higher on the quiz
Certificate
Upon the successful completion of this course a certificate with your name will be stored on your profile and available to print
Additional Training Courses
Maritime Health and Wellness (OSHA)
This is a comprehensive online training class, designed in accordance with OSHA standards, focusing on Maritime Health and Wellness. It is recognized by I-CAB.
Introduction to Ergonomics for the Office-2024
AMTA's Introduction to Ergonomics for the Office-2024 course presents insights on the identification of ergonomic risks and implementation of practical strategies to mitigate repetitive...
La Loi sur l’accessibilité pour les personnes handicapées de l’Ontario (LAPHO)
La formation obligatoire sur la Loi sur l'accessibilité pour les personnes handicapées de l'Ontario (LAPHO) et le Code des droits de la personne de...
