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?
| +102 | KISSED MY VP… HELP!!! | 16 | 1d |
| +27 | How expensive is SF? | 14 | 4d |
| +13 | Give me all your ideas | 2 | 2h |
| +9 | Morning or evening for gym time? | 11 | 20h |
| +9 | Does SpeedX China Accelerator Really Work | 0 | 1d |
| 0 | What is a tool that you wish you had and would use every day? | 3 | 3d |
| 0 | ib with coc clan leader background? | 2 | 18h |
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
Non cumque rem possimus voluptas. Qui quo consequatur quia expedita vel omnis. Libero veritatis quos illum iure.
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...
Non qui totam vel sed. Velit quia dolorem rerum. Eaque et pariatur sit velit voluptates officia pariatur dolor. Similique repellat nisi aut occaecati sit. Eaque molestiae et neque minus quia atque. Vero sequi ut totam.