Free Microsoft Office Training and Tutorial Resources




    



June 21, 2008

Getting Started Handouts for Word, Excel, PowerPoint, & Access

Here are 4 Getting Started With Training Handouts covering Word, Excel, PowerPoint, and Access, from  the University of Texas. If you need to learn more about these applications’ basic features and tasks, then these will help you do that.


Getting Started with Microsoft Word
This handout provides an introduction to Microsoft Word’s basic functionality. It covers starting Word, the Word interface, creating a Word document, editing a Word document, selection techniques, paragraph and character formatting, spell checking, printing, graphics and tables.

Getting Started with Microsoft Excel
This handout introduces the basic features of Microsoft Excel. It shows how to enter and edit data, perform formatting, enter formulas, do page setups, and print spreadsheets.

Getting Started with Microsoft PowerPoint
This handout introduces the basic features of Microsoft PowerPoint and shows how to create simple presentations, along with and editing and formatting your PowerPoint slides.

Getting Started with Microsoft Access
Microsoft Access is a relational database application with which you can efficiently save and retrieve data in many formats. This handout explains how to navigate the Access interface, create simple tables and queries, and relate information from one table to another.



Tags for this post>> | | |

Web Design Process Guide

Here is a quick 7-page Web Design Process Guide, from the University of Texas at Austin. This guide explains the six phases of designing and developing a web site. It will help you to do, or at least consider, these important aspects of web design.


Project Definition

The most critical step in the web design process is creating an accurate project definition. A project definition includes a project brief and a project plan. The client survey is used to gather the information needed to develop the project brief and plan. How do you create the project definition?


Site Structure

Good web design requires a solid site architecture based on the site’s goals and target audience established in the project brief. The deliverables from this phase are:

   1. Content Outline
   2. Site Diagram
   3. Wireframes


Visual Design

Review the project brief, sitemap and wireframes with the designer(s), then give them free reign to brainstorm solutions and develop the different visual designs. The designer(s) should also review any branding guidelines as well as the technical requirements for screen resolution, browser compatibility, download time, web standards and accessibility.


Site Development

Now it is time to actually build the site. There are two major steps during this stage:

  1. Technical/Functional Plan
  2. Build and Integrate the Site

Testing

The Quality Assurance person’s priority is to create a realistic QA plan, manage the testing process, prioritze issues, insure that high priority issues are solved and conduct the final review and release of the site.


Launch Plus

   1. Document your Style Guide
   2. Launch your web site
   3. Maintenance


Resources


Tags for this post>>
June 19, 2008

41 Basic Photoshop Video Tutorials

Here are 41 Basic Photoshop Video Tutorials, from sutree.com‘s free Basic Photoshop Basic Course. These Photoshop tutorials show and demonstrate for you how to use many Photoshop tools and features, such as the Lasso Tool, the Slice Tool, the Clone Tool, Vector Path Tools, Vector Shape Tools, History Brush, Blur Sharpen and Smudge, Color Selector, Layers, Masking Layers, Filters, Text Tools, Image Tools, Page Layout, 3D, Animation, the Pen Tool, and Smart Objects.


Photoshop Video Tutorials:

01. Photoshop Video Tutorial – Setting up a new Document

02. Photoshop Video Tutorial – Magnetic Lasso

03. Photoshop Video Tutorial – Lasso Tool

04. Photoshop Video Tutorial – Slice Tool

05. Photoshop Video Tutorial – Clone Tool

06. Photoshop Video Tutorial – History Brush

07. Photoshop Video Tutorial – Blur Sharpen and Smudge

08. Photoshop Video Tutorial – Burn Dodge Sponge

09. Photoshop Video Tutorial – Vector Path Tools

10. Photoshop Video Tutorial – Vector Shape Tools

12. Photoshop Video Tutorial – Color Selector

13. Photoshop Video Tutorial – Layers I

14. Photoshop Video Tutorial – Layers II

15. Photoshop Video Tutorial – Quick Masking Layers

16. Photoshop Video Tutorial – Corrective Filters

17. Photoshop Video Tutorial – Importing Images Twain

19. Photoshop Video Tutorial – Text Tools

20. Photoshop Video Tutorial – Image Tools

21. Photoshop Video Tutorial – Custom Fill

22. Photoshop Video Tutorial – Clipping With Bitmaps

23. Photoshop Video Tutorial – Color Sampler

24. Photoshop Video Tutorial – Auto Select Layers

25. Photoshop Video Tutorial – Page Layout

27. Photoshop Video Tutorial – Simple Navigation Header

28. Photoshop Video Tutorial – PMS Colors

30. Photoshop Video Tutorial – Retouch Old Pictures

31. Photoshop Video Tutorial – Shifting Hues

32. Photoshop Video Tutorial – Faked Fill Drop Shadow

33. Photoshop Video Tutorial – Halftone

34. Photoshop Video Tutorial – Vanishing Point Tool

35. Photoshop Video Tutorial – Retro Halftone

36. Photoshop Video Tutorial – 3D in Photoshop

37. Photoshop Video Tutorial – Grunge Image Brushes

38. Photoshop Video Tutorial – Spikey Objects

39. Photoshop Video Tutorial – Photoshop Animation

40. Photoshop Video Tutorial – Basics of Pen Tool

41. Photoshop Video Tutorial – Trace Image Pen Tool

43. Photoshop Video Tutorial – Actions and Automation

44. Photoshop Video Tutorial – Smart Objects

46. Photoshop Video Tutorial – Clipping Path

47. Photoshop Video Tutorial – Cartoon Cross Hatch


Tags for this post>>

12 Free Office 2000 Training Manuals

Here are 12 Free Office 2000 Training Manuals for all of these Microsoft applications: Word, Excel, PowerPoint, Outlook, Access, Project, Visio, and FrontPage. These excellent free Office training documents, from microsofttrainingcourses.co.uk, include tutorials and instructions for learning both introductory and advanced features, and also provide Macro and VBA training. The documents are downloaded in zip format, and when unzipped are in Word (.doc) format. They are comprehensive and teach you all of the features and topics for these apps in a step-by-step format.


MS Office 2000 Training Manuals

MS Word Training Manuals
MS Excel Training Manuals
MS PowerPoint Training Manual
MS Outlook Training Manual
MS Access Training Manuals
MS Project Training Manual
MS FrontPage Training Manual


Tags for this post>> | | | | | |
June 18, 2008

12 Free Office XP Training Manuals

Here are 12 Free Office XP Training Manuals for all of these Microsoft applications: Word, Excel, PowerPoint, Outlook, Access, Project, Visio, and FrontPage. These excellent free Office training documents, from microsofttrainingcourses.co.uk, include tutorials and instructions for learning both introductory and advanced features, and also provide Macro and VBA training. The documents are downloaded in zip format, and when unzipped are in Word (.doc) format. They are comprehensive and teach you all of the features and topics for these apps in a step-by-step format.


MS Office 2002 / XP Training Manuals


MS Word Training Manuals


MS Excel Training Manuals
MS PowerPoint Training Manual

MS Outlook Training Manual


MS Access Training Manuals

MS Project Training Manual

MS Visio Training Manual

MS FrontPage Training Manual


Tags for this post>> | | | | | | |

Free FrontPage 2003 Training Manual

Here is a great Free FrontPage 2003 Training Manual, from microsofttrainingcourses.co.uk. This FrontPage training document is 207 pages in length, the zipped download size is 1.3mb, and the resulting doc file size is 4.4mb. It covers and teaches all of the features and functions in FrontPage that you need to know to create compelling web pages and sites, including: FrontPage Views, Text and Paragraph Formatting, Backgrounds, Page Setup, Linking, Images, Tables, Frames, Themes, Forms, and Tasks Lists. For step-by-step instructions for each Excel command demonstrated, look for the hand icon.


FrontPage 2003 Training Manual Table of Contents:

How to use this guide
Objectives
Instructions
Keyboard
Commands
Notes
Tips

Section 1
Common terminology associated with the Internet, Intranet and WWW
URL, Web browser, Frame
HyperLinks, HTTP, HTML
Organising Your Web’s Structures
Understanding Good Web Design

Section 2
FrontPage Views
The Folders View
The Reports View
The Navigation View
The Hyperlinks View
The Tasks View

Section 3
Starting a One-Page Web from Scratch
Creating new pages
Importing Pages and non-HTML files
Working with Folders and Web files

Section 4
Common Editing Tasks
Move and Copy Text
Using Line Breaks
Spell Checking across the Entire Web
Find and Replace Text across the Entire Web

Section 5
Formatting Text
Preview the Web in FrontPage preview
Preview the Web in your Web Browser Application

Section 6
Paragraph Formatting
Set paragraph alignment
Using Indentations
Borders and Shading

Section 7
Creating a Bulleted List and a Numbered list
Using images as bullets

Section 8
Titling a Page
Page Backgrounds
Setting Page Text Colors
Changing the Margins
Page Setup and Page Transitions

Section 9
Inserting Horizontal Lines
Adding Images (or Graphics)
Saving Images into Your Web

Section 10
Creating and Viewing Hyperlinks
Creating and Linking to Bookmarks
Creating an Image Hyperlink
Using Hotspots
The Hyperlinks View

Section 11
Working with Tables
Inserting Tables
Inserting and deleting rows and Columns
Changing Row and Column Height
Distribute rows and columns evenly
Splitting and merging cells
Applying Borders and Shading
Convert a table to text and text to table
Other Table Formatting options

Section 12
How Frames work
Navigational Frames
Applying Frames to an Existing Web
How inline frames are used
Save a frames page
The Frames Page (or frameset) Properties
Create a hyperlink to show a page in another frame

Section 13
Using FrontPage Components
Creating a marquee and a banner ad
Inserting the Hit Counter Component
Creating a hover button
Inserting Excel Charts, Pivot Tables and spreadsheets

Section 14
FrontPage  Themes
Viewing Themes
Removing a Theme

Section 15
Creating New Pages in the Navigation Window
Changing the Orientation of a navigation bar
Removing the navigation bar

Section 16
Using Shared borders
Removing Shared Borders

Section 17
Create a Table of Contents
Regenerate a Table of Contents

Section 18
Designing Forms
Using Form Controls
Check Box’s and Radio buttons
Text Boxes and Drop Down Menus
Adding Submit and Reset Buttons
Managing Form Results
Setting Form Properties
Storing Form Results
The Results Storage Concept
Choosing a Container for the Results
Directing Form Input to an HTML File
 
Section 19
Create a Discussion Group on a Web Site
Delete a Web Document Discussion

Section 20
Working with Tasks
Viewing and Editing Task lists

Section 21
External Hyperlinks
Verifying Hyperlinks
Repairing broken links


Tags for this post>> |

June 17, 2008

Free Microsoft Project 2003 Training Manual

Using Microsoft Project, you are able to to define projects, manage, update, and communicate information about a project. The details of the project’s tasks and associated resources are entered into the system as a new project. Project then shows the information such that the relationships of the tasks and their time scales can clearly be seen and potential problem areas identified.

Here is a Free Microsoft Project 2003 Training Manual, from microsofttrainingcourses.co.uk. This training document is 140 pages in length, the zipped download size is 711kb, and the resulting doc file size is 1.3mb. It will teach and show you all of Project’s important features and functionality, as listed below, including the 3 main methods of viewing and editing project data: charts, forms, and sheets. Charts can be either Gantt Charts or Network Diagram Charts both of which are a diagrammatic representation of the project data. Forms contain the data relevant to a single specific task or resource. Sheets are a table of all the Tasks or all the Resources that are part of the Project.

Project 2003 Training Manual Table of Contents
:


Section 1:
Understanding Project Management
Project Language
Terminology
Views and Tables
The Tracking Gantt View
Project’s Menus
Project’s The Tool Bars
The Stages of Project Management
Monitoring and Adjusting

Section 2:
Planning and Defining the Project
Defining the Project
The Goal and Objectives
The Specification and Limitations
Project Properties
Creating a New Base Calendar
Save the New Project File
Saving and Ending a Project Session

Section 3:
Entering Tasks
The Task Information box/Task Sheet
Tables and descriptions
In the Gantt Chart or the Task Sheet
Using the Task Information Form
Using The Network Diagram Chart
Adding and Linking Tasks
Defining the Summary Tasks
The AutoCorrect Feature

Section 4:
Resource Management
Reviewing and Navigating the Resource Sheet
Adding Resources to the Resource Sheet
The Resource Graph
Set Resource Calendars
Allocate Resources
Review Resource Usage
Working with Resources
Updating Resource Information on the Fly
Planned Time Scale
Lead Time and Lag Time
The Outlining View (Summary)
Promoting and Demoting Tasks

Section 5:
Display Data and Cost Factors
Using Gantt Charts
Changing Time Scale and the Palette
Using Network Diagram Charts
Changing the contents of a Node
Changing the layout of the Chart
Elements of the Network Diagram Chart
Applying and Customizing Filters
Examining the Cost Factor

Section 6
:
Page Setup
Printing Charts, Forms and Sheets
Reports Setup & Editing Reports
Task and Cost Information
Cost information
Reports by Report Type

Section 7
:
Updating the Project
Updating Task Data
Entering Task Names and Durations
Tracking Progress
Viewing the Gantt Chart and the Resource Graph
Modifying the Project to Match Resources
Levelling
Define an Update Point

Section 8:
Multiple Projects
Using Common Resources
Adding Sub Projects
Consolidating Projects created in earlier versions of Project
Recurring Tasks
Task Relationships
The Organizer



Tags for this post>>

8 InDesign CS2 Video Tutorials

Adobe’s InDesign CS2 application allows the user to work with and edit page layouts for print documents. It provides many features for creating richer and complex documents. InDesign also integrates smoothly with other Adobe software. Here are 8 InDesign CS2 Video Tutorials, from sutree.com, that will show you how to do important tasks, such as page numbering, setting paragraph styles, adding pages, and linking text boxes. Also included here is a video showing you how to create a business card.


InDesign CS2 Video Tutorials:

01. Indesign Video Tutorial – Auto Page Number

02. Indesign Video Tutorial – Paragraph Style

04. Indesign Video Tutorial – Drop Caps

05. Indesign Video Tutorial – Adding Pages

07. Indesign Video Tutorial – Business Card Setup

08. Indesign Video Tutorial – Photoshop Clipping Path

09. Indesign Video Tutorial – Linking Text Boxes

10. Indesign Video Tutorial – Runaround – Force Field



Tags for this post>>

June 16, 2008

30 Illustrator CS2 Video Tutorials

Here are 30 Illustrator CS2 Video Tutorials, from sutree.com. Using Illustrator CS2, you can easily create sophisticated vector artwork for many areas, such as the web and print. You can learn how to use Illustrator’s tools quickly and easily, as you use its features to work with images, text, and color variations. You can also share files between Illustrator and other Adobe apps as you manage and manipulate designs for print, web, interactive and mobile applications. 


Illustrator CS 2 Course Video Tutorials:

01. Illustrator Video Tutorial – Create & Outline Fonts

02. Illustrator Video Tutorial – Pattern Swatch

03. Illustrator Video Tutorial – Swatches

04. Illustrator Video Tutorial – Spray Can Shapes

05. Illustrator Video Tutorial – Spray Can Images

06. Illustrator Video Tutorial – Shape Morf

07. Illustrator Video Tutorial – Scale & Skew

08. Illustrator Video Tutorial – Rotate & Reflect

09. Illustrator Video Tutorial – Importing & Placing Images

11. Illustrator Video Tutorial – Pathfinder MinusBack

12. Illustrator Video Tutorial – Pathfinder Connect

13. Illustrator Video Tutorial – Smooth with Pencil

14. Illustrator Video Tutorial – PMS Colours

15. Illustrator Video Tutorial – Pen & Brush Tool

16. Illustrator Video Tutorial – Outlines Around Shapes

17. Illustrator Video Tutorial – Custom Brush Shapes

18. Illustrator Video Tutorial – Line Segment Tool

19. Illustrator Video Tutorial – Font with Gradient

20. Illustrator Video Tutorial – Text in a Circle

21. Illustrator Video Tutorial – Adding Blocks of Text

22. Illustrator Video Tutorial – Apply Text to a Path

23. Illustrator Video Tutorial – Outlines Around Text

24. Illustrator Video Tutorial – Picture Clipping

25. Illustrator Video Tutorial – Slice for Web

26. Illustrator Video Tutorial – Using Layers

27. Illustrator Video Tutorial – Blend Colour Tool

28. Illustrator Video Tutorial – Print-ready Postcard

29. Illustrator Video Tutorial – Making Glossy Buttons

30. Illustrator Video Tutorial – Making Glossy Web Icons

Make Business Cards in Adobe Illustrator


Tags for this post>>

June 12, 2008

28 Fireworks Video Tutorials

Fireworks is a popular bitmap and vector graphics editing application from Adobe. It is designed to integrate easily with other former Macromedia products, such as the popular Adobe Dreamweaver and Adobe Flash. Here are 28 Fireworks Video Tutorials, from sutree.com, making up their free Fireworks Video Course. These will show and teach you how to perform many tasks using Fireworks, including: Select and Lasso, Paintbrush, Vector Pen Tool, Vector Brush Tool, Image Masks, Recording Actions, Slicing, Animating, Gradients, Clone Tool, Custom Textures, and various Text Effects.


28 Fireworks Video Tutorials:

01. Fireworks 8 Video Tutorial – Select and Lasso

02. Fireworks 8 Video Tutorial – Paintbrush

04. Fireworks 8 Video Tutorial – Blur Dodge Sharpen

05. Fireworks 8 Video Tutorial – Rubber Stamp

06. Fireworks 8 Video Tutorial – Color replace

07. Fireworks 8 Video Tutorial – Removing Redeye

08. Fireworks 8 Video Tutorial – Vector Pen Tool

09. Fireworks 8 Video Tutorial – Vector Brush Tool

10. Fireworks 8 Video Tutorial – Smart shapes

11. Fireworks 8 Video Tutorial – Image Masks

12. Fireworks 8 Video Tutorial – Free-form Tools

13. Fireworks 8 Video Tutorial – Recording Actions

14. Fireworks 8 Video Tutorial – Batch File Edit

16. Fireworks 8 Video Tutorial – Slicing I

17. Fireworks 8 Video Tutorial – Slicing II

18. Fireworks 8 Video Tutorial – Selective Compression

19. Fireworks 8 Video Tutorial – Animated Gifs

20. Fireworks 8 Video Tutorial – Using Type

21. Fireworks 8 Video Tutorial – Animating

22. Fireworks 8 Video Tutorial – Exporting Transparency

23. Fireworks 8 Video Tutorial – Working with Gradients

24. Fireworks 8 Video Tutorial – Custom Texture

25. Fireworks 8 Video Tutorial – Combine Path Objects

26. Fireworks 8 Video Tutorial – Making a Pop up Menu

27. Fireworks 8 Video Tutorial – Clone Tool

29. Fireworks 8 Video Tutorial – Perspective Shadows

34. Fireworks 8 Video Tutorial – Text on a Path

35. Fireworks 8 Video Tutorial – Bevelled Text


Tags for this post>>

Free Advanced Excel 2003 Training Manual

Here is an excellent Free Advanced Excel 2003 Training Manual, from microsofttrainingcourses.co.uk. This training document is 155 pages in length, the zipped download size is 1.1mb, and the resulting doc file size is 9.8mb. Advanced Excel features and functionality covered by this Excel training manual include: Conditional & Logical Functions, Lookup Functions, Goal Seeking And Solving, Views and Scenarios, Reports, Manage Lists, Advanced Filtering, Pivot Tables, Charting, Templates, Auditing, Validation Circles, Precendents And Dependants, and Comments. For step-by-step instructions for each Excel command demonstrated, look for the hand icon.


Table Of Contents of Advanced Excel 2003 Training Manual:

Introduction
How To Use This Guide

Section 1
Using Advanced Worksheet Functions
Using Names
Conditional & Logical Functions
If Statementsh
And, Or, Not
Lookup Functions
Vector Lookup
Hlookup
Vlookup
Nested Lookups
Goal Seeking And Solving
Solver

Section 2
Views, Scenarios & Reports
Views & Scenarios
Custom Views
Scenario Manager
Print Reports

Section 3
Using Excel To Manage Lists
Excel Lists
Sorting Data
Adding Subtotals To A List
Filtering A List
Data Form
Advanced Filtering
Copying Filtered Data
Database Functions
Pivot Tables
Modifying A Pivot Table
Grouping Pivot Table Items

Section 4
Excel Charts
Chartwizard
Moving And Resizing Embedded Charts
Chart Types
Formatting Charts
Format Chart Elements
Manipulating Chart Data
Chart, Edit Series
Swapping The X And Y Axes
Using Charts To Change Data

Section 5
Templates
Custom Templates
Autotemplates
Opening And Editing Templates
Template Properties

Section 6
Auditing
Tracers
Comments
Validation Circles
Go To Special
Precendents And Dependants
Comments


Tags for this post>> |

June 11, 2008

29 Photoshop Video Tutorials

Here are 29 Photoshop Video Tutorials, from graphicssoft.about.com. These video tutorials will help you learn many Photoshop features and techniques. You’ll see and use live screencasts given by Photoshop experts that demonstrate and teach how to edit and touch up your photos, perform graphical design tasks, and create original art and a variety of effects using Photoshop. Also, if you’d like to follow these tutorials offline, a full transcript is provided for each one.


29 Photoshop Video Tutorials from about.com:

Wrap Text Effect in Photoshop – Video
Wrapping text in creative ways adds a fun and playful quality to a picture. Learn how to wrap text around an object using three different effects in Adobe Photoshop.

Use the Pattern Stamp Tool in Adobe Photoshop – Video
Photoshop’s pattern stamp tool lets you paint with a pattern in one of the Photoshop libraries or with a pattern that you create. Learn how to use the pattern stamp tool to edit your photos.

Remove Photography Grain or Noise in Adobe Photoshop – Video
Do you have digital pictures that would be perfect except for a bit of distortion, photography grain, or noise? Learn how to remove unwanted grain in Adobe Photoshop.

How to Create a Rainbow in Adobe Photoshop – Video
Want to splash a colorful rainbow across a party invitation or on stationery? Learn how to create one in Adobe Photoshop.

Convert Color Photos to Black and White with Photoshop – Video
There’s something special about the classic look of black and white photos. Learn how to convert your color pictures into black and white using Adobe Photoshop.

How to Add a Text Watermark in Adobe Photoshop – Video
You can protect photos that you distribute by adding a simple watermark to them. Learn how to create watermarks in Adobe Photoshop and give professional branding to your pictures.

Adobe Photoshop Sand Effect – Video Tutorial
[Video Tutorial] Use Adobe Photoshop to create text with a sand-like texture, using the same displacement effect design pros use to blend text or objects seamlessly into picture backgrounds.

Adobe Photoshop Text Reflection – Video Tutorial
[Video Tutorial] Create a text reflection effect in Adobe Photoshop and make text contents pop from their background.

Adobe Photoshop Photo Frame – Video
[Video Tutorial] Make your favorite photo look polished and elegant- learn how to add a tasteful faux frame to the image itself with Adobe Photoshop.

Adobe Photoshop Fire Text Effect
Make your text distinctive and exciting with Photoshop text effects- learn how to make your words appear to be on fire.

Adobe Photoshop Brightening a Photo
Are some of your most precious memories stored on pictures that look too dark? This video demonstrates how to brighten digital pictures and photos using Adobe Photoshop.

Make a Skewed Picture Straight in Adobe Photoshop
Do some of your pictures appear just a little bit lopsided or skewed? Learn how you can make a skewed horizon or other line straight with Adobe Photoshop.

Fix Picture Imperfections with Adobe Photoshop Healing Brush
Would your pictures be perfect if you could just remove one or two blemishes? Well, with the Healing Brush in Adobe Photoshop, you can be your own professional air-brusher in just a few steps.

Fix Picture Imperfections with Adobe Photoshop Clone Tool
Would your pictures be perfect if you could just remove one or two blemishes? Well, with the Clone Tool in Adobe Photoshop, you can be your own professional air-brusher in just a few steps.

Adobe Photoshop Web Button
You don’t have to be a graphic designer to make your Website look professional. Use Adobe Photoshop tools to create custom buttons that differentiate your site from its competition and encourage user interaction.

Adobe Photoshop Shortcuts
Whether you’re a professional graphic artist or you just want to re-touch your favorite photos, Adobe Photoshop Shortcuts can make your Photoshop workflow a great deal more efficient in just a few easy steps.

Adobe Photoshop Sepia Effect
There’s a quaint and beautiful look to older, black-and-white photos. With Adobe Photoshop, you can mimic that sepia-toned, antiqued appearance for your images in just a few easy steps.

Adobe Photoshop Red Eye Fix
You probably have some digital pictures that are perfect but for a common problem known as red eye. Use Adobe Photoshop to fix red eye and make your photos look professional.

Adobe Photoshop Photo Filter
It’s all too common for our photos to seem great if not for an unflattering yellow, green, or other tint. With Adobe Photoshop’s Photo Filter, you can adjust the color of your digital pictures, reconciling them with the memories they document.

Adobe Photoshop Pet Eye Fix
You probably have some cute digital pictures of your pets that are perfect but for a common problem known as red eye, or in this case pet eye. Use Adobe Photoshop to fix pet eye and make your photos look professional.

Adobe Photoshop Pattern Maker
Use the Adobe Photoshop pattern maker tool to create patterns out of graphics and photos. Generate original designs and special effects for your projects.

Adobe Photoshop Patch Tool
Would your pictures be perfect if you could just remove one or two obtrusive objects from the frame? Use Adobe Photoshop’s Patch Tool to re-touch your digital pictures and photos in just a few steps.

Adobe Photoshop Marquee Tool Background
Use the marquee tool in Photoshop to create backgrounds that can make any image or photo look professional or transform it into the perfect gift.

Adobe Photoshop Magic Eraser Tool
Adobe Photoshop’s Magic Eraser Tool provides you with a quick and easy way to change a picture’s background or other color area with just a few clicks.

Adobe Photoshop Lighting Filter
Learn how to use the Adobe Photoshop lighting filter, so you can get creative with lighting effects in your digital photos.

Adobe Photoshop Layers
Try light graphic work or picture re-touching without any worry of damaging your original images by using Layers in Adobe Photoshop.

Adobe Photoshop Ice Effect
Make truly distinctive and exciting text in your Adobe Photoshop images with this Ice Effect.

Adobe Photoshop Dodge Tool Brightening
Are some of your most precious memories stored on pictures that look too dark? Brighten or highlight parts of your digital pictures using the Adobe Photoshop Dodge Tool.

Turning Pictures into a Coloring Book with Photoshop
How to turn digital pictures into a coloring book using Adobe Photoshop.


Tags for this post>>

Free Excel 2003 Essentials Training Manual

Excel allows you to create and manage tables (worksheets) of data that are cross-referenced by rows, columns and other worksheets, and include calculations and graphs on that data. The data can be set up with various levels complexity, from containing simple formulas to complex functions and mathematical models.

Here is an excellent Free Excel 2003 Essentials Training Manual, from microsofttrainingcourses.co.uk. This training document is 216 pages in length, the zipped download size is 2.3mb doc file, and the resulting doc file size is 5.8mb. Essential Excel features and functionality covered by this Excel training manual include: Excel Screen Layout, Toolbars, Editing and Referencing Cells, Formulas, Functions, Moving And Copying Data, Formatting Data and Cells, Names, Working With Multiple Sheets, Printing, Manipulating Large Worksheets, Sorting & Subtotalling Data, and Customizing Excel. The Appendix shows all of the Excel toolbars with their functions referred to in the manual, along with tables of shortcut keys and an Excel glossary. For step-by-step instructions for each Excel command taught, look for the hand icon.


Table Of Contents of Excel 2003 Essentials Training Manual:

Introduction
How To Use This Guide
Objectives
Instructions
Commands
Notes
Tips

Section 1
The Basics
Windows Concepts
Excel Basics
The Spreadsheet Concept
The Excel Screen Layout
Use Toolbars
Use Menus
Getting Help

Section 2
Move Around And Enter Information
Data Entry
Autocomplete
Pick From List
Editing
Select Information
Select Cells The Mouse
Select Cells With The Keyboard
Clear Cells
The Fill Handle
Select Cells To Limit Data Entry
Select Cells For Multiple Entry

Section 3
Formulas And Functions
Entering Formulas By Pointing
Errors In Formulas
Filling Formulas
Functions
Function Box
Type Functions
Function Argument Tool Tips
Cell References
Absolute And Relative References

Section 4
File Operations
Save Files
Close Files
Open Files
New Files
Create Workspace Files

Section 5
Moving And Copying Data
Moving and Copying Items
Drag And Drop
Shortcut Menus
Moving And Copying Between Files
Moving And Copying Between Worksheets
Paste Special

Section 6
Formatting
Background Fill Colour
Borders
Alignment
Merge Cells
Number Formats
Advanced Formats
Format Cells Dialog
Custom Number Formats
Formatting Columns And Rows
Hide Columns And Rows
Insert and Delete Cells
Shortcut Keys For Formatting
Conditional Formatting

Section 7
Names
Rules When Naming Cells
Define and Create Name
Selecting Names
Names In Formulas
Apply and Delete Names
Intersecting Names

Section 8
Working With Multiple Sheets
Moving Between The Workbook Sheets
Move And Copy Worksheets
Insert And Delete Worksheets
Group Adjacent Sheets
Group Non-Adjacent Sheets
Fill Data Across Worksheets
3-D Formulas
External References
Protect Worksheet Data
View Worksheets Side By Side
Watch Window

Section 9
Printing
Print Preview
Page Setup
Page and Margine Tab
Header and Footer Tab
Sheet Tab
Page Breaks
Printing Large Spreadsheets

Section 10
Manipulating Large Worksheets
Split Screen
Freeze Panes
Zoom

Section 11
Sorting & Subtotalling Data
Lists
Sorting List Data
Subtotals
Summarising A Subtotalled List
Show And Hide By Level
Sort List Data With Sort Tools

Section 12
Customizing Excel
Customize Toolbars
Set Options
General Tab
View and Edit Tabs
Edit Tab
Transition Tab

Appendix
Standard Toolbar
Auditing Toolbar
Movement Keys
Mouse Selection Methods
Selection Keys
Keyboard Shortcuts For Formatting
Glossary



Tags for this post>> |

June 9, 2008

14 HTML Video Tutorials

HTML (Hypertext Markup Language) is the markup language that is used for creating and rendering (displaying) web pages. It uses ‘tags’ to specify headings, paragraphs, lists, etc., and additionally it supports the use of interactive forms, embedded images, and other objects, such as Flash movies. HTML can also contain CSS (Cascading Style Sheets) code that defines the look and feel of items such as font size and color and paragraph style. Here are 14 HTML Video Tutorials from sutree.com that will show you how to do use several important HTML and CSS features to develop web pages. Also included are some videos to help you creating an ecommerce site.


14 HTML Web Building Course Videos:

Create Tables in HTML

Create Bullet, Number, and Definition Lists in HTML

Link to Webpages in HTML

HTML Tags

Add a Background Image to a Webpage

CSS Syntax

CSS Text Align

Follow These Principles When Designing Your Web Site

Creating Webpage Frames

How to Link Pages Within a Website

Choose and Register a Website Domain

Tips for Creating a Successful e-Commerce Website

How to Create a Successful E-Commerce Web Site

Get Your Site Listed on Google



Tags for this post>>

36 Dreamweaver Video Tutorials

Adobe Dreamweaver is a great tool for web designers and developers to design, develop, and maintain websites and web application, giving them both a graphical visual interface and an efficient coding environment. In addition, Dreamweaver is integrated with other Adobe applications which provides an efficient workflow across your these tools. Here are 36 Dreamweaver Video Tutorials for sutree.com‘s Dreamweaver 8 Course. These will teach you how to use and work with Dreamweaver to design, create and manage your web pages and web sites. Some of the features and topics demonstrated by these videos include: Browser Plug-ins, Form Validation, Snippets, Templates, CSS, Layers, Rollovers, Adding Flash Buttons and Content, Menus, Images, and Databases.


Dreamweaver 8 Course Videos:

01. Dreamweaver 8 Video Tutorial – Control Flash Movies

02. Dreamweaver 8 Video Tutorial – Pop Up Windows

03. Dreamweaver 8 Video Tutorial – Check for Plugins

04. Dreamweaver 8 Video Tutorial – Validate Forms

05. Dreamweaver 8 Video Tutorial – Rollover Status Bar Message

06. Dreamweaver 8 Video Tutorial – Using Snippets

07. Dreamweaver 8 Video Tutorial – Editing Templates

08. Dreamweaver 8 Video Tutorial – Dreamweaver Templates

09. Dreamweaver 8 Video Tutorial – Working with CSS

10. Dreamweaver 8 Video Tutorial – Ads by Layers

11. Dreamweaver 8 Video Tutorial – Image Navigation Menu

12. Dreamweaver 8 Video Tutorial – Adding Rollovers

13. Dreamweaver 8 Video Tutorial – Animating Layers

14. Dreamweaver 8 Video Tutorial – Layer Visibility

15. Dreamweaver 8 Video Tutorial – Working with Layers

16. Dreamweaver 8 Video Tutorial – Adding Images

17. Dreamweaver 8 Video Tutorial – Flash Buttons

18. Dreamweaver 8 Video Tutorial – Simple Contact Form

19. Dreamweaver 8 Video Tutorial – Adding Flash Content

20. Dreamweaver 8 Video Tutorial – Jump Menus

21. Dreamweaver 8 Video Tutorial – List Menus

22. Dreamweaver 8 Video Tutorial – Tracing Images

23. Dreamweaver 8 Video Tutorial – Preview in Browser

24. Dreamweaver 8 Video Tutorial – Files Menu

25. Dreamweaver 8 Video Tutorial – Making New Pages

26. Dreamweaver 8 Video Tutorial – Define Your Site

27. Dreamweaver 8 Video Tutorial – File Associations

28. Dreamweaver 8 Video Tutorial – Create Database with SQLYOG – Step 1

29. Dreamweaver 8 Video Tutorial – Create a page to insert data – Step 2

30. Dreamweaver 8 Video Tutorial – Swap Text Input to Radio Buttons – Step 3

31. Dreamweaver 8 Video Tutorial – Display the records – Step 4

Dreamweaver Video Tutorial – Button Rollovers

Dreamweaver Video Tutorial – Define Local Root/Site Folder

How to set up and use the FTP feature in Dreamweaver

Check for Plugins in Dreamweaver

How Change File Associations in Dreamweaver



Tags for this post>>
June 4, 2008

25-Lesson Flash 8 Video Course

Macromedia Flash Pro 8 is the industry’s most advanced authoring environment for creating interactive web sites, digital experiences, and mobile content. With Flash Professional 8, creative professionals can design and author interactive content rich with video, graphics, and animation for truly unique, engaging web sites, presentations or mobile content. Here is a great, free 25 Lesson Flash 8 Video Course that will teach you both Flash fundamentals and a few advanced Flash features and techniques.


Flash 8 Course Videos:

01. Flash Video Tutorial on – Using Layers

02. Flash Video Tutorial on – Guide Layers

04. Flash Video Tutorial on – Adding Scenes

05. Flash Video Tutorial on – Adding Images

06. Flash Video Tutorial on – Editing Images

07. Flash Video Tutorial on – Gradients

08. Flash Video Tutorial on – Tweening

10. Flash Video Tutorial on – Image Buttons

12. Flash Video Tutorial on – Morfing

14. Flash Video Tutorial on – Drag and Drop

15. Flash Video Tutorial on – Load External SWF

16. Flash Video Tutorial on – Buttons Sounds

17. Flash Video Tutorial on – Masking

18. Flash Video Tutorial on – Animated Highlighting

19. Flash Video Tutorial on – Animated Banner

20. Flash Video Tutorial on – Bitmap Tweening

21. Flash Video Tutorial on – Importing Libraries

22. Flash Video Tutorial on – Flash Projectors

23. Flash Video Tutorial on – Sequential Images

24. Flash Video Tutorial on – Get URL

25. Free Flash 8 Video Tutorial – Loop FLV Movies

How to use macromedia flash 8

How to use Actionscript 2.0 class



Tags for this post>>

Free Advanced Word 2003 Training Manual

Here is an excellent, free Advanced Word 2003 Training Manual, from mousetraining.co.uk. This illustrated advanced Word training document is 191 pages in length and is downloadable in zip format (ZIP file is 3.5mb, resulting DOC file is 4.4mb after unzipping). Advanced Word features and topics covered by this training manual include the following: advanced Table Features, advanced Formatting Techniques, Styles, Outlining, working with Headings and Fields, Auto-Features, Columns, Indexes and Tables, Master Documents, Track Changes, Comments, and Templates and Forms. Look for the hand icons which precede the list of instructions for each command or feature being taught. 

Table of Contents of Advanced Word 2003 Training Manual:

Introduction
How to use this guide

Section 1
Advanced Tabs
Tables – Advanced Features
Moving and Copying
Splitting A Table
Table, Row, and Column Sizes
Table Alignment
Merging and Splitting Cells
Sorting Cells
Table Formulas
Draw Table
Repeating Table Headings

Section 2
Advanced formatting techniques
Styles
Default styles
Creating new styles
Redefining a style
Creating & redefining with format style
Copying Styles between Documents
Borders
Changing the paragraph border width
Page borders & Shading
Defining Styles Automatically
Printing Styles

Section 3
Outlining
Document outlines
Using an Outline
Moving Headings and Body Text in an Outline
Outline Numbering
Customising the outline numbering

Section 4
Using the Document Map
Document Map
Changing the Level of Detail

Section 5
Numbering Headings
Applying Numbering
Customised Numbering

Section 6
Using Fields
Inserting Fields
Field Switches
Viewing & Updating Field Codes
Locking, Unlinking & Deleting Fields
Common Long Document Fields
Date and Time
Document Information
Links and References

Section 7
Creating cross-references
Cross-Referencing Text
Heading cross-references
Page Reference
Updating cross-references

Section 8
Auto-Features
AutoFormat
AutoText
AutoComplete
AutoSummarize

Section 9
Advanced tips and tricks
Locating Files
Advanced Header and Footer options
HyperLink

Section 10
Section Breaks
Continuous & Next Page Section Breaks
Odd Page and Even Page section breaks
Handling Headers And Footers
Section Properties

Section 11
Columns
Snaking Columns
Entering Text
Lines between columns
Column Breaks

Section 13
Indexes and Tables
Table of Content
Indexes
Editing and Updating Indexes
AutoMark

Section 14
Using Master documents
Saving the Master Document
Converting An Existing Document Into A Master Document
Inserting Subdocuments Into A Master Document
Working With Subdocuments
Multi-User Access
Formatting A Master Document
Printing the Master document & Subdocument
Printing the Master Document Outline

Section 15
Footnotes and endnotes
Footnotes and Endnotes
Inserting Footnotes
Customising Footnotes
Using Endnotes

Section 16
Track Changes (Revision Marks)
Locking A Document
Versions

Section 17
Comments
Locking A Document
Printing Comments

Section 18
Customising the Word 2003 environment
Customising Toolbars &Menus
Macros

Section 19
Templates and Forms
Customising the template environment
Form fields


Tags for this post>> |

June 3, 2008

Over 600 Photoshop and ImageReady Tutorials

Here are over 600 Photoshop and ImageReady Tutorials from graphicssoft.about.com. These cover several versions of Photoshop, from the latest CS version to 7.0, 6.0, Element, and 5.5. Many Photoshop features and tools are taught by these Photoshop tutorials, from the very basics to advanced topics, such as Curves, Levels, Extract, Actions, Adjustment Layers, and ImageReady Animation and Slicing. Also available at this site is a Free Photoshop Course by Email.


500 Online Photoshop Tutorials:

 - Photoshop’s Native Filters (20)
 - Photoshop Basics & Tools (73)
 - Creating Art & Effects (126)
 - Actions & Batch Processing (17)
 - Layers & Blend Modes (20)
 - Working with Type (14)
 - Layer Style Effects Tips (14)
 - Creating Text Effects (44)
 - Masks and Selections (18)
 - Creative Photo Effects (84)
 - Web Graphics / ImageReady (62)
 - Fix, Correct, Repair Photos (79)
 - Photoshop Color Management


More Advanced Photoshop Tutorials at about.com:

 - Unsharp Mask
 - Curves
 - Levels
 - Extract Command
 - Paths and the Pen Tool
 - Using Actions
 - Batch Processing
 - Adjustment Layers
 - Animation, Rollovers, Slicing in ImageReady


Photoshop Tutorials by John Woods at about.com:

 - Photoshop CS
 - Photoshop 7.0
 - Photoshop Elements / 6.0
 - Photoshop 6.0
 - Photoshop 6.0 / 5.5
 - Free Photoshop Layer Styles
 - Free Photoshop Pattern Sets



Tags for this post>> |

Free Introduction to Word 2003 Training Manual

Here is a great, free Introduction to Word 2003 Training Manual, from mousetraining.co.uk. This illustrated Word training document is 167 pages in length and is downloadable in zip format (ZIP file is 3.1mb, resulting DOC file is 6.5mb after unzipping). Word features and topics demonstrated include the following: Smart Tags, Undo & Redo, Autocorrect, Templates, Navigation, Selecting Text, Moving & Copying, Character and Paragraph Formatting, Bullets, Document Views, Printing, Tables, and Page Layout. Look for the hand icons which precede the list of instructions for each command or feature being taught. The Appendix list the toolbars mentioned within the manual with a breakdown of their functions and tables of shortcut keys.


Table of Contents of Introduction to Word 2003 Training Manual:

Introduction
How to use this guide
Objectives:
  Instructions
  Appendices
  Keyboard
  Commands
  Notes

Section 1
The Basics:
Windows Concepts
Getting Started
Screen Layout:
 Title bar
Toolbars
Horizontal and Vertical Ruler
Status Bar
Scrollbars
Task Pane
View Buttons
Smart Tags
Microsoft Word 2003 Help

Section 2
Entering and Editing Information:
Word Wrap
Inserting Lines
Editing Text
Show / Hide All
The Undo and Redo features
Using Smart Tags
AutoCorrect

File Operations:
New Files
Templates
Saving files
Closing Files
Opening Files

Section 3
Navigation:
  The Mouse
  The Keyboard
  Goto

Section 4
Selecting Text:
Extend Mode
Selecting non-concurrent text

Section 5
Editing Tools
Move & Copy:
  Moving items
  Copying items
  Drag and Drop
  Moving and Copying between documents
  Clipboard Task Pane
  Insert a file

Section 6
Formatting:
Character formats:
  Formatting toolbar
  Font Style
  Point Size
  Font Tab
  Character Spacing Tab
  Text Effects Tab

Keyboard shortcuts for character formatting

Paragraph Formats:
  Alignment
  Indents
Other Paragraph Formats:
  Line and Page breaks Tab
  Pagination
  Keyboard shortcuts for paragraph formatting

Borders:
Changing the paragraph border width
Page Borders
Shading
Shortcut Menus

Bulleted and Numbered lists:
Bullets
Customise a bulleted list
Numbers
  Customise a numbered list
  Create a multi-level list
  Bullets and numbering with the shortcut menu

Section 7:
Viewing Your Document:
  Normal View
  Print Layout View
  Web Layout View
  Outline View
  Document Map
  Viewing multiple documents

Printing:
Print Preview
  Magnification
  Edit from the Print preview screen
  Pages per screen
  Zoom
  View ruler
  Shrink to fit
  Full screen
  Print a document
  Number of Copies

Section 8:
Tables:
  Create tables
  Table Navigation
  Select items in a table
  Format table data
  Change column widths
  Add rows and columns
  Remove rows and columns

Table borders and shading:
  Tables and Borders Toolbar
  Choose bordered edges
  Change border style
  Line style, weight, and color
  Table shading
  Repeating Table Headings

Section 9:
Proofing Tools
Spell Checker & Thesaurus
  Spell and Grammar Checker
  Thesaurus
  Look up a synonym

Section 10:
Page Layout
Page Setup:
  Margins Tab
  Paper Tab
  Layout Tab
Page breaks

Headers and Footers:
  Header and footer toolbar
  Insert Header and Footer field codes
  Using pictures in headers and footers

Page numbers:
  Position
  Alignment
  Format
  Start number
  Suppress page numbers

Appendix:
Keyboard Shortcuts
Movement keys
Selection keys
Keyboard shortcuts for character formatting
Shortcuts keys for table navigation
Shortcut keys for selecting in a table


Tags for this post>> |