Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

Learn how to define, use & delete names in Excel formulas. It becomes easier to identify & comprehend data when you can add Names to it.

In this tutorial we explain how to use the Ccommand button to navigate between worksheets in Excel. Switch between Excel worksheets easily!

This formula shows how to reference the cell in another worksheet using a formula. Begin the formula with an equal sign, and follow it with the name of the worksheet you wish to reference.

The bare bones VBA code A simple list of sheet names is easy to generate using VBA thanks to the Worksheets collection. Listing A shows a simple For Each loop that cycles through this collection.

Using range names in Excel allows you to quickly navigate to areas of your worksheet and makes formulas much easier to create.