EXCEL-lent Ways to Help Your Students Excel!

Basic Excel Review
Basic Tables and Graphs
Interactive Maps
Drop Down Menus
Timelines





EXCEL-lent Websites!
http://www.nps.gov/history/hps/abpp/bystate.htm
http://www.mrnussbaum.com/civilwarpage.htm
http://www.pbs.org/civilwar/war/map2.html
http://kids.house.state.tx.us/
http://www.senate.state.tx.us/CHBook/CHBook.htm
http://fofweb.com (username = esc20 Password = coop)
http://www.tsl.state.tx.us/treasures/earlystate/index.html

• Toolbars – View>Toolbars
  • Standard
  • Formatting
  • Drawing
• Navigating
  • Tab Key – moves cursor to the right
  • Shift + Tab – moves cursor to the left
  • Enter Key – moves cursor down
  • Shift + Enter – moves cursor up
  • Arrow Keys – move cursor in the direction of the arrow

Basic Tables and Graphs – Civil War Example

• Formatting Text – just like Word!
• Adjusting columns and rows
  • Manually – right click on the column or row heading and choose “Column width…” or “Row height…” then type in a number.
  • Automatically – to fit contents – double click on line between column or row headings
  • Automatically – to make all columns or rows the same – click in the select all area then change one column width or one row height.
• Autosum button
  • Adds columns or rows
  • Keeps a running total
  • Click in the cell after your entries.
  • Click on the Autosum button, then click enter.
• Average
  • Works just like Autosum
  • Use the drop down menu
• Merge and Center
  • Use for titles or bold headings
  • Highlight the cells you want to merge, then click the “Merge & Center” button.
• Fill Color – adds pizzazz
• Make graph from chart
  • Highlight the data for the chart
  • Click the “Chart Wizard” button
  • Follow the prompts.