EMPOWER YOURSELF

BECOME THE GO-TO EXCEL 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.

Start Learning

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.

Combine Excel Sheets with Power Query

Can you easily combine & clean data from multiple Excel sheets into a single table or Pivot Table? You can easily get this done in Excel with Get & Transform (aka Power Query). Check out the full post.

Excel Conditional Bar Charts

Properly show the variance to previous period using conditionally formatted bar charts. There is a simple trick to getting the negative bars in a different color to positive bars. You'll also discover a bonus trick to conditionally format any bars based on a logic.

Excel Advanced Unpivot Techniques

You can easily use Excel Power Query to transpose a data-set with multiple row headers from multiple columns to rows. Find out how in this quick tutorial.

Excel IFS Function

The IF function is one of the most popular functions in Excel. But what about the IFS function? Does it really make writing nested IF functions easier? Let's find out.

Excel Filled Map Chart Using Power Query

Go from raw data to a filled map chart in Excel. Power Query will help summarize the data and make the whole process dynamic. Use Excel filled maps to create an impressive visualization for your reports.

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