Be sure to check out our Blogs and discover all the new Free Training!
Newsletter for EducationOnlineForComputers.com
Computer Software Education, Training & Tutorial Resources
*** ISSUE #27 - July 2006 ***
This Newsletter is only sent to its subscribers and
is available in August, 2006 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 is the July 2006 issue (#27) of our Free monthly Newsletter for EducationOnlineForComputers.com, giving you the most current Free online Microsoft Office and Web Development 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 EducationOnlineForComputers.com costs only $14 for two months, for more information please see Become a Member of EducationOnlineForComputers.com.
My desire is that these free resources will help you with your computer education and training and will help you 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.
In this issue we are featuring a total of 28 Computer Software Application training, learning and tutorial web sites, with a total of 65 tutorial courses linked. It features many Free Microsoft Office, Flash, Photoshop, Dreamweaver, and Web Development training tutorials for your learning profit and enjoyment.
*** Current Issue ***
Please take a look at and bookmark our Blogs, these will be updated daily and weekly with New Free Training and Tutorial Resources, as I discover and evaluate them:
- Free Microsoft Office Application Training
- Free Web Development Training
- Free Adobe & Macromedia Training
- Free Technical Computer Training
- Free Computer Books & Ebooks
To get your Free MS Office and Web Development Software Training updates via RSS, please copy (right click and copy shortcut or link location) and paste these urls into your RSS reader:
Please visit our New Free Training and Tutorial Search Engine, Edcomp.com - We have deployed a new website at www.edcomp.com that is a search engine with a large database of over 150,000 free IT education and training web resources, with another 70,000 free resources reserved exclusively for paid members. If you're an educationonlineforcomputers.com member, go to http://www.edcomp.com/members/ to access the special members' page for searching 220,000 free training web resources.
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:
Also, please check out our new free computer training search site at www.edcomp.com.
I wish you the best with your computer studies and learning.
Jeff Love Newsletter and Web Site Editor
"Learn New Skills and Increase Your Earning Power*** Become a Member of EducationOnlineForComputers.com ***
- With Free Online Computer Training!"
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.
This is our new free computer and IT education and training search engine housing over 140,000 free training internet resources! Just type in a topic you're looking for and get tons of great web resources instantly. These search results are much better than the big search engines, like google. You can also check out our predefined search results page giving you tons of free training resources: http://www.edcomp.com/predefined.htm.
--> 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
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.
TrainingByEmailVisit TrainingByEmail to receive Free Training for Word, Excel, Outlook, C#, ASP.Net, and SQL via your email every week! We will send out a new training in the topic of your choosing every week. You can then save this, print it out, or delete it all at your convenience. And you can't beat the price, FREE!
Microsoft Office Quick Refrence Cards
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 Word 2003
Microsoft Outlook 2003
Microsoft Excel 2003
Microsoft PowerPoint 2003
Microsoft Access 2003
Free Training Manuals for Word, Excel, and Powerpoint
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.
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
Microsoft Word Forms
Organization and Layout of Microsoft Word Documents
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
Learn to create impressive and memorable presentations for class or business.
Introduction to Microsoft PowerPoint
PowerPoint Presentation Options
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
How Tos and Tutorials for Word, Excel, and Access
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.
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:
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
Microsoft Excel Tutorial
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.
Formulas and Functions
Releative, Absolute and Mixed Referencing
Sorting and Filling
Alternating TExt and Numbers with Autofill
Mail Merge Exercises
Excel Formulas, User-defined Functions, and Excel VBA
Alan Barasch has specialized in Excel for twelve years. He provides these excellent Excel Formulas, User-defined Functions, and Excel VBA coding examples on These will greatly help you to understand how these advanced Excel features work and how to use them so you can get Excel working to its maximum potential.
Microsoft Access Tutorial
Microsoft Access is a powerful program to create and manage your databases. It has many built in features to assist you in constructing and viewing your information. Access is much more involved and is a more genuine database application than other programs such as Microsoft Works.
This Microsoft Access tutorial, from Bradley Univerisy, will help you get started with Microsoft Access and may solve some of your problems, and included are some advanced functions, such as linking relationships, creating a report, and creating mail merge. It is also a good idea to use the Help Files that come with Microsoft Access, or go to Microsoft's web for further assistance.
Using the wizard
Creating a database without using a wizard
Create a table
Using the Wizard
Creating a Form Using Wizard
What they are
Creating A Report
Using A Wizard
Creating Mail Merge
Labels using aWizard
56 Visio Tutorials and Tips
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.
3) The Best New Free Training Sites for Flash, Photoshop, Dreamweaver, FrontPage, and other Adobe and Macromedia Applications
38 Latest Photoshop Tips and Tutorials from Adobe
Here are the 38 latest and most current Tips and Tutorials for Photoshop, direct from the graphic application's creator, Adobe. Linked and described here are all of the newest Photoshop tutorials written in the last 6 months. You can also search by topic, content type, and level.
Beginning and Advanced Flash Tutorials
Using Flash, you can develop and create rich multimedia web content sites with ease. Flash is a vector-based program, which means that the graphical information is stored in the form of mathematical formulae rather than pixel tables, so Flash files take up less space compared to animated graphic files. In addition to animations, Flash can be used to create complex multimedia content with interactivity, sound, drop down or scrolling menus, animated buttons, custom animated cursors and even games
Webdevelopersnotes.com offers the following excellent Flash tutorials to help you learn this important web development application. This site also offers some great advanced Flash tutorialsFlash Tutorials
The series of lessons in this tutorial guide you through the following features and concepts of Flash:
Advanced Flash Tutorials
- Drawing tools.
- Frames, Layers and the Stage.
- Movie properties.
- Basic controls and commands available in the Flash menu.
- Embedding Flash in HTML pages.
- Symbols and why they are required.
- Creating and modifying symbols.
These Flash tutorials will help you learn how to make things move around using Flash and to bring interactivity to Flash movies.
Free Ebook for Macromedia Flash 8
Here is a blog post at ebooks.bloggoing.com about a freely available ebook covering Flash 8. This ebook will demonstrate step-by-step and with screen shots how to use Flash 8 and its features, including the improved script editor (with a visual interface), a revamped library interface, a new undo feature, new run-time effects, and excellent motion-graphics capabilities. By reading this guide you'll learn Flash 8 quickly, from basic vector graphics to animation with motion tweening and more. To access the download link on rapidshare.de, click on the Free button at the bottom right of the rapidshare page, wait about 30 seconds, then enter the 3 character code and click on the download button. Note the required password to uncompress the file. To uncompress .rar files you can use 7-Zip.
Free Ebook for Learning Flash Actionscript
Here is a blog post at ebooks.bloggoing.com for a freely available ebook covering Flash 8 Actionscript. Flash 8 has an improved scripting language, which includes a visual interface. This Flash ebook provides hands-on lessons and simple, step-by-step instructions, translating real-life activities into scripts. It also includes methodologies and techniques for building nearly 40 real-life Flash 8 ActionScript projects, including sample games, wireless applications, Web sites, and more. By mastering these Flash Actionscript projects, you will be able to use Flash more efficiently and work faster. To access the download link on rapidshare.de, click on the Free button at the bottom right of the rapidshare page, wait about 30 seconds, then enter the 3 character code and click on the download button. To uncompress .rar files you can use 7-Zip.
Dreamweaver 8 Knowledge Pages from MIT
Here is good information to know when installing or upgrading to Dreamweaver 8. Short tutorials are also offered for CSS, Accessibility, and Template features of Dreamweaver. These Dreamweaver knowledge pages are provided by the Information Services and Technology department at MIT.
Dreamweaver 8 for Windows
4) The Best New Free Web Development Training Sites
Top 20 Training and Tutorials Sites on Digg.com for last month
- 15 Exercises for Learning a new Programming Language
- AJAX Feedback Mechanism
- PHP - Top Ten Security Vulnerabilities
- Converting Windows executables to Mac OS X or Linux binaries
- How to Write FireFox Extensions
- Compilr - Compile C, C#, VB, and Fortran programs online
- 5 Worthy CSS Tips
- Learn How to Create a Keygen
- Configuring Rails Environments: The Cheat Sheet
- Password hashing using PHP and MySQL
- The Windows XP Command Line, Batch Files, and Scripting
- 100+ powerpoint presentations on improving your PHP skills
- What's The Secret Sauce in Ruby on Rails?
- Build RSS reader using AJAX and PHP
- Learn CSS
- Cut through AJAX hype
- C# FAQ for C++ programmers
- Collection of AJAX Tutorials
- 195 Free Online Programming Books
Web Development Tutorials from the Shadow Fox Network
XML Learning GuideThis guide explains what XML is, how it's used, and where it fits into the world of Web services. Here you will find XML articles, tutorials, examples, tips, tools, white papers, expert advice and more to increase your XML knowledge and understanding. XML (Extensible Markup Language) is a flexible way to create common information formats and then consistenly share both the format and the data on the WWW, intranets, and elsewhere. Using a standard way of describing data, as XML allows, enables users to send an intelligent agent (a program) to a target, such as a web site, gather data, make a comparison of the data, and then send back results to the user..
XML Security Learning Guide
Securing XML is an essential element in keeping Web services secure. This XML Security Learning Guide is a compilation of resources that review different types of XML security standards and approaches for keeping your XML Web services secure.
Fast Guide to Web Services Security
This SearchWebServices.com guide introduces you to Web Services Security -- highlighting the inherent challenges of securing Web services while providing you with strategies to overcome these challenges. You'll find articles, tips, white papers, expert advice and more to arm yourself against would-be invaders.
67 Beginning and Advanced PHP Tutorials
PHP is an open-source, reflective programming language. Originally designed as a high-level tool for producing dynamic web content, PHP is used mainly in server-side applications. PHP 5 is the latest version and includes new features such as PHP Data Objects and more performance enhancements. PHP generally runs on a web server, using PHP code as its input and creating Web pages as output.This link is to a blog post of mine on Intelligentedu.com that provides a wide selection of 67 well written PHP tutorials, covering PHP training from Beginner to Advanced to Object Oriented.
Basic and Advanced HTML Tutorials
Webdevelopersnotes.com offers online tutorials to help you learn Basic HTML (HyperText Markup Language) and Advanced HTML. The site's main tutorial page is located here. Also check out their Web Page Design and Web Graphics Design tutorial pages. The basic HTML tutorials describe and explain common HTML tags. The advanced HTML tutorials teach you how to embed sound and video content, how to control HTML colors, use tables, frames, forms and image maps.
5) The Best New Free Windows, Linux, Hardware and General Computer Training Sites Microsoft Windows XP Quick Reference Guide
This 2 page reference guide shows you the parts of a typical window, keyboard shortcuts, items on the start menu, and helpful tips,
Computer Basics - Guides and Tutorials
- 64-bit Computing
- Active Directory (Plan and Design)
- Active Directory (Management)
- Computer Memory: Troubleshooting
- Hardening Windows School
- Increase Scripting Expertise
- Migrating to Windows Server 2003
- Memory Basics
- Microsoft Operations Manager
- Prevention Guide: Detecting and removing rootkits
- Printer Management
- Scripting Guide for Beginners
- Step-by-Step Guide: Patch management must-do list
- Windows: Detecting and Removing rootkits
- Windows Group Policy
- Windows Server Migration
- Windows Terminal Services
WinZip Tutorial (low bandwidth)
WinZip Tutorial Movie (high bandwidth)
6) Software, Office and Computer Sites and Downloads Worth Mentioning
10 Free Plug-ins to Enhance Photoshop
Photoshop plug-ins do a variety of things, such as creating new image effects or performing actions that might otherwise be impossible. Photoshop has one of the largest collections of plug-ins available, some are free but many come with a fee to pay. Here is a collection of 10 favorite Free Photoshop plug-ins, all of which fall within the filters category.
Embedding fonts in MS PowerPoint
This is a short how-to on putting fonts into a PowerPoint presentation so you are sure they will be used, instead of relying on the fonts installed on the computer the presentation is running on. Also, see Package your presentation to run on another computer on Microsoft's website.
Outlook Express signature with pictures
Ever wanted to have your logo and a slogan in your email signature? In Outlook Express more difficult to do than in Outlook. This is a tutorial on how to add a signature that also has an image in it.
Voice Mail Compressor
This is a cool freebie that allows sending voice email messages. Using Voice Mail Compressor you can send voice email messages to anyone with an e-mail address. Voice Mail Compressor generates compressed .wav files reducing the size from 16 to 10 times. The recipient doesn't need any special software to listen your messages, all they do is double-click the file and then listen to it using the default audio player.
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.
July 2006 Question of the Month:
I am looking for free Excel Add-ins to use so I can do more with my spreadsheets. Can you direct me to some good Excel add-ins?
Here is what you need... ASAP Utilities is one of the world's most popular Free add-ins for MS Excel 97 / 2000 / 2002 / XP / 2003. ASAP Utilities contains over 300 useful and powerful utilities to fill the gaps in Excel, and automate frequently used tasks. This is truly an amazing collection of addins, and best of all is free.
ASAP Utilities - Over 300 Free Excel Addins
Here are just a few of ASAP's popular Excel add-in tools:
- Deselect cells
- Apply formula to selected range
- Conditional select cells (i.e. cells > 12 or red cells)
- Copy a worksheet's page and print settings
- Vision control, view workbooks, sheets and easily change their settings
- Print multiple sheets
- Color each n'th row or column
- File import and export (txt, csv, dbf, xls, gif, jpg, etc.)
- Export selection as HTML table (including formats, colors etc.)
I hope this helps you.
8) Please Support Our Training Mission
How You Can Support Our Computer and Software Training Mission
Please help support EducationOnlineForComputers.com'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.
This is our new free computer and IT education and training search engine housing over 150,000 free training internet resources! Just type in a topic you're looking for and get tons of great web resources instantly. These search results are much better than the big search engines, like google. You can also check out our predefined search results page giving you tons of free training resources: http://www.edcomp.com/predefined.htm.
ITT Technical Institute: Choose from their many programs:
University of Phoenix Online: Advance your career
DeVry: Online degrees for working adults
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.
***EducationOnlineForComputers.com'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.
EducationOnlineForComputers.com Member Site FAQ Answers:
- 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.
- You can choose to pay using either Paypal or 2Checkout. If paying pay check and you live in the U.S., please select 2Checkout.
- 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.
- 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: http://tinyurl.com/7ien You can email Jeff Love with questions at email@example.com
I will give you 5 Great Free Bonuses when you sign up now.
These are as follows:
- 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.
- 19 Online Business and Reference Books, including titles such as Scientific Advertising, The Art of Electronic Publishing, and Small Business Manual
- 12 Instructive e-Books, including On Line Stealth Marketing, 7 Secrets to Unlimited Traffic, and Increase Auction Profits.
- Instant and Easy Online Access to the 24 Best Free Computer Help & Support Sites.
- 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: