ST Alpha - "I've done a ton of Excel work and never had to use a Pivot Table. Why do you use one?" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 185

In response to "Excel Help: let's say you have a Pivot Table. and within said Pviot you want to sort things in order from Highest to lowest" by Beaker

I've done a ton of Excel work and never had to use a Pivot Table. Why do you use one?

Posted by muzungu psilotum (aka psilotum) Sep 13 '11, 09:00

serious question.

Responses:

It allows you to slice and dice a large spreadsheet to get all kinds of information big and small - con_carne Sep 13, 09:08
It allows you to analyze a huge data table by aggregating various columns and performing calculations with the intersecting data -- nm - Beryllium Sep 13, 09:04 4
- Like, let's say you have a raw data table of all your company sales/invoices over the past 5 years ... you could use a pivot table to divide it by - Beryllium Sep 13, 09:06 3
  - Hmmm. I used to work with data sets too big for Excel. Not sure if that would have helped in this case, because you could not import the data. - muzungu psilotum Sep 13, 09:09 2
    - excel used to have a 65,000 row limit, that doesn't apply any more -- nm - Beryllium Sep 13, 09:10 1
      - This was exactly my problem. - muzungu psilotum Sep 13, 09:11
OMG, it is the single greatest tool within excel IMO. nm -- nm - groiny Sep 13, 09:01 3
- and counterintuitively, GETPIVOTDATA() is the worst function in all of Excel. - TFox Sep 13, 09:05 1
  - agreed -- nm - decline Sep 13, 09:06
- agreed. - Mel Profit Sep 13, 09:04

Post a message top

Replies are disabled on threads older than 7 days.