Presenting the right information to the right people in a visually engaging way that enables actionable decision making is a major goal for everyone working with data. In this three hour, hands-on session we will work with a wide variety of techniques that will help you clearly and concisely prepare and present data for your audience. We will explore dashboard design principles, data preparation, and presentation using tables and charts. Techniques using VLOOKUP, SUMIFS and COUNTIFS, sparklines, data bars and conditional formatting are covered. If you need to make sense out of a mountain of data, these techniques will help.
Prerequisites: Intermediate level experience with Excel 2013. No previous experience with PivotTables or PivotCharts is required.
Instructor: Staff, Training Services
Hours: 3
Contact FAST3 (training@illinois.edu) or Phil Nyman (217-244-9041) to discuss course availability or scheduling.