What's New?
# of Lessons
Duration
Skill Level
MSRP
Instructor(s)
Available Captions
Also Included
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 5 Expert TOSA Certification.
Topics covered include:
Over four hours of high-quality HD content in the “Uniquely Engaging” TM Bigger Brains Teacher-Learner style!
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 |
Related Course Recommendations:
Copyright ©2021 . TripleTech LLC, dba Bigger Brains . All Rights Reserved
This website uses cookies to improve your experience. Please select whether you would like to accept our decline tracking technologies and cookies. https://getbiggerbrains.com/privacy-policy/ Read More