There’s nothing quite like getting a massive spreadsheet to finally balance out after hours of head-scratching.
Small win? Maybe. Satisfying? Absolutely.

What’s your favorite “tiny win” moment in Excel

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

Take your engagement bait back to LinkedIn

:)

When I learned how to make a deduplicated dynamic list from a set of data…

That's awesome! Creating deduplicated dynamic lists is a super valuable skill—especially when dealing with messy datasets

like

Related Posts

I have lovely deep kitchen window sills that get blasted by the sun. Ideas/inspiration for your favorite full sun houseplants?

like

What are some of the perks of working for Deloitte?

like

Looking for a job in GSK , as a technical Argus safety pharmacovigilance consultant with 9 years of experience. Thanks in advance .

like

Agency recruiters, how would you rate today’s market for creatives? Is it more of a freelancers’ market or is it tight for everyone at the moment?

like

When are the layoffs going to start? Anybody care to wager a bet?

Typical non-equity partner salary? Include law firm size pls.

like

I have an interview coming up with Church & Dwight. When the recruiter emailed me with 3 interview times I thought he was asking me what time works best. Turns out he was telling me I was scheduled for 3 different interviews for 3 different teams in one day. Has anyone heard of a company doing that or gone through this for an interview? It seems odd to me

What's the difference or gap between the skill set of L3, L4 and L5 engineers? Basically, how to know the exact correct level to apply for?

like

Just joined Deloitte India. Worst on boarding ever. The people were like robots, reading scripted matter. Seriously it was a pathetic experience. Esp Mumbai Talent team people unable to take queries even gave false information about leave policy. Deloitte Deloitte India Deloitte USI

like

What are your thoughts about someone willing to pursue SAP consulting as a career ? Oracle and SAP are standard ERP systems in Fortune/Big companies so even if one joins and learns in 2-3 yrs what are the growth opportunities in SAP ? I do recognize that there are a lot of advanced planning systems out there but in reality is it fair to assume that one can easily plateau off in 5 yrs from a career progression standpoint?SAP Oracle o9 Solutions Blue Yonder Kinaxis Inc.

like

null Can anyone let me know how long it takes to receive Fnf from EXL? My last working day was 9 September but I haven't received it yet. EXL Exl Pvt Ltd

like

Hi Googlers, are there any advantages to using a pixel phone at Google i.e better enterprise integration, internal apps, etc.? Planning to switch to Android from iOS.

Thanks!
Soon to be Noogler

like

Hey fishes,

Can anyone help me with the below questions on RTO-

1. When is optum planning to open offices fulltime and in how many phases are they planning to open
2. Do they provide cab servies
3. Do they provide breakfast/lunch/dinner inside office
4. Do they follow any dress code
5. Office timings

TIA😊

like

Is anyone currently pursuing the CIA certification or recently passed? I am having trouble passing part 2. Any advice is welcomed. I passed part 1 over a year ago and haven’t been able to accomplish the next hurdle.

like

Anyone on these food antitrust cases? Not looking to disclose details just wanna know if suffering alone.

like
like

Any thoughts on the company Deep Instinct? So far, I am seeing good press and reviews.

like

Need some urgent help can anyone DM me, Please

like

Out of these 3 which one will be good for long term and offer job security.
1.
Northern Trust Corporation
2. Capgemini
3. Epam anywhere not EPAM Systems
I am tired of changing companies.
Now, I want to stay in one company for long term till retirement

like

Anyone here know of a wholesaler that supplies bottles like this? I've checked Alibaba, Thomasnet, and various other sites, but not much luck. I can't currently fulfill anything above 500 bottles and most suppliers I've come across have a minimum of 1000 or more. Any help is greatly appreciated!

Post Photo
like

Additional Posts in Excel Genius

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

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

like

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

Post Photo
likehelpful

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

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

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

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)

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

like

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

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 look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

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

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

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

like

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

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.

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

likesmart

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

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