Learning Excel 2019 – Beginner (TOSA)

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

Target Audience: People who have a basic knowledge of Microsoft® Windows® and want to learn beginner Excel 2019 or Excel 365 skills to create and modify spreadsheets. By the end of this course, you will be able to use Excel 2019 or Excel 365 to create your own workbooks and analyze your data.

Instructor: Kathy Jones

Objectives:
• Navigate the interface including creating and saving workbooks, quickly accessing commands, and selecting and entering data
• Perform calculations using formulas and functions
• Apply formatting to text, numbers, and cells including Conditional Formatting and Cell Styles
• Control how your worksheets print using Page Layout options
• Sort and filter column data
• Identify different Chart Types
• Use Ideas in Office 365

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. The material is aligned with the Level 1 Beginner TOSA Certification.

Topics covered include:
• Navigating the interface
• Creating and saving workbooks
• Selecting and entering data
• Performing calculations
• Formatting data

Course Length

Lessons : 21
Seat Time : 2 Hours 17 Minutes

Getting Started
Navigating the Interface 8:42
Selecting Data 9:15
Using Commands 7:14
Creating a New Workbook 8:04
Entering Cell Data 5:59
Using Excel Help 2:05
Formulas and Functions
Creating Formulas 7:57
Inserting Functions 8:14
Using Absolute References 9:51
Formatting
Applying Text Formats 8:35
Applying Number Formats 7:24
Customizing Number Formats 7:46
Applying Cell Styles 5:20
Applying Conditional Formatting to Numbers 6:45
Applying Conditional Formatting to Text and Dates 7:56
Printing
Printing Workbooks 4:12
Setting the Page Layout 6:34
Sorting and Filtering
Sorting Data 5:18
Filtering Data 5:20
Other
Using Chart Types 2:27
Ideas in Office 365 2:06

Trusted by Aspiring IT Professionals, Corporations and
Government agencies
for more than a Decade

Get unlimited online access learn anywhere, anytime using your computer or mobile device!