Have you ever found yourself in a chaotic Excel workbook, where multiple people are editing the same cells, accidentally overwriting each other’s work, or making unintended changes? It’s frustrating, ...

Excel automation isn’t just macros anymore.

Excel drop-down lists, like those found on Web pages, help you view large amounts of data in a small area. They are also useful for limiting the choices an Excel spreadsheet user can make when editing ...

To update your Microsoft Excel worksheet, you can add a data series to the source data and also update the worksheet chart to make your data meaningful to your colleagues and clients. Applying an ...

Discover 10 hidden Excel shortcuts that aren't on standard cheat sheets. Learn how to streamline your workflow and improve ...

A few months back, Dave showed you how to use Excel pivot tables to better visualize your spreadsheet data. (If you missed the post, be sure to check it out -- it has video!) Of course, if you've ...

Power users rely on these lesser-known Excel shortcuts to work faster across large datasets, formulas, and worksheets.

Increasingly, reporters are turning to Microsoft Excel — or similar spreadsheet programs like Apple’s Numbers — to advance their reporting. They’re using spreadsheets to keep track of city budgets, ...

Microsoft recently added a new optical character recognition feature to Excel that lets users import data from a photograph taken from a smartphone. Here's how to use it. I first started using ...