Software Skills–Mastering Excel 2016: Intermediate, Microlearning Courses
TITLE | LENGTH | DESCRIPTION |
Mastering Excel 2016 Intermediate: Working With Named Ranges | 11:39 | If you've mastered Microsoft Excel 2016 then you have one of the most practical and valuable skill sets in all of modern business. A spreadsheet guru can work wonders - from organizing lists, to creating multi-layered, interactive reports, to revealing answers to business critical questions like ROI, budget allocations, tracking expenditures, and more. This course builds on your existing knowledge of Excel basics and teaches you how to manage data, charts, and tables, and how to use powerful tools such as PivotTables, Pivot Charts, Slicers, Timelines, and more. |
Mastering Excel 2016 Intermediate: Using Named Ranges in Formulas | 03:53 | |
Mastering Excel 2016 Intermediate: Using Specialized Functions | 14:12 | |
Mastering Excel 2016 Intermediate: Working With Logical Functions | 13:56 | |
Mastering Excel 2016 Intermediate: Nesting Functions | 05:28 | |
Mastering Excel 2016 Intermediate: Date and Time Functions | 03:38 | |
Mastering Excel 2016 Intermediate: Working With Text Functions | 14:34 | |
Mastering Excel 2016 Intermediate: Sorting Data | 05:34 | |
Mastering Excel 2016 Intermediate: Filtering Data | 09:18 | |
Mastering Excel 2016 Intermediate: Using Database Functions | 07:49 | |
Mastering Excel 2016 Intermediate: Using Subtotals | 09:41 | |
Mastering Excel 2016 Intermediate: Create and Modify Tables | 08:15 | |
Mastering Excel 2016 Intermediate: Manipulation Table Data | 03:50 | |
Mastering Excel 2016 Intermediate: Conditional Formatting Rules | 03:51 | |
Mastering Excel 2016 Intermediate: Using Logical Functions With Conditional Formatting | 05:20 | |
Mastering Excel 2016 Intermediate: Creating Charts | 08:37 | |
Mastering Excel 2016 Intermediate: Modifying and Formatting Charts | 09:38 | |
Mastering Excel 2016 Intermediate: Creating a Dual Axis Chart | 07:20 | |
Mastering Excel 2016 Intermediate: Chart Templates | 02:59 | |
Mastering Excel 2016 Intermediate: Creating a PivotTable | 07:14 | |
Mastering Excel 2016 Intermediate: Analyzing PivotTable Data | 09:47 | |
Mastering Excel 2016 Intermediate: Pivot Charts | 06:25 | |
Mastering Excel 2016 Intermediate: Slicers and Timelines | 06:04 |