|
|
Having a sound knowledge of Power Query and Power Pivot is a must if you work with, analyze and generate reports from large datasets. Power Pivot helps you overcome Excel�s limitations when it comes to working with massive datasets. Power Query can save you a lot of time when working with imported data. Often, when data is imported from external sources, it needs work on it, before it can be used. Join this webinar by Tom Fragale to learn to utilize the features of PowerPivot and Query to summarize large amounts of data and streamline the process of presenting the results.. This event is aimed at users of Excel (2010, 2013 and 2016 for Windows) who wish to learn
about Power Pivot and Power Query. Attendees should have at least intermediate knowledge of Excel and be familiar with formulas and creating Pivot Tables.
Key Learning Objectives- How to activate/install PowerPivot and PowerQuery-free tools from Microsoft
- Learn about Data Models
- Creating relationships between different datasets in PowerPivot
- Importing data into excel from an array of external sources
- Learn about DAX formulas
- Cleaning, transforming and merging data with PowerQuery (goodbye, Access)
- Practical applications for different data models you can create with these tools
|
| |
|
|
|
 |
Tom Fragale
Computer Trainer and Consultant
Mr. Fragale is a computer professional with over 30 years experience. He has trained over 30,000 business people with online webinars, public seminars and on-site training. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Crystal Reports, SQL Server, Visio, QuickBooks and SharePoint. |
| View More |
| |
|
