You Know Excel. But What Do You Know About Power Query? (hands-on) (ES12)
Clean-up that annoying data and automate and consolidate your reports in a flash! In this session, you will learn how to quickly parse out information that was brought into your excel sheet. Learn how to: convert an unorganized table into an organized table (normalize table) in order to create many pivot tables; combine multiple sheets of data containing empty cells into one complete table; link tables in order to generate pivot tables and using slicers to filter the information; create inner joins where you can find information that exists into two separate tables; and, create magic with Flash Fill. Attendees should be comfortable with Excel already; laptops are required. Preferred installations: Microsoft Excel 2013 and Excel 2016.