Participants 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. Module One: Create and Manage Worksheets and Workbooks• Create Worksheets and Workbookso Create a workbooko Import data from a delimited text fileo Add a worksheet to an existing workbooko Copy and move a worksheet• Navigate in Worksheets and Workbookso Search for data within a workbooko Navigate to a named cell, range, or workbook elemento Insert and remove hyperlinks• Format Worksheets and Workbookso Change worksheet tab colouro Rename a worksheeto Change worksheet ordero Modify page setupo Insert and delete columns or rowso Change Workbook themeso Adjust row height and column widtho Insert headers and footers• Customize Options and Views for Worksheets and Workbookso Hide or unhide worksheetso Hide or unhide columns and rowso Customize the Quick Access toolbaro Change workbook viewso Change window viewso Modify document propertieso Change magnification by using zoom toolso Display formulas• Configure Worksheets and Workbooks for Distributiono Set a print areao Save workbooks in alternative file formatso Print all or part of a workbooko Set print scalingo Display repeating row and column titles on multiple worksheetso Inspect a workbook for hidden properties or personal informationo Inspect a workbook for accessibility issueso Inspect a workbook for compatibility issuesModule Two: Manage Data Cells and Ranges• Insert data in cells and rangeso Replace datao Cut, copy, or paste datao Paste data by using special paste optionsfill cells by using Auto Fillo Insert and delete cells• Format cells and rangeso Merge cellso Modify cell alignment and indentationo Format cells by using Format Paintero Wrap text within cellso Apply number formatso Apply cell formats, apply cell styles• Summarize and organize datao Insert sparklineso Outline datao Insert subtotalso Apply conditional formattingModule Three: Create tables• Create and manage tableso Create an Excel table from a cell rangeo Convert a table to a cell rangeo Add or remove table rows and columns• Manage table styles and optionso Apply styles to tableso Configure table style optionso Insert total rows• Filter and sort a tableo Filter recordso Sort data by multiple columnso Change sort ordero Remove duplicate recordsModule Four: Perform operations with formulas and functions• Summarize data by using functionso Insert referenceso Perform calculations by using the SUM functionPerform calculations by using MIN and MAX functionso Perform calculations by using the COUNT functiono Perform calculations by using the AVERAGE function• Perform conditional operations by using functionso Perform logical operations by using the IF functiono Perform logical operations by using the SUMIF functiono Perform logical operations by using the AVERAGEIF functiono Perform statistical operations by using the COUNTIF function• Format and modify text by using functionso Format text by using RIGHT, LEFT, and MID functionso Format text by using UPPER, LOWER, and PROPER functionso Format text by using the CONCATENATE functionModule Five: Create charts and objects• Create chartso Create a new charto Add additional data serieso Switch between rows and columns in source datao Analyze data by using Quick Analysis• Format graphic elementso Resize chartso Add and modify chart elementso Apply chart layouts and styleso Move charts to a chart sheet• Insert and format objectso Insert text boxes and shapeso Insert imageso Modify object propertieso Add alternative text to objects for accessibility
