Learning Excel 2019 – Beginner (TOSA)

Learning Excel 2019 - Beginner (TOSA)

# of Lessons

21

Duration

2:17:04

Skill Level

Beginner

MSRP

$30

Instructor(s)

Kathy Jones

Available Captions

Not Captioned

Also Included

Handout, Practice Files, Knowledge Check, High-quality HD content in the “Uniquely Engaging™” Bigger Brains Teacher-Learner style! 

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

 

Over two hours of high-quality HD content in the “Uniquely Engaging” TM Bigger Brains Teacher-Learner style!

Course Contents:

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

Related Course Recommendations:

Learning Excel 2019 - Basics (TOSA)
Learning Excel 2019 - Productive (TOSA)
Learning Excel 2019 - Advanced (TOSA)

Catalog Request

Login Logo