Often in Excel, we need to get our data from Point A to Point B. For example, getting our raw data into a summary report. When the labels are different, getting the values from Point A to Point B can be cumbersome. However … we can save a lot of time by using a map! Mapping tables often provide the most efficient route.
In this webinar, I’ll show you three ways to implement a mapping table, including SUMIFS, Power Query, and Power Pivot. No matter your Excel skill level, mapping tables will help you discover the treasure of efficiency.
Attendees receive a free e-book to keep for reference.
On-Demand Webinar (Free, No CPE)
The free on-demand webinar is available now through October 30, 2020.
- The on-demand version starts immediately and will start at the beginning.
- If you don't have time to watch it now, click the On-Demand Version button above and enter your name and email.
- The system will email you a link that you can use to launch the webinar anytime between now and October 30, 2020.
- The webinar is about one hour.
- The webinar provides the ability to submit questions, but not the ability to pause or rewind.
- After you watch the webinar, the system will automatically send a link to the Replay, which can be paused.
- Webinar registration includes a complimentary subscription to the Excel University blog.
- On-demand version is not offered for CPE credit.
Pass it on!
Know someone who would enjoy this webinar? Please send them a link to this page!
Additional Information / Webinar Agenda
A mapping table helps you get from Point A to Point B. For example, you download data from an accounting system which includes account names and balances. You need to get these values into a report. When the labels between the data and report are different, a mapping table provides the translation needed so Excel can fully automate the process.
Specifically, we'll talk about:
- Using SUMIFS to create a formula-based mapping table and report
- Using Power Query to import data from a CSV file
- Using Power Pivot to relate the tables to create a PivotTable report
- State the arguments of the SUMIFS function
- Recall the steps to import a CSV file using Power Query
- Identify the process to relate tables in Power Pivot
Recommended CPE Credit: 1.0
Subject Area: Computer Software & Applications
Course Level: Basic
Instructional Method: Group Internet Based
Advanced Preparation: None
Have you decided to skip the webinar?
If so, no worries ... but while you are here, please subscribe to our blog to learn Excel free via email. You'll be notified of new Excel articles, blog posts, and free Excel tips.