Check out my full courses and ebooks here 👉 www.howtoexcel.org/courses/

Have watched at minimum 20 Excel videos and this one is by far the best! Thank you

Wow! I spent half the night watching your channel. Highly recommend that even advanced users watch your tutorials. I've been using Excel for 25 years and love it. I knew many of your tips already but it was so worth watching anyway. The new functions I learnt will save me many hours.

Las Vegas, NV, USA: This was so awesome! Thorough, clear, concise, fast-moving but really easy to follow. Outstanding! Thank you so much!

Wow, as someone who is quite advanced already I can definitely say that this contains almost all advanced tips I would like people to know, plus a few more I didn't completely know yet. Well done!

I discovered your channel yesterday and am loving it. As an advanced Excel and Power BI user, your channel is amazing for incremental learning.

Great content, some I knew, some I did not, but it's always great to see things from another perspective. Watching this tutotial was totally worth it. Thank you!

Hands down the best excel video I've seen so far.

Short and to the point. Thank you, John.

Vielen Dank für ein riesige Information für Microsoft Excel, die Zusammenfassung ist voll gelungen. Ob es jede so korrekt schaffen wird, fraglich. Sehr Hilfreich! Respekt!

I had a quick view, paused your video, and have referenced it 4 times today in practical work, thanks!

Wow! What a great summary of features. At 2x speed, you have to pay attention to what's happening! Thank you!

Awesome. Very clear and straight to the point.

Awesome video and great tips summarized for every level of Excel users! Thank you!!

Excellent tutorial! Definitely recommended for learning Advanced Excel.

What a wonderful and pleasant way to spend a few minutes learning a great deal about Excel. Many thanks for a job well done.

Its fantastic learning. Way of teaching is outstanding

Hi John.. great list.. a real workout. One thing to note.. I don't think you need to use INDIRECT on a Data Validation list with the Source referencing a formal EXCEL table. Even though you can't reference the table name itself in the Source field and instead must highlight the actual range address of the table, when subsequently adding data to the table, the range address automatically expands within the Data Validation Source definition. So, no INDIRECT reference to the table name is needed. If data is in a list but not an EXCEL table, then INDIRECT or OFFSET or INDEX can all be used to make it dynamic in conjunction with a Named Range. Just thought I would mention it, as I discovered this feature one day which is a time saver. Thanks for all the excellent tips and tricks.. great stuff! Thumbs up!!

Loved the DAX part. Awesome trick. Thank You!!

OMG! Just the Ideas tip was worth the time to watch this video! I had noticed the Idea button but I'm in the process of designing an executive dashboard (using the functions I already know) and was too focused on that to try out something new. Voila! Ideas will auto create a few of the charts I had planned. But the best thing Ideas did was present 35 options but most were not useful because of the way my data was structured. So rather than spend my time creating pivot tables and charts, I reorganized my data and let Ideas create the charts.

Can`t thank you enough for these tips and tricks. They surely help saving a shit lots of time.

Very amazing and updated tutorial which is easy to follow. Thank you very much.

This was very useful and practical tips, thank you

Please keep uploading more videos. You are a champion !!

Love the content of this video and your way of teaching! Thanks for the video which gave me inspiration for my own classes (I give basic Excel training to students) 😊

Thanks for sharing such a valuable information.

Amazingly presented. Very well explained.

This is just great! Thank you so much! It'll really help me unpack Power Query which is just a bit dense for the new initiate :)

Thank you so much for doing these videos, you are a legend.

Thank you for this video! It was very helpful

Man a million likes to you! This video is a treaure trove!!!

Wow.. some great tips and explained well! I learned a lot. Super video.. thank you :)

Thanks John! We do a lot of budget and financial analysis. Any videos with examples on budget and financial analysis?

Very Very Helpful. Thank you!

Amazing video I think Excel has the option to distinct in pivots - if you added to Data model before excuting, as far as i remember it was in the value calculation when you click in the values section.

Great video. Useful tips. Thanks

Excellent Video... Thank you.

Very clear! Awesome tips & tricks, thank you!

very useful tutorial, Thank you

It's super helpful.Thanks

Hello, John. I've been using pivot tables and viewing numerous relevant YT videos a lot recently, but I did pick up something new just now - your final tip about adding two tables to a data model and using both tables in the pivot table. Nice - thank you! 🦾

great video! very insightful

Beautiful video.

amazing, nice tutorial

Wonderful course!

Gosh - this is really quality stuff. Thank you.

Thank you Sir!

Good stuff. Thank you.

Thank you so much for the video! Very well explained with crystal clear instructions. I would like to ask on Hide and Unhide feature in Excel. Do you know if there is any hotkey available or an easier way to Unhide all hidden columns and rows at the same time?

Excel has many different versions. It will be a good practice to mention which Excel version is the video talking about. Maybe for most part, they are common for different versions and this is good, but there are issues which differ from one version to another and this confuses the user. In this particular video and first tip, I am using 2013 version and I don't have "from folder" option. Also different options in "From other sources" are very strange for me and I couldn't understand them. I should search in Internet for their meaning and usage.

nice video, thanks

Very helpful video.

clap!clap1clap! a very powerful presentation from an old salt

Valuable tips, thanks for the spreadsheet provided. Thank you John.

Great tips sir, continue the great contributions in the future.

Some Really Helpful Tips And Tricks Happy Days!Thank You John :):):)

Unique effort... Thanks a lot

Hi John. Well done, long and comprehensive video. Is it planned in future touch more power pivot, dax, and data modeling? Thanks for sharing You knowledge?

Hello teacher, Great video

Really nice tips. Thanks

fabulous thanks

Thanks John for this useful compilation of knowledge 👍

Nice demonstration, but I want to add that the new functions are also available on Microsoft's web based version of Excel, so there is no need for Office 365 if anyone wants to casually try these out.

excellent material! thank you

Super...Happy to see such good value addition knowledge on excel

Thank you.

These are great tips, but for the first tip: isn't it too complicated for adding a file in a sheet in a workbook? For what purpose would you use it this way? Thank you!

Thank u excellent glad i found u

Damn get data form folder so awesome. Thank you!

Your classes are great! i love it. Is there a way to filter between times? Say for instance, I have a courier team who drives medical supplies back and forth all day. So we have 1st shift, 2nd shift, 3rd shift, overnight and weekend shift. I have 6 months worth of data and i was trying to see overnight shift only. So i wanted to filter it to where i only see routes picking up items from 10:30pm to 7:00am. Is this possible? do you have a tutorial on how to do that if it is possible? Please advise. :)

Really helpful!

Very nice video

Awesome! Thanks.

Great tips on excell

Awesome! Thank you for putting this together! 👍

Very nice!

Valuable tips, thank you.

Great, thank you!

for text to columns, if you don't close the current workbook and open a new spreadsheet - and try to paste something that has the delimiter, then it will automatically apply text to columns. Only way to stop this is to close all excel projects and re-open them and apply text to columns to your second project. This always caused me issues in dealing with different daily banking reports.

Thank you very much it was very helpful , please to share that Datasheet

Fabulous tutorial! Loved every bit of it. Thank you so much! Just a tiny question: How did you get the yellow circle around the curser? Again many thanks!!

Thank you for this lesson, really useful tips! I am really interested in advanced filter, I used it some time ago, but the biggest problem is that you can't make it adjusted for end user, as you you have table with some parameters above the table, every time you changed the data you applied filter by yourself. Do you know is it possible to auto-filter cells based on filled in data?

Thanks sir

Excel lent ! Thank you; most helpful.

You are the best

Awesome👌

Hi, I have a question: How can I create a dynamic pyramid chart that is horizontally and vertically segmented? In excel or power BI. Thanks a million.

Hello thank you for your nice tips! very interesting! but I have an issue on the first tips about Getting data from folders, when I remove one excel files I can not refresh anymore my table. Do you have any tips? thank you

Nice tutorial. Learned something. Kindly share the workbook. The link provided is broken.

Great video

so fantastic

SIR, DOWNLOAD LINK GIVEN BY YOU FOR PRACTICE WORKSHEET TO FOLLOW ALONG IS NOT OPENING AND SHOWING ERROR 404. PLEASE SUGGEST

great tips

First tip to get Data would be huge for me. Now how do you get the data from a folder with sub folders? I've tried to do so, and I get an error of [Expression.Error] The key didn't match any rows in the table. If I pull from each individual folder, I don't get this error, is there a work around?

can't seem to download workbook from link. Looks like a personal sharepoint account?

thank you

I've subscribed and downloaded all the other workbooks except for this one ?

Does this require excel 365 or something?, I don't have any stock option on excel 2021 (rich data type)

Good video

Thank you for this lesson! Can you please tell me how to add my signature and graphics so that it appears automatically within my emails?