This one-hour course will provide users with hands-on practice using PivotTables and Excel. Users will learn and apply skills to create, structure, and analyze data using PivotTables. The benefits and limitations of PivotTables will be discussed. Users will be introduced to Power Pivot and Online Analytics Processing within it. This course is one in a ten-part certification series, Core Data Analytics: Excel and Power BI Skills for Accounting and Finance Professionals, by Surgent IQ.