Microsoft Excel 2016 Level 2 English Version

This manual will show you how to use the additional tools and functions of Microsoft Excel 2016 Program for organizing, visualizing and calculating your data, it also assist you to explore how Excel's new data analysis tools help you track and visualize your data for greater insight and presentation.

PowerPoint 2016 is a visual and graphical application, primarily used for creating presentations. This manual provides a simple guideline to use PowerPoint such as create, view, and present slide shows that combine text, shapes, pictures, graphs, animation, charts, videos and etc.

This manual covers Templates, Auto Correct, Auto Format & Auto Text, Graph, SmartArt Graphics, Document Collaboration and Co-Authoring, Master Documents, Mail Merge, Track Changes, and Useful Tips on Word 2016

This manual provides an advanced guideline to use PowerPoint such as wordart, Smart Art Graphic, Organization Chart, Photo Album, Slide Master, Placeholders, Slide formating, Working with audio and video, and additional features in the Microsoft PowerPoint 2016.

This manual covers Introduction of Microsoft powerpoint 2016, Creating Presentation, Understanding OneDrive, Slide Basics, Text Basics, List Basics, Add Table Basics, Add Chart Basics, Animation Basics and Transition Basics

This manual will covers Introduction To Microsoft Excel 2016,Starting Microsoft Excel 2016, Getting to Know Cells and Cell Content, Modifying Columns, Rows and Cells, Formatting Cells, Creating Simple Formulas, Worksheets Basics, Creating Complex Formulas, Working with Basic Functions, Basic Sorting and Filtering and Printing with Microsoft Excel

This manual covers Date, Time and Financial Functions, What-if Analysis, Defined Name, Data Form and Drop Down List and Hyperlink.

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. 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, and you can download an objective map for the series from http://www.30bird.com.Students will benefit most from this course if they want to use Excel 2016 to perform real-world tasks such as rearranging and presenting complex data. If they intend to take a Microsoft Office Specialist or Expert exam for Excel, this course will continue their preparation, but they will need to continue on to the Level 3 course, particularly to prepare for the Expert exam.The course assumes students know how to use a computer, that they're familiar with Microsoft Windows, and that they've taken the Level 1 course or have equivalent introductory experience with Excel.