EMPOWER YOURSELF

BECOME THE GO-TO SPREADSHEET EXPERT AT YOUR COMPANY

START NOW

WHERE DO YOU NEED TO IMPROVE?

I’m not sure which

Skill to Improve First

Find your ideal course with this quick Quiz. It takes less than a minute.

Take the quiz

I need to become

Confident with formulas

Learn the 10 Essential Excel formulas with my free eBook.

Get ebook

We Have Taught Professionals from 300+ Companies Including

LATEST TUTORIALS

Learn a new Excel tip or trick every week. You’ll also find some PowerPoint tips and Accounting articles here.

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.

See more

LOOKING FOR SOMETHING SPECIFIC?

HAPPY STUDENTS FROM 135 COUNTRIES

★★★★★ “The instructor’s explanations and referencing real-world situations are just what is needed to understand how these formulas can help you work smarter.” Keith

★★★★★ “Lots of tips and techniques. Already using them in my own work!” Alison

★★★★★ “It was just what I needed! Definitely a great hands on way for someone with existing excel skills to pick up great “hacks” for excel.” Teo

Get my Excel Tutorials & updates from me, directly to your Inbox:

You can expect to hear from me on a monthly basis. Unsubscribe anytime.

We pass on your support

By investing in your education through our courses, you give children in remote areas a chance for a better future.

Learn more