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?
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.
Thousands of people visit excelexplained.com each month to get help writing more complex formulas or simply learning a new function they haven’t used yet.
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
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 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
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.