|
Microsoft Office Tips
& Tricks Robert Mayben: rmayben@bama.ua.edu Introduction 1)
The Technology
in Motion Program (www.inservice.ua.edu/tim)
2)
Summer Workshop
Web Sites (www.bama.ua.edu/~rmayben/tim/summerworkshops.html)
3)
Workshop Web
Site (http://www.bama.ua.edu/~rmayben/tim/summertips.htm) 4)
Sample Materials
(http://www.bama.ua.edu/~rmayben/tim/castles.zip)
Microsoft Office Templates 1)
Go to office.microsoft.com and select Templates in the left-hand
column 2)
Scroll down until you locate Education. 3)
Click on Education to locate templates. 4)
Templates range from back to school PowerPoint Presentations to
letters requesting parent conferences to tests to gradebooks. 5)
After locating a desired template, click download now. (See next section
if the template does not open automatically.) 6)
Your template is now available for editing in Microsoft Office. Please Note: There may be some questions asked
during this step. Click agree, yes, or continue if prompted. 7)
Other Template Suggestions:
PowerPoint Templates & Designs
Newsletters for Publisher and Word
Calendars
Web Sites 8)
Dont forget
about the search bar at the top.
Microsoft Word 1)
Text Special
Effects: www.microsoft.com/Education/TipSpecialEffect.mspx 2)
Captions for
Pictures: www.microsoft.com/Education/AddCaption.mspx 3)
AutoShapes for
Graphic Organizers: www.microsoft.com/Education/TextAutoShapes.mspx 4)
Page Borders: www.microsoft.com/Education/Border.mspx 5)
Watermark
Backgrounds: www.microsoft.com/Education/AddWatermark.mspx 6)
Make Words Stand
Out/Highlight Tool: www.microsoft.com/Education/HighlightTool.mspx
7)
Tables: How do I
make the lines print or not print? After
creating table: Click inside your table ่ Pull down the Format menu ่ Select Borders and Shading ่ Select the Setting that you desire (None =
Invisible Lines)
8)
Page Break: Hold
down the Ctrl Key as you click enter. 9)
Holding down the
shift button while pressing ENTER enables you to create extra lines when
using bullets or numbers. 10)Columns Pull
down the Format Menu ่
Select Columns ่
Select the Number/Formatting of the Columns (Highlight the desired text if
you want the Title to stay Centered!) Notice the APPLY TO box at the bottom.
This can save you from fighting with columns.
11)The
Quick Brown Fox Trick =rand(X,Y)
12)Drop
Cap: www.microsoft.com/education/dropcap.mspx
13)Print Your Document as a
Booklet: www.microsoft.com/Education/CreateBooklet.mspx
14)Scraps: Select Desired Text ่ Drag to Desktop ่ Drag into any document
15)How
to print two pages on a single sheet of paper (2 Methods): A) www.microsoft.com/Education/TipTwoUp.mspx B)
Pull down the File Menu ่ Select
Print ่
Locate Zoom in the lower Right-Hand Corner ่ Select the Number of Pages that you desire on a
single sheet ่
Click OK
Practice Time
After each section of tips and tricks, you will be given 10-20 minutes
to practice the skills.
Use this time to begin a project, handout, presentation, or something
else that you can take back to use in your classroom.
The practice time is also a good time to find and save some templates
that you would like to use in your classroom.
Be sure to create a folder and only save to it in order to keep all of
your work and templates together.
You will have the opportunity to burn your folder of work and
templates to a CD at the end of the workshop. Microsoft excel 1)
Alphabetizing Columns Select a Cell in the Range ่ Pull down the Data
Menu ่ Select Sort ่ Select Sort By ่ Check Header Row or
No Header Row ่ Click OK 2)
Making Columns fit the text: At the top of the column (letters),
double click on the line between the two columns that you would like to fit
to the text. 3)
Orienting: www.microsoft.com/Education/CreateTimeline.mspx 4)
Easy Data Sets with Forms: www.microsoft.com/education/datasets.mspx
5)
Creating Charts Select a Cell in the
Range ่ Click on the Chart
Wizard Icon on the Standard Toolbar (Double check to make
sure that the wizard selects the proper range in step 2!) 6)
Pictographs with Charts: www.microsoft.com/Education/CreatePictograph.mspx 7)
Copying Charts into other Programs Select your chart ่ Copy it using your
preferred method ่ Open PowerPoint, etc.
่ Paste in the desired
location (Edit the chart after pasting by double-clicking on it.)
microsoft PowerPoint 1)
Use Grids to
Align Objects Pull
down the View Menu ่ Select
Grids and Guidelines ่
Place Checks in the Snap Objects to Grid and the Display Grid on Screen Boxes
่ Click OK 2)
Pictures as
Backgrounds Pull
Down the Format Menu ่
Select Background ่
Click the drop down arrow under Background Fill ่ Select Fill Effects ่ Click the Picture Tab ่ Click Select Picture ่ Locate the desired Picture ่ Click OK ่ Click either Apply to All or Apply 3)
The Photo Album
Feature Pull
Down the Insert Menu ่
Select Picture ่
Then New Photo Album ่
Locate the pictures desired for the album (Select more than one by holding
down the CTRL key as you click.) ่ Select the Album Layout ่ Check Captions box if desired ่ Click Create
4)
Playing a Song
throughout the Presentation Insert your desired song. ่ Click on Slide Show, and
then select Custom Animation. ่ Locate your song in
the Custom Animation Menu. ่ Click the drop down
menu, and then select effect options. ่ Select Stop Playing
After X number of slides. ่ Click OK.
5)
Copying & Pasting Using
Ctrl-Drag to Copy่You can quickly make a
copy of any object by holding down the CTRL key while you drag on the
object. You will then "drag off" a new copy.
|
|
|
