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 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.

Excel Add Text to Values

You can easily add text to your cell values in Excel. You don't have to do this manually. You have 3 easy options to choose from. The 3rd one will surprise you. You can use it in many other circumstances as well.

SUMIFS Multiple Criteria in a Single Column

Learn how to sum values based on multiple criteria in a single columns. You probably know that you can use SUMIFS to sum values based on criteria from multiple columns. But there is also an easy way you can sum values if your criteria is in the same column.

Office Scripts with Power Automate

Learn to combine Office Scripts with Power Automate so you can run your macros without opening your files. You'll learn how to create a script, how to loop through each sheet in the script and how to setup Power Automate to apply the script to every file in a folder.

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