Learn Excel Online

Learn Excel Online

Everything you need to know to get started with Microsoft Excel.

Trusted by more than 10,000 teams worldwide

Start for free

Resources

Working With Excel Dynamic Arrays resource cover image

Working With Excel Dynamic Arrays

Excel dynamic arrays have changed the way we use all functions and formulas in Excel for the better. Learn about it in this article.
Excel Challenge 13: Use Partial Match to Find Multiple Criteria resource cover image

Excel Challenge 13: Use Partial Match to Find Multiple Criteria

Can you filter in Excel using multiple criteria and wildcards? Test your skills by stepping up to this challenge!
Waterfall Charts in Excel - A Beginner's Guide resource cover image

Waterfall Charts in Excel - A Beginner's Guide

A waterfall chart is one of the most visually descriptive charts supported in Excel. Learn how to create your own.
Excel Challenge 12: Methods for Splitting Cell Values resource cover image

Excel Challenge 12: Methods for Splitting Cell Values

In this challenge, we are experimenting with different methods of splitting data in Excel. How many methods do you know? Which method is most efficient?
Excel Challenge 11: Design an Interactive Selection Form resource cover image

Excel Challenge 11: Design an Interactive Selection Form

Can you use data validation to minimize or eliminate selection errors? Test your skills with this Excel challenge!
How to Use the Excel SEARCH Function resource cover image

How to Use the Excel SEARCH Function

The Excel SEARCH function is meant to help you look for something within a specific text string. Learn about it here.
How to Use the COUNTIFS Excel Function resource cover image

How to Use the COUNTIFS Excel Function

COUNTIFS determines the number of occurrences by comparing each range with its respective criterion. It then counts how many rows match all the stated criteria.
How to Use the Excel RIGHT Function resource cover image

How to Use the Excel RIGHT Function

The Excel RIGHT function might be just the thing you need, when you want to extract data from the end of a string. A video and free exercise file are included.
How to Use the Excel LEFT Function resource cover image

How to Use the Excel LEFT Function

When you want to extract some values from one location in Excel without copying all the cell’s contents, the Excel LEFT function might be the thing you need.

How to Lock Cells in Excel resource cover image

How to Lock Cells in Excel

You can protect data in Excel at different levels. Learn how to lock cells in Excel.
Excel Challenge 10: Automating Repetitive Tasks With Macros resource cover image

Excel Challenge 10: Automating Repetitive Tasks With Macros

In this challenge, you get to build your first simple macro in Excel by automating a repetitive report! Can you solve this challenge?
How to Alphabetize in Excel resource cover image

How to Alphabetize in Excel

Learn how to alphabetize in Excel to sharpen your sorting skills and keep your data organized. Master alphabetizing in Excel, simple to advanced methods.