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