Coronavirus (COVID-19) Information

Hawkeye will continue in an online format for course instruction and services for the remainder of the semester. See the full announcement.

Buildings are closed. Faculty and staff are working remotely and can be reached via email or phone.

We are updating the Coronavirus (COVID-19) Information web page as soon as new information is available. Students, faculty, and staff will also receive notifications via their Hawkeye email and the Hawkeye Alert. If you have any questions, please email preparedness.response@hawkeyecollege.edu.

Excel Formulas & Functions

Jun22

Date:
Monday, June 22, 2020

Time:
2:30pm–4:30pm

Location:
Cedar Falls Center 114

Map and Directions

Explore the many formulas and functions that Excel has to offer! Formulas and functions will expand the capabilities of your Excel workbooks and save you time. Start with a review of basic formula creation, using automation features such as AutoSum, AutoComplete, Flash Fill, Function Library, Insert Function, cell protection, and formula auditing/verification. Dive deeper to explore advanced functions such as Linking Workbooks/Worksheets, IF statements, SUMIF, IF AND, and IF OR statements to perform conditional calculations, and VLOOKUP, MATCH and INDEX for extracting information. Text functions and date/time functions will also be covered. Textbook is included. Prerequisite: Excel Level One course or equivalent experience.

Pre-registration required.

View complete course and registration information

Tags

  1. continuing education
  2. continuing education computers and technology
Back to top