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 3 Productive TOSA Certification.
Topics covered include:
Over three hours of high-quality HD content in the “Uniquely Engaging” TM Bigger Brains Teacher-Learner style!
Course Contents:
# | Section | # | Lesson | Length |
1 | Modifying Worksheets | 1 | Using Flash Fill | 5:05 |
2 | Searching and Replacing | 7:54 | ||
3 | Using Proofing and Researching Tools | 6:57 | ||
4 | Aligning Cell Contents | 7:17 | ||
5 | Inserting Hyperlinks | 6:30 | ||
2 | Advanced Formatting | 6 | Applying Conditional Formatting to Numbers | 6:45 |
7 | Applying Conditional Formatting to Text and Dates | 7:56 | ||
8 | Applying Comparative Analysis Formatting | 7:22 | ||
9 | Customizing Conditional Formatting | 5:57 | ||
10 | Using Formulas with Conditional Formatting | 6:08 | ||
3 | Managing Workbooks | 11 | Managing Worksheet Views | 6:01 |
12 | Managing Workbook Views | 6:22 | ||
13 | Managing Workbook Properties | 4:14 | ||
4 | Sorting and Filtering | 14 | Sorting Data | 5:29 |
15 | Filtering Data | 5:20 | ||
5 | Using Tables and Charts | 16 | Creating Tables | 6:31 |
17 | Modifying Table Styles | 6:32 | ||
18 | Creating Charts | 5:37 | ||
19 | Changing Chart Data Source | 6:32 | ||
20 | Adding Chart Elements | 10:00 | ||
21 | Formatting a Chart | 4:46 | ||
6 | Using PivotTables | 22 | Creating a PivotTable | 11:31 |
23 | Summarizing Data in a PivotTable | 8:00 | ||
24 | Grouping Data in a PivotTable | 6:15 | ||
7 | Collaborating with Others | 25 | Adding Comments | 5:04 |
26 | Tracking Changes | 6:04 | ||
27 | Preparing to Share | 7:19 | ||
8 | Forecasting and Mapping Data | 28 | Using Goal Seek | 3:30 |
29 | Creating Sparklines | 3:58 | ||
30 | Creating a Map Chart | 3:47 | ||
31 | Creating 3D Maps | 8:27 | ||
9 | Other | 32 | Importing and Exporting Data | 3:19 |
33 | Creating a Web Query | 3:52 | ||
34 | Using the Quick Analysis Shortcut | 1:54 | ||
35 | Using Group Mode | 3:18 | ||
36 | Using 3D References | 2:32 |
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