Welcome to DMACC Continuing Education
Getting the Most from Excel Formulas and Functions | |
---|---|
CRN: 31662 Location: Ankeny-Bldg 20 Course/Section: DATA560 300 Date: 06/06/2019 - 06/06/2019 Room: Instructor: Staff * 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: 12 Fees: $125.00 | |
Back | Add |