SCORE Live Webinar - Excel Power Query - Power Tool for Transforming Data
Often the biggest hurdle in analyzing information in Excel is getting the data organized
the way you need it - columns need to be split, tables combined, or certain entries omitted. Doing it by hand is typically impossible for all but the smallest data sets.
Power Query is an oft-overlooked feature of Excel that can automate many such conversions, for example by separating city state and ZIP code in an address, or transposing rows and columns.
This live, one-hour program will introduce you to Power Query’s capabilities, and show you how to use it in several common situations.
Discussion and examples will cover:
* What Power Query is and where to find it in Excel;
* The kinds of data sources Power Query can work with;
* How to plan and build a query;
* How to connect a data source to Power Query;
* Using Power Query to parse data such as first and last name and elements of an address;
* Transposing rows and columns;
* Combining tables; and
* Different ways Power Query can output its results.
There will be plenty of time for questions, so please come prepared.
Presenter: Gerald Rosenthal, ComputerImages.com
Date and Time
Tuesday Jul 16, 2024
10:00 AM - 11:00 AM EDT