With Power Pivot, your PivotTable reports can become even more powerful than you might have thought possible. This powerful tool can connect directly to many external data sources to link data directly into your reports. Alternatively, you can use it in conjunction with Power Query for superior data import and transformation capabilities. Further, DAX functions allow you to create sophisticated calculations in your PivotTables, adding even more analytical capabilities. And the relational database functionality of Power Pivot provides all the tools necessary for building an intermediary database from multiple data sources. Put Power Pivot to use immediately by participating in this session, which surely will help you improve your analytical and reporting processes.
DESIGNED FOR
Accountants and business professionals who are seeking to improve financial analysis processes by taking advantage of the Power Pivot feature found in Windows-based versions of Excel
BENEFITS
- Differentiate between ordinary PivotTables and those created with Power Pivot
- Identify the advantages of working with Power Pivot
- Explain the procedure for building a PivotTable using Power Pivot
- Define data models, data analysis expressions, and key performance indicators
ADDITIONAL NOTES
Please contact the ACPEN help desk 1-877-602-9877 or help@acpen.com if you wish to cancel your attendance for a previously purchased webcast and are requesting a refund or transfer.