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
Preparación y respuesta ante emergencias
La normativa OSHA dicta que los empleadores deben garantizar un entorno laboral seguro para sus trabajadores. En la eventualidad de una emergencia, la mayoría...
ICC Transport de Marchandises Dangereuses (Manutentionnaire & Conducteur)
WB-CLR12F Ce programme est conçu pour former les manutentionnaires, les conducteurs, et toute autre personne qui nécessite une compréhension des marchandises dangereuses ou qui...
Roadside Inspections for CMV Drivers
This course aims to adequately equip drivers for roadside inspections and enlighten them on the implications of a failed inspection. It further provides guidance...
