Professional Development

Advanced

Modality

Self-Paced (On-Demand)

Excel 2016 Expert

<h5 id="d77771c1-99da-4ea8-9e56-1fe14966917c" data-toc-id="d77771c1-99da-4ea8-9e56-1fe14966917c" style="font-size: 16px; line-height: 1.2;">Course Overview:</h5>Participants will gain an advanced level of understanding for the Microsoft Excel environment, and the ability to guide others to the proper use of the program's full features - critical skills for those in roles such as accountants, financial analysts, and commercial bankers. Participants will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Excel environments to meet project needs and increase productivity. Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.<h5 id="5c992a61-ae36-4664-8d7c-1eadaef66251" data-toc-id="5c992a61-ae36-4664-8d7c-1eadaef66251" style="font-size: 16px; line-height: 1.2;"> Course Outline:</h5><table style="min-width: 25px;"><colgroup><col></colgroup><tbody><tr><td colspan="1" rowspan="1">Module One: Manage Workbook Options and Settings<ul><li style="color: rgb(88, 88, 88);">Manage Workbooks<ul><li style="color: rgb(88, 88, 88);">Save a workbook as a template</li><li style="color: rgb(88, 88, 88);">Copy macros between workbooks</li><li style="color: rgb(88, 88, 88);">Mange Document Versions</li><li style="color: rgb(88, 88, 88);">Reference data in another workbook</li><li style="color: rgb(88, 88, 88);">Reference data by using structured references</li><li style="color: rgb(88, 88, 88);">Enable macros in a workbook</li><li style="color: rgb(88, 88, 88);">Display hidden ribbon tabs</li></ul></li><li style="color: rgb(88, 88, 88);">Manage Workbook Review<ul><li style="color: rgb(88, 88, 88);">Restrict editing</li><li style="color: rgb(88, 88, 88);">Protect a worksheet</li><li style="color: rgb(88, 88, 88);">Configure formula calculation options</li><li style="color: rgb(88, 88, 88);">Protect workbook structure</li><li style="color: rgb(88, 88, 88);">Mange workbook versions</li><li style="color: rgb(88, 88, 88);">Encrypt workbooks with a password</li></ul></li></ul>Module Two: Apply Custom Data Formats and Layouts<ul><li style="color: rgb(88, 88, 88);">Apply Custom Data Formats and Validation<ul><li style="color: rgb(88, 88, 88);">Create custom number formats</li><li style="color: rgb(88, 88, 88);">Populate cells by using advanced Fill Series options</li><li style="color: rgb(88, 88, 88);">Configure data validation</li></ul></li><li style="color: rgb(88, 88, 88);">Apply Advanced Conditional Formatting and Filtering<ul><li style="color: rgb(88, 88, 88);">Create custom conditional formatting rules</li><li style="color: rgb(88, 88, 88);">Create conditional formatting rules that use formulas</li><li style="color: rgb(88, 88, 88);">Manage conditional formatting rules</li></ul></li><li style="color: rgb(88, 88, 88);">Create and Modify Custom Workbook Elements<ul><li style="color: rgb(88, 88, 88);">Create custom color formats</li><li style="color: rgb(88, 88, 88);">Create and modify cell types</li><li style="color: rgb(88, 88, 88);">Create and modify custom themes</li><li style="color: rgb(88, 88, 88);">Create and modify simply macros</li><li style="color: rgb(88, 88, 88);">Insert and configure form controls</li></ul></li><li style="color: rgb(88, 88, 88);">Prepare a Workbook for Internationalization<ul><li style="color: rgb(88, 88, 88);">Display data in multiple international formats</li><li style="color: rgb(88, 88, 88);">Apply international currency formats</li><li style="color: rgb(88, 88, 88);">Manage multiple options for +Body and +Heading fonts</li></ul></li></ul>Module Three: Create Advanced Formulas<ul><li style="color: rgb(88, 88, 88);">Apply Functions in Formulas<ul><li style="color: rgb(88, 88, 88);">Perform logical operations by using AND, OR, and NOT functions</li><li style="color: rgb(88, 88, 88);">Perform logical operations by using nested functions</li><li style="color: rgb(88, 88, 88);">Perform statistical operations by using SUMIFS, AVERAGEIFS, AND COUNTIFS functions</li></ul></li><li style="color: rgb(88, 88, 88);">Look up data using Functions<ul><li style="color: rgb(88, 88, 88);">Look up data by using the VLOOKUP</li><li style="color: rgb(88, 88, 88);">Look up data by using the HLOOKUP function</li><li style="color: rgb(88, 88, 88);">Look up data by using the MATCH function</li><li style="color: rgb(88, 88, 88);">Look up data by using the INDEX function</li></ul></li><li style="color: rgb(88, 88, 88);">Apply Advanced Date and Time Functions<ul><li style="color: rgb(88, 88, 88);">Reference the date and time by using the NOW and TODAY functions</li><li style="color: rgb(88, 88, 88);">Serialize numbers by using date and time functions</li></ul></li><li style="color: rgb(88, 88, 88);">Perform Data Analysis and Business Intelligence<ul><li style="color: rgb(88, 88, 88);">Import, transform, combine, display, and connect to data</li><li style="color: rgb(88, 88, 88);">Consolidate data</li><li style="color: rgb(88, 88, 88);">Perform what-if analysis by using Goal Seek and Scenario Manager</li><li style="color: rgb(88, 88, 88);">Use cube functions to get data out of the Excel data model</li><li style="color: rgb(88, 88, 88);">Calculate data by using financial functions</li></ul></li><li style="color: rgb(88, 88, 88);">Troubleshoot Formulas<ul><li style="color: rgb(88, 88, 88);">Trace precedence and dependence</li><li style="color: rgb(88, 88, 88);">Monitor cells and formulas by using the Watch Window</li><li style="color: rgb(88, 88, 88);">Validate formulas by using error checking values</li><li style="color: rgb(88, 88, 88);">Evaluate formulas</li><li style="color: rgb(88, 88, 88);">Calculate data by using financial functions</li></ul></li><li style="color: rgb(88, 88, 88);">Define Named Ranges and Objects<ul><li style="color: rgb(88, 88, 88);">Name cells</li><li style="color: rgb(88, 88, 88);">Name data ranges</li><li style="color: rgb(88, 88, 88);">Name tables</li><li style="color: rgb(88, 88, 88);">Mange named ranges and objects</li></ul></li></ul>Module Four: Create Advanced Charts and Tables<ul><li style="color: rgb(88, 88, 88);">Create Advanced Charts<ul><li style="color: rgb(88, 88, 88);">Add trend lines to charts</li><li style="color: rgb(88, 88, 88);">Create dual axis charts</li><li style="color: rgb(88, 88, 88);">Save a chart as a template</li></ul></li><li style="color: rgb(88, 88, 88);">Create and Manage Pivot Tables<ul><li style="color: rgb(88, 88, 88);">Create PivotTables</li><li style="color: rgb(88, 88, 88);">Modify field selections and options</li><li style="color: rgb(88, 88, 88);">Create slicers</li><li style="color: rgb(88, 88, 88);">Group PivotTable data</li><li style="color: rgb(88, 88, 88);">Reference data in a PivotTable by suing the GETPRIVOTDATA function</li><li style="color: rgb(88, 88, 88);">Add calculated fields</li><li style="color: rgb(88, 88, 88);">Format data</li></ul></li><li style="color: rgb(88, 88, 88);">Create and Manage PivotCharts<ul><li style="color: rgb(88, 88, 88);">Create PivotCharts</li><li style="color: rgb(88, 88, 88);">Manipulate options in existing PivotCharts</li><li style="color: rgb(88, 88, 88);">Apply styles to PivotCharts</li><li style="color: rgb(88, 88, 88);">Apply Styles to PivotCharts</li><li style="color: rgb(88, 88, 88);">Manipulate options in existing PivotCharts</li><li style="color: rgb(88, 88, 88);">Apply styles to PivotCharts</li><li style="color: rgb(88, 88, 88);">Drill down into PivotChart details</li></ul></li></ul></td></tr></tbody></table>

Microsoft Excel 2016 Expert

Language

Level

Student

Duration

Course content

Course Description

100% Satisfaction Guaranteed

This Course Includes