Welcome to DMACC Continuing Education
Getting the Most from Excel Formulas and Functions | |
---|---|
CRN: 16660 Location: Ankeny-Bldg 20 Course/Section: DATA560 100 Date: 09/27/2018 - 09/27/2018 Room: 06 Instructor: Smith Pamela Time: 08:30AM - 03:30PM Days: Thursday Contact Hrs: 6 hours |
|
Description: | |
Using formulas in Excel will increase the accuracy of data and reports, and save you time. In this course you'll create formulas in cells, use the AutoSum button, learn about the order of operations, and relative and absolute cell references, and verify formulas. You will also learn how to work with functions such as IF statements, SUMIF, IF AND, and IF OR statements to perform conditional calculations; and VLOOKUP, MATCH, and INDEX for extracting information. Commonly used text functions and date and time functions will also be covered. Book is included. Prerequisite: Excel Intermediate course or equivalent experience. | |
Available Seats: 5 Fees: $99.00 | |
Back | Add |