Free Training Videos for Microsoft Office Applications
March 31, 2006, 11:53 pm
Here are 7 video.google.com searches for free educational and training videos covering the Microsoft Office applications: Word, Excel, PowerPoint, Outlook, Access, and Publisher, along with 2 links for free OpenOffice videos. These should give you a good flavor of what kinds of free videos are available at this site and how to search for them.
Free Microsoft Word Training Videos
Free Microsoft Excel Training Videos
Free Microsoft PowerPoint Training Videos
Free Microsoft Outlook Training Videos
Free Microsoft Access Training Videos
Free Microsoft Publisher Training Videos
Free Microsoft Office Training Videos
Free OpenOffice Training Videos
Free Open Office Training Videos
Free Microsoft Word Training Videos
Free Microsoft Excel Training Videos
Free Microsoft PowerPoint Training Videos
Free Microsoft Outlook Training Videos
Free Microsoft Access Training Videos
Free Microsoft Publisher Training Videos
Free Microsoft Office Training Videos
Free OpenOffice Training Videos
Free Open Office Training Videos
Excel 2002 Training Course
March 30, 2006, 11:49 pm
This freely available Excel course focuses on preparing you to take the Microsoft Office User Specialist (MOUS) Excel 2002 Core exam. It assumes familiarity with Excel 2000 or Excel 2002, and is intended to assist users in reviewing how to use Excel 2002 in developing and creating spreadsheets. In this course, you will review the Excel 2002 features used when working with cells, including entering data into cells, editing cells, moving cells, and creating hyperlinks in a spreadsheet.
For each training module below, a link for text-only training content is listed first, followed by the link for computer based training (CBT) with Graphics, for which the quizzes are not freely available and Internet Explorer is required.
Excel 2002: Working with Cells:
Text-only training:
http://tinyurl.com/j9fqf
CBT training:
http://tinyurl.com/znau3
In this unit, you will explore the types of data that can be entered into a spreadsheet, as well as ways to select a cell and format its contents.
Excel 2002: Working with Files:
Text-only training:
http://tinyurl.com/gvt8x
CBT training:
http://tinyurl.com/z8ofj
In this unit, you will discover how to locate and open a file using different search options. You will also learn how to use Excel to create folders to help you organize your files. Finally, you will use templates to create workbooks.
Excel 2002: Formatting Worksheets:
Text-only training:
http://tinyurl.com/fdr6n
CBT training:
http://tinyurl.com/hczjz
In this unit, you will learn different methods for applying formatting changes to cells, including font changes, borders, patterns, and background color.
Excel 2002: Page Setup and Printing:
Text-only training:
http://tinyurl.com/jd45b
CBT training:
http://tinyurl.com/zyeor
In this unit, you'll learn how to preview and print worksheets, and you'll learn how to use the print options available to you in the Print dialog box and the Print Preview window. You'll also learn how to preview a worksheet as a Web page before you convert it.
Excel 2002: Worksheets and Workbooks:
Text-only training:
http://tinyurl.com/ekcjj
CBT training:
http://tinyurl.com/kmwcu
In this unit, you will learn how to insert and delete rows and columns. You will also learn how to hide and unhide rows and columns. Finally, you will learn how to freeze and unfreeze rows and columns, and split a worksheet.
Excel 2002: Formulas and Functions:
Text-only training:
http://tinyurl.com/ermab
CBT training:
http://tinyurl.com/k8cvd
In this unit, you will be working with formulas. You will learn how to create a formula by typing and by selecting cell references. You will also learn how to revise formulas.
Excel 2002: Charts and Objects:
Text-only training:
http://tinyurl.com/j8zng
CBT training:
http://tinyurl.com/l4zre
In this unit, you'll learn two ways to create a chart. You'll learn how to create a default chart quickly. You'll also learn how to create a chart specific to your needs using the Chart Wizard.
For each training module below, a link for text-only training content is listed first, followed by the link for computer based training (CBT) with Graphics, for which the quizzes are not freely available and Internet Explorer is required.
Excel 2002: Working with Cells:
Text-only training:
http://tinyurl.com/j9fqf
CBT training:
http://tinyurl.com/znau3
In this unit, you will explore the types of data that can be entered into a spreadsheet, as well as ways to select a cell and format its contents.
Excel 2002: Working with Files:
Text-only training:
http://tinyurl.com/gvt8x
CBT training:
http://tinyurl.com/z8ofj
In this unit, you will discover how to locate and open a file using different search options. You will also learn how to use Excel to create folders to help you organize your files. Finally, you will use templates to create workbooks.
Excel 2002: Formatting Worksheets:
Text-only training:
http://tinyurl.com/fdr6n
CBT training:
http://tinyurl.com/hczjz
In this unit, you will learn different methods for applying formatting changes to cells, including font changes, borders, patterns, and background color.
Excel 2002: Page Setup and Printing:
Text-only training:
http://tinyurl.com/jd45b
CBT training:
http://tinyurl.com/zyeor
In this unit, you'll learn how to preview and print worksheets, and you'll learn how to use the print options available to you in the Print dialog box and the Print Preview window. You'll also learn how to preview a worksheet as a Web page before you convert it.
Excel 2002: Worksheets and Workbooks:
Text-only training:
http://tinyurl.com/ekcjj
CBT training:
http://tinyurl.com/kmwcu
In this unit, you will learn how to insert and delete rows and columns. You will also learn how to hide and unhide rows and columns. Finally, you will learn how to freeze and unfreeze rows and columns, and split a worksheet.
Excel 2002: Formulas and Functions:
Text-only training:
http://tinyurl.com/ermab
CBT training:
http://tinyurl.com/k8cvd
In this unit, you will be working with formulas. You will learn how to create a formula by typing and by selecting cell references. You will also learn how to revise formulas.
Excel 2002: Charts and Objects:
Text-only training:
http://tinyurl.com/j8zng
CBT training:
http://tinyurl.com/l4zre
In this unit, you'll learn two ways to create a chart. You'll learn how to create a default chart quickly. You'll also learn how to create a chart specific to your needs using the Chart Wizard.
Illustrated Tutorials for Word, Excel, and PowerPoint
March 28, 2006, 10:39 pm
The following are illustrated tutorials of how to perform many tasks and functions in Microsoft Word, Excel, and Powerpoint. These are courtesy of the Center for Instructional Materials and Computing at the University of Wisconsin.
.
.
Basics of Word 2000 - 2002
Module Objectives:
Upon completion of this module students will have the skills necessary to:
Insert page numbers into a document
Recover the last thing deleted
Insert indents, numbered lists, and bulleted lists
Insert a picture into the document
Basics of Excel 2000
Module Objectives:
After completing this module students will have the skills necessary to
Define basic spreadsheet concepts
Enter and edit data in a worksheet
Set a page display and printing options
Microsoft PowerPoint 2002
Module Objectives:
After completing this module students will have the skills necessary to
User Guides for Word and Excel
March 23, 2006, 10:16 pm
Here are 2 well written and informative Microsoft Office user guides, one each for Word and Excel. The Word booklet is aimed for the type of user who is familiar with Word and would like to learn and use some of its more advanced features. It is aimed
particularly at those who compile large documents, books, reports, etc.
The Excel booklet helps you learn some basics, along with charting,
pivot tables, Gantt charts, and using Excel as a database. Two video
viewlet tutorials are also linked to in the Excel section below.
Using Word - 25 page guide in pdf format
|
Fonts,
Text
|
|
| Tables | |
| ShortCut Keys | |
| Section Breaks | |
| Headers & Footers | |
| Equations | |
| Proofreading / Managing revisions | |
| -
Track Changes - Merging revisions - Resolving Proposed Changes - Comments |
|
| Templates | |
| Styles | |
| -
Using Styles - Creating Styles 1. Create by example 2. Automatic style changes 3. Format styles via style dialog box - Changing Styles - Identifying TOC (table of contents) styles |
|
| Master Documents | |
| - Creating a master document and subdocuments | |
| Creating a Contents Page | |
| Creating a Contents page for a Master document | |
| Updating a contents | |
| Creating an Index | |
| Creating Forms | |
| Tips on incorporating images | |
Using Excel - 21 page guide in pdf format
|
The
Excel Screen
|
|
| Functions exclusive to Excel | |
| Worksheet Navigation | |
| Formatting Entries | |
| Using Formulas, Functions (including Statistics Functions) | |
| Copying / Moving | |
| Controlling the worksheet View | |
| -
Windows Arranged - Freezing columns and rows - Splitting the screen |
|
| Printing | |
| Spreadsheet Charts | |
| Preparing a scatter graph | |
| (watch
a viewlet)Error bars (watch a viewlet) Inserting a Trendline |
|
| -
Example: Bradford's - Example: Error bar data |
|
| The Excel Database | |
| -
Database Table Rules - Searching a Database |
|
| Pivot Tables | |
| Creating Gantt charts | |
| - Creating a Dynamic Gantt Chart | |
Microsoft Word Tutorials, Helps, Tips, and Tricks
March 21, 2006, 11:02 pm
Shauna Kelly, a Microsoft MVP, provides many excellent Microsoft Word online tutorials, helps, tips, tricks, and a FAQ. These have a special emphasis on Word styles, formatting and numbering.
Styles in Microsoft Word
Formatting
- How the Styles and Formatting pane works
- Why does text change format when I copy it?
-
How Paste Options works
Numbering, Bullets, Headings, Outlines
- How to control bullets
- How to create numbered headings or outline numbering
- Why use Word's built-in heading styles?
- How to number headings and figures in Appendixes
- How to create a table of contents in Microsoft Word
-
How Document Map works in Microsoft Word
Templates
- What is the relationship between a Word document and its template?
-
What happens when I attach a new template to my document? or
How do I copy content and settings from a template to a document?
Layout
Sharing Microsoft Word documents
- What happens when I send my document to someone else?
- How does Track Changes in Microsoft Word work?
- How to use the Reviewing Toolbar in Microsoft Word 2002 and Word 2003
-
How do I control how a Word document opens from the internet or an intranet?
Downloads
Resources
- Microsoft Word news
- Office 2007 information
- Trivia, some of it about Word
- Contents of this site
- Search this site
- Getting help, asking questions
For new users of Microsoft Word