A common use of data validation is to create a drop-down list. Use it to restrict the type of data that users enter into an Excel cell.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.

Graphs in Excel help break down your data into an easily digestible format. Here’s how to make a graph in Microsoft Excel.

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.