Free Microsoft Office Training and Tutorial Resources




    



July 30, 2009

4 Excel 2007 Tutorials

Here are four Excel 2007 Tutorials, hosted by the University of South Dakota. These Excel tutorials introduce you to this powerful analytic, organization, and data logging application. They are organized in a series of pdf documents that take you through and demonstrate various features, tools, and tips of Excel. The purpose of these Excel 2007 tutorials is to provide instructions on performing both basic and advanced Excel tasks and functions.


Excel Tutorial Part 1: Getting the Basics  (877 Kb, 22 pages)
This first Excel tutorial focuses on the basic features of Excel like the ribbon, adding headers and footers, navigation, entering data in worksheet, and merging and splitting of cells. The Excel 2007 file used in the tutorial can be downloaded from here.

 - First look into Excel
 - Components of Excel
 - The Ribbon
 - Key Tips
 - Using a Previous Version of Excel
 - Inserting Columns
 - Formatting Cells
 - AutoSum
 - Add Headers and Footers
 - The New Workbook Window
 - Navigation in Excel
 - Modifying Cells
 - Entering Data into a Worksheet
 - Merge or Split cells
 - Combine the contents of multiple cells into one cell
 - How do I work with people who don’t have Excel 2007 yet?


Excel Tutorial Part 2: Charts and Graphs  (346 Kb, 11 pages)
This Excel tutorial teaches you charts and graphs in Excel. The tutorial explains various chart and graph features like formatting chart titles, individual columns, moving and resizing tips, modifying the properties of your charts, and changing the axis scale. The Excel 2007 file used in the tutorial can be downloaded from here.

 - Creating Charts in Excel
 - Change the Chart
 - Add Chart
 - Change how your Chart
 - Format Chart Titles
 - Format Individual Columns
 - Add your Chart to a PowerPoint Presentation
 - Choosing a chart type
 - Resize and move an embedded chart
 - Moving and resizing tips
 - Data of the Chart is Linked to the Chart
 - Modify the properties of your charts
 - Add a graphic to a chart
 - Change the axis scale
 - Freeze rows and columns in a List


Excel Tutorial Part 3: Conditional Formatting  (614 Kb, 21 pages)
This tutorial introduces you to conditional formatting in Excel. The topics covered include creating conditional formula that results in a logical value, an overview of formulas, using array formulas and array constants. The three Excel 2007 files used in this tutorial can be downloaded from here: Grade SheetLoan Worksheet, and Tutorial Worksheet.

 - Conditional Formatting in Excel
 - Create conditional formulas
 - Create a conditional formula that results in a logical value (TRUE or FALSE)
 - Create a conditional formula using IF, AND, and OR
 - Functions: A Quick Refresher
 - Overview of formulas
 - Using functions and nested functions in formulas
 - The difference between absolute, relative and mixed references
 - Using names in formulas
 - Using array formulas and array constants


Excel Tutorial Part 4: Pivot Tables  (535 Kb, 15 pages)
This tutorial handles the introduction of Excel pivot tables to your skill set. All the basic features that are related to pivot tables in Excel are covered here. Features that are explained include: inserting pivot tables, adding a report filter, filter the data, and using a custom calculation. The two Excel 2007 files used in the tutorial can be downloaded from here: PivotTable_II and PivotTable_III.

 - Get your Data Ready
 - Insert a Pivot Table
 - Add a Report Filter
 - Group the Dates
 - Pivot the Report
 - Filter the Data
 - Filter by using Comparisons
 - Filter by Date
 - Change how Subtotals are Displayed
 - Use a custom calculation
 - The GETPIVOTDATA Function
 - Change the Format of a PivotTable Report



Tags for this post>>

2 Access 2007 Tutorials

Here are two Access 2007 Tutorials, at the University of South Dakota, which you can use to increase your MS Access skills. The first Access tutorial introduces you to the world of the database management systems through using Access. The second Access tutorial handles some of the advanced topics in like queries, forms and reports. These tutorials are in pdf format.


Access Tutorial Part 1  (765 Kb, 24 pages)
This section of the MS Access tutorials gives you a helping hand in getting started with the database management system. The section explains basic features of Access like templates, adding table to your database, creating forms and reports etc.

 - Getting Started
 - The New File Extension
 - Access Templates
 - Add a Table to your Database
 - Create a Form
 - Create a Report
 - A Few Terms
 - Database design basics
 - Some database terms to know
 - What is good database design?
 - Specifying primary keys
 - Naming Conventions
 - Create a new table
 - Add fields to a table in Datasheet view
 - Add a field from the Field List pane
 - Set a field’s data type in Datasheet view
 - Set the primary key


Access Tutorial II: Queries, Forms, and Reports  (532 Kb, 15 pages)
This section of the MS Access tutorials introduces you to features like queries, creating forms, understanding controls, editing forms, subforms and reports.

 - Introduction to Queries
 - Creating Forms
 - Understand controls
 - Editing Forms
 - Subforms
 - Reports



Tags for this post>>

4 Flash Tutorials

Here are 4 excellent Flash Tutorials at California Polytechnic State University. These Flash MX 2004 tutorials will teach you how to use Flash in your applications to create interactive and animated Web sites. They start off with an introduction to various Flash interfaces and tools. Then the tutorials cover many animation and navigation tools that are available in Flash for your use. After finishing this course of four Flash tutorials you will be able to create some great applications using this application. These Flash tutorials are in pdf format.


4 Flash Tutorials:

Flash MX 2004 Interface / Tools Introduction (667 Kb, 18 pages)
This section gives you a basic introduction to the world of Flash development. Various Flash MX interfaces and tools are explained here in this section.

 - Working with the Timeline
 - Moving the playhead
 - Frames and keyframes
 - Working with layers
 - About the Property inspector
 - About the Library panel
 - Components in the Library panel
 - Working with common libraries
 - Draw vector art
 - Drawing curved paths with the Pen tool
 - Adjusting anchor points on paths
 - Reshaping using the Selection tool
 - Optimizing curves
 - About overlapping shapes in Flash
 - Erasing
 - Transforming objects freely
 - Scaling objects
 - Add text
 - Creating scrolling text
 - Aligning objects
 - Tweened animation
 - Frame-by-frame animation
 - Layers in animation
 - Creating keyframes
 - Representations of animations in the Timeline
 - Examples


Flash MX 2004 Introduction Lesson (644 Kb, 7 pages)
This section explains some of the introductory topics on Flash. Basic procedures like creating a new document, opening a new document, defining document properties, creating movie clips, drawing rectangle are illustrated here.

 - Creating a new document
 - Open a new document
 - Define document properties
 - Adding media content
 - Add text
 - Create a movie clip
 - Add text
 - Resize with Free Transform tool
 - Drawing a rectangle
 - Copy / Paste Text
 - Common Library


Flash MX 2004 Animation Lesson (182 Kb, 7 pages)
Here in this third section teaches lessons on animation. The subjects which are covered in this section are playing with frames, motion between animation, onion skinning, drawing with pencil tool, creating a motion tween etc.

 - Opening a document
 - Opening the library
 - Grouping objects
 - Frames and keyframes
 - Onion skinning
 - Creating frame-by-frame animations
 - Copying and pasting frames
 - Frames and keyframes
 - Motion between animation
 - Test the application
 - Copy / Paste Text
 - Drawing ovals
 - Create a movie clip
 - Grouping objects
 - Onion skinning
 - Creating frame-by-frame animations
 - Copy / Paste Text
 - Drawing with the Pencil tool
 - Create a movie clip
 - Tweening shapes
 - Creating a motion tween


Flash MX Navigation Lesson (27 Kb, 4 pages)
This section helps you to create the over all design (user interface) and setup home page navigation.



Tags for this post>>

July 27, 2009

OneNote 2007 Tutorials

Here are some excellent OneNote 2007 Tutorials at Microsoft Office Online that are in the form of Webcasts, Podcasts and video tips. OneNote is a software package for information gathering, and multi-user collaboration from Microsoft and is primarily used for taking notes. This app is well suited for use on pen-enabled Tablet PCs, in environments where pen, audio or video notes are more appropriate than an intensive use of keyboards. These tutorials demonstrate personal usage and collaboration of notes, introduction to OneNote’s basic features, finding text in OneNote 2007 and using tags to organize notes.


Webcasts:

OneNote 2007 Tips and Tricks: Personal Usage and Collaboration
These webcasts are recorded as live events by Microsoft Office experts and they discuss their tips and tricks in OneNote for personal usage and collaboration of notes. They serve as a detailed reference to the work flow of OneNote.


Video tips:
These video tips provide a neat and easy workflow into a specific task in OneNote such as finding text, using hyperlinks to easily link documents and organizing notes.

- How to Easily Find Text in OneNote 2007 256k | 750k
- Introduction to the Basic Features of OneNote 2007 256k | 750k
- Quick Tips for OneNote 2007 256k | 750k
- Use Hyperlinks to Easily Link Documents in OneNote 2007 256k | 750k
- Use Tags to Organize Your Notes and Auto-Create To-Do Lists in OneNote 2007 256k | 750k
- Using SharePoint Server 2007 with OneNote 2007 256k | 750k


Podcasts:
OneNote 2007 Tips and Tricks: Personal Usage and Collaboration
This podcast is the audio-only version of previously recorded webcasts and discuss tips and tricks, in OneNote for personal usage and collaboration of notes.



Tags for this post>>

6 Photoshop Tutorials

Here are 6 Photoshop Tutorials, at California Polytechnic State University, that explain and describe many of Photoshop’s features and tools. These Photoshop tutorials cover using Adobe Photoshop CS3 and CS4, but most of these can also be followed using older versions such as Photoshop.


6 Adobe Photoshop Tutorials:

Photoshop Tutorial 1 – Introduction  (246 Kb, 5 pages)
This tutorial gives you an introduction to Adobe Photoshop.

Photoshop Tutorial 2 – Creation  (97 Kb, 2 pages)
This workshop shows you how to use various features of Photoshop like opacity, drop shadow, feather, levels, selection, filters, shapes, and styles.

Photoshop Tutorial 3 – Output  (95 kb, 2 pages)
In this workshop, you will learn creating aqua buttons and saving files.

Scanning and Digital Cameras  (100 Kb, 2 pages)
In this workshop, we will explain about scanners, how to use it, deciding on the right resolution and getting out the red eye and color correcting.

Photoshop File Optimization Tutorial
This tutorial explains how to optimize a file in Photoshop.

Photoshop for Blackboard  (474 kb, 10 pages)
With Photoshop you may create a graphic that can be saved and uploaded into Blackboard as a banner on the announcements page. In this section, this topic is explained in detail.



Tags for this post>>

July 25, 2009

2 PowerPoint 2007 Tutorials

Here are 2 PowerPoint 2007 Tutorials at the University of South Dakota. These PowerPoint tutorials will teach you how to create attractive slideshow presentations using PowerPoint 2007. With the help of PowerPoint you can create dynamic and high-impact presentations. The first tutorial helps you plan and build a presentation and the second one shows you how to add charts and record narration.


PowerPoint Tutorial 1: Planning and Building Your Presentation 732K 15 Pages
This section of the tutorial gives you tips on how to properly plan and build your slideshow presentation. This will let you know the general PowerPoint environment, themes, adding bells and whistles, printing presentation handouts etc.

 - Planning Your Presentation
 - Get to Know the PowerPoint Environment
 - Switching Views and Navigating a Presentation
 - Building Your Presentation
 - Themes
 - Adding Bells and Whistles
 - Printing Presentation Handouts


PowerPoint Tutorial 2: Add Charts and Record Narration 571K 12 Pages
This section introduces you to adding charts and record narration to a presentation. The topic explanations are well supported by ample screen shots on the topics being covered.

 - Introduction
 - Adding Charts to your Slides
 - Add Narration to a Presentation
 - Set the Slide Timings Manually



Tags for this post>>

Digital Camera Tutorial

This excellent tutorial on Digital Cameras at The University of South Dakota is a downloadable pdf file that explains everything about digital cameras in 9 pages, keeping the size of the file to 153kb. This Digital Camera tutorial discusses the basics of a digital camera and how an image is captured. It also show users how to select a good digital camera by providing information on what to look for such as resolution, image formats, lens, shutters and shooting modes. This Digital Camera tutorial also demonstrates how exposure and color balance combine to produce a lasting image. Other resources such as image sizes, file formats and file formats are provided. A comparison between lossy and lossless compression is also carried out.


Digital Camera Tutorial:

Cameras and Capturing an Image

What to Look for in a Digital Camera
 - Resolution
 - Compression and image formats
 - Lens
 - Shutter speed range and noise reduction
 - Shooting modes
 - Other important features

Exposure

Setting Color Balance

Image Size, File Size, and File Format
 - Selecting Image Size
 - Lossy vs. lossless compression
 - File formats
 - When to use each format

Useful Resources



July 23, 2009

Outlook 2007 Tutorial

Here is an Outlook 2007 Tutorial, at the University of South Dakota . This tutorial on Outlook 2007 takes you through the new features that are being introduced in Outlook 2007 over the previous version, Outlook 2003. The step-by-step guide to Outlook 2007 can really lead you from the basic to the advanced features of Outlook. This Outlook 2007 tutorial cover some of the topics like how to use flags and reminders, recalling an Email, creating a task or contact, rules, working out with calendar, processing meeting requests, using the Outlook journals, creating tasks etc. The tutorial is 32 pages in length and 882kb in size (pdf format).


Contents of Outlook 2007 Tutorial:
Some things haven’t changed
 - Using other tabs Getting Started with Outlook Options
 - Options for writing e-mail
 - Options for sending e-mail
Flags and Reminders
Recalling an Email
Use your Email to Take Action
 - Create a Task
 - Create a Contact
When the Action is Extraction
The To-Do Bar
Outlook Rules
Create a Logical Folder Structure in Outlook
 - Creating a Folder
 - Naming Folders
 - Popular Folder Structures
 - Make It a Habit!
The Outlook Calendar
Create an Appointment
Have a Meeting
 - Create a meeting request
 - Process meeting requests
Tracking Multiple Calendars
Using the Outlook Journal
 - Automatically record items and files
Tasks
 - Create a task from scratch
 - Create a task from an existing task
 - Schedule time in Calendar to Complete a Task
Using Notes in Outlook



Tags for this post>>

CSS Tutorials and References

These CSS Tutorials at sitepoint  are an excellent starting point for those who want to learn and use CSS in web development. CSS is a presentation language used to describe the presentation and layout of elements in HTML and XHTML pages. CSS can also be applied to any kind of XML document. These CSS tutorials and references provide users with information on CSS properties, CSS selectors, CSS At-rules, CSS concepts and live examples of using CSS elements.


CSS Properties
These tutorials discusses properties of CSS elements such as boxes, list, table, layout, typographical, user interface and color and backgrounds. Each of these properties is explained in detail, though most of them are self explanatory.

 - Box Properties
 - Layout Properties
 - List Properties
 - Table Properties
 - Color and Backgrounds
 - Typographical Properties
 - Generated Content
 - User Interface Properties
 - Paged Media Properties
 - Vendor-specific Properties
 - Alphabetic Property Index


CSS Selectors
Strictly speaking, a selector is a pattern and is used to match a set of elements in an HTML or XHTML document. This section explains how selectors are used in CSS to create simple patterns

 - Universal Selector
 - Element Type Selector
 - Class Selector
 - ID Selector
 - Attribute Selector
 - Selector Grouping
 - Combinators
 - Pseudo-classes
 - Pseudo-elements


CSS At-rules
This CSSf tutorial provides information on At-rules that provide instructions and directives to the CSS parser. The At-rules elements are explained with their respective examples.

 - @charset
 - @import
 - @media
 - @page
 - @font-face
 - @namespace


CSS Concepts
These tutorials explains some key concepts in CSS such as syntax and nomenclature, inheritance, layout and formatting, filters and hacks and the basic differences between HTML and XHTML.

 - What Is CSS?
 - General Syntax and Nomenclature
 - The Cascade, Specificity, and Inheritance
 - CSS Layout and Formatting
 - Workarounds, Filters, and Hacks
 - Differences Between HTML and XHTML


CSS Live Examples
This section is a quick reference point for CSS properties and live examples are provided for most of them.

  CSS Properties
    Box Properties
      Dimensions
       - height
       - min-height
       - max-height
       - width
       - min-width
       - max-width
      Margins
       - margin-top
       - margin-right
       - margin-bottom
       - margin-left
       - margin
      Padding
       - padding-top
       - padding-right
       - padding-bottom
       - padding-left
       - padding
      Borders and Outlines
       - border-top-color
       - border-top-style
       - border-top-width
       - border-top
       - border-right-color
       - border-right-style
       - border-right-width
       - border-right
       - border-bottom-color
       - border-bottom-style
       - border-bottom-width
       - border-bottom
       - border-left-color
       - border-left-style
       - border-left-width
       - border-left
       - border-color
       - border-style
       - border-width
       - border
       - outline-color
       - outline-style
       - outline-width
       - outline
    Layout Properties
     - display
     - position
     - float
     - clear
     - visibility
     - top
     - right
     - bottom
     - left
     - z-index
     - overflow
     - clip
    List Properties
     - list-style-type
     - list-style-position
     - list-style-image
     - list-style
    Table Properties
     - table-layout
     - border-collapse
     - border-spacing
     - empty-cells
     - caption-side
    Color and Backgrounds
     - background-color
     - background-image
     - background-repeat
     - background-position
     - background-attachment
     - background
     - color
    Typographical Properties
     - font-family
     - font-size
     - font-weight
     - font-style
     - font-variant
     - font
     - letter-spacing
     - word-spacing
     - line-height
     - text-align
     - text-decoration
     - text-indent
     - text-transform
     - text-shadow
     - vertical-align
     - white-space
     - direction
     - unicode-bidi
    Generated Content
     - content
     - counter-increment
     - counter-reset
     - quotes
    User Interface Properties
     - cursor
    Vendor-specific Properties
      Mozilla Extensions
       - -moz-border-radius
       - -moz-box-sizing
       - The display Property Value: -moz-inline-box
      Internet Explorer Extensions
       - zoom
       - filter
       - behavior


CSS Selectors:
 - Universal Selector
 - Element Type Selector
 - Class Selector
 - ID Selector
 - Attribute Selector
   - CSS3 Attribute Selectors
 - Selector Grouping
  Combinators
   - Descendant Selector
   - Child Selector
   - Adjacent Sibling Selector
   - General Sibling Selector
  Pseudo-classes
   - :link
   - :visited
   - :active
   - :hover
   - :focus
   - :first-child
   - :lang(C)
    CSS3 Pseudo-classes
     - :nth-child(N)
     - :nth-last-child(N)
     - :nth-of-type(N)
     - :nth-last-of-type(N)
     - :last-child
     - :first-of-type
     - :last-of-type
     - :only-child
     - :only-of-type
     - :root
     - :empty
     - :target
     - :enabled
     - :disabled
     - :checked Pseudo-class
     - :not(S)
  Pseudo-elements
   - :first-letter
   - :first-line
   - :before
   - :after
   - ::selection


CSS Concepts:
  The Cascade, Specificity, and Inheritance
   - The Cascade
   - !important Declarations
   - Specificity
   - Inheritance
     - The CSS Property Value inherit



Tags for this post>>

131 Illustrator Tutorials from around the Web

Here are 131 Illustrator Tutorials, located at InstantShift, providing a very comprehensive set of tutorials from around the web for this vector graphics editor. These Adobe Illustrator tutorials help you in a big way whether you are an Illustrator beginners you are seeking to learn more advanced features of this graphics tool. The tutorials are divided into sections so that you can directly go and look for the areas in which you want more expertise and to increase your skills. After finishing with these Illustrator tutorials, you will be able to expertly draw and edit your illustrations, design your own logos. and create special effects.


Illustrator Tutorials for the basics
This section of tutorials will be learning guide for you if you are comparatively new to Adobe Illustrator. The following tutorials give you excellent lessons on mastering Illustrator within thirty days, guiding you to use paintbrush and brush tools, selection tools, rotate tools, mesh tools and many other useful tools that you can use.

 - Learn Illustrator CS in Days
 - A Comprehensive Guide: Illustrator’s Paintbrush Tool and Brush Panel
 - Illustrator’s Pen Tool: The Comprehensive Guide
 - Utilizing the Magic Wand’s Tolerance Levels
 - Illustrator Live Trace
 - Adobe Illustrator CS Tutorial: Selection Tools
 - Spraying Symbols in Adobe Illustrator
 - Duplicate with rotate tool
 - An Intro to the Mesh Tool
 - Illustrator Make with Mesh
 - Tips for Working with the Gradient Mesh Tool In Illustrator
 - Spiral Tool Mysteries – Solved!
 - Using the Pathfinder and Align tool in Illustrator
 - How to Make a Custom Illustrator Brush
 - Get More-Natural Adjustments with Illustrator “Reshape” Tool
 - Fun with Illustrator’s Blend Tool
 - Adobe Illustrator Shortcuts
 - Create a Disco Environment with Twirl Tool, Crystalize , and Envelope Tool


Character Illustrator Tutorials
These tutorials focuses on topics related to characters. After going through this section you will be able to create different characters according to your creativity.

 - How to Create a Killer Chainsaw Bunny Character
 - Character Illustration
 - Create Your Own Vector Cartoon Character
 - Creating vector characters in Illustrator
 - Symmetrical Illustration: Thug Bunny
 - Wolf Drawing Tutorial
 - Twitterlove Bird, from sketch to vector in Photoshop and Illustrator
 - Create a Cute Vector Monster from a Pencil Sketch
 - Face, Hair, Clothing Illustrator Tutorial
 - Drawing a Character’s Face in Illustrator
 - Drawing Homer Simpson
 - Creating convincing characters
 - Create a Gang of Vector Ninjas


Page Layout Illustrator Tutorial
These tutorials explains features on page layout such as creating website layout, creating a sample of fairy tale story book and designing a business report cover.

 - Use Adobe Illustrator to Create a Clean Website Layout
 - Create the First Page of a Fairy Tale Story Book, with a Hint of Kitsch
 - Design a Business Report Cover


Illustreator Tutorials forLines, Shapes, Charts, and Graphs
This section of tutorials covers the topics on lines, shapes, charts and graphs. These tutorials illustrate these features with good amount of ample examples by giving screenshots wherever necessary.

 - Turn a Boring Bar Graph into a D Masterpiece
 - Trendy Geometric Lines Tutorial
 - Command Shape in Illustrator
 - A Time to Shine
 - Creating Road Maps in Adobe Illustrator
 - Use the power of Illustrator to create cool D infographics
 - Creating Omspace D cylinder graphic in Illustrator
 - D Charts in Adobe Illustrator CS  
 - D Graphs  
 - How to make retro/futuristic curves in   Steps
 - Create a Four-Leaf Clover
 - Spice up Pie Charts


Objects Related Illustrator Tutorials
These tutorials explains some of the advanced features of Illustrator like crafting a vector collegiate notebook design, creating rotatable globe, creating animated D poker chips, and creating vector home cinema design.

 - Craft a Vector Collegiate Notebook Design
 - How to Create an Open Book with Illustrator’s D Extrude & Bevel Tool
 - Create a Rotatable Globe in Adobe Illustrator
 - Create a D Push Pin and a Paper Note in Illustrator
 - Draw A Realistic Vector Guitar in Inkscape
 - Create an Animated D Poker Chip – PART I
 - Create an Animated D Poker Chip – PART II
 - Create a Sidekick LX Styled Vector Illustration
 - Illustrator Tutorial: Disco Ball
 - Create a Vector Home Cinema Design
 - D Objects and Transparencies to Make a Vector Cola Bottle Design
 - How to Make Realistic Skate Wheels in Illustrator
 - How to Draw Your Own Vector Wings
 - Chinese Bamboo


Sketch and Painting Illustrator Tutorials
These tutorials demonstrate sketch and painting related topics. Some of the topics covered here are creating a stunning undersea painting using vector packs, and master painting in Illustrator.

 - Create a Stunning Undersea Painting Using Vector Packs
 - A Pseudo-Sugar Skull: From Start to Finish
 - Master painting in Illustrator
 - How to Create a Classic Vector Painting with Watercolor Washes and Line Art
 - Woman and Cats How-To Advanced


Illustrator Tutorials covering Logos, Symbols, and Icons
This section of tutorials introduces you to the topics related to logo, symbol and icon. Some of the topics covered here are making a vector military cap icon, creating a vector light bulb icon, creating an envelope icon with a satin feel, pirate cartoon tutorial, and creating a vector RSS icon with illustrator.

 - How to Make a Vector Military Cap Icon
 - How to Create a Vector Light Bulb Icon with Inkscape  
 - Create a Spiral Ornament Symbol in Illustrator  
 - How to Create a Vector Safari Compass in Illustrator
 - Adobe Bridge Icon
 - iTune Icon
 - Create an envelope icon with a satin feel
 - How to Turn Glasses into a Great Geek Icon
 - Logo Design Project Step by Step Walkthrough
 - Creating a Crazy Cool Logo
 - Test Your Creativity  
 - Pirate cartoon tutorial
 - Create a Vector RSS Icon with Illustrator  
 - How to Design a Classic Heraldic Figure
 - BMX Illustration


Text Illustrator Tutorials
These tutorials teach you text related topics of Illustrator.

 - Let’s Make a Playful Yet Robust D Letter Design
 - Blueprint Style Text in Adobe Illustrator
 - D Text Tutorial
 - Creating an Environmentally Friendly Green Type Treatment
 - Tug and Twirl Text in Illustrator
 - Type on a Path Options
 - Make a Torn Vector Desktop Wallpaper with Angled Text
 - How to Create a Magnified Text Illustration  
 - ways to apply a line pattern effect on text in Illustrator


Patterns Texture Illustrator Tutorials
These tutorials cover patterns and texture related features of Illustrator.

 - Geometric Patterns in Illustrator
 - Create A Wood Grain Texture
 - Creating-Pattern
 - Create a Themed Repeating Pattern in Illustrator
 - Design your own pattern swatches


Effects related Illustator Tutorials
These tutorials describe and explain effects related features of Illustrator. Some of the special effects that are covered here are creating cool water effect, vectoring hair etc.

 - Creating a Cool Water Effect  
 - Vectoring Hair
 - Easily Make Shiny Realistic Vector Hair
 - Experimental text effects


Illustrator Tutorials forBackgrounds, Abstract Art, Poster or Label
These tutorials cover topics related to backgrounds, abstract art, poster and label.

 - How to Create Colorful Abstract Artwork in Illustrator
 - Create a Blissful Vector Scene
 - Super cool abstract vectors illustrator and photoshop
 - Create Abstract Backgrounds  
 - Swirl Mania in Illustrator and Photoshop  
 - Poster Illustration: Go Forth and Create  
 - Create an Milk Bottle with a Funny Cow Label
 - Design a Print-ready Ad in Adobe InDesign
 - Swingin ’ Retro Look in Adobe Illustrator
 - Crazy cool vectors illustrator and photoshop
 - Recolor Artwork Using Illustrator’s LiveColor


Advanced Illustrator Tutorials
Here are some advanced tutorials showing how to create and manage vector graphics in Illustrator such as an abstract phoenix, pattern maniac, and an abstract peacock.

 - Illustrator Vector Line Art of Cruise Ship
 - See-Through Car Illustration Tutorial
 - How to find Inspiration for illustration design   Finding Inspiration
 - Some Lovely Results of illustration   Abstract Peacock
 - Abstract Phoenix
 - Pattern Maniac
 - POGO Illustration


Illustrator Video Tutorials
These video tutorials explain topics like creating D pyramid, creating an iPod, drawing face, creating comic book style text, feynamn diagrams, creating background effects, and creating D shapes.

 - How I Do Stuff Tutorial
 - Create D Pyramid
 - Creating an iPod  
 - Drawing Face  
 - Create Swirling Rainbows with Ease
 - Vector Drawing – The Dog
 - Creating Seamless Pattern
 - Creating Comic Book Style Text
 - Roundtrip Logo from Illustrator to Photoshop  
 - Feynman Diagrams
 - Drawing a Nice Vector Golden Badge Award
 - Creating Vectorized Shining and Sparkling Heart Artwork and Icons  
 - Adding Texture
 - Creative Background Effects  
 - D Brochure
 - Creating D Shapes in Illustrator



Tags for this post>>

July 21, 2009

HTML Tutorials and References

Here are HTML Tutorials and References at reference.sitepoint.com that provide understanding on how to create and manage websites using HTML. Most of these HTML tutorials are focused on various aspects of HTML, its tags, the structures, the attributes and the most commonly used concepts in HTML such as Doctypes, HTML and XHTML and accessibility features. These HTML tutorials are easy to follow and understand and have code samples provided for each topic. Each topic is followed by a short description of its related tags as well.


HTML Elements
This section describes the various elements available in HTML. These elements include structural, head, list, text formatting, table frame and window elements. Each of these elements is followed by a small description. Clicking on the element will display an in-depth explanation and its supportability.

 - Structural Elements
 - Head Elements
 - List Elements
 - Text Formatting Elements
 - Form Elements
 - Image and Media Elements
 - Table Elements
 - Frame and Window Elements
 - Deprecated Elements (to avoid using)
 - Proprietary & Nonstandard Elements
 - Alphabetic Element Index
 - Elements and Valid DTDs They May Appear In


Common Attributes of HTML
This section teaches all attributes that are common to all HTML elements, such as styling, scripting, title and class attributes. The attributes taught here include core attributes and event attributes such as key press, mouse click and mouse move.

 - Core Attributes
 - Event Attributes
 - Extended Event Attributes


HTML Concepts
This tutorial section explains when to use HTML and XHTML, their differences and covers high level concepts related to HTML and XHTML. Also discussed are DocTypes and the syntaxes of HTML and XHTML.

 - Basic Structure of a Web Page
 - Doctypes
 - HTML and XHTML Syntax
 - HTML Versus XHTML
 - HTML/XHTML Accessibility Features


HTML Extras
This tutorial covers additional information about HTML other than attributes and elements such as MIME types, ISO Language Codes and Color names and their related Hex values.

 - Color Names and Related Hex Values
 - ISO 2 Letter Language Codes
 - MIME Types – Complete List


HTML Microformats
This HTML tutorial covers the concept of HTML Microformats which were introduced as a defined set of attributed based on a preexisting standard. Microformats are meant to provide additional formatting in the HTML tags that use them. This tutorial explains Microformats in detail and provides examples for them.

 - hCard
 - hCalendar
 - XFN
 - hReview
 - VoteLinks
 - rel-license
 - rel-nofollow
 - rel-tag



Tags for this post>>

After Effects Tutorials and Videos

Here are many After Effects Tutorials, at tv.adobe.com, that provide great free training videos on this application. Linked below are 12 After Effects CS4 tutorials at this site. After Effects is the latest version of the digital motion and compositing software from Adobe and is used primarily for film and video post production. These tutorials demonstrate how to use After Effects CS4, its features, and how to use it to work with and edit videos. All tutorials are comprehensively explained with examples within screen videos.


12 After Effects CS4 Tutorials:

Introducing After Effects CS4
This tutorial introduces After Effects to first time users giving a brief description of how it is widely used in the industry.

01 Overview of After Effects CS4
This tutorial provides an overview of After Effects and how it works in compositing in films.

02 Creating projects
This section explains how to create new projects, introduce elements in it and save the newly created projects.

03 Creating compositions
This video describes the creation on of compositing in films and how they are used for the full production of a film.

04 Working with the Timeline
Timelines are important in creating the workflow for the compositing elements in After Effects and this video explains this concept in depth.

05 Animation essentials
This video explains the essentials of creating and using animations effectively in After Effects.

06 Previewing Animations
This video explains how to preview newly created animations just before they are put into films.

08 Animating characters
This video provides an in depth explanation of animating characters in After Effects and how they can be effectively used to create animations.

10 Applying effects
Various effects are available in After Effects and this video describes how to use them effectively in film.

11 Correcting color with effects
Colors and other video elements may not exactly turn out to be what they look like. They can be corrected by adding effects and this is explained in this video.



Tags for this post>>

4 Word 2007 Tutorials

Here are 4 Word 2007 Tutorials, located at The University of South Dakota. This series of Word 2007 tutorials will help you get up to speed with Microsoft Word’s many features, which are powerful aids for creating professional looking documents. These Word tutorials are designed to assist both beginners and advanced users. These tutorials are in pdf format.


Microsoft Word 2007 Tutorial Part 1  (993kb, 25 pages)
This first Word tutorial gives you a quick introduction of the word processing tool. The topics covered here are as follows: the ribbon, the quick access toolbar, temporarily hiding the ribbon, working with styles, the format painter, inserting pictures, shapes, and headers and footers.

 - Opening Word 2007
 - The Ribbon
 - The Mini toolbar
 - The Quick Access Toolbar
 - Customize the Quick Access Toolbar
 - Temporarily Hide the Ribbon
 - Using Keyboard Shortcuts in Word 2007
 - Find Everyday Commands
 - Bullets, Numbers, and More like
 - Working with Styles
 - The Format Painter
 - Zoom
 - Insert Pictures, Shapes, Headers, and Footers
 - Horizontal and Vertical Rulers
 - Reviewing for and Correcting Errors
 - Selecting and Moving Text within the Document
 - The New File Format


Microsoft Word Tutorial Part 2  (1024kb, 11 pages)
This Word tutorial teaches topics such as using building blocks, working with clip art, previewing and printing a document, working with hyperlinks, and text animation. The Word documents used in this tutorial can be downloaded from these links: Guide_to_Recycling and Recycle.

 - Using Building Blocks and Quick Parts in Office 2007
 - Working with Clip Art
 - Tables
 - Preview and print a document
 - Working with Hyperlinks
 - Word’s Desktop-Publishing Features
 - Formatting Text in Newspaper-Style Columns.
 - Drawing a Border around the Page.
 - Text Animation


Microsoft Word Tutorial Part 3  (729kb, 19 pages)
This Word tutorial explains how to: use the mail merge task pane, create telephone directory, embed an Excel workbook, create templates, and add protection to a template. The word documents used in this tutorial can be downloaded here: Form Letter, InvoicePhone List.

 - The Mail Merge Task Pane
 - Inserting Merge Fields
 - Previewing the Merged Document
 - Complete the Mail Merge
 - Creating Mailing Labels
 - Creating a Telephone Directory
 - Integrating Objects from Other Programs
 - Embedding an Excel Workbook
 - About Templates
 - Create a template
 - Create Your Own Templates
 - Add content controls to a template
 - Save and distribute building blocks with a template
 - Add protection to a template


Microsoft Word 2007 Tutorial Part 4  (139kb, 7 pages)
This Word tutorial elucidates on topics that include adding content controls to the form, adding instructional text to the form, protecting parts of a form, finding and using a building block, renaming a building block, and deleting a building block. The word documents used in this tutorial can be downloaded from these links: Invoice, PivotTable_III, Margie.

 - Create forms that users complete in Word
 - Add content controls to the form
 - Insert a text control where users can enter text
 - Insert a drop-down list that restricts available choices to those you specify
 - Set or change properties for content controls
 - Add instructional text to the form
 - Add protection to the form
 - Protect parts of a form
 - Protect all of the contents of a form
 - Create and distribute boilerplate text
 - Create a reusable content building block
 - Find and use a building block
 - Change the content in a building block
 - Rename a building block
 - Save and distribute building blocks with a template
 - Delete a building block



Tags for this post>>

July 18, 2009

PowerPoint 2007 Interactive Guide

Here is Microsoft’s PowerPoint 2007 Interactive Guide at Microsoft Office Online. This PowerPoint 2007 tutorial is in the form of an interactive presentation and allows users to create their own presentations as they would with a real PowerPoint 2007 application. Users can add animation, slides, pictures, audio and video to their slides. This PowerPoint 2007 interactive guide acts as a primer for those who would start working with PowerPoint 2007 in future. For a complete searchable list of command equivalents, download the PowerPoint ribbon mapping workbook in Excel format. This workbook lists the locations of PowerPoint 2003 commands in PowerPoint 2007. This workbook is highly rated by those who have used it, and can be used as a quick reference guide for while working with PowerPoint 2007. This PowerPoint 2007 tutorial guide can also download from here.



Tags for this post>>

Outlook 2007 Interactive Guide

Here is Microsoft’s Outlook 2007 Interactive Guide. This Outlook tutorial gives users an in-depth view of how to get the most from this office application. It demonstrates Outlook’s functionality with examples for every feature, guiding users on how to use this email and contact management application effectively. The list of command equivalents are also listed neatly in an xlt document linked along with this post. For a complete searchable list of command equivalents, download the Outlook ribbon mapping workbook in Excel format. This Outlook 2007 tutorial guide can also download from here.



Tags for this post>>

July 14, 2009

3 InDesign Tutorials

Here are 3 InDesign Tutorials at University of Florida Health Science Training Center covering. These InDesign tutorials help you to understand how to use InDesign CS2 and CS3, which is Adobe’s desktop publishing software,. They explain and describe InDesign’s basic features and will help you improve your skills and understanding of how InDesign is used.


Adobe InDesign CS3 Tutorial 3328 kb
This InDesign tutorial demonstrates the interface, preferences, toolbox and various palettes that are available in InDesign CS3. It also shows how to create a master page, navigate through the document, add text and images to the layout, and create drop cap styles.

 - Interface
 - Preferences – Units
 - Toolbox
 - Palettes
 - Create a new document
 - Create a master page
 - Navigating the Document
 - Adding Text or Images
 - Creating Drop Cap Styles


InDesign Exercise Tutorial 33.5 kb
An exercise is given out for you in this section to enhance your desktop publishing skills using InDesign.


Adobe InDesign CS2 Tutorial 757 kb
This InDesign tutorial teaches you about the interface, preferences, toolbox and various palettes that are available within InDesign CS2. It also explains how to create a master page, navigate through the document, and add text and images to the layout.

 - Interface
 - Preferences
 - Toolbox
 - Palettes
 - The Control Palette
 - Create a new document
 - Create a master page
 - Navigating the Document
 - Adding Text or Images



Tags for this post>>

Access 2007 Interactive Guide

Here is the Access 2007 Interactive Guide at Microsoft Office Online. This Access 2007 interactive guide can also download from here. This Access 2007 tutorial helps you to understand MS Access 2007 by leading you through an interactive guide where you can experience the new features of the DBMS real time. The Access 2007 interactive guide demonstrates with ample examples for every feature. The interactive guide can be downloaded and installed in your desktop so that you can have a feel of MS Access even if you are offline. The list of command equivalents are also listed neatly in an xlt document linked along with this post. To effectively use the workbook sufficient tips are given in one of the worksheets. For a complete searchable list of command equivalents, download the Access ribbon mapping workbook.



Tags for this post>>

July 13, 2009

Web Design Tutorial

Here is an excellent Web Design Tutorial, at The University of South Dakota. Some of the aspects covered in this Web Design tutorial include the drafting of the contents of the page, including the header, the body, the font, color and its accessibility. Also included are tips on various types of sites that can be created, and their requisite colors, balance, levels of navigation, and management of information. This web design tutorial is in pdf format, is 11 pages in length, and has a file size of 500kb.


Contents of Web Design Tutorial:

Purpose of Tutorial

Website Development

Page Content
 - Responsibility
 - The Header
 - Body
 - Outline Style
 - Font/ Font Color
 - Website Content
 - Top
 - Down Design
 - Active Voice
 - Accessibility

Designing the Site
 - Type of Site
 - Balance
 - Contrast/Color
 - Navigation
 - Management Information



Tags for this post>>

2 Photoshop CS2 Tutorials

These two Photoshop CS2 Tutorials, at The University of South Dakota, provide users with an in-depth coverage the basics of Photoshop CS2. Some of the important topics covered include a brief introduction to Photoshop, opening a new file, the different types of file Photoshop CS2 supports.


Adobe Photoshop CS2 Tutorial 1:
This first downloadable Photoshop tutorial discusses Photoshop’s tool box and the tools in the tool box that users can work with. All Photoshop tools are covered exhaustively and a section describing the use of layers, the layers palette and how they can be effectively used in an image. (pdf, 706Kb, 17 Pages)

Introduction to Photoshop
 - Learning Objectives
 - Start Photoshop
 - Open a new file

Photoshop tools
 - Marquee
 - Move
 - Lasso
 - Magic Wand
 - Crop
 - Slice
 - Healing Brush
 - Paintbrush/Pencil
 - Cloning
 - Eraser
 - Gradient
 - Paint Bucket
 - Blur
 - Sharpen
 - Smudge
 - Dodge
 - Burn
 - Sponge
 - Typing
 - Text Mask
 - Shape
 - Notes

Eyedropper

Introduction to Layers
 - Adding a New Layer
 - Setting Layer Options
 - Merging Layers
 - Using the Layers Palette


Adobe Photoshop CS2 Tutorial 2:
This second downloadable Photoshop tutorial briefs users of the use of Adjustment tools and working with the various filters already present in Photoshop and those that can be downloaded off the internet. Filters provide various effects to an image and users can customize the level of effect used. A mini-project is also provided allowing users to work on images based on what they have learnt. (pdf, 581Kb, 15 Pages)

 - Adjustments tools
 - Transforming
 - Working with the Filters
 - Project



Tags for this post>>

Excel 2007 Interactive Guide

Here is the Excel 2007 Interactive Guide at Microsoft Office Online. This Excel 2007 tutorial is for learning and self practicing all the basics of Excel. This is specially designed towards intermediate and advanced users. The tutorial takes users through the highest level of spreadsheet capabilities. The interactive guide can be downloaded and installed in your desktop so that you can have a real feel of MS Excel even if you are offline. The list of command equivalents are also listed neatly in an xls document linked along with this post. For a complete searchable list of command equivalents, download the Excel ribbon mapping workbook in Excel format. This Excel 2007 interactive guide can also download from here.



Tags for this post>>

Next Page »