Microsoft Tips and Tricks for Teachers

Microsoft Office Tips and Tricks for Teachers


Microsoft Office is a powerful set of applications, and there are many features in the software that most users have never encountered. Teachers, especially math and science teachers, are frequently unaware of the free equation editor, the ability to create histograms using Excel, ways to work with graphics to create effective documents for students, the various ways to use tabs, and how to add interest (with animations) to PowerPoint presentations. Here are various tutorials to help teachers explore some of the little-known features of the Office suite. Files are provided for Office XP/2003 and also for teachers who are trying to learn Office 2007.

Please note: The files for Office 2007 features are given in the Office 2007 format (the extensions are .docx and .pptx). These can be opened with Office XP or Office 2003, but you may have to download and install a small upgrade to allow the older version of Office to read these newer files.


Office XP/2003
Office 2007
Equation Editor
Using equations in Word is easier when the equation editor is available. The information applies to PowerPoint and Excel as well as Word.
Equation_Ed_Word_XP_2003.doc Equation_Ed_Word_2007.docx

Working with Graphics
Incorporating graphics and diagrams in tests and worksheets makes the process easier and your documents appear more professional. The information applies to PowerPoint and Excel as well as Word.

Graphics_Word_XP_2003.doc Graphics_Word_2007.docx

Making Use of the Tabs
Most people using word processors are not aware of the variety of tabs available within the program. Tabs can allow you to align numbers at the decimal point and create answer lines for tests and worksheets with one keystroke. The information applies to PowerPoint as well as Word.

Tabs_Word_XP_2003.doc Tabs_Word_2007.docx

Animating Objects in PowerPoint
PowerPoint provides options to make separate parts of a slide appear in a sequence, using Custom Animations. However, this presentation goes a bit farther, and shows you how to create an animation of a graphic which moves on the screen (using Motion Paths).

Animating_PowerPoint_XP_03.ppt Animating_PowerPoint_2007.pptx

Creating Histograms
Excel allows the creation of a variety of charts/graphs, but there is also a set of data analysis functions that are not well-known. This tutorial provides information on how to produce frequency histograms using Excel.

Histograms_Excel_XP_2003.doc Histograms_Excel_2007.docx
Using and Choosing Graphs
This document is adapted from information from Statistics Canada on the types of graphs and when to choose a particular type of graph. This file is in Word XP/2003 format only.

Additional files for Excel:

File Name
Spreadsheet Tutorial (by Acadia) excel_quick.doc A good tutorial from opening to printing in Excel 2000/2003/XP
Excel XP Tutorial Excel XP tut.doc A tutorial for Excel XP
TILT Tips for Excel TILT Tips Excel_Jan04.doc Tips and ideas from HRSB's TILT team
Samples of Excel Charts Samples.xls Samples of some of the different things that can be done with Excel.