Excel Pivot Tables & Charts

Pivot Tables are absolutely essential tools for data exploration in Excel, allowing you to instantly sort, filter, and analyze your data while keeping your source tables intact.

Consider this course a master class in Pivot Tables and Pivot Charts. We'll show you when, why, and how to use core tools and techniques, introduce advanced sorting, filtering, and calculation options, and guide you through interactive, hands-on demos and pro tips each step of the way. In the final section, we'll apply our skills to 10 real-world case studies, including burrito ratings, shark attack records, stock quotes, wine tasting scores, and more.

Whether you're looking for a quick primer or hoping to ramp up your analytics skill set, you've come to the right place.

COURSE CONTENTS:

• 7.0 hours on-demand video (11.0 CPE credits)

• 5 quizzes

• 15 homework assignments

• 2 skills assessments (1 benchmark, 1 final)

COURSE CURRICULUM:

WHO SHOULD TAKE THIS COURSE?

• Excel users who want to build a solid foundation for advanced analytics

• Analysts or BI professionals looking to extract insight and meaning from raw data, using expert-level PivotTable techniques

• Anyone seeking to improve productivity and work more efficiently with data

WHAT ARE THE COURSE REQUIREMENTS?

• Microsoft Excel 2010+ or Office 365 (ideally for PC/Windows)

• Mac users are welcome to join, but may have challenges following along

• No advance preparation is required

WHAT ARE THE COURSE OBJECTIVES?

• Identify Excel's basic Pivot Table requirements and functionality, including source data structure, the field list, contextual menus, and refreshing

• Identify Pivot Table formatting options and tools, including number formatting, custom headers, report layouts & styles, and conditional formatting

• Identify and interpret examples of sorting, filtering, and grouping in Pivot Tables, including wildcards, date grouping, slicers, timelines, and report filter pages

• Identify and interpret summarization and "Show Values As" options, including % of column, % of parent, difference from, running total, rank, and index

• Identify examples of calculated fields and items in Pivot Tables, including the use of count columns, and tools like solve order and list formulas

• Identify the relationship between Pivot Tables and Pivot Charts, as well as key Pivot Chart options and capabilities

CPE ACCREDITATION DETAILS:

• CPE Credits: 11.0

• Field of Study: Information Technology

• Delivery Method: QAS Self Study

Maven Analytics LLC 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 the 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.

For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.

*Last Updated: December 1, 2021