blog

Top Websites to Learn Microsoft Excel Online

Best Resources to Learn MS Excel Online for Free

Microsoft Office Suite is a handy tool. Its uses are for writing, editing, presentation and calculation work.

Microsoft Excel is no doubt a multi-utility platform. It is used for a wide range of purposes by analysts, bankers, marketers, and accountants. Business schools too impart training in Excel. The internet has a wide range of MS Excel tutorials. It instructs you on its efficient usage. These tutorials will give you an in-depth knowledge of Microsoft Excel.

We have listed some resources to benefit you. These websites will teach you essential data management and analysis skills.

1. Microsoft Excel Help Center

Microsoft Excel Help Center is the best platform to learn excel online. It is an official website of Microsoft. A collection of tutorials will help you to learn MS Excel. Topics in the tutorials cover Data formats, Pivot Tables etc.

Tutorials are available on mail merges. In addition, you can choose the guides relevant to your current needs. Most importantly, some tutorials contain practical experiments. This enables you to get a hands-on experience.

Some of the featured topics dealt with in the website are,

  • Move or copy worksheets or worksheet data
  • Save a workbook in another file format
  • Dropdown list
  • Freeze panes to lock rows and columns
  • Calculate the difference between two dates
  • List of all Excel functions available
  • How to avoid broken formulas
  • IF function
  • Access support for excel
  • VLOOKUP function
  • SUM function

“Ask The Community” platform provides solutions to queries.

Learn From – Microsoft Excel Help Center


2. GCF LearnFree.org

GCF LearnFree.org has one of the most detailed free resources to learn Excel online. It offers 29 tutorials and an addition of five tutorials. Besides, you will learn Excel basics and advanced lessons. In addition, the instructions come in simple terms for you to practice. Further, you will get a quiz at the end of the tutorials. This will assess your knowledge.

Some of the topics covered in the website include the following,

a) Excel 2016 Basics

  • Getting started with Excel
  • OneDrive
  • Creating and Opening Workbooks
  • Saving and Sharing Workbooks

b) Working with Cells and Sheets

  • Cell Basics
  • Modifying Columns, Rows and Cells
  • Formatting Cells
  • Number Formats
  • Working with Multiple Sheets
  • Using Find & Replace
  • Checking Spelling
  • Page Layout and Printing

c) Formulas and Functions

  • Introduction to Formulas
  • Creating Complex Formulas
  • Relative and Absolute Cell References
  • Functions

d) Working with Data

  • Basic Tips for Working with Data
  • Freezing Panes and View Options
  • Sorting Data
  • Filtering Data
  • Groups and Subtotals
  • Tables
  • Charts
  • Conditional Formatting

e) Additional Advantages

  • Track changes and Comments
  • Inspecting and Protecting Workbooks
  • Intro to PivotTables
  • Advanced instructions in PivotTables
  • What-if Analysis

Learn From – GCF LearnFree.org


3. Excel Exposure

Excel Exposure is another best resource to learn excel online. It has a free online training course with links to video lessons. It covers topics like conditional formatting, error checking and macros. It deals with advanced concepts too.

Complicated issues tend to split into simple terms throughout. This makes even Visual Basic for Applications (VBA) easy to learn. Notably, Excel Exposure has a large group of followers. The lessons split into Beginner, Secondary and Advanced levels. A section on Excel 2013 too is available.

Learn From – Excel Exposure


4. Chandoo

Chandoo too is a vibrant platform to learn MS Excel online. You can begin with the fundamentals and move on to advanced topics. In addition, it has over 450 articles and tutorials on MS Excel. You will learn conditional formatting and create reports at a faster pace. Tips found on this website come from forums. Solutions to formulas, formatting, shortcuts, pivot tables, etc find their way here.

Topics having elaborate explanations are,

  • Excel Basics
  • Advanced Level
  • Pivot Tables
  • Project Management and
  • Top 10 Excel Features

In addition, some of the Formulas dealt with in this website are,

a) Basics

  • IF
  • CHOOSE
  • SUMFIS
  • VLOOKUP and
  • SUBTOTAL

b) Advanced

  • SUMPRODUCT
  • INDEX
  • Multi-condition Lookups
  • Array Formulas and
  • Top Formulas for Analysis

Besides, a section on Excel VBA proves to be helpful.

Learn From – Chandoo


5. Excel Central

Excel Central is a noteworthy free site to learn MS Excel online.
Four versions of programs are available.

Learn From – Excel Central


6. Contextures

Contextures provides you a great way of learning Excel online for free. It has everything you require to become a master in Excel. Added to this, a variety of lessons, sample files, and videos help you. Tips and tutorials are available for free.

The tips and tutorials search occur in an indexed order.

The Sample Excel Files contains categories such as,

  • Data Validation
  • Filters
  • UserForms, VBA, Add-Ins
  • Conditional Formatting
  • External Data
  • Dashboards
  • Charts and Graphics
  • PivotTables
  • Functions
  • Scenarios
  • Comments and
  • Unblock Files

Learn From – Contextures


7. Excel Hero

Excel Hero is the best website to learn MS Excel online. It is an excellent resource for beginners. Many of the workbooks are available for download.

Among other things, you will learn,

  • Excel Formulas
  • Animated Business Charts
  • Excel Optical Illusions
  • Filling PDF Forms from Excel
  • Using XML inside Excel

Excel Hero’s blog gives additional information.

Learn From – Excel Hero


8. Mr. Excel

Mr. Excel is another noteworthy site to learn excel online. It includes a variety of tips and tricks that will help you to learn excel. Besides this, free webinars guide you further. This will help you to get insights into the featured topics.

In addition, the site appears in subject sequences. Besides, Mr.Excel.com expert group can answer questions of the users. The site has a library of essential Excel books and tutorials.

Learn From – Mr. Excel


9. Improve Your Excel

It is another important source to learn Microsoft Excel online. It has free videos and webinars that will improve your knowledge of Excel.

Added to this, it deals with various topical categories such as,

  • Data Validation
  • Excel Features
  • Graphs
  • Hyperlinks
  • Excel Counting Functions
  • Pivot Table
  • power Query
  • Excel Functions
  • Working With Data
  • Power Map

In addition, it introduces topics such as the VLOOKUP function.

Learn From – Improve Your Excel


Also Read: 
Career Scope of Advanced Excel


10. Excel Easy

Excel Easy is one of the easy resources to learn Excel online. Beginners will find it to be helpful. The website contains six essential topics. The introduction deals with subjects such as Range, and Formulas and Functions.

The Basics deal with subjects such as,

  • Ribbon
  • Workbook
  • Worksheets
  • Format Cells
  • Find & Select
  • Templates
  • Data Validation
  • Keyboard Shortcuts
  • Print
  • Share and
  • Protect

Functions deals with subjects such as,

  • Count and Sum
  • Logical
  • Call References
  • Date & Time
  • Text
  • Lookup & Reference
  • Financial
  • Statistical
  • Round
  • Formula Errors and
  • Array Formulas

Data Analysis deals with subjects such as,

  • Sort
  • Filter
  • Conditional Formatting
  • Charts
  • Pivot Tables
  • Tables
  • What-If Analysis
  • Solver and
  • Analysis ToolPak

VBA deals with various subjects including,

  • Create a Macro
  • MsgBox
  • Workbook and Worksheet Object
  • String
  • ActiveX Controls and
  • Userform

An additional of 300 examples prove helpful.

Learn From – Excel Easy


11. ExcelJet

ExcelJet is the best online site to learn Excel Shortcuts for Windows and Mac. Quick reference for keyboard shortcuts prove to be user-friendly. You can jet through a program without using the mouse.

The following have shortcut navigations,

  • File
  • Ribbon
  • General
  • Tables and Filters
  • Drag and Drop
  • Navigation
  • Selection
  • Active Cell
  • Extend Selection
  • Select Special
  • Cell Edit Mode
  • Entering Data
  • Formatting
  • Number Formatting
  • Borders
  • Formulas
  • Gird Operations
  • Pivot Tables
  • Workbook
  • Dialog Boxes, etc.

Learn From – ExcelJet


12. Annielytics

Annielytics is one of the most genuine sites to learn Excel online. This site by Annie Cushing proves helpful. Annie is a web analytics data expert.

Videos and tutorials on Excel in this site are informative.

Learn From – Annielytics


13. EdX Excel Courses

EdX is a most useful platform to learn Excel. Below are some links to learn Excel from EdX,

Data Analysis & Visual with Excel
Microsoft Excel for the Data Analyst
Introduction to Data Analysis using Excel
Analyzing and Visual Data with Excel
Essential Statistics for Data Analysis using Excel
Data Analysis: Visual and Dashboard Design

You can learn most of the above courses in a self-paced manner.

Learn From – EdX


14. Khan Academy

Khan Academy is one of the best sources to learn MS Excel online. It includes many video-tutorials on MS Excel. Instructive videos solve queries on Excel. Khan Academy offers ample free training courses. These courses are on varying subjects.

Learn From – Khan Academy


15. The Spreadsheet Page

The spreadsheet page is an online excel tutorial which provides extensive tutorials and books on Microsoft Excel. This website is handled by John Walkenbach. He is written more than 60 books for the users. Besides, he has written 300 articles about MS Excel. Therefore, you will get the examples of custom number formats, which you can play with and tweak on your own time. It also helps you to get familiar in Microsoft Excel.

Learn From – SpreadSheet Page


16. Excel Bytes:

Excel Bytes is a website which is handled by Microsoft Excel specialist Mike Rempel. From this resource, you can get the free video tutorials and tips about Microsoft Excel. It also contains a collection of different how-to tutorials.

Learn From – Excel Bytes


17. Excel Functions.Net

Excel Functions.net is a reliable resource to learn MS Excel online. It has a collection of tutorial and tips about MS Excel. It will help you to learn the basic excel functions & formulas, pivot tables, macros, VBA, etc.

Learn From – Excel Funtions.net


18. Best Excel Tutorial

Best Excel Tutorial is a complex and completely free resource for learning MS Excel through online. It explores database functions with the most common function you would ever utilize when creating or mining a database. Besides, you will get essential tips and tutorials on Microsoft Excel.

Learn From – Best Excel Tutorial


19. Home And Learn

This is a free resource which helps you to learn about the Excel VBA. In this tutorial, you will learn how to create your own macros. It also helps you to take your Excel skills into the next level and establish yourself ahead of the competition.

Learn From – Home And Learn

Above guidance to learn Excel online will definitely enrich your scope. Go through the Excel lessons to master your craft.

Learn MS Excel from Industry Experts


Leave a Reply