Welcome to DMACC Continuing Education
| Getting the Most from Excel Formulas and Functions | |
|---|---|
CRN: 24877 Location: Ankeny-Bldg 20 Course/Section: DATA560 200 Date: 02/27/2020 - 02/27/2020 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: 7 Fees: $135.00 | |
| Back | Add |
Previous Item | Next Item
Previous Item | Next Item
Previous Item | Next Item
