XLOOKUP v/s VLOOKUP

Any agile coaches here ?

I recently became an Anaplan Certified Level 1 Model Builder and have been applying to a lot of roles. Does anyone have any recommendation on companies to apply to and a range that is suitable with that certification? So far I have applied to the the big four consulting firms and Fintech companies.

Any help would be greatly appreciated!

Can anyone suggest if I can make a rental contract with my parents on a 1rupee stamp duty letter for below 1 lakh? If so, can I directly submit that to income tax department while filing the return for claiming refund or should I be disclosing in Deloitte Portal for last FY 2022. Also, I assume 11 months contract doesn't require to be registered with the govt? Please correct me if this is incorrect. Appreciate your suggestions on the above for tax benefit purpose..!!

Hi Fishes,
I have offers from below org. with almost same CTC-
Birlasoft
Atos
Wipro

Tech stack- ETL developer
Exp- 7 years
Immediate joiner

Kindly suggest which one is better?

I have got excellence review as "Highly Valuable".
What percent of hike i can expect with this review.

Fiancé’s milestone birthday coming up. We both love experiences and enjoy the city. Welcome all the help to make it special for her!

Hi fishes. I am a fresher and have been recruited as an associate consultant into tech consulting via campus interview. I join in a few months and my package is 7lpa fixed plus 80k variable. I plan to stick with EY for at least 2-3 years barring exceptional circumstances. How can I expect my salary to progress over this duration? Thanks!

I’m trying to get a job as a pharmacist at bcbs. Anyone ever worked there or have experience there? Any tips on how I could make my resume stand out for them?

Hi fishes, any openings for SAP consultant in American Express in India

Who’s getting a bivalent?

When do we get laptop from ibm? Before joining or post joining?

Hi Everyone, our organization is looking to add an experienced account leader to our team. Through the vehicle of a digital marketing & analytics agency, our mission is twofold and ordered: 1) to empower our team to achieve their dreams and to best help others; 2) to honestly partner with our clients, and with their best interests, build scalable solutions that provide profitable growth.

Hi Fishes,
What should be the salary for Manager / Sr Manager having 14+ yoe in project/product service operations? I am at 32 lpa which I think is quite low having worked with top consulting firms for close to 12 years.

Currently I work for a small company that does the construction of small cell utility poles and roof top sites for the major cell carriers like VZW, T-mobile, AT&T and so on. I am a project coordinator but I do everything under the sun. Created project tracker. Submitti bids, sourcing material, negotiating price on materials, handling post construction inspections, scheduling sub contractors, notifying stakeholders, coordinating with construction managers - property owners - building management.

Is the best way to learn provision for someone who only does compliance one of those big 4 guides? Do they get updated each year? Any other sources you recommend?

Dm me if you have below skills

7+ years of Big Data experience and overall 9+ years of IT Experience. Fluent in big data engineering development using the Hadoop/Spark ecosystem
Hands-on project experience with Cloudera Data Platform
Design the data ingestion and integration into the Data Lake using the Hadoop ecosystem tools such as Sqoop, PySpark, Impala, Hive, Oozie, Airflow etc
Candidates should be fluent in the Python language
Leading the Data ingestion and integration flows in Hive, Spark

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.

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

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.

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”

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

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!

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.

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

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?

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

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

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.

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)

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

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.

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.

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