Microsoft Office Events

PowerPoint 2016, Level 2 provides advanced concepts and skills for PowerPoint 2016 power users: how to use advanced formatting features, and animation and transition techniques, add and format media, track corrections and work with multiple presentations, create custom slide shows, and work with security and sharing options. This course, along with the preceding one, maps to the objectives of the Microsoft Office Specialist exam for PowerPoint 2016.

This course provides the basic concepts and skills to start being productive with Microsoft Word 2016, including how to create, format, and set up a document, and how to add graphics and tables. This course, and the two that come after, map to the objectives of the Microsoft Office Specialist and Expert exams for Word 2016. Objective coverage is marked throughout the course.

In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.

Excel 2016 Level 2 builds on the basic concepts and skills of our Level 1 course to provide more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel 2016: how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users.

This course will provide the concepts and skills to use some more advanced features of Microsoft Word 2016, including enhanced formatting, references, editing, and sharing, and saving to various formats. This course, and the two others in this series, map to the objectives of the Microsoft Office Specialist and Expert exams for Word 2016. Objective coverage is marked throughout the course.

Excel 2016 Level 2 builds on the basic concepts and skills of our Level 1 course to provide more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel 2016: how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users.

PowerPoint 2016, Level 2 provides advanced concepts and skills for PowerPoint 2016 power users: how to use advanced formatting features, and animation and transition techniques, add and format media, track corrections and work with multiple presentations, create custom slide shows, and work with security and sharing options. This course, along with the preceding one, maps to the objectives of the Microsoft Office Specialist exam for PowerPoint 2016.

Excel Basic provides the basic concepts and skills to start being productive with Microsoft Excel 2016: how to create, save, share, and print worksheets that contain various kinds of calculations and formatting. This course, and the two that come after, map to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2016. Objective coverage is marked throughout the course.

Excel 2016 Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide advanced tools for solving real-world problems in Microsoft Excel 2016: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros. The three levels of our Excel 2016 courses map to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2016. Objective coverage is marked throughout the course.

Excel 2016 Level 2 builds on the basic concepts and skills of our Level 1 course to provide more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel 2016: how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users.