Learning Excel 2019 – Beginner (TOSA)
Course details
- No. of Lessons: 21
- Duration: 2:17:04
- Skill level: Beginner
- Captions: Not Captioned
- Also included: Handout, Practice Files, Knowledge Check, High-quality HD content in the “Uniquely Engaging™” Bigger Brains Teacher-Learner style!
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!
Taught by top subject matter experts, Bigger Brains courses are professionally designed around key learning objectives, and include captions and transcripts in 29 languages, downloadable handouts, and optional LinkedIn digital badges on course completion.
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 |
