Skip to content

Excel Tutorial

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

    Show / Hide Rows or Columns Based on Drop-Down Selection | Pick Table From Drop-Down List

        In this video tutorial I demonstrate how to show/hide rows or columns or tables based on a drop-down list selection. This particular technique requires VBA code which I supply via the link above. Click here to download the featured file (including code). Video Table of Contents 00:00 – Introduction 00:49 – Create the data… Read More »Show / Hide Rows or Columns Based on Drop-Down Selection | Pick Table From Drop-Down List

      Dynamic Amortization Schedule Excel 365 Template | EMI Calculator with Repayment Schedule in Excel

          In this video I demonstrate how to build an amortization schedule in Microsoft Excel. An amortization schedule displays principle and interest payments for each month over the term of a loan. The schedule is fully dynamic in that it expands and contracts to display the correct number of rows for loan’s tenure. The functions… Read More »Dynamic Amortization Schedule Excel 365 Template | EMI Calculator with Repayment Schedule in Excel