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
Gas Monitor Competence Training – GfG G450/G460 Gas Monitor
The Gas Monitor Competence Training ensures compliance with the OSHA 1910.146(h)(2) regulation by providing a comprehensive understanding of the GfG 450 & 460 gas...
Job Hazard Analysis (JHA) (CAN)
The Job Hazard Analysis (JHA) safety training course, designed in compliance with Canadian standards, is appropriate for any individual involved in creating JHA documents....
Hours of Service Training Module 5: ELD Basics
The Hours of Service Training: ELD Basics module is intended to equip drivers with the knowledge needed to skillfully operate ELDs and properly utilize...
