EMPOWER YOURSELF
BECOME THE GO-TO EXCEL EXPERT AT YOUR COMPANY
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.
I need to become
Confident with formulas
Learn the 10 Essential Excel formulas with my free 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.
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.
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.