I find myself using VLOOKUP and SUMIF constantly, but I’m curious what functions you all rely on the most in your work. Any tips or hidden gems I might not be using?

I can’t believe companies pay millions for me to Google for content.

Anyone in Bay Area for the holidays? 29M

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

Which is better for meeting other gay women? Tindr or bumble?

What’s the meaning of life before FIRE and after FIRE?

Gratuity Form L is given to me, by what time can I expect the payment?

Dear Friends, I am looking for an IT Project Manager job. Let me know if you have any opening for this role. Work experience: I have 13years of experience in the IT industry.

Key Skills: Project Management, Customers and stakeholders management, worked on Cloud migration project, worked on new customer transition, Transitioning project to BAU,IT operations

Technical Skills : AWS, Azure, VMware, Windows Server 2012/2016/2019

How it's like to work in Johns Hopkins Hospital ED as RN?

Hi ,
anyone help on the HCL retention bonus ?

They added 2L per year in separate letter,

will 2L added in every year ?

They added condition of need to stay for 24 month .

How HCL retention bonus works ?

@HCL Technologies

Netherlands, Eindhoven salaries for Java devs

What are the best areas to live in w/ easiest commute to south station/seaport area? I’ll be moving alone so looking for a fun area for 25 y/o to meet people and go out. Will also want to have a car (either on street parking or off is fine)

Offtopic:
Any WhatsApp group of stock/option traders?
Am an option seller and looking forward to connect to like minded people.

Anyone volunteering with the upcoming CFE exam this week?

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.

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.

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

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?

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.

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!

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

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

Would anyone be willing to teach me vlookup?

Still don't have xlookup. #fomo

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”

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

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 😭