Print Course information
E-mail to a friend
Return to Course Catalog

Workshops > Microsoft Office 2016

MS Excel 2016 Part 1  

This course aims to provide you with a foundation for Excel knowledge and skills. Upon successful completion of this course, you will be able to create and develop Excel worksheets and workbooks in order to work with and analyze the data that is critical to the success of your organization.

This workshop is a blended training experience that includes instructor-led classroom time plus these online components available to you on any mobile device.

  • E-Book – an electronic version of your printed book, readable on any computer or mobile device
  • Files – the practice files used in the instructor-led class
  • Assessments – Detailed evaluations based on course content
  • Learn To – Short video tutorials reinforcing and expanding key concepts of the course
  • Checklist – Quick reference material and step-by-step instructions for tasks covered in the class in an easy-to-find format

Topics Covered
Getting Started with Microsoft Office Excel 2016
     Navigate the Excel User Interface
     Use Excel Commands
     Create and Save a Basic Workbook
     Enter Cell Data
     Use Excel Help

Performing Calculations
     Create Worksheet Formulas
     Insert Functions
     Reuse Formulas and Functions

Modifying a Worksheet
     Insert, Delete, and Adjust Cells, Columns, and Rows
     Search for and Replace Data
     Use Proofing and Research Tools

Formatting a Worksheet
     Apply Text Formats
     Apply Number Formats
     Align Cell Contents
     Apply Styles and Themes
     Apply Basic Conditional Formatting
     Create and Use Templates

Printing Workbooks
      Preview and Print a Workbook
     Set Up the Page Layout
     Configure Headers and Footers

Managing Workbooks
     Manage Worksheets
     Manage Workbook and Worksheet Views
     Manage Workbook Properties

Download Class Files


MS Excel 2016 Part 1
Item: ITOFF6004h4
1:00 PM - 4:30 PM Location: Hickory Hall, Hickory 128
Sessions: 2 M Tu 5407 N. University Peoria, IL 61635
11/19/2018 - 11/20/2018 Fee: $140.00

MS Excel 2016 Part 1
Item: ITOFF6004h5
1:00 PM - 4:30 PM Location: Hickory Hall, Hickory 128
Sessions: 2 W Th 5407 N. University Peoria, IL 61635
2/6/2019 - 2/7/2019 Fee: $140.00

MS Excel 2016 Part 1
Item: ITOFF6004hLAB
  This is the online-only version of this workshop. You'll receive all of the online components listed above in addition to the optional virtual labs. Instructor-led training is not included
  Fee: $50.00

The Professional Development Institute
Illinois Central College Peoria Campus
5407 N. University St. Peoria, IL. 61635

© Illinois Central College. All Rights Reserved.