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.

Get the Full Tutorial List

Download the full list HERE.

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

At the top 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!

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

60 Comments

  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?

    Thanks

    • 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.

      • Bobby Perez August 9, 2019 at 3:44 am - Reply

        Hi Leila,
        I have learned SO much from watching your videos and has helped me a lot at work. Im currently trying to build a dependent drop down list following your tutorials but im in a pinch.

        I have 3 columns that I need to create drop downs and each drop down is dependent on one another to show only specific data based on the selection of the previous drop down list but I can’t get it to work for the third column. For example:

        Column 1 has names
        Column 2 has specific categories assigned to the names. Some names support multiple categories.
        Column 3 has item codes specific to categories. Some item codes fall under multiple categories.

        Any help is appreciated. Thank you!

  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.
    Eyal

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

    Leila,

    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!

    Lawrence

    • 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.

  6. Godwin December 15, 2018 at 9:39 pm - Reply

    Hi Leila,
    Your site and blog make sense to me. Please I am looking for a tutorial or course that can assist me to automate undergraduate result computation. I have perfected semi automation using conditional statements. I want an excel design that will enable lecturers to load results prepared on excel and the respective scores will move to the corresponding registration number without manual typing anything. Please guide me… Best Regards

    • Leila Gharani December 20, 2018 at 9:09 am - Reply

      Here, you can probably achieve a lot via the lookup formulas like Vlookup & Index and match. This way you can paste all the raw data in one place (an Excel table would be optimal) and then the formulas will allocate them to the right places…

  7. Kim Chaney December 20, 2018 at 2:00 pm - Reply

    Leila,

    Thank you, thank you, thank you so very much for your training videos, I greatly appreciate your help. I have made a few purchases on Udemy to further my Excel proficiency.

    Please keep up the great work!

    Happy holidays to you and yours.

    Sincerely,
    Kim Chaney

    • Leila Gharani December 20, 2018 at 6:23 pm - Reply

      Thank you Kim for your support! Wish you nice holidays and all the best for the new year.

  8. Glen December 20, 2018 at 5:45 pm - Reply

    Great work on your channel, Leila. As a business professor who teaches business analytics using Excel, I am always looking for “better ways” to explain concepts/approaches. In fact, I am promoting your channel to my students as an example of “doing-it-right.” Keep up the great work and all the best in the New Year! (p.s. I’d love to see some Excel+Data Modeling+Power BI videos .)

    • Leila Gharani December 20, 2018 at 6:25 pm - Reply

      Thank you Glen. Also for promoting my channel! Really appreciate it. I added your suggestions to my list. Thank you :)

  9. Chandra Raj Sharma December 20, 2018 at 6:26 pm - Reply

    Dear Ms. Laila,

    Good evening, I watched most of your post in about excel to learn. Thank you for teaching everyone. I have one request, could you please make one post to short all absent, sick or present on roster according to the date Drop Down list in such a way that when we choose one category it display the persons of that day in roster. I mean when we choose absent all absent people on that day should be displayed. I will send the attachment of format on next text.

    Regards,

    • Leila Gharani December 20, 2018 at 6:53 pm - Reply

      Thanks Chandra – Sure – I can add an example for that. For now, you can use the same method shown in this video. Soon with Office 365 it will be a much much simpler formula.

  10. NM December 20, 2018 at 10:46 pm - Reply

    I never get tired watching your videos and your channel is my go-to guide when I need a quick refresher on an excel problem. I just love the way you explain things so they make sense.

    You are a beautiful and smart woman and I am looking forward to learning much more from you.

  11. MOHAMAD SANI AHMAD December 21, 2018 at 1:13 am - Reply

    Dear Leila,

    I just found out about your youtube videos a couple of months back but only subscribe to your channel a few days ago.

    I am a middle school teacher and have been struggling to round up the scoresheet result. In my scoresheet, I have to give the final result (letter grades) in one specific result. I have been using the concatenate formula to roynd up the final result, example, a student got a letter result of 5A 3B and 1D but the result that appeared on the final result is 5A 3B 0 1D 0 0.
    Now how do I can get the final result only, that is 5A 3B 1D.

    Regards from Malaysia.

  12. Robert December 22, 2018 at 3:00 am - Reply

    Your workbook of tuts is such an incredibly smart thing to do. I’m so glad I subscribe to your channel. As my father used to say, “organization is half the battle”. And so as not to leave you hanging, execution is the other. I can’t wait to see what 2019 brings. I love to learn. Thank you for being such a marvelous, thoughtful teacher.

    • Leila Gharani January 3, 2019 at 11:55 am - Reply

      Thanks Robert! I’m glad you find the file useful :)

  13. Luis de Almeida December 22, 2018 at 7:04 pm - Reply

    Dear Leila,
    Thanks in advance for your free tutorials, I use a lote of them, bur sometimes I can’t find the video.
    Can you send me a link to download all of your tutorials at the same time?
    Merry Christmas and an happy year of 2019

    • Leila Gharani January 3, 2019 at 11:55 am - Reply

      Hi Luis – the file is right above the comments – at the bottom of the blog post :)

  14. Steinar Johansen December 23, 2018 at 10:36 pm - Reply

    First of all, I have been watching many of your videos and you are one of the kind with the way you explain. I am a MOUSE expert and have been teacher in this many years ago. My heart is with excel all the way. One of my hobbies is cooking, and for many years i want to collect my recipies. Some month ago I started, and i started watching our videos.I know i can do this in access or VB, but I want to do it in excel. Ican do some programming in VB to make things happen but not all. I know i can do it all with formulas. I have tried VLOOKUP, HLOOKUP INDEX and MATCH, but I dont get the function of it..I know it is my definition in the formula that is wrong, but I dont know what.
    Why I do this? I have been trying so many recipies program but there is always some thing wrong, eks. you can not do anythhing with the language… If I get this to work my way I wil let it go for free so any one can use it and in an easy way make it fit theyr need. Intresting? Give me a mail and i will send the workbook and explanation.

  15. Shadrack Awunyo December 25, 2018 at 8:28 am - Reply

    Dear Leila,
    We thank you very much for actively sharing your excellent knowledge with us at no cost. Your posts are very informative and they simplify our works for us. Speaking for the majority, I know. Have a good holiday and see you in the coming year.
    Regards
    Shadrack…..

    • Leila Gharani January 3, 2019 at 12:01 pm - Reply

      Thank you Shadrack for your kind words and your continuous support. Hope you had great holidays :)

  16. Don January 9, 2019 at 8:34 pm - Reply

    Hello Leila,

    These are truly helpful and so appreciative tutorials. The tutorial provided on ‘Excel Dynamic Chart with Drop down List’ is very powerful for displaying data, but when used with a pie chart, the values that have zero, or are empty cells, still appears on the pie chart. Is there anyway you can help in not having those values show in the pie chart or any other graph, if they have a blank cell or zero value? I tried integrating you lesson on ‘Automatically skip blanks in Excel charts with formulas’ into the dynamic chart with drop down, but became very confused in doing so. Thanks again.

    • Leila Gharani January 11, 2019 at 3:22 pm - Reply

      Hi Don,
      I’d go with a data preparation table in this case and use that as the source for the Pie Chart. So right beside the values you can put this data prep table. If you download the workbook for the formula version of the “Automatically skip blanks” lecture, you can copy and paste the formula from my file to yours. Would that work?

  17. Jason January 23, 2019 at 8:05 pm - Reply

    Leila,

    i just started to use some of the formulas in Excel for the first time, and I came across you discussing the “IF” function. you explained it very well so, I looked for your other topics.

  18. jim February 14, 2019 at 12:58 am - Reply

    Like your videos a lot, and tried to download video source above, and i cannot search it, scroll through it or use it in any way. Cannot see beyond row 40 when scrolling down. Probably just me, but wondered if that has happened to anyone else.
    thanx

    • Leila Gharani February 17, 2019 at 5:34 pm - Reply

      Hi Jim – if you have Excel, you should be able to scroll and use it. It might be in “protected” form when you open it so you might need to click on “enable editing” on top of the workbook.

  19. Orieke Joshua March 4, 2019 at 10:37 am - Reply

    Hi Leila,

    I want to say a big thank you for staying put and giving time to continuous learning. Your videos have sure giving a sit at the table at my work place and has fanned me to relevance.

    I would like to know the requirement for registering as your student.

    • Leila Gharani March 5, 2019 at 8:27 am - Reply

      Hi Orieke – thank you. We’re glad to hear that. You can find out more info about the courses we currently offer here: https://www.xelplus.com/courses/

  20. Steve March 6, 2019 at 11:29 am - Reply

    Hello Leila,

    I have come across your videos and find them very helpful. I am struggling with an issue of how to auto fill text from one spreadsheet to another spreadsheet in the same workbook. I have merged a number of cells so I can add comments in the cell on page one and it also appears in a cell on sheet 2. Can you help please

    • Bryon Smedley April 7, 2019 at 8:11 pm - Reply

      Thank you for your question. To aid in answering your question, the following link to the Microsoft Excel Tech Community would be the best place to pose your question. If you have a sample file to upload, this would greatly aid in developing a course of action.

      The Excel Tech Community has some of the finest minds in the industry. No matter your issue, I’m certain someone there can inform you of the best way to reach your solution.

      Microsoft Excel Tech Community

      With over 25K members and almost 30K posts, your solution is either ready and waiting or has the possibility of being answered more quickly than we may be able.

      Thank you for taking the time to write. I hope you find success with this fantastic group of Excel enthusiasts.

      XelPlus Team

  21. Mohammed Shanes March 9, 2019 at 6:30 pm - Reply

    Dear Leila,

    You have been a great instructor and your YouTube Videos are really helpful.
    I am planning to take a course on Dashboard so that after learning it, it can be useful for my work.

    Thank You
    Mohammed Shanes

  22. Ricardo F. Denoni March 17, 2019 at 2:19 pm - Reply

    Dear Leila,
    I would appreciate a series on Building Management using MS Excel or possibly even more Office 365 suite applications that help control cost such as monthly versus budget spending considering budget WBS, physical time control, quality, scope, purchasing , human resources, risk, integration and communication and dynamically summarizing in a dynamic dashboard which will be updated monthly. Consider a dashboard field for comments or alerts from the project manager. Also consider the applicable CPI, SPI or other KPI indicators. The idea is to present the monthly report such as “one page report”. From now I am aggrading your wonderful didactics and attention to those who wish to greatly evolve their learning in MS Excel.
    This week I will sign up for the 3 Course Bundle.
    PS: I wrote in Portuguese from Brazil and I used Google translator, so I’m sorry if any words or meaning of the phrase caused a misunderstanding.

    • Leila Gharani March 17, 2019 at 2:46 pm - Reply

      Thank you Ricardo for your suggestions. I’ve added them all to my list. I will check which one I can incorporate in existing or future courses & videos. Many thanks for your support.

  23. tajhizyar March 24, 2019 at 9:30 am - Reply

    interesting ! Thanks for information !

  24. Shiping Lee April 11, 2019 at 11:49 pm - Reply

    Thanks for information !

  25. ido April 22, 2019 at 12:35 pm - Reply

    Hello Leila,

    First of all – I watch your videos and they are amazing – really good and interesting.

    I have a question for you.
    Recently you published a video, dynamic Arrays formulas.
    I have Excel in its last version, 365 proplus – and I tried to use these formulas, but none of them are available for me (filter, sort, unique).
    Do you have a solution? idea?

    • Bryon Smedley April 22, 2019 at 6:32 pm - Reply

      The Dynamic Array functions are being rolled out in phases; this means that depending on your subscription channel, it could be a few more months before you see it included in your function library.

      Just keep checking those monthly updates.

      The XelPlus Team

  26. Mark Tristan R. Ocampo April 23, 2019 at 8:57 am - Reply

    Hello, Leila. How are you? It’s good to be here.

    First and foremost, I would like to THANK YOU for all your Excel video tutorials on YouTube. That’s where I first “met” (stumbled upon) you which eventually lead me to your official site, here.

    Excel has been a part of both my professional and personal lives. It started out from basic daily budget and expenses computation to managing large amount of data at work to the tiniest and most specific details of my Family members. I don’t know what I would do without spreadsheets (Excel in particular) in my life.

    A couple of years back, I had the opportunity to take basic and advanced Excel courses courtesy of my workplace which I was very thankful for. But as we all know, Excel is as broad as the universe that even after completing these courses, there will still be challenges we cannot solve and questions left unanswered. So, I usually “YouTube” or “Google” it out and most of the time, it solves the problem for the day.

    Only this week that I am simultaneously posting this on your site I encountered 1 of your YouTube videos that lead to another. Later on, I found myself subscribed (notification bell on) and liking and commenting and interacting with everyone else in the Comments section.

    Leila, your tutorials are heaven-sent. And you are an angel the way you explain terms and formulas and everything else that intimidated us in the past. Your lessons are such blessing to and easy to comprehend.

    Can’t wait to get back home and watch more (or all) of your YouTube videos (as I am currently in the office).

    Again, thank you so very much. God bless.

    Mark Tristan R. Ocampo
    Favorite feature: Pivot and Vlookup (I know there will be more after watching your videos)

    • Leila Gharani April 25, 2019 at 7:16 am - Reply

      Thank you very much Mark for your kind words. I’m very glad to hear you find the tutorials helpful. It’s great to have you here in our community.

  27. Dennis May 4, 2019 at 9:23 pm - Reply

    Hello Leila,

    great content on YouTube I agree.

    I got Question

    I always creat tables with customer numbers and their activelicenses

    customer number Product

    a x
    a y
    b x
    c x
    c y

    I always should Analyse customer numbers with only x. I know I can filter this. Is there a possibility in Pivot, too?

    Thanks and best regards.

    Dennis

    • Bryon Smedley May 5, 2019 at 11:20 am - Reply

      Thank you for your question. To aid in answering your question, the following link to the Microsoft Excel Tech Community would be the best place to pose your question. If you have a sample file to upload, this would greatly aid in developing a course of action.

      The Excel Tech Community has some of the finest minds in the industry. No matter your issue, I’m certain someone there can inform you of the best way to reach your solution.

      Microsoft Excel Tech Community

      With over 25K members and almost 30K posts, your solution is either ready and waiting or has the possibility of being answered more quickly than we may be able.

      Thank you for taking the time to write. I hope you find success with this fantastic group of Excel enthusiasts.

      The XelPlus Team

  28. Linda Preston June 14, 2019 at 9:02 pm - Reply

    Hi Leila,

    Thank you for all you do for all of us wanting to learn Excel. I have signed up for a few of your courses to help me on my path to Excel Expert Certification and of course follow your YouTube videos which are great.

    I am hoping you can point me in the right direction on how to study for the exam and perhaps practice tests. Do you have any tools available or have recommendations?

    Thanks so much!

    • Leila Gharani June 19, 2019 at 2:50 pm - Reply

      Hi Linda, When I did the exams, I found the MOS study guides useful. You can find the links on my resources page. All the best for the tests!

      • Linda Preston July 23, 2019 at 9:23 am - Reply

        Thank you so much! I was given a (pricey $$$) Excel Expert course but since learned it wouldn’t actually qualify me to pass the exam. I’ve learned so much more from you and value your advice. The books you recommended are perfect and have me feeling confident once again! Thank you for all you do!

  29. Adrian Henson June 15, 2019 at 9:44 am - Reply

    Hi Leila, thank’s for your time in making such informative video courses, though I am struggling to understand where everything goes. I am trying to create a basic stock control form in VBA, to populate a worksheet, no bells or whistles, just find the last unpopulated row and fill it in. I have a show userform on open sheet, which I have coded in the sheet. I have exit, add, and cancell control buttuns on userform. The rest I have tried to code in the userform, combobox, textbox etc. All I want is a simple solution, if possible, any ideas? I do not know if I really understand the laws of structure where all the parts of code should go. thank’s

    • Leila Gharani June 19, 2019 at 2:38 pm - Reply

      Hi Adrian, best would be to post your specific question with screenshots on an Excel forum – for example Microsoft’s tech community right here.

  30. Mordi June 15, 2019 at 11:33 am - Reply

    Dear Leila,
    A very big thank for you great works for the use of excel. Your videos and articles have made learning excel a mile easier and simpler. I use to panic when my boss gives me a job to represent in spreadsheet, but now it’s a lot breezy through the video teachings on YouTube. I am even promoting your channel to my colleagues. However, I am with the safety department in my company and there are Risk Assessment Matrix(RAM)with color code risk levels I find difficult to represent in excel without using VBA. Please I would be happy if you add RAM topic to your channel. I could send a sample of RAM via a functional email.
    Many thanks in advance
    Mordi
    A huge fan

    • Leila Gharani June 19, 2019 at 2:36 pm - Reply

      Thank you Mordi for your support and for spreading the word. We are happy to receive YouTube video suggestions.

  31. HAFEEZ KORAIE June 22, 2019 at 12:28 pm - Reply

    Thank you for support

  32. Punith August 9, 2019 at 4:31 pm - Reply

    Hi Leila,

    Today I got chance to teach excel for 40 team members and it went well. I would like to thank you, since I took most of the examples from your YouTube channel.

    Promoted your YouTube channel as well.

    • Chris August 23, 2019 at 4:26 pm - Reply

      Wow, that’s great! Congratulations on your successful training. Many thanks for your support.

  33. ido August 11, 2019 at 12:15 am - Reply

    Dear Leila,

    your advice was very useful in the last time.
    one more question please –

    in formulas: Sumif, Sumifs, Averageifs, maxifs… I want to Insert the criteria – bigger then.. BUT, I dont want to write the criteria manually, I want to link it to the cell

    I tried several formulas, such as: indirect; cell – and it’s doesn’t work.

  34. Mbali September 11, 2019 at 3:18 pm - Reply

    LEILA! YOU THE BEST NEXT TO GOOGLE!!!

  35. noorsanattajhiz October 8, 2019 at 1:26 pm - Reply

    great
    thanks for your good data

Leave A Comment

Share This