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.
The Quick Analysis menu won't replace everything you do in Excel, but it handles the repetitive stuff faster than navigating through ribbons. This shortcut eliminates most of the steps for you if you ...
You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up.