Need more review in some of the basics of the Microsoft Office products? Follow the links to see video clips that will refresh your memory.

Note: You will need Adobe Flash Player to view these clips. You can download it for free by following this link: Download Flash Player. (You do not have to download the Yahoo toolbar in order for the Flash player to function correctly).

Each video will open in its own window. Click the red X to close the window when you are finished viewing the video and you will return to this menu.

You may pause, rewind, or move forward through the videos as needed. Some videos have a brief quiz at the end to test your understanding. The answers will be presented after you respond, but the tests are not counted towards your class grade.

 
 
Access | Excel | Word |PowerPoint | Folder and File Management | Miscellaneous
 
  Access Videos to top
 
  1. Use the Query Wizard
  2. Switch Views in the Query Object
  3. Build a Query in Design View
  4. Add and Move Fields in Query Design View
  5. Use Sort and Filter Tools
  6. Use AND and OR Queries
  7. Create a Calculated Form Control
  8. Forms overview
  9. Calculated Report Controls
  10. Anatomy of an Access Report
  11. Create relationships
  12. About referential integrity
  13. Many-to-many relationships
  14. Use the Lookup Wizard
  15. Basic queries
  16. Complex queries
  17. Create a Crosstab Query
  18. Understand PivotTables and PivotCharts
  19. Create a form with subform
  20. Modify Subforms
  1. Use Tab Controls
  2. Add a Combo Box for data entry
  3. Add a Combo Box to locate records
  4. Add an Option Group
  5. Adding a Command Button
  6. Understand Domain Aggregate Functions
  7. Access Overview
  8. Tables Overview
  9. Queries Overview
  10. Reports Overview
  11. About Switchboards
  12. Build Macros
  13. Plan and Build a Switchboard (loads slowly; be patient)
  14. Learn about Custom Search Forms
  15. Create a Custom Search Form: Step 1
  16. Create a Custom Search Form: Step 2
  17. Create a Custom Search Form: Step 3
  18. Create and Complete a Custom Search Form: Step 4
 
  Excel Videos to top
 
  1. Tour the window
  2. Select cells and ranges
  3. Rules for writing formulas
  4. Use AutoSum
  5. Use the Fill button
  6. Change Page views
  7. Write a formula
  8. About functions
  9. Write a function
  10. About relative references
  11. Write an absolute reference
  12. Create a Data Table
  13. Understand the IF function
  14. Write an IF function
  15. Write a PMT function
  16. Understand the VLOOKUP function
  17. Write a VLOOKUP function
  18. Use Automatic Subtotals
  19. Understand and use Advanced Filter
  20. Understand and use Database functions
  21. Understand and use SUMIF and COUNTIF functions
  1. Grouping Sheets
  2. Understanding 3-D references
  3. Writing a 3-D formulas
  4. Writing a 3-D function
  5. Creating Charts
  6. How to organize data into spreadsheet format
  7. Using the PROPER and CONCATENATE text functions
  8. Use the Insert Function feature
  9. Understand and use the AND function
  10. Protect worksheets
  11. Chart overview interactive activity
  12. Create and use Excel tables
  13. Create a combination chart
  14. Create a Bar of Pie chart
  15. Create a pictograph
 
  Word Videos to top
 
  1. Selecting Text
  2. Indenting text
  3. Mail merge
  4. Use Resume tools
  5. Use Word Tables
   
  PowerPoint Videos  
 
  1. Using the PowerPoint Slide Master
  2. Tour the PowerPoint environment
 
  Folder and File Management  
 
  1. Self-paced instruction on basic tasks such as creating folders, zipping and unzipping files, understanding file extensions, and more!
  2. Zip files and folders
  3. Unzip folders
 
  Miscellaneous to top
 
  1. DC Chapter 9: Communications and Networks Part 1
  2. DC Chapter 9: Communications and Networks Part 2
  3. DC Chapter 10: Databases
  4. DC Chapter 12: Information System Development Part 1
  5. DC Chapter 12: Information System Development Part 2
  6. DC Chapter 13: Programming Languages and Program Development Part 1
  7. DC Chapter 13: Programming Languages and Program Development Part 2
  8. Tour of Sauk's network
  9. Coding in HTML
  10. Writing code in VBA for Excel
  11. Integrating the Office applications
 
     
 
(c) 2007-8 by V. A. Wittman. All rights reserved.