Excel Basics

This comprehensive YouTube tutorial was created by ExcellsFun and covers more than 12 hours of instruction on how to use Excel. It is entirely free to access and can be repeated as many times as you like. It is often heralded as one of the better free resources to gain a deeper understanding of Excel features and applications.

Created by: Michael Girvin

Produced in 2017

icon
What you will learn

  • Introduction to core Excel features and functions, including formatting cells, creating formulas, utilizing built-in calculating tools.
  • Techniques for improving Excel efficiency.
  • Facades
  • VLOOKUP
  • Cell metadata
  • Conditional formatting
  • Data Analysis

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 98 / 100

icon
Course Description

1. Create Formulas to make business calculations2. Use Excel Functions like VLOOKUP & IF functions to make efficient business calculations3. Format & create page setup for effective reports and dashboards4. Understand and use Number Formatting in reports and calculations5. Use PivotTables to create reports and dashboards6. Use Sort, Filter and Flash Fill for data analysis tasks7. Use Power Query to import and clean data8. Use Power Pivot Relationships to make reports from multiple tables9. Create charts and visualizations for dashboards10. Complete comprehensive business tasks integrating multiple Excel featuresThis is a free Excel class taught by Mike Girvin, Microsoft Excel MVP and Highline College Professor. This class will teach you the efficient and effective methods of using Excel so you can became great at using Excel to accomplish all your tasks at work, at home, and so that you can get that job you want that requires Excel skills!!!

icon
Pros

icon
Cons

    • Clear, patient explanation of all covered concepts. Absolutely no computer background is necessary to get through this series.
    • Thorough walkthroughs make it easy for you to open your own spreadsheet and follow along.
    • High, positive energy makes an otherwise dry topic compelling and interesting.
    • This is more than just a handful of tips to help with Excel. It is a comprehensive tutorial in the features, functions and applications of the software.
    • As with any YouTube tutorial series, there is no direct interaction with the instructor.
    • 12 hours is a lot of time to spend going through Excel. Course can feel long.
    • Despite the deep dive, lessons do not cover background knowledge necessary to fully utilize some of the explained features (e.g. Lessons on statistical tools do not fully teach how the statistics work).

icon
Instructor Details

Michael Girvin

Mike Girvin is known online by the name ExcelIsFun. On on his Youtube channel he has an astonishing collection of over 2200 videos on Excel, organized in over 50 playlists. Mike has an almost encyclopedic understanding of Excel and is an extremely enthusiastic teacher, which you'll immediately notice in any of his videos. He has also published 2 books on Excel and several DVDs.

icon
Reviews

4.9

15 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By xlViki on 8/29/2014

The guy might sound quirky to some, but I think he just tries to make it exciting. On purely content basis, his videos are really good. A good resource for beginners and intermediate users alike. One of the excel resources I recommend to everyone.

By GeorgeK1 on 5/8/2019

Big thumbs up to Mike Girvin and his Excel Is Fun channel! I've been using Excel for close to 20 years and I still reference his videos when I need to learn something new or refresh an old skill.I'm doing some training classes at my company and the one thing I suggest as the quickest way to get better faster is to watch his Excel Basics: Learn to Efficiently Use Excel at Work and to Get a Job. This will teach you just about all you need for most business scenarios and it's only 25 videos. Learn one a day and your a hero in a month.Mike is an excellent teacher and in addition to demonstrating the Excel functions he constantly reinforces a myriad of best practices, like keyboard shortcuts, to streamline your work.

By Lee Johnny on 10/18/2017

Excel tutorial cannot get better than this,literally!!!

By Don Chering on 7/25/2018

Very enjoyable refresher on Excel basics, I had forgot some of them and was following along on my Mac but still got there.

By Richmond Tiger on 9/12/2017

These Excel Basics videos are good for everyone at every level of Excel knowledge and experience.

By Big Will on 5/15/2018

This is an amazing tutorial! I've fine tuned my excel skills with this video especially with printing!

By Barry Bennett on 11/23/2018

For the first 20 seconds or so I thought wow! patronising!! but after that I realised I was so wrong! His delivery is actually amazing. He stresses all the important points in such a way that it is so easy to follow and remember. His repetition then hammers the point home and his final summary just ties it all together. On any teaching or presentation course you are taught the following adage; " Tell them what you are going to tell them, Tell them, Tell them what you just told them" That is exactly what he does. He also teaches us the easy way to do things in real life not like a handbook or instruction manual but as a real person would do it.

The great thing about this videos is how simple and well constructed they are, and they are not boring at all. Kudos from Mexico for this amazing tutorial.

By Mark Tempest on 12/24/2019

I knew the basics of excel but I decided I want to get to advanced level. These videos are fantastic. Really clear and to the point.

By Savinder Kaur on 1/12/2019

Excellent videos, all the steps are clearly explained, thank you so much for making them available free of cost to everybody.

By Jamie O'Neill on 11/2/2018

Top notch tutorials. For some reason you have the ability to teach me about excel whilst also entertaining me.

By Orsolya Manning on 2/15/2019

I never thought learning how to use Excel can be so entertaining! You are the best example of a teacher who knows how to make learning fun.