The first time I discovered PivotTables, I remember thinking, “Where has this been all my life?” It completely changed how I look at data. 😀

What was your biggest “aha” moment in Excel where something just clicked?

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

Vlookup is my latest aha, game changer

like

I used to use V Look ups. Now I use X look ups instead. So much better!

like

INDEX/MATCH

like

That’s a nice one I use it all it the time with to complement other formulas

Any other sites/tools you'd recommend for someone newly breaking into the industry? Something that breaks down the wall to access fundamental but powerful skills?

like

Power bi very powerful with their up and coming copilot integration

Formulas > conditional formatting > pivots > XLOOKUP > Power Query > Power BI

like

Yess!! 🙌 love the powerbi plug

like

same

smart

Select visible cells and tge sum if

Awesome 👏

Index (match(),match()) was one of the greatest things I've ever seen

Power query, PowerBi, DAX formulas

Power query is game changer love that powerbi has it integrated

Oh pivot tables make me so nervous. I hate and love excel. I need more knowledge base tho. I know that

🙂

Related Posts

like

Anyone that works for DOD have trouble getting their CAC? I work with the Navy and haven't heard anything about issuing a CAC. Did they stop issuing out CACs?

like

May I know why are we not allowed to eat in shuttle? I was stopped by security guard cz I was eating ... I was hungry,packed up my food,running out of coding work . .. Strange !!

like

I want to get middle school cert (for ELA) My degree is K-8. My current cert. & EdTPA is K-5. What's the quickest & easiest path to middle school certification?! (I'm in TN, specifically Sumner Co.)

like

I am having LTI offer letter but the joining date mentioned in that is incorrect. When I called HR to change the date she told me to first accept the offer letter and resign from the current company and give me the screenshot of your resignation mail. So I did as she told. But till now my joining date is not changed in the offer letter and HR is not replying to any email, call or sms. What should I do now?

like

On my honeymoon and already self conscious of gaining a little weight from indulging in cocktails and treats. How do not punish myself but also not make excuses for myself? Will losing this weight be as simple as cutting out the excess when I get home? Sigh

like

I’m thinking about transitioning to In-House from a big law firm where I practice Employee Benefits. Will employers consider me without the typical “corporate” or “litigation” experience?

like

VMLY&R makes me afraid for what body horror merger is next

like

Hi,
Lead-technology is only for development role or it might be qa or production support in synechron

like

I know the pay at Jackson Lewis is subpar, but is anyone at JL and happy there? I understand this is also probably office specific but am curious about culture and vibe.

like

This cutie 😍

Post Photo
likeuplifting

Has anyone ever had any success in getting a delta base economy fare refunded? Am no longer going on a trip and wondering if I can get those points back that I used to cover the fare

like

Has UST Global opened any office in Kolkata?

How is $120k salary for Manager in Consulting in Toronto?

like

Anyone traveling again yet or received communication about when you’ll be back on the road?

like

What’s the comp range for a manager at KMPG Advisory?
Assume post MBA with two years as an SC, and 10 years pre-MBA experience in the same industry vertical.

like

Any idea what the comp range is for a lvl 4 at BDO

like

Hi Fishes, Can anyone shed some light on what does PWC SDC pays to Audit Senior Associate with 2 YoE Post Qualification. Qualification (Chartered Accountant).

I have heard that they are paying good this year but wanted to know specific numbers if someone can help.
Current CTC - 11 L

like

New to the area, anyone in this group into hunting?

like

Hey hey guys.
I am looking for a good example of a cv of a mbb consultant who moved to a FAANG. Any guidance here

like

Additional Posts in Excel Genius

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

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

Still don't have xlookup. #fomo

like

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

Post Photo
likehelpful

How do you fix microsoft excel cannot paste data error?

like

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

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

Anyone know what these badges are?

Post Photo
likefunny

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

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

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

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)

Hello all, hope you guys are having an amazing day!
I’m wondering if anyone has a good beginner friendly resource in linking SQL database to a Worksheet. Tips, in-depth tutorials, that good stuff

like

Any book recommendations on excel modeling for real world business applications?

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

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

Would anyone be willing to teach me vlookup?

like

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

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

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

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