Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations.

Microsoft Excel makes great charts, but often they’re not eye-pleasing. Learn how to change formats to yield a professional-looking chart.

In Microsoft Excel 2010, a chart sits over the worksheet and provides a visual expression of the underlying data. You can use a chart in conjunction with elements on the worksheet to get a better ...