Excel Compass

Excel tips, tricks, and automations

  • Process Step Tracking with Dynamic Checkboxes in Excel

    Create a dynamic and configurable checkbox list to track process steps that displays the next step to a user only after the prior step is marked completed. Use Case: A user is presented with instructions for the first step of a process on a worksheet along with a checkbox. When the step is complete the…