Ben Richardson
Bio
Ben is a director of Acuity Training which he has been running for over 10 years.
He is a Natural Sciences graduate from the University of Cambridge and a qualified accountant with the ICAEW.
He previously worked as a venture capitalist and banker and so had extensive experience with Excel from building financial models before moving to learn SQL, Microsoft Power BI and other technologies more recently.
[Detailed Guide] SQL Update Statement
This article explains how to use the SQL UPDATE statement for updating table rows in SQL SERVER. It looks at […]
Mastering The SQL IF Statement
In this article, you will see how to use the SQL IF statement for the conditional execution of your SQL […]
Learn To Use XLOOKUP [2 Full Examples!]
It’s time we introduce you to the new member of the modern function family of Excel – the XLOOKUP function. […]
The Ultimate Guide To Using Send Email In Power Automate
Power Automate allows you to automatically send emails when certain things take place. Although not all emails can be automated, […]
3 Quick Ways To Recover Unsaved Files [Excel 2024]
We’ve all been there – working on an Excel file, only to have it disappear after a crash! Panic […]
How Do Until Loops Can Help You – Power Automate
There is often a need to execute certain actions or instructions repeatedly. This can be achieved by using loops in […]
Create And Personalise Your Excel Dashboard!
In this tutorial, we will take you through the steps needed to create an Excel Dashboard. We will also review […]
The EFFECT Function – Master Excels Financial Tools!
Interest computations are not always as simple as an equation of two plus two. In fact, compound interest calculations […]
The PMT Function – Master Excels Financial Tools!
Excel’s financial functions are here to help you with your daily finances. The PMT function is all about calculating […]
Collections In VBA – The Ultimate Guide
If you have ever used VBA, you’ve used Collections. They are an object that can store multiple values. If […]
VBA Class Modules: A Step By Step Guide
VBA Class Modules let you create your own custom objects. You can then combine this with object-oriented programming tools. […]
The COUNTA Function – Use It In Your Own VBA Code!
In this post, we will review how to use the COUNTA Function in your VBA code. Excel allows you to […]