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

Small databases of a few rows, to a few thousand rows, can often be created more quickly and easily in Microsoft Excel, than by using a dedicated database system. Excel is available as a stand-alone ...

I’ve been helping an administrative assistant (who also happens to be a close relative—see what comes of having a reputation for using technology?) who needs a database on her job to track employee ...

To help readers follow the instructions in this article, we used two different typefaces: Boldface type is used to identify the names of icons, agendas and URLs. Sans serif type shows the names of ...

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. You don’t have to import an Excel ...

Didi Gurfinkel is the co-founder and CEO of DataRails, a powerful software product that helps CFOs and financial planning and analysis (FP&A) pros with their planning and reporting needs. Gurfinkle ...

The last piece of this three-part article is about merging your custom Word documents with your client list (exported from Outlook to Excel) for distribution. Part One explains how to selectively ...

I'm less than a year away from getting my B.S. in Computer Science, and have an opportunity this summer for my first set of "real work." I would be creating a database for a small company, moving tons ...

Have you ever found yourself drowning in spreadsheets, endlessly scrolling through rows of data, or manually fixing errors that seem to multiply by the hour? For many, Excel is both a lifeline and a ...