Learn how to use one of the most powerful tools Microsoft Excel has to offer.

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.

Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more.

How to Make Excel Data Horizontal. When you start fresh in Microsoft Excel, you have two options to enter data – horizontal and vertical. But after entering vertical or columnar data, it can ...

Excel's Data Model feature allows you to build relationships between data sets for easier reporting. Here's how to use it to make data analysis easier.

Learn how to use Excel to import, clean, manipulate, visualize, filter, and forecast transport data for transportation management.

Microsoft Excel’s Subtotal feature is a great tool, but you can make the results even better by customizing the format.