Steve Kraynak, Microsoft MVP: No financial relationships to disclose
Session Description: You can do almost anything with Microsoft Excel, especially when it comes to data. In this half-day session, Steve Kraynak (SumProduct.com), who spent 12 years as an Excel product manager at Microsoft, will show you how to gather, organize and present your data with the wide array of features available in Excel. You'll learn helpful tips that make Excel easier to use. Learn best practices for getting your data into Excel and then analyzing and summarizing it with PivotTables. Understand how to get the most out of the powerful dynamic array functions. Highlight the minimum, maximum or outlier values in your charts. Each attendee will receive their own paperback copy of Guerrilla Data Analysis Using Microsoft Excel, by Excel MVPs Oz Du Soleil and Bill Jelen, as well as the set of example files used in the session so you can follow along or practice afterward.
Format: Attendees are welcome to bring their laptop to follow along with some of the examples in the presentation, but it's not required. Feel free to learn and ask questions along the way to get the most out of the session.
Learning Objectives:
Learn how to easily summarize your data with PivotTables.
Import and combine data from raw data files into Excel in easy, flexible and repeatable ways (Power Query).
Learn straightforward techniques for highlighting minimum, maximum, or outlier values in your charts.
How to make sure that Excel doesn't change your data unexpectedly.
Understand the dynamic array behavior and related functions in the modern version of Excel.