How do you create a PivotTable in Excel?

Asked by Last Modified  

1 Answer

Follow 1
Answer

Please enter your answer

IT Professional Trainer with 5 Years of Experience in IT Industry

Select the cells you want to create a PivotTable from. ... Select Insert > PivotTable. This creates a PivotTable based on an existing table or range. ... Choose where you want the PivotTable report to be placed. ... Select OK.
Comments

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Before analysis start Important
Hi All, Often we do analysis in day to day life, before we start we should follow few principles of data cleaning activities in any application such as removing unwanted space, converting data into correct...

Automated Data Consolidation from Different Worksheets
https://vz-3ad30922-ba4.b-cdn.net/c301f62f-a465-4952-87de-c32d3b1bd80f/play_480p.mp4

Space Base

0 0
0

Mail Merge In Word
Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more user information stored in a list, database, or spreadsheet. Mail Merge is most often used...

Excel Macros Training
The Next Level Technologies Excel Learning...Read & Share....Happy Learnings Record Macro (Automating day to day activity reports) -> Choose Record Macro in the Code group of the Developer...
N

Next Level Technologies

0 0
0

Recommended Articles

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you