Skip to content

September 2020

Add Checkboxes to Excel Cells

    This video demonstrates how to add checkboxes to Excel cells.  A checkbox can be linked to a cell so that if it is ticked the cell receives the value TRUE and if unticked the cell receives the value FALSE.  The TRUE and FALSE values can be used to apply conditional formatting or within logical tests.… Read More »Add Checkboxes to Excel Cells

    Sum Between Two Dates in Excel | Sum Between Month and Years

      This video demonstrates how to sum between two dates in Excel.  In our scenario we want to calculate total revenue.  The functions used in this video are SUMIFS, EOMONTH and EDATE. Download the featured file here. The formula used is: =SUMIFS(Revenue_data[Revenue],Revenue_data[Date],”>=”&I2,Revenue_data[Date],”<=”&J2) One thing to note with this formula is how you create criteria that combines… Read More »Sum Between Two Dates in Excel | Sum Between Month and Years