Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

Learn how to control Excel worksheets with spin buttons, scrollbars, option buttons, and checkboxes.

Microsoft Excel sorts slider buttons alphabetically and numerically. Fortunately, you can add a custom sort list to sort the buttons in a more meaningful way, when necessary.

Follow the Record Macro instructions (4, 5, 6 under Macro1 above) to create this next macro. Name the macro Macro3 and use Ctrl+ J for the shortcut (you can create a button on the Ribbon menu later).

When collaborating in Excel, sometimes the collaboration can be distracting. Here's how to make a static image so you can do your own work without interruption.