Get the Full Tutorial List
Download the full list HERE.
Aside from Excel, you’ll find tutorials on Finance & Accounting, Power BI, Power Automate, PowerPoint, OneNote and other Office Productivity Apps.
The links in this file are regularly updated. Check back to get the latest file. Or read on till the end, to learn how to get a direct connection to the latest version.
From Idea to Video
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 300 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!
Never Miss an Update Thanks to Power Query
If you don’t want to miss my new videos, all you have to do is Subscribe to my channel 😉
But if you want to keep your copy of the Tutorials list up to date, follow the steps in this video:
You will learn how to connect to the file with Power Query (Get & Transform Data). That way, you won’t have to come back to the post, simply refresh on your end.
You can also create a custom data type to get more out of the results (including clickable hyperlinks that take you directly to the relevant post).
Leila Gharani
I'm a 5x Microsoft MVP with over 15 years of experience implementing and professionals on Management Information Systems of different sizes and nature.
My background is Masters in Economics, Economist, Consultant, Oracle HFM Accounting Systems Expert, SAP BW Project Manager. My passion is teaching, experimenting and sharing. I am also addicted to learning and enjoy taking online courses on a variety of topics.
