Just created my first macro! Super proud of myself! #humblebrag

Welcome everyone! Let’s get to know each other 😊 what city do you practice in? And what’s your favorite thing about estate planning?

After 1 month of BGV doc submission I have not received any communication. HR says to check after some time.
What to do? Is this usual?
Do I get any confirmation on completion of BGV?

I got a offer from HCL as a Process Lead , Can someone let me know what would be my Key responsibility Areas and Profile.

Area- Applications

Ok! What would be the manager promotion increase and bonus this year for a National firm in the northeast region?? Any guesses?!

Lawyers who began full-time work during or shortly before the pandemic...how connected do you feel to your workplace? Have you found mentors? What would you like to see change or improve as we move forward in hybrid and/or fully remote environments?

What should i go for TCS 9.5Lpa or Rategain 11.5 lpa

How much have you heard of Paid Social Planners/Markets making at companies in the tech space? I'm thinking about leaving my media agency company.

How long did you date your SO before moving in with them?

Does Deloitte India give goodies and joining kit ? Though people are posting with pics in linkedin. I have joined Deloitte. But I got only laptop and bag. 🥱🥱

What is a good salary for a director in NY?

Hi all, I have been practicing for 5 years (admitted in NY & NJ) and recently went in house. I just started a side business of writing blog posts for firms or solo practitioners. DM for more info!

Just had year end discussion. Not at all happy with how it went

Is there anyone from pega profile un IBM? Want to know about work env, work pressure as well as work life balance. Please need some suggestion. Good to join or not

Hello Fishes,

I would like to know the appraisal cycle in UST, If I join by December, when will be the next cycle(april to april or dec to dec)?

I think I need Ex bankers as friend and accountants. I need people who we can discuss deals in the swift world with from time to time. I need people with great ideas in my life

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

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.

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”

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?

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?

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

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.

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?

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

Any weekend or online excel course recommendations?

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?

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.

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

How do I create a formula that creates a “cutoff”? For example, let’s say I have 1000 hours. I have a list of activities in a tab that take up 15,20,50 hours etc. I want to highlight the cutoff as soon as that 1000 hour limit is reached.

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

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

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

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