Microsoft Excel® 2016

Microsoft Excel® 2016 Module 1
Working with Ranges

In Excel, a range is a group of two or more cells that work together rather than separately.  The range is the basic function that makes Excel a powerful tool, and it is discussed in this module. We start by learning how to fill a range with values, move or copy them, and insert or delete them.  After that we discuss range names and how to use them.  We conclude by discussing how to format fonts, colors, alignments, numbers, column widths, row heights, and other range options.
Selecting and Populating Ranges

• Moving, Inserting, and Deleting Ranges and Cells
• Merging Two or More Cells
• Using Touch Gestures
• Using and Defining Range Names
• Navigate the Workbook

Microsoft Excel® 2016 Module 2
Formulas, Worksheets, and Workbooks

Once a range is populated and formatted, it’s time to do something with that data.  In this module we discuss how to build formulas and incorporate Excel worksheet functions into your formulas.  We move on to discuss how to manipulate the worksheet, which is where you spend most time in Excel, then you will learn how worksheets and workbooks go together. We conclude by discussing how to format the look and feel of workbooks.

• Creating Excel Formulas
• Using Excel Functions
• Troubleshooting Formula Errors
• Navigating and Using Worksheets
• Formatting and Customizing Worksheets
• Creating and Using Workbooks
• Formatting and Customizing Workbooks

Microsoft Excel® 2016 Module 3
Using and Analyzing Data

Once you have your workbooks and worksheets created, it’s time to do something useful with your new tools.  In this module we first discuss how to import data into your worksheets to create useful information.  Next you will learn how to create printed copies of this information to share with others, and then we discuss how Excel is used to store and use non-numeric information in tables.  We conclude by discussing how to use Excel to analyze your captured information.

• Formatting Workbook Colors, Fonts, and Effects
• Applying Workbook Themes, Headers, and Footers
• Importing Data from Another Application
• Configuring and Printing Workbooks
• Understanding Tables
• Using and Editing Tables
• Creating a PivotTable

Microsoft Excel® 2016 Module 4
Visual Aids and Collaboration

Creating a visual representation of your data makes it easier for you and others to both understand and analyze it.  This module discusses how to create custom graphs and charts using the data in your worksheets, including how to add graphic objects like shapes, clip art, pictures, WordArt, and SmartArt images. We then discuss how to collaborate with others using Excel, such as adding comments, sharing a workbook, and working on a spreadsheet online.

• Chart Elements and Types
• Creating and Editing a Custom Chart or Graph
• Changing Chart Source Data
• Creating and Formatting Worksheet Graphics and Images
• Protecting and Sharing Workbooks
• Saving Excel Data as A Web Page
• Collaborate Online in Excel