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.

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.

Excel – Interactive Dashboard Trick

With Pivot Charts in Microsoft Excel you can add slicers to add interactive functionality to your dashboards. But what about adding even more interactivity? You could give the user the ability to change the relevant KPI in the chart from the slicer.

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