{"product_id":"excel-2016-advanced","title":"Excel 2016 Advanced","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 Advanced.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eExcel 2016 Advanced Objectives: This course will take learners to a high level of knowledge using financial topics available in Excel such as Financial functions, auditing and Charts.\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 Advanced 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\u003eStudy time:\u003c\/strong\u003e approximately 2 hours.\u003c\/li\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\u003eExcel 2016 Advanced\u003c\/strong\u003e\u003cbr\u003e\u003cbr\u003eObjectives: This course will take learners 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 \u003c\/p\u003e\n\u003ch5\u003eUnit Contents:\u003c\/h5\u003e\n\u003cp\u003e\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003e 1. 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\u003e 2. Using Multiple Worksheets and Workbooks\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover: \u003cbr\u003eUsing Multiple Worksheets and Workbooks \u003cbr\u003eUsing Multiple Worksheets\u003cbr\u003eInserting New Worksheets\u003cbr\u003eRenaming Worksheets\u003cbr\u003eDeleting Worksheets\u003cbr\u003eCreating Multiple Views\u003cbr\u003eFreezing Panes\u003cbr\u003eViewing and Arranging Multiple Worksheet Windows\u003cbr\u003eNavigating in Multiple Workbooks\u003cbr\u003eSelecting and Viewing Multiple Workbooks\u003cbr\u003eManaging Multiple Worksheets and Workbooks\u003cbr\u003eSelecting Multiple Worksheets\u003cbr\u003eMoving and Copying Data between Worksheets\u003cbr\u003eLinking Data Between Worksheets\u003cbr\u003eCreating a 3-D Formula\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003e 3. Charting\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover: \u003cbr\u003eCharting \u003cbr\u003eUsing Charts\u003cbr\u003eCreating a Chart\u003cbr\u003eChanging Chart Type, Style and Chart Sub-Type\u003cbr\u003eChangesto the Chart Source Data\u003cbr\u003eAdd data to an existing chart\u003cbr\u003eChange the data in an existing chart\u003cbr\u003eRemove data from a chart\u003cbr\u003eManaging Chart Objects    \u003cbr\u003eMoving and Resizing Chart Objects\u003cbr\u003eDeleting Chart Objects\u003cbr\u003eAdding Data Series and Objects to a Chart\u003cbr\u003eChanging the Chart Type\u003cbr\u003eFormatting Chart Objects\u003cbr\u003ePrinting Charts\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003e 4. Advanced Functions\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover: \u003cbr\u003eAdvanced Functions \u003cbr\u003eCreating and Using Functions\u003cbr\u003eUsing Built-in Functions\u003cbr\u003eWorking with Arguments: The PMT Function\u003cbr\u003eUsing Dates and Times\u003cbr\u003eUsing Dates in Calculations\u003cbr\u003eUsing Nested Functions\u003cbr\u003eAuditing Worksheets\u003cbr\u003eIdentifying the Auditing Commands\u003cbr\u003eThe Watch Window\u003cbr\u003eThe Formula Evaluator\u003cbr\u003eTracing and Correcting Worksheet Errors\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003e 5. Advanced Formatting\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover: \u003cbr\u003eAdvanced Formatting \u003cbr\u003eUsing Comments in a Worksheet\u003cbr\u003eReviewing, Showing, and Hiding Comments\u003cbr\u003eDeleting a Comment\u003cbr\u003eWorking with Styles\u003cbr\u003eApplying a Style\u003cbr\u003eModifying Existing Styles\u003cbr\u003eUsing Format Painter\u003cbr\u003eCreating Custom Number Formats\u003cbr\u003eApplying an AutoFormat (Table Format)\u003cbr\u003eConditional Formats\u003cbr\u003eClear conditional formats\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003e 6. New Features in Excel 2016\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover: \u003cbr\u003eIn this topic you will cover: \u003cbr\u003eNew Features in Excel 2016 \u003cbr\u003eWhat’s New in Excel 2016\u003cbr\u003eCompatibility\u003cbr\u003eBenefits in the new version\u003cbr\u003eFile Types\u003cbr\u003eThe Ribbon\u003cbr\u003eThe Quick Access Toolbar\u003cbr\u003eDifferent Screen Resolutions - Solutions\u003cbr\u003eKeyboard shortcuts in Excel 2016 (KEY TIPS)\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003e 7. Wrapping Up \/ Assessment Result\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover: \u003cbr\u003eCourse Conclusion\u003cbr\u003eWrapping up\u003cbr\u003eTest Results Summary\u003cbr\u003e\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\u003eNext course:\u003c\/strong\u003e \u003ca href=\"\/products\/excel-2016-master\"\u003eExcel 2016 Master\u003c\/a\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eLearners also take:\u003c\/strong\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 Advanced\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":35286895165600,"sku":"ITLU054","price":44.0,"currency_code":"USD","in_stock":true},{"title":"5 Licences (EUR 35 each)","offer_id":59260638593372,"sku":null,"price":193.0,"currency_code":"USD","in_stock":true},{"title":"10 Licences (EUR 30 each)","offer_id":59260638626140,"sku":null,"price":330.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0077\/7604\/3071\/products\/ITLU054Excel2016AdvancedCover.png?v=1595612485","url":"https:\/\/www.ebsiamericas.com\/products\/excel-2016-advanced","provider":"eBSI Export Academy","version":"1.0","type":"link"}