Very good, congratulations!

I would use the conditional formatting along with the regex functions to validate data that I might enter or import from an external source.

Any video on patterns

This one’s pretty powerful, it’s a hot key for a feature called “flash fill” - you can also select it with the mouse by going to the data tab in the top ribbon. You have to type some examples immediately to the right of what you want to have broken out in separate cells, then use flash fill. It can help if you want to add/remove characters in the source data.

I'm looking for how to do this using a date in a different cell as the start date. That date may or may not be the first day of a month.

it would be great it you would add videos with questions and then solving them

I use this too :)

Oh my goodness. Power query was the best for me. Thank you so much. On another note, every August we have a huge business meeting (approximately 800 in attendance) that I have to download all the data from the online registration and create name tags (among other things). I usually download all the info into a csv, then create a 'label' in Word, add the fields, .. you get where I'm going. Is there a quicker easier way? Any help would be appreciated. Thank you.

Brilliant

This was very efficient and easy to understand, Thanks for the effort. It was very helpful.

I need calculate due dates based on the last report date entered in a cell. 1. One year ahead, one month back, and that last day of the month. 2. Two months ahead and one day back.

This helped me ZERO!

Thanks, great video and explanation.

Only video that I’ve seen that gave a solution for me on this!

Neither of these are working for me.

Crtl Shift End, the range goes right row with me, doesn't go down column? what is wrong?

10:20

Hi Jon, This was an excellent method to explain a very complicated topic. I was not even aware that we could calculate Running Totals in Excel Tables 😉 Thanks for all your efforts.👍 I was wondering why the Table Names were not appearing in the formulas. Then I enabled them using the below options: File > Options > Formulas > Use table names in formulas (This is something new I learnt today🙂) I am not sure when and why I had un-checked this option. I just wanted to confirm if this option of "Use table names in formulas" is enabled by default in MS-Excel? Regards, Deepak.

Thanks, great clip, as always. One suggestion though, to paste the Symbol/emoji, instead of going thru the "Format Data Series - Clipboard", you may choose to simply use the shortcut key "Ctrl+V"

Drop-down lists seemed difficult to me. I can't believe how easy it is. Thank you very much🙏

Worked Great, thank you SO much.

Thanks for the video Jon. I have been using conditional formatting for many years but have always had problem with the 'applies to' on Rules Manager changing when I move, add, or delete records within the sheet. I have a monthly running spreadsheet with conditional formatting applied to several different fields, but as I move, add, or delete records the conditional formatting breaks on the 'Applies to' in Rules Manager. Is there any way to always apply the conditional formatting to the complete field when move, add, or delete a record?

great sir knowledge provider

I still don't understand why you don't work in tables

Very late to the party here but this was really helpful... Thank you 😀

Thank you very much

Very interesting to be able to describe situations in this way. Everything will be much more understandable. Thanks for the tutorial, Jon.

Any update on increasing the font size (usability) of a dropdown list? I increase the zoom on my spreadsheet to 300% and still can't hardly use the tiny dropdown data. I'm in the field with a tablet trying to tap tiny numbers with a fingertip.

Thanks for the information, really useful. Paul

❤❤❤Great

Thanks❤❤❤❤❤❤

❤❤❤Amazing

Greetings for u from Iraq

thank you

Shift F10💯

Is there a way to format the charts so that it automatically displays the check, x, or - based on the underlying value? If not, I don't see the point of doing the whole chart thing, and you could just manually lay out the 5 shapes/ pictures you want and just type the category names under them.

Impatiently awaiting availability of these and several other of the new functions. Any idea of anticipated release date? I'm not any kind of insider so it's all black box to me :::sigh::::

This was an excellent presentation. Very easy to understand.

what's the name of the intro video sir?

Great video thanks Jon!

I am totally using this in my hours / client billing dashboard. I should have thought about this option. I feel a bill hours range assessment attached to such a great chart option. For the formatting… would I need to first set the chart manually to all options (good bad middle) and then layer in the automated calculations for 1,2,3,etc? Another way…In order for the dynamic feature, it first needs to be set up for what each means?

Excellent sir

I am sorry if i missed it but where is the a chart? What I saw is to learn how design a diagram that is not linked to the source of data.

Hi John If I want to see the list of each sales person how do I do that not just to see the list of sales persons

Very easily explained.

I'm so glad I found your page. My Excel just changed on 06/01/24....so a full 6 months after the change. I was able to revert back to the old style using your tips....thank you so much. I may change one day....gradually....just not now.

Thanks for the video. It was very helpful.

Thanks. I want to create a multi product sales chart YTD for each location with Sales# and sales $. I used clustered column chart type for unit sold and unit price for Product A,B,C. All 4 locations sold product A, 2nd location sold product B, 3rd location sold product C. In the clustered chart, there is a Gap between two products in location C. How do I fix that Gap?

I extract information from a bank description that includes the deposit date from the deposit ticket, the store#, and the bag# the deposit is in. I use Mid/Find right now, but I think this will be easier and it won't matter how many characters are in the cell. Thank you!!

Gave up three times because I was sleepy but keep coming back thank you Jon u the real g