EMPOWER YOURSELF

BECOME THE GO-TO SPREADSHEET EXPERT AT YOUR COMPANY

START NOW

As featured in

CHOOSE YOUR COURSE

POPULAR COURSES ENDORESED BY BUSINESSES, TEAMS & PROFESSIONALS

POWER Excel Bundle (POWER QUERY & DAX)

Busy analyzing lots of data? You need the Power bundle.

Get Package
Financial Analyst Course Thumbnail

Fundamentals of Financial Analysis

When You Can Speak the Language of Finance, You Give Yourself an Unfair Advantage in Your Career.

Join Now
Excel Essentials Course Thumbnail

Excel Essentials for the REAL World (Get Started Right)

Become Confident. Learn Excel from Scratch or Fill in the Gaps.

Join Now

Google Sheets – The Comprehensive Masterclass

Go from Beginner to Expert with this hands-on course.

Join Now

Master Excel VBA & Excel Macros

Automate your work. Real-World Projects included.

Join Now

Black Belt Excel Package

Master it all. Become the Go-To Excel Expert at your work.

Get Package
VIEW ALL COURSES

We Have Taught Professionals from 300+ Companies Including

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

LATEST TUTORIALS

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

Bulk Import PDF Files to Excel

Use this button you already have in Excel to bulk combine and import PDF files to Excel. Forget copy-paste, manually typing values or using 3rd party tools. Get it dynamic too so you just need to drop a new PDF in a folder and the PDF data is immediately imported to Excel.

Excel Organizational Data Types

Organizational data types allow you to create your own rich custom data types in the Excel Ribbon. Technically you‘d create them in Power BI and have them show up in the Excel Menu of your team members. This tutorial show you what organizational data types are and you can set them up from scratch.

Excel VSTACK Function

This is a real-life example of Excel's VSTACK function. Quickly stack data from multiple sheets (even as many as 15 sheets!), filter out blank cells and even sort the summary table.

Excel Pivot Table Date Grouping

Handling dates in Excel Pivot Tables can get tricky. How can you quickly ungroup the dates? Or get your own custom grouping for fiscal periods? How can you show all the dates including the ones with no values? This tutorial covers it all!

Excel LOOKUP Function

The lookup function is the simplest function in Excel. It can return exact or approximate matches and it's super easy to write. Yet many people prefer VLOOKUP because it's easier to understand. In this tutorial, I'll explain the LOOKUP function by using a simple, followed by a more complex example.

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