Step 3: Now you have one check box with caption ‘check box 1’. Step 2: Go to cell B4 and having the cursor right on the top left corner of the cell click once. This is a similar icon that you get if you have to draw any shape like, square, circle etc. Step 1: Go to developer tab > Controls group > click Insert drop down > under form controls sub-group click check box icon. To add check boxes go through following steps: Check boxes are basically one of the form controls available in Excel.
You will have a new tab with the name Developer.Īs we have a developer tab with us, now we can add check boxes.
Step 2: From the dialogue box that appear in the list on the right, find “Developer” check box and check it. Step 1: Right click anywhere in the ribbon (better yet to right click on any tab) and select customize ribbon. But if you know the way you can find Developer Tab. Not getting it? Continue reading 😉 Opening the gates to Oasis! – Discovering Developers tab!īy default you don’t see this tab among others. Later I will use the check boxes (that I still have to insert) and the days mentioned to calculate the days. I intentionally left one column blank and then listed the time in days I require to finish one area of the syllabus. I have listed down all the chapters/topics I have to cover. So how is that all done lets learn and excel at something new in Excel today! And in the end I also have a mini calculator that lets me know if I can still relax or I have to schedule some make up classes to finish the course by specific date as it tells me exactly how many days/hours I have to manage. Well yeah they are cool and in addition to that I applied conditional formatting that makes cell changes its color when the relevant box is checked. Now I can check the topics I have covered so far and next time I open the fine I instantly know what to do next! Following is a snapshot of one of my chapters to-do lists (for ACCA F2 Management Accounting to be specific) So until recently I used to make a list and have to confess all of them were on drafting pad (because I live to that draw dark line to mark the work done!) but since I started Excel tutorials I made all those lists in Excel. And if you are also the one who likes to strike a line or tick or dash or mark then this tutorial is for you.Īs I teach ACCA and other professional qualification students and at the same time teaching several subjects it is hard for me to remember what chapters/topics we have done so far. The ones who like to plan adores to-do lists as well.
0 kommentar(er)
