My man you just saved me hours of my life

Where can I get the file that is actually used? So I can follow along

📌 DETAILED INSTRUCTIONS can be found on our website at www.excelcampus.com/pool

Simple and effective solution! Thanks for sharing this👍🏻

This is what I was looking for. Thank u!!

Awesome

Thank you for sharing this

This is awsome

Thank you

EXCEL 365 DOEST HAVE THAT ABILITY

My favorite feature was the zoom to fit selection. Thank you!

great video! still no way to save the default them as old one?

This was so helpful- thank you!

Thank you so much, this certainly a simple and effective Video.. :) God Bless. :)

Love the automation of the tasks at the end with macros. Gonna try it. Thanks

I've a excel data sheet with others sheets name and that specific sheet all data table name (all sheet have different type of tabale data with different row and column size. I want to create a hyperlink on each sheets name. Could it possible?

Thank you for this. Is there anyway you could use “yes or No” instead of the checkboxes?

Quick, clear and direct to the point. Thanks

The fact that Microsoft effectively disabled the CTRL+O Keyboard shortcut to open files starting in Office 2013, when literally EVERY OTHER APPLICATION ON THE PLANET USES IT, is almost as dumb as disabling Dark Mode in Power BI Desktop back in 2018 or so. They just added that back in the last update. I know about the Save setting in Options which reenables this, but it's stupid to have that as the default. If I want to go to the Backstage > Open, I'll bloody go there on my own. Good video, Sir.

TRIM() or :. :)

Nice presentation. Not too fast and not too slow. Also, clear speech having clarity. Easy to follow. ( I mean not like other training videos ). Thanks!

Waffle chart

Hard to put working excel file, here?

Thanks a million! I'm working on my Value Chain Forecasting hw and you are great help!

thanks!

3 minutes later he still hadn't shown me how to "Add New Items to Excel Drop-down Lists"

Wish I could get this to work. You went through it so fast, and I couldn't make out all the characters at the end of the formula.

Very cool! More such creative ideas!

Smooth!

Brilliant. Thank you!

Well explained

You are the best. Saved a ton of my energy and time ♥️

Extremely helpful!! Although I became stuck with my formula not auto updating but I fixed it.

Really like the video, was trying to make something for myself, but the xmatch is not working with the check boxes. Then i went to your workbook. (its the same on all sheets) -- Sheet "Show Details" if in cell say K3 i type in the formula =XMATCH(TRUE,tblOrders[Details],0) just to see if it will get the row number - but it says N/A the whole time. Doesn't matter if i pick box 1,2,3,4.... check boxes. NOW if I i copy the formula from the XRow function inside the LET() function and put that in cel K4, it works just fine. I can pick any check box, and i get the Row (index) number of the box selected. If I pick say box #5 i get N/A in K3, and 5 in K4. If i edit the formula in K3 and press return i get a 5, but now it remains 5 even if i unselect the box and pick another one. ANY IDEAS?

How to exclude zeros from pivot values of average of columns

Thank you so much!!! You saved me a lot of time. Thank you, thank you, thank you.

Not Working for me in Excel 2021

So MaC users can't use some of the shortcuts

I need some help in formatting the bidirectional data bars in the newly updated Excel. I can't find the minimum and maximum values in the manage rules section. Does anyone have an idea how to do it? Thanks in advance.

I don't have the checkbox there, there's no 'controls' tab

Any chance for an updated version of this that shows current Microsoft 365 version?

Hey Jon, the Regex features look amazing. Definitely going to check them out first. Though I'm going to save this video as a "go to". Full of fun/good stuff.....many, many thanks.

You do it so fast

8 years and still very helpful, thanks

this is genius, thanks

Thanks

Very useful! 😮

Thank you so much!!! It worked for me!!!

Great vid!!

💡😳💡