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

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

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.

Learn how you can make use of Name Box in Excel. The purpose of Excel Name Box is to help reduce the time taken while working with columns, cells, rows & ranges.

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro.

Use Editing, Fill, Justify to add instructions to your Excel 2007 worksheets When you need to add instructions to an Excel 2007 worksheet, they usually look something like Figure A.

Open the Payroll Calculator worksheet. The employee names are entered in this worksheet automatically, based on their names and ID numbers from the first worksheet.

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.

You can use PowerShell to search for various pieces of data within an Excel workbook to include all of the worksheets, which can be useful to quickly determine how much of a particular piece of data ...