The database capabilities of Excel are very powerful. In fact, not only can Excel be used to create a simple searchable database, it also can be used to create a proper relational database.

Whether you're a seasoned Excel user or just starting out, you'll be surprised at how easy it is to unlock the potential of your data.

Some can design very sophisticated reports, others show you your data in the familiar grid layout that Excel uses.

This article compares the data visualization program Tableau to Excel, examines their relative strengths, and provides a simple walk-through on how to use Tableau.

Microsoft Excel has features that are reminiscent of a database, although it’s not a database application and never will be.

Learn how to use Excel's PivotTable feature to generate meaningful reports that summarize data.

Learn how to calculate simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.

Data Disappears in Excel. Microsoft Excel application designs spreadsheets, tables and documents. Data can be entered in several ways to create formulas and charts formatted in varying sizes ...