Microsoft Excel Advanced PivotTables
In this Advanced PivotTables Excel course, we teach you how to make the most of this powerful data analysis function. Start with a PivotTable refresher before moving onto some of the advanced features of this tool. Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting are just a few of the subjects included in this PivotTable deep-dive. This course is perfect for intermediate users of Excel who are already comfortable using the PivotTable function.
5.0 (1 Reviews)
176 student views
Course Goal
- How to format a PivotTable, including adjusting styles
- How to create a Pivot Chart and add sparklines and slicers
- How to create an awesome looking interactive dashboard
- Understand how to use GETPIVOTDATA
- How to use 3D Maps from a PivotTable
Who This Training Is For
- All SAP professionals
Exam/Certificate
- Certificate of Completion (more certification info)
- Upon successful completion of this course, receive your Microsoft Excel Advanced PivotTables certificate
This Course is In the Following Learning Paths:
Take this learning path to increase your skills from a spreadsheet novice to an Excel Master. After you complete this pa...
Instructor
4.7 Average Rating
133 Reviews
955 Students
24 Courses
Teaching Business Software
The IT in Simon Sez IT stands for Information Technology. In a nutshell: We make business and technical software simple to learn. We teach people to use the most popular business software including Microsoft Office, Microsoft Project, Photoshop, Web Design, and QuickBooks. Self-paced, affordable software training is what Simon Sez IT is all about. We only hire the best authors to teach and our style is to take the time to explain things in the detail they deserve. That means our courses are perfect if you're new to a certain technology or just technology shy in general. Chris "Simon" Calder was working as a Project Manager in IT for one of Los Angeles's most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course which he sold on DVD via eBay. Fast forward to now and Simon Sez IT has taught hundreds of thousands of students through its online course platform and popular YouTube channel.
Student Feedback
5.0
Average Rating