Do You Want to Get More From Excel? 

Watch the Video to see how you can Become Confident & Advanced in Excel

Take The Course

Advanced Excel skills are highly relevant in business

No matter which role you’re currently in or you’re planning to take on. Whether you’ll be in finance, consulting, IT, or project management, your advanced Excel skills will set you apart from the competition.

This course will help You build a strong foundation in Excel & to solve complex problems fast – Let me show you how.

  • Use my top 10 tips to save time
  • Learn the top 10 formulas for quick and dynamic analysis

The top 10 will increase your awareness of the most useful Excel features to work faster and smarter. Only when you know the extent and possibilities Excel offers you, only then are you able to handle any type of analysis with the best method. If you are already advanced in Excel, take this course as a means to “fill in the gaps”.

What Participants Say:

View the Rest…
Well explained, excellent material and topics. Definitely very helpful for my everyday work.
Steven Jackson
Very very helpful tips. Anyone who uses Excel should learns these to let them get more benefits of the embedded functionalities.
Sahar Mojtahedi
I like the presentation and the material covered. The files are very elegant and professional looking and the material covered is thorough and to the point.
Michael Diamond
I’m glad I took up these lessons. It was truly insightful and I have no doubts it will enhance overall proficiency with Excel. Thank you.
Surendran Appadurai

What is the difference between an Advanced Excel and Average Excel user?

An advanced Excel user is aware of the tools and features available and can apply the right tools for the right task, instead of relying on their go-to tools and making them work for every situation. Advanced Excel users, always find the optimal solution for every task, and they find it fast!

The way I picked this specific top 10 is purely based on my experience of what I’ve generally seen as “missing” knowledge by many Excel users. It’s difficult to define what being “Advanced in Excel” really is mainly because it means different things to different people depending on their interactions with Excel.  When you think of it, using one feature over another doesn’t mean it’s more “advanced”, it just means you have more alternatives and more options of doing things faster and this puts you one step ahead of the average Excel user.

What differentiates this Excel course from the others?

The reason I created this specific Advanced Excel course, is because there are many advanced Excel users who are unaware of key features & formulas in Excel. I understand that when you take an Excel training it can be so broad, and a lot of courses cover too many topics. It’s easy to get lost. You might also not immediately appreciate why some features are useful and how you can practically apply them. We are creatures of habit and it’s difficult to get our head around learning new techniques. As a result you might be missing out on some features that can majorly simplify the way you use Excel.

Differentiation factor #1

Focus – The top 10 brings focus to the key Excel features which will provide you with a solid & a strong foundation in Excel.

Differentiation factor #2

Learn by doing – This Advanced Excel course is well structured and organized. You can download my Excel Demo workbook which I use to demonstrate each feature and practice along with me. You can then do an exercise from the Excel Exercise workbook to test your knowledge. Real learning happens when you attempt to solve problems on your own. Answers are provided, but do ask any questions if you get stuck. Your questions will always be answered.

Differentiation factor #3

Engaging – I have made every attempt to keep the course interesting and engaging by mixing talking head explanations with screencast demos. Each course is split by topic & feature. This allows you to easily pick what you want to learn now or review later.


My main goal in this training is to increase your awareness of the top tools and formulas in Excel to help you solve complex problems. Users are not aware of what they don’t know. Only when you know the extent and possibilities Excel offers you, only then are you able to handle any type of analysis with the best method.

Becoming advanced in Excel takes practice, readiness to learn new methods and willingness to apply these to practical cases. Take this course to get a head start!

Take The Course

Not Yet Ready?

Get the eBook to the course instead! Subscribe to my Newsletter to get your FREE Excel Top 10 Tips and Formulas eBook. Although the PDF is supporting documentation to the online course, it works well as a stand-alone document. In addition, you will receive updates and discounts on new courses. Don’t worry, I hate spam! I only share what I think my subscribers will find valuable.

Advanced Excel Top 10 Tips and Formulas PDF Free Download

Related Blog Posts for Advanced Excel Tips & Formulas

Excel SCAN Function

Learn how to use the new Excel SCAN function! This function is a Lambda helper function. You can use it to "scan" a range and apply a calculation to each cell. In this example you'll learn how to use SCAN to get to-date values and how you can tweak it to return YTD values.

Percentile and Percentile Rank Calculation in Excel

Learn the meaning of percentile in introductory statistics and how to calculate Percentile in Excel. There are two functions: one is PERCENTILE.INC and the other PERCENTILE.EXC. I'll explain the difference and also how you can calculate PERCENTRANK in Excel.

Office 2021 new Features

Here's why you should upgrade to Office 2021 if you're on 2019 or 2016 (and for some reason you can't upgrade to 365). You get life-changing Excel functions like XLOOKUP, UNIQUE, FILTER, SORT and a lot more. I cover what you get when you upgrade in this post.

Excel Repeat blocks of Values x times

With this trick you can easily combine and repeat blocks of values together in Excel. You don't need copy pasting or complicated formulas. Just a tiny bit of Power Query. This keeps your solution dynamic too.

Power Automate with Forms

It's super easy to setup an automation in Power Automate to get notified when someone submits their answers in a Microsoft Form. You can also add a condition, so you get an email or mobile notification only when a specific answer is submitted.

Excel BYROW and BYCOL Functions

Find out how you can use the new Excel BYROW and BYCOL functions. These are called Lambda helper functions and they can help you save a lot of time if your analysis is based on a whole row or an entire column. Check out this practical example to find out more.