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.

Data validation is the foundation of creating drop-down lists in Excel. By setting up data validation rules, you can create lists that automatically update as your data changes.

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

The ability to automate tasks in Excel for the web has been a long wait—but it’s finally here, and it was worth the wait.

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.

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 ...