Excel Resources

Microsoft Excel is an extraordinary tool, but many of us only tap into a tiny fraction of its ability. Below you will find a series of resources that you can access on an as needed basis. Do not be concerned if you need to return to these resources on a regular basis, many of the best Excel tricks are complicated but can be easily achieved with a little help.

Excel Training Workshop

Watch this: Tour of the Demo Spreadsheet

Open the Demo Spreadsheet File

Excel Short Cuts

  • CTRL+Z = undo
  • CTRL+C = cut
  • CTRL+P= paste
  • CRLT+F= find

Excel Activities for Beginning Users
  • Freezing cells
  • Sort
  • Filter
  • Formulas
  • Print settings

Watch this to learn about: Freezing cells, Sorting & Filtering
Watch this to learn about: Basic formulas & Print Settings

Excel Activities for Intermediate Users

  • Conditional formatting
  • Protecting cells & sheets
  • Creating graphs

Watch this to learn about: Conditional Formatting
Watch this to learn about: Creating Graphs
Watch this to learn about: Protecting cells & columns

Excel Activities for Advanced Users

  • vLookup
  • Pivot Tables

Watch this to learn: about vLookup
Watch this to learn about: Pivot Tables

Data Tips - Excel

Manipulating Pivot Tables

Straight to the Source

The "Help Tab" is built directly into the Excel Ribbon and is a great first place to check for instant help. Most of the objects on the Help Tab are specific links to content on Microsoft's website. If the Help tab is not installed on your computer you can download it here.

external image Image%202.png
external image Image%202.png

Other amazing resources found on Microsoft's website are:Excel Skill Builders video series - Learn various excel activities in a set of four online video series.Excel 2007 Help and How-to - A glossary style list of excel functions.Office Templates - Download some very cool Excel spreadsheets from this online repository.Ribbon Hero - Learning how to use Excel is now a game!!! Once installed, the game can be accessed from a tab in Excel's Ribbon. Loving this Ribbon thing? Try Ribbon Hero 2 and become a Microsoft Office Rock Star!!
Other Excel ResourcesExcel 2007 in Pictures -
Tutorials based on pictures, not words
.Quick Reference Card - A printable guide with the most commonly used Excel commands.

Conditional Formatting

This is an excellent tool to use when analyzing Reading 3D, 1st and 2nd grade math assessments, ClassScape data etc.