Skip to content Skip to navigation Skip to login

Tech Integration Project
Lesson Accelerator: Project Launcher

Party on a Budget
Platform: PC
Application:

Description

The process for creating the Party Budget spreadsheet in Microsoft® Excel 2010 is described below. The Completed Project Movie shows you what the example project might look like. The tutorial movies that follow demonstrate, step-by-step, how to construct a spreadsheet using information provided in the resource packet. This project can be easily modified for creating other spreadsheets that can be used to manipulate data collected about any subject under study. For a complete project description, including goals, objectives, and materials needed, see the Project Overview.

The Example Project

The Completed Project movie will show you what the completed example project looks like.
expand  Completed Project Movie
Tutorial Number Availability Status Tutorial Title Key # Length
1. preview What the example project looks like 95582 01m:16s
Subscribers have access to download the resource materials for this project, which includes all example files, an assessment rubric, and information about adapting and extending the example project.

Creating Your Own Project

We'll begin by creating a new spreadsheet in Microsoft Excel. The first section will demonstrate how to enter and format labels and values as well as saving. In the second section, we'll be creating and formatting a pie chart, using the data that has been entered into the spreadsheet. The tutorials in the final section will demonstrate the power of the spreadsheet tool in financial decision-making.

Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Starting your spreadsheet 95563 02m:56s
2. locked Adjusting column widths 95564 01m:32s
3. locked Wrapping & formatting text 95565 02m:41s
4. locked Inserting rows, merging cells, & aligning text 95566 02m:26s
5. locked Saving your spreadsheet 95567 01m:22s
6. locked Entering data into cells 95568 01m:40s
7. locked Formatting numbers 95569 01m:04s
8. locked Formatting currency 95570 01m:38s
9. locked Adding cell borders 95571 02m:04s
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Naming cells 95572 01m:52s
2. locked Entering formulas 95573 02m:52s
3. locked Copying & editing formulas 95574 02m:55s
4. locked Using a function to generate a total 95575 01m:56s
5. locked Copying formulas & functions to a different column 95576 01m:41s
6. locked Creating a pie chart 95577 01m:28s
7. locked Changing chart properties 95578 01m:28s
8. locked Formatting chart size 95579 01m:50s
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Printing your spreadsheet & chart 95580 01m:18s
2. locked Changing data (what-if scenarios) 95581 02m:13s
Tutorial series by Cindy Rybaczyk
©2013 Atomic Learning, Inc.   All rights reserved.