Course Detail: CMP500 - Working with Functions in ExcelŽ 2019

Learn to use the various calculations and consolidation functions that ExcelŽ has to offer!

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 this course will help you get there!




Course Topics:

- Working with ranges
- Using specialized, logical, date and time, and text functions

Prerequisite: Basic knowledge of ExcelŽ.


This class has two options to participate:


1. Fully in-person at Purdue Fort Wayne. Students will participate in live sessions during the schedule course days and times.


2. Fully online via Zoom. Students will participate in the live sessions during scheduled course days and times. (Online Course Requirements: Students should have access to MS Excel 2019 or newer, a reliable internet connection, and a computer camera and microphone).

You will be able to select the option that works for you (ONLINE or IN-PERSON) at time of registration.

Available Sessions - Click on date(s) below.