{"product_id":"excel-2016-master","title":"Excel 2016 Master","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 Master.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eExcel 2016 Master : In this mastery course you will be taken to the highest level of proficiency in MS Excel 2016. Before attempting this course you should have completed the Essentials , Advanced and Expert courses.\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 Master 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\u003e\u003cstrong\u003eITLU055 : Excel 2016 Master \u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eExcel 2016 Master : In this mastery course you will be taken to the highest level of proficiency in MS Excel 2016.  Before attempting this course you should have completed the \u003ca data-cke-saved-href=\"https:\/\/www.ebsi.ie\/products\/excel-2016-essentials\" href=\"https:\/\/www.ebsi.ie\/products\/excel-2016-essentials\" target=\"_blank\"\u003eEssentials\u003c\/a\u003e, \u003ca data-cke-saved-href=\"https:\/\/www.ebsi.ie\/products\/excel-2016-advanced\" href=\"https:\/\/www.ebsi.ie\/products\/excel-2016-advanced\" target=\"_blank\"\u003eAdvanced\u003c\/a\u003e and \u003ca data-cke-saved-href=\"https:\/\/www.ebsi.ie\/products\/excel-2016-expert\" href=\"https:\/\/www.ebsi.ie\/products\/excel-2016-expert\" target=\"_blank\"\u003eExpert\u003c\/a\u003e courses. \u003cbr\u003e\u003c\/p\u003e\n\u003cp\u003eObjectives: This course takes users to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts.\u003c\/p\u003e\n\u003cp\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\u003e\u003cbr\u003e\u003c\/p\u003e\n\u003ch5\u003eUnit Contents:\u003cbr\u003e\n\u003c\/h5\u003e\n\u003cp\u003e\u003cbr\u003e\u003cstrong\u003e1. Getting Started\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover a basic introduction to the course unit and its objectives.\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003e2. Working with Lists\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover:\u003cbr\u003eWorking with Lists\u003cbr\u003eCreating a List\u003cbr\u003eMaintaining a List\u003cbr\u003eEditing Records Using the Data Form\u003cbr\u003eFiltering a List\u003cbr\u003eUsing Subtotals in a List \u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003e3. Macros and User Defined Functions\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover:\u003cbr\u003eMacros and User Defined Functions\u003cbr\u003eRecording and Using Macros\u003cbr\u003eAssigning Macros\u003cbr\u003eUsing User-Defined Functions\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003e4. Basic Analysis Tools\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover:\u003cbr\u003eBasic Analysis Tools\u003cbr\u003ePerforming “What If” Analyses\u003cbr\u003eWorking with Scenarios\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003e5. Advance Analysis Tools and External Data\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover:\u003cbr\u003eAdvance Analysis Tools and External Data\u003cbr\u003eQuerying a Database\u003cbr\u003eImporting and Exporting Files\u003cbr\u003eProtecting Data\u003cbr\u003eUsing Data Validation\u003cbr\u003eUsing Worksheet Protection\u003cbr\u003ePassword Protecting a Workbook\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003e6. Pivot Tables \u0026amp; Advanced Business Analysis Tools\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover:\u003cbr\u003ePivot Tables \u0026amp; Advanced Business Analysis Tools\u003cbr\u003eWorking with Pivot Tables and Pivot Charts\u003cbr\u003eIdentifying the Parts of a Basic Pivot Table\u003cbr\u003ePivot Table Reports\u003cbr\u003eCreate a PivotTable from worksheet data\u003cbr\u003eCreate a PivotTable from an external data source\u003cbr\u003eCreate a PivotChart report from an existing PivotTable report\u003cbr\u003eDelete a PivotTable or PivotChart report\u003cbr\u003eSlicers\u003cbr\u003eUsing slicers\u003cbr\u003eFormatting slicers for a consistent look\u003cbr\u003eSharing slicers between PivotTables\u003cbr\u003eSparklines\u003cbr\u003eTypes of Sparklines\u003cbr\u003eCreate a sparkline\u003cbr\u003eCustomize sparklines\u003cbr\u003eControl which value points are shown\u003cbr\u003eChange the style of or format sparklines\u003cbr\u003eOnline Analytical Processing (OLAP)\u003cbr\u003eBusiness intelligence\u003cbr\u003eWhat is Online Analytical Processing (OLAP)?\u003cbr\u003eOLAP features in Excel 2016\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003e7. Wrapping Up \/ Assessment Result\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover:\u003cbr\u003eCourse Conclusion\u003cbr\u003eWrapping up\u003cbr\u003eTest Results Summary\u003c\/p\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-advanced\"\u003eExcel 2016 Advanced\u003c\/a\u003e  |  \u003ca href=\"\/products\/excel-2016-macros-and-vba\"\u003eExcel 2016 Macros and VBA\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 Master\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":35299090923680,"sku":"ITLU055","price":44.0,"currency_code":"USD","in_stock":true},{"title":"5 Licences (EUR 35 each)","offer_id":59260638921052,"sku":null,"price":193.0,"currency_code":"USD","in_stock":true},{"title":"10 Licences (EUR 30 each)","offer_id":59260638953820,"sku":null,"price":330.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0077\/7604\/3071\/products\/ITLU055Excel2016MasterCover_783a0e6d-24ed-477f-8b3d-ad700c2a7ec9.png?v=1595691195","url":"https:\/\/www.ebsiamericas.com\/products\/excel-2016-master","provider":"eBSI Export Academy","version":"1.0","type":"link"}