How to Create a Pivot Table in Microsoft Excel

How to Create a Pivot Table in Microsoft Excel - Indigo Software

Pivot tables in Excel are a powerful tool for analyzing and summarizing large amounts of data. They allow you to quickly and easily see patterns and trends in your data, making it easier to make informed decisions. In this article, we’ll go over how to create a pivot table in Excel step by step.

Step 1: Prepare your data

The first step in creating a pivot table is to prepare your data. Make sure your data is organized into columns and that the columns have appropriate headings. It’s also a good idea to remove any blank rows or columns from your data.

 Prepare your Pivot table data

Step 2: Select your data

Select the data that you want to include in your pivot table. This can be a single range of cells or multiple ranges of cells.

create your Pivot table data

Step 3: Start the pivot table wizard

To start the pivot table wizard, go to the “Insert” tab on the ribbon and select “Pivot Table”. You will be prompted to select the data that you want to include in your pivot table.

Start the pivot table wizard

Step 4: Choose the location for your pivot table

Next, choose the location for your pivot table. You can either create a new worksheet for your pivot table or place it in an existing worksheet.

Choose the location for your pivot table

step 5: Select the fields for your pivot table

In the “Pivot Table Fields” pane, select the fields that you want to include in your pivot table. You can add fields to the “Rows”, “Columns”, and “Values” areas. The fields that you add to the “Values” area will become the values that are summarized in your pivot table.

Select the fields for your pivot table

Step 6: Choose the summary calculation

For each field in the “Values” area, you can choose the summary calculation that you want to use. Common summary calculations include “Sum”, “Average”, “Count”, and “Max”.

 Choose the summary calculation

Step 7: Apply any filters or sorting

You can also apply filters or sorting to your pivot table to further refine the data that is displayed. To do this, go to the “Analyze” tab on the ribbon and select “Sort & Filter”.

Apply any filters or sorting

Step 8: Format your pivot table

Finally, you can format your pivot table to make it more readable and visually appealing. You can change the font, font size, and font color, as well as add borders and shading. To format your pivot table, go to the “Design” tab on the ribbon.

Format your pivot table

In conclusion, creating a pivot table in Excel is a quick and easy way to analyze and summarize large amounts of data. With these step by step instructions, you’ll be able to create a pivot table in no time. In windows 11 Pro you can made pivot table as this have a good updates in office software programs.

I could have bought Office 2021 from another company cheaper but didn't so glad I paid more had issues with download and the support from Joe and Jenna was awesome. You get what u pay for so spend the extra money and go... with Indigo. I've used multiple times and they have never let me down.read more
Herbert CumbaaHerbert Cumbaa
15:55 26 Jul 22
Outstanding! Fair Price for Product! (Office Professional Plus 2016) Received Install Codes Immediately after Purchase! Processed Perfectly with Microsoft! Wanted Legit Software for Our Church! Will Use Again!... A+A+A+A+A+A+A+A+A+A+A+read more
Allan DrakeAllan Drake
20:51 16 Jul 22
Asked for two activations for office 2019 professional I bought two times. Microsoft says since I updated to win 11 the code provided is not a good code on either computer. Indigo sent me both replacement codes. I... also sent in a form on your website with my phone number.read more
Bob SBob S
14:13 20 Jun 22
I purchased MS Office 2019 for my new computer in 2021. The Install went well and all was good. A little over a year later Outlook stopped being able to sign into the Comcast email. Talking to Comcast tech after several... different trials we found by deleting the Comcast account and reinstalling it fixed the problem. About a month later the problem happen again. The delete and recreate the account trick did not work. Comcast indicated it was a MS Outlook problem since my iPhone that uses the same interface and the webmail portal all worked with the account. I then contacted Indigo about the issue. I got an email the next day asking for the order #. A few days later a email with YouTube video links on how to setup the Office software. I replied with a second more in depth description of what had been tried to resolve the issue. I have not heard from them in a week now. I can't imagine someone dealing with this lack of responce if their business depended upon it. Fortunetly for me, it is just for home use. The problem may not be MS Outlook, but you have to be able to get the support / knowledgebase to work thru to the solution.Edit: As soon as I checked my email, Indego had responded with a proceedure to reinstall Office and make sure no other office products were installed. It worked and Office is resyncing with the email account now.read more
Sidney RuetzSidney Ruetz
21:03 19 May 22
Best software purchasing experience bar none. Excellent prices and installation was painless and flawless. I needed both Windows 10 and Microsoft office. I saved a lot of money. You can't go wrong here!!!
Dito DalawaDito Dalawa
15:15 24 Dec 21
Indigo Software
4.9
431 reviews
powered by Google
js_loader