If you had to describe your Excel style—are you the minimalist (clean sheets, few formulas), or the architect (complex formulas, hidden sheets, dashboards)?

Which type are you, and why?

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

Reusability is important save times long term

likesmart

Both, but lean towards architect, because few things only need to be done once.

like

Make sense no wrong answers just depends on use cases

Mostly architect but if it's Excel, I'm interested! I try using it for most requests.

like

Nice that’s awesome

Personality disordered hoarder and I have no idea why

like

Depends on the situation. One off ask? Quick, simple. Part of a repeated process? More involved

Thanks for sharing yes I can see it varies depending on situation

Related Posts

Hey D1, you left a copy of your resume in the conference room. You know who you are. Now the entire team knows too.

funny

I got an email before the holidays from KPMG that they would draft written offer post holiday break. is that something I can rely on, or would they have a chance of not sending offer? Thanks!

like

Got offered a pharma/healthcare role (currently work consumer side). 15% more than current role, lateral move, remote for now of course. Not sure if I should take the offer or not, given I have no experience in pharma & health. I said I would sleep on it. Advice?

like

What is the Senior Product Manager salary at Microsoft for someone who joined from IIM and got promoted internally? Does it match with someone joining as SPM?
Microsoft

like

Hi techies

I am a python developer with an experience of 3.3 years. my current CTC is 7 lakhs.
How much salary can I expect If i switch now?

Can anyone share work culture and flexibility in olam Chennai. Also what is salary range and incentives for associate director in olam.

like

So, what happens if you miss your utilization/billable hour target by like 70-150 hours? Tons of "impactful" PRD work

like

Saw this in another bowl so thought I’d do one here 😅
What was your approximate pay from graduating college up until now?

2020: $48k
2021: $50k
2022: $53k + 5% bonus

I am SCM analyst. Covid seems to have impacted the SCM industry a lot. Share if you’re comfortable and give a little background of your career journey / advice if you’ve been in the industry for 5+ years

like

What salary range should I give for Avascent analyst role?

like

Going to Denver mid December, would like to drive up to the Rocky’s. What trail would you recommend for a day trip and wouldn’t be too difficult with weather conditions at that time? Is it possible?

Any idea why certain of the larger biglaw firms do not allow descriptive associate website bios unlike the more middle v100 firms?

like

Those of you who have worked both in India and US - what are the biggest cultural differences you’ve noticed? All else being constant (like industry, type of work, etc)

like

I am looking account job in ahmedabad

Hello Fish mates!

I am here seeking your 2 cents how my decision of moving from Corporate Loan Operations into Vendor Management operations within Goldman Sachs is going to be beneficial for me.

Please feel free to list out any drawbacks too!

Thanks
- Fellow Fish

like

Dear fishes,
Looking for referrals for the role of a product owner.

experience - 6 years.

Available to join immediately. Any referrals would be highly appreciated.

Regards

like

I recently come across a position at PwC tiled "Risk & Regulatory Business Process, Controls & ITGC- Manager" Can somebody provide me more details like culture, salary range, and information specific to the group?

like

I need help from an accountant or a financial analyst. I need to compare fed vs private company retirement and help me create a retirement plan. I will pay for the services. Thank you

like

Anyone has IBS here? Lately I have been having a lot of symptoms of IBS and even if I’m not fully constipated, I think I am to a certain extent. I had excruciating lower abdominal pain this afternoon and it was almost unbearable. Also, my period is approaching so I think my symptoms got worse. Anyone has any tips?

like

I know this has been asked before but I can’t find the thread. How much do firms care about GPA as an experienced hire? I had a really shitty GPA in college.. will that affect my offer?

like

Additional Posts in Excel Genius

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

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)

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
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

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

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

Still don't have xlookup. #fomo

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

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

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

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)

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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.

Would anyone be willing to teach me vlookup?

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

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