A while back, a teammate asked if I could help them with a tricky Excel formula. We ended up sitting together for half an hour, going over SUMIFS, conditional formatting, and some keyboard shortcuts.
By the end, not only had we fixed the formula, but I realized how much I enjoyed showing someone else the ropes.

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

+1 for wholesome

like

thanks!

Have any favorite tips?

like

One of my favorite advanced tricks is using the FILTER function (available in newer versions of Excel). It lets you instantly pull just the rows you want based on any criteria, and the results spill into the sheet automatically—no need for copying, pasting, or complicated helper columns.

like

Related Posts

Hello London folk. There’s a lot of great chat about diversity in adland on fishbowl, but it’s all very US based. So I’ve just started a bowl on diversity in London specifically - 9qo8f

like

Doing a budget travel to London for 4 days. Took a London pass for 3 days. Any other must dos while I'm there that can fall within my budget backpacking trip?

like

Best Marriott hotel to stay in Amsterdam for a weekend? (For a 28 year old single male :)

Weezer fans, give me a 👍

like

Samsung Galaxy Note 9 or iPhone X/XS? Like the S Pen for writing but would also like to be able to send texts from iPad without keeping the phone on (I.e. iMessage). Currently have an iPhone

Any tips for someone trying to break into consulting in the GCC from the US? Applying blindly hasn't worked out. Head hunter recommendations would be great as well!

like

What is the best way to search for remote job openings in the IT sector in Canada provided you already have a PR and everythg is legal

like
like

The concept of Pseudomorphosis applies to most emerging changes to organizations and leadership: They are forced to comply with outdated structures dated back to Taylor.

How does underwriting compare to PIP litigation in terms of flex time (ability to stop/start work throughout day, work at 2 am if needed, etc)

For example.. in PIP Litigation I can review my suits at 2 am if needed (as a result of having a rough day or other emergency) and still be in compliance

Does Underwriting carry any time sensitive tasks?

likehelpful

What's the New joiner registration grace period at Accenture?can someone help me to understand.

like

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

Bank error 30k in your favor. BTC… Where to start?

likehelpfuluplifting

What is Accenture Car Lease Policy in India? Please share details. TIA.

like

Just received a text from a team member stating two missionaries that traveled through Tokyo were in my classroom teaching (private school). Said they hired a company to deep clean tonight. Thoughts?

like

Guys... are they giving location of our choice...specially Chennai and not bangalore..?

I have submitted my background check for the new offer. One of my previous bosses I referenced and now I am trying to call and text him to inform but he’s not responding so I am worried. (Cont’d)

like

So what's the deal with read receipt requests? Are they timing people once they have that notification? 🙄

likefunny

Additional Posts in Excel Genius

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 created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

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

Still don't have xlookup. #fomo

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

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

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

Post Photo
likehelpful

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

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

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

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

Everyone: Excel is a smart app
Excel:

Post Photo
likefunny

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

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

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

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

How do you fix microsoft excel cannot paste data error?

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