Microsoft announced this week that's it's now possible for Office 365 users to import table data from Adobe Portable Document Format (PDF) files into the Microsoft Excel spreadsheet program. The ...

In 2010, Microsoft added yet another technical term—Power Query—to Excel's long list of jargon, but it's not as complex as it sounds. In fact, once you get started, it's not too steep a learning curve ...

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

Have you ever faced the frustration of trying to combine multiple Excel files, only to realize their sheet names don’t match? It’s a common headache for anyone working with data from varied sources.

Did you know that you can export an Access database to an Excel worksheet? In Microsoft Excel, there are features to import or export data from or to an Excel worksheet. When exporting data to Excel, ...

The Pivot Table is a tool that Excel uses to create custom reports from your spreadsheet databases. Once you select the portion of your spreadsheet that contains the target data, then define it as a ...

Digital disaster can strike in an instant when a program that contains important information closes unexpectedly. Microsoft designed Excel to address this problem through an AutoRecover feature that ...

Need to extract data from PDF files into a spreadsheet so you can analyze it? Find out how seven PDF to Excel conversion tools fared in head-to-head tests with increasingly complex data sources. In an ...

You have a table on paper but need the data listed in Excel? Fortunately, there’s a simple trick for importing data on physical papers (or any other images) into Excel spreadsheets. Take your ...