Welcome to DMACC Continuing Education
Excel Formulas & Functions Fast Track | |
---|---|
CRN: 15720 Location: Zoom Course/Section: DATA506 100 Date: 10/22/2020 - 10/22/2020 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 a Calendar Invitation will be emailed to you with the Zoom link, course handout, and exercise files that will be used during the class. | |
Available Seats: 12 Fees: $75.00 | |
Back | Add |