Working with Multiple Worksheets and Workbooks: Tracking Cash Flow (Part One)

Excel techniques used:

Create a worksheet group

• Enter formulas in the worksheet group
• Apply the same formatting to all sheets in the worksheet group
• Ungroup the worksheet group

Create cell references to other worksheets

• Enter a formula that references another worksheet

Consolidate data from multiple worksheets using a 3-D reference

• Copy information across worksheets
• Enter the formula that includes the 3-D cell reference

Create a workbook based on a template

• Create a workbook based on a built-in template
• Create and save custom workbook template

Use data from multiple workbook

• Create a link to data in another workbook
• Create a workbook reference using the point-and-click method

(Zoom in by clicking the pictures)