Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

Table Style Options in Excel. Microsoft Excel tables are a way to organize complex data into rows and columns, making your information easy to understand. Table styles let users add color and ...

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.

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

Among them are: 1. Automatic relationship detection: In Excel 2013, pivoting two or more sets of data was a more difficult operation because you had to use Excel’s Relationship tool to define the ...

Learn how to add a highlight to expose groups in your Microsoft Excel data using a helper column and Excel’s conditional formatting feature.

Microsoft Excel PivotTables turn data into meaningful information, but it's difficult to add grand total rows. Read on to learn how.