Welcome to DMACC Continuing Education
Getting the Most from Excel Dashboards | |
---|---|
CRN: 24984 Location: Zoom Course/Section: DATA577 200 Date: 03/10/2021 - 03/10/2021 Room: Instructor: Staff * 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 you will receive a textbook via UPS and an email with the Zoom link and exercise files that will be used during class. | |
Available Seats: 8 Fees: $135.00 | |
Back | Add |