I am an Excel genius with years of experience in creating dynamic spreadsheets, automating workflows, and solving complex data challenges. My expertise ensures that businesses can streamline their processes, save time, and make data-driven decisions effectively.

Key Excel Skills and Expertise:

Advanced Formulas: Proficient in VLOOKUP, HLOOKUP, INDEX-MATCH, IF/ELSE, and nested formulas for complex calculations.

Is there any practice better than tax for someone who likes to think/solve hard problems? The practice seems technical in almost a science-y way, and while I’m sure patent law is technical as well, I have yet to come across another practice area with this same emphasis on problem solving.

Still want a recruitment bonus 👀. Lmk if you’re looking to lateral!

Any tips for how to better implement feedback on drafts? My work is so heavily redlined that I struggle to consistently follow through with every comment/feedback. I am in patent prosecution, so it is a lot of detailed technical writing, but is also fairly formulaic, which is nice. Thankfully the partner I work with is extremely patient and a very good teacher, I would just like to be better at learning from his very thorough feedback.

I am RTL design engineer at Qualcomm with YOE 3.5 and this AR cycle I'm expecting promotion as Senior design engineer.
For Bangalore location, What market correction I should expect and what should be the base salary after promotion? What is the general hike?

I am soooo slow right now… nyc. How’s everyone else doing. I’m getting a little nervous about this economy and seeing a lot of layoffs in other bowls 😣

Hi all,

There is guy living near my place and i find him really attractive. And sometimes I come across him in the gym. But I'm not sure if he likes me or not. How to handle this situation?
Any suggestions?

Looking for feedback on employment with Amtrust and/or Plymouth Rock if anyone has experience working for either company in the Casualty Claims department.

Currently certified in AWS (CCP, SAA, and Security) and GCP (Security Engineer and Cloud Architect).

Any recommendations on Azure certs to pursue?

What is the package range for Senior software engineers at Jio experience - 4 years

Hi folks
I've completed my technical and managerial rounds in tcs in Data science and AI
I've 4+ YOE in AI and Data Science
What can be the ctc I can demand for
My current ctc is 11.88 LPA and next month it is going to be revised again in my current org

Does anybody else think that the Wharton Slack & Discord groups are kinda quiet/inactive compared to admit groups from other schools?

Any book recommendations for grieving the death of an estranged parent?

Barber recs in Manhattan that can do a nice fade and scissor cut?

Guys, I need your expert suggestions. All figures are in INR
I am living in Europe with my wife. We both are earning.We save around 4.5 to 5 lakhs every month based on exchange rate. We have SIPs of around 60k. Please help me to invest my savings. Apart from mutual fund SIPs I don't know much.

If you could work at any agency, where would you go?

How hard was it to leave your first shop? (Yes, be honest)

Came up with an idea in an agency brainstorm, even who the influencer should be. Now it’s being executed, but I’m not working on it. Weird if I put it in my book? Maybe as just the one who came up with it?

SPAC bubbles are popping everywhere. Premiums being pulled out here pre deals. Becareful out there. None are safe. I will be selling puts in psth if it opens below 28

We are looking for Search Language Specialists - Manual Software Testing for our Team.

Requirements :
Primary language proficiency (Read/write/Speak) as Native speaker : Marathi & Bengali (Mandate)

Work Location: Bangalore

Work Type : Hybrid

Degree : IT/Technical Degree

SoftSkills : 
Good Communication skills and willingness to work on internationalisation Localization and Translation query.

Good Team Player.

Experience : 3 years

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.

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

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

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

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 🙏

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.

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

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

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 😭

Would anyone be willing to teach me vlookup?

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

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.

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

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

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

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”

Hello all, hope you guys are having an amazing day!
I’m wondering if anyone has a good beginner friendly resource in linking SQL database to a Worksheet. Tips, in-depth tutorials, that good stuff

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.