TOIT Training

Mastering Excel 2019 – Basics

Mastering Excel 2019 – Basics
  • Overview
  • Curriculum
  • Reviews

There are two kinds of people: Those who are masters at Excel 2019 or Excel 365, and those who wish they were  

When you master Excel 2019 or Excel 365, you have one of the most practical and valuable skillsets in modern business. A spreadsheet guru can work wonders—from organizing lists; to creating multi-layered, interactive reports; to answering critical business questions like ROI, budget allocations, expense tracking, and more. This course is your first step towards becoming an expert at using Excel 2019. This is our most requested training course!

  • 7 Sections
  • 28 Lessons
  • 0m Duration
Expand All

Getting Started

6 Lessons
  • Introduction
  • Navigating the Interface
  • Selecting Data
  • Using Commands
  • Creating a New Workbook
  • Entering Cell Data

Performing Calculations

3 Lessons
  • Creating Formulas
  • Inserting Functions
  • Copying Formulas and Functions

Modifying Worksheets

3 Lessons
  • Inserting and Deleting Cells
  • Searching and Replacing
  • Using Proofing and Researching Tools

Formatting Worksheets

6 Lessons
  • Applying Text Formats
  • Applying Number Formats
  • Customizing Number Formats
  • Customizing Number Formats
  • Applying Cell Styles
  • Applying Themes

Printing Workbooks

3 Lessons
  • Printing Workbooks
  • Configuring Headers and Footers, Part 1
  • Configuring Headers and Footers, Part 1

Managing Workbooks

4 Lessons
  • Managing Worksheets, Part 1
  • Managing Worksheets, Part 2
  • Managing Workbook Views
  • Managing Workbook Properties

Customizing Options

3 Lessons
  • Customizing General Options
  • Customizing the Ribbon
  • Customizing the Quick Access Toolbar

0

0 Ratings
5 Star 0%
4 Star 0%
3 Star 0%
2 Star 0%
1 Star 0%

Reviews

Free

Start Course

Retake Course

Are you sure you want to retake the course? This action will permanently delete all your progress in this course.

Course Includes

  • Navigating the interface 
  • Creating and saving workbooks 
  • Selecting and entering data 
  • Performing calculations 
  • Formatting data 
  • Managing multiple worksheets 
  • Customizing your options 

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Buy for group

Mastering Excel 2019 – Basics
No groups Found

You don't have any groups yet

Create a group and add group members. Sync Group(s)