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

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.

How to Create an Employee Calendar in Excel. When you own or manage a small business, you may need to track employees' vacation times, hours worked or shifts scheduled. Microsoft Excel offers a ...

Microsoft Excel lets you swiftly create a variety of useful records to log sales calls, service calls and other kinds of call information you need to run your business. In just a few minutes, you ...

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.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

Learn how to create an automated, multiple choice, interactive quiz or question bank in Microsoft Excel, the easy way.

Excel provides over 16 dozen geometric shapes that you can size and manipulate to your specific needs, plus hundreds of special effects.