Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool. Tables are one of the fundamental tools in ...

Q: To make an Excel table fit better on a page when I print it, I frequently have to transpose it—that is, move all the data from, say, rows 1, 2 and 3 and put them into columns A, B and C. To do that ...

If there’s one task most marketers share — whether their focus is SEO, paid search, or social media — it’s collecting and interpreting data. Being able to slice and dice the data to find actionable ...

Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working with ...

How to create and populate a table in Microsoft Excel’s Power Query Your email has been sent Updating data in a Microsoft Excel workbook is common, but you will run into cases where you can replace ...

How to populate a dropdown with data from another sheet in Excel Your email has been sent If your list and dropdown are on different pages, you’ll need to know this ...

Tom Warren is a senior editor and author of Notepad, who has been covering all things Microsoft, PC, and tech for over 20 years. Microsoft is adding a very useful feature to its Excel mobile apps for ...