Several readers have submitted questions about Excel 2010 and 2007 PivotTables, as follows: Q1: Why does Excel insert the GETPIVOTDATA function into a formula when you use the mouse pointer to refer ...

There are a great many keyboard shortcuts you can use to work with Excel more efficiently. For a handy reference to all of them, some which work in other Office programs, Microsoft offers these PDF ...

Enhancements in the .NET Framework 4 and Visual Studio 2010 make Office automation solutions easier than ever to write and deploy. Here's an Excel automation scenario that reflects solutions that I've ...

Data wonks, rejoice! Pivot tables now automatically refresh themselves in a new beta version of Microsoft Excel. You might expect that pivot tables—which can be used to summarize rows and columns of ...

These charts accompany our story Excel 2010 cheat sheet. Click through to that story for detailed information on getting up and running with Excel 2010. If you’ve upgraded to Excel 2010 directly from ...

If you’re serious about using Microsoft Excel, then you should get to know all of its keyboard shortcuts. Here’s a list of the most useful Excel shortcuts and how they can help you work faster. For ...

It’s not for big data, but you can use Microsoft Excel to learn a lot more about analytics than you may realize. For many office workers, Microsoft Excel is simply the go-to spreadsheet application.

Combo boxes are a useful way of entering data into an Excel spreadsheet, combining the flexibility of a text field with the convenience of a list box. Combo boxes provide you with a list of choices ...