Learning Excel 2019 – Basics (TOSA)

Learning Excel 2019 Basics (TOSA)

# of Lessons

23

Duration

2:29:23

Skill Level

Basic

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 will get you one step closer to becoming an expert at using Excel 2019. The material is aligned with the Level 2 Basics TOSA Certification. Topics covered include:

  • Performing calculations
  • Formatting data
  • Managing multiple worksheets
  • Working with named ranges
  • Inserting functions
  • Sorting data
  • Inserting charts
  • Auditing formulas

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

Course Contents:

# Section # Lesson Length
1 Performing Calculations 1 Inserting Functions 8:10
2 Using Absolute References 9:51
2 Formatting Worksheets 3 Inserting and Deleting Cells 8:50
4 Applying Text Formats 8:35
5 Applying Number Formats 7:24
6 Aligning Cell Contents 7:17
7 Applying Themes 3:48
8 Using Templates 6:01
3 Printing Workbooks 9 Setting the Page Layout 6:34
10 Inserting Page Breaks 8:38
11 Configuring Headers and Footers, Part 1 5:09
12 Configuring Headers and Footers, Part 2 4:04
4 Managing Workbooks 13 Managing Worksheets, Part 1 5:02
14 Managing Worksheets, Part 2 7:39
15 Creating a Custom View 3:47
5 Working with Functions 16 Using Named Ranges 5:25
17 Working with Logical Functions 8:36
18 Working with Conditional Functions 7:33
6 Other 19 Sorting Data 5:18
20 Creating Charts 5:37
21 Using Chart Types 2:27
22 Tracing Formulas 6:22
23 Addressing Formula Errors 7:16

Related Course Recommendations:

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

Catalog Request

Login Logo