Office debate: Gridlines or no gridlines? This is serious business.

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

Yes for financial analysis or big tables. No for summary reports and presentations.

like

Internal WPs? Grid lines. Client facing, nah.

like

Depends on the sheet and how structured the data is excluding gridlines. If you have a lot formatting, gridlines can get in the way. Need to also consider consistency across sheets for showing/not showing

Never

Related Posts

I am having 12.5 lpa CTC with 7.7 YoE. How much can Delta Airlines offer?

like

No FSW draw what's happening!?

like

How long does it take to get an offer letter once the mail offer is discussed and thru..I have been waiting for more than 10 days but there is no approx. TAT indication

like

I’m a copywriter in advertising, but I’m seriously considering a sabbatical to start a novel. Anyone have great resources for book building/novel structure guides?

like

Any recs for mixology classes for couples?

like

How is SAP hybris practice at KPMG?

like

Hi Fishes,
What kind of work is done in GCR Tax? Is there decent wlb?? Can someone pls share the hierarchy structure in GCR

like

Any idea, what will be the second round interview for azure data engineer in EY gds?

like

What would you choose? MBB (Digital practice) or Amazon PMT?

Background: T15 MBA student, 7YoE as Mech engineer, long term goal is to climb ladder in Tech, married and have a 2year old

Situation: I have a MBB and Amazon PMT offer for summer internship that I need to choose. MBB comes with FT offer, Amazon PMT will most likely result in return offer. If I go with MBB, I plan to exit to big Tech in 2-3 years. Y1 TC for both will be quite similar (around 230k).

Thank you in advance!

like

Sorry if this has been asked ad nauseum around here, but can anyone recommend a really good (yet easy and basic) skincare routine? Specific products/brands would be really helpful.

Mid-20’s here. TIA, I really appreciate it.

like

Hello Fishes I am working on SCCM/MECM (Infra) domain. I have cleared my technical round for IBM, so now I am waiting for the salary discussion call. I do have total 5 yoe. Current CTC : 6LPA Current Company : HCL So I would request you to please lemme know what amount or range of salary I should ask ?HCL Technologies IBM EXL Service

Hi! About to join a PE consulting firm but don't have an extensive experience in doing CDD. Any good books /online courses with some practical examples that you'd recommend to get upto speed?

TIA!

like

I am an associate at a UMM and my employment contract has a 4 month non compete (yes, even for associates) but I am thinking of lateraling. What are the implications of breaking a non compete? I didn’t say anything when I signed because I was desperate for a PE offer but it seems so unfair as I am just a lowly associate. I am not so much worried about getting sued, but about my current employer tanking my reputation if I leave and break the non compete.

like

Hey Booz Allen Hamilton friends! Looking for a referral for a Technical Writer and Release Manager remote position. Let me know if anyone can help!

like

Is Charles Tyrwhitt a good brand? They have 3 shirts for $89 right now and they usually have deals for 3 shirts for $99.

like

How’s your work-life balance? New job at a new company and wondering how to clarify standards on this

like
like

Google spot just killed me 😢

like

That was fun by Audi. Love the choice of song.

like

Additional Posts in Excel Genius

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

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

likehelpful

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

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

How do you fix microsoft excel cannot paste data error?

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

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

like

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

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

Still don't have xlookup. #fomo

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!

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

Would anyone be willing to teach me vlookup?

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

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

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

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’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

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

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