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.

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

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.

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.

You can reference a list on another sheet, but it takes a bit more work. In this tutorial, I’ll show you how to populate a dropdown with data on another sheet.

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

Microsoft Excel's VLookup formula permits you to search large spreadsheets for specific data, one of Excel's lookup and reference functions. You can use VLookup between sheets within an Excel ...

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

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.