Free Microsoft Office Training and Tutorials Blog

Blog Roll:
Free Microsoft Office Training & Tutorials
Free Adobe & Macromedia Training & Tutorials
Free Web Development Training & Tutorials
Intelligentedu.com Blogs
- Free Technical Computer Training
- Free Computer Books & Ebooks

Top Links:
Free Training By Email
Free Computer Training from EdComp
Free Computer and I.T. Training

56 Visio Tutorials and Tips

June 30, 2006, 10:00 pm

For those of you looking for help with learning the features of Visio, along with drawing its lines and arrows and using its shapes and graphics, here are a total of 56 Visio Tutorials and Tips. Included are several Visio learning articles and how to tutorials from Design Draw, one tutorial each from the Universities of Texas and Arizona, and four Visio tutorials from CNet.

Visio Tutorials and Tips from Design Draw

Visio Tutorials and "How-to" articles

Visio Tips

University of Texas Course 325: Database Model Diagram Visio Tutorial

University of Arizona Visio Tutorial - Draw a Data Flow Diagram Step by Step

4 CNET Visio Tutorials

Create Effective Visio diagrams for Network Documentation

Visualize Deadlines in Visio

Create a Timeline in Visio to Help Team Members Visualize Deadlines

Create your Own Custom Stencils in Microsoft Visio

by computer_teacher in general
0 Comments

How Tos and Tutorials for Word, Excel, and Access

June 22, 2006, 9:59 pm

The Alabama Cooperative Extension System hosts these well written Microsoft Office tutorials. Included here are several How Tos for Word, Excel, and PowerPoint, and 3 excellent Tutorials for Access.

How Tos and Tutorials for Word, Excel, and Access

Microsoft Word How Tos:

Create Tab Stops with Leader Characters

Create Headers and Footers

Text Wrapping for Clip Arts

Center Text on a Page

Create a Hyperlink

Using Mail Merge in Microsoft Word
(envelopes, labels, and letters)

Microsoft Excel Ho Tos:

Perform IF Functions

Use Absolute and Relative Cell References

Link from One Cell to Another in a Workbook

Enter a Formula Across Worksheets

PowerPoint How Tos:

Run a Continuous Presentation (Kiosk) with Music or Sound (XP and 97)
Dim Text after an Animation

Microsoft Access Tutorials: Beginning, Intermediate, and Advanced:

Access XP Level 1 (42 pages, 762kb)
Introduction to databases and Tables

Access XP Level 2 (33 pages, 665kb)
Forms and Queries

Access XP Level 3 (40 pages, 820kb)
Reports and Controls

by computer_teacher in general
0 Comments

Free Training Manuals for Word, Excel, and Powerpoint

June 20, 2006, 10:38 pm

Here are several well written online training manuals for Microsoft Word, Excel, and Powerpoint from Seattle University. These will show you how to use both basic and and advanced features of these Office applications.

Free Training Manuals for Word, Excel, and Powerpoint

Microsoft Word

Use the introduction manual for an overview of Microsoft Word, creating simple documents with formatting. Then go on to look at the Mail Merge and Forms manuals for experience with these Word features.

Introduction to Microsoft Word

Mail Merge

Microsoft Word Forms

Organization and Layout of Microsoft Word Documents

Microsoft Excel

Use the introduction manual to learn to create spreadsheets with impressive formatting and basic calculations. Then review the second manual for instructions on database management including sorting, filtering and grouping data.

Introduction to Microsoft Excel

Worksheets, Database Management and Printing

Microsoft Excel Charts

Microsoft Excel Formulas, Functions, Linking & Protecting

Microsoft PowerPoint

Learn to create impressive and memorable presentations for class or business.

Introduction to Microsoft PowerPoint

PowerPoint Graphics

PowerPoint Presentation Options

Microsoft Office

Use this document to help you learn to quickly and easily move data between the various Microsoft Office programs.

Importing and Exporting for Microsoft Office

by computer_teacher in general
0 Comments

Microsoft Office Quick Refrence Cards

June 19, 2006, 10:22 am

Here are Free Quick Reference Cards for the 2003 versions of Word, Outlook, Excel, PowerPoint, Access, and Windows XP. Each of these are in pdf format and are 2 pages in length. Download one or all of them and print them, share them, or post them.

Microsoft Office Quick Refrence Cards

Microsoft Word 2003

Microsoft Outlook 2003

Microsoft Excel 2003

Microsoft PowerPoint 2003

Microsoft Access 2003

Microsoft Windows XP

by computer_teacher in general
0 Comments

Microsoft Excel Tutorial

June 16, 2006, 11:32 am

Excel allows you to create spreadsheets much like paper ledgers that can perform automatic calculations. Each Excel file is a workbook that can hold many worksheets. The worksheet is a grid of columns (designated by letters) and rows (designated by numbers). The letters and numbers of the columns and rows (called labels) are displayed in gray buttons across the top and left side of the worksheet. The intersection of a column and a row is called a cell. Each cell on the spreadsheet has a cell address that is the column letter and the row number. Cells can contain either text, numbers, or mathematical formulas.

This tutorial hosted by Bradley University teaches many features you will need to understand and know how to use if you are planning to use Excel in your work or at home. Included are some advanced functions, such as recording and running macros, graphics, charting, and mail merge.

Microsoft Excel Tutorial

Basics
Screen Elements
Adding and Renaming
Standard Toolbar

Customizing
  Menus
  Toolbars
  Recording Macros
  Running Macros

Modifying a Worksheet
Moving Through Cells
  Adding Rows and     Columns
  Resizing
  Selecting Cells
  Moving and Copying
  Freeze Panes