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.

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.

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.

Open Microsoft Excel on your desktop and create a blank workbook. Lets open the existing Excel workbook. Create a new sheet from the bottom menu. Open your Excel sheet and fill in a description of ...

Import data. 1. Open a blank Excel spreadsheet and use the instructions from “Excel pro tips: Importing and parsing data.”Note that all the information imports into one field, so you must ...