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

Workshops > Microsoft Office 2016

MS Excel 2016 Part 2  

You already know how to get Excel to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But, Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data. In other words, when you have questions about your data, you need to know how to get Excel to provide the answers for you. And that's exactly what this course aims to help you do.

This course builds upon the foundational knowledge presented in the MS Excel 2016: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence.

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
Working with Functions
     Work with Ranges
     Use Specialized Functions
     Work with Logical Functions
     Work with Date & Time Functions
     Work with Text Functions

Working with Lists
     Sort Data
     Filter Data
     Query Data with Database Functions
     Outline and Subtotal Data

Analyzing Data
     Create and Modify Tables
     Apply Intermediate Conditional Formatting
     Apply Advanced Conditional Formatting

Visualizing Data with Charts
     Create Charts
     Modify and Format Charts
     Use Advanced Chart Features

Using PivotTables and PivotCharts
     Create a PivotTable
     Analyze PivotTable Data
     Present Data with PivotCharts
     Filter Data by Using Timelines and Slicers

Download Class Files

 

MS Excel 2016 Part 2
Item: ITOFF6005HLAB
  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
 
 

MS Excel 2016 Part 2
Item: ITOFF6005H3
1:00 PM - 4:30 PM Location: Hickory Hall, Hickory 128
Sessions: 2 Th F 5407 N. University Peoria, IL 61635
1/11/2018 - 1/12/2018 Fee: $140.00
 

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

© Illinois Central College. All Rights Reserved.