Every Monday, I start by color-coding my spreadsheet tabs—it’s my weird way of getting into the zone. Does anyone else have little rituals or habits that make working in Excel feel a bit more… fun?

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

Lighting one up

Hahaha

Go see a doctor 😂

LOOOOL

Related Posts

I run a small SaaS startup. I am looking for a growth manager for my company, who can wear multiple hats. She should be able to do presales as well as helping me in the building strategies for the company. Any help, what should I look for in an ideal candidates? Any suggestions about how would I interview candidates? Thanking you in advance!

like

Hi Fishes, What is the actual payout ratio of PIP component of Schlumberger offer letter? I am having 1.1Lakh PIP component? How much out of it and when i will get that? Also what should be proper package to ask for for 8.5 YOE in SAP technologies? Thanks in advance.

like

My pregnant wife has weird food cravings. How are you supposed to deal with this?

like

Best pizza delivery in Boston? I really like Picco. Upper Crust is trash. Regina is decent.

like

what’re the agencies in Toronto that are best for diversity / healthy culture of mutual respect for all - women, POC? know nowhere is perfect but any doing okay?

like

Nice bowl to avoid lowering the average in the US-centric threads. Anybody else finding that with the lack of pay rises this year, it’s become even harder to benchmark? Had a few recruiters recently suggesting I’d get 25% more by moving to a competitor but no telling whether that’s a short term-gain for a longer term hit.

likefunny

Whatever happened to that guy years ago who bought google adwords of creative directors to ask for a job when they google themselves?

like

Can I still apply if I'm new to Salesforce ecosystem?

like

Anyone know if MBAMath class helps get off waitlists?

Considering working from India for a couple of years due to personal reasons. Any advice for Salary expectations/negotiations? Haven't worked in India for over a decade.

Senior consultant, came into Deloitte with over 14 YOE (industry), in the FSI -> IM space, expertise & experience in buy side asset management.

If you are open/willing to offer referrals, happy to talk. Any insights are greatly appreciated. Thank you.

like

Sharks! I’m 33, currently working as a Java Architect (11.6 YOE, 40 LPA INR). I’m planning for retirement at my 40. Currently owning a house worth 1 Crore INR where I’ll be closing my home loan by this August. Please suggest diversified options of Investment for my retirement. I don’t have any investment till now (except the house) as I used my whole income to close off the Loan which I took in 2019.

like

Any of you guys in Hong Kong?

like

How do RSUs/equity work? I received an offer that includes $20k equity. I'm not sure if this is good, or low, as I don't really know how the payout is calculated or given. Can anyone advise?

Anyone else calling a Tether collapse?

Any russian-speaking M7 MBA graduates here? What was your GMAT score?

like

How is HSBC Client in terms of WLB and work culture

like

What is the org structure at TCS from consulting stream?
As in I have been offered C2 system Analyst with the work exp of 4.5 years... can someone please share the job level bands with comparison to Infosys Job level?

like

Just saw a meme that said “I’m going to turn off the news and put on a serial killer documentary to unwind” and…..ya. Does anyone else do this?

likefunny

I lateraled into a niche practice group in Sept 2021. I also have a 1 year old and have been mostly remote since I started - but have been keeping busy tracking towards 2400-2500 hours. That said getting to know people only remote has been kind of awkward at times (email only can be tough to decipher) although as a working mom the pros vastly outweigh the cons. Yesterday my main partner asked me to come in Thursday bc he will be there and set a time to meet. Is this good/bad?? kind of nervous!

like

Additional Posts in Excel Genius

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

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

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!

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

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

like

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

Anyone know what these badges are?

Post Photo
likefunny

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.

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

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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

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)

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

likehelpful

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

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

like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

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