This article applies to Microsoft Excel 2007, 2010, and Office 365. View the videos listed in the Resources section for more ideas on using Excel's database functions.

Data comes from all kinds of sources and Microsoft Power Query can you when you need to combine foreign data. It’s a bit easier than trying to do so in Microsoft Excel sometimes.

Discover how Excel’s Copilot uses AI to automate tasks like summarization and data cleanup. Is it the productivity breakthrough you need?

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Microsoft has teamed up with Nasdaq and Refinitiv, to bring real-time financial data to Excel spreadsheets. Users have access to the latest stock and bond prices, plus other relevant information.

Microsoft adds a new Copilot function to Excel, letting users generate, analyze, and summarize data directly in spreadsheet ...

To convert data from Microsoft Money 95 for use in Excel, you must first export the data as a QIF file and then use a third-party utility to convert it to CSV format.