Learning Excel 2019 – Beginner (TOSA)

Learning Excel 2019 – Beginner (TOSA)

# of Lessons

21

Duration

2:17:04

Skill Level

Beginner

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 in the world: A handful of people who are masters of Excel, and the millions of others who wish they were.  

 

When you master Excel, you have one of the most practical and valuable skillsets in modern business. A spreadsheet expert can work wonders—from organizing lists to creating multi-layered interactive reports; from answering critical business questions to managing budget allocations and tracking expenses. In this course you’ll start and the beginning to learn how to navigate Excel efficiently. Then you’ll create new workbooks, enter data, start creating calculations, and format your data. In no time at all, you’ll have a functioning workbook you can use to organize your data. 

Take this course and make your first move to becoming an expert at using Excel 2019. Material in these modules is aligned with the Level 1 – Beginner User TOSA Certification. You’ll be learning the fundamental features and functions of Excel. 

 

Topics covered include: 

  • Navigating Excel’s interface 
  • Creating and saving workbooks 
  • Selecting and entering data 
  • Performing basic calculations 
  • Formatting text, numbers, and cells 
  • Sorting and filtering data 
  • Changing chart types 
  • Printing worksheets 

 

Enjoy 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:

Catalog Request

Login Logo

Get course updates, Learning and Development ideas, and Information on how to use Bigger Brains!