Microsoft Excel's Formula by Example helps automate repetitive tasks in structured tables in Excel for the Web. The tool is ...

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.

However, your Excel 2013 spreadsheet might also use named ranges that never change unless you manually adjust them. Changing these ranges apply to all formulas that use the named range. Changing ...

Below Excel Off The Grid explains how to use Excel’s “Allow Edit Ranges” feature—a fantastic option for collaborative workbooks. This little-known tool lets you take control of your shared ...

A share feature in Excel allows you to share your workbook and specify sections, tables, ranges, charts, or worksheets that need to be addressed or viewed by someone else; but note that the recipients ...

The pivot table is a collection of tools that Excel uses to create reports from complex, multi-file spreadsheet data. Here's how to generate reports for single tables ...

You can edit a drop-down list in Excel using a few different methods. It's easy to edit a drop-down list if it's based on an Excel table, as the table should update automatically with your edits.

Image: PixieMe/Shutterstock. Microsoft Power Query showed up in Excel 2016, though earlier versions can access Power Query using an add-in. This tool allows you to import, scrub and edit data from ...