Introduction to Microsoft Excel

Overview

​

Learn the necessary skills and discover the best practices required to create, edit, format, and print basic Microsoft Excel worksheets. Our instructor-led online classes are conducted in the 2016 version of the software. Your instructor will point out the minor differences with earlier versions, where they exist. For our custom instructor-led online and onsite classes, we use the version of the software you use in your office. No prior product knowledge needed.

Course length: 3 days, Delivery: Online or in-person.

Call us at (475) 328-2227 with questions.

Course Objectives

​

  • Create basic worksheets using Microsoft Excel 2016.

  • Perform calculations in an Excel worksheet.

  • Modify an Excel worksheet.

  • Modify the appearance of data within a worksheet.

  • Manage Excel workbooks.

  • Print the content of an Excel worksheet.

  • Learn how to use handy features new in 2016.

 

Create and manage worksheets and workbooks

  • Create worksheets and workbooks

  • Format worksheets and workbooks

  • Customize options for worksheets and workbooks

  • Customize views for worksheets and workbooks

  • Modify Document Properties

​

Manage data cells and ranges

  • Insert data in cells and ranges

  • Manage data by using AutoFill

  • Move data within a workbook

​

Create Excel tables

  • Create and manage tables

  • Manage table styles and options

​

Perform operations with formulas and functions

  • Define named ranges

  • Navigate in worksheets and workbooks

  • Summarize data by using functions

  • Perform conditional operations by using functions

  • Format and modify text by using functions

  • Create a simple array formula

​

Present worksheet data

  • Format cells and ranges

  • Define Styles

  • Apply conditional formatting and filtering

Course Overview

Upcoming Dates:

Register