Expires in:
Expires in:
Expires in:
Self-paced course
Self-paced course
Excel Pro Tips: Pivot Tables
Excel Pro Tips: Pivot Tables
Rating 4.3
318 reviews
318 reviews
318 reviews
Course Description
The Excel PRO TIPS series is designed to transform everyday Excel jockeys into certified power users, by featuring the same tools and techniques used by top pros and MVPs.
In this course we’ll focus on one of Excel’s most powerful and flexible analytics tools: PivotTables. We’ll start with some common topics like slicers, table layouts and field list options, then dive into more unique use cases like grouping values, enabling multiple filters, reviving source data from cache, defining custom sort lists, and more.
It’s time to start working smarter, not harder. If you’re ready to slice, dice and filter your data like a PivotTable pro, this is the course for you.
Course Description
The Excel PRO TIPS series is designed to transform everyday Excel jockeys into certified power users, by featuring the same tools and techniques used by top pros and MVPs.
In this course we’ll focus on one of Excel’s most powerful and flexible analytics tools: PivotTables. We’ll start with some common topics like slicers, table layouts and field list options, then dive into more unique use cases like grouping values, enabling multiple filters, reviving source data from cache, defining custom sort lists, and more.
It’s time to start working smarter, not harder. If you’re ready to slice, dice and filter your data like a PivotTable pro, this is the course for you.
Course Content
4.5 video hours
Skills you'll learn in this course
Build nested, drillable PivotTables in seconds
Group dates, numbers & text to reveal hidden patterns
Design slicer‑driven dashboards without formulas
Refresh, link & style your pivots for exec reports
Meet your instructors
Chris Dutton
Founder & CPO
Chris is an EdTech entrepreneur and best-selling Data Analytics instructor. As Founder and Chief Product Officer at Maven Analytics, his work has been featured by USA Today, Business Insider, Entrepreneur and the New York Times, reaching more than 1,000,000 students around the world.
Student reviews
This set of Pro Tips was a great recap of working with Pivot Tables. There were some useful examples in there. For me a tip about working with pivot tables without source data was especially useful and is something I would like to try out.
AndrewHubbard
This course is short but very effective in explaining Tips and Tricks using pivot tables which I didn't know before. Highly Recommended!
Md. Zakir Hussain Khan
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
Excel Pro Tips: Pivot Tables
Excel Pro Tips: Pivot Tables
CPE Accreditation
CPE Credits:
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: May 25, 2023
Course Description
The Excel PRO TIPS series is designed to transform everyday Excel jockeys into certified power users, by featuring the same tools and techniques used by top pros and MVPs.
In this course we’ll focus on one of Excel’s most powerful and flexible analytics tools: PivotTables. We’ll start with some common topics like slicers, table layouts and field list options, then dive into more unique use cases like grouping values, enabling multiple filters, reviving source data from cache, defining custom sort lists, and more.
It’s time to start working smarter, not harder. If you’re ready to slice, dice and filter your data like a PivotTable pro, this is the course for you.
Course Description
The Excel PRO TIPS series is designed to transform everyday Excel jockeys into certified power users, by featuring the same tools and techniques used by top pros and MVPs.
In this course we’ll focus on one of Excel’s most powerful and flexible analytics tools: PivotTables. We’ll start with some common topics like slicers, table layouts and field list options, then dive into more unique use cases like grouping values, enabling multiple filters, reviving source data from cache, defining custom sort lists, and more.
It’s time to start working smarter, not harder. If you’re ready to slice, dice and filter your data like a PivotTable pro, this is the course for you.
Curriculum
1
Getting Started
1
Getting Started
1
Getting Started
2
PivotTable Tips
6 MIN
6 MIN
6 MIN
6 MIN
2
PivotTable Tips
6 MIN
6 MIN
6 MIN
6 MIN
2
PivotTable Tips
6 MIN
6 MIN
6 MIN
6 MIN
3
Course Feedback & Next Steps
3
Course Feedback & Next Steps
3
Course Feedback & Next Steps
Meet your instructors
Chris Dutton
Founder & CPO
Chris is an EdTech entrepreneur and best-selling Data Analytics instructor. As Founder and Chief Product Officer at Maven Analytics, his work has been featured by USA Today, Business Insider, Entrepreneur and the New York Times, reaching more than 1,000,000 students around the world.
Student reviews
This set of Pro Tips was a great recap of working with Pivot Tables. There were some useful examples in there. For me a tip about working with pivot tables without source data was especially useful and is something I would like to try out.
AndrewHubbard
This course is short but very effective in explaining Tips and Tricks using pivot tables which I didn't know before. Highly Recommended!
Md. Zakir Hussain Khan
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
Excel Pro Tips: Pivot Tables
Excel Pro Tips: Pivot Tables
CPE Accreditation
CPE Credits:
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: May 25, 2023
More courses you may like
