Skip to content

Convert Numbers into Words in Microsoft Excel – With or Without Currency | VBA Included in Download

    In this Microsoft Excel video tutorial I explain how to convert numbers into their words equivalent. You can do this using a VBA custom function. A version of this function is available on Microsoft’s website: https://support.microsoft.com/en-us/office/convert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd55d98 I found this version of the function, although very good, had some spacing and wording issues; it also only… Read More »Convert Numbers into Words in Microsoft Excel – With or Without Currency | VBA Included in Download

    Free Online Automated Attendance Tracker Template in Google Sheets | Online Attendance Register

      In this Google Sheets video tutorial I demonstrate how to use and improve Google Sheets free online attendance tracker template. The Google Sheets attendance tracker template is pretty good out of the box but there are significant improvements that can be made. The improvements I make to the template are: I automate the dates that… Read More »Free Online Automated Attendance Tracker Template in Google Sheets | Online Attendance Register

      Apply Icon Sets Based on Another Cell in Excel | Based on Formula (IS TRUE) | Comparing Columns

        In this Microsoft Excel video tutorial I explain how to apply conditional formatting icon sets based on an adjacent cell. To achieve this you will need to use a formula in the cells that you want to display the icons in. Click here to download the featured file. Video Table of Contents 00:00 – Introduction… Read More »Apply Icon Sets Based on Another Cell in Excel | Based on Formula (IS TRUE) | Comparing Columns