MS Office 2007 Basic Skills

CIS120L and WebCT FAQ

Introduction to the New Interface Demo

PDF file of the Demo Contents

File Management Help File

Link to all Assignment Material

Site for inexpensive version of Office 2007 - Techhead.org

Below are the links to the Demos: Just 'mouse over' the application and then the week for the demo you want to watch...

• Word 2007
  • Week 1
    • Demo 1 - Basic Start - Open Doc, Insert & delete, background, blank lines and save
    • Demo 2 - Selecting text, formatting, Header/Footers, printing
    • Demo 3 - Open/Navigate a Doc, Zoom slider, images
    • Demo 4 - Margins,Line spacing,Paragraph spacing, Format painter
  • Week 2
    • Demo 5 - Find/replace, Synonyms, Breaks, Hypertext, Spell & grammer check
    • Demo 6 - Working with Multiple open files & Bullets
    • Demo 7 - Page numbers, Footers, Auto correct
    • Demo 8 - Footnotes, Citations/References, Inserting symbols
    • Demo 9 - Creating a Title page with Word Art, Graphics, Borders
  • Week 3
    • Demo 10 - Tabs
    • Demo 10a - More on Tabs
    • Demo 11 - Tables (Part 1)
    • Demo 12 - Tables (Part 2)
    • Demo 13 - Creating Columns and Column breaks, Drop caps, shadowing & borders, Hyperlinks
    • Demo 14 - Templates

• Excel 2007
  • Week 4
    • Demo 1 - Basic Start
    • Demo 2 - Adding text & numbers, Column width, Filling
    • Demo 3 - Text cell formating
    • Demo 4 - Copy and Paste, Inserting rows, Number/Date, Formatting, Cell borders
    • Demo 5 - Working with Worksheets
  • Week 5
    • Demo 6 - Formulas and Functions (Part 1)
    • Demo 7 - Formulas and Functions (Part 2)
    • Demo 8 - Review Demos 6 & 7
  • Week 6
    • Demo 9 - Basic Chart creation
    • Demo 10 - Conditional Statements
    • Demo 11 - Data Tables
    • Demo 12 - Putting it all together

• PPT 2007
  • Week 7
    • Demo 1 - Basic Start
    • Demo 2 - Creating Basic Slides
    • Demo 3 - Outline View, Slideshow Themes, Graphics, Transitions
    • Demo 4 - Downloading Graphics from the Internet and Storing in Folder
  • Week 8
    • Demo 5 - SmartArt, Changing Background Themes, Adding Shapes, Text and Music
    • Demo 6 - Animation of Slide Components
    • Demo 7 - Print Options, Templates
  • Week 9
    • Demo 8 - Using PPT as a Desktop Publisher (Part 1 – Creating a Letterhead)
    • Demo 9 - Desktop Publisher (Part 2 – Creating a Flyer/Poster)
    • Demo 10 - Desktop Publisher (3-Column Flyer Part 1)
    • Demo 10 - Desktop Publisher (3-Column Flyer Part 2)

• Access 2007
  • Week 10
    • Demo 1 - Introduction of Databases, Opening a DB and Table, Adding a New Record, Sorting and Filtering a Table, Creating a Query
    • Demo 2a - Creating a backup of your database, correcting/updating data entries, deleting records
    • Demo 2b - Creating a New Table
    • Demo 2c - Creating Multi-level Queries

Practice files that can be used with specific demos:

Word: none

Excel: Demo 8, Demo 9, Demo 10, Demo 11, Demo 12

PPT: Demo 5, Demo 8, Demo 9, Demo 10

Access: Demo 1, Demo 2a-c