TITLE |
LENGTH |
DESCRIPTION |
Mastering Excel 2019 (Intermediate) 01: Intro |
01:47 |
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 builds on your existing Excel knowledge and teaches you how to manage data, charts, and tables, and how to use powerful tools such as Pivot Tables, Pivot Charts, Slicers, Timelines, and more. |
Mastering Excel 2019 (Intermediate) 02: Using Named Ranges, Part 1 |
05:16 |
Mastering Excel 2019 (Intermediate) 03: Using Named Ranges, Part 2 |
05:32 |
Mastering Excel 2019 (Intermediate) 04: Using Named Ranges, Part 3 |
05:10 |
Mastering Excel 2019 (Intermediate) 05: Working with Date Functions, Part 1 |
09:15 |
Mastering Excel 2019 (Intermediate) 06: Working with Date Functions, Part 2 |
04:38 |
Mastering Excel 2019 (Intermediate) 07: Working with Date Functions, Part 3 |
03:41 |
Mastering Excel 2019 (Intermediate) 08: Working with Time Functions |
05:50 |
Mastering Excel 2019 (Intermediate) 09: Working with Logical Functions |
09:03 |
Mastering Excel 2019 (Intermediate) 10: Working with Conditional Functions |
08:16 |
Mastering Excel 2019 (Intermediate) 11: Multiple Criteria Functions |
05:23 |
Mastering Excel 2019 (Intermediate) 12: IFS and SWITCH |
06:21 |
Mastering Excel 2019 (Intermediate) 13: Nesting Functions |
05:57 |
Mastering Excel 2019 (Intermediate) 14: Working with Text Functions, Part 1 |
04:22 |
Mastering Excel 2019 (Intermediate) 15: Working with Text Functions, Part 2 |
04:55 |
Mastering Excel 2019 (Intermediate) 16: Working with Text Functions, Part 3 |
03:49 |
Mastering Excel 2019 (Intermediate) 17: Working with Text Functions, Part 4 |
08:56 |
Mastering Excel 2019 (Intermediate) 18: Working with Math Functions |
07:55 |
Mastering Excel 2019 (Intermediate) 19: Calculation Options |
02:47 |
Mastering Excel 2019 (Intermediate) 20: Sorting Data, Part 1 |
05:31 |
Mastering Excel 2019 (Intermediate) 21: Sorting Data, Part 2 |
06:00 |
Mastering Excel 2019 (Intermediate) 22: Filtering Data, Part 1 |
05:25 |
Mastering Excel 2019 (Intermediate) 23: Filtering Data, Part 2 |
08:06 |
Mastering Excel 2019 (Intermediate) 24: Filtering Data, Part 3 |
08:28 |
Mastering Excel 2019 (Intermediate) 25: Querying Data |
07:16 |
Mastering Excel 2019 (Intermediate) 26: Using the Subtotal Function |
04:43 |
Mastering Excel 2019 (Intermediate) 27: Using the Subtotal Feature |
07:09 |
Mastering Excel 2019 (Intermediate) 28: Creating Tables |
06:45 |
Mastering Excel 2019 (Intermediate) 29: Modifying Table Styles |
07:10 |
Mastering Excel 2019 (Intermediate) 30: Using the Quick Analysis Shortcut |
01:56 |
Mastering Excel 2019 (Intermediate) 31: Summarizing Data in Tables |
04:35 |
Mastering Excel 2019 (Intermediate) 32: Customizing Conditional Formatting |
06:07 |
Mastering Excel 2019 (Intermediate) 33: Using Formulas with Conditional Formatting |
06:17 |
Mastering Excel 2019 (Intermediate) 34: Creating Charts |
05:48 |
Mastering Excel 2019 (Intermediate) 35: Using Chart Types |
02:30 |
Mastering Excel 2019 (Intermediate) 36: Changing the Data Source |
06:46 |
Mastering Excel 2019 (Intermediate) 37: Adding Chart Elements |
10:19 |
Mastering Excel 2019 (Intermediate) 38: Formatting a Chart |
05:23 |
Mastering Excel 2019 (Intermediate) 39: Using Advanced Chart Features |
04:44 |
Mastering Excel 2019 (Intermediate) 40: Applying Trend Lines |
04:36 |
Mastering Excel 2019 (Intermediate) 41: Creating a Chart Template |
03:31 |
Mastering Excel 2019 (Intermediate) 42: Inserting Graphics |
09:15 |
Mastering Excel 2019 (Intermediate) 43: Modifying Graphics |
12:38 |
Mastering Excel 2019 (Intermediate) 44: Creating a Pivot Table |
12:14 |
Mastering Excel 2019 (Intermediate) 45: Summarizing Data in a Pivot Table |
08:38 |
Mastering Excel 2019 (Intermediate) 46: Grouping Data in a Pivot Table |
06:33 |
Mastering Excel 2019 (Intermediate) 47: Formatting a Pivot Table |
07:42 |
Mastering Excel 2019 (Intermediate) 48: Changing Pivot Table Options |
08:38 |
Mastering Excel 2019 (Intermediate) 49: Presenting Data with Pivot Charts |
04:29 |
Mastering Excel 2019 (Intermediate) 50: Using Slicers |
07:45 |
Mastering Excel 2019 (Intermediate) 51: Using Timeline Slicers |
01:50 |