Education Online: Free and fee-based computer software training

       Newsletter for
Computer Software Education, Training & Tutorial Resources

          *** ISSUE #14 - April 2004 ***

     This Newsletter is only sent to its subscribers and
     is available in May, 2004 on the web at

     Newsletter Archives are here:

     Subscribe and unsubscribe instructions are at the end.

Please forward this newsletter to all your friends
and associates who might be interested!

In This Issue:

1)... Editor's Greeting

2)... Best New Free Microsoft Office Training & Tutorial Sites

3)... The Best New Free Training Sites for Flash, Photoshop, Dreamweaver, FrontPage, & other Adobe / Macromedia Applications

4)... Best New Free Web Development Training Sites

5)... Best New Free Windows, Linux, Hardware & Computer Training

6)... Software, Office and Computer Sites Worth Mentioning

7)... Question of the Month about Software Training

8)... Please Support Our Computer Training Mission


1) Editor's Greeting:

Hello everyone, and welcome to our new subscribers!

This issue marks our 13th monthly Newsletter for, giving you the most current Free online Software Training and Tutorial Resources that we have recently discovered and researched. This newsletter is free to anyone subscribing (instructions at bottom, no username/password is needed). To access our member site, however, you do need a user name and password - registering as a member of costs only $14 for two months, for more information please see Become a Member of

My desire is that these free resources will help you with your computer education and training and are tools to advance your career. Our main mission is the training of those less fortunate who are seeking to become computer literate, from a user's perspective.

By means of this email newsletter, you have knowledge of and access to these sites before our web site visitors do. The best of these resources will be added to our Member Training pages and the remainder to our Free Training pages.

*** Current Issue ***

In this issue we are featuring a total of 31 Software and Computer training, learning and tutorial web sites, with a total of 269 tutorial courses linked. It features many free Microsoft Office training tutorials for your learning profit and enjoyment. 

For your convenience, this newsletter is also available to subscribers in HTML format at this special url:

If you are looking for free technical or programming training, please visit our sister site:

I wish you the best with your computer studies and learning.

Warm Regards,
Jeff Love Newsletter and Web Site Editor


"Learn New Skills and Increase Your Earning Power
 - With Free Online Computer Training!"

*** Become a Member of *** 

Our Members' Site contains the web's best Microsoft Office and other software training resources and tutorials. This content is individually linked and presented in a way to expedite and facilitate your computer learning experience. We have done all the web research and presentation work for you so you can concentrate solely on your computer training. For short FAQ Answers, please see the end of this newsletter.

The total price to join as a member is only $14 total for 2 months, $24 for 4 months, $32 for 6 months, or $56 for a whole year. The funds generated will assist us to help all those seeking computer education and application end-user training. Here's the link to see what's available on our member's site and to sign up.


--> Here is Your Reward for Subscribing to this Newsletter <--

*** Get Your Free Microsoft Office Forms and Templates ***

Click here for tons of Free Office Forms and Templates:

Here's another special bonus for you: if you have a web site and want to increase it's traffic by 50%, we'll show you how - Click on this link to sign up at the best free traffic generator on the web today:



2) The Best New Free Microsoft Office Training & Tutorial Sites:

This section of our newsletter contains the best new Free Microsoft Office training and tutorial sites that we have found and researched in the last few weeks.

Microsoft Office 2000 is a software suite that consists of different applications that perform various activities. MS Office 2000 is by far the most widely recognized software suite in the world.

Skidmore Help Sheets:

  Introduction to Microsoft Word 2000:

  Using Word Templates:

  Word Collaboration:

  Introduction to Microsoft Excel 2000:

  Introduction to Microsoft PowerPoint 2000:

  Introduction to Microsoft Access 2000:


Instructional Resources from Minnesota State University:

These are instructional technology tutorial handouts for Microsoft Office applications.

  Word: Mail Merge:

  Word: Numbers, Bullets and Outlines:

  Word Part I:

  Word - Setting tabs:

  Word - Tables:

  Word - Tips and Tricks:

  Excel Basics:

  Excel Part I:

  Excel Part II:


  Publishing PowerPoint files to the Web:

  Recording Narration in PowerPoint:

  Access Part I :

  Access Part II:

  Access Queries:

  Access Definitions:


Microsoft Office Training Tutorials and Help documents:

  Microsoft Word:

  Microsoft Excel:

  Microsoft PowerPoint:

  Microsoft Access:


Computing Services IT Training Manuals:

Some of the courses require files to work on. These are available here:

  Word Introduction:  
  Can be used also with Word 97, 98, 2000, 2001, 2002 and X.

  Word Intermediate:  
  Applies to Word 97, 2000 and 2002 and can be used with 98, 2001 and X.

  Word Advanced:  
  Applies to Word 97, 2000 and 2002 and can be used with 98, 2001 and X.

  Excel Data Presentation:  
  Applies to Excel 97, 2000 and 2002 and can be used with 98, 2001 and X.

  Excel Introduction:  
  Applies to Excel 97, 2000 and 2002 and can be used with 98, 2001 and X.

  Excel List/Database Management:  
  Applies to Excel 97, 2000 and 2002 and can be used with 98, 2001 and X.

  Excel Advanced:  
  Applies to Excel 97, 2000 and 2002 and can be used with 98, 2001 and X.

  Excel VBA Macro development:

  Access Introduction:  
  Applies to Access 97, 2000 and 2002.

  Access Advanced Queries:  
  Applies to Access 97, 2000 and 2002.

  PowerPoint Introduction:

  Outlook Express Introduction:


Outlook 2000 Tutorial:

This one-page tutorial covers: Categories, Groups, Inbox, Organization, Rules, Distribution Lists, Contacts, Calendar, Tasks, Journal, and Notes.


Screenbook Computer Tutorial Library

These are very in-depth training tutorials for Microsoft Word and Excel.

Microsoft Word: A comprehensive set of 30+ tutorials with 500+ screenshots for Microsoft Word covering all important features of the application.

Word Basics

   My First Document:
   Open an Existing Document:
   Opening a Document from the Internet:
   Open a Document from Email:
   Opening Multiple Documents:
   Editing a Document:
   Special Characters:
   Formatting Text:
   Copy Formatting:
   Spatial Formatting:
   Bullets and Numbers:
   More on Tables:

Word Printing

   Print Preview:
   Printing an Envelope:
   Printing a Label:

Word Viewing and Navigating

   Document Views:
   The Document Map:

Word Special Elements

   Document Information:
   Page Numbers:
   Date and Time:
   Header and Footer:
   Footnotes and Endnotes:

Word Features and Tools

   Mail Merge:
   Printing Labels with Mail Merge:
   Text Effects:
   Clip Art:
   Table of Contents:

Microsoft Excel:  
This is a comprehensive set of 60+ tutorials with 500+ screenshots for Excel 2000, all the way from absolute beginner level (how to start the program) up to pivot tables and macros. Sample files are included which you can run on your own computer.

A Sample Excel Application

   Using Formulas:
   More on Formulas:
   Filtering and Sorting:
   Pivot Tables:

Excel Basics

   Start Excel:
   Creating a File in Excel:
   Saving a File:
   Open a Workbook:
   Finding a Work Book:
   Switching between WorkBooks:
   Email a Workbook:
   Edit or Delete Data:
   Move or Copy Data:
   Finding Data:
   Spelling Check in Excel:
   Inserting Rows or Columns:
   Deleting Rows or Columns:
   Hiding Columns:
   Naming Cells:
   Zooming In or Out:
   Splitting Worksheets:
   Entering a Formula:
   Entering Functions:
   Adding Numbers:
   Copying a Formula:
   Inserting a Worksheet:
   Switching between Worksheets:
   Renaming a Worksheet:
   Moving a Worksheet:

Excel Formatting

   Changing Column Width or Row Height:
   Font Face and Size:
   Bold Italic or Underline:
   Cell Alignment:
   More on Cell Formatting:
   Number Formats:
   Data Formats:
   Adding Borders:
   Copy Formatting:
   Clear Formatting:
   Autoformat in Excel:

Excel Printing

   Print Preview:
   Page Orientation:
   More Print Options:
   Changing Margins:
   Page Breaks:
   Specifying Number of Pages:
   Add Page Labels:
   Adding a Header or Footer:

Excel Lists and Macros

   Creating a List:
   Filtering Data in a list:
   Sorting Data in a list:
   Adding Subtotals to a List:

Excel Charts

   Creating a Chart Part I:
   Creating a Chart Part II:
   Changing Chart Type:
   Moving Resizing or Deleting A chart:
   Adding Data to a Chart:
   Printing a Chart:


3) The Best New Free Training Sites for Flash, Photoshop, Dreamweaver, FrontPage, and other Adobe and Macromedia Applications


Computing Services IT Training Manuals:

Some of the courses require files to work on. These are available here:

  Dreamweaver Introduction part 1:

  Dreamweaver Introduction part 2:

  QuarkXPress Introduction:

  PageMaker Introduction:


Instructional Resources from Minnesota State University:

These are instructional technology tutorial handouts for Web Page development.

  Macromedia Flash 5:

  Flash MX Overview:

  Flash MX Workshop:

  FrontPage 2000:

  FrontPage Forms:

  FrontPage with Database:

  Dreamweaver 4:

  Connecting to WWW in Dreamweaver:

  Dreamweaver MX:

  Adobe Acrobat:


Skidmore Help Sheets:

  Intro to Dreamweaver MX:

  Dreamweaver Site Management:

  Using Fireworks to Design & Edit Web Graphics:

  Create an Online Form:


Free Photoshop Tutorials from

Interface Photoshop Tutorials

3D Sphere:  
Make a smooth 3D sphere, can also be used for buttons.

Navigation Bar :  
Make your own tool bar using custom gradient techniques.

Simple WinAmp Skin:  
Putting together a simple WinAmp Skin. Making a lyout using the Pen tool, beveling, adding buttons, adding details.

3D Button:  
A way of creating a 3D button using radial gradients, and then making an illusion of a button being pressed using inside shadow.

Basic Photoshop Tutorials

Using Actions:  
Learn how to load, save, and record your own actions.

Loading Brushes: Brushes/LoadBrush.html  
Learn how to simply load brushes.

Photoshop Patterns:  
Define your own photoshop patterns.

Photoshop Magic:  
Discover some of the hidden images that programmers hid in photoshop.

Define Custom Brush:  
Create your own brushes.

Photoshop Effects Tutorials

Making your own rusty style:  
A step-by-step tutorial on creating rusty style in photoshop. First, create your own pattern, make the style using custom pattern, save style.

Quick Beveling: Beveling/Quick-Beveling.html  
A very quick way to create bevel, after beveling you may apply layer styles to make it look even better.

Grungy Effects:  
Create grungy effects using custom displacement maps.

Text reflection, this method can also be used for objects and making shadows.

Metallic Screws:  
Create realistic metalic screws using radial gradient and curve adjustments.

Hell Fire Effect: Fire Effect/Hell-Fire-Effect1.html  
An easy way to create a great looking fire effect. Just follow the filter techniques and you'll get it eventually.

Frozen Text:  
Give your text a realistic freezing look, using some of the photoshop filters and curve adjustments.

Metallic Text:  
A rather long way to create metal text, using channels and lighting effects, however you come up with a good metal effect and learn channels and lighting as do it.

3D Logo:  
Using the gradient tool and some layer style effects to create a good looking 3D logo.

Lemon text tutorial:  
Use a variety of techniques such as layer styles, overlaying, blurring, adding noise and more. Create lemon looking text.

Golden-crispy text tutorial:  
Add some crisp to your text using layer styles and overlaying techniques.

Raylight Wave tutorial:  
Learn how to create an energetic raylight wave using wave filter, blur techniques and overlaying.

Glowing text tutorial:  
Glowing text with overlaying modifications.

Glow Effect:  
Learn to create the all wanted Dodge Glow Effect since it was "lost" in Photoshop 7.0.

Photoshop Texturing Tutorials

Old Grungy Texture:  
Using a lot of Photoshop filters together to achive some cool looking effects - the old grungy texture.

Melting Plastic:  
Create a melting plastic effect using a combination of photoshop filters.

Stone Texture: Texture/Stone-Texture1.html  
Another tutorial using Photoshop filters, just follow the steps and you will get a unique stone texture.


FrontPage 2002 Tutorials by Tina Clarke:

Maintaining your FrontPage Website:  
How to maintain your website using FrontPage Tools and Features and the methods to employ.

How to save your Favorites and sort them for Broken links:

Using FrontPage and Internet Explorer.

Adding Table of Contents to your website with FrontPage 2002:

All about the FrontPage Table of contents and how to utilise it.

How to Backup FrontPage:
Learn how to back up your FrontPage site in a variety of different ways.

Adding Navigation To Your Website with FrontPage 2002:
Creating and Inserting a Navigation Structure.

Adding Included Content To Your Website With FrontPage 2002:
How to use include pages on your FrontPage website.

FrontPage Discussion web 2002:  
Tips and tricks for the FrontPage Discussion web, including how to send yourself emails when a message has been posted to the forum.

Adding Banners To Your Website With FrontPage 2002:
All about Working with Page Banners, Adding Comments, Inserting Timestamps.

Optimizing your FrontPage site for Search Engines:

Everything You Wanted To Know About the 'Insert Hyperlink' Dialog Box In FP2002 But Were Afraid To Ask:

FrontPage 2002 PhotoGallery:

FrontPage Subwebs and Permissions:


FrontPage 2000 Tutorial from

  How to print a Broken Links Report in FrontPage 2000:

  How to Configure your backgrounds and avoid the default look:

  Where is best place to get some Help for FrontPage?:

  Graphically Speaking:

  FrontPage 2000 FAQS, Tips, Add-ons and How-to's:

  Three FrontPage 2000 How-to's:

  FrontPage 2000 Frequently Asked Questions:

  FrontPage 2000 Tips:

  FrontPage 2000 Resource and Help Links:

  FrontPage 2000 Add-in's:


FrontPage 2000 Training Tutorial:

  New Page and Adding Color:

  Adding and Formatting Text:

  Adding, Moving and Positioning Images and Clip Art:

  Transparent, Interlaced, and Cropped Images, and DHTML Animations:

  Text and Image Hyperlinks, and Image Hot Spots:

  Create and Format Tables:

  Browser Previews and Compatibility, and Spell Check:

  View, Organize, and Expand Web site:

  Add and Customize Style and Themes:

  Forms, Radio Buttons, Check Boxes, Text Boxes:

  Send Data to Email and Database, View Database:

  Reports for Broken Links, Slow Pages, and Added Files:

  Publish to Server and Go Live:

4) The Best New Free Web Development Training Sites


Authoring for the World Wide Web:

This 20-page tutorial workbook describes how to create an HTML document for use on the Web.


HTML By Example:

A 30-chapter book - each chapter starts by explaining a particular concept, giving examples in "snippets" of HTML markup as you go along. Once you've understood each concept, you are then ready to work with a full-blown example.


HTML 2000:

This help file explains the basics to HTML and web design. It contains everything you need to know to get a basic web site online. (zipped, .chm help file format - 143.55 Kb)


Instructional Resources from Minnesota State University:

These are instructional technology tutorial handouts for Web Page development.



  HTML Code for Special Characters:

  Introduction to Metatags:

  Netscape Composer:



Web Programming Tutorials and Training from

Web Development Library:


Authoring & Site Design:














Programming & Scripting:





  Script Library:

  Web Tricks:


Reference Materials:

  CSS reference table:

  Color code converter:

  HTML tags and attributes:

  Script Library:

Smart HTML State/City picker:  
An HTML/JavaScript page showing how to create a form where the data presented by one dropdown box is determined by the choice made in another dropdown box.

XML and Microsoft Office:  
XML allows you to import and work with data that originates from applications outside of Microsoft Office, as well as export data from Office to a myriad of other data formats that your business partners may require.

Beginning Web Development in Access 2002 :
This article discusses Web development in Microsoft Access 2002 using data access pages--how data access pages work, and when to use them--as well as ways to take advantage of new features within Access 2002.

5) The Best New Free Windows, Linux, Hardware and General Computer Training Sites


Windows Tutorial Part I:

Windows Tutorial Part II:

Windows Shortcut Keys Tutorial:


Windows 2000 Basics:

Although the screenshots in this set of 40+ tutorials with 600+ screenshots were taken with Windows 2000, this set of tutorials is not just for Windows 2000. It covers the basics of Windows generally, such as what is a folder, and how to use Windows Explorer. This is information that anyone who uses any Microsoft Windows operating system should know.


Set a password-protected screensaver in Win 2000 & XP:

Set a password-protected screensaver in Mac OS X:


Platinum Edition Using Windows 98:

Special Edition Using Windows 98:


Windows Introduction:

6) Software, Office and Computer Sites and Downloads Worth Mentioning


My Outlook Calendar:

Customizable Word template for generating and printing Outlook weekly and monthly calendars. Print any Outlook calendar that you have access to, including calendars from other users' mailboxes and Public Folders. Add color coding by category or by type of item (one-day event, multiple-day event, etc.) Specify time and date formats and the title for the calendar. Freeware, 121kb, 17 Oct 2000. Available in versions for Office 2000 version (may work with Office 2002 as well) and Office 97/Outlook 98 <>.



Have you used ECCO or Lotus Organizer and miss the outlining capability? Here's a simple way to do much the same thing in Microsoft Outlook. To use it, use File | Open Special Folder | Personal Folder to open the Notebook.pst file downloaded via the link below. Then copy the Notepad folder to your Personal Folders or Exchange Server mailbox. In the Notepad folder, use Compose | New Post in This Folder to open a special form with Chapter, Heading, Page and Page Number fields that are used in the special views created for this folder. Freeware, 26kb, 22 Aug 97. Click here to download.


eBay Reminder:

Creates an Outlook appointment with a reminder for the eBay auction you're currently viewing in your browser. Free.


Calendar Updates - Free Holiday and Sport Team Schedules for Microsoft Outlook:

Conveniently add holidays and sport team schedules directly to your Microsoft Outlook calendar. Once downloaded to your computer, you will have every game or event for an entire season added to your calendar.


Outlook NameDays:

Free tool to add "name day" events for names from many countries to any Outlook calendar folder.


Public Holiday Calendar for Outlook:

Add holidays to Outlook from your home country and other countries you choose. Free.



Clock display that shows your upcoming Outlook appointments as a color-coded spiral. Free.



7) Question of the Month about Software Training:

Each month Jeff Love will answer a current or important question that we have received about computer and software training.

April 2004 Question: 

How can I create PDF files for free?


Download and install, it runs on both Windows and Linux operating systems. Here is the download page:

Once you have it installed, simply open your Microsoft Office application with it and click on the PDF icon in the toolbar. The process of creating a PDF file is automatic.

I hope this helps you.

Jeff Love


8) Please Support Our Training Mission

How You Can Support Our Computer and Software Training Mission

Please help support's Computer and Sofware Education and Training Mission by visiting our sponsors below and requesting more information. By doing so, you will be helping people who want to learn to use computers in an Information Technology career.

Learn and then apply the Financing and Investment Techniques used today to make the best financial and investment decisions possible. You'll get Free Information and Guides, Learning Materials, and Online Tools to empower you to deal with those who do this everyday. We will lead and guide you in your decisions about Auto Loans and Leases, Home Mortgages and Refinancing, Stocks, Investments, Insurance, Business Loans, Lenders and Investors.

University of Phoenix Online: Advance your career:

DeVry: Online degrees for working adults?

ITT Technical Institute: Choose from their many programs:


Free to Sell - The Ultimate eBook!
(lowest price on the web)


Search for IT Training:

Computer Colleges:


American College of Computer & Information Sciences: 
Get the degree you need to advance your at your convenience


Saint Leo University Online:
Accelerated Online Degree Programs: Business and Accounting, Computer Information, Criminal Justice, Liberal Arts.


University Alliance Schools:
Accelerated degrees and flexible online courses with streaming video lectures

Free Computer Software Training Now!

A free and member-based software educational and training portal web site. We have compiled, categorized, described, and linked many sites that will be of keen interest to computer software application end-users seeking free training and knowledge. Many subject areas are covered, including Microsoft Office, Flash, Photoshop, Dreamwever, FrontPage, Web Development, Windows, Linux, and Computer Hardware. You are able to study and learn all about computer software via Free training, courses, tutorials, documentation, articles, tips, notes, and help. Check us out today.

Copyright Notice: Please note that all of the items hyperlinked are copyrighted by their authors and/or publishers. You are expected to look for, read, and adhere to such notices. Downloaded and online material is copyrighted whether or not a copyright notice is present.


***'s Member Site ***

Our Members' Site contains the web's best computer software training resources and tutorials. This content is individually linked and presented in a way to expedite and facilitate your software and computer learning experience. We have done all the web research and presentation work for you so you can concentrate solely on your computer training. Member Site FAQ Answers:

  1. All of the web sites and pages in our members site are not in the free section of our web site. The member site training is more detailed and the best available. The online training resources in our members' site are linked and laid out in a much more detailed fashion than those in the free section. This will save you time in finding all the best free training on the web.
  2. You can choose to pay using either Paypal or 2Checkout. If paying pay check and you live in the U.S., please select 2Checkout.
  3. You have a choice to select the non-recurring or recurring method of payment. If you select non-recurring, when your membership period expires, you will not be automatically charged another fee on your credit card or check.
  4. The total price to join our member's site is only $14 total for 2 months, $24 for 4 months, $32 for 6 months, or $56 for a whole year. The funds generated will assist us to help all those seeking software application education training. Here's the link to see what's available on our member's site and to sign up: You can email Jeff Love with questions.

I will give you 5 Great Free Bonuses when you sign up now.

These are as follows:

  1. 28 Modules of Soft Skills Training, covering topics such as Coaching, Delegating, Finance Essentials, Hiring, Leading and Motivating Team, Making a Presentation, Managing Your Time, and Setting Goals.
  2. 19 Online Business and Reference Books, including titles such as Scientific Advertising, The Art of Electronic Publishing, and Small Business Manual
  3. 12 Instructive e-Books, including On Line Stealth Marketing, 7 Secrets to Unlimited Traffic, and Increase Auction Profits.
  4. Instant and Easy Online Access to the 24 Best Free Computer Help & Support Sites.
  5. 45 of the Best, Completely Free Programs and Utilities.

To Subscribe to this Free monthly Newsletter of Computer Education, Training, & Tutorial Resources simply send a blank email to this address: 
(You will need to confirm using a link in a confirming email.)

Or go to this web page and use the subscribe form

To Unsubscribe
from this Free monthly Newsletter of Computer Education, Training, & Tutorial Resources simply send a blank email to this address:
(no need to confirm)

Or simply go to this web page and use the unsubscribe form:


Thank You!