For the most part, you're probably accustomed to using Microsoft Excel for tasks such as preparing reports, forecasts, and budgets. However, Excel is much more powerful than that. It can be used to ...

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,relatives, ...

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we dive ...

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. For example, it takes Excel less than one-tenth of a second to calculate an entire, massive ...

Tracking the time your employees take off needn't cause you a headache. With Microsoft Excel you can set up a workbook that can organize all sick days, personal days and any other days you need to ...

You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up ...

Q. There are formulas that I am repeatedly having to create in my Excel workbook, and there are no built-in functions in Excel that can do these calculations. Is there a quicker way to reuse the same ...