Maybe I’m late to the party but I just discovered the ASAP Utilities excel add-in and my life is changed. These tools can save loads of time!

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

Um then I’m way late, what is that!?

like

ASAP is great. You can get a free non commercial license from their site

like

What does it do?

like

Where did you get it from?

like

EY 2, are you sure it's free? It says 49$ at EY Appstore.

like

Literally everything. I’m only sad I didn’t find it sooner

like

Open a ticket on the self service portal saying you want to have the plug in installed on your computer and IT will install it for you. Just had mines installed today.

like

What approval is needed?

Related Posts

Do Data Engineers generally get much lesser CTC than Data Scientists and Software Developers at Top Product Based companies?

I am only getting 18.5 LPA (including RSUs) at a Top Product Based Company for 4 YOE, whereas many of my peers are getting 24-30 LPA for my experience level at my company. (some even lesser than me)

People are getting much more than me in Devops and Software Development - Both Frontend and backend.

like

Having 2 offers in hand one is Capgemini’s(Hsbc) and Coforge(Hsbc). Both companies offered same package. Any suggestions for job security and onsite which one is good. Having 7 years of experience..

Vive la France !

like

I have a credit card that I pay $95 dollars a year for, but I’m hoping to apply for another card that gives me more benefits but charges $250 dollars a year. Do people usually cancel their previous card when this happens or do they just keep both?
Thank you

like

Would you ever inform your coworker/managers about your ADHD? I’ve seen people becoming more aware of neurodivergency and wanting to listen to the experiences of neurodivergent people.

like

For Virtusa internal candidates :

If anyone has basics testing knowledge and good comm skills and willing to move to testing domain, feel free to comment

Hello fishes!

Can anyone refer me to HCL srilanka? Currently working in Cognizant, Hyderabad for Java full stack

like
like

Best Christmas gifts for other advisors?

Managers in consulting: what did you put for the “number of direct reports you supervised” field on the GSB app? Guessing we should use average size of our teams? Or total supervised to date?

like

Hello! Anybody here buying liquidation pallets and reselling as a side gig? Any tips would be greatly appreciated!

like

Any recs for a good CPA that can handle complex investment and crypto trading? I know there was just a similar post, but that was more international income focused.

like

Is it easy making a move from KSA to UAE?

Can someone tell me more about the data analyst role at Facebook? A lot of folks are been hired from a data Analytics + regulatory Compliance background into Facebook.. is it too technical?

likehelpful

Is being a SAP practitioner with the following skill sets; PI/PO, Data Migration/BODs, ABAP, and good management skills a bad mix? I feel like I’ve don’t to many things going for me. Not sure of my skill set or how to add more value of myself. 8 YOE

like

Hi Fishes, Pls Help me choose the right offer...
Role - SDET / QA
YOE - 2.4

infoedge ( Naukri.com ) - 18 LPA ( 16 Fixed + variable) - Hybrid Workmodel
Sprinklr - 15 Lpa ( All Fixed) - Hybrid
Talentica Software - 12 Lpa ( All Fixed) - permanent wfh

like

Hi fishes

Does fidelity revise offer letter without the counter offer or does they take the offer back?

Do you have guidelines of what you expect a transactional associate to know at X years into their license?

like

Additional Posts in Excel Genius

Experience a lot of downtime because I deal with massive amounts of data and need to constantly filter and delete records that are not relevant. Is there a workaround for this?

like

Convinced my non-accountant-but-still-works-@-B4 wife that Excel doesn't use the letter O at all because it's too similar to 0. And that most accounting systems don't use O either.

Score one for Excel nerds!

likefunny

I have a large spreadsheet with lots of dates, how can I identify classification based on the dates below? I.e. if your hire date was in between these parameters, it flags you. nested IFAND?

Post Photo
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)

Advice needed: I have a manager that I do PM work for, including metrics, and often get asked to “re-run the numbers” but this is an incredibly complex process that takes a lot of time to make accurate in excel, even though it’s a single-figure output on a team/teams progress

Is there any way to make them realize the effort that goes into it on my side? I’ve stated before but they mostly brushed it off - worried I backed myself into a corner by not making it sound hard enough the first time

like

Dumb question, when I hit (ctrl+shift+down) on column B (data in A) to highlight all rows, my sheet keeps going ALLL the way down to >10,000th cell... how do I make sure it only goes down to my data?

like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Hey guys current TB us set up with columns as company codes and rows as company accounts. Support was received with two columns being codes and accounts. What is the easiest way to update the tb?

Post Photo
like

What are the most typical models you all build

likehelpful

Does anyone have an excel test they can share (or point me to something online) that you use during the interviewing process to evaluate candidates? Not looking for an excel expert but definitely need someone who knows more than the sum function

like

Question. I have data in Column A & I want to color highlight cells with data on Columns B-Z that don’t match A in the same row. How could I write formula/function that can do this?

like

Does anyone know if there is an excel plug-in that links brokerage data (i.e. account info from fidelity/Schwab, etc.) so I can track/analyze on excel?

likefunny

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

like

Opinions wanted: I inherited an excel file around 2k rows and 50 columns used to manage stakeholder communications. Mostly free text fields and it feels very chaotic. It will be easy to miss an update/ hard to get a summary of changes without reading most of the columns. Would it be worth converting to an Access Db just for my use? Willing to put in the time to figure it out, but not sure if it will be more/less difficult to manage over time

like

Is there a way to use formulas within icon set-based conditional formatting?

I'm trying to compare D2 vs. C2, E2 vs. D2, etc..

I know I could create a helper table w values

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

How do I get a vlookup to spit out multiple values?

like

Boss seems to think I should learn Access and wants me to find a class. I can fumble around in VBA, but really only through using google. Is Access worth it or is there something better?

like

I have a table in sheet1. Column examples are ID, Initiative, Owner, etc. I’d like to use that table as a growing list of inputs. I’d like for sheet2 to be used by another team for other types of data inputs. But I need sheet2 to automatically populate the IDs from sheet1 as they change. Thoughts?

like

What’s the best resource for excel tips and tricks?

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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