Skip to content

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