Microsoft Office Advanced SuccessPath

Prerequisites
Should have a basic understanding of the Microsoft Windows and Microsoft Office

Description
In this path, extend your basic knowledge of Microsoft Office into some of the specialized and more advanced topics to become even more productive at the office. You will learn advanced document layout, adding tables, and page layout in Microsoft Word. Learn advanced techniques in using Excel formulas and aggregation functions, plus explore tools can help to illuminate the data in your workbook in order to give your audience the information they need in a more digestible, visual manner. Learn advanced formatting features in PowerPoint to control images, SmartArt, shapes, tables, and charts in your presentations. Explore how to animate objects so they come in, flow, move and accentuate. Finally, take a deep dive into Excel functions and features that center around Data Analysis including financial and statistical functions, VLOOKUPS, PivotTables, and PivotCharts.


Office Advanced

Course Path

Microsoft Office 2016

22+ hours covering 84 topics

Course TitleTopicsRuntimeSkill LevelTrailer
Microsoft Word 2016, Part 3 of 5: Tables and Objects /**/ 4 /**/ 1h 51m Beginner /**/
Microsoft Word 2016, Part 4 of 5: Labels, Page Layout and Printing /**/ 6 /**/ 1h 58m Beginner /**/
Microsoft Word 2016, Part 5 of 5: New Features /**/ 5 /**/ 1h 20m Intermediate /**/
Microsoft Excel 2016, Part 3 of 6: Working with Data /**/ 7 /**/ 1h 31m Beginner /**/
Microsoft Excel 2016 Data Analysis, Part 4 of 4: Analytical Tools /**/ 4 /**/ 0h 49m Intermediate /**/
Microsoft Excel 2016, Part 4 of 6: Modifying Workbook /**/ 8 /**/ 2h 37m Beginner /**/
Microsoft Excel 2016, Part 5 of 6: Printing and Sharing /**/ 6 /**/ 1h 16m Beginner /**/
Microsoft Excel 2016, Part 6 of 6: New Features /**/ 4 /**/ 1h 3m Beginner /**/
Microsoft PowerPoint 2016, Part 3 of 5: Working with Objects /**/ 8 /**/ 2h 33m Intermediate /**/
Microsoft PowerPoint 2016, Part 4 of 5: Presentations /**/ 8 /**/ 1h 38m Beginner /**/
Microsoft PowerPoint 2016, Part 5 of 5: New Features /**/ 6 /**/ 1h 56m Intermediate /**/
Micorosft Excel 2016 Data Analysis /**/ /**/ /**/
Microsoft Excel 2016 Data Analysis, Part 1 of 4: Functions and Formulas /**/ 3 /**/ 1h 0m Intermediate /**/
Microsoft Excel 2016 Data Analysis, Part 2 of 4: Lookups and DataTables /**/ 5 /**/ 1h 4m Intermediate /**/
Microsoft Excel 2016 Data Analysis, Part 3 of 4: PivotTables and PivotCharts /**/ 6 /**/ 1h 5m Intermediate /**/
Microsoft Excel 2016 Data Analysis, Part 4 of 4: Analytical Tools /**/ 4 /**/ 0h 49m Intermediate /**/


Microsoft Office 2013

13+ hours covering 47 topics