Another way to name ranges in Excel is to format the data as an Excel table, and rename the table instead. Naming ranges is just one of many ways to speed up your workflow in Excel .

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.

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

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

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