Power Query

Apply key Excel functions to prepare data for analysis using pivot tables
Create and customize pivot tables to reconcile and analyze accounts efficiently
Utilize Power Query to clean up and prepare data for reporting
Utilize pivot tables functions and calculations to generate a set of management and business analysis reports
Run macros to speed up work and utilize other advanced techniques in data analysis and reporting
Report and analyze big data using PowerPivots

Quick Links