Hey monkeys - just joined consulting from Finance and noticed that everyone is using pivot table.
As far as I remember, I have never seen anyone using pivot in my previous role..
What are your thoughts - are Pivot table good practices?
| +59 | Girlfriend found my UBS badge. I told her I was cheating. | 5 | 1d |
| +32 | Quit at 25? | 6 | 11h |
| +24 | What portable monitors are you guys actually using and would recommend? | 5 | 1h |
| +12 | Anyone still having issues with Microsoft Outlook? | 2 | 1d |
| +7 | Jensen Huang resignation | 11 | 19h |
| +6 | Honeymoon Length | 6 | 3d |
| +5 | I want to work for Google | 1 | 1d |
| +3 | Jam Band Debate | 1 | 3h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Helps manipulate data - I use it a lot
Also made the switch from finance to consulting. Everyone uses pivot tables, it's normal. For how we use them to simply sort and map data, it works plenty well enough. Honestly, now that I think about it, we could probably get more done actually just burying into SQL or Python, but this is consulting after all and our industry isn't exactly known for being the most technically savvy.
I used pivot tables all the time at MBB when we needed data to be cut quickly. Best practices that I had were:
1) Don't touch the raw data or modify it
2) Add columns to raw dataset when you need additional calculations done, or when you need to group things in certain ways
3) Create a separate sheet foor any index/match lookups
4) Create a pivot table on the raw data plus the new columns you added
5) Format appropriately
6) When you need additional pivot tables in new sheets, just copy and create a duplicate of that sheet, don't make a new pivot table, saves time
Voluptatem nemo qui adipisci. Et ex est molestias unde. Doloribus assumenda quos doloribus inventore consequatur tempora.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...
Quidem qui repellendus sapiente neque. Ut omnis voluptatem dolor ut rerum eligendi. Repellendus eos reprehenderit deleniti autem. Impedit voluptatibus quis architecto omnis. Autem sint libero et mollitia dolor aut fuga. Aut mollitia deserunt ipsam et.