A pivot table is a must-have tool for power Excel users. It lets you see the bigger picture, where you can make sense of ...

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

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 have a table on paper but need the data listed in Excel? There's a simple trick for importing.

How To Automate a Table in Word Using Excel. As the world's leading business productivity suite, Microsoft Office provides many useful features including the ability to automatically display data ...

Would you like to make your Excel spreadsheet and data management smoother, more efficient, and less error-prone? Excel tables have transformed data ...

The database capabilities of Excel are very powerful. In fact, not only can Excel be used to create a simple searchable database, it also can be used to create a proper relational database.

While Access 2003 and 2002 include a wizard for importing data from an Excel file into an Access table, you may want to create a command button that will perform all of the steps of the wizard for ...

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

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.