Unit 4 Competency 4 - Develop and interpret spreadsheet tables, charts, and figures to support written and oral Communication.

Suggested Objective a:  Create spreadsheet tables, charts, and figures to support written and oral communication

 End of June budget update on our LEED house in Houston

Download Excel Charts & Graphs.ppt

Doing More with Excel

Reviewing and Sharing Workbooks Links to an external site.

Using Templates Links to an external site.

Working with Charts Links to an external site.

Working with Sparklines Links to an external site.

Using Conditional Formatting Links to an external site.

Creating PivotTables Links to an external site.

 

Excel 2010:  Formatting Tables Links to an external site.

Excel 2010: Pivot Tables Part 1 Links to an external site.

Excel 2010: Pivot Tables Part 2 Links to an external site.

Excel 2010: Charts Links to an external site.

Mail Merge in Microsoft Office Word 2007 Links to an external site.

 

Suggested Objective b:  Interpret spreadsheet tables, charts, and figures used to support written and oral communication

 

Grade 9th Math problemHow can spreadsheets be used in real life?  Spreadsheets have many uses in life - everyday or business.  You can use a spreadsheet to create a budget, to average grades in a gradebook, or to use as an appointment book or list of people for Christmas cards.  Spreadsheets are very versatile.

Look at what Tracy Lawton  Links to an external site.had to say about spreadsheets and staying organized.  Click the link  Links to an external site.for her short article.

EHow  Links to an external site.provide five more ideas.  Look at these ideas by clicking the link Links to an external site..

Below are a few links from GCF to explain how you can perform What-If scenarios.  In other words, if a certain "thing" happens, what would the result be?  This conditional format is a great feature for using Excel.

 Using What-If Analysis Links to an external site.

 

Excel 2010: What-If Analysis Links to an external site.

 Excel Formulas:  Solving Real-Life Problems in Excel Links to an external site.

 Learning to use spreadsheets effectively takes practice.  With time, you can learn to use spreadsheets in many situations.  You might consider a spreadsheet as appropriate for use in budgeting or for averaging grades.  Look at these quick articles.

How to Make Good Use of Spreadsheets Links to an external site.

Who Uses Spreadsheets? Links to an external site. and how

How to Use Google Spreadsheets - Tips and Tricks Links to an external site.