Explore
For Enterprise
Join for Free
Log In

Parcourir
Rechercher
For Enterprise
Connexion
Inscrivez-vous gratuitement

Sort a Pivot Table

Loading...

Problem Solving with Excel

4.7 (3,426 notes) | 81K étudiants inscrits

Cours 2 de 5 dans Data Analysis and Presentation Skills: the PwC Approach Spécialisation

This course explores Excel as a tool for solving business problems. In this course you will learn the basic functions of excel through guided demonstration. Each week you will build on your excel skills and be provided an opportunity to practice what you’ve learned. Finally, you will have a chance to put your knowledge to work in a final project. Please note, the content in this course was developed using a Windows version of Excel 2013. This course was created by PricewaterhouseCoopers LLP with an address at 300 Madison Avenue, New York, New York, 10017.

Visualiser le programme de cours

Compétences que vous apprendrez

Data Analysis, Microsoft Excel, Pivot Table, Data Cleansing

Avis

4.7 (3,426 notes)

5 stars
2,633 ratings
4 stars
641 ratings
3 stars
119 ratings
2 stars
21 ratings
1 star
12 ratings

TW

Jan 03, 2017

It's a great course with clear instructions and insightful practices. I learnt useful functionalities and tools that could be used in my future career as an accounting professional.

BY

Jan 17, 2019

The functions introduced in this course are very useful for me to utilize the excel in my academic studies and I also think this will help me to develop greatly in my future career.

À partir de la leçon

Logical Functions & Pivot Tables

In this module, you will learn about logical functions and pivot tables. We will show you how to create and use pivot tables to solve business problems. We will give you an opportunity to practice creating and using a pivot table to solve a business problem. Finally, we will share some insight on PwC’s perspectives on the impact of Excel on your career and work. Note: We recommend viewing videos in full-screen mode by clicking the double arrow in the lower right hand corner of your screen.

Pivot Tables4:34

Navigate a Pivot Table7:49

Sort a Pivot Table3:43

Advanced Filtering5:53

Calculated Fields3:26

Enseigné par

Alex Mannella
Alumni / Former Principal

Transcription

[MUSIC] In this next section we're going to go over how to sort a pivot table. So we've looked at this a little and some of our past examples but there are even more sort functions that we haven't gotten into yet. In problem 4a, we're going to sort the distributors in alphabetical order by first name. So it looks like here we have the distributors from Panama and their revenue. So I'll click the dialog box next to distributor to show our sort functions. And currently since Sort Z to A is highlighted, it looks like that is what we're using. But we want this in alphabetical order, so I'm going to change this to Sort A to Z. And now we can see that we have our table in alphabetical order by first name. Now problem 4b is a little more complicated because we have the quantity of products broken down by sales channel. Here, the question is asking us to sort both the products and the sales channel in descending order by sum of quantity. Just as in our past example, we can click the dialogue box next to Products to see our sort options. Here, you can see that there's already a Select Field option. Though this menu is helpful it's always better to look at the more sort option, so you can see all of your options and what is the easiest way to go about sorting your data. So here you can see the options, ascending and descending, and we would like to sort descending order. On the top of this menu, it says select field and has a drop down menu. The drop down menu shows both sales channel and product. So this is what we are going to sort by. In our example, we would like to sort products and sales channel. So lets start with product. I'll click on Product to tell Excel that we would like to sort by product. Next, I'll go to More Sort Options, and we would like to sort it in descending order, so I'm going to click for Descending. And what would we like to sort by? So you can see in the summary below right now we are sorting product in descending order, but we would like to sort product by Sum of quantity. So this drop down menu allows us to sort product by sum of quantity, and you can see that that is updated in our summary. So now I'm going to click OK to update those changes. This pivot table now shows products sorted in descending order by sum of quantity. The next step will be to sort sales channel in descending order by sum of quantity. To do this let's return to our sort menu. I'm going to click the button next to products again, and here when we select field we would like to select Sales Channel. The next step is to go to the more sort options menu. Question 4b asks for a descending order by sum of quantity. So I'll click Descending and then change this to Sum of Quantity. And we can see in our summary, we are sorting sales channel by Sum of Quantity in descending order. So I'm going to click OK. Our resulting pivot table has online retail and direct, our sales channel, in descending order by sum of quantity, as well as the products within those sales channels in descending order. In problem 4c, it's your turn to try sorting. Sort countries and products in descending order by sum of revenue. If you're having any trouble, try guessing and checking. Good luck. [MUSIC]

Explorer notre catalogue

Rejoignez-nous gratuitement et obtenez des recommendations, des mises à jour et des offres personnalisées.

Coursera propose un accès universel à la meilleure formation au monde, en partenariat avec des universités et des organisations du plus haut niveau, pour proposer des cours en ligne.

© 2019 Coursera Inc. Tous droits réservés.

Disponible sur Google Play

Coursera
À propos
Direction
Carrières
Catalogue
Certificats
Certificats MasterTrack™
Diplômes
For Enterprise
For Government
Pour le campus

Communauté
Learners
Partners
Developers
Beta Testers
Translators

Se connecter
Blog
Facebook
LinkedIn
Twitter
Instagram
YouTube
Blog Tech

Plus
Conditions
Confidentialité
Aide
Accessibilité
Presse
Contact
Répertoire
Filiales