Welcome to DMACC Continuing Education
CreateDashboardsUsingFormulas | |
---|---|
CRN: 26761 Location: Zoom Course/Section: DATA507 200 Date: 04/05/2022 - 04/05/2022 Room: Instructor: Staff * Time: 09:00AM - 12:00PM Days: Tuesday Contact Hrs: 3 hours |
|
Description: | |
Learn the powerful aspects of Excel to create dashboards to display key business performance indicators that are relevant to a business process. A dashboard is a visual interface that shows data at a glance, and often includes conclusions that alleviate the need for the viewer to analyze the data. You will create advanced formulas using range names and specialized functions, automate workbook functionality by applying Data Validation and working with Forms and Controls, and apply conditional logic using Lookup functions and combining functions. Book is included. Prerequisite: Excel Intermediate course or equivalent experience. A day or two before the course start date, you will receive an email with the Zoom link, handout and exercise files that will be used during class. | |
Available Seats: 12 Fees: $69.00 | |
Back | Add |