Microsoft Excel spreadsheets hold more than a million rows of data and automate number crunching, but they can do so much more. Excel’s simple interface lends itself to uses well beyond those ...

Excel 2007's new table feature eliminates the need to copy formulas; once you define a data range as a table, Excel will do it for you!

Excel can solve for unknown variables, either for a single cell with Goal Seek or multiple cells with Solver.

Does Excel still have a place in analytics efforts? Let's look at the pros and cons of using the old workhorse, the spreadsheet.

Excel is a fine piece of software, but as Public Health England found out, its ubiquity and ease of use does not make it the ideal tool for every job that involves data.

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.

Excel Add-Ins are applications written by independent programmers that provide enhanced capabilities for the primary software. Here's how to install, manage, and choose the best Add-Ins available.

Getting viable data from an Excel workbook into Power BI for data visualization purposes takes some specific preparation. Here is what you need to do.

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does. If, for example, a cell has a formula "=A1" and you ...