Skip to content

Automated Attendance Sheet in Excel with Formula | Download Attendance Sheet Template

    This video tutorial shows you how to create an attendance sheet in Excel. Watch the video above and download the featured file using the link below. Download the featured attendance worksheet here Excel Automated Attendance Sheet – Overview Month and Year Selection: Drop-down menus for choosing the month and year. Dynamic Date Display: Automatically adjusts… Read More »Automated Attendance Sheet in Excel with Formula | Download Attendance Sheet Template

    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