One of my dashboards is full of long, nested formulas, and troubleshooting them is becoming a nightmare. I’ve started breaking them into helper columns, but it’s still hard to maintain.
What’s your strategy for managing and simplifying overly complex formulas in Excel?

Hello everyone trust your weekend is going on well.
I'm not completely certain how this platform works but it appears I could use some likes on my profile to unlock its full usage.

Looking to exit UTHEALTH SA for other opportunities. Healthcare is great but pay/retirement is womp-womp. How is comp and benefits at your company? Can someone who has been in academic medicine as a Clinical Reporting Analyst transition to other industries? Thoughts fishies.

What is designation at Senior 1 level ??

I used to have a fitbit. Really liked a lot of its features. Like the reminder to move and the competition within the app (games and competitionvs friends). However, whenever I was at work I'd find myself taking it off for more comfortable typing and then forgetting it during the day. Now that I'm back at work I'm sitting more and need to move. I was thinking of getting an oura ring. Does anyone have one? Any thoughts as to which is better?

Hi Anyone worked in DQAM team at Credit Suisse India, wanted to how is the work in terms of learning, careeer progression etc.

TIA

Hey folks! Any idea how much an associate makes at Deloitte UK? (Isle of Man)! Any leads would be appreciated.

Hi fishes,
I am currently working as an UAT tester (both manual & automation) with overall experience of approx 3years. I want to switch to a business analyst role.
Is it possible to get a job for a business analyst position without MBA?
I am willing to learn the necessary skills required too but cannot afford MBA

Please suggest..

What is the eligibility or time period needed to move from 6B to 7A in IBM? I have 4.7 years of experience and joined IBM recently in JL 6B.

Thanks in advance.

"Stock Market Today: Dow Starts Week on Strong Footing as Energy, Tech Gain"

Best GMAT prep books/ material ?

Welcome to the HR Equity and Inclusion Bowl, let’s come together to discuss ways we can change organization culture, so that all staff feel a sense of belonging.

Anyone know any consultants who specialize in re negotiating insurance contracts? I’m tasked with finding someone for our fertility practice.

What would be a reasonable cost of renting for a single expat dude in Singapore living in decent area ? Would sgd 4K suffice ?

Moving To Dallas this summer and will likely be looking to live/buy in suburbs. Any recommendations where to look?! Want to be central to everything and access to nature, in 300-400k range

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

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

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

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Still don't have xlookup. #fomo

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

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.

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

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.

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

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?

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.

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?

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?