Excel 2016 – PC


In this Excel 2016 – PC online course, you'll learn how Microsoft® Excel® 2016 delivers many new features and updates to the user experience and core functionality. With online integration with OneDrive®, Excel 2016 is a first-class spreadsheet tool.

Platform: Windows

Length: 1 hour 50 min

This title is available in the
Total Training All-Access library.

Subscribe Now


Presented by Dan Fanella, this Excel 2016 – PC training course will teach you the latest tips and tricks for working with formulas, tables, charts, and more. By the time you’re finished with this course, you’ll have a deep understanding of working with your data – from sharing and securing, to importing and exporting.

This training course is for Microsoft Office Excel 2016 for Windows.

Sample clip

A. Getting Started
What you’ll learn in this training
Excel spreadsheet structure overview
Creating and saving an Excel file
Interface overview

B. Work with Data and Datasets
Enter data into a cell
Create a dataset
Auto-fill data
Create simple calculations
Referencing cells
Auto-fill cell references
Format cell data
Cut and paste data

C. Create Formulas
Create multiple calculation formulas
Use AutoSum
Create an averaging formula
Retrieve the min and max value
Retrieve the number count
Create a correlation
Access and search for built in formulas

D. Manage Data and Datasets
Trace precedents
Trace dependents
Sort data
Changing text to columns
Setup data validation
Delete and insert columns and rows

E. Format Your Table
Merge cells
Label data
Change cell background color
Change table format
Freeze panes
Create conditional formatting
Insert images and objects

F. Work with Sheets
Name and add sheets
Reference cells in other sheets

G. Work with Charts
Insert a chart
Edit a chart
Change the chart type
Change chart data

H. Share and Secure Data
Protect a sheet
Hide and unhide columns and rows
Add comments to a cell
Save to OneDrive®
Invite people to share

I. Import and Export Data
Import data from text
Import data from Access®
Import data from XML file
Export Excel as CSV
Export spreadsheets to PDF
Export data as tab delimited text
Printing spreadsheets