In these instances, it makes sense to set up a totalling worksheet that automatically summarizes data gathered from cells located elsewhere in your workbook.

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.

We show you how to clean up and prepare your data for the big mail merge, everything from trimming unnecessary data fields to setting up record ID numbers.

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