Ravindra BagaleCourses & study guides मराठी Track your progress

Ravi Sir's Cards › Excel

To-Do List in Excel (card 1 of 2)

Revision card 1 for To-Do List in Excel: Number of tasks: =COUNTA(A6:A15) gives 10; Tasks done: =COUNTIF(E6:E15,TRUE) gives 3; Done %: =J7/J6 gives 30%. Includes an example data table.

Revision card 1 for To-Do List in Excel: Number of tasks: =COUNTA(A6:A15) gives 10; Tasks done: =COUNTIF(E6:E15,TRUE) gives 3; Done %: =J7/J6 gives 30%. Includes an example data table.
Card 1 of 2: To-Do List in Excel · Download PNG
Read card text

What this card says

1 for To-Do List in Excel: Number of tasks: =COUNTA(A6:A15) gives 10

Tasks done: =COUNTIF(E6:E15,TRUE) gives 3

Done %: =J7/J6 gives 30%. Includes an

Example

data table

Learn this in the lesson: To-Do List in Excel with Priority, Due Dates, a Done Checkbox and a Progress Bar

See all Excel revision cards