Learn Excel Online - Improve Excel Skills! Free Online Excel Training Course
Since the Excel Course Lesson Plan on the home page has the videos grouped into logical categories, I thought it would be important to provide a recommended Lesson Guide for watching the videos and tutorials. I’ve tried to group them into Beginner, Intermediate, and Advanced (based on complexity). More importantly, they are ordered in the way that I feel would be most effective for learning Excel. This allows for the knowledge from prior lessons to help in understanding the more advanced ones. If you plan on going through the entire course, I would recommend watching them in this order. All lessons are video tutorials unless specified, with the total video time next to each link.
Beginner Lessons
- Beginner’s Introduction to Excel [19:44]
- Basic Formatting Techniques [08:06]
- Absolute and Relative Cell Referencing (i.e. the $ sign) [07:44]
- Math & Statistical Functions (e.g. SUM, AVERAGE) [13:53]
- Date & Time Functions (e.g. TODAY, MONTH) [13:25]
- Text Functions (e.g. LEN, CONCATENATE) [14:34]
- Group / Ungroup Rows & Columns [Non-Video]
- Alternative to Merged Cells (Includes Removing Gridlines) [Non-Video]
- Extract List From Data With Duplicate Values Removed [Non-Video]
Intermediate Lessons
- Logical Functions (e.g. IF, AND) [14:56]
- Lookup & Reference Functions (e.g. VLOOKUP, MATCH) [14:04]
- Naming Ranges and Cells [09:58]
- Data Validation with In-Cell Drop-Down List [08:54]
- Conditional Formatting [09:11]
- Introduction to Pivot Tables [06:57]
- Advanced Pivot Tables: Round 1 [08:18]
- Advanced Pivot Tables: Round 2 [11:19]
- Auto-Filter and Advanced Data Filtering [06:34]
- Creating and Designing Charts (including Sparklines) [14:48]
- Error Checking and Data Monitoring [16:52]
- Introduction to Tables [Non-Video]
Advanced Lessons
- Information Functions (e.g. CELL, ISNUMBER) [09:44]
- Formula Auditing & Formula Evaluation [07:28]
- Advanced VLOOKUP Examples [14:36]
- Advanced INDEX & MATCH Lookup Examples [09:40]
- Five Powerful Excel Tips [15:19]
- Introduction to Macros & VBA programming [13:08]
- VBA Macro Walkthrough #1: Purchase Order Generator [17:28]
- VBA Macro Walkthrough #2: Message Encoder & Decoder [16:51]
News / Other
- Excel 2013 In-Depth Preview [15:29]
Awesome lessons! Awesome videos! Awesome explanations! This is priceless!!! Thank you!
This is so incredibly helpful I can’t thank you enough. If you aren’t a teacher, you really should be.
I absolutely agree. Thank you, Ben, for helping us so much!
hi.it’s such a good educative tool. thank you very much.
Many many thanks for all your Excel videos! I’m a computer illiterate and never in my life thought that I could learn the basics of Excel in such a short time and in the comforts of my home + with all that flexibility!! Awesome!!
thanks a lot for the site team
Hey Raghavendhra,
So glad that you found the site/tutorials to be useful! It’s actually not a team but just myself who created & operates the site.
Getting positive feedback is what makes it all worth it.
Feel free to reach out to me if you have any questions or suggestions.
Cheers,
Ben
great ben thanks.
Excellent……
Useful Data…….
Thank you so much! I love this site!
thankyou SO much, i really need to learn to use Excel. word and office to get any decent kind of job and this will help a lot. very much appreciated
Hello Ben,
Your tutorial is excellent ….. I am looking out for Planned lessons. How could I get them ?
this site is so awesome I want to marry it and have it’s babies!
be blessed,it is very helpful
These lessons are brilliant. Nice to have them organised in terms of difficulty progressively getting more advanced. Very useful reference also when I need a quick tip on a formula or a technique i have forgotten about. This is a real help for me as a finance analyst!
Very well done! Thank you so much
you saved my life with these videos!!! I have a job interview in a few days and did not read the job description properly and it said must be proficient in excel, i have used excel but that was years ago and forgot almost everything, so at least now when I go for my interview I can say it’s been a few years but I’m re teaching myself. THANK YOU!!!!
really very helpful lessons for me, thanks
Really good work mate, I spend all my free time at work looking at these videos as much as possible. Cheers!
Thank you for doing this, I am very this really helpful
its really help ful thanks
Ben,
I truly appreciate the amount of work you have put into this. This is very clear and organized. Cheers!
In fact, I recently bought a course on MS Excel, but the quality of this course is way higher than paid course both in terms of quality of content, presentation, and organisation. It is indeed an excellent resource. I present my sincere appreciation to the creator for producing a highly organised and very effective course. Thanks a lot.
I really appreciate you posting this tutorial ! This is very beneficial , Have a blessed day!
Hello – again, excellent sessions. You mentioned you might be rolling out a third lesson around pivot table functionality. Today I discovered ‘slicers’ – pretty cool stuff. You might want to include in future pivot lessons. Thanks again.
Can you take beginners,intermediate and advanced or do you choose one level?
You guys are doing a wonderful job. I’ve been yearning to find a right place to learn excel and here am I. Thanks a lot!
Hey mate, Do you have anything of microsoft access?
Hey!
As much as I would love to be able to do other products, I currently only do MS Excel 2010 and doubt I would be branching beyond that due to time constraints and work. Any other project like that would really take away from my ability to keep up with Excel Exposure.
I’m sure there are some useful resources online though, and I hope you never stop wanting to learn!
Cheers,
Ben