Learn XLOOKUP & STOP the VLOOKUP madness
https://youtu.be/1JC9axbDBjY

This is the most animated view of XLOOKUP on the planet. If you’re new to the function, it’s very easy to learn. And if you already know it, I think you’ll still enjoy the visual format. If you have any questions or feedback, I’m here! Thanks so much for watching.

What if airbnb gives you a similar suite than the one in the picture but it is still not the same suite? And you tell airbnb but the host says its not accurate and says you are a disrespectful host?

Any golfers here? Relatively new to Austin and starting to get back into regular play. Been playing at Falcon Head, always looking regulars to avoid the constant randoms.

NFT peeps, get a Doodle while you still can. Bought mine for 1.5 ETH last week. Now at 3.9 floor. Other collections that I think have a lot of potential: Lil Baby Ape Club, Cosmic Labs ducks, Party Apes, and Stoner Cats. Cool Cats are pricey. Little Alien Club is super duper cheap but a total Hail Mary gamble.

What are your favorite restaurants/activities that are a quick drive from the city?

Island is open: L4L4L 😮

Bottom half of my island is a hot mess but the upper half is inspired by the attractions at the Golden gate park!

Some extra recipes in front of Nook’s cranny

I will be AFK

Best scotch under $70, not too peaty

I think deep dish pizza is overrated.

Anyone with 2/5 calls on NOK care to share your game plan?

Ok, my favorite singer comes THIS WEEK for an interview ❗❗❗
I'm excited about the opportunity of proving my capabilities, but I also don't want to miss the chance of getting a picture or maybe an autograph.
Is it ok if I ask for it? Or is it too invasive?

Hey folks,

Does anyone wants to join us for a 2:30 PM show today of Sita Ramam (Telugu) in Bollywood multiplex - Kharadi?

Probably the least racy confession on here but I really liked Windows 8 and I'm sad there's nothing like it anymore

What are the best social clubs in the area?

In Vancouver for the week. Any interesting thing or activities you all recommend?

In my prime workout days I could down 3 cheesy Gordita crunches, 1 chicken quesadilla, and a chicken soft taco from Taco Bell ....just tried it 10 years later...would not recommend.

I’ll believe it when I actually have it in my hands, but apparently I successfully ordered a PS5 through their Direct lotto system.

My family and I want to move from Florida to the Seattle area in 5 years. My husband is in Aerospace Engineering. We both love nature, hiking, and rock climbing. We prefer cool rain over sunshine, miss seeing the seasons, and love to cook.
Any advice, Pros VS Cons, anything to look out for ?
Thank you in advance!

Anyone else hear hints of Hayley Kiyoko in I Forgot That You Existed?

Any book recommendations about human psychology / thought processes?

@microsoft folks, any prep advice for a Senior Business Program Manager interview Friday? Especially coming from consulting? Got 3 interviews with people from the team on Friday

Hi Fishes :
I have 2 offers for Automation Engineer:
1- EPAM Anywhere - 21LPA[inc. Bonus] - Totally Remote
2- Jio Infocom - 21 LPA[Fixed] but with lot of provisions in CTC - Will call to office [location : Mumbai]

YOE: 6 Years
Need your suggestions

What are the best data privacy certs to aim for? 4 year exp in cyber risk consulting. Want to move to a privacy related role outside the big 4. Should I go for the CDPSE or CIPP or CIPM?

Not law quite law related but I could use some input: anyone have any luck negotiating lease pricing with a corporate landlord? I originally signed and got covid pricing and now they want to hit me with a 17% increase bc of inflation 🙃

State of Ohio:
Anyone have experience with Dept of Public Safety? Are they disorganized? Do they have a bad culture? I am starting to think they suck based on my application experience with them , compared to other state agencies.

How's the SAP SuccessFactors practice in Accenture . How's the job security ?
The projects ? And work environment ?

Any firms cut salaries, bonuses, or staff lately? I feel like it’s coming..

PWC India or Capgemini?

Looking for a solid receiver to run outdoor speakers, one that has bluetooth and alexa capabilities. Was using zone 2 on main Home theater but it doesnt push out enough power.

Hi Fishes,

Is Deloitte India mandatorily asking 2 days hybrid work from office? or it's complete work from home??

What designation i can expect iat Capgemini of joining as a Lateral?

I have total 11.5 YoE

Is 36 too late to join IB as an associate? Alternatively, can stay in my industry (not banking) as manager.

Any openings for cloudera databricks ?

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

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?

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

How long did it take you to become good at excel? Like fast?

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

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

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

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

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?

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

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

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.

I’m trying to learn more about Excel functionality and there’s several simple functions that I don’t know, this is probably one. If I am color coding data, is there a way to automatically move those lines to the top or bottom of the spreadsheet once the color code for the line is made?

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?

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.