Ben Richardson
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.
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 […]
FILTER Function – Master Excels Array Tools!
The FILTER function enables Excel users to filter data ranges. You can set your own criteria, and pull out […]
The RANDARRAY Function – Master Excel Array Tools!
Excel already had the RAND and RANDBETWEEN functions – so why make another? RANDARRAY is special, as it generates random […]
Where Is The Best Place To Work In The World? – Country Ranking
Few experiences enhance your professional expertise and strengthen your cultural awareness like living and working abroad. Learning how businesses […]
XMATCH Functions – Master Excels Array Tools!
Most people using Excel, have used the MATCH function. However, with more features and flexibility, the XMATCH function is much […]
UNIQUE Function – Mastering Excels Array Tools
The UNIQUE function is used to extract a range or array of unique values from a given array. The […]
Master VBA Special Cells In Excel! [Advanced Guide]
In this post, we are going to review the VBA Special Cells method in Excel. You can use the […]
SEQUENCE Function – Breakdown
SEQUENCE function is one of the most advanced and modern functions of Excel. It was introduced as a part […]
Making A Gantt Chart In Excel (Quick & Easy!)
In this article, we will look at how to create a Gantt chart in Microsoft Excel. Gantt charts assist with […]