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.

This article explains how to create a report in Microsoft Excel using key skills like creating basic charts and tables, creating pivot tables, and printing the report.

Creating Running Totals in Excel Tables If, like me, you prefer your data to be formatted as a structured Excel table, you'll need to use a different method to create a running total.

Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

How to Create a Summary Chart in Excel. Excel spreadsheets can often contain large amounts of data ranging across broad categories. For example, a sales spreadsheet might record sales of products ...

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

Funnel chart is widely used for sales data representation. Learn how to create & insert Funnel Chart in Excel, Excel Mobile, PowerPoint and Word.

In today’s fast-paced business world, the ability to create visually compelling and informative Excel charts is a crucial skill for semi-technical professionals. Whether you’re presenting data ...

If you have a number of Microsoft Excel worksheets that contain related data, you'll likely need to create a report that consolidates and summarizes the data. If those worksheets are laid out ...

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.