Excel

media type="custom" key="4575386" =Excel Basics= = = =Excel Tutorials=
 * Excel is a spreadsheet program. It can do numerous calculations for you as well as chart and graph data.
 * We have various versions throughout the district.
 * Most versions function in the same manner, but the tools might be located in different places.
 * Newer versions save with the file extension .xlsx and will not open in 04, 03, or earlier. If you need to open these files (at some point) with an earlier version of Excel, save them backwards as .xls files. On the mac, go to FILE - SAVE AS - Format - Excel 97-2004 Workbook. (.xls). On a PC, go to SAVE AS - Excel 97- 2003 Workbook. If you are only ever using version 2007 and newer, you do not need to do this.

Within our district we have Excel 2004 and 2008 for Mac and Excel 2003 and 2007 for PC. The latest versions, which you might have at home are Excel 2011 for Mac and Excel 2010 for PC.

Basics of Excel, What it is and how to use it

PC Tutorials
Excel 2003 Training (PC) Excel 2003 For Teachers Tutorials (PC) Excel 2003 - Using Formulas (PC) Excel 2003 - Tutorials (PC) Excel 2007 - Self Guided Course (PC) Excel 2007 Tutorial (PC) Excel 2007 Tutorial (PC) Excel 2010 - Getting Started (PC) Excel 2010 - Tutorial (PC)

Mac Tutorials
Excel 2004 Quick Guide Excel 2004 Tutorials Excel 2004 Tutorials Excel 2004 Tutorials Excel 2008 Quick Guide Excel 2011 Download Training Guides and Videos

toc

= Excel 2004 for Mac =

Mrs. Tonkin's Penny Density Lab
1. Merge A1 and B1 and center the text. (Format - Cells - Alignment - check box for merge cells - at top change alignment to center) 2. Merge C1 and D1 and center the text. (Format - Cells - Alignment - check box for merge cells - at top change alignment to center) 3. Label A1 //Old Pennies// 4. Label C1 //New Pennies// 5. Label A2 //Net Volume//. 6. Label B2 //Mass//. 7. Label C2 //Net Volume//. 8. Label D2 //Mass//. 9. Enter your data. 10.Highlight all data, but leave out the "Old Pennies/New Pennies" Fields 11. In the toolbar, click the GRAPH chart wizard. (Looks like a bar graph and magic wand.) 12. Select LINE graph, then choose your type of line graph. 13. Go through the wizard and label the title, x axis, and y axis. 14. When your graph is created you will notice that you have 2 extra lines. Delete the yellow and dark blue lines by clicking on them and pressing delete on your keyboard. 15. Change the legend, which now says "Mass, Mass." 16. Go up to CHART in the menu bar. 17. Select SOURCE DATA. 18. Select SERIES. 19. Change the names to "Old Pennies" and "New Pennies," but do not change the values. 20. Customize and play!

= Excel 2007 for PC =

Creating a Table




Changing Your Table into a Graph
= =

Moving Tables and Charts/Graphs Into Word
Right click on each and select "COPY." Open Word. Once in work right click and select "PASTE." Shortcuts are command C for copy and command V for paste.