If the work schedule will be created by a manager and posted for employees to read, make sure the instructions also tell users how to read the finished sheet. Format the table.

For that, Google Sheets has a nifty function called Conditional formatting. Let’s use that first to make sure a task will be strikethrough when the checkbox next to it is marked, and thus completed.

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro. You ...