Excel

Workshops> Excel

Description: This introductory workshop is designed to provide an overview of Excel’s basic workspace and create a basic budgeting spreadsheet using functions, formatting, and worksheet formatting.

Workshop Preview Video

Resources: 

• Spreadsheets and Data Manual (PDF)
• Budget Demo (xlsx)
• RA Example

Description: This workshop is designed to teach skills in Excel that will help you manage data from large imports and save them for further use in SPSS.

Workshop Preview

Resources: 

• Data Management and Workflow Manual (PDF)
• Data Management Sample File

Description: A pivot table is a special type of data summary table that you can use to analyze and reveal relationships in the data without making you create and insert formulas. You can also adjust the arrangement of the summarized data after you generate the table.

Resources:

• Pivot Tables Manual (PDF)
• Pivot Table Example (xlsx)

Description: This short workshop is designed to provide an overview for creating and formatting charts, pivot tables and sparklines in Excel. You will also learn how to copy and paste this data to use in reports, posters and infographics.

Resources:

• Creating Charts Manual (PDF)
• Chart Demo (xlsx)
• Jorgensen Example (xlsx)

Description: This workshop is designed to provide an overview for running descriptive and correlational analysis in Excel 2013.

Resources:

• Descriptive and Correlational Analysis Handout (PDF)
• Sample Data (xlsx)