Over 100 Excel Tutorials in ONE Place

The links in this file are updated on a monthly basis. Check back to get the latest file.

On my YouTube channel, I often get questions like:

“Do you have a video on *specific* topic?” or “How can I do *this* Excel task?”

Actually, a lot of the videos on my channel are from you.

Let me show you:

The process of coming up with video ideas starts off chaotically, but ends up quite organized.

It generally starts off with Youtube, and one of you commenting on a video of mine, asking a question, and then me realising that the question could be best answered with a video.

I take a screen clipping of the comment and, as I generally have my OneNote open in the background, I go to my YouTube section and I paste that in the page “Video ideas to file”.

Once I get some time for filing, I add a tag to this and then I cut the idea and I paste it into “Filed ideas”.

The moment I do that, I add that idea to my Excel file.

I have a tab called ideas, and I make one row per idea, and I add the tag to it.

When I come to create this video, I can look up the tag on my OneNote and see the screen clipping, to get more information about what the person wants to see inside the video.

Sometimes I mention the person’s name, sometimes I don’t.

It might be because the question was raised by many people and I just take a sample, but basically that’s the process of coming up with ideas.

Now, let me show you how you get to the FREE Excel Tutorials mentioned in the title!

More than 100 FREE Excel Tutorials

If you scroll down to the bottom of this post, you’ll find a link that takes you to an Excel Workbook where you can see the list of all the videos I have on the my YouTube channel up to now. 

The good thing about this is that you can search for a phrase, and filter by topic (it’s much easier than searching directly on YouTube).

Let’s say you want to learn more about the INDEX formula.

What you can do is go up to the filter under “video title”, put in an asterisk (*), type in index and put in the asterisk (*) again:

This is going to give you all the rows that include the word INDEX.

Now let’s say you find this one interesting “How to use index and match”.

You can click on the link which takes you to the YouTube video, you can see the video length, the date it was created and a link to the article.

If you’d rather read about it instead of watching the video, or you want to download the workbook to practice along with me, click on the article link. This will take you to my tutorials page on this site.

You can follow the instructions, or just download the workbook at the bottom of the blog post.

If you’re curious how the filter technique worked with the wild cards (*) I have a video on Excel filter basics and advanced as well.

Check them out if you want to learn more.

I hope this helps you find useful videos and learn new topics.

If there’s a topic there that you didn’t know I had and you found it helpful, let me know in the comments below.

Also, if there’s a topic that I don’t have yet and you’d like me to make a video on it, let me know in the comments below too.

You know what’s going to happen now to that comment!

Video and Workbook

Feel free to Download the Workbook HERE.

Free Excel Download

Learn when you like, where you like.

Check out my bestselling Excel Courses

Learn anytime that fits your schedule.

Download files. Practice. Apply.

Visit Courses
Free Tutorials


  1. Jimmy September 8, 2018 at 11:37 pm - Reply

    Hi Leila
    I have been following your excellent “Excel Hash” video and trying to replicate the elements you highlighted. For some reason the frequency formula will not work. Instead of generating the value re each of the bins it just returns the value of the 0 bin for each of the other bins as well.
    Have you made the excel file available anywhere so that I can download and see what it is that I am doing wrong?


    • Leila Gharani September 10, 2018 at 6:29 am - Reply

      Hi Jimmy,
      One reason could be this: When you write the Frequency function you need to highlight the cells where you want the result of the frequency function to be first. For normal formulas you just click in a cell and type in the formula, but here you actually need to highlight all the cells that should have the result in them (in this example: I2:I6. Then go to the formula bar and type in the formula – then press Control + Shift + Enter (not just enter but Ctrl + shift + enter). Your formula should work then.
      Hope this helps.

  2. Eyal September 14, 2018 at 3:13 am - Reply

    Hello Leila.
    I have been following your youtube channel lately and was amazed from your video tutorials and ideas.
    I have been struggling with a filtering issue recently and no one was able to find a good solution for me.
    The main problem is filtering by dates that are in different formats. I can provide a sample spread sheet and detailed explanation.

    I will be glad to get your help.

  3. Lawrence Heltzer October 20, 2018 at 3:51 pm - Reply


    I just saw your video on the new dynamic array functions that Microsoft will be releasing… and I am blown away. You are absolutely dead on when you opened that video with “this will change everything.”

    But when?

    Specifically, will it be in Office 2019? Will there be an add-on for earlier versions?

    Also have to tell you that I discovered your YouTube videos a few weeks ago and you are amazing. Combining technique with graphic design with exceptional presentation skills. I’m a fan!


    • Leila Gharani October 23, 2018 at 8:43 am - Reply

      Hi Lawrence, unfortunately, it will not be part of 2019 Excel. I think it was too late to include it in there. It will be part of Office 365 rolled out as an update.
      I’m glad you like the videos. Thank you for your support :)

  4. Samir November 12, 2018 at 5:55 am - Reply

    Hello Leila,

    I have been a big fan of excel and always used to think that i need to learn more. Over the last few weeks i have been watching some of your videos in the quest to get better with the usage of excel. Your videos make the understanding of those functions simple and the applications of those functions that you bring about is absolutely brilliant. Thanks for sharing such informative stuff in such an easy to understand manner.

    Presently i am wondering if should take a course in excel and the vba course really looks interesting to me, however i am not sure if it is the right time for me get there now as i am still in the learning mode w.r.t the various functions and there utility. Wonder if you could have some suggestion here.

    • Leila Gharani November 15, 2018 at 2:12 pm - Reply

      Hi Samir – thank you for your support of my videos. I’m glad you find them useful. I don’t suggest learning VBA yet – I’d say you wait until you feel you have a good foundation in Excel first and then to start to dig in VBA. I have an Excel basics playlist on my channel you could start from. I’ll also create an Excel basics crash course soon on my site.

  5. faissal bozi November 20, 2018 at 11:11 am - Reply

    Hi Leila, Thanks for these useful files and videos ,I am searching for files excel visualization Demo workbook in your resources but I didn’t find it, please can you provide me with these files, Thanks

    • Leila Gharani November 20, 2018 at 12:42 pm - Reply

      Hi Faissal – this is the name of the Demo book I have inside my paid visualization course. Please download this from inside the course, you’ll see it as a resource.

Leave A Comment

Share This