Excel's PivotTable feature lets you organize and summarize data into a meaningful report format without changing the data set. Beyond reporting, PivotTables offer a quick and easy way to analyze ...

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.

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.

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

Next, tidy up the appearance of your text. Stick to clean, professional fonts like Calibri, Arial, or Times New Roman, and use consistent sizes—say 12pt for headers and 11pt for all other text. Align ...

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.

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

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

In this Excel tutorial, I’ll show you how to run subtotals on a simple data set and then quickly apply formatting that will make those totals really stand out.

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