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

Lesson 2: Performing Calculations
     Create Worksheet Formulas
     Insert Functions
     Reuse Formulas and Functions

Lesson 3: 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: ITOFF6004h3 Rhonda Wetzler
1:00 PM - 4:30 PM Location: Hickory Hall, Hickory 128
Sessions: 2 Tu W 5407 N. University Peoria, IL 61635
10/3/2017 - 10/4/2017 Fee: $140.00
 

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

© Illinois Central College. All Rights Reserved.