{"product_id":"excel-2016-essentials","title":"Excel 2016 Essentials","description":"\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 example 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\u003eModule One: Create and Manage Worksheets and Workbooks\u003cbr\u003e• Create Worksheets and Workbooks\u003cbr\u003eo Create a workbook\u003cbr\u003eo Import data from a delimited text file\u003cbr\u003eo Add a worksheet to an existing workbook\u003cbr\u003eo Copy and move a worksheet\u003cbr\u003e• Navigate in Worksheets and Workbooks\u003cbr\u003eo Search for data within a workbook\u003cbr\u003eo Navigate to a named cell, range, or workbook element\u003cbr\u003eo Insert and remove hyperlinks\u003cbr\u003e• Format Worksheets and Workbooks\u003cbr\u003eo Change worksheet tab colour\u003cbr\u003eo Rename a worksheet\u003cbr\u003eo Change worksheet order\u003cbr\u003eo Modify page setup\u003cbr\u003eo Insert and delete columns or rows\u003cbr\u003eo Change Workbook themes\u003cbr\u003eo Adjust row height and column width\u003cbr\u003eo Insert headers and footers\u003cbr\u003e• Customize Options and Views for Worksheets and Workbooks\u003cbr\u003eo Hide or unhide worksheets\u003cbr\u003eo Hide or unhide columns and rows\u003cbr\u003eo Customize the Quick Access toolbar\u003cbr\u003eo Change workbook views\u003cbr\u003eo Change window views\u003cbr\u003eo Modify document properties\u003cbr\u003eo Change magnification by using zoom tools\u003cbr\u003eo Display formulas\u003cbr\u003e• Configure Worksheets and Workbooks for Distribution\u003cbr\u003eo Set a print area\u003cbr\u003eo Save workbooks in alternative file formats\u003cbr\u003eo Print all or part of a workbook\u003cbr\u003eo Set print scaling\u003cbr\u003eo Display repeating row and column titles on multiple worksheets\u003cbr\u003eo Inspect a workbook for hidden properties or personal information\u003cbr\u003eo Inspect a workbook for accessibility issues\u003cbr\u003eo Inspect a workbook for compatibility issues\u003cbr\u003e\u003cbr\u003eModule Two: Manage Data Cells and Ranges\u003cbr\u003e• Insert data in cells and ranges\u003cbr\u003eo Replace data\u003cbr\u003eo Cut, copy, or paste data\u003cbr\u003eo Paste data by using special paste options\u003cbr\u003efill cells by using Auto Fill\u003cbr\u003eo Insert and delete cells\u003cbr\u003e• Format cells and ranges\u003cbr\u003eo Merge cells\u003cbr\u003eo Modify cell alignment and indentation\u003cbr\u003eo Format cells by using Format Painter\u003cbr\u003eo Wrap text within cells\u003cbr\u003eo Apply number formats\u003cbr\u003eo Apply cell formats, apply cell styles\u003cbr\u003e• Summarize and organize data\u003cbr\u003eo Insert sparklines\u003cbr\u003eo Outline data\u003cbr\u003eo Insert subtotals\u003cbr\u003eo Apply conditional formatting\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eModule Three: Create tables\u003cbr\u003e• Create and manage tables\u003cbr\u003eo Create an Excel table from a cell range\u003cbr\u003eo Convert a table to a cell range\u003cbr\u003eo Add or remove table rows and columns\u003cbr\u003e• Manage table styles and options\u003cbr\u003eo Apply styles to tables\u003cbr\u003eo Configure table style options\u003cbr\u003eo Insert total rows\u003cbr\u003e• Filter and sort a table\u003cbr\u003eo Filter records\u003cbr\u003eo Sort data by multiple columns\u003cbr\u003eo Change sort order\u003cbr\u003eo Remove duplicate records\u003cbr\u003e\u003cbr\u003e\u003cbr\u003eModule Four: Perform operations with formulas and functions\u003cbr\u003e• Summarize data by using functions\u003cbr\u003eo Insert references\u003cbr\u003eo Perform calculations by using the SUM function\u003cbr\u003ePerform calculations by using MIN and MAX functions\u003cbr\u003eo Perform calculations by using the COUNT function\u003cbr\u003eo Perform calculations by using the AVERAGE function\u003cbr\u003e• Perform conditional operations by using functions\u003cbr\u003eo Perform logical operations by using the IF function\u003cbr\u003eo Perform logical operations by using the SUMIF function\u003cbr\u003eo Perform logical operations by using the AVERAGEIF function\u003cbr\u003eo Perform statistical operations by using the COUNTIF function\u003cbr\u003e• Format and modify text by using functions\u003cbr\u003eo Format text by using RIGHT, LEFT, and MID functions\u003cbr\u003eo Format text by using UPPER, LOWER, and PROPER functions\u003cbr\u003eo Format text by using the CONCATENATE function\u003cbr\u003e\u003cbr\u003eModule Five: Create charts and objects\u003cbr\u003e• Create charts\u003cbr\u003eo Create a new chart\u003cbr\u003eo Add additional data series\u003cbr\u003eo Switch between rows and columns in source data\u003cbr\u003eo Analyze data by using Quick Analysis\u003cbr\u003e• Format graphic elements\u003cbr\u003eo Resize charts\u003cbr\u003eo Add and modify chart elements\u003cbr\u003eo Apply chart layouts and styles\u003cbr\u003eo Move charts to a chart sheet\u003cbr\u003e• Insert and format objects\u003cbr\u003eo Insert text boxes and shapes\u003cbr\u003eo Insert images\u003cbr\u003eo Modify object properties\u003cbr\u003eo Add alternative text to objects for accessibility\u003c\/span\u003e\u003c\/p\u003e","brand":"My Store","offers":[{"title":"Default Title","offer_id":46499584803028,"sku":"excel_2016_essentials","price":25.0,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0751\/4882\/0692\/files\/microsoft-excel-2016.png?v=1779428554","url":"https:\/\/essatraining.com.au\/products\/excel-2016-essentials","provider":"Essential Soft Skills Academy","version":"1.0","type":"link"}