Some of my best Excel tips have come from team chats, friends, and even internet forums.
Who taught you your most valuable Excel trick?

Interesting all the noise about these PPT, my take:

The pandemic took all the upside of an IB analyst life (client meetings in person, fancy trips, suit up, worshiped at networking events) and left all the juniors with the downside (long hours, monkey-like type of job, aggressive work environment).

Not that the complaints are not sort of legitimate but you may need to revise the decision-making process that led you to accept a return offer. Specially if you were looking for less hours.

Hi Fishes anyone here working in ADDA project

Everyone I needed final approvals from to get these expert retention agreements signed off has decided to ignore me on literally the day our disclosures are due.

I have a question regarding taxation of joining bonus.

I recieved a joining bonus of 1 lakh from my previous employer in last fiscal year which was taxed.
I resigned from the organisation before completing 1 year... Which will be deducted from my last month salary.
How does taxation works in this case.

Recent immigrant and about to buy a car - insurance company said it would take 2 weeks to process my application. Is this normal? In the US I insured my car with one 10min phone call, so was a bit surprised

What are the promotion cycle and salary review cycle months?

I want out of the Insurance industry looking to go into tech as a Data Analysis or Project Manager

Seeking input on entry-level salaries for grant writers! Please share with your location if you’re comfortable. TIA!

Hello fishes, can anybody refer me in EY? Currently working on snowflake and Matillion

Hi All,

What is the wlb in Areteans for a pega developer.

Let’s move out of NYC SF together lol . Maybe try LA ?

Ally here. What do I say to someone who refuses to stop confusing gender identity and sexual orientation? The usual examples don't help.

Why is it that a lot of couples I know living in big cities are in open relationship?

I am a proposal manager for federal consulting company. My base is low (112000) but I make up upto 50-70% of my base income with win bonuses. But I get the bonus only after the completion of one year of the base period of the contract. My question is -is this arrangement good or should I negotiate for higher base instead ?

Is it still worth buying Tesla stock? Especially after rising so much since year start?

Anyone have experience with Donut app? And their 4% APY? Had any issues pulling money back out? Whats the risk here?

What is the best platform for cryptocurrency?

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

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?

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

What are your top Excel ninja tricks? Ones that few people know...

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

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

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?

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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..

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

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.

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

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!