Free Microsoft Office Training and Tutorials Blog




    



Free Training Videos for Microsoft Office Applications

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

Excel 2002 Training Course

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.

Illustrated Tutorials for Word, Excel, and PowerPoint

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:

Create a new blank document

Use the Save As command

Open and edit a document

Change fonts and sizes

Insert page numbers into a document

Copy, cut, and paste text

Recover the last thing deleted

Insert indents, numbered lists, and bulleted lists

Create line spacing

Insert a picture into the document

Create a table

Create a header and footer

Modify margins

Create page breaks

Preview and print a document


Basics of Excel 2000

Module Objectives:
After completing this module students will have the skills necessary to

Define basic spreadsheet concepts

Open and Save files

Enter and edit data in a worksheet

Sort data

Format a worksheet

Perform calculations

Create and format charts

Set a page display and printing options


Microsoft PowerPoint 2002

Module Objectives:
After completing this module students will have the skills necessary to

Create Presentation Graphics

Type slide text

Create a New Slide

Menus

Insert tables

Slide Design

Slide transitions

Custom Animations

Add presentation notes

Print notes and slides

Run a slide show manually or automatically


User Guides for Word and Excel

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

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.


Sharing Microsoft Word documents


Downloads


Resources



Page :  1 2 3 4