![]() This Business Analytics course teaches you the basic concepts of data analysis and statistics to help data-driven decision making. You have also created an interactive To-Do-List with the help of the checkboxes.īoost your analytics career with powerful new Microsoft Excel skills by taking the Business Analytics with Excel course, which includes Power BI training. In this article, you have learned how to add a checkbox to your Excel worksheet. In the cell H12, enter the following formula: =COUNTIF($J$5:$J$9, TRUE).In the cell H11, enter the following formula: =COUNTA(G5:G9) to count the total number of tasks.In the cell I5, enter the following formula: =IF(J5,” Done”,” To Be Done”) and drag for all the cells below. ![]() You will have to manually link each checkbox one by one. It reflects the changes in the Task Completed and % Of Task Completed cell.įollow these steps to make this interactive To-Do-List:.The value of the cell linked to that checkbox changes from FALSE to TRUE. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |