Formulas & Automation
Learn the Excel hacks, shortcuts, and tricks of the trade that enable you to slash hours out of monotonous tasks.
The magic of the CONCATENATEX function in Power BI
Uncover the power of CONCATENATEX in Power BI to enhance reports with visuals, itemised breakdowns, and simplified calculations.
Achieving the zero-click dream with Office Scripts and Power Automate
Create dynamic workflows with Office Scripts and Power Automate by automating tasks that require no manual intervention.
Ditch PivotTables — unlock the power of GROUPBY and PIVOTBY
Transform your reporting with a more flexible alternative to traditional PivotTables that involves just a single formula.
Writing powerful custom functions with LET and LAMBDA
Learn the basics of LET and LAMBDA to give you a framework for building complex but easy-to-use functions.
Discover how to create a wizard using VBA, involving a multi tab userform created from scratch with all the VBA shown.
Explore our Team Training Offer
Our CPD-accredited training programs are designed to enhance productivity and streamline operations. Fully customizable to align with each organization’s unique needs.