Healthcare

Financial

Management

Association


Excel Series 1 - Power Query Basics (Advanced)

  • 23 Jan 2019
  • 12:00 PM - 1:30 PM
  • Webinar
WEBINAR
SAVE THE DATE
Excel Series 1
Power Query Basics (Advanced)


Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel! Power Query is an incredibly powerful tool that, at a high level, helps us retrieve data from a variety of sources and prepare it for use. In this session, we’ll use Power Query to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports. If you frequently export/import data from one system to another, you will want to understand how to use Power Query to streamline your work. Learning objectives: (1) recall the steps to create a new query; (2) identify commands that transform data; and (3) state the process to return the transformed data to Excel.
Powered by Wild Apricot Membership Software