In 2010, Microsoft added yet another technical term—Power Query—to Excel's long list of jargon, but it's not as complex as it ...

When you have a massive Excel workbook overflowing with data, trying to make sense of it can feel like a tough task at times.

Pivot tables in Microsoft Excel are a great way to organize and analyze data, and the more you know about the feature, the more you’ll get out of it. For instance, filtering a pivot table is a great ...

Pivot Tables are meant to simplify (and partially automate) the ways you can organize and interpret the various data points in your spreadsheets. Think of it as a way to make either Excel or Sheets ...

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 ...

A few months back, Dave showed you how to use Excel pivot tables to better visualize your spreadsheet data. (If you missed the post, be sure to check it out -- it has video!) Of course, if you've ...