Welcome to DMACC Continuing Education
Getting the Most from Excel Dashboards | |
---|---|
CRN: 32608 Location: Zoom Course/Section: DATA577 300 Date: 06/17/2020 - 06/17/2020 Room: Instructor: Smith Pamela Time: 08:30AM - 03:30PM Days: Wednesday Contact Hrs: 6 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 being presented. In this course you will create advanced formulas using range names and specialized functions, automate workbook functionality by applying Data Validation and working with Forms and Controls, apply conditional logic using Lookup functions and combining functions, visualize data with basic charts, use advanced charting techniques and create Sparkline's, and analyze data with PivotTables, Slicers and PivotCharts. 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: 6 Fees: $135.00 | |
Back | Add |