{"product_id":"excel-2016-expert","title":"Excel 2016 Expert","description":"\u003cp\u003e\u003cspan\u003eParticipants 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.\u003c\/span\u003e\u003cbr\u003e\u003cbr\u003e\u003cspan\u003eParticipants will create, manage, and distribute professional spreadsheets for a variety of specialized purposes and situations. They will customize their Excel 2016 environments to meet project needs and increase productivity. Expert workbook examples include custom business templates, multi-axis financial charts, amortization tables, and inventory schedules.\u003c\/span\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cspan\u003eModule One: Manage Workbook Options and Settings\u003cbr\u003e• Manage Workbooks\u003cbr\u003eo Save a workbook as a template\u003cbr\u003eo Copy macros between workbooks\u003cbr\u003eo Mange Document Versions\u003cbr\u003eo Reference data in another workbook\u003cbr\u003eo Reference data by using structured references\u003cbr\u003eo Enable macros in a workbook\u003cbr\u003eo Display hidden ribbon tabs\u003cbr\u003e• Manage Workbook Review\u003cbr\u003eo Restrict editing\u003cbr\u003eo Protect a worksheet\u003cbr\u003eo Configure formula calculation options\u003cbr\u003eo Protect workbook structure\u003cbr\u003eo Mange workbook versions\u003cbr\u003eo Encrypt workbooks with a password\u003cbr\u003e\u003cbr\u003eModule Two: Apply Custom Data Formats and Layouts\u003cbr\u003e• Apply Custom Data Formats and Validation\u003cbr\u003eo Create custom number formats\u003cbr\u003eo Populate cells by using advanced Fill Series options\u003cbr\u003eo Configure data validation\u003cbr\u003e• Apply Advanced Conditional Formatting and Filtering\u003cbr\u003eo Create custom conditional formatting rules\u003cbr\u003eo Create conditional formatting rules that use formulas\u003cbr\u003eo Manage conditional formatting rules\u003cbr\u003e• Create and Modify Custom Workbook Elements\u003cbr\u003eo Create custom color formats\u003cbr\u003eo Create and modify cell types\u003cbr\u003eo Create and modify custom themes\u003cbr\u003eo Create and modify simply macros\u003cbr\u003eo Insert and configure form controls\u003cbr\u003e• Prepare a Workbook for Internationalization\u003cbr\u003eo Display data in multiple international formats\u003cbr\u003eo Apply international currency formats\u003cbr\u003eo Manage multiple options for +Body and +Heading fonts\u003cbr\u003e\u003cbr\u003eModule Three: Create Advanced Formulas\u003cbr\u003e• Apply Functions in Formulas\u003cbr\u003eo Perform logical operations by using AND, OR, and NOT functions\u003cbr\u003eo Perform logical operations by using nested functions\u003cbr\u003eo Perform statistical operations by using SUMIFS, AVERAGEIFS, AND COUNTIFS functions\u003cbr\u003e• Look up data using Functions\u003cbr\u003eo Look up data by using the VLOOKUP\u003cbr\u003eo Look up data by using the HLOOKUP function\u003cbr\u003eo Look up data by using the MATCH function\u003cbr\u003eo Look up data by using the INDEX function\u003cbr\u003e• Apply Advanced Date and Time Functions\u003cbr\u003eo Reference the date and time by using the NOW and TODAY functions\u003cbr\u003eo Serialize numbers by using date and time functions\u003cbr\u003e• Perform Data Analysis and Business Intelligence\u003cbr\u003eo Import, transform, combine, display, and connect to data\u003cbr\u003eo Consolidate data\u003cbr\u003eo Perform what-if analysis by using Goal Seek and Scenario Manager\u003cbr\u003eo Use cube functions to get data out of the Excel data model\u003cbr\u003eo Calculate data by using financial functions\u003cbr\u003e• Troubleshoot Formulas\u003cbr\u003eo Trace precedence and dependence\u003cbr\u003eo Monitor cells and formulas by using the Watch Window\u003cbr\u003eo Validate formulas by using error checking values\u003cbr\u003eo Evaluate formulas\u003cbr\u003eo Calculate data by using financial functions\u003cbr\u003e• Define Named Ranges and Objects\u003cbr\u003eo Name cells\u003cbr\u003eo Name data ranges\u003cbr\u003eo Name tables\u003cbr\u003eo Mange named ranges and objects\u003cbr\u003e\u003cbr\u003eModule Four: Create Advanced Charts and Tables\u003cbr\u003e• Create Advanced Charts\u003cbr\u003eo Add trend lines to charts\u003cbr\u003eo Create dual axis charts\u003cbr\u003eo Save a chart as a template\u003cbr\u003e• Create and Manage Pivot Tables\u003cbr\u003eo Create PivotTables\u003cbr\u003eo Modify field selections and options\u003cbr\u003eo Create slicers\u003cbr\u003eo Group PivotTable data\u003cbr\u003eo Reference data in a PivotTable by suing the GETPRIVOTDATA function\u003cbr\u003eo Add calculated fields\u003cbr\u003eo Format data\u003cbr\u003e• Create and Manage PivotCharts\u003cbr\u003eo Create PivotCharts\u003cbr\u003eo Manipulate options in existing PivotCharts\u003cbr\u003eo Apply styles to PivotCharts\u003cbr\u003eo Apply Styles to PivotCharts\u003cbr\u003eo Manipulate options in existing PivotCharts\u003cbr\u003eo Apply styles to PivotCharts\u003cbr\u003eo Drill down into PivotChart details\u003c\/span\u003e\u003c\/p\u003e","brand":"My Store","offers":[{"title":"Default Title","offer_id":46499584835796,"sku":"excel_2016_expert","price":25.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0751\/4882\/0692\/files\/microsoft-excel-2016.png?v=1779428554","url":"https:\/\/essatraining.com.au\/products\/excel-2016-expert","provider":"Essential Soft Skills Academy","version":"1.0","type":"link"}