We’re nearing 200k fishes in this bowl, yet I only see a couple of real excel questions per week. What’s up with that?! Where y’all at with those questions? Give us excel geniuses a chance to prove ourselves!

Does anyone else work at an office where the receptionist is a gate keeper, trying to keep tabs on everyone that passes location and timing and reason?

I’m starting to slowly get into product marketing at my job, eventually fully transition in product marketing. I’d love to get some advice on how to best work with a product team and build a relationship. Seems like our product is never quite ready (new features, updates, etc)

Have you ever been racially discriminated against in a personal healthcare situation/not at work? While you were ill or in the hospital? Obviously horrible when it happens to anyone but it takes the cake for me when white people in healthcare discriminate about Black people when they don't know they work in the same field and know how they should be treated.

I am feeling naughty since morning! Anyone sharing the feeling?

Can anyone tell me where I can declare a home loan in the Payroll portal?

I am a little confused...

Do you allow the community to discuss your direct competitors?

Salary credit timings? Icici bank

Anyone familiar with Covid Supplemental Paid Sick Leave in CA? Does having planned time off nullify a full time employee’s ability to use the C19 sick leave if they become sick just prior to the planned time off? (I’ve only been able to find references to eligibility being based off of hours work preceding C19 sick leave - nothing about planned time off)

Is it Bad to change the Sector from 'IT' and move into 'Investment Banking sector'?
Work Profile - Project Management Office
Some people say once you move out from the IT sector, there is no chance of getting back to IT.
Is this really true?

Please guide me.
Will it be good to accept the offer?

I'm working with an IT MNC in PMO profile and got an offer for the same profile but with the Investment Bank.

YoE- 3.
Current CTC- 9.5lakh (Pune)
Offered CTC- 16lakh (Mumbai)

Hi, we are currently updating our Apprenticeship Policy and I wanted to understand what other organisations offer in regards to:
1. Rewards for exam passes
2. Holiday allowance during study

Any detail would be greatly appreciated. Thank you.

Has anyone taken the CDFA exam? Is it difficult? How much time did you devote to studying in order to pass?

ZS 🐠 - can you receive sponsorship for MBA prior to having tenure of 3 years? If not, what is the downside of applying after 1 or 2 years? I am coming in with 3+ YOE in consulting, so my application would be competitive for next fall (or ‘23)

Does anyone know of a public defender making the transition to private practice? Either civil or crim? If so I’d greatly appreciate hearing about the process and transition. 3rd year PD in Brooklyn looking to switch.

the more I want something, the harder it is to achieve. anyone has this feeling also?

I am inquiring about a patient account coordinators salary. It seems I am asking way above average salary due to current position and experience I bring as well as education. Can someone give a number for this position and suggestions for negotiating pay to make what I’m worth.

Looking for push gift suggestions.

Hey everyone. I found out we are expecting our first child and I’m really nervous. I got into consulting one year ago and I’m up for promotion this year. With timing of our performance conversations I would have to inform I’m pregnant before outcomes - then shortly after the promotion effective date I would go on a leave for due date. I’ve worked really hard and I’m worried our wonderful news will throw chances with this :(- also if I don’t get promoted pretty sure it’s up or out. Any advice?

Anybody work in-house in adult entertainment? Not interested professionally, but genuinely curious what that work experience is like, or how you transition between roles and companies.

Database for M&A precedents? Trying to look for a share purchase agreement from a 2021 acquisition. Didn’t find it on EDGAR. Is there anyway to make sure the document is not publicly available? How can I get access to this agreement?

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.

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

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

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

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?

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 best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

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

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

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?

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

How long did it take you to become good at excel? Like fast?

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

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?

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?

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!

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100