Looking for recommendations on how I could replace a pdf in one file so that power query can replace the table on excel. And when I replace the pdf, it refreshes with new values.
Any recommended videos or tutorials that can do this? Chat gpt ain't helping

Hi Fishes ,
From tcs I got mail to upload documents 20 days before (10th June)

There was no documents section under my profile in tcs I begin portal. One of HR confirmed that they are creating new EP id for me

Can anyone help me how much time this takes ? Most of the times no HR is replying to my mails and calls not answering

My H1B extension was approved last week! Just want to throw out some positive vibes for everyone who’s still waiting on decision, and good luck!!!

36 F Black NYC Divorced, 1 tween. anyone want to get to know one another better?

Does UBS provide any welcome kit?

What is UBS Associate Director salary in Non IT Pune role with 15 yrs of experience.

Hi Guys,

I have completed my tech interview rounds with UBS and have received email for fitment round.

Can anyone share what happens in this fitment round on interview?
HRs have asked to submit documents even before this fitment round; which seems unusual. Is this normal for UBS and this is how they progress?

Thank you.

Who are your favorite advertising comedy directors? Who are your favorite comedy directors who are women?

Which agency does Jack Daniels TV?

Anyone here who is working on Experian powercurve tool??

Best way to go about getting contract work for new solo/startup? Should I just ask around the area for people doing that type of work and see if they have anything?

Hello! Excited to be part of this group and I need assistance for salary negotiation with Amazon. I am currently in the last round of interview for Sr. Customer Success Manager, Strategic Account Services (3P Marquee Accounts) and Id like to know real world compensations cases before I re-state my range or start the negotiation process with AMZ. Anyone with insight on this roll and pay?

I have 3 weeks to review for FAR. Any tips? How many MCQs a day? Practice TBSs?

Looking to brainstorm ... What's the next wave to ride for the next 3-5 years and how to position yourself?

GDS folks, a colleague of mine has defaulted on timesheets (more than 3) at senior level and was rated as Progressive. Is that the sole factor for not him not being a rated as differentiator?

What motivates you to start or keep up a side gig? Is it just having more income or a specific financial goal?

Would anyone recommend or share a side hustle that would complement a banker’s 8-5 M-F schedule? As of now, I do an hour DoorDash before work and after work I do DoorDash and Instacart for a couple hours. I do this as well on the weekends targeting about $200-300 a week since I am in a really small market. Looking for more creative, cost effective, and efficient ways I can supplement my average salary. TIA!

When your old 100+ person agency has a BLM message on their website but only employed one black person while you worked there.

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

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.

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)

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

Any book recommendations on excel modeling for real world business applications?

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

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?

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”

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Would anyone be willing to teach me vlookup?

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

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?