Learning Excel 2019 – Expert (TOSA)
Course details
- No. of Lessons: 40
- Duration: 4:03:10
- Skill level: Expert
- 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.
Take this course and you’ll become an expert at using Excel 2019. Material in these modules is aligned with the Level 5 – Expert User TOSA Certification. You’ll work with the most advanced features and functions associated with the exchange, protection, and review of data. Use this course to harness the full power of Excel while acquiring a skillset to manage and share large tables and databases with ease.
Topics covered include:
- Customizing the Ribbon and Quick Access Toolbar
- Using a wide variety of functions including Logical functions, Text functions, Conditional functions, Lookup functions, Math functions, Database functions, Subtotals, and nested functions
- Creating PivotTables to group and summarize data
- Presenting data with PivotCharts
- Collaborating with others using co-authoring
- Using Tracing, Evaluate Formula, and the Watch Window to find and address errors
- Forecasting data with Data Tables, Scenarios, Data Trends, and Sparkline
- Working with forms and adding ActiveX Controls
Enjoy over four 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 | Customizing Options | 1 | Customizing General Options | 4:45 |
| 2 | Customizing the Ribbon | 7:02 | ||
| 3 | Customizing the Quick Access Toolbar | 6:46 | ||
| 2 | Working with Functions | 4 | Working with Logical Functions | 8:36 |
| 5 | Working with Conditional Functions | 7:33 | ||
| 6 | Multiple Criteria Functions | 5:03 | ||
| 7 | Using Nested Functions | 5:13 | ||
| 8 | Using IFS and SWITCH Functions | 5:56 | ||
| 9 | Working with Text Functions, Part 1 | 4:13 | ||
| 10 | Working with Text Functions, Part 2 | 4:27 | ||
| 11 | Working with Text Functions, Part 3 | 3:42 | ||
| 12 | Working with Text Functions, Part 4 | 8:14 | ||
| 13 | Working with Math Functions | 6:59 | ||
| 14 | More Lookup Functions | 9:44 | ||
| 3 | Using PivotTables and PivotCharts | 15 | Creating a PivotTable | 11:31 |
| 16 | Summarizing Data in a PivotTable | 8:00 | ||
| 17 | Grouping Data in a PivotTable | 6:15 | ||
| 18 | Formatting a PivotTable | 6:56 | ||
| 19 | Selecting and Moving PivotTables | 3:15 | ||
| 20 | Changing PivotTable Options | 8:07 | ||
| 21 | Adding Calculated Fields | 2:03 | ||
| 22 | Presenting Data with PivotCharts | 4:21 | ||
| 4 | Sharing and Protecting | 23 | Co-Authoring, Part 1 | 6:12 |
| 24 | Co-Authoring, Part 2 | 4:44 | ||
| 25 | Protecting a Workbook File | 7:08 | ||
| 26 | Applying Data Validation | 7:18 | ||
| 5 | Auditing Formulas | 27 | Addressing Formula Errors | 7:16 |
| 28 | Watching and Evaluating Formulas | 4:46 | ||
| 29 | Adding Error Handling | 4:34 | ||
| 30 | Working with Information Functions | 5:12 | ||
| 6 | Forecasting Data | 31 | Forecasting with Data Tables | 5:04 |
| 32 | Using Solver | 6:46 | ||
| 33 | Forecasting with Scenarios | 8:16 | ||
| 34 | Forecasting Data Trends | 3:23 | ||
| 35 | Creating Sparklines | 3:58 | ||
| 7 | More Features | 36 | Using Paste Special | 5:50 |
| 37 | Summarizing Data in Tables | 4:32 | ||
| 38 | Creating Custom Lists | 5:34 | ||
| 39 | Working with Forms | 9:54 | ||
| 40 | Using ActiveX Controls | 4:02 |
