How Much Carpet and How Much Grass?

Although Excel has 350+ functions built-in, you can use VBA to build your own custom functions. A couple of months ago, I delivered a 1-hour live online training session called VBA 101. It was a gentle introduction to VBA in Excel – what it is, how it can be...

What are User Defined Functions?

In April 2012 I delivered a 1 hour webinar called “Excel Macro Magic” in which I demonstrated how the power of macros and VBA can be used to automate tasks and enable Excel to achieve the impossible. The webinar was recorded and the short clip below was...