Working with Multiple Worksheets and Workbooks: Tracking Cash Flows (Part Two)

Excel techniques used:

Use data from multiple workbooks

• Create a summary workbook
• View the list of linked workbooks

Using lookup tables

• Setup a lookup table and insert the VLOOKUP function

Create and use an Excel workspace






(Zoom in by clicking the pictures)