Software Skills–Mastering Excel 2016: Advanced, Microlearning Courses
TITLE | LENGTH | DESCRIPTION |
Mastering Excel 2016: Advanced - Using Links and External References | 10:15 | 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 covers everything you need to know about Microsoft Excel 2016, from the very basics to the most advanced features and functions. |
Mastering Excel 2016: Advanced - Using 3D References | 08:57 | |
Mastering Excel 2016: Advanced - Consolidating Data | 06:15 | |
Mastering Excel 2016: Advanced - Applying Data Validation | 09:33 | |
Mastering Excel 2016: Advanced - Search for Invalid Data | 06:41 | |
Mastering Excel 2016: Advanced - Using Lookup Functions (Part 1) | 12:00 | |
Mastering Excel 2016: Advanced - Using Lookup Functions (Part 2) | 05:59 | |
Mastering Excel 2016: Advanced - Tracing Precedent and Dependent Cells | 06:23 | |
Mastering Excel 2016: Advanced - Watching and Evaluating Formulas | 05:29 | |
Mastering Excel 2016: Advanced - Comments and Track Changes | 08:22 | |
Mastering Excel 2016: Advanced - Comparing and Merging Workbooks | 04:47 | |
Mastering Excel 2016: Advanced - Protecting Worksheets and Workbooks | 09:51 | |
Mastering Excel 2016: Advanced - Accessibility Checker | 04:19 | |
Mastering Excel 2016: Advanced - Working with Macros (Part 1) | 11:27 | |
Mastering Excel 2016: Advanced - Working with Macros (Part 2) | 07:20 | |
Mastering Excel 2016: Advanced - Creating Sparklines | 04:41 | |
Mastering Excel 2016: Advanced - 3D Maps | 06:31 | |
Mastering Excel 2016: Advanced - Data Tables | 06:32 | |
Mastering Excel 2016: Advanced - Using Scenarios | 04:54 | |
Mastering Excel 2016: Advanced - Goal Seek | 02:42 | |
Mastering Excel 2016: Advanced - Forecasting Data Trends | 03:00 | |
Mastering Excel 2016: Advanced - Changing your Display (Appendix 1) | 04:16 | |
Mastering Excel 2016: Advanced - Importing Delimited Text Files (Appendix 2) | 03:42 | |
Mastering Excel 2016: Advanced - Data Forms and Form Controls (Appendix 3) | 14:21 | |
Mastering Excel 2016: Advanced - Calculated Fields and Cube Functions (Appendix 4) | 04:55 |