Welcome to DMACC Continuing Education
Excel Formulas & Functions Fast Track | |
---|---|
CRN: 26679 Location: Zoom Course/Section: DATA506 200 Date: 02/25/2021 - 02/25/2021 Room: Instructor: Staff * Time: 09:00AM - 12:00PM Days: Thursday Contact Hrs: 3 hours |
|
Description: | |
Do you have some experience using formulas and functions or need to brush up on your skills? Then this hands-on accelerated course is for you. Topics include: creating formulas in cells, using the AutoSum button; learning about the order of operations, and relative and absolute cell references; working with functions such as IF, SUMIF, IF AND, and IF OR statements to perform conditional calculations; using VLOOKUP, MATCH, and INDEX for extracting information and exploring commonly used text, date and time functions. Book is included. Prerequisite: Excel Intermediate course or equivalent experience. A day or two before the course start date you will receive and email with the Zoom link, course handout, and exercise files that will be used during the class. | |
Available Seats: 12 Fees: $75.00 | |
Back | Add |