Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Microsoft Excel 2016 Course

Microsoft Excel 2016 Self Paced Training Course

Course Description: Learn all the new features of Microsoft Excel 2016. This Excel 2016 Self Paced online class covers the basic, intermediate and advanced features of Microsoft's newest spreadsheet program.

Price: 6-month User License: $99.00
Price: 12-month User License: $129.00

6-Month License $99

12-Month License $129

Microsoft Excel 2016 Self-Paced Course Syllabus

Getting Started with Excel 2016

  • Understanding the Excel Screen
  • Creating a Workbook
  • Navigating a Worksheet
  • Opening and Saving a Workbook
  • Printing a Workbook
  • Getting Help
  • Closing and Exiting
Editing a Workbook
  • Select Cells and Ranges
  • Edit Cell Data
  • Cut, Copy, and Paste
  • More Pasting Options
  • Using AutoFill
  • Inserting, Moving, and Deleting Cells
  • Checking Spelling
  • Finding and Replacing Text
  • Hiding Rows and Columns
Formatting Worksheets
  • Formatting Text
  • Cell Alignment and Merging Cells
  • Formatting Numbers and Dates
  • Borders and Background Colors
  • Copying Formatting
  • Row Heights and Column Widths
  • Applying Conditional Formatting
  • Applying and Removing Cell Styles
  • Creating and Modifying Cell Styles
  • Find and Replace Formatting
  • Inserting an Image
Building Formulas
  • Formula Basics
  • Working with Sums and Averages
  • Referencing External Worksheets
  • Absolute and Relative Cell References
  • Cell and Range Names
  • Financial Formulas
  • Logical Formulas
  • Text Formulas
  • VLOOKUP Formulas
  • Understanding Formula Errors
Viewing and Managing Worksheets
  • Viewing Worksheets
  • Moving and Copying Worksheets
  • Insert, Rename, and Delete Worksheets
  • Freezing Rows and Columns
  • Hiding Worksheets and Gridlines
Working with Charts
  • Creating a Chart
  • Moving, Resizing, and Deleting a Chart
  • Understanding Chart Types
  • Changing Chart Layout and Style
  • Working with Titles and Legends
  • Gridlines, Labels, and Data Tables
  • Formatting Chart Elements
  • Modify Chart Data
  • Filtering Charts
  • Sparklines
Printing Worksheets
  • Changing Page Size and Scale
  • Setting the Print Area and Viewing Page Breaks
  • Print Titles and Headings
  • Headers and Footers
  • Margins and Orientation
Working with Data and Tables
  • Sorting Data
  • Filtering Data
  • Using Quick Analysis
  • Working with Tables
  • Remove Duplicates and Total
  • Using Data Validation
  • Filtering with Slicers
  • Using Flash Fill
  • Import and Export Data
Collaborating with Excel
  • Working with Cell Comments
  • Sharing Workbooks
  • Tracking Changes in Workbooks
  • Protecting a Worksheet
  • Password Protecting a Workbook
  • Saving Worksheets as Web Pages
Working with PivotTables
  • Creating a PivotTable
  • Adding Multiple Fields to a PivotTable
  • Changing a PivotTable’s Calculation
  • Filtering a PivotTable
  • Working with Timelines
  • Working with PivotTable Layout
  • Grouping PivotTable Values
  • Refreshing a PivotTable
  • Formatting a PivotTable
  • Creating a PivotChart

Special Offers!

Special Offer: Get this class, along with all of our other available Microsoft Office self-paced training courses for only $149. See what is included in the Microsoft Office value package.

Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)

Featured Content

Ultimate Guide to Excel Charts and Graphs

Business Computer Skills BBB Profile