Workbook and Analysis

Set up Your Spreadsheet

1. Begin opening the spreadsheet. 2. Save as, and re-name it:

LASTNAME_Workforce_Composition_Analysis_Semester_Year

3. Format the spreadsheet for Landscape with Narrow Margins. 4. Enter your name, date, and page number in the Footer area of the sheet. 5. Format the entire spreadsheet for Verdana 11 font. 6. The gray box at the top of the spreadsheet indicates what cell formatting to use for each

column. Format columns accordingly.

7. Bold the column heading titles. 8. Rename Tab 1: Data.

Note: There are three sections to the spreadsheet on Tab 1, separated by gray bands, titled:

Section 1: Data, Section 2: Category Keys and Summary Tables, and Section 3: Data Analysis.

Used with permission from Microsoft.

Excel screen showing how the cells in each column should be formatted.