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.

Add a sheet name, followed by an exclamation point, to reference cells located on another sheet. For example, "=Sheet2!A1:B5" references a range of 10 cells on "Sheet2." Sheet names are located on ...

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.