Sometimes I’ll double-check a spreadsheet that looks fine, only to realize there’s a hidden error buried in a formula or a reference to the wrong tab. It makes me wonder how often things slip through unnoticed.

How do you catch errors in Excel before they snowball into bigger problems?

Anyone looking for an AAE or Asst Media Planner? Have a friend w a Cornell degree looking to change careers and join our crazy industry

Does anyone have any side gigs or know of any gig types for project managers? Projects themselves need too much attention to manage on the side of our already busy days.

What’s your hourly rate for web development and where are you located? If you’re able to share, I’d really appreciate it. My agency is trying to figure out how to strike a balance in quoting website projects. We’re based in New Orleans and are not looking to gather comp set data. We just need some validation.

will cognizant blacklist me if i didn't join. my joining date in cognizant is 24th april and thinking of emailing my decision today.

If i accept offer letter and then reject the offer of BNY Mellon, will they blacklist me so that I won't be able to interview there again?

7.1 rating at persistent . How much salary can I expect??

Has anyone ever left someone because they don’t want to live a healthy lifestyle? My SO is so unhealthy but doesn’t want to do anything or believes they can’t

Course marshall has to be one of the top part-time retirement jobs

Does dxc give permanent wfh option for any specific projects?

I moved from being customer service at a call center to doing it remotely from home, and it's such a game changer. I just sit around in my pajamas, relaxed. Has anyone else switched to 100% remote work?

I'm going to office on Jul 20 and 21st. I'm trying to book a seat for me in magnet but its not showing any results for Hyderabad tower 1. Anyone can guide me please

Science and art are completely intertwined as I see it; color theory, composition, and balance all coming together to create a cohesive whole. Thoughts?

Anyone find a good CC in another practice? How?

Any insights on compensation for a Sr. Analyst in the security practice?

How do you know if your agency is OK with being mediocre?

Hello Friends I am looking for an opportunity in the field of Environmental Regulatory Compliance and Sustainability. Please help.

Paul Fredrick has some great summer colors for men dress shirts. Any way to grab them cheaper? Also, any other decent shirts with great “summery” colors? (Shades of orange/blue/pinks). 🙏 thanks

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

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

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!

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?

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

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.

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

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?

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

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!

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

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?

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

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