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

Persons across the globe use Excel in Accounting, Engineering, and Marketing for the things it can do. Microsoft Excel also helps users to store information and create advanced charts.

Use INDEX and MATCH for simple database queries in Excel The bigger your spreadsheet, the more you need these, which you can combine with SUM, AVERAGE, and MAX to refine your searches.

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!