Skip to main content

Microsoft Excel Formulas & Functions

ID : 4349   
« 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 - Tue

Location
Business & Technology Center

Instructor
James Flack 

CEUs : 0.6

Tuition: 

$129.00


Registration Closes On
Sunday, April 19, 2020 @ 12:00 AM

Schedule Information

Date(s) Class Days Times Location Instructor(s)
4/21/2020 - 5/5/2020 Weekly - Tue 3:30 PM - 5:30 PM Marshalltown, Business & Technology Center  Map, Room: 201 Computer Lab James Flack