Excellent video - you very clearly explained exactly what I needed to know. THANK YOU!

Helpful!

Thanks for sharing

Nice, thanks!

Thanks for sharing. Very cool

Helpful

thanks for the helpful tip to show us all the formulas, sometimes i forget whats going on in my spreadsheet

Great, thanks! Do you know hoe to remove the by default expand and collapse uttons on the pivod table, also in google sheets please, I can't find a solution 😢

Super helpful, thank you!

For these figures are you using net income or gross?

How can I calculate the Average of a different ranges based on a criteria such as ">0" as per this equation (didn't work) AVERAGEIF(B199:B204,C193:C198,">0") There are 2 ranges here: B199:B204 & C193:C198 The criteria is: >0

Thanks, it was what I needed but....after dragging my columns, I refreshed the data and it reverted back to original column sorting. Any way to lock the sorted columns into place so a refresh does not change them?

Thanks

Excel is just designed to frustrate and annoy. It's hit and miss whether my columns will move. I'm convinced that Bill Gates made a pact with the devil, and MS office is the result.

How would I do Average for multiple colors as the same time? for Red and Blue as an example

Nice tutorial! I tried without setting the columns to move manually in the sort and it didn't work for me. However, after setting that option it worked like a charm.

Going to save this video for my whole life.

Can you set up conditional formatting to strikethrough an entire row once a cell is filled? For instance, can I use conditional formatting to strikethrough the entire row once a date is placed in a specified cell? This video is helpful when your cells already contain data

Would be good to see a version that's dynamic and changes size with the loan terms.

Can you do the reverse?

Awesome thank you

Very cool video

I did not get green line which showed in the tutorial..i tried it many times

Thanks for this helpful excel video

Great excel video

Helpful excel video

thank you for this helpful video showing me how to find something in my spreadsheet data

thank you for this helpful grouping in excel video

This is awesome, thanks for sharing. I've been looking for something list this.

THANKS FOR THIS HELPFUL EXCEL VIDEO

Thanks!!

Thanks!

Thanks! Helpful to find the week number

thanks for this!

I was wondering how to strike through text

this is good stuff to add up a column quickly

Thanks for this helpful excel #short

Thanks for this #short

Thanks!

thanks for the helpful video. I never knew about that ALT tip to sum data in excel

Hi, do you know on how to hide columns through dropdown list value .. when the user input value in the dropdown list. Then, certain columns will be hide

helpful video about weeknum

helpful video!

Thanks for the helpful tip to find monthly payment. If only my interest rate wasn’t so high 🫠

This is a great, easy to following tutorial! Thank you for your help and teachings!

thanks for this helpful video

Thanks for the helpful PMT video.

Helpful, why are home prices and interest rates so high 😞

How do I find out the week of the month? We get paid weekly on Friday, and I budget by the week in the month. Thanks.

Good to know 👍