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 offers several tools you can use when you need to fill a column with the same text or numbers.

Importing data into Excel from other sources can result in long, messy strings of text you need to parse. We'll show you how.

Click on the Databases tab and select the format of your database. Our demo uses MS Access Database . If your database product doesn’t appear, click on Browse to locate it on your computer and then ...

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp.

From the databases tab select the correct version of Microsoft Access and press 'OK'. This will then prompt you for the location of the database file.

Microsoft Office is more than the sum of its parts—you can link an Excel database table to an Access database, integrating your data and adding value. Here's how.

It's not expected that the Excel PowerPivot component will require additional licensing, though to experience the full power of the solution you'd need to use the server side components delivered in ...