Improve data processing and reporting with Excel’s pivot tables!
Being able to view data in meaningful ways can be very important when it comes to understanding your data. Pivot tables offer unique ways to add sortable and interactive elements to any project’s spreadsheets for how data is shown. Not only does it make managing your data quick and easy, but allows you to leverage the data for insights without needing to create separate reports.
Using mock-up sales data, you’ll learn to extract and aggregate large sets of data into pivot tables that can dynamically display data how you want. You’ll also gain advanced techniques for sorting, filtering, grouping, and displaying data in ways that make your information easy to work with for multiple different kinds of goals.
Whether you’re just upgrading your Excel skills or want to find new tools for your business, pivot tables will give you a new method to analyze your data effectively.
This course assumes basic familiarity with Excel.
You will learn how to:
- Create pivot tables and pivot charts
- Sort and group data based on criteria
- Format pivot tables with different techniques
- Manipulate how pivot table data displays
- Refresh pivot tables with updated data
- Use slicers to create interactive reports
Courses by the World’s Best
Our course instructors aren’t just fun to learn from – they’re qualified coders who have been formally certified for their excellent programming and teaching skills. That way, you can be confident that you’re developing strong, modern skills that will set you up for success as a developer.
WHO CAN TAKE THESE COURSES?
We start with the absolute basics and go through everything step-by-step – so even if you have zero experience in programming, you’ll be able to easily follow along.
More experienced? Whether you’re wanting to brush up, expand your skills, or learn a new technology, our courses are structured in a way that makes it easy to skip ahead to the lessons that are relevant and interesting to you.
REINFORCE YOUR LEARNING
Zenva’s courses feature quick challenges that will speed up your learning.
Access live coding lessons where you can practice coding right in your browser, and instantly see the results of any changes you make to the code:
Reinforce key concepts with in-course quizzes, which appear throughout courses:
COURSES BY THE WORLD’S BEST
Our course instructors aren’t just fun to learn from – they’re also serious gamers, qualified coders, and have been formally certified by Unity Technologies and CompTIA for their excellent programming and teaching skills. That way, you can be confident that you’re developing strong, modern skills that will set you up for success as a game developer.
YOUR COURSES, YOUR WAY
Learn with project-based courses that are designed to be flexible – access them 24/7, fit them around your schedule, and choose the learning materials that suit you best.
With an online platform optimized for all modern devices, you can even learn on the go!
✅ Watch video lessons
✅ Download course printouts
✅ Explore interactive lessons
✅ Practice with source code
✅ Build real projects
✅ Earn completion certificates
ACHIEVE REAL RESULTS
Our community of 1,000,000+ learners and developers have used the skills learned with us to publish their own games and websites, land their dream jobs, and even start their own businesses – and you have the potential to do the same!
Check out what our learners think below:
I love the lectures, concise course objectives, and how they not only teach you enough to get started, but prepare you for the advanced stuff later down the road.
With Zenva, I started learning a more accurate way to approach problems and develop solutions. It’s full of interesting topics that I love to learn in conjunction with my work.
I chose Zenva because of the large selection of topics and the fact that I can choose what courses I want to take whenever I want to take them. That level of freedom is unique to Zenva.
The Unity courses at Zenva helped me achieve a level of comfort with game development that I didn’t think was possible. They give you the confidence to expand your skills, and were so easy to understand.