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