Instructor: Alea Renner
Date: June 23-27—1:00pm-3:00pm
Location: Elton Gregory Middle School. Room 100
Target Audience: Support Staff

Participants will explore both basic and more advanced features of Excel 2007. Some of the topics that will be covered will be formatting, styles, formulas, sorting, filters, and much, much more! The district will be transitioning to Excel 2007 so this is a great opportunity to get a head start in learning how to use this new version of Excel.


Training Files

Excel Crosswalk Utility -
Excel Training Data - Day 1 -
Excel Training Data - Day 3 -
Excel Training Data - Charts -
Excel Training Guide - Days 1-3 -
Excel Shortcuts - Control Key -
Excel Shortcuts - Function Key -
Excel Shortcuts - Other Useful Shortcuts -
Excel Data Consolidation Guide -
Excel Charts Guide -



Day 1 - June 23th


  • Opening Discussion
  • What's Changed?
  • What happened to the file menu?
  • Your New Control Center - The Ribbon
  • Quick Access Toolbar

-BREAK-

  • How about Those Shortcuts
  • Modifying the Excel Worksheet
  • The Home Tab


Day 2 - June 24th


  • The Home Tab
  • Formatting
  • Fonts

-BREAK-

  • The View Tab
  • Exploring Different Views
  • Show/Hide Features
  • Window Arrangement
  • What is a Macro?


Day 3 - June 25th


  • The Data Tab
  • Import from Anywhere
  • Sorting Your Data
  • Auto-Filter
  • Data Tools
  • Groups and Subtotals

-BREAK-

  • The Formula Tab
  • What can formulas do for you
    ----

Day 4 - June 26th


  • The Formula Tab - continued
  • There's gotta be a quicker way
  • Logical
  • Text
  • Date/Time
  • Other

-BREAK-

  • The Insert Tab
  • Pivot Tables
  • Pictures, Shapes and Smart Art
  • Charts and Graphs
  • A visit to classroom wiki examples
  • Creating your own wiki



Day 5 - June 27th


  • The Review Tab
  • Proofing / Protecting
  • Comments
  • The Page Layout Tab
  • Themes
  • Page Setup
  • Getting the Best Print Possible


-BREAK-

  • Hands on with Excel 2007