{"product_id":"excel-2016-expert","title":"Excel 2016 Expert","description":"\u003cdiv class=\"ebsi-team-licence-note\"\u003e\u003cp\u003e\u003cstrong\u003eBuying for a team?\u003c\/strong\u003e\u003cbr\u003eChoose 5 or 10 licences to purchase access for multiple learners at a reduced per-person rate. After purchase, eBSI will contact you to confirm the learner details and arrange course access for each participant.\u003c\/p\u003e\u003c\/div\u003e\n\u003c!-- ebsi-sales-wrapper --\u003e\u003cdiv class=\"ebsi-sales-wrapper\"\u003e\n\u003cp\u003e\u003cstrong\u003eDevelop practical knowledge and confidence in Excel 2016 Expert.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\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\/p\u003e\n\u003ch3\u003eWhy this course matters\u003c\/h3\u003e\n\u003cp\u003eThis course turns the subject into practical, structured learning you can apply in real business and workplace situations. It is designed to help you move beyond definitions and understand how the ideas, tools and decisions covered in the course fit together.\u003c\/p\u003e\n\u003ch3\u003eWhat you will gain\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003eUse the key features and workflows covered in Excel 2016 Expert with greater confidence.\u003c\/li\u003e\n\u003cli\u003eApply the tools and techniques to practical business tasks.\u003c\/li\u003e\n\u003cli\u003eRecognise common mistakes and work more efficiently in day-to-day use.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eWho is this course for?\u003c\/h3\u003e\n\u003cp\u003eThis course is suitable for business users, administrators, managers and professionals who want to work more efficiently with everyday digital tools.\u003c\/p\u003e\n\u003ch3\u003eCourse at a glance\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eFormat:\u003c\/strong\u003e self-paced online learning.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eProfessional development:\u003c\/strong\u003e CPD course.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\n\u003cp class=\"ng-scope\"\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\/p\u003e\n\u003cp class=\"ng-scope\"\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\/p\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cmeta charset=\"utf-8\"\u003e\u003cspan\u003eCompleting this course will confer 2 CPD Credits towards internationally recognised \u003c\/span\u003e\u003cstrong\u003eContinuous Professional Development\u003c\/strong\u003e\u003cspan\u003e Requirements within organisations operating this kind of staff development methodology.\u003c\/span\u003e\u003c\/p\u003e\n\u003cp class=\"ng-scope\"\u003e \u003c\/p\u003e\n\u003ch5 class=\"ng-scope\"\u003e\u003cstrong\u003e\u003cspan style=\"text-decoration: underline;\"\u003eCourse Outline\u003c\/span\u003e\u003c\/strong\u003e\u003c\/h5\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule One: Manage Workbook Options and Settings\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eManage Workbooks\n\u003cul\u003e\n\u003cli\u003eSave a workbook as a template\u003c\/li\u003e\n\u003cli\u003eCopy macros between workbooks\u003c\/li\u003e\n\u003cli\u003eMange Document Versions\u003c\/li\u003e\n\u003cli\u003eReference data in another workbook\u003c\/li\u003e\n\u003cli\u003eReference data by using structured references\u003c\/li\u003e\n\u003cli\u003eEnable macros in a workbook\u003c\/li\u003e\n\u003cli\u003eDisplay hidden ribbon tabs\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eManage Workbook Review\n\u003cul\u003e\n\u003cli\u003eRestrict editing\u003c\/li\u003e\n\u003cli\u003eProtect a worksheet\u003c\/li\u003e\n\u003cli\u003eConfigure formula calculation options\u003c\/li\u003e\n\u003cli\u003eProtect workbook structure\u003c\/li\u003e\n\u003cli\u003eMange workbook versions\u003c\/li\u003e\n\u003cli\u003eEncrypt workbooks with a password\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Two: Apply Custom Data Formats and Layouts\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eApply Custom Data Formats and Validation\n\u003cul\u003e\n\u003cli\u003eCreate custom number formats\u003c\/li\u003e\n\u003cli\u003ePopulate cells by using advanced Fill Series options\u003c\/li\u003e\n\u003cli\u003eConfigure data validation\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eApply Advanced Conditional Formatting and Filtering\n\u003cul\u003e\n\u003cli\u003eCreate custom conditional formatting rules\u003c\/li\u003e\n\u003cli\u003eCreate conditional formatting rules that use formulas\u003c\/li\u003e\n\u003cli\u003eManage conditional formatting rules\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eCreate and Modify Custom Workbook Elements\n\u003cul\u003e\n\u003cli\u003eCreate custom color formats\u003c\/li\u003e\n\u003cli\u003eCreate and modify cell types\u003c\/li\u003e\n\u003cli\u003eCreate and modify custom themes\u003c\/li\u003e\n\u003cli\u003eCreate and modify simply macros\u003c\/li\u003e\n\u003cli\u003eInsert and configure form controls\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003ePrepare a Workbook for Internationalization\n\u003cul\u003e\n\u003cli\u003eDisplay data in multiple international formats\u003c\/li\u003e\n\u003cli\u003eApply international currency formats\u003c\/li\u003e\n\u003cli\u003eManage multiple options for +Body and +Heading fonts\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Three: Create Advanced Formulas\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eApply Functions in Formulas\n\u003cul\u003e\n\u003cli\u003ePerform logical operations by using AND, OR, and NOT functions\u003c\/li\u003e\n\u003cli\u003ePerform logical operations by using nested functions\u003c\/li\u003e\n\u003cli\u003ePerform statistical operations by using SUMIFS, AVERAGEIFS, AND COUNTIFS functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eLook up data using Functions\n\u003cul\u003e\n\u003cli\u003eLook up data by using the VLOOKUP\u003c\/li\u003e\n\u003cli\u003eLook up data by using the HLOOKUP function\u003c\/li\u003e\n\u003cli\u003eLook up data by using the MATCH function\u003c\/li\u003e\n\u003cli\u003eLook up data by using the INDEX function\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eApply Advanced Date and Time Functions\n\u003cul\u003e\n\u003cli\u003eReference the date and time by using the NOW and TODAY functions\u003c\/li\u003e\n\u003cli\u003eSerialize numbers by using date and time functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003ePerform Data Analysis and Business Intelligence\n\u003cul\u003e\n\u003cli\u003eImport, transform, combine, display, and connect to data\u003c\/li\u003e\n\u003cli\u003eConsolidate data\u003c\/li\u003e\n\u003cli\u003ePerform what-if analysis buy suing Goal Seek and Scenario Manager\u003c\/li\u003e\n\u003cli\u003eUse cube functions to get data out of the Excel data model\u003c\/li\u003e\n\u003cli\u003eCalculate data by using financial functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eTroubleshoot Formulas\n\u003cul\u003e\n\u003cli\u003eTrace precedence and dependance\u003c\/li\u003e\n\u003cli\u003eMonitor cells and formulas by using the Watch Window\u003c\/li\u003e\n\u003cli\u003eValidate formulas by using error checking values\u003c\/li\u003e\n\u003cli\u003eEvaluate formulas\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eCalculate data by using financial functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eDefine Named Ranges and Objects\n\u003cul\u003e\n\u003cli\u003eName cells\u003c\/li\u003e\n\u003cli\u003eName data ranges\u003c\/li\u003e\n\u003cli\u003eName tables\u003c\/li\u003e\n\u003cli\u003eMange named ranges and objects\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Four: Create Advanced Charts and Tables\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eCreate Advanced Charts\n\u003cul\u003e\n\u003cli\u003eAdd trendlines to charts\u003c\/li\u003e\n\u003cli\u003eCreate dual axis charts\u003c\/li\u003e\n\u003cli\u003eSave a chart as a template\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eCreate and Manage Pivot Tables\n\u003cul\u003e\n\u003cli\u003eCreate PivotTables\u003c\/li\u003e\n\u003cli\u003eModify field selections and options\u003c\/li\u003e\n\u003cli\u003eCreate slicers\u003c\/li\u003e\n\u003cli\u003eGroup PivotTable data\u003c\/li\u003e\n\u003cli\u003eReference data in a PivotTable by suing the GETPRIVOTDATA function\u003c\/li\u003e\n\u003cli\u003eAdd calculated fields\u003c\/li\u003e\n\u003cli\u003eFormat data\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eCreate and Manage PivotCharts\n\u003cul\u003e\n\u003cli\u003eCreate PivotCharts\u003c\/li\u003e\n\u003cli\u003eManipulate options in existing PivotCharts\u003c\/li\u003e\n\u003cli\u003eApply styles to PivotCharts\u003c\/li\u003e\n\u003cli\u003eApply Styles to PivotCharts\u003c\/li\u003e\n\u003cli\u003eManipulate options in existing PivotCharts\u003c\/li\u003e\n\u003cli\u003eApply styles to PivotCharts\u003c\/li\u003e\n\u003cli\u003eDrill down into PivotChart details\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c!-- ebsi-cross-sell --\u003e\u003cdiv class=\"ebsi-cross-sell\"\u003e\n\u003ch3\u003eContinue your learning\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003ePart of this learning pathway:\u003c\/strong\u003e \u003ca href=\"\/collections\/microsoft-office-skills\"\u003eMicrosoft Office \u0026amp; Windows\u003c\/a\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eLearners also take:\u003c\/strong\u003e \u003ca href=\"\/products\/excel-2016-essentials\"\u003eExcel 2016 Essentials\u003c\/a\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eRelated training bundle:\u003c\/strong\u003e \u003ca href=\"\/products\/excel-2016-mastery-program\"\u003eExcel 2016 Mastery Program\u003c\/a\u003e\u003c\/p\u003e\n\u003c\/div\u003e\n\u003c!-- ebsi-academy-breadcrumb --\u003e\n\u003chr\u003e\u003cdiv class=\"ebsi-course-pathway\"\u003e\n\u003cp\u003e\u003cstrong\u003eCourse pathway:\u003c\/strong\u003e \u003ca href=\"\/pages\/welcome-to-ebsi-sme-academy\"\u003eeBSI SME Academy\u003c\/a\u003e \u0026gt; \u003ca href=\"\/collections\/microsoft-office-skills\"\u003eMicrosoft Office \u0026amp; Windows\u003c\/a\u003e \u0026gt; Excel 2016 Expert\u003c\/p\u003e\n\u003cp\u003eExplore more \u003ca href=\"\/collections\/microsoft-office-skills\"\u003eMicrosoft Office \u0026amp; Windows\u003c\/a\u003e training or return to the \u003ca href=\"\/pages\/welcome-to-ebsi-sme-academy\"\u003eeBSI SME Academy\u003c\/a\u003e.\u003c\/p\u003e\n\u003c\/div\u003e","brand":"eBSI Export Academy","offers":[{"title":"Individual Licence (EUR 40)","offer_id":14358980591679,"sku":"ITLU007","price":44.0,"currency_code":"USD","in_stock":true},{"title":"5 Licences (EUR 35 each)","offer_id":59260628173148,"sku":null,"price":193.0,"currency_code":"USD","in_stock":true},{"title":"10 Licences (EUR 30 each)","offer_id":59260628205916,"sku":null,"price":330.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0077\/7604\/3071\/products\/ITLU007_Excel_2016_Expert_1.png?v=1590011820","url":"https:\/\/www.ebsiamericas.com\/products\/excel-2016-expert","provider":"eBSI Export Academy","version":"1.0","type":"link"}