If you are looking to start a career in business or finance, having a working knowledge of Microsoft's Excel 2013 is a must. Our new and exciting course taught by Michael Meskers will teach you how to reveal insights hidden in your data with the help of new features such as Flash fill and Recommended Pivot Table. Learn how to visualize your data to better understand what is really going on with those important numbers with the help of Quick Analysis and Chart Formatting Control. This course will also help you study and prepare to take the Microsoft's Excel 77-420 Certification exam. Course Outline

Benefits

• Learn how to utilize the new Flash Fill Tool, which detects patterns and extracts and enters data after a recognizable pattern is found
• Learn how to use Recommended Charts, which only shows a subset of chart types that are appropriate to the data you have selected and are working with
• The new Quick Analysis tool can help you find the best options for working with selected data

Includes

• 5 Sessions with Video Training and Exercise Labs
• 5 Pre Assessment 
• 5 Post Assessment

Requirements

• Internet Explorer 9 or later, Chrome, Firefox, Edge, Safari
• Flash plugin installed 
• High-speed Internet connection

Certification

This course bundle is preparation for the official Microsoft Excel 77-420 certification exam.