Editor’s note: These charts accompany our story Excel 2007 Cheat Sheet.Click through to that story for detailed information on getting up and running with Excel 2007.

Your Excel formulas cheat sheet: 22 tips for calculations and common tasks. Max Productivity ... especially if you’re editing a macro or tracking down a circular reference.

Mac keyboard shortcuts often follow the same principle as the Windows keyboard shortcuts, though the Alt key on Windows keyboards is often replaced by the Options key on a Mac, and the Windows Ctrl ...

Excel is packed with features spreadsheet ninjas should know, but for a visual reference, save or download one or all of these cheat sheets: 8 Great Tools to Make You an Excel Expert (includes how ...

If you’re new to using Microsoft Excel, or an experienced user looking for a good visual reference, this handy cheat sheet covers eight helpful tricks for becoming a spreadsheet pro.

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

By default, Excel names the first sheet in the workbook "Sheet1." Append the cell's address to its sheet's name, separated by an exclamation mark. Continuing the example, the extended reference ...

How to Calculate Average on Excel From Multiple Sheets. Microsoft Excel 2010 provides a formula for calculating the average ... This same range of cells on multiple worksheets is a 3-D reference.

These charts accompany our story Excel 2010 cheat sheet. Click through to that story for detailed information on getting up and running with Excel 2010.