How do I create a dropdown list with checkboxes on Mac excel?

[clairecat84]

I want to use a dropdown list where I tick off a list using checkboxes.

Each row in my spreadsheet is for a set client. I need to complete several tasks for each client and I want to be able to check each one off as I go along - ideally I'd like the cell to only show 4 of 7 tasks complete, or 7 of 7 etc. so I know when they are complete.

I currently use Trello for keeping the checklist for each client, but I'd like to have it all on excel, if possible, so I only need to update one system.