Lesson 1: Getting Started with Excel 2016

• Starting Excel With Excel 2016
• Using the Ribbon as the Excel 2016 User Interface
• Navigating within the Worksheet
• Selecting a Cell or Range of Cells
• Entering Data
• Entering Cell Contents
• Cutting, Copying, and Pasting Cell Values
• Copy and Paste Special
• Saving your Workbook
• Opening your Workbook

Lesson 2: Managing Rows & Columns in Excel 2016

• Inserting, Moving & Deleting Cells
• Managing Columns and Rows
• Hide and Unhide Rows & Columns
• Changing Column Width & Row Height

Lesson 3: Managing Worksheets in Excel 2016

• Format Worksheet Tabs
• Insert and Delete Worksheet
• Move and Copy Worksheet
• Hide & Unhide Worksheet

Lesson 4: Formatting Cells in Excel 2016

• Formatting the Cell
• Number and Date Formatting
• Finding and Replacing Text
• Working with Styles

Lesson 5: Working with Formulas & Functions

• Excel Arithmetic Operators & Order of Operations
• Using Auto Fill Options
• Using Commonly Used Functions
• Writing simple & useful Formulas on your own

Lesson 6: Organizing Worksheet & Table Data

• Create and Modify Tables
• Sorting and Filtering Data in a Table
• Getting Summary Information in a Table
• Formatting a Table For Reporting

Lesson 7: Working with Charts

• Summarizing Data Visually Using Charts
• Customizing Chart Data
• Format Chart Legend and Titles
• Change the Chart Body
• Saving the Chart as a Template
• Creating a Pie Chart
• Using Chart Titles & Placing Charts

Lesson 8: Working with Graphics

• Adding Pictures into a Worksheet
• Customizing Pictures and Objects
• Adding Drawing Objects into a Worksheet
• Adding SmartArt into a Worksheet
• Adding Clip Art into a Worksheet

Lesson 9: Managing Large Workbooks with Excel 2016

• Managing Large Workbooks
• Printing Worksheets
• Setting Page Setup Options
• Setting Page Breaks

Lesson 10: Customizing & Enhancing Workbooks

• Customizing Excel to the Way You Work
• Creating Hyperlinks
• Working with Workbook Themes
• Working with Templates
• New Templates in Excel 2016