Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

How to Set Up Auto Calculate in Excel 2010. When you edit the values on your Microsoft Excel worksheet, pressing the "F9" button refreshes the calculation manually.

When something so obvious is available in competitors, even in other Microsoft programs and features, and Excel is only now getting it. When working with Excel, one would expect that pivot tables, ...

When creating formulas and equations on Microsoft Excel, users have the option of inserting multiple functions and conditions into a formula to attain a desired result. This action is often referred ...

Q. Are there any alternatives to traditional PivotTables in Excel? A. The first thing that comes to mind is the function GROUPBY. The primary purpose of GROUPBY is to make data analysis easier by ...

How to Program an Excel Spreadsheet to Auto-Update From the Web. While you can certainly copy and paste data from a network or Web-based external source into Excel, importing the data by ...

Prevent duplicates before they happen by combining a simple function with data validation.

Is the Auto Fill button when dragging the fill handle down missing in Excel? We show wyou how to enable Auto Fill in Excel.

These new data types allow you to place structured data within a single cell. Microsoft announced a major update to Excel that brings the option to create your own data types.