MU stacked logo with embedded link to the university's home page

Extension Technology and
Computer Services
 

University of Missouri-Columbia   Extension Technology and Computer Services—ETCS
 
 
Home
About ETCS
ETCS Staff
Training
Help Desk
S Drive
Webmail
InnerCircuits
Contact ETCS
Production
     Services
News & Notes
Documents
 
 
 
 
 
 
 
 
 
 
 

More:
— Quick Tips! —

Please email us with your video tips and training ideas etcs@missouri.edu 

Office.Microsoft.com learning resources
Microsoft Spreadsheets locating Office 2003 commands in 2007.
ETCS Quick Tip movies
Excel
  • Create a New Workbook
    time—2:08
  • Insert a New Worksheet
    time—2:32
  • Rename a Worksheet
    time—0:44
  • Move a Worksheet
    time—1:07
  • Delete a Worksheet
    time—1:33
  • Make Changes in Page Layout View
    time—3:45
  • The Watch Window
     time—2:02
  • Create & Format a Table
    time—2:39
  • Create a Chart
    time—2:14
  • AutoComplete a Formula
    time—2:19
  • Data Entry Form:
    Pt. 1-Create Command Button
    time—1:12
  • Data Entry Form:
    Pt. 2-Enter Data
    time—1:26
  • Data Entry Form:
    Pt. 3-Create a .csv File
    time—1:22
  • Save Options
    time—2:38
  • Move/Copy Rows & Columns
    time—1:44
  • Print Gridlines & Headers
    time—1:04
  • Sort Your Data
    time—2:20
  • Filter Your Data
    time—1:45
  • Give Your Worksheet a Title
    time—3:05
  • Conditional Formatting
    time—3:40
  • Sort by Color
    time—1:14
  • Format Painter
    time—2:23
  • Freeze Panes
    time—1:43
  • XX
    time—0:50

  •  movie  list

Word
  • 0-Quickly Format Text
    time—2:28 total (2 parts)
  • 1-Insert a Cover Page
    time—1:20
  • 2-Insert Text Boxes
    time—1:34
  • 3-Add a Signature Line
    time—1:03
  • 4-Mark Document as a "Draft"
    time—0:50
  • 5-Insert a Footer
    time—1:18
  • 6-Save as a Template
    time—0:55
  • 7-Change Layout Orientation
    time—0:49
  • 8-Set the Page Margins
    time—0:54
  • 9-Insert a Page Break
    time—1:04
  • 10-Create a Table
    time—0:52
  • 11-Format a Table
    time—1:30
  • 12-Add a Graphic
    time—2:05
  • 13-Write Mathematical Equations
    time—1:57
  • 14-Add References & Bibliography
    time—3:53 total (3 parts)
  • 15-Remove Hidden Comments
    time—1:34
  • 16-Encrypt your Document
    time—1:47
  • 17-Add a Digital Signature
    time—1:22
  • 18-Enable Hyphenation
    time—1:25
  • 19-Change the Page Size
    time—1:02
  • 20-Format Multiple Columns
    time—1:21
  • 21-Add Line Numbers
    time—2:47 total (2 parts)
  • 22-Format Painter
    time—2:00

  •  movie  list

Vista
  • 1-Find Files, Save a Search
    time—2:24
  • 2-Find Files w/Search Folder
    time—2:57
  • 3-Find Files w/Navigation Pane
    time—2:04
  • 4-Navigate in Windows Explorer w/Address Bar
    time—1:46
  • 5-XX
    time—0:50
  • 13-XX
    time—2:05
Sharepoint
  • 1-Set Alerts
    time—2:15
  • 3-Check Files In & Out
    time—2:43
  • 5-XX
    time—2:05
  • 2-Delete Alerts
    time—1:05
  • 4-Move Files Between Libraries
    time—2:07

  •  movie  list

WebApps
  • 1-Add or Change Alerts
    time—3:40
  • 3-Search
    time—2:52
  • 2-XX
    time—2:05
  • 2-Delete Alerts
    time—1:33
  • 4-Set as a "Trusted Site"
    time—2:35

  •  movie  list

Back

Last Revised: 08/06/08

 

© 2005 - Curators of the University of Missouri
DMCA and other copyright information.
All rights reserved.
 Contact ETCS

 

MU Extension logo with embedded link to the Extension home page
  The information presented in this website is designed for use in the University of Missouri Extension
 computing environment. This information may not be applicable outside the Extension system.