Microsoft Excel’s introduction of the new checkboxes feature has opened up a world of possibilities for users looking to create more interactive and dynamic spreadsheets. This versatile tool can be ...

Whether your corporate style guide prefers to call an image that displays spreadsheet data a chart or a graph, you're likely to be using Excel spreadsheet software to generate it. With Microsoft Excel ...

The Chart Wizard of earlier versions may be gone in Excel 2007, but creating charts is still as easy as ever. Beyond building basic charts there are various techniques you can use to make your charts ...

Excel does not always handle a cluttered page very well, especially if you intend to use a workbook on multiple versions of Excel. In this example we will use the Worksheet_SelectionChange event as a ...

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them. Microsoft Excel offers a plethora of tools for ...

Q. I currently keep a static to-do list, and I would like to update it to be more dynamic. Do you have any advice? A. Microsoft Excel is best known for crunching numbers, but it’s also a powerful tool ...

Users will appreciate a chart that updates right before their eyes. In Microsoft Excel 2007 and Excel 2010, it’s as easy as creating a table. In earlier versions, you’ll need the formula method.