I've helped thousands of people improve their Excel skills for free.

During the last years thousands of people have benefited from the free Excel lessons. It doesn’t matter if you are just starting out or if you are an experienced user. I am confident you can improve your skills and perform more complex tasks after you go through these tutorials.

Start working smarter and faster in Excel!

Microsoft Excel 2016

I use the latest version of Microsoft Excel, but the tutorials apply to older versions as well

Beginner Friendly

All the lessons are explained so that even new Excel users can understand them.

Short and to the point

Step by step instrunctions on how to use different Excel functions and achieve the desired result.

The best part? It's FREE

It's costs you nothing to access the lessons. You will never have to pay to access the tutorials.

Example formulas

If you want to take your Excel skills to a new level, you have to learn how to use INDEX And MATCH, combine multiple functions and write complex formulas. Read more…

If you are looking to create a breakdown of yearly sales based on a list of transactions you can use the SUMIFS function. Read more…

If you need to calculate subtotals based on item type (or whatever common criteria), you can easily do so using the SUMIF function. Read more…

To identify a VAT rate based on a simple tax rate table, you can use the VLOOKUP function. For this example I have also used a Data Validation List. Read more…

Counting cells that equal to a specific value can be achieved using COUNTIF function. If you need to use multiple criteria if your formola then you can use COUNTIFS. Read more…

Excel allows you to easily count the number of cells with values between two dates by using the COUNTIFS function. Read more…

Learn how to change text case to UPPER, lower or Proper format and combine text from different cells to obtain the desired result. Read more…

Learn how to find duplicates in Excel. Perform the check in the same column or compare two different sheets, using conditional formatting or formulas. Read more…

Popular functions

Step by step instructions on how to use COUNTIF function in Excel. You can also download the example workbook which contains practical examples on how to use COUNTIF. Read more…

From the basic SUM function to the versatile SUMIFS, this article covers a wide range of examples, including the use of drop down lists created using Data Validation. Read more…

VLOOKUP is used to lookup and retrieve data from a specific column in a table. It support approximate and exact matching, with extra flexibility provided by the use of wildcards (* ?). Read more…

Excel’s EOMONTH function returns the last day of a month, N months in the future or the past. EOMONTH can be used in formulas to retrieve specific dates (e.g. 7 days before the month end). Read more…


Frequently Asked Questions

Are these lessons really free?

Yes, the content available on excelexplained.com is completely free. I do recommend that you subscribe for the weekly lessons via email since it will help you stay on track.

How often do you send the emails?

I hate spam as much as you do, so I will keep the emails number to a minimum. You can expect one or two emails per week.

What is your best Excel advice?

Learn the keyboard shortcuts. It may be difficult at first but it will save you a lot of time in the long run and your productivity will skyrocket. I have created a comprehensive list of over 200 Excel keyboard shortcuts to help you out.

Do I need Excel 2016?

Using the latest version available is always preferable, but most of the functions described in the lessons are available starting with Excel 2007 (or even earlier versions). 

How long does it take to complete each lesson?

Most of the articles will take you less than 10 minutes to read. However, I do recommend that you download and study the exercise files as well.

What if I struggle and I don't understand something?

I do my best to explain each function. However, if you are having a hard time understanding a function please leave a comment on the article or send me an email and I will do my best to help you out.

Copyright © 2017-2020 ExcelExplained.com