One of the more useful features in Microsoft Excel is Insert Charts. You can create a wide variety of charts: bar, line, pie and others. While many charts only involve one variable, you can create ...

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

Microsoft Excel allows you to perform equations in individual cells in your worksheet. The Microsoft Equation Editor contains many symbols and operators not commonly found on your keyboard. This ...

One of Excel’s greatest tricks is the dimensional or 3D reference. This feature, which allows you to create formulas that refer to the same cell or range on multiple worksheets, simplifies the ...