{"product_id":"excel-2016-essentials","title":"Excel 2016 Essentials","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 Essentials.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eParticipants will gain a fundamental understanding of the Excel environment and the ability to complete tasks independently. They will know and demonstrate the correct application of the principal features of Excel 2016. Participants will create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook examples include professional looking budgets, financial...\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 Essentials 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\u003cspan\u003eParticipants will gain a fundamental understanding of the Excel environment and the ability to complete tasks independently. They will know and demonstrate the correct application of the principal features of Excel 2016. Participants will create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook examples include professional looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.\u003c\/span\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cspan\u003e\u003cmeta charset=\"utf-8\"\u003eCompleting this course will confer 2 CPD Credits towards internationally recognised \u003cstrong\u003eContinuous Professional Development\u003c\/strong\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\u003e\u003cspan style=\"text-decoration: underline;\"\u003e\u003cstrong\u003eCourse Outline\u003c\/strong\u003e\u003c\/span\u003e\u003c\/h5\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule One: Create and Manage Worksheets and Workbooks\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eCreate Worksheets and Workbooks\n\u003cul\u003e\n\u003cli\u003eCreate a workbook\u003c\/li\u003e\n\u003cli\u003eImport data from a delimited text file\u003c\/li\u003e\n\u003cli\u003eAdd a worksheet to an existing workbook\u003c\/li\u003e\n\u003cli\u003eCopy and move a worksheet\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eNavigate in Worksheets and Workbooks\n\u003cul\u003e\n\u003cli\u003eSearch for data within a workbook\u003c\/li\u003e\n\u003cli\u003eNavigate to a named cell, range, or workbook element\u003c\/li\u003e\n\u003cli\u003eInsert and remove hyperlinks\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eFormat Worksheets and Workbooks\n\u003cul\u003e\n\u003cli\u003eChange worksheet tab color\u003c\/li\u003e\n\u003cli\u003eRename a worksheet\u003c\/li\u003e\n\u003cli\u003eChange worksheet order\u003c\/li\u003e\n\u003cli\u003eModify page setup\u003c\/li\u003e\n\u003cli\u003eInsert and delete columns or rows\u003c\/li\u003e\n\u003cli\u003eChange Workbook themes\u003c\/li\u003e\n\u003cli\u003eAdjust row height and column width\u003c\/li\u003e\n\u003cli\u003eInsert headers and footers\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eCustomize Options and Views for Worksheets and Workbooks\n\u003cul\u003e\n\u003cli\u003eHide or unhide worksheets\u003c\/li\u003e\n\u003cli\u003eHide or unhide columns and rows\u003c\/li\u003e\n\u003cli\u003eCustomize the Quick Access toolbar\u003c\/li\u003e\n\u003cli\u003eChange workbook views\u003c\/li\u003e\n\u003cli\u003eChange window views\u003c\/li\u003e\n\u003cli\u003eModify document properties\u003c\/li\u003e\n\u003cli\u003eChange magnification by using zoom tools\u003c\/li\u003e\n\u003cli\u003eDisplay formulas\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eConfigure Worksheets and Workbooks for Distribution\n\u003cul\u003e\n\u003cli\u003eSet a print area\u003c\/li\u003e\n\u003cli\u003eSave workbooks in alternative file formats\u003c\/li\u003e\n\u003cli\u003ePrint all or part of a workbook\u003c\/li\u003e\n\u003cli\u003eSet print scaling\u003c\/li\u003e\n\u003cli\u003eDisplay repeating row and column titles on multiple worksheets\u003c\/li\u003e\n\u003cli\u003eInspect a workbook for hidden properties or personal information\u003c\/li\u003e\n\u003cli\u003eInspect a workbook for accessibility issues\u003c\/li\u003e\n\u003cli\u003eInspect a workbook for compatibility issues\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Two: Manage Data Cells and Ranges\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eInsert data in cells and ranges\n\u003cul\u003e\n\u003cli\u003eReplace data\u003c\/li\u003e\n\u003cli\u003eCut, copy, or paste data\u003c\/li\u003e\n\u003cli\u003ePaste data by using special paste options fill cells by using Auto Fill\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eInsert and delete cells\u003c\/li\u003e\n\u003cli\u003eFormat cells and ranges\n\u003cul\u003e\n\u003cli\u003eMerge cells\u003c\/li\u003e\n\u003cli\u003eModify cell alignment and indentation\u003c\/li\u003e\n\u003cli\u003eFormat cells by using Format Painter\u003c\/li\u003e\n\u003cli\u003eWrap text within cells\u003c\/li\u003e\n\u003cli\u003eApply number formats\u003c\/li\u003e\n\u003cli\u003eApply cell formats, apply cell styles\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eSummarize and organize data\n\u003cul\u003e\n\u003cli\u003eInsert sparklines\u003c\/li\u003e\n\u003cli\u003eOutline data\u003c\/li\u003e\n\u003cli\u003eInsert subtotals\u003c\/li\u003e\n\u003cli\u003eApply conditional formatting\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 tables\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eCreate and manage tables\n\u003cul\u003e\n\u003cli\u003eCreate an Excel table from a cell range\u003c\/li\u003e\n\u003cli\u003eConvert a table to a cell range\u003c\/li\u003e\n\u003cli\u003eAdd or remove table rows and columns\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eManage table styles and options\n\u003cul\u003e\n\u003cli\u003eApply styles to tables\u003c\/li\u003e\n\u003cli\u003eConfigure table style options\u003c\/li\u003e\n\u003cli\u003eInsert total rows\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eFilter and sort a table\n\u003cul\u003e\n\u003cli\u003eFilter records\u003c\/li\u003e\n\u003cli\u003eSort data by multiple columns\u003c\/li\u003e\n\u003cli\u003eChange sort order\u003c\/li\u003e\n\u003cli\u003eRemove duplicate records\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Four: Perform operations with formulas and functions\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eSummarize data by using functions\n\u003cul\u003e\n\u003cli\u003eInsert references\u003c\/li\u003e\n\u003cli\u003ePerform calculations by using the SUM function\u003c\/li\u003e\n\u003cli\u003ePerform calculations by using MIN and MAX functions\u003c\/li\u003e\n\u003cli\u003ePerform calculations by using the COUNT function\u003c\/li\u003e\n\u003cli\u003ePerform calculations by using the AVERAGE function\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003ePerform conditional operations by using functions\n\u003cul\u003e\n\u003cli\u003ePerform logical operations by using the IF function\u003c\/li\u003e\n\u003cli\u003ePerform logical operations by using the SUMIF function\u003c\/li\u003e\n\u003cli\u003ePerform logical operations by using the AVERAGEIF function\u003c\/li\u003e\n\u003cli\u003ePerform statistical operations by using the COUNTIF function\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eFormat and modify text by using functions\n\u003cul\u003e\n\u003cli\u003eFormat text by using RIGHT, LEFT, and MID functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eFormat text by using UPPER, LOWER, and PROPER functions\u003c\/li\u003e\n\u003cli\u003eFormat text by using the CONCATENATE function\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp class=\"ng-scope\"\u003e\u003cstrong\u003eModule Five: Create charts and objects\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul class=\"ng-scope\"\u003e\n\u003cli\u003eCreate charts\n\u003cul\u003e\n\u003cli\u003eCreate a new chart\u003c\/li\u003e\n\u003cli\u003eAdd additional data series\u003c\/li\u003e\n\u003cli\u003eSwitch between rows and columns in source data\u003c\/li\u003e\n\u003cli\u003eAnalyze data by using Quick Analysis\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eFormat graphic elements\n\u003cul\u003e\n\u003cli\u003eResize charts\u003c\/li\u003e\n\u003cli\u003eAdd and modify chart elements\u003c\/li\u003e\n\u003cli\u003eApply chart layouts and styles\u003c\/li\u003e\n\u003cli\u003eMove charts to a chart sheet\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003eInsert and format objects\n\u003cul\u003e\n\u003cli\u003eInsert text boxes and shapes\u003c\/li\u003e\n\u003cli\u003eInsert images\u003c\/li\u003e\n\u003cli\u003eModify object properties\u003c\/li\u003e\n\u003cli\u003eAdd alternative text to objects for accessibility\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\u003eNext course:\u003c\/strong\u003e \u003ca href=\"\/products\/excel-2016-expert\"\u003eExcel 2016 Expert\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 Essentials\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":14359101177919,"sku":"ITLU002","price":44.0,"currency_code":"USD","in_stock":true},{"title":"5 Licences (EUR 35 each)","offer_id":59260628435292,"sku":null,"price":193.0,"currency_code":"USD","in_stock":true},{"title":"10 Licences (EUR 30 each)","offer_id":59260628468060,"sku":null,"price":330.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0077\/7604\/3071\/products\/ITLU002_Excel_2016_Essentials_1.png?v=1590011818","url":"https:\/\/www.ebsiamericas.com\/products\/excel-2016-essentials","provider":"eBSI Export Academy","version":"1.0","type":"link"}