I’ll admit—sometimes I spend too much time making a spreadsheet look “just right.” But when different people format things differently, it quickly turns messy again.
How do you balance clean formatting with efficiency in Excel, especially when multiple people are editing?

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

I don't let them edit. I use powerbi instead

smart

Umm that should be dictated from the start or there is ONE person who is in charge of the project who will reformat everything prior to delivering to a client. For my team I have a sheet in the workbook, that is like CAGR 1 decimal, Percent of Z, no decimals. All column headers are bold, centered vert and horizontal, etc etc etc.

Haha I like the example

like

Related Posts

Any really impactful books that have helped you career-wise? Not necessarily consulting focused. In need of guidance and a new book so figured I'd kill two birds with one stone or whatever.

like
likehelpful
like

Any tips on how to deal with this…my entire team was let go today (was 5, now just me). We functioned as the Marketing team for 4 brands and primarily focused on product launches and sustaining social media content. My plan moving forward is to only focus on the top revenue driving product launches for now and say “no” to basically everything else. Would love to hear from anyone who has been in a similar situation and can offer some advice.

like

Did you vote? I finally made time after work yesterday.

like

The mid-level associate who directly supervises me isn’t being responsive. I am worried about missing a deadline. Should I keep pinging him? Figure it out on my own? Reach out to someone above him?

like

Resigned already 30 days back

Got 75% from accenture

Feeling like I should revoke resignation.

I am actually loving the people I am working with.

Not sure what is waiting for me in new company.

Will I regret leaving deloitte for accenture?

like

Does anyone have experience in SIOP in Supply Chain? What organizations do it and can explain how you use it for work?

like

How will things be at Apisero be after a year into NTT buyout? Apisero NTT DATA Tata Consultancy Infosys

like

2nd year SC with consistent 1 or 2 (top) ratings, and 5 yrs experience in digital / CX. I've decided I need a change - what can comp I expect in NYC at other big 4s? Anyone care to refer me? 🙏

like
like

I have 2.5 year experience in dot net technology. Now I am looking for change. My current ctc is 6lpa. how to prepare for dot net interview. Can anyone pls guide me Tata Consultancy Accenture India Capgemini Cognizant Mindtree GlobalLogic Nagarro . Thanks in advance

like

I have got an offer of CTC 23.25LPA +JB +RSU in Blore. And I have also got an international offer of CTC € 70000 + relocation sponsorship in a mid sized firm in Vienna, Austria.

My wife works with a CTC of 15LPA in Blore.

I am in dilemma about the option that is most suitable for me as my wife would have to quit her current job and relocate and then find another job. Is it a profitable deal to relocate to Austria?

Kindly post your opinions.

like

Hi! How’s the growth in the tech department of the company? How are increments and bonuses?

Looking for ideas:
I’m in person with half a class a day and I see them twice a week. The only reading curriculum we have is literacy footsteps which is small group. My room is maxed out of room so there is no place to do even 2 people small groups and do social distancing.

Does anyone have any ideas of what I could do? Would meeting once a week with a student for 10 minutes really be beneficial at that point?

like

Can anyone tell me what is the SA2 salary range in advisory for more than 5 year experience

like

How much does Infosys pay a Sr Consultant in Canada with 5 years of domain level experience? I believe it is ~$110k-$120k plus Bonus. Pls correct me if I'm wrong.
Thanks

like

I’ve been approached my by company that one of our large clients (who im currently project managing for) is looking for a consultant of sorts, and if they hire us, I’d be the first person asked to take on this consultant role. This isn’t something my company typically offers and would greatly change the scope of my role. Has anyone ever taken on a role like this? If so, were you able to negotiate a percentage of the consulting fee? Or was it a bump in salary during the project?

Additional Posts in Excel Genius

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

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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

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

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

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 book recommendations on excel modeling for real world business applications?

like

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

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

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

How do I compare two sheets to make sure they are identical?

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

Hello all, hope you guys are having an amazing day!
I’m wondering if anyone has a good beginner friendly resource in linking SQL database to a Worksheet. Tips, in-depth tutorials, that good stuff

like

How do you fix microsoft excel cannot paste data error?

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Would anyone be willing to teach me vlookup?

like

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

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

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