Last Updated on March 1, 2021.
What are the best free excel courses online for beginners in 2021?
Excel is one of the most popular business tools in the world. It’s the industry-standard software for data analysis and visualization and is useful in virtually all professions. Bankers, accountants, business owners, tax analysts, statisticians, data analysts and everybody else use excel.
More Posts on the Blog:
You can use Excel to do basic arithmetic and in fact some complex mathematics. You can use it to analyze data, track inventory, make charts, prepare to-do lists, and, wait for it, create sudoku puzzles.
Business owners use Excel to evaluate and improve their businesses. Some corporate workers are employed just to use Excel. This makes Excel one of the most essential tools everyone should know how to use regardless of their profession.
To make it easy for you to learn how to use Excel, I have curated a list of the best free Excel courses online for beginners. And considering its many uses, I made sure to select courses and tutorials that cut across different aspects of the software.
Pivot tables, math formulas, keyboard shortcuts, charting and graphing, data analysis, VLOOKUP, you’ll learn at least one new thing from this list of the best free Excel tutorials and courses.
7 Best Free Excel Courses Online in 2021
Here are the best free Excel courses and tutorials you can take online. They were carefully selected for both beginners and intermediate users.
#1. Microsoft – Excel Video Training
Not an actual course per se, but you can learn the basics of Excel in these free video tutorials from Microsoft. It’s a great place to start since they are the proprietor of the tool.
I strongly believe learning how to use a tool from its owners is the best way to be introduced to a tool and it’s why I listed them here first, like I did in my post about the best Photoshop tutorials.
These Excel tutorial videos from Microsoft will introduce you to Excel, teach you rows and columns, cells, tables, charts and graphs, formulas, pivot tables and so on.
What you’ll learn:
- Intro to Excel
- Rows & columns
- Formulas & functionsTables
- Pivot Tables
- Share & co-author
- Linked data types
- Get to know Power Query
#2. Udemy – Excel 2019: From beginner to intermediate (MOS cert MO-200)
Udemy is arguably the most popular online course marketplace on the web. It caters to over 40 million learners with over 155 thousand courses and over 115 million minutes of videos.
While most of the courses on Udemy are paid, you can take this particular excel course absolutely free of charge. All you need to do is sign up for an account and enroll for free.
The course contains 24 sections, 168 lectures, and 12 hours of videos. It has been taken by 29,787 students and has a rating of 4.6 stars out of 5 from 1,698 ratings.
You’ll learn how to:
- Create, configure and save Excel worksheets and workbooks.
- Navigate through and format worksheets and workbooks.
- Customize options and views for worksheets and workbooks.
- Configure Excel worksheets and workbooks to print (e.g. page setup).
- Insert data into and format cells and ranges, and create and modify tables.
- Highlight, filter, sort and group cells, ranges, and tables.
- Create and format Excel charts.
- Insert and format objects, including modifying images.
- Create formulas in Excel, including using conditional logic and modifying text.
#3. Trump Excel – Free Online Excel Training
Trump Excel is a great resource for Microsoft Excel. Sumit Bansal provides useful Excel tips on his blog and creates both free and paid Excel tutorials. He’s so good Microsoft honored him with the Most Valuable Professional Awards 7 times.
This free Excel training from Sumit is perfect for beginners. It is divided into six modules, contains 26 lessons and 12+ hours of video.
Module 1 – Excel Basics (for Beginners):
- Lesson 1 – Getting Started with Excel
- Lesson 2 – Data Entry, Data Editing, and Number Formatting
- Lesson 3 – Data Formatting
- Lesson 4 – Working with Cells and Ranges in Excel
- Lesson 5 – Managing Worksheets
Module 2 – Excel Essentials:
- Lesson 6 – Introduction to Excel Tables
- Lesson 7 – Auto-fill, Custom Lists, and Flash Fill
- Lesson 8 – Number Formatting in Excel
Module 3 – Excel Formulas:
- Lesson 9 – Excel Formula Basics
- Lesson 10 – Logical Formulas in Excel
- Lesson 11 – Math Formulas in Excel
- Lesson 12 – Lookup and Reference Formulas in Excel
- Lesson 13 – Stats Formulas in Excel
- Lesson 14 – Text Formulas in Excel
- Lesson 15 – Date and Time Formulas in Excel
- Lesson 16 – Formulas Mix and Match (10 Examples)
Module 4 – Data Analysis:
- Lesson 17 – Named Ranges in Excel
- Lesson 18 – Data Validation in Excel
- Lesson 19 – Data Sorting and Filtering in Excel
- Lesson 20 – Using Conditional Formatting in Excel
Module 5 – Introduction to Excel Charting:
- Lesson 21 – Introduction to Excel Charting
- Lesson 22 – 10 Advanced Excel Charting Examples
- Lesson 23 – Dynamic Charts in Excel
Module 6 – Pivot Table and Excel Extras
- Lesson 24 – Overview of Excel Pivot Table
- Lesson 25 – Protection in Excel
- Lesson 26 – Introduction to Macros and VB Editor
#4. MotionTraining (YouTube) – Microsoft Excel for Beginners
“A comprehensive series of tutorials that will guide you through the basics of Excel and turn you into a confident spreadsheet user.”
This is a very comprehensive introduction to Microsoft Excel. It starts right from the overview of the software and then progresses to operations such as formatting, charting, IF, COUNTIF and SUMIF Functions, percentages, and so on.
The playlist contains 35 videos in total and has been viewed 621,626 times as of when this post was last updated.
- Get Started
- Calculations (Formulas)
- Functions (Formulas)
- Number Formats
- Formatting Pt.1, 2 & 3
- Charts Pt.1, 2 & 3
- Updating Calculations
- Percentages and Absolute References
- Conditional Format Update & Percentages
- Percentages – More Examples
- Using The ‘IF’ Function
- Using Nested ‘IF’ Functions
- Nested ‘IF’ Functions Pt.2
- COUNTIF and SUMIF Functions
#5. CFI: Free Excel Crash Course – Spreadsheet Tutorial for Finance
This free Excel course by the Corporate Finance Institute (CFI) is targeted at people who are already performing professional financial analysis and financial modeling but is also good for beginners who’d like a career in finance as it’s a refresher course.
While it focuses more on finance-specific formulas and models, you’ll learn all the tips, tricks, shortcuts, functions, and formulas you need to go from beginner to advanced. It also gives you a peek into the operations of financial analysts and investment bankers.
Corporate Finance Institute® (CFI) is a leading global provider of online financial modeling and valuation courses. Since 2016, CFI’s programs and certifications have been delivered to over 800,000 individuals at top universities, investment banks, accounting firms, and operating companies around the world.
What you’ll get from this course:
- Learn everything you need to know about Excel spreadsheets for a career in corporate finance and investment banking
- Master keyboard shortcuts, functions, and formulas to save time and speed up your modeling skills
- Follow industry-leading best practices; simulate on-the-job analyst training
- Stand out in an interview or move up the ladder at work by dramatically boosting your MS Excel skills and confidence
- Get an Excel Crash course certificate of completion
Other Posts on the Blog:
#6. Coursera – Everyday Excel, Part 1
Coursera is one of the most popular MOOCs platforms on the web. They have courses in virtually all disciplines and their courses are usually offered by universities and taken by professors and other subject experts.
This particular free Excel course is offered by the University of Colorado Boulder and is targeted at beginners without any prior knowledge of the spreadsheet program.
“”Everyday Excel, Part 1″ is aimed at learners who are seeking to learn Excel from the ground up. No experience with Excel is necessary. While this course is meant for beginners of Excel, advanced users will undoubtedly pick up new skills and tools.”
As at the time this post was last updated, the course has 4.8 stars from 1,383 ratings and has been taken by 114,558 learners.
What you’ll learn:
- Navigating Excel, editing the worksheet (including inserting/deleting cells, columns, and rows), and cell formatting.
- Expression entry and common Excel formulas (including logical functions, text functions, and financial functions).
- Data management (sorting, filtering, consolidating, removing duplicates, data validation, and one-way lookups).
- Data visualization (scatter plots, column charts, pie charts, Slicers, Sparklines, and Pivot Tables)
#7. GCFGlobal – Excel 2016 Basics
Yet another free Excel training course you can take to learn Excel online.
GCFGlobal offers free courses in a wide range of subjects that can help you improve your skills or build new ones.
“For almost 20 years, the GCFLearnFree.org program has helped millions around the world learn the essential skills they need to live and work in the 21st century.”
This free Excel course will introduce you to the tool and teach you how to perform some basic operations.
What you’ll learn:
- Getting Started with Excel
- Understanding OneDrive
- Creating and Opening Workbooks
- Saving and Sharing Workbooks
Working with Cells and Sheets:
- Cell Basics
- Modifying Columns, Rows, and Cells
- Formatting Cells
- Understanding Number Formats
- Working with Multiple Worksheets
- Using Find & Replace
- Checking Spelling
- Page Layout and Printing
Formulas and Functions:
- Intro to Formulas
- Creating More Complex Formulas
- Relative and Absolute Cell
Working with Data:
- Basic Tips for Working with Data
- Freezing Panes and View Options
- Sorting Data
- Filtering Data
- Groups and Subtotals
- Conditional Formatting
Doing More with Excel:
- Track Changes and Comments
- Inspecting and Protecting Workbooks
- Intro to PivotTables
- Doing More with PivotTables
- What-if Analysis
- Buying Office 2016
- New Features in Office 2016
- What are Reference Styles?
- More Resources
You can also test your knowledge by taking their quiz.
If you really want to learn Excel, you absolutely can. These free Excel training courses will help you get started. They are all free and self-paced.
You don’t need to enroll for all seven. Just go through the course outlines of each of them and enroll for the one that best satisfies your need or is closest.
The toughest part about learning anything is getting started. Once you start, you’d want to get better at it.
Go learn Excel with these free Excel courses!