The best way to do this is by converting your data to an Excel table. Select your data range (A1:E11), press Ctrl + T, and ...

Over the last few months, I’ve written several articles about Excel’s newish dynamic array functions. In many cases, they can replace older, more complex expressions. The new functions do all that ...

Most people know that you can reference one or more cells, tables and their column headers, or named ranges in Excel formulas. However, fewer know that you can reference specific data points in ...

To edit a drop-down list in Excel, you can use a number of tools depending on how you created the list. Here's what you need ...

Averaging isn’t always a simple total divided by the number of items totaled. Fortunately, Microsoft Excel offers several averaging functions, and one of them will probably get the job done. In this ...

We can use two functions to add a prefix to multiple (or all) entries across a column. The first one is using the & operator, and the second is using the CONCATENATE function. Eg. We are creating the ...

The Microsoft Excel program includes a variety of mathematical formulas that you can apply to any cell in a spreadsheet. If your business uses an Excel file to track sales information, you can use the ...

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.