Ok…. I’ll admit it: I once spent 30 minutes hunting for a #DIV/0! error… only to realize I forgot to drag down the formula.
Excel keeps you humble.

Anyone else have a classic spreadsheet slip-up

I’ve been working for my State Farm agency as a team member for 2 years. I am licensed in property and casualty as well as life and health, but only make $13 an hour. I technically can make bonuses but I’m not supposed to dig into a sale and I have to send it to a sales rep (I am service and retention mostly). My boss also has me running a retired agents office until a new one is chosen (its an hour away with no pay increase or mileage pay). Also, no benefits! Should I start job searching?

just got a full time graphic design job. is there any reason why using the work-provided adobe creative cloud account for personal use is a bad idea? like privacy or something? i’m thinking of canceling my personal subscription and saving some money.

Hi! I am seeking for an advise, anything helps! I applied to Accenture’s entry level analyst program. I applied a few days ago (I know it’s a bit late, but the application is still open thankfully). Yesterday, I joined a resume workshop w/ an Accenture recruiter. She went through my resume and said that I have a strong one! I’ve also set up a coffee chat w/ her next week. Unfortunately, I got an email today from the system, they decided not to move forward :( Should I reach out to her abt this?

What does Hinshaw start at in its Florida offices? Or any info on its reputation generally?

For those of you who had miscarriages after IVF, was there an underlying cause? Did you do genetic testing of your embryos? Did you do frozen or fresh transfer? Are there any ways to minimise chances of miscarriage during ivf?

#Heardle #14

🔊🟩⬜️⬜️⬜️⬜️⬜️

Hello,I’ve 11 years of experience in hardware verification. I know SV, UVM. How can I change my career field to AIML? Please guide

My firm’s IT (especially system saving and file locating function) is so bad 😐😞 and they keep doing updates no one asked them for just to mess with the stuff we already got a hang of without doing anything about the issues we actually need fixed. Anyone else in a similar boat? Do you bill the client for the time it takes to fix the IT issue (or IT inefficiency generally, like time taken to find a file in a convoluted system)? Or is that supposed to be our non-billable time?

Advice and/or consolation anyone? My wife and I (both above average health 30year olds) were trying for 11 months before getting pregnant and then had a week 5 early miscarriage a few months back. If the stress and surprise of just how difficult it apparently is to get pregnant wasn’t enough, the miscarriage put us over. We got back to it and have been trying for the last 2 months again, still no luck. We’re freaking out… all we want is a family. Any similar stories? Advice? 😢

I don’t know about you, but this year, I want to get better at having a work/life balance. I love having the time in the summer to do things around the house, but struggle when the school year starts. If you have any tips, suggestions, or systems that have worked for you when it comes to planning, etc. I would love to hear your thoughts.

Unfortunately was dragged into an audit despite the fact I don’t work in audit. Why does audit RM say yeah your hours will be 50 hours/week when you’ll have to work way more to do the audit. Seems very dumb - if you have work do it, if not don’t work…

If you leave J2 and get another (new) J2, does the first J2 show up on new J2 background check? Assuming these are w2 roles. If so, how do you explain that? 🧐

Are you a member of a club or do you just play casually?

What is the maximum percentage of joining bonus Accenture offers?

One of the company asked if i could join as early as in 1.5/2 months where I have 3 months NP and haven't put papers yet .. i asked one of my senior in my team about this who's already resigning...and she has told about this to the entire team 😶. I realise it's my mistake asking her :p
Now that I'm not hearing back from the company which I gave interview and my environment at current project is a mess atm...Should I just put papers or bear with it till I fine another one..??

Agency recruiters, how would you rate today’s market for creatives? Is it more of a freelancers’ market or is it tight for everyone at the moment?

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 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)?

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

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

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)

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

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 look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

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?

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

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

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?

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.

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.

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

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

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.