How to Create a Searchable Database in Excel. Although you're probably accustomed to relying on Microsoft Excel to help you budget, forecast, plan and report the numbers that underlie your ...

I recently explained creating a database using MSWorks. Well,the database used by most folks is an address book that includesnames, addresses, e-mail addresses, and phone numbers of friends,relativ… ...

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.

Microsoft Excel has features that are reminiscent of a database, although it’s not a database application and never will be.

SaveToDB elevates Excel from a simple data analysis tool to an effective and user-friendly database editor and puts you directly in control of your information.

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.

Excel’s database functions are often overlooked, yet they have the potential to transform complex data management tasks.

Don't have access to Access? You can use Excel to open the database you want, using the MS Query Wizard. Here's how to multitask using Office's versatile spreadsheet program.

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.

I consider myself an Excel poweruser. I program in it daily (20ish hours a week) and manage a few thousand lines of code for my personal use (stocks and finance). Outside of Excel, I know very ...