Welcome to DMACC Continuing Education
Excel Dashboards-Comprehensive | |
---|---|
CRN: 14859 Location: Ankeny-Bldg 20 Course/Section: DATA577 100 Date: 09/28/2021 - 09/28/2021 Room: Instructor: Staff * Time: 08:30AM - 03:30PM Days: Tuesday 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. | |
Available Seats: 12 Fees: $135.00 | |
Back | Add |