Click Here For More Information
Microsoft® Excel: Data Tables & PivotTables Featuring PowerPivot
Virtual LiveCourse Description: This hands-on course is ideal for professionals with a working knowledge of Excel who are ready to take their data analysis skills to the next level. In the […]
Microsoft® Excel: Data Tables & PivotTables Featuring PowerPivot
Virtual LiveCourse Description: This hands-on course is ideal for professionals with a working knowledge of Excel who are ready to take their data analysis skills to the next level. In the […]
Course Description:
This hands-on course is ideal for professionals with a working knowledge of Excel who are ready to take their data analysis skills to the next level.
In the first half, participants will reinforce foundational skills in working with Excel data lists and tables, including sorting, filtering, and subtotaling. Building on these essentials, the course introduces PivotTables—starting with basic, one-dimensional designs and progressing to multi-dimensional PivotTables enhanced by filters, slicers, and Pivot Charts.
The second half focuses on PowerPivot, a powerful Excel Add-In that extends the capabilities of traditional PivotTables. Participants will learn to perform advanced calculations, group and manage large data sets efficiently, and connect to external data sources to create robust, scalable reports.
Course Highlights:
-
Identify and structure Excel data lists
-
Perform basic and complex sorting techniques
-
Apply filters and subtotal functions to analyze data
-
Convert standard data lists into Excel Tables
-
Create and customize one-dimensional and multi-dimensional PivotTables
-
Reorganize PivotTable data for dynamic views
-
Use filters and slicers to enhance interactivity
-
Develop visually engaging Pivot Charts
-
Utilize PowerPivot for:
-
Advanced calculations
-
Grouping and summarizing large data sets
-
Connecting to external data sources
-
Designing and distributing professional-level reports
-
Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
Cancellation Policy: 5 working days for full refund. Cancellations after that time are charged full tuition for the course.
For more information regarding refund, concerns, and/or program cancellation policies please contact our offices at 919-878-7100 ext. 22