Course Outline:

Excel 2016 Essentials:

Module One: Create and Manage Worksheets and Workbooks

•Create Worksheets and Workbooks

oCreate a workbook

oImport data from a delimited text file

oAdd a worksheet to an existing workbook

oCopy and move a worksheet

•Navigate in Worksheets and Workbooks

oSearch for data within a workbook

oNavigate to a named cell, range, or workbook element

oInsert and remove hyperlinks

•Format Worksheets and Workbooks

oChange worksheet tab color

oRename a worksheet

oChange worksheet order

oModify page setup

oInsert and delete columns or rows

oChange Workbook themes

oAdjust row height and column width

oInsert headers and footers

•Customize Options and Views for Worksheets and Workbooks

oHide or unhide worksheets

oHide or unhide columns and rows

oCustomize the Quick Access toolbar

oChange workbook views

oChange window views

oModify document properties

oChange magnification by using zoom tools

oDisplay formulas

•Configure Worksheets and Workbooks for Distribution

oSet a print area

oSave workbooks in alternative file formats

oPrint all or part of a workbook

oSet print scaling

oDisplay repeating row and column titles on multiple worksheets

oInspect a workbook for hidden properties or personal information

oInspect a workbook for accessibility issues

oInspect a workbook for compatibility issues

Module Two: Manage Data Cells and Ranges

•Insert data in cells and ranges

oReplace data

oCut, copy, or paste data

oPaste data by using special paste options fill cells using Auto Fill

oInsert and delete cells

•Format cells and ranges

oMerge cells

oModify cell alignment and indentation

oFormat cells by using Format Painter

oWrap text within cells

oApply number formats

oApply cell formats, apply cell styles

•Summarize and organize data

oInsert sparklines

oOutline data

oInsert subtotals

oApply conditional formatting

Module Three: Create tables

•Create and manage tables

oCreate an Excel table from a cell range

oConvert a table to a cell range

oAdd or remove table rows and columns

•Manage table styles and options

oApply styles to tables

oConfigure table style options

oInsert total rows

•Filter and sort a table

oFilter records

oSort data by multiple columns

oChange sort order

oRemove duplicate records

Module Four: Perform operations with formulas and functions

•Summarize data by using functions

oInsert references

oPerform calculations by using the SUM function

Perform calculations by using MIN and MAX functions

oPerform calculations by using the COUNT function

oPerform calculations by using the AVERAGE function

•Perform conditional operations by using functions

oPerform logical operations by using the IF function

oPerform logical operations by using the SUMIF function

oPerform logical operations by using the AVERAGEIF function

oPerform statistical operations by using the COUNTIF function

•Format and modify text by using functions

oFormat text by using RIGHT, LEFT, and MID functions

oFormat text by using UPPER, LOWER, and PROPER functions

oFormat text by using the CONCATENATE function

Module Five: Create charts and objects

•Create charts

oCreate a new chart

oAdd additional data series

oSwitch between rows and columns in source data

oAnalyze data by using Quick Analysis

•Format graphic elements

oResize charts

oAdd and modify chart elements

oApply chart layouts and styles

oMove charts to a chart sheet

•Insert and format objects

oInsert text boxes and shapes

oInsert images

oModify object properties

oAdd alternative text to objects for accessibility