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
CEIS help
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

 

 

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.