Microsoft Excel 2016 Essentials

Module One: Create and Manage Worksheets and Workbooks

• Create Worksheets and Workbooks
• Create a workbook
• Import data from a delimited text file
• Add a worksheet to an existing workbook
• Copy and move a worksheet
• Navigate in Worksheets and Workbooks
• Search for data within a workbook
• Navigate to a named cell, range, or workbook element
• Insert and remove hyperlinks
• Format Worksheets and Workbooks
• Change worksheet tab color
• Rename a worksheet
• Change worksheet order
• Modify page setup
• Insert and delete columns or rows
• Change Workbook themes
• Adjust row height and column width
• Insert headers and footers
• Customize Options and Views for Worksheets and Workbooks
• Hide or unhide worksheets
• Hide or unhide columns and rows
• Customize the Quick Access toolbar
• Change workbook views
• Change window views
• Modify document properties
• Change magnification by using zoom tools
• Display formulas
• Configure Worksheets and Workbooks for Distribution
• Set a print area
• Save workbooks in alternative file formats
• Print all or part of a workbook
• Display repeating row and column titles on multiple worksheets
  
• Inspect a workbook for hidden properties or personal information
• Inspect a workbook for accessibility issues
• Inspect a workbook for compatibility issues

Module Two: Manage Data Cells and Ranges

• Insert data in cells and ranges
• Replace data
• Cut, copy, or paste data
• Paste data by using special paste options
• fill cells by using Auto Fill
• Insert and delete cells
• Format cells and ranges
• Merge cells
• Modify cell alignment and indentation
• Format cells by using Format Painter
• Wrap text within cells
• Apply number formats
• Apply cell formats, apply cell styles
• Summarize and organize data
• Insert sparklines
• Outline data
• Insert subtotals
• Apply conditional formatting

Module Three: Create tables

• Create and manage tables
• Create an Excel table from a cell range
• Convert a table to a cell range
• Add or remove table rows and columns
• Manage table styles and options
• Apply styles to tables
• Configure table style options
• Insert total rows
• Filter and sort a table
• Filter records
• Sort data by multiple columns
• Change sort order
• Remove duplicate records

Module Four: Perform operations with formulas and functions

• Summarize data by using functions
• Insert references
• Perform calculations by using the SUM function
• Perform calculations by using MIN and MAX functions
• Perform calculations by using the COUNT function
• Perform calculations by using the AVERAGE function
• Perform conditional operations by using functions
• Perform logical operations by using the IF function
• Perform logical operations by using the SUMIF function
• Perform logical operations by using the AVERAGEIF function
• Perform statistical operations by using the COUNTIF function
• Format and modify text by using functions
• Format text by using RIGHT, LEFT, and MID functions
• Format text by using UPPER, LOWER, and PROPER functions
• Format text by using the CONCATENATE function

Module Five: Create charts and objects

• Create charts
• Create a new chart
• Add additional data series
• Switch between rows and columns in source data
• Analyze data by using Quick Analysis
• Format graphic elements
• Resize charts
• Add and modify chart elements
• Apply chart layouts and styles
• Move charts to a chart sheet
• Insert and format objects
• Insert text boxes and shapes
• Insert images
• Modify object properties
• Add alternative text to objects for accessibility