Planning your workbook in Excel

 

Planning your workbook

✦ Does the layout of the spreadsheet require the use of data tables

✦ Do these data tables and lists need to be laid out on a single worksheet or can they be placed in the same relative position on multiple worksheets of the workbook (like pages of a book)?

✦ Do the data tables in the spreadsheet use the same type of formulas?

✦ Do some of the columns in the data lists in the spreadsheet get their input from formula calculation or do they get their input from other lists (called lookup tables) in the workbook?

 ✦ Will any of the data in the spreadsheet be graphed, and will these charts appear in the same worksheet (referred to as embedded charts), or will they appear on separate worksheets in the workbook (called chart sheets)?

✦ Does any of the data in the spreadsheet come from worksheets in separate workbook files?

 ✦ How often will the data in the spreadsheet be updated or added to?

 ✦ How much data will the spreadsheet ultimately hold?

✦ Will the data in the spreadsheet be shared primarily in printed or online form?