BIS Safety Software Canada

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.

Mastering Excel 2019 – Basics

COURSE OVERVIEW

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.


COURSE TOPICS

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
ONLINE COURSE DURATION

Approximately 4 hours

PASS MARK

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. 

CERTIFICATE OF COMPLETION

Upon successful completion of this online course, a certificate of completion will be available for download and printing.

COURSE PREVIEW

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

DOT Driver Compliance (US)

DOT Driver Compliance (US)

This web-based DOT Driver Compliance course introduces necessary U.S. Department of Transportation (DOT) rules that all drivers of Commercial Motor Vehicles (CMV) are obligated...

OSHA Formaldehyde Standard

OSHA Formaldehyde Standard

Our OSHA Formaldehyde Standard online course delivers mandatory training, emphasizing the regulations and guidelines set by the standard for safe handling of this potentially...

Aerial Platform – Boom & Scissor

Aerial Platform – Boom & Scissor

The online Aerial Platform – Boom & Scissor course is designed to minimize the hazards associated with straight telescoping boom, articulating boom, and scissor...