There are a lot of resources to learn Microsoft Excel for free. Here is a list of 19 plus there are hundreds of free videos available on Youtube. Most of these offer beginner tutorials but some do get into advanced functions.
Where to Learn Microsoft Excel for Free
Kind of obvious, Excel for Windows training is a great way to learn how to use Microsoft Office Excel. It offers short tutorials and how-tos on spreadsheets layouts, functions, tracking, sharing, and more.
Free Microsoft Excel training includes;
- Intro to Excel
- Rows & columns
- Formulas & functions
- Share & co-author
The free Basic Skills Excel tutorial will get you started with Excel fundamentals. Even though it is a basic skills course you’ll still master many skills that professional Excel users are unable to use. Available entirely free as an e-book. The Basic Skills course contains the first 43 lessons from the Essential Skills course and will take most users 5 hours or less to complete.
Excel Exposure is a self-paced online Excel training course designed to help you learn more about the features and functionality of Microsoft Excel. The site includes free video lessons, tutorials, and information to help improve your Excel skills. There are both paid and free training available.
Excel 2016 from GFC
In this free Excel 2016 tutorial, learn how to create formulas and charts, use functions, format cells, and do more with your spreadsheets.
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. From Microsoft Office and email to reading, math, and more—GCFLearnFree.org offers more than 200 topics, including more than 7,000 free lessons, more than 1,000 videos, and more than 50 interactives and games, completely free.
Chandoo (Purna Duggirala) holds a master’s degree and the experience of training more than 5,000 students in various online & physical training programs. In addition to free basic Excel training, he also has regular, podcasts, and Youtube videos. More advanced classes are also offered for a fee.
There are 5 important areas on the screen above.
- Quick Access Toolbar: This is a place where all the important tools can be placed. When you start Excel for the very first time, it has only 3 icons (Save, Undo, Redo). But you can add any feature of Excel to Quick Access Toolbar so that you can easily access it from anywhere (hence the name).
- Ribbon: Ribbon is like an expanded menu. It depicts all the features of Excel in easy to understand form. Since Excel has 1000s of features, they are grouped into several ribbons. The most important ribbons are – Home, Insert, Formulas, Page Layout & Data.
- Formula Bar: This is where any calculations or formulas you write will appear. You will understand the relevance of it once you start building formulas.
- Spreadsheet Grid: This is where all your numbers, data, charts & drawings will go. Each Excel file can contain several sheets. But the spreadsheet grid shows few rows & columns of active spreadsheet. To see more rows or columns you can use the scroll bars to the left or at the bottom. If you want to access other sheets, just click on the sheet name (or use the shortcut CTRL+Page Up or CTRL+Page Down).
- Status bar: This tells us what is going on with Excel at any time. You can tell if Excel is busy calculating a formula, creating a pivot report or recording a macro by just looking at the status bar. The status bar also shows quick summaries of selected cells (count, sum, average, minimum or maximum values). You can change this by right-clicking on it and choosing which summaries to show.
In this course, you will learn the fundamentals of Excel and become an effective user. The target audience for the course is those who have never used Excel before and those who are beginner-level users. To learn Microsoft Excel for free you will need a copy of Microsoft Excel for Windows since you will be practicing along with the course. I use Excel 2010 for Windows in the videos but any version with Excel 2007 for Windows or later would work. Excel Versions prior to 2007 have a different user interface but concepts will apply.
As the course is targeting beginners, it has been developed to be very easy to follow. We will be working with data related to a book store in the exercises. The files are available for download and you can follow along with the videos while practicing.
The course covers the topics that you would need to know, to become a functional user. You can download the Table of Contents document from Chapter 1, to see all the topics the course will address. The course has 89 videos and runs for 9.5 hours. Since this is a free course, Udemy does not offer certificates anymore.
You’ll find everything you need to become an Excel Master, here on the Contextures website. Whether you like to learn by reading, watching, or doing, we’ve got something for you — Excel tips, step-by-step lessons, sample files, and videos.
Take free online Excel courses to improve your resume and advance your career. Learn how to analyze and visualize data using the latest Excel tools and reports with online courses from Microsoft and top schools and institutions.
The Excel Hero Blog contains hundreds of hours of fascinating, and fairly advanced Excel information and almost one hundred freely downloadable workbooks.
26 Lessons, 12+ hours of Free Excel Training (Videos) Absolutely FREE. No Sign-up Needed. Scroll Down and Start Learning. If you’re an Excel beginner (or an intermediate) and want to learn Excel, this is the perfect place for you to start. This page gives you access to a completely FREE Online Excel Training (26 video lessons with 12+ hours of learning). You don’t need to sign-up or do anything to get access to the course. Just scroll down and start watching the videos to learn Excel.
This wikiHow teaches you how to set up and use Microsoft Excel on your Windows or Mac computer. Very basic program training included.
Basic Free Excel training on this page with a free trial offer on their premium training.
Excelfunctions.net has been created to help you learn Microsoft Excel for free, including Excel functions and formulas. Excel provides us with many Built-In Functions, that are designed to perform specific calculations. These are listed in the ‘Formulas’ menu of the Excel ribbon. This website provides information and examples of each of the Built-In Functions and also shows you how to combine these functions with each other, and with the Mathematical Operators (+, -, *, /, etc.), to create Excel Formulas.
When you need Microsoft Excel help- whether it’s solving an Excel emergency or simplifying a task – MrExcel.com is there. MrExcel.com is an entire community of Excel gurus who are dedicated to helping you unleash the power of Excel.
Led by MrExcel himself, the community is always available to help you save time, create accurate, useful reports, and make you the hero of your company meetings. And unlike a software support hotline or an independent “Excel genius”, MrExcel.com can usually give you free, quick solutions through our Message Board. The MrExcel.com community is constantly checking for new questions and posting solutions. They’re passionate about making Microsoft Excel work for you.
Want to learn Microsoft Excel quickly for free? Looking for a fully illustrated tutorial? Using Excel 2019-2007? Want to learn the basics and more? Looking for free Excel training? Then this site is for you!
Learn Microsoft Excel for free with clear examples and bite-sized videos. Check out their guide on 222 keyboard shortcuts for Excel. Free Excel training resources include:
- 500 Excel formula examples
- 222 shortcuts for Windows and Mac
- 101 Excel Functions
- Excel Function Guide
- Excel Formula Errors
- Formula criteria
- Pivot Table Guide
- Pivot Table Examples
- INDEX and MATCH
- Excel Chart Types
- Conditional Formatting formulas
- Custom Number Formats guide
- Data Validation guide
- Nested IF examples
- Excel visual glossary
Free step by step example of creating advanced charts. In this tutorial exercise, we will assume that we run a blog and have software that gives us the number of monthly visitors. We would like to see the relationship between the numbers of articles published per month vs the total monthly traffic.
Another source of free Excel training videos and webinars, Improve Your Excel has numerous offerings and introduces topics like Excel Power Query and the VLOOKUP function. This is an older site.
If you wish to continue your MS Office training all the way you can get Microsoft Office certified as either a Microsoft Office Specialist (MOS) or Microsoft Office Master. Microsoft does use a third party to proxy the exams, locations differ based on location. Many locations are available in local libraries and some offer free vouchers for those who qualify.
Looking for more ways to expand our education? Check out our post about – a free college-level education.
Have you tried any of the training listed above? How was it? Did we miss how you learned Microsoft Excel for free? Let us know – contact us.