Office 07 Excel Topics

If you have a question about using Excel in your classroom please send email to Internet4Classrooms.
Our E-mail addresses are found below

1. Basic Tutorials
   1. Using the Insert Tab in Excel 2007 - Learn about the various groups in the Insert Tab.
   2. Using the Page Layout Tab in Excel 2007 - Learn about the various groups in the Page Layout Tab.
   3. Using the Formulas Tab in Excel 2007 - Learn about the various groups in the Formula Tab.
   4. Using the Data Tab in Excel 2007 - Learn about the various groups in the Data Tab.
   5. Using the Review Tab in Excel 2007 - Learn about the various groups in the Review Tab.
   6. Using the Drawing Tools Tab in Excel 2007 - Learn about the various groups in the Drawing Tool Tab.
   7. Using the View Tab in Excel 2007 - Learn about the various groups in the View Tab.
   8. Using the Chart Tools Tab in Excel 2007 - Learn about the various groups in the Chart Tools Tab.
2. Animate an Excel chart in PowerPoint - Learn how to make a simple chart and then use PowerPoint to display the elements of the chart one at a time.
3. Create a Chart or Graph - This module presents suggestions on using the new chart tools in Office 07.
4. Create an interactive crossword puzzle - Use the conditional format feature of excel so your puzzles can immediately show correct (or incorrect) answers.
5. Import Data from the Internet - Sure you can write the numbers on paper and then manually enter them into the worksheet, but Excel can automatically import data for you.
6. Inserting an Image into the Background of an Excel Worksheet - This process would work well for setting up review worksheets to use on an interactive whiteboard.
7. Make a Custom List - You can tell Excel what information to fill down; the example used is a list of your students.
8. Make a Venn diagram - If you have made Venn diagrams with the old Excel there are a few differences you need to know about in the new Excel.
9. Transposing Rows and Columns in an Excel Workbook - Rather than starting all over entering data, Excel can switch the rows and columns for you.
10. Using Compatibility Mode - This module lists advantages and disadvantages of setting your new Excel to automatically save files in the older .xls mode.
11. Using Conditional Formatting - This is an example of "if then" formatting; if the answer is right then display it colored green, for example.
12. Using Mail Merge - Learn how to use Word and Excel to create a form letter which can then fill in information specific to each of your students.
13. Using a Radar chart to analyze data - Sometimes when you can't see the forest for the trees, this type of graph gives you a good overview.

Interactive: Excel 2003 to Excel 2007 command reference guide