COVID-19 Campus Updates and Resources: Wearing a face mask and practicing physical distancing are required. Visit our Stay Healthy, Stay Safe. Navigating COVID-19 Together website for more information.

Spring 2021 Course List: This course list identifies face-to-face classes that will be delivered via Zoom at their scheduled days and times through March 19. All other courses will run as scheduled at their designated days, times, and locations.

Extended hours: Many offices are open 8:00am–6:00pm weekdays through January 22. Offices with extended hours include Student Services, Business Office, Financial Aid, and Admissions.

This Event has expired.

Excel Formulas & Functions

Jan27

Date:
Monday, January 27, 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