Skip to main content

Excel Formulas & Functions

ID : 40260   
« back to classes page
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.
 

Class Details

3 Sessions
Weekly - Mon

Location
Cedar Falls Center

Instructor
James Flack 

CEUs : 0.6

Tuition 

$129.00


Registration Closes On
Tuesday, January 21, 2020 @ 11:59 PM

Schedule Information

Date(s) Class Days Times Location Instructor(s)
1/27/2020 - 2/10/2020 Weekly - Mon 2:30 PM - 4:30 PM Cedar Falls, Cedar Falls Center  Map, Room: 114 James Flack