Don't sleep on the classic pivot table. I've always felt it's way easier to read and interpret than the default. Who agrees?

Post Photo
like
Posting as :
works at
You are currently posting as works at

100%

like

I don't know how to change settings on that, so I just do insert, pivot table, and whatever settings are there I keep. Then I have all my options to filter it.

Agree… classic view is the easiest to understand and make sense of

Post Photo

What?!?!? How is a 25 page report not enough. It seems like that would be sufficient.

110%

Related Posts

Any HR pros able to explain the process for hiring US citizens to Canadian offices, and if that process is so onerous you would rather offer a much higher US salary to avoid it?

like

Graduated May 2019, can I apply for campus hire jobs 🙂

like

Ok. Which of you Trumpers did this?

Post Photo
funnylike
likehelpful

If your client hired a life coach/consultant to help them through a family law matter, what would you want them to focus on and what’s hands off?

like

Is it true that AFS doesn’t allow people to start with a positive PTO balance?

like

Favorite light to medium coverage foundation with spf?

Nothing like some Hans Zimmer to get you in the FKING ZONE

likesmartfunny

Personal finance book recommendations?

like

If that’s your Art Director, then why is he in my google doc?

likefunny

Any recommendations for grow lights that can be moved around?

like

Is it worthwhile to get an MBA as a tech-leaning consultant (data scientist)?

like

I recently retired and I’d like to try out acting now that I have all this extra time to pour into it. What can an older guy (65) do to pursue a career in acting?

likeuplifting

Hi Fishes,
My LWD in Wipro (my previous employer) was on 21 Aug, 2021. I was waiting to receive my outstanding due and experience certificate, as part of F&F, ever since. However, I received an email from the offboarding team today stating that my Final Settlement is on on hold due to security concerns (DLP: data leakage). How is this going to play out? And much longer will it take before my F&F process is completed and I get my outstanding due and my experience certificate? Pls advice.

like

What’s the best ergonomic mouse y’all recommend? Can you please provide a link? TIA

like

Best consulting firms for PE work (CDD,Value Creation)? Looking for the best firm for exit ops to PE ops eventually. Thanks!

like

It appears J Crew is filing bankruptcy this weekend and brooks bros might not be too far behind. What are consultants going to wear when we eventually get back to work??

likefunny

Selling 2 tickets to Billy Joel at Notre Dame Stadium for this Saturday June 25th at 8pm. Please dm me for details!

like

Does anyone from the northeast regret moving to Miami? I’m from NYC. Mid 30’s, single. Don’t know anyone in Florida except for 1 friend in Orlando. Trying to get a gauge of how things are down there before I move.

like

Hey fishes,

Anyone recently joined LTI as senior data engineer P2?

Man, i need to talk you, plz respond

like

Additional Posts in Excel Genius

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Any book recommendations on excel modeling for real world business applications?

like

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Anyone know what these badges are?

Post Photo
likefunny

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Still don't have xlookup. #fomo

like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal