7 short HD Videos that will make Excel easy to learn and fun to use. You get instant access to the first lesson and then one lesson every day
Practice makes you perfect. So you get all the practice files used during the recording of the videos.
Your learning shouldn't stop with the videos. So you get some useful resources and cheat sheets 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.
Copy Paste Secrets Used by Excel Pros
Copy paste is more than a simple Control C and Control V. In this video, you get the know the powerful ways of copy pasting data in Excel. Additionally, I also share my favourite mouse tricks that save me tons of time every day.
Excel Functions Basics + 3 Excel Function Examples
What the difference between a function and a formula? What are operators and how to use it in Excel formulas? Why knowing the order of precedence can make a difference? Watch this video to get answers to these questions. Additionally, also learn how to use SUM, COUNT, and AVERAGE function in Excel.
Advanced Excel Functions Made Easy
Let's get advanced with this video. Learn how to use IF function (and the wonders of Nested IF), SUMIF function, and the VLOOKUP function. This video will make it simple to follow these advanced function with some practical examples (and of course you get to download the examples and practice yourself).
How to Handle Large Data Sets in Excel - The Exact Tools I Use Every day
Don't get bogged down by large data sets. Watch this video and learn how to can easily manage large data set with panache. In this video, you will learn about Freeze Panes, Split worksheets, filtering and sorting data (along with a cool technique to sort data based on cell colors).
The Wonders of Conditional Formatting in Excel
Conditional formatting blows life to your boring dull reports. Watch this video and learn how you can quickly add amazing layer of visual analysis by using conditional formatting. And do remember to check out the additional resources I share with the video (it's legen - wait for it - dary)
Chuck those boring numbers! Let's Visualise Data with Excel Charts
You know what management loves more than donuts and coffee? Charts!!! In this video, 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
Pivot Table - The Swiss Army Knife to Slice and Dice Data in Excel
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.
Absolutely! No charges whatsoever.
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 2016. However, even if you have Excel 2007, 2010, or 2013, you can easily follow this course.
You get access to the first lesson as soon as you enrol. After that, I will send you 1 lesson every day for the next six days. And your Excel learning would not stop after these 7 lessons. I will continue to create new tutorials and send you on a weekly basis.
You should - if you want to learn Excel or get better at it. The lessons are created with beginner Excel users in mind.
I believe in short and crisp videos for teaching Excel. The lessons are anywhere between 8-15 minutes in duration.
I will send you the link to the videos via email. While I recommend you watch the videos the same day you get it, I understand it's not always possible. So I am giving you the lifetime access to all the videos. You can go back anytime and watch any of the video.