26 HD Videos that will make Excel easy to learn and fun to use. These are detailed lessons that covers the topic comprehensively
Practice makes you perfect. So you get all the practice files used during the recording of these videos.
Your Excel training shouldn't stop with the videos. Get some useful resources and cheat sheets with every video to become an Excel pro
I work in a finance company since a year and everyone here is really good with excel. I always doubted whether I will ever be able to master in excel. Thanks to people like you who make this possible. Its just the beginning of my career and I hope I will EXCEL.
Your tips have been very useful in my day to day use of Excel. I have started to use several of your shortcut tips regularly.
Thanks you for putting in all your time and hard work to make our lives easier.
Thank you so much Sumit! I feel blessed to be able to learn from your course.
You are a very experienced tutor and all your lesson are very clear and simple to comprehend.
This module consists of five lessons that cover the following topics: Getting started with Excel, Data Entry/Editing, Number formatting, Data formatting, Working with cells and ranges, and Managing worksheets.
This module is geared toward beginners and introduces you to the structure and basics of Excel. It also has a lot of keyboard shortcuts and tricks that can help you get the work done faster
This module consists of three lessons that cover the following topics: Introduction to Excel tables, Autofill, Custom Lists, Flash Fill and Number formatting.
This module consists of eight lessons that cover the following topics: Excel formula basics, Logical formulas, Math formulas, Lookup and Reference formulas, Stat formulas, Text formulas, Date and Time formulas, and 10 Advanced Excel formula examples
This module introduces you to Excel formulas and covers most of the commonly used formulas with detailed examples. The last lesson of this module also shows you 10 advanced examples where you learn how these formulas work together to get complex tasks done.
Data Analysis in Excel
This module consists of four lessons that cover the following topics: Named ranges in Excel, Data validation in Excel (including drop down lists), Data sorting and filtering in Excel, Conditional Formatting.
These lessons will make you proficient in working with data. You will be able to slice and dice the data using sorting/filtering and will also be able to create better reports using conditional formatting.
Introduction to Excel Charting
This module consists of three lessons that cover the following topics: Introduction to Excel Charting, 10 advanced Excel charting examples, and Dynamic charts in Excel.
You know what management loves more than donuts and coffee? Charts!!! In this module, I will introduce you to some amazing Excel charts and show you how easy it can be to convert your no-one-looks-at-me data into everyone-loves-me charts
Excel has a lot of inbuilt charts and this module will introduce you to those. But more than that, it will show you how to use minor tweak and formulas to create advanced charts.
Excel Pivot Table - The Swiss Army Knife to Slice and Dice Data in Excel
This module consists of one lesson that cover the following topics: Introduction to Excel Pivot Table.
Pivot Table, without a doubt, is one of the best data tools to have braced the mother earth. It can summarize huge data sets in milliseconds (no kidding!). If you have a boss who asks too many questions about the data, Pivot Table is what you need. Watch this video to learn the basics of Pivot Table that will get you started on the road to productivity.
If you need to learn more about Pivot Tables, you can use the related articles section where individual topics are covered as written tutorials.
Excel Extras - Coz this couldn't fit it any other module
This module consists of two lessons that cover the following topics: Protection in Excel and Introduction to Excel Macros
These are short videos and will show you how to protect worksheets and use macros. VBA and automation is a huge topic in itself, and learning about how to record macros will get you started on the road to automation.
Absolutely! No charges whatsoever. You don't even need to sign-up for anything. Just click on the button above and start learning.
This course has been recorded with Excel on Windows. However, Mac users can also enrol and easily follow this course.
This course is recorded with Excel 2013. However, even if you have Excel 2007, 2010, or 2016/2019, you can easily follow this course. Most of the things covered in this course works for all the versions of Excel
Instant! Just click on the big orange button above and it will take you to a page that has all the videos. You can watch the videos as many times as you want (all you need is decent internet connection).
No you can not. You can watch these videos any number of times, but you need to be online with a decent internet connection.
You should - if you want to learn Excel or get better at it. The lessons are created with beginner Excel users in mind and also cover some advanced concepts as well (such as formulas and charting). This course will give you a strong foundation and make you better than 99.9% people using Excel.
The lessons are anywhere from 10-40 min long (depending on the topic)
Yes (with my Indian accent)!
You can leave the questions or feedback in the comments section (at the below of the course page). I will try my best to respond as soon as possible (but there can be delays).
Popular Excel Tutorials
I create tons of free Excel Tips videos. Click below to join my YouTube channel and get instant access to 150+ videos.