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?

Writing a report for the first time and feel way in over my head. Team didn’t discuss what adjustments we want as a group before divvying up—new transfers what has been your experience?

Might be the wrong bowl but finding it extremely difficult to focus on work post busy season. It’s been 2 weeks since we filed and I’m still taking lots of naps and breaks (I’m talking like 3-4 cumulative hrs worked during the day). Idk if I’m taking longer to recover from busy season bc I’m getting old or if I’m over public accounting (but then where do i go). Tried to schedule time with a therapist but everyone has a months-long waitlist so next step might be trying to find a life/career coach

So fed up with my practice and not looking to stick around for typical below-market compensation in October.

Which big 4 firms or MM have the best FDD comp. so far? Excl. A&M (I know their comp., over half our practice has quit to go there lol)

Whether we need to give back joining bonus if we resign before 1 year but last working day is after 1 year or so?

Hi all
I have a kind favor to ask of you, my dad who has 25+ years experience in finance is looking for better opportunities in UAE , requesting your help to kindly assist if you or anyone in your circle are aware of any opportunity. If there is anything please let me know and I will DM you .
Appreciate your help and su

When did this bowl become so competitive and spiteful? Why can’t we just be happy and support each other?

Question: do y’all really love this stuff and understand it? Or are you all on the “fake it til you make it” wave? I ask because I’m in a specialty group under the Corporate umbrella and many of the partners and some senior associates are extremely smart and clearly enjoy this stuff. Some even do “night time reading” to catch up on the recent laws. I, on the other hand, cannot wrap my head around it most of the time and would rather not waste energy doing it. Is it just me? What do i do? Quit?

What is an NFT?

It’s pretty boring. What’s the fun thing we can do in Bangalore for this weekend

I’m one of the top performers in the company and got invited to the company’s emerging leadership program. I always meet all my goals and deliverables on time but still feel like half of the time I’m not even doing anything (or performing my best). How do I leverage this ‘off-time’ into something productive in order to progress faster?

I have cleared 1st round of technical interview in Mphasis and was told next round will be managerial round any idea what kind of questions can be expected

Hi Fishes,

I will we interviewing with Salesforce for the position for Customer Intelligence Analyst position. Could anyone please guide me with the interview process and difficulty level.

Is there a Gym facility in DTTI office in mumbai?

I have gotten a verbal offer from Facebook, but I just had my phone screen interview with the hiring manager at Amazon yesterday. I want to reach out to the recruiter at Amazon and let them know what the timeline looks like. I would much rather have the Amazon job over the Facebook one. But I’m afraid if I decline Facebook then Amazon won’t happen. I’m just completely lost.

Any open position in Workday Talent Acquusition?

Hi All, I am currently a Data Analyst with 1 year of experience and pursuing a masters in Computer Science (expected to graduate 5/2023). I am looking to transition into an entry Data Scientist role (preferably remote or Philadelphia, PA). Can someone refer me or let me know who is hiring?

I can provide my resume if needed.

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

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?

Would anyone be willing to teach me vlookup?

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?

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?

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

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!

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

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

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

Hi there,
Which Excel courses you recommend for a beginner?

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

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.

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

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

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?

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 😭