Want to learn Excel for free? Then you’re in the right place.
Microsoft Excel is one of the most used software for analyzing and visualizing data. The vast majority of businesses use excel for analysis, reporting, finances, and accounting.
Beginner or intermediate, these free excel training and classes will help you master the program.
All courses listed here will need registration, but they are completely free. You’ll have free access to all training materials, videos, lessons, and tutorials.
One of the many advantages of online learning is the flexible schedule it offers. You are free to progress at your own speed. There are hundreds of free learning resources available where you can learn the software online.
But how do you choose the best ones?
We have collected the list of best 10 free excel training and classes that let you learn MS Excel at no cost.
1. Useful Excel for Beginners – Udemy
Overview:
In this Excel course, you will learn the fundamentals and become an effective user. The target audience for the course is those who have never used Excel before. It is a good start for all beginner level users. You would need a copy of Microsoft Excel for Windows since you will be practicing along with the course.
The files are available for download. Besides you can follow along with the videos while practicing. This Excel training covers the topics that are essential to becoming a functional user.
What you’ll learn:
Fundamentals of Excel, Spreadsheets
Duration: 9.5 Hours
Review: 4.4 / 5
Level: Beginner
Free / Paid: Free
Course: Register Here
2. Excel 2016 Essential Training – LinkedIn Learning
Overview:
This excel course will help you learn how to organize data and perform calculations. How to work with functions and multi worksheets. Format the appearance of your data and cells, build charts and PivotTables.
This excel training will go through functions and formulas at the start. As course advances, it will cover worksheets and workbooks. Additionally power functions, data management features, data analysis tools and PivotTables.
Lastly, you will be briefly introduced to the uses of Macros in Excel. You can register on this course with a 1-month trial and cover this course for Free.
What you’ll learn:
Microsoft Excel, Spreadsheets
Duration: 9 Hours
Review: 4.4 / 5
Level: Beginner, Intermediate
Free / Paid: Free
Course: Register Here
3. Excel Skills for Business: Essentials – Coursera
Overview:
In this Excel course, you will learn the essentials of Microsoft Excel. Over the course of six weeks, you will learn:
- How to expertly navigate the Excel user interface
- Perform basic calculations with formulas and functions
- Format spreadsheets, and create visualizations of data through charts and graphs.
If you are self-taught and want to fill in the gaps for better efficiency, this is a great choice. Even if you have never used Excel, this class will set you up with a solid foundation. In the end, you’ll become a confident user and develop more advanced skills.
Spreadsheet software is one of the most used software in workplaces across the world. Learning to operate excel means adding a valuable skill to your employability portfolio.
A number of quizzes and challenges are provided in this training. You’ll sharpen your skillset with practical tasks.
What you’ll learn:
Microsoft Excel, Spreadsheets
Duration: 18 Hours
Review: 4.9 / 5
Level: Beginner
Free / Paid: Free
Course: Register Here
4. Analyzing and Visualizing Data with Excel – edX
Overview:
Excel is one of the most used solutions for analyzing and visualizing data. It now includes improved visualizations and more sophisticated business logics.
In this data science course, you will get an introduction to the latest versions of these new tools in Excel 2016. The course was built by an Excel Product Team expert at Microsoft.
This training will develop your skills with Excel to manipulate, transform, analyze, and visualize data.
The course is for intermediate users. You are expected to be comfortable with pivot tables and charts, slicers and creating dashboards.
What you’ll learn:
- Gather and transform data from multiple sources
- Discover and combine data in mashups
- Learn about data model creation
- Explore, analyze, and visualize data
Duration: 18 Hours
Review: 4.5 / 5
Level: Intermediate
Free / Paid: Free
Course: Register Here
5. Free Excel Class – Formulas & Functions – Udemy
Overview:
For this class, students should have basic experience with the Excel environment. No knowledge of functions and formulas is required in this tutorial.
The course will cover the basics of excel functions and formulas. Manipulation of variables with functions, some mathematical formulas, and advanced excel formulas.
This course is great to familiarize yourself and practice with excel functions and formulas. Most importantly you will have to invest just 3.5 hours of your time.
What you’ll learn:
- Excel Formulas and Functions from scratch
- Work with Relative, Absolute and Mixed cell references
- Use of formulas with Excel Tables
Duration: 3.5 Hours
Review: 4.3 / 5
Level: Beginner
Free / Paid: Free
Course: Register Here
6. Excel VBA programming by Examples – Udemy
Overview:
This course will provide the foundation to understand VBA uses in Excel. Learn about Excel VBA syntax, Excel VBA forms and control methods.
Several workout examples will introduce the students to the Excel VBA for automation. This course is 4 hours long.
The lessons will cover no-coding automations. You will understand VBA syntax basics and data fetching from MS Access. Learn designing forms and connecting with MS Access database.
What you’ll learn:
- Automation of repetitive tasks. Developing VBA forms.
- Understand VBA syntax for Excel.
Duration: 4 Hours
Review: 4.3 / 5
Level: Intermediate
Free / Paid: Free
Course: Register Here
7. Excel Crash Course – Tutorial for Finance – CFI
Overview:
This course is for finance specialists, who look to learn or advance Excel skills for their field of work. In this free Excel training, you will learn all the tips, tricks, shortcuts, functions and formulas.
It’s for spreadsheet users who are already performing professional financial analysis and modeling. Or are looking to prepare for a wall street career.
This training course starts with the Excel basics. It progresses to a more advanced level where even experts will learn something new.
What you’ll learn:
- Cells, Formatting, Tables.
- Charts, PivotTables.
Duration: 3.5 Hours
Review: 4.5 / 5
Level: Beginner / Intermediate
Free / Paid: Free
Course: Register Here
8. Excel for Windows training – Microsoft
Overview:
Microsoft has a free Office 365 Training Center, where you can take free Excel training (along with other Office products).
MS Excel tutorial is divided into 14 parts, with each having several sections. The sections include article type post and a supplementary video.
The videos are short, mostly only 1 minute long. However, they still provide value, visualizing the specific function of excel.
This is a good place to check out if you are looking for specific function or formulas. Moreover, if you need quick help or assistance from the authors of Excel.
What you’ll learn:
- Cells, Formatting, Tables.
- Charts, PivotTables.
Duration: 1-1.5 Hours
Review: 4.3 / 5
Level: Beginner
Free / Paid: Free
Course: Register Here
9. Free Excell Lessons from Excel Exposure
On your journey to master Excel, this is a great resource to have in your bookmarks. Excel Exposure has a number of free and paid courses and testimonials.
We will focus on free courses, which offered by student levels.
Beginner Lessons cover:
- Introduction to Excel
- Basic Formatting Techniques
- Math & Statistical Functions
- Date & Time Functions
- Text Functions and more
Intermediate Lessons cover:
- Logical Functions
- Lookup & Reference Functions
- Naming Ranges and Cells
- Data Validation with In-Cell Drop-Down List
- Conditional Formatting
- Introduction to Pivot Tables
- and more.
Advanced Lessons:
- Information Functions
- Formula Auditing & Formula Evaluation
- Introduction to Macros & VBA programming
- Learn by Doing: Intro to VBA via Adding Charts Example
- Excel 2013: Data Model Tutorial
Duration: 3-4 Hours
Review: 4.5 / 5
Level: Beginner, Intermediate, Advanced
Free / Paid: Free
Course: Register Here
10. Free Excel 2016 tutorial by CGF LearnFree.org
This tutorial helps you learn formulas and charts, functions, format cells, and more. with your spreadsheets.
This training goes through basics like working with Cells and Sheets. How to insert and delete cells and cell content, drag and drop cells. All about formatting text in Excel.
You’ll learn:
- How to use PivotTables in Excel for stronger data analysis.
- To do more with PivotTables in Excel to better summarize data.
- How to use what-if analysis to answer different types of questions.
- All about using reference styles in Excel.
In the end, you can take a quiz and test yourself.
Duration: 2-3 Hours
Review: 4.3 / 5
Level: Beginner, Intermediate, Advanced
Free / Paid: Free
Course: Register Here
Here’s The Next Step…
Now I want to turn it over to you:
Is there a great free Excel training or classes you know… but don’t see it on this list?
Or maybe you have a question.
Let us know by leaving a comment below.
