{"product_id":"excel-2016-mastery-program","title":"Excel 2016 Mastery Program","description":"\u003cp\u003eDescription\u003c\/p\u003e\n\u003cp\u003eIn this course you will learn to dominate Excel 2016 with our program which will take you from:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eExcel 2016 Essentials\u003c\/li\u003e\n\u003cli\u003eExcel 2016 Advanced\u003c\/li\u003e\n\u003cli\u003eExcel 2016 Expert\u003c\/li\u003e\n\u003cli\u003eExcel 2016 Macros and VBA \u003c\/li\u003e\n\u003cli\u003eExcel 2016 Master\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eFollowing this course you will be in the top tier of Excel practitioners and will be the go-to person for any Excel wizardry needed in your organisation!  This course is a must have for Business people, Bankers, Financiers, Project Managers and anyone else who needs to become an absolute master of Excel 2016!  \u003c\/p\u003e\n\u003cp\u003e\u003cmeta charset=\"utf-8\"\u003e\u003cspan\u003eCompleting this course will confer 10 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\u003eEssentials Course Outline\u003c\/h5\u003e\n\u003cp\u003e \u003c\/p\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\u003cstrong\u003eCourse Outline\u003c\/strong\u003e\u003c\/span\u003e\u003c\/p\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\u003cp\u003e \u003c\/p\u003e\n\u003ch5\u003eAdvanced Course Outline\u003c\/h5\u003e\n\u003cp\u003e \u003c\/p\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\u003eUnit Contents:\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:\u003cspan\u003e \u003c\/span\u003e\u003cbr\u003eUsing Multiple Worksheets and Workbooks\u003cspan\u003e \u003c\/span\u003e\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:\u003cspan\u003e \u003c\/span\u003e\u003cbr\u003eCharting\u003cspan\u003e \u003c\/span\u003e\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:\u003cspan\u003e \u003c\/span\u003e\u003cbr\u003eAdvanced Functions\u003cspan\u003e \u003c\/span\u003e\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:\u003cspan\u003e \u003c\/span\u003e\u003cbr\u003eAdvanced Formatting\u003cspan\u003e \u003c\/span\u003e\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:\u003cspan\u003e \u003c\/span\u003e\u003cbr\u003eIn this topic you will cover:\u003cspan\u003e \u003c\/span\u003e\u003cbr\u003eNew Features in Excel 2016\u003cspan\u003e \u003c\/span\u003e\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:\u003cspan\u003e \u003c\/span\u003e\u003cbr\u003eCourse Conclusion\u003cbr\u003eWrapping up\u003cbr\u003eTest Results Summary\u003c\/p\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003ch5\u003eExpert Course Outline\u003c\/h5\u003e\n\u003cp\u003e \u003c\/p\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\u003cstrong\u003e\u003cspan\u003eCourse Outline\u003c\/span\u003e\u003c\/strong\u003e\u003c\/p\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\u003cp\u003e \u003c\/p\u003e\n\u003ch5\u003eMacros and VBA Course Outline\u003c\/h5\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eExcel 2016 Macros and VBA\u003c\/strong\u003e\u003cbr\u003e\u003cbr\u003eObjectives: This course covers automation and customising of Excel using macros and screen items (such as buttons and menus). It will also teach learners how to write macros using VB code and assign macros to screen items.\u003c\/p\u003e\n\u003cp\u003eUnit Contents:\u003c\/p\u003e\n\u003cp\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. Introduction \u0026amp; the Macro Recorder\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover:\u003cspan\u003e \u003c\/span\u003e\u003cbr\u003eIntroduction \u0026amp; the Macro Recorder\u003cspan\u003e \u003c\/span\u003e\u003cbr\u003eIntroduction\u003cbr\u003eDemonstration\u003cbr\u003eThe Excel Macro Recorder\u003cbr\u003eRelative and Absolute Recording\u003cbr\u003eMacro Storage\u003cbr\u003eMacro Shortcut Keys\u003cbr\u003eDeleting Macros\u003cbr\u003eExcel’s New File Format\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003e3. Creating \u0026amp; Editing Macros With VBA\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover:\u003cspan\u003e \u003c\/span\u003e\u003cbr\u003eCreating \u0026amp; Editing Macros With VBA\u003cspan\u003e \u003c\/span\u003e\u003cbr\u003eMacro Storage Concepts\u003cbr\u003eThe VB Editor\u003cbr\u003eWorking With Modules\u003cbr\u003eEditing Macros\u003cbr\u003eCopying Macros\u003cbr\u003eLinking Macros\u003cbr\u003eUser-Defined Functions\u003cbr\u003eGlobally Available User-Defined Functions\u003cbr\u003eAuto Executable Macros\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003e4. Objects and Dialog Boxes\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover:\u003cspan\u003e \u003c\/span\u003e\u003cbr\u003eObjects and Dialog Boxes\u003cspan\u003e \u003c\/span\u003e\u003cbr\u003eObjects\u003cbr\u003eThe VBA Object Browser\u003cbr\u003eBuilt-In Dialog Boxes\u003cbr\u003eCustom Dialog Boxes\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003e5. Introduction to Controls\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover:\u003cspan\u003e \u003c\/span\u003e\u003cbr\u003eIntroduction to Controls\u003cspan\u003e \u003c\/span\u003e\u003cbr\u003eWorksheet Controls\u003cbr\u003eIntroduction to User Forms\u003cbr\u003eAccessing your Macros in Excel\u003cbr\u003eSelf-test Quiz\u003cbr\u003e\u003cbr\u003e\u003cstrong\u003e6. Wrapping Up \/ Assessment Result\u003c\/strong\u003e\u003cbr\u003eIn this topic you will cover:\u003cspan\u003e \u003c\/span\u003e\u003cbr\u003eCourse Conclusion\u003cbr\u003eWrapping up\u003cbr\u003eTest Results Summary\u003c\/p\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003ch5\u003eMaster Course Outline\u003c\/h5\u003e\n\u003cp\u003e \u003c\/p\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\u003cspan\u003e \u003c\/span\u003e\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,\u003cspan\u003e \u003c\/span\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\u003cspan\u003e \u003c\/span\u003eand\u003cspan\u003e \u003c\/span\u003e\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\u003cspan\u003e \u003c\/span\u003ecourses.\u003cspan\u003e \u003c\/span\u003e\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\u003eUnit Contents:\u003cbr\u003e\u003c\/p\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\u003cspan\u003e \u003c\/span\u003e\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\u003cp\u003e \u003c\/p\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 Mastery Program\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\n\u003c!-- ebsi-program-related-cpd --\u003e\n\u003cdiv class=\"ebsi-related-cpd\"\u003e\n\u003ch3\u003eRelated CPD Courses\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\u003ca href=\"\/products\/excel-2016-expert\"\u003eExcel 2016 Expert\u003c\/a\u003e\u003c\/li\u003e\n\u003cli\u003e\u003ca href=\"\/products\/excel-2016-advanced\"\u003eExcel 2016 Advanced\u003c\/a\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"eBSI Export Academy","offers":[{"title":"Default Title","offer_id":35299189883040,"sku":"EXCELMASTERY","price":110.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0077\/7604\/3071\/products\/Excel2016MasteryBundle.png?v=1595691990","url":"https:\/\/www.ebsiamericas.com\/products\/excel-2016-mastery-program","provider":"eBSI Export Academy","version":"1.0","type":"link"}