Merged cells in shared workbooks drive me up the wall—why do people do this to us?!
What’s your biggest Excel pet peeve? Get it off your chest!

Our RIA will be presenting to a group of FAs on COI strategy in a few months. Curious if anyone has had success obtaining referrals from centers of influence?

Hi all, I am looking for Managerial and senior managerial positions in Operations Excellence in Toronto please help to refer me if there is an similar opportunity in your organization.

What should you be shooting for in TC at age 30, without an MBA?

Tmrw will be having discussion with Mastercard HR
yoe :11.6
Tech: java micro service
How much salary they are offering lead software development engineer

Hi All,
I am having 10 years experience in IT-Automation Testing. Being offered Lead Quality Assurance and testing analyst role and grade i .
Is this a lower grade as per experience?

I have significant equity in a property (300k+) and maybe another 200k across other properties. I have a decent amount of money in cash and already 200k or so in stocks. Would you consider pulling money through cash out refi and using it? I get nervous for stocks being so high. I have a few properties in pipeline already. How would you suggest using it (if at all).

How long does it take you to get your L1 after the 12 months? Is it a long processing time wait?

I’ve recently left my job (unhappy with it) and am applying for new work. I have a few irons in the fire at the moment. I’m curious about a trend I am seeing: I like to think I’ve well documented my abilities and functions in my CV, as well as my portfolio. I’ve noticed that for some of these jobs that I can check every single box in the job description, I won’t even get an interview. I’m wondering if many of these jobs are posted for internal hires, but some stay open for weeks. What gives?

Looking for opportunities as a data engineer with 2 years of experience .lwd 28th aug .
@expert in azure and sql
Have been trained in bigdata technology.
Any help would be great!

Hello. I currently work in-house as a Legal Operations Manager. I am working on a project to expand our network of law firms.

Any recommendations of boutique law firms in CA that have experience in commercial litigation for retail/fashion/apparel/home companies? Specifically consumer class action, unfair business practices, false advertising/17200, data privacy.

Thanks for your recommendations.

I am an associate at an AM200 firm and was (IMO) very clear prior to accepting this role that I value work-life balance and wanted to try to keep work at night on the weekends to a minimal, but since February, it seems like it’s always something that requires my time as needed disregarding “business hours” or my personal schedule. Thoughts on whether to bring this up or continue to be a team player until I burn out and pay off my student loans?

Any advice for a couple where one person runs really warm and the other has a cooler body temperature - how do you manage this while sleeping? I feel my body produces a lot of heat. My partner and I love to hold each other at night but post an argument yesterday, he pulled away and told me my body is too hot. I feel I’ll worry about this each time we cuddle now and it will ruin the quality of that experience for me. Would love other perspectives on how to think about this.

Looking for suggestions what the are the critical recruiting metrics Amazonians use or asked during the interview process? Are they anything different from reqs load, screening, interviews, offer hire, time to hire, DEI etc…looking for some great examples.

In cgi what are the shift timings for a tester ,?
#cgi

My monthly salary is around $6.4k after-tax. Living in NYC. Do you think it’s reasonable that I pay:
- about $1.5k on rent
- about $500 on utilities and subscriptions
- about $900 on student loan
- about $2k on food and etc.
My saving goals is around $3k so been trying to adjust my monthly spending.

What is an average pay for a clinical lead medical assistant in Philadelphia area?

POLL: After a long summer of unemployment & rejection letters, you finally get 2 offers. Both have appeal for different reasons. Which would you pick, assuming money wasn’t a factor? Thanks for choosing by liking A or B below. A= a Creative Lead job on an a beautiful tropical island (English speaking, but cultural adventure) where the work/industry was much less developed, or B= a Creative lead job in a new-to-you US city you also liked where the work and teams were much more advanced/skilled?

Any tips for negotiating in-house salary (base + bonus (no equity, unfortunately))? NYC mid-level here.

I have one year subscription of amazon prime available. If anyone is interested I will sell it at 40% off.

Hello all,
Today some one told me that H4 visa holder can now work in USA, just wanted to cross check the information is valid or just a fake news? as I couldn’t find anything on google.

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?

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.

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?

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?

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

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

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

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

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

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

Would anyone be willing to teach me vlookup?

I’m trying to learn more about Excel functionality and there’s several simple functions that I don’t know, this is probably one. If I am color coding data, is there a way to automatically move those lines to the top or bottom of the spreadsheet once the color code for the line is made?

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

Building an invoicing template for a construction comp but won’t be industry specific. I’ll be charging 5 hours at US$80/hr. Anyone want a copy of it for US$40 worth of crypto?

Context:
I spent 2 days last week and tmr fumbling over invoicing activity with the owner using a poorly designed invoicing spreadsheet. Last minute changes to already approved templates impacting >30 invoices is ridiculous. There will be a control sheet, an invoice generating sheet and a summary sheet. Q’s or comments?

My job often has me conducting analyses where we try to identify if product launch A has had an impact on B (cannibalization analyses) but super often they are inconclusive. I feel I need statistics / rudimentary data science here. Any idea what to study?