Want to organize all the worksheets in your Excel workbook? Try creating a table of contents. It makes it easy to find specific sheets, especially if your Excel file contains hundreds of them.

These AI tools simplify spreadsheet tasks — from formula building to marketing data analysis — and you don’t need a techl ...

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we ...

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

A spreadsheet may contain a number of tables, giving you several cell ranges that need the same formatting. One way to make these multiple tables is to copy a table, ...

Richardson: A product called Tableau. It’s not cheap—about $999 for a personal version. If you want it in a professional setting, it’s about $2,000, but it comes not only in a desktop but in server ...

Zoho Sheet, the company's Web-based spreadsheet, just added over a dozen new features, including support for Visual Basic macros (the same kind used in Excel) and pivot tables/charts (which ...

If you want to share data in a pivot table with others you may encounter one of the most distinct disadvantages of this Excel tool. Sharing useful, functional pivot tables with others requires ...