Self-paced course
Self-paced course
Excel Pro Tips: Pivot Tables
Excel Pro Tips: Pivot Tables
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
3 course hours
1 quizzes
Who should take this course
Excel users who want to explore, analyze and manage data more effectively
Analysts or BI professionals looking to build custom, PivotTable-based reports, dashboards, or analytics tools
Anyone seeking to explore some of Excel's most useful PivotTable tools & techniques
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.
Featured review
"Such a great course, with a broad range of tips and tricks to fill the gaps in your excel knowledge. So many great lessons that will save me time and effort and help me do things I didn't even know were possible. Another brilliant course from Chris!"
Ian A.
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
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
Such a great course, with a broad range of tips and tricks to fill the gaps in your excel knowledge. So many great lessons that will save me time and effort and help me do things I didn't even know were possible. Another brilliant course from Chris!
Ian A.
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
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
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
