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

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

Advanced list solutions are easy thanks to Excel's Table object. If you need a dynamic list, try one of these techniques.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

This article will teach you how to create drop-down lists in Microsoft Excel using a feature called Data Validation. When applied, the Data Validation function serves to restrict data that can be ...

Create a Menu — In this brief tutorial, I explain how to create a menu that contains a handful of frequently used commands. (I use Word in this tutorial; the procedure is nearly identical with Excel ...

For even the most new-to-the-program users, compiling a graph in Microsoft Excel is fairly intuitive. Excel offers a one-click option on its "Insert" menu to take data on a spreadsheet and render ...

Learn how to make custom templates in Microsoft Excel to save you time and effort when creating similar reports or spreadsheet data analysis ...

Learn how to improve your productivity by creating custom Excel shortcuts to improve efficiency when using spreadsheets in Microsoft's ...