Cons of using Excel as a database Limited security Before you fully embrace Excel as a database tool, make sure to keep the following cons in mind.

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.

Tips This article applies to Microsoft Excel 2007, 2010, and Office 365. View the videos listed in the Resources section for more ideas on using Excel's database functions.

Using the Graph API to work with Excel is relatively easy; it’s a set of REST APIs with a common structure for all calls. This lets you quickly build URLs that access OneDrive locations, which ...

If you've have lots of data and lots of analysis to do, but little time or skill, you need Excel's Power Pivot feature. Here's how to get started with it.

A new method, using Microsoft Word and Excel, has been developed. The method produces a flexible Word document of interview data separated into logical chapters and subchapters. All text is coded, and ...