Need question: What's your favorite excel formula?

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

One of my favorites is INDIRECT which allows you to change the cell you are referring to on the fly.
Also, not really a formula, per se, but a method for simplifying your formulas: helper columns!

like

Alt + F4. It solves many issues with Excel

like
Recent IconRecent

Nested IF statements

like

Index match is indeed a powerful one, especially if you do a cross lookup with index match match

like

Solver

like

Also, to all the VBA gurus out there, where do I start learning it?

like

If I know I'm not going to insert a column, why not use vlookup?

like

OP, MSDN would be a good start for VBA.

like

Offset is the most underutilized and underrated excel function

like

I can’t seem to comment the link (I tried on two different devices). Just Google Power Query, it’s at the top of the list

like

Conditional formatting 💙

like

Just a tip from my side: combine filter with SUBTOTAL

like

GIVETO(SA1)

like

Oh btw, it was supposed to be "Nerd question", damn you autocorrect!

like

I was just being snarky, because I knew it was a typo, though I thought that it was "new" not "nerd"

like

P2, Haha, now I get your first comment!

like

Countifs 💁

like

Countif ftw

like

Most used is probably vlookup. So quick

like

Using - - within sum product for weighted average ifs 🤭

like

Are you f*cking serious...

like

Related Posts

Clinical Access Coordinators at AHN, what are you making?

like

Hi All,

Can anyone let me know the premium per month for group term life insurance policy by lti.
As this premium will be deducted from our salary so can we add this deduction under tax exemption or not ?

PS : I am a new joinee and filling form B for projected investment, please let me know anyone.

like

Starting to feel I don’t like litigation. Third year. I’m not excited about winning an argument or destroying the other party’s arguments. But the current market doesn’t seem to favor a transition.

likefunny
like

Anyone wanna throw me their Uber eats referral code?

like

How has your experience been starting a new job during the global pandemic?

likehelpful

Hello! I just received my PSM I certificate for scrum master and I need help finding a mentor or a coach. Currently I am looking for new roles and would love any advise or referrals anyone may have in order to further expand my knowledge.

like

And there goes GIO's chance at the Haas F1 seat

likefunny

I received an offer for $74k as underwriting analyst. Company is based out of DC. Is $74k a good offer? Or should I negotiate for more. 6 years in the industry. 5 as an account manager/underwriting assistant

like

Just got laid off do I need cobra? I plan to hopefully have a job soon

like

I am an Automation tester with 9 years exp. What all should I focus for FAANG interview prep? Will the interview be different from that for Dev folks?

Anyone else work on Medicaid projects after coming from commercial and amazed at how dysfunctional the operations are?

likefunny

I got this assignment project as part of my selection process. As per me POM, pom.xml, TestNg are used with Java program. Can someone pls help me understand if these can be achieved using python. If not pls help me understand how to achieve this task.
Thanks.

Post Photo

FLORIDA: can an attorney accept services as payment from a client? (E.g: drafting a demand letter for a client in exchange for web design services)

like

So much baggage brought into the relationship. 2 years in and just discovered a whole lot more. Its been mentally extremely difficult and it’s changed me as a person. Just venting but feel hopeless and I know my SO is suffering. Wish there was a solution but I’m losing hope

like

Can somebody please refer me for Microsoft Germany? I’ll contact you with further details :) TIA

like

What is the slary range for level 25?

like

At what point you start coming on radar if you have been on beach for significant amount of time? Like Since thanksgiving . Is there a schedule to let go?

like

Does anyone here know anyone who threw a covid party or attended one? I just read about them in the news, but don’t know anyone who would go to one, especially advertised as such.

like

Additional Posts in Consulting

In terms of benefits (vacation, medical/dental, phone/internet reimbursements, etc), which is better EY or Deloitte? Asking because my niece received offers from both and just wanted to offer her some help in deciding.

like

Owe ~$4,500 in taxes for 2020. Anything I can do to reduce this amount? Going to contribute some extra money to 401k to get me to 19,500 for the year. Anything else?

like

Is there a way to share my phones wifi connection? In other words - if I buy wifi on the plane for my phone, can I have my phone then hotspot that signal for my laptop? Or vice versa? Thanks!

like

Does anyone have any book recommendations that have helped them become a better consultant ?

likehelpfulfunny

Almost 4YOE at Big 4 TAS. Seen high turnovers this year. Thoughts on the following options: FPA vs. CorpDev vs. MM IB vs. MBA to BB/EB or MBB?

like

Definitely not a fan of Westin's "Eat Well" proposition. I'm working in the room at 2:00 AM and the most appetizing menu item is a cold turkey avocado and arugula wrap. I just want a burger and fries!

like

Finally found THE one, after over a year of searching and trying out at least 5 different ones!

A nice comfortable office chair.

https://ergochair.co/collections/chairs/products/ergonomics-mesh-chair-w-adjustable-headrest-and-armrest?variant=32511617597491

My criteria: mesh seat and back, arms, headrest

I tried cheap ones from Amazon. Expensive, second hand gaming chairs. Tried HM Aeron (second hand) and while I didn't like the bulk and the general design, I was sold on the mesh seating. I wanted to get the ErgoChair 2 from autonomous, but it doesn't have mesh seat.

AMA.

likefunnyuplifting

Woke up to bug bite at a Sheraton on my Birthday.. #GreatStart🙄😪

like

any fishes in Memphis, TN ?

like

M/SM and above, why do you label a meeting as “touch point” or ask if you can have a “quick chat” when it’s something serious? Millennials like us always assume we’re about to get fired - I actually have been laid off in a meeting with that title. But at my new job, my boss asked for a “quick chat” to literally ask me to change the title of a meeting and then chat about christmas. Now that I’m in management, I want to understand it better.

like

Hello! Anyone work at GE Healthcare?

like

Anyone w hotel mgmt experience willing to talk? Parents own a hotel that is suffering greatly but could be amazing. I know nothing and am not at the table and my generation is not wanted there.

like

We use Deloitte India for a number of parts of our delivery. Recently I have seen some unethical practices that violate labor laws and do not align with Deloitte principles. My manager says it isn’t my problem as they are a vendor but I can’t help thinking I have an ethical responsibility to do something. Any advice as to how to approach this without being fired?

likehelpful

I think all frontline healthcare workers need to have their school loans waived, if they have them. (And yes, something for first responders/essential workers too. Like tax waivers maybe?) 🙏🏼

likefunnyuplifting

Has anyone actually received their reimbursement for filing taxes in multiple states? I got told that it would process with payroll last Friday but I don’t see it in my bank.

like

May be this is off the topic..
One of my friend who is a doctor & is an international med graduate. He passed his United States Medical Licensing Exams with above average scores. He has applied fr the match last yr & was nt able to match. Match process costs around USD10k; this year he is applying again after borrowing funds frm different sources bt he is under tremendous pressure to get match. I feel his pain as he has studied for 10+ yrs and is struggling to match nw. I m nt sure hw I can help

like

What are the best consulting companies in the US focused on Sustainability, either Strategy or Ops?

likefunny

When they say utilization doesn't count for the month of May/June what exactly does that entail? I'm assuming being on the bench for those months will still show on personal utilization reports...

like

Accenture folks, seeing lots of news about layoffs at other firms here. Are we in the same situation?

like

Any book recommendations? Preferably shorter < 300

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