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 #32 - December, 2006 ***
EducationOnlineForComputers.com
This Newsletter is only sent to its subscribers
and is available on the web at
http://www.EducationOnlineForComputers.com/newsletter32.html
Newsletter Archives are here:
http://www.EducationOnlineForComputers.com/newsletter.html
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:2)... Best New Free Microsoft Office Training & Tutorial Sites
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 our December 2006 issue (#32) 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 35 Computer Software Application training, learning and tutorial web sites, with a total of 128 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:
EducationOnlineForComputers.com Blogs:- Free Microsoft Office Application Training
- Free Web Development Training
- Free Adobe & Macromedia Training
Intelligentedu.com Blogs:- 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:
Free_Microsoft_Office_Training_Tutorial_Resources_rss2.xml
Free_Training_Photoshop_Flash_Dreamweaver_FrontPage_Adobe_Macromedia_rss2.xml
Free_Web_Development_Training_Tutorial_Resources_rss2.xml
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:
http://www.educationonlineforcomputers.com/current_news.htmlIf you are looking for free technical or programming training, please visit our sister site:
http://www.intelligentedu.com.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.
Warm Regards,
Scott Turton Newsletter and Web Site Editor
scott_turton@EducationOnlineForComputers.com
http://www.EducationOnlineForComputers.com
"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.
EdComp.com:
http://www.edcomp.com/
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.
Visit 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!
Free Microsoft Word Course
Here is an excellent Free Microsoft Word Course that gives you 11 lessons to learn this important word processor application. Each lesson, or section, provides several tutorials on how to perform the features and functions being discussed. These Word course tutorials cover beginning and more advanced topics, such as mail merge and creating a Word macro.
Word Course Lessons:
- Get Started with Word
- Document Formatting
- Cut, Copy and Paste
- Clip Art
- Multi-Page Documents
- The Drawing Toolbar
- Word Art
- Letterheads, Templates
- Mail Merge in Word
- How to design a Form
- Creating Tables in Word
- Create a Word Macro
8 Word Video Tutorials
Here are Teach-ict.com's training videos teaching you how to use the features of Word, which is the word processor in Microsoft's Office Suite of applications. These videos will help you learn the following Word features: footers, page numbers, bullet points, mail merge, tabs, and table of contents. Learn these Word topics by watching what happens on the screen, and then trying it yourself. This site offers many Free Video Tutorials on various software applications.
Free Microsoft Excel Course
Here is an excellent Free Microsoft Excel Course that gives you 12 lessons to learn this important word processor application. Each lesson, or section, provides several tutorials on how to perform the features and functions being taught. These Excel course tutorials cover many topics and features of this spreadsheet application, including Charting, Math Operators, Functions, Conditional Logic, Scenarios, Goal Seek, Pivot Tables, Data Validation, and Web Integration.
Excel Video Tutorials
Here are Teach-ict.com's Excel Training Videos teaching you how to use the features of Excel, Microsoft's Office Spreadsheet application. These will help you learn how to perform the following functions using Excel: Formatting (colors, borders, cells, tabs, text), Inserting, Deleting, Moving, Charts (type, colors, new chart, labels), Validation, Formulas (autofil, sum, percent, average, min, max, vlookup), Printing, Sorting, and Searching . Using these training videos and can learn these Excel features by watching what happens on the screen, and then trying it yourself. These are some of the many Free Video Tutorials on various software applications that Teach-ict.com offers.
Excel Tutorial Topics:
7 PowerPoint Video Tutorials
One of the best ways to learn how a software application works is to watch it being used via screen videos. Teach-ICT.com provides many Free Video Tutorials on various software applications. Here are their training videos teaching you how to use some of the features of PowerPoint. These will help you learn how to perform the following functions using PowerPoint: creating a new slideshow, adding a new slide, formatting bullet points, adding the date and time to footers, adding animation, performing slide transitions, and creating hyperlinks.
Starting Off
Creating a new Powerpoint slideshow New slide - adding one Formatting
Bullet points - changing the style Date and time - adding to footers Developing Your Presentation
Animation - adding to text and images Slide transitions Hyperlinks to other slides
Microsoft Access Video Tutorials
One of the best ways to learn how a software application works is to watch it being used via screen videos. Teach-ICT.com provides many Free Video Tutorials on various software applications. Here are their training videos teaching you how to use the features of Access, Microsoft's Office Database application. These will help you learn how to perform the following functions using Access: field and input validation, creating simple and complex queries, creating a report from a query, designing and using tables, filtering and sorting tables, and creating and customizing forms and subforms. Using these training videos, you can learn Access by watching what happens on the screen, and then try it yourself.
Microsoft Access Database Tutorial
Profsr.com offers this Microsoft Access tutorial giving you step-by-step instructions on how to create and develop a commercial-grade database application. It beings with teaching database modeling, which deals with the actual design of the database before it's created. After designing database, you will learn how to develop the required database objects and learn how to use them. A simple application (Video Rental Store) is demonstrated showing how Microsoft Access is used in business. This database application assists with gaining an understanding of how users can deploy Access using its database management tools and facilities.
- Lesson 1 - Microsoft Access Introduction
- Lesson 2 - Designing the application - tables, fields, data types, properties
- Lesson 3 - Creating the database - primary key, creating tables
- Lesson 4 - Defining Table relationships - referential integrity, primary and foreign keys
- Lesson 5 - Entering data into Tables - data view, sorting and ordering
- Lesson 6 - Creating data-entry forms - data validation, default values
- Lesson 7 - Building simple Queries - sorting, selection criteria, working with dates
- Lesson 8 - More complex Queries - multiple tables, linking, functions
- Lesson 9 - Creating a Master/Detail form
- Lesson 10 - The Microsoft Access Application Menu - the Switchboard
- Lesson 11 - Creating Macros - autoexec, conditions
- Lesson 12 - Writing Reports
- Lesson 13 - Sales Analysis Reports with Microsoft Access
- Lesson 14 - Action Queries - Updating data
- Download Area- sample Microsoft Access databases
Microsoft Project and Gantt Chart Tutorials
This is a nicely illustrated, 2-page tutorial covering Microsoft Project that introduces you to Project and demonstrates its basic functionality. This application has many features and capabilities and some of the most important are shown in this tutorial.
Gantt Charts are an important concept that is used in Microsoft Project and its important to understand how to use these types of charts. Here is a 4-page Gantt Chart Tutorial (pdf format) that discusses project planning basics (tasks, milestones, work breakdown statements) and how to use Excel to make Gantt Charts.
3) The Best New Free Training Sites for Flash, Photoshop, Dreamweaver, FrontPage, and other Adobe and Macromedia Applications
Flash Video TutorialsHere are Teach-ict.com's free Flash Training Videos teaching you how to use several important features of Flash, Adobe's popular web animation application. These will help you learn how to perform the basics, create and use buttons, graphics, and animations with Flash. Using these training videos, you can learn Flash by watching what happens on the screen, and then trying out the functions for yourself. These are part of the many Free Video Tutorials on various software applications that Teach-ict.com.
Flash Training Topics:
4 Flash and Actionscript Video Tutorials
XML Driven Slideshow
Title: XML driven Slideshow
URL: http://tutorial.templates247.com/tutorial5/
Time: 10 Mins
Difficulty Level: Intermediate
Summary: How to make a xml driven slideshow
Assumed knowledge: Xml, Components
Author: Chris Calangi
Website: Templates247.com
Tutorial Files: Source
Description: How to make a xml driven slideshow. With a use of a component, you can easily make a slideshow in Flash.
Custom Easing in Flash 8
Title: Custom Easing in Flash 8
URL: http://tutorial.templates247.com/tutorial4/
Time: 30 Mins
Difficulty Level: Intermediate
Summary: How Custom Easing in flash 8 works.
Assumed knowledge: Tween, Custom Easing
Author: Chris Calangi
Website: Templates247.com
Tutorial Files: Source
Description: How Custom Easing in flash 8 works. The tutorial describes the basics of Custom Easing a new feature in flash8.
Actionscripted Fader
Title: Actionscripted Fader
URL: http://tutorial.templates247.com/tutorial3/
Time: 30 Mins
Difficulty Level: Intermediate
Summary: How to fade an mc using Actionscript.
Assumed knowledge: Tween, Functions / Global, Movieclip Actions
Author: Chris Calangi
Website: Templates247.com
Tutorial Files: Source
Description: How to fade an mc using Actionscript. This is a useful script that you can use to fade any movieclip in your flash.
Pseudo Zoom Effect with Actionscript
URL: http://tutorial.templates247.com/tutorial2/
Time: 30 Mins
Difficulty Level: Intermediate
Summary: How to make a pseudo-zoom effect
Assumed knowledge: Tween, Photoshop Filters
Author: Chris Calangi
Website: Templates247.com
Tutorial Files: Source
Description: How to make a pseudo-zoom effect. It gives the illusion that you are zooming the actual object from flash.
Photoshop Tutorials from Learn2Photoshop
Learn2Photoshop.com is a Photoshop Tutorial website that offers Adobe Photoshop tutorials making digital photographic manipulation easy and fun for everyone, from amateurs to seasoned programmers. The creative web and game design techniques taught be these photoshop tutorials cover: teaching texturing techniques, layer effects, tilable textures, and keying green backdrops.
1) Texturing Techniques: The Cabinet Case-Study - Part 1
This tutorial teaches true photo-texturing, versus the lazy-man's way of selecting an image, resizing it, saving it and calling it texture. This is known as (photorape). Using a high-resolution photo image that has issues of flash spots from the camera, barrel distortion and rotation, and color inaccuracy, Part 1 of this study addresses the barrel distortion and rotation.
2) Texturing Techniques: The Cabinet Case-Study - Part 2
Using the same high-resolution photo image as in Part 1, this tutorial case study (Part 2) addresses the last problem to be fixed -- flash spots from the camera, which are hard to remove and are a dead give-away for photorape.
Assuming a very basic knowledge and understanding of layers and simple tools, this tutorial explain some layer effects and blending options using demos for each. These are: Drop Shadow, Inner Shadow, Outer Glow, Inner Glow, and also Bevel and Emboss
4) The easiest way to make tileable textures with PhotoShop7 or above
This is a true newby guide and the author encourages the reader to feel free to cut and paste the first image (a cropped photo of grass) into Photoshop for actually trying out the techniques taught in the tutorial. Here you will learn to remove tell-tale signs like seam lines between tiles using the healing brush tool.
5) Keying Green Backdrops (original tutorial is here)
This tutorial is about editing photos with a green backdrop and at the end discusses editing photos with a translucent image. In this tutorial, objects will be separated from green backdrops with precision, including learning how to mask fine strands of hair and also a translucent glass vase. Techniques taught are identifying green areas, creating a black and white layer to represent the transparency of the image, using the channel mixer tool, adjusting the green backdrop with the Hue/Saturation Tool and removing green edge artifacts.
Photoshop Video Tutorials
One of the best ways to learn how a software application works is to watch it being used via screen videos. Teach-ICT.com provides many Free Video Tutorials on various software applications. Here are their training videos covering Photoshop. These will help you learn how to perform the following functions using Photoshop: editing, drawing, painting, manipulating images, and effects. Learn Photoshop by watching what happens in these videos, and then try it yourself.
Photoshop Topics:
- Starting off
- Editing with Photoshop
- Doing Drawing & Painting using Photosho
- Photoshop Effects
- Manipulating Images with Photoshop
Dreamweaver Video Tutorials
Here are Teach-ict.com's Dreamweaver Training Videos teaching you how to use the features of Dreamweaver, Adobe's GUI Web Development application. These will help you learn how to use Dreamweaver's features in regards to Setting up a new site, Templates, Images, Tables, Hyperlinks and Menus, Formatting Text, Behaviours. By viewing these training videos, you can learn Dreamweaver by watching what happens on the screen, and then try out the features shown for yourself. Teach-ict.com offers many Free Video Tutorials on various software applications
Dreamweaver Training Topics:
FrontPage Video Tutorials
Here are Teach-ict.com's training videos teaching you how to use the features of Frontpage, Microsoft's GUI Web Site Editor. These videos will help you learn many Frontpage features related to: formatting, content, images, hyperlinks, backgrounds, and tables. Because one of the best ways to learn how a software application works is watching it being used, by using these training videos you can learn Frontpage by watching what happens on the screen, and then try it yourself. This site offers many Free Video Tutorials on various software applications.
Learn these Frontpage Topics:
4) The Best New Free Web Development Training Sites
HTML is an abbreviation for HyperText Markup Language and is what is used to program web pages. It is used by placing HTML tags and codes into text (marking up the text) so that web browsers can understand it and display it as the author has designed the page.
Here are several methods on programming web pages with HTML:This tutorial will teach you the HTML tags and code required for developing you own web pages. You can write your web pages in a text editor using HTML code, or you can first use a GUI editor and then edit the HTML directly to tweek the way the page looks and displays.
- using a regular text editor to write the web page content and manually place the HTML tags and code into and around the text. Not very easy for large web pages and sites. Many freeware text editors are available on the web.
- using an HTML editor; which functions as a text editor, except the HTML tags and code are inserted around the text by using menu options and buttons. Arachnophilia is one of these tools.
- using a word processor, such as Word or OpenOffice.org's Writer, and saving the file in HTML format. One downside to using Word with this method, is the file will be much larger than needed and Microsoft proprietary codes will be inserted along with standard HTML.
- using a GUI web page editor, as FrontPage or Nvu, with which you design, construct and write the web page, and in the background the application writes the HTML code for you.
- Lesson 1 - Preparation
- Lesson 2 - The Stylesheet
- Lesson 3 - Basic Tags
- Lesson 4 - Tables
- Lesson 5 - Lists
- Lesson 6 - Java
Web Design Library
Here is my blog post about the Web Design Library, which offers a large collection of Web Design Tutorials using Phothoshop, Flash, HTML, CSS, PHP, and Javascript. Also check out the Editor's Picks.
Web Design HTML Course and CSS Tutorials
Homeandlearn.co.uk provides some excellent free computer training, including this Web Design Course and these Cascading Style Sheet Tutorials. These course lessons and tutorials will teach you how to create web pages using HTML and CSS. To begin, first read their Introduction to the Web Design Course to see more about what you will learn, and to download their free HTML editor.
Web Design HTML and CSS Topics:
- A first Web Page
- Images and the Web
- HTML Text Formatting
- Adding Links with HTML
- HTML Tables
- HTML Forms
- HTML Frames
- CSS - How to Set Up a Style Sheet
- CSS - Formatting Text with Style Sheets
- Stylesheet Reference
> Section One - A first Web Page
1 Anatomy of a Web Page
2 The Five Minute Web Page3 The HTML Skeleton
4 Adding Colours to Web Pages
> Section Two - Images and the Web
1 inserting images into a web page
2 Image Types
3 Design a Web Page with and Image