Not long ago, I realized I was spending way too much time manually updating status trackers. Learning how to link data across sheets and automate calculations with formulas was a total game changer for my workflow. It freed up hours each week for more meaningful work.
Has there been a moment when Excel (or another tool) helped you reclaim your time? What changed for you?

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

I’m a very rudimentary user of Excel but I’ve discovered Power Query and it has been a game changer for me.

like

I feel the sentiments for the almighty power query. Literally life changer and saved so much time

Related Posts

How much salary a cyber security consultant can expect with 4 years of experience? In big4 ? Current CTC is around 10 LPA.

Hi,
Could you help me with the salary range / average salary for Deloitte Finance Transformation.

Designation - Sr Consultant (Management Consulting)

Exp -3+

like

Any advice for understanding whether sourcing would be a good match for your personality/innate skill set?

Im pretty extroverted, I have been told in reviews that I peak in verbal communication, and I have really loved conducting expert interviews in DDs.

However, I’ve worked some sales jobs in the past, and I had a hard time with the variability and staying positive bad times when nothing is sticking.

like
like

Fake it till you make it

Post Photo
likefunny

Anyone starting their own VC/GE fund and looking for people to join? Down to help with DD and sourcing

likefunny

Internal auditor here, has anyone considered/gotten the Certified Regulatory Compliance Manager (CRCM) Certification? If so, can you share any pros/cons regarding the certification?

like

If my clients are the firm’s clients, it’s up to the firm to let them know I am leaving right? I’m leaving for a government position so I can’t take them with me anyway.

like

I am a technical recruiter with three years of experience. I am currently interviewing at a series B tech start up located in CA for a fully remote position. I am currently in Texas and don’t have to pay state income taxes. I am making about 90 K and would love to bump up my salary from there. My question is, what is a fair salary to ask for that will factor in both the new income tax and a raise? My other question is what is a fair salary in general for somebody with three years experience?

like

Any insight into the Barnes & Thornburg, Los Angeles office? I see there’s an opening for a Products Liability Litigation associate.

like

If a company I got rejected from is posting an opening for the same role should I re-apply? Any chance of a better outcome?

like

Hi will KPMG blacklist if we reject offer letter after accepting it.

like

T3 firm reached out re: direct admit to the partnership with some runway to grow the practice. I am at a firm now where there aren’t bright line metrics to make PPMD, but think I could make it in 2-5 years. This would be a step down in brand, but might be better from a WLB and getting to start at partner. Haven’t had firm comp talks yet but range was well north of 50% increase in cash comp from current (plus LT equity, draws, etc). Anyone take $ over brand? what are some traps to watch for?

like

My bf has asked me to help him quit the ecigs and told me he’ll probably hide them from me but he wants me to take them. So I have for the past week. He really only keeps them in his pocket, 1 drawer

Fiancé’s milestone birthday coming up. We both love experiences and enjoy the city. Welcome all the help to make it special for her!

like

I’m mid 30s F. Recently started seeing this guy, where he is “good enough”. Good conversations, decent time together, he has a good heart, but nothing about him shines. - not fit (I work out everyday and play sports), meh social skills (he doesn’t have best friends, just few he hangs out with), bit less energy than me.
There is a feeling in me that says “he’s going to be a comfortable life partner” and “he is just good enough, but if I break up I won’t find someone for a long time”
Do I stay?

like

What's a good place to live to access both downtown and Argonne national lab in Lemont? I live on the far north side of Chicago now, but my partner got a new job and it would be an hour each way by car to commute for him. I work downtown along the red line. Looking for somewhere affordable, not interested in night life or anything but groceries and transit need to be 10 minute walk or less and be safe. Also prefer CTA over metra since my company has later night events. Thank you!!

like

Anyone else feel restless - I'm happy with my job / money but this restlessness surrounds me, want to do something else, something creative, something bigger than a job...

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

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)

What are your top Excel ninja tricks? Ones that few people know...

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)

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

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

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

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

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!

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

like

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

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

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

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

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

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

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

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.

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

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