As featured in

CHOOSE YOUR COURSE
POPULAR COURSES ENDORESED BY BUSINESSES, TEAMS & PROFESSIONALS
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 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.
Learn Financial Analysis
The reason most people fail at understanding financial analysis is that they fail to understand the fundamental concepts. Concepts such as debits and credits, journal entries, trial balance and how these connect to the income statement, balance sheet and cash flow.
Lock and Unlock Cells in Excel
Lock & Unlock Cells in Microsoft Excel
If you create spreadsheets for other people to use, you may have some experience with those people deleting or changing your
Excel TEXTSPLIT Function
Excel's TEXTSPLIT function can split words into separate cells. You can have multiple delimiters, you just have to know how to define these properly. You can also do amazing things like splitting into columns and rows and internally sorting words.
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.