Improve your Excel skills

Hey, I’m Radu, and since 2017, thousands of people have benefited from my free Excel lessons. My only question is, will you be next?

My Excel Background

Over the past 15 years, I have been using Microsoft Excel in my day to day job. I’ve worked as an investment and business analyst, and Excel has always been my most powerful weapon. Its flexibility and complexity make it a highly demanded skill for finance employees.

I must admit that working with Excel hasn’t always been pretty. I remember that back in the days I used to struggle with basic formulas like VLOOKUP or SUMIF. But when I’ve realized what Excel can do with just a little bit of training, I decided to pursue my goal of learning as much as possible. And that’s exactly what I did for the last 15 years.

Now I want to pass this knowledge on to you. And the best part is that I’ll do it for free. There are no strings attached. Just subscribe to my email lessons and start learning whenever it’s convenient for you.

Hundreds of thousands of people visit excelexplained.com each year to get help, learn to write more complex formulas, or simply learn a new function they haven’t used yet.

Start working smarter in Excel!

Countif

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 the article

Index & Match

Understand how to use INDEX, MATCH, and INDEX + MATCH together. This will take your lookup skills to a more advanced level, providing a great alternative to the VLOOKUP function. Read the article

Vlookup

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

Learn how to use IF function in Excel using easy-to-follow examples. Expand your knowledge by writing nested IF functions for even complex formulas. Exercise file available for download. Read the article

Frequent Questions

Are these lessons really free?

Yes, the content available on excelexplained.com is completely free. I do recommend that you subscribe to 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 email number to a minimum. You can expect to receive one or two emails per week.

What is your best Excel advice?

Focus on the most used Excel functions and start learning keyboard shortcuts. It may prove difficult at first, but it will save you a lot of time in the long run, and your productivity will increase exponentially.

Do I need the latest Excel version?

Using Office 365 or the latest standalone version available is always preferable, but most of the functions described in the lessons are available starting with Excel 2007.

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. I reply to every message that I receive.