Here's a quick method, and the equivalent keyboard shortcut, for selecting an entire data range. Working with a complete data set is a common task in Excel. You might want to move the data, apply a ...

Design is best, but when you're stuck with an existing data structure, it helps to know how to work around trouble. Susan Harkins explains. Excel sheets grow — sometimes by adding new functionality, ...

The "Unpivot" button inside Excel's Get Data feature is a hidden superpower. It can turn a tedious, error-prone task into smooth, automated workflows. No more copy-pasting, no more manual rearranging ...

Filters organize and prepare data for Excel reports and visualizations by selecting only relevant data for display. If you are working with a filter in an Excel worksheet, you can extend the range of ...

Q. I spend a substantial amount of time entering data into Excel. Do you have any suggestions on ways to make this faster and/or more efficient? A. One of the best data-entry tools to use in Excel is ...

What if you could write Excel formulas that practically think for themselves—automatically adjusting to changes in your data without endless tweaking? With the introduction of the dot operator and the ...

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp. Have you noticed that people groan when you pop open a spreadsheet to ...

Sometimes you need to scan some files for a piece of data like a string, phrase or some number, and one of those files just happens to be an Excel spreadsheet. You could open up the file, launch the ...

We invite you to join our industry specialists for a virtual session on how to use Bloomberg functionality in Excel. This ...