Why is Power Query so terrible at converting an image (of a table of numbers)!?

Even high resolution images don't seem to make much difference. Decimal points are missed, the thousand comma separators are often confused for text. Rows and columns are just randomly misaligned. 😩

Is there any website to get a template for decent/basic contracts (i.e. leases, purchase agreements, partnership agreements)? I want a base to start, without having to sign up for a free trial and then get hit with a bill when I forget to cancel...

Any openings in wellsfargo for data engineer or bigdata engineer??

At what point does it make sense to buy a home? I have ~700k in the stock market and a lower than average salary currently (80k) and pay 1800 a month in rent.

2nd year assoc. here. Finding myself spending 3-5 hours researching/analyzing issues that should only take 1-3 hours. I find myself questioning - for every assignment - is this the issue I was asked to look into? Did I read that case right? Does this analysis make sense? And I end up reading the same cases over and over. Does anyone have advice for being more confident/efficient on tasks, especially research?

Anyone know of a good exchange that will let you withdraw in Canada? Canadian withdrawals are blocked on Coinbase....

Annual review coming up. Looking for suggestions for asks…

8 YOE, Current 125 base, TC ~140.

Median base for my title/geo ~170 (mean ~166, 0.75 ~226).

Certs: CIPM, M365 Security Admin/Architect, AWS SOA, AN, & Security.

Vet, Inactive TS.

Highlights of the year: flew out on 12hr notice to evac E Europe-based employees & families, plugged 3 exposures before they became breaches, built TVM/privacy program from scratch, onboarded new CNAPP.

(-) Still a student (GIB: BA/MS expected ‘24)

Someone please tell me salary range for a Sr. Associate. How much I can negotiate with hr?

New to Toronto, moved to the west end of town/ just past - in Etobicoke. I celebrate my 40th a few days after NYE/NYD - would love some recommendations on moderately priced but nice ambiance restaurants for myself + husband, and my extended family. Everyone is scattered throughout (Hamilton, Barrie, Lyle, Newmarket, North York). Don’t want anything too fancy but don’t really know where or what is good and not downtown.


Any recommendations? (Open to GTA of course).

Is there a clause in IBM if one separates before completing year.
Offer letter mentioned recovery of joining bonus if separation before 1 year. If i resign now ,my lwd is beyond 1year since I joined 10 months back. Which date will be considered here? Day of separation filing or actual lwd .
Also Can one can revoke separation at a later stage?

What does a 30% travel requirement mean in a job description? How often do they expect the candidate to travel ?

Sitting here in office and wondering , What can be plural of a computer mouse !

Hi
I will be working hybrid at cisco Bengaluru soon. Thus need some help, like what localities/areas i should visit while pg hunting.
I prefer single sharing, if aware about current rent. Please do tell. Thanks in advance @cisco

Fti 🐠, what is the salary band for a senior director in forensic and litigation consulting?

I have an interview with Korn Ferry for an associate principal role and am curious about others’ experiences have been with work-life balance here. Also, I have an idea of what I should be compensated in this type of role, but any insights on how they pay compared to others would be helpful. Are you traveling during the pandemic or have client interactions been virtual? Lastly, if you are a consultant here, are you on billable hours? My current consulting role is not - so this would be new.

Looking for 2bhk/3bhk near marathahalli or Brooke field and a flatmate(preferably Telugu)as we are 3 pre decided and rent range is 20000-30000

😭 👶🏿 🌈 🐻. 🚀 🌚

Has anyone started/considered starting an individual/small business income tax preparation side gig? What were the challenges juggling w/ a Full Time job and getting clients?

I’m getting messages from recruiters for Sr. Corporate Paralegal roles but all of my experience is in litigation. I have 6 years experience as a paralegal. Should I move forward with this? Not sure if I’m qualified.

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?

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

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

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

Still don't have xlookup. #fomo

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

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?

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

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.

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

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.

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

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

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.

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 can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.