Last week, I spent hours troubleshooting a stubborn formula—only to realize I’d made a tiny typo. It was frustrating at the time, but finally getting it to work felt like a huge victory. It’s those little moments that remind me how rewarding problem-solving can be, even in the middle of a busy week.

What’s a recent “small win” you’ve had at work, whether in Excel or another area? How did it make your day better?

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

Had a small wins teaching a new hire how to do conditional formatting. He was so thanksful haha

Related Posts

What are the basic things to keep in mind or to keep it ready before moving to Australia?

The GSAP payback formula shows “+1/2 grants and scholarships”. Does this mean Deloitte pays me back extra for getting money from a school?

like

How do younger Females feel about dating or getting into a relationship with older people, age gap 5-6 years 🤔

Genuine responses

like

I have received an offer with a 6 month probationary period, during which time I can be terminated with 1 weeks’ notice. Are these normal terms? I just want to be sure and have very little familiarity/context.

like

Entire fucking Ritz Carlton smells like cigarette smoke... how many points

like

Found a bed bug in a Radisson Red in Campinas Brazil, how many points?

like

I’m 36 and I recently reached a net worth of 1 million dollars. I thought I was doing good but then I see other people with several millions and can’t help but wonder how they got there.
I feel I’m doing everything I’m supposed to (I save, I invest, I max out my 401k, IRA, etc...).

What can I do to upgrade my game and reach those higher numbers?

likesmartfunny

Looking for advice: Boston ring shopping stores and any general tips on how to shop

like

How come in TV shows there are different salaries for different actors? And it's even worse when you bring numbers in. Per episode, there have been cases where some people make twice as much as others.

like

I will possibly be getting a machinist role through some contacts, and I have no experience in the field and I’m wondering what I could expect to make, when I look up average salaries for a machinist position I see around 65k but that seems too good for my age and experience so I’m wondering what some others in the trade on here are making

like

I am in the finance dept at my agency and have been struggling to get into the media department. I'm fine starting off in a junior role but after countless applications no one will give me a chance.

What is the average salary for a Product Manager with 7 years of experience (5 years as a PM and 2 years as a Dev) in Toronto?

like

Anyone know what is the job n responsibility of application owner in mumbai

Qt k ,nsultancyhly

like

Any recs on a good office chair for the back? Looking to spend <$350

like

Hello RSM coworkers! I am thrilled to be moving to RSM into a Scheduler roll. I just found out yesterday and want to be as prepared as possible in the next steps.

So here are my questions.

How long does the background study take? I'm guessing admin staff have a study that is faster and less complicated than someone in Tax ect.

When training at home what did you need that wasn't supplied by RSM? My home office is well stocked but I want to be as prepared as possible.

Thanks in advance!

likefunny

Does it make sense to take a pay cut if given a chance to join the corp dev team of a growing company? Currently a manager in Fdd

like

5+ years of full-time job as developer and still waiting to reverse a LinkedList at work.

Since there is a heavy impetus on solving Tree, LinkedList, and Graph problems for tech interviews, it can naturally make freshers believe that these concepts will be used in day-to-day life at work. In reality, most of these DSA concepts are already implemented in some libraries our code uses and we rarely have to code such Algorithms by hand.

Problem solving skill >>> DSA
What's say?

like

Always thought I was an introvert but maybe I’m just drained from a toxic job and haven’t met my type of people. Is that possible?

like

I’ve listened to Lil’ Bit by Nelly and Florida Georgia Line 7 times today.

likefunny

Additional Posts in Excel Genius

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

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

Post Photo
likehelpful

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

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

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

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 can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

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 change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

like

Would anyone be willing to teach me vlookup?

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.

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

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)

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

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

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

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

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

like

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

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

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