Free Web Design, Development and Programming Training and Tutorial Resources




    



February 24, 2009

Excellent CSS Reference Sheet


Here is an excellent CSS Cheatsheet from addedbytes.com (pdf format), giving you a one-page reference sheet, listing all selectors (as of CSS 2.1) and properties. It includes a visual example of the box model, unit reference for CSS units and the various media types CSS makes allowance for.


Contents of CSS Cheatsheet
:

 - Selectors
 - Pseudo-Selectors and Pseudo-Classes
 - Sizes and Colors
 - Box Model
 - Positioning
 - Dimensions
 - Color / Background
 - Text
 - Fonts
 - Boxes
 - Tables
 - Paging
 - Interface
 - Aural
 - Miscellaneous



Tags for this post>>

A Nice Outlook 2003 Tutorial


Here is a good Outlook 2003 Tutorial, from the University of New Hampshire. This Outlook tutorial provides very nice screen shot illustrations and step-by-step instructions for using many important features of Outlook, such as creating and sending email, changing your user settings, adding and editing the address book, working with the calendar, creating rules, archiving, and working offline.


Contents of Outlook 2003 Tutorial:

Views
Different Outlook views

Settings
Changing settings

Mail
Creating & sending mail
Creating signature files
Viewing other mailboxes

Address Book
Global Address List
Contact Folder
Creating new contacts
Distribution lists

Calendar
Creating Appointments
Planning Meetings
Sharing

Organization
Creating Sub-Folders
Creating Rules

Saving Space
Archiving

Offline Access
Offline Folders
Enabling Offline Access



Tags for this post>>

1-page XHTML & CSS Tutorial


Here is a quick 1-page XHTML & CSS Tutorial, from Brown University. This tutorial will show you how to write valid XHTML (just HTML with a few minor tweaks) and then use CSS to control the typography, layout, and look-and-feel of your web pages and sites. CSS (Cascading Style Sheets) permits a minimal HTML code base for your pages while giving you a high degree of formatting and layout flexibility. This will result in your users having a better and more compelling experience, while giving you the ability to control your web site behaviour and layout from one CSS file.


Contents of this 1-page XHTML and CSS Tutorial:

XHTML:
 - The Picky Bits up top
 - Sample XHTML page
 - Habit Forming
 - Code-Phobic Alternatives

CSS:
 - CSS explained
 - The Three Different Ways to Bring in CSS
 - Linked CSS
 - Embedded
 - In-line
 - Anatomy of a CSS Rule
 - Selectors
 - Tag
 - Class
 - ID
 - Nesting Selectors
 - Link Pseudo-class Selectors
 - div and span tags
 - Basic Formatting
 - Positioning and Layout
 - Links



Tags for this post>> |

1-page HTML Tutorial


This is a quick 1-page HTML Tutorial, from Brown University. It goes over the basics of coding HTML for your web pages, as shown in the contents below. HTML (or Hypertext Markup Language) is the actual code that web pages are written in. HTML controls the structure of your webpage (where things are placed on the screen) as well as some aspects of the appearance (how text and other items are displayed).

Although you can develop web pages using a graphical user interface using applications such as Dreamweaver and FrontPage without learning or using HTML, HTML is still useful for tweaking and making those webpages more exciting and efficient. Therefore, using these applications along with manually editing the HTML code can make you a more effective web site developer and designer.


Contents of this 1-page HTML Tutorial:

 - Web Publishing Process
 - Tag Basics
 - Simple HTML Page
 - Tag Properties
 - Images
 - Links
 - Special Characters and More on White Spaces
 - Lists
 - Naming and Coding Conventions
 - Resources



Tags for this post>>

125 Illustrator Tutorials at Layersmagazine.com


Layersmagazine.com offers 125 free Adobe Illustrator Tutorials that will teach you how to use the many features and tools of this graphic and image editing application. The Illustrator tutorials linked here are their most recent ones covering Illustrator CS4 and CS3. Older versions of Illustrator are also included in this tutorial collection.


Adobe Illustrator Tutorials at layersmagazine
:

 - Cool Logo Effects in Adobe Illustrator
 - Blend Tool Backgrounds
 - Banner Ad Templates from Illustrator to Photoshop
 - Patterns and Shapes in Adobe Illustrator
 - Animate a Flying Bird using Illustrator and Flash, Part 1
 - Animate a Flying Bird using Illustrator and Flash, Part 2
 - Background Experiments with Photoshop and Illustrator
 - Adobe Illustrator in 3D
 - Illustrator to Flash
 - Simple Silhouettes in Illustrator CS4
 - Roundtrip Logo From Illustrator to Photoshop
 - Mapping Photos to 3D Objects in Illustrator
 - Illustrator CS4 Artboards
 - Illustrator CS4 Multi Artboards
 - Illustrator CS4 Blob Brush
 - Illustrator CS4 Gradients
 - Illustrator CS4 Appearance Panel
 - Background Designs
 - Blend Tool Revisited
 - Illustrator Brush Patterns Into Photoshop
 - Blueprint-Style Text in Adobe Illustrator
 - 3D Graph Effects
 - Blending Gradients in Illustrator
 - Using Illustrator’s Mesh Tool as Nature Intended
 - Leather Stylin’ in Illustrator
 - Creating 3D Shapes in Illustrator
 - Smart Border Effects
 - Fun Film Design Using Illustrator
 - Vector Art Goes Hollywood
 - Wedding Album: Illustrator and Photoshop Warping
 - Swingin’ Retro Look in Adobe Illustrator
 - Crazy 3D Shapes in Illustrator
 - Designing Ultra SceneXCore Apparel in Photoshop and Illustrator
 - Night Lights: Creating a Glowing Neon Effect in Illustrator
 - Creating Silhouettes in Adobe Illustrator
 - Brushed Metal Effect in Adobe Illustrator
 - Creative Masking Techniques in Illustrator
 - Grunge Borders in Adobe Illustrator CS3
 - Circle of Stars in Adobe Illustrator
 - Using Public Domain Images for Art in Adobe Illustrator
 - Adobe Illustrator’s Transform Again Command
 - Creating Reflecting Web Icons in Illustrator
 - Using Kuler with Illustrator
 - Live Color in Illustrator CS3
 - Adobe Illustrator: Creating an I-Pod
 - Product Boxes Made Easy in Adobe Illustrator
 - Illustrator: Large Brushes for Abstract Backgrounds
 - Graffiti-Like Website Layout Using Adobe Illustrator
 - Adobe Illustrator: CS3 Templates
 - Spacing Boxes in Adobe Illustrator
 - Dashed Lines in Illustrator
 - Create a Pyramid in Adobe Illustrator CS3
 - Masking in Illustrator CS3
 - Creating a Halftone Background in Adobe Illustrator
 - Exporting from Adobe Illustrator to Flash
 - Editing Gradients Inside Adobe Illustrator
 - Decorate with Ribbons in Illustrator
 - Creating Custom Brushes with the Transform Each Command in Illustrator
 - Illustrator CS3 Interface
 - Illustrator CS3 Document Profiles
 - Adobe Illustrator CS3 Anchors
 - Halftone Dots in Adobe Illustrator
 - Adobe Illustrator: the Pathfinder Palette
 - The Pen and Paths in Adobe Illustrator
 - Illustrator: Golden Section
 - Startup File in Adobe Illustrator
 - Adobe Illustrator: Sliding Graphs
 - Adobe Illustrator: Intro to the Gradient Mesh Tool
 - Photoshop and Illustrator: Preparing Your Art to Pop



Tags for this post>>

1-page Dreamweaver Tutorial


Here is a quick 1-page Dreamweaver Tutorial from Brown University that will show you how to create web pages using Dreamweaver. Using Dreamweaver, you can develop a new web site or maintain and work on an existing site, no matter how it was created previously. You can use Dreamweaver to create a brand new web site or to update a current site, even if it wasn’t created in Dreamweaver. To start editing your web pages, simply open Dreamweaver and select File > Open from the menu to access a web page.

This Dreamweaver tutorial will get you going with learning how to create and work with:

 - Tables
 - Text
 - Images
 - Hyperlinks



Tags for this post>>

February 23, 2009

Macro Tutorial for Word and Excel


Here is an excellent one-page Word and Excel Macro Tutorial from Brown University. This will help you understand when to use and how to create macros for Word and Excel.

According to Microsoft, “If you perform a task repeatedly in Word, you can automate the task by using a macro. A macro is a series of Word commands and instructions that you group together as a single command to accomplish a task automatically. Instead of manually performing a series of time-consuming, repetitive actions in Word, you can create and run a single macro, in effect, a custom command, that accomplishes the task for you.

Here are some typical uses for macros:

 - To speed up routine editing and formatting
 - To combine multiple commands; for example, inserting a table with a specific size and borders
 - To automate a complex series of tasks.


Macro Tutorial Objectives:

 - Understand what a macro is and how it works
 - Learn how to conceptualize and record your own macros
 - Learn how to run them simply and efficiently via shortcut keys
 - Learn how to install pre-written macros
 - Learn how to save and embed them into your documents



Tags for this post>> |

15-Lesson PowerPoint 2003 Tutorial


Here is a 15-Lesson PowerPoint 2003 Tutorial, from Wesleyan University. This PowerPoint tutorial covers many important features of this presentation application, such as Design Templates, Slide Layouts, Hyperlinks, Charts and Graphs, Images, Colors and Backgrounds, Packaging your Slide Presentation, making your Presentation available on the Web, Printing, and running a Slide Show.


Contents of PowerPoint 2003 Tutorial:

Getting Started
Starting PowerPoint
Selecting a Design Template
Choosing a Slide Layout
Creating Your First Slide
Working with Multiple Slides

Adding and Editing Content:
Text
Web Links
Charts, Tables, Graphs
Images and Graphics
Slide Colors and Backgrounds
Slide Effects

Presenting Your Show:
“Package for CD”
Put Your Presentation on the Web
Printing Handouts
Running Your Slide Show



Tags for this post>>

5-Lesson Excel 2003 Tutorial


Here is a quick 5-Lesson Excel 2003 Tutorial, from Wesleyan University. It provides instructions on how to perform the fundamentals of using Excel, including entering  your data, formatting and editing data with the cells, creating and using formulas, and using charts.


Contents of Excel 2003 Tutorial:

 - Introduction and Orientation

 - Entering Data

 - Formatting and Editing Data

 - Using Formulas

 - Creating Charts



Tags for this post>>

FrontPage 2003 Tutorial from Wesleyan University


Here is a FrontPage 2003 Tutorial from Wesleyan University, providing step-by-step instructions for creating and maintaining web pages and web sites using Microsoft FrontPage.


Contents of FrontPage 2003 Tutorial:

 - How a Web Page Works

 - Getting Started

 - Page Settings

 - Text Options

 - Creating Links

 - Images

 - Tables

 - Preview

 - Design Tips

 - Managing Your Web Site



Tags for this post>>

February 21, 2009

177 Photoshop Tutorials at Layersmagazine.com


Here are many excellent Photoshop Tutorials from layersmagazine.com. These will teach and show you how to perform a great number of Photoshop tasks and use many of its tools. This site hosts a total of 177 Photoshop tutorials for several, 62 of which are linked below covering Photoshop CS4 and CS3. Older versions of Photoshop are included in their Photoshop tutoral library. They make use of  screen videos and also illustrated step-by-step directions.


Photoshop Tutorials at layersmagazine:

 - Installing an Image Slideshow in WordPress
 - Table Styles in Photoshop
 - Blend Tool Backgrounds
 - Taking Image Slicing from Photoshop to Dreamweaver
 - The Photoshop Guys Discuss Photoshop CS4 (Part 1 of 4)
 - The Photoshop Guys Discuss Photoshop CS4 (Part 2 of 4)
 - The Photoshop Guys Discuss Photoshop CS4 (Part 3 of 4)
 - The Photoshop Guys Discuss Photoshop CS4 (Part 4 of 4)
 - Banner Ad Templates from Illustrator to Photoshop
 - Adobe Photoshop Variables
 - Exposure Blending in Photoshop
 - Background Experiments with Photoshop and Illustrator
 - Retouching Eyes with Photoshop CS4
 - Retouching Eyes with Photoshop CS4, Part 2
 - Photoshop CS4 Interface Overview
 - Photoshop CS4 Configurator
 - Photoshop CS4 Photomerge
 - Photoshop CS4: New Beauty, Part 1
 - Photoshop CS4: New Beauty, Part 2
 - Photoshop CS4: New Beauty, Part 3
 - Photoshop CS4: New Beauty, Part 4
 - Photoshop CS4 Graduated Filters
 - Photoshop CS4 Tone Correction
 - CS4 Camera Raw Post-Crop Vignette
 - Photoshop CS4 Camera Raw Adjustment Brush
 - Background Designs
 - Nesting Smart Objects for Multimask Effects in Photoshop
 - Working with Hair in Photoshop
 - Trendy Circle Brush in Photoshop
 - Animate the Splash Using Photoshop and After Effects
 - Black and White Fine-Tuning in Photoshop CS3
 - Illustrator Brush Patterns Into Photoshop
 - Turn Down the Noise in Photoshop CS3
 - Mastering Keyboard Shortcuts
 - Developing Outlines in Photoshop CS3
 - Retouching Eyes in Photoshop
 - Feathered Transparency With Photoshop & Dreamweaver
 - Designers, Get the Grunge Out in Photoshop CS3
 - Photoshop CS3: Underexposure S.O.S.
 - Creating a DVD Menu in Photoshop CS3 Extended
 - Photo Composite Template
 - Image Slicing in Photoshop CS3
 - Smart Border Effects
 - Masking Hair in Photoshop CS3
 - Understanding Channels in Photoshop CS3
 - Creative Contrast in Photoshop CS3
 - Black and White Toning in Photoshop CS3
 - Offset Dashes in Photoshop CS3
 - 2D/3D with Photoshop CS3 Extended and After Effects
 - Wedding Album: Illustrator and Photoshop Warping
 - Creating a Background in Photoshop, Part 1
 - Creating a Background in Photoshop, Part 2
 - Applying Digital Makeup in Photoshop CS3
 - Zoomify Objects in Photoshop CS3
 - Smart Strokes in Photoshop CS3
 - Importing Photoshop Files Into Flash
 - Pop the Image in Photoshop CS3
 - Photoshop CS3: Output Sharpening
 - Dreamweaver and Photoshop Integration
 - Building Your Web Gallery in Photoshop CS3
 - Mixing It Up With CS3
 - Creative Gradient Mapping in Photoshop CS3



Tags for this post>>

February 20, 2009

2 Video PowerPoint 2007 Tutorials


Here are 2 Video Tutorials for PowerPoint 2007, from HP’s Learning Center. The first one shows you how to create a slide master and the second one teaches you how to customize PowerPoint’s user interface.


Microsoft PowerPoint 2007: Create a New Slide Master

Learn how to create master slides in PowerPoint to add or change design elements and formatting in presentations. (2:43) Video

Microsoft PowerPoint 2007 gives you the option of creating your own master slides, which allow you to add or change design elements and formatting within presentations. A slide master is a single, controlling slide behind the scenes that specifies how slides appear all the way through your presentation. When you make changes to a slide master, they’re applied universally to the presentation. A slide master is part of a template — it stores information by using placeholders. We’ll also demonstrate how to add a new placeholder to a master slide. You can use multiple slide masters within a presentation or simply use a single slide master that contains multiple layouts.


Microsoft PowerPoint 2007: Customize the PowerPoint Interface

This video tutorial will show and teach you how to change options and customize the interface to find the toolbars and functions you need most.   (4:44) Video

PowerPoint is a powerful, customizable tool for creating presentations. Before you create a PowerPoint presentation, you might want to customize the interface to make it easier for you to find the toolbars and functions you need most. In this demonstration you’ll learn how to change options and customize the interface.



Tags for this post>>

51 Flash Tutorials from Layersmagazine.com


Here are 51 great Flash Tutorials from layersmagazine.com. They cover and teach many Flash features, tasks, and activities in Flash CS4, Flash CS3, and Flash 8 using screen cam videos and step-by-step illustrated instructions. These Flash tutorials are linked below, with the most recent at the top.


Flash Tutorials at layersmagazine:

 - Flash Audio, Part 1
 - Flash Audio, Part 2
 - Video Filters and Blend Effects in Flash
 - Adobe Sound Documents
 - Creating Motion in Flash with Bones Tool
 - Flash CS4 Deco Tool
 - Flash to Video
 - Adobe Soundbooth Audio Files with Flash Video
 - Animate a Flying Bird using Illustrator and Flash, Part 1
 - Animate a Flying Bird using Illustrator and Flash, Part 2
 - Creating Rain in After Effects, Part 2
 - Creating Smoke in Adobe Flash
 - Illustrator to Flash
 - Dreamweaver XML Flash Slideshow Extension
 - Trace Bitmap in Flash CS4
 - Flash Video the Easy Way
 - Flash Video the Easy Way, Pt. 2
 - Flash Video the Easy Way, Pt. 3
 - Flash CS4 Motion Easing
 - Flash CS4 Animating Puppets
 - Flash CS4 Motion Tweening
 - Flash CS4 Motion Editor
 - Flash CS4 Folded Book
 - Flash CS4 SprayBrush
 - Flash CS4 Media Encoder
 - Basic Coding For Flash Video
 - Falling Snow in Flash CS3
 - HD Video in Flash Professional CS3
 - Code-Free Flash Video
 - Flash CS3: Made-To-Order Text
 - Flash Buttons with Action Script 3
 - Mastering Keyboard Shortcuts
 - Closed-Captioned Video in Flash CS3
 - Moving Illustrator Art in Flash CS3
 - Handlin’ Photoshop and Illustrator Content in Flash
 - Animated Zoom Blur in Flash CS3
 - In a Flash
 - Importing Photoshop Files Into Flash
 - Controlling the Timeline with ActionScript 3
 - Converting Video Files into Flash Format
 - Turning Animation into Code in Flash CS3
 - 9 Slice Scaling in Flash
 - Passing Variables Using Flash and Dreamweaver
 - Creating a Simple Calculator Using Adobe Flash
 - Complex Button Animation in Adobe Flash
 - Flash Slideshow Image Gallery
 - Animating a Match in Adobe Flash
 - Custom Video Player in Adobe Flash
 - Creating an Interactive Story in Adobe Flash
 - Creating an Interactive Story – Part 2
 - E-card Announcement using Adobe Flash
 - Animating Shadows in Adobe Flash
 - Animating Your Adobe Photoshop Files in Flash 8
 - Attaching Movie Clips in Flash Using ActionScript
 - Motion Blur in Flash
 - Tweening with Ease: Using Easing Controls
 - Blending and Filtering in Flash 8 Professional
 - Using Illustrator Symbols in Flash
 - Integrating Video in a Flash Movie
 - Photoshop Layers into Flash
 - Water Ripples



Tags for this post>> |

February 16, 2009

Free Outlook 2007 Class

Here is HP’s Free Outlook 2007 Class, where you will learn how to manage your Inbox, present a professional image, and protect your personal data. This online 24/7 course teaches Outlook 2007 features such as the Ribbon, how to send and receive email safely, how to customize email using font styles and themes, and how to email pictures. You’ll also learn techniques for managing your Inbox using file folders and email message archiving, along with using antivirus software to protect your Inbox. You can enroll in this class for free at any time.

This Outlook class with teach you the following:
 - With what Microsoft Outlook 2007 can do: the interface, the Ribbon and views and how to send and receive email
 - Using color coding and other techniques to organize incoming emails and prioritize them
 - Scheduling meetings using the printable Calendar and sharing your availability with co-workers
 - Using themes, Quick Styles and customized signature lines to give your emails a more professional edge
 - Protecting your Inbox by backing up data and using a spam blocker, and learning how to repair a corrupt Inbox file


Outlook 2007 Class Lessons:

Lesson 1: Getting to know Microsoft Outlook 2007

Outlook 2007 is a feature-rich email client. This lesson introduces you to the Outlook 2007 interface and features, shows you how to change views to focus on groups of emails and steps through the process of sending and receiving email.

Lesson 2: Managing your Inbox, email addresses, Calendar and more
Knowing how to keep your Inbox clean and quickly prioritizing incoming mail can be a considerable time saver. This lesson covers those topics in addition to search techniques and practical business uses of the Calendar.

Lesson 3: Email tips for adding professionalism and efficiency
In this lesson, you’ll learn to use font styles, themes, signature lines, tables and more to draw attention to important information in your emails. You’ll also learn to use Quick Parts for often-used text.

Lesson 4: Email safety tips for protecting your Inbox, contacts and data
Even with strong controls in place, some spam still passes through email servers to your Inbox. This lesson covers antivirus software and spam filters to keep most of it at bay. You’ll also learn how to back up files and repair a corrupted Inbox.



Tags for this post>> |

Free Microsoft Project 2007 Class

Here is HP’s Free Microsoft Project 2007 Class, which will give you a good introduction to Project management using Microsoft Project. This online course, available 24/7, will help you to sharpen and demonstrate your project management skills. You’ll learn the basics of project management  and how to manage a project’s scope, deadlines, costs and resources using Project 2007. You can enroll for free at any time.

Project features you will learn:
 - Understand project management basics of time, money, resources and scope
 - Set up and manage tasks
 - Manage human and material resources
 - Track projects more effectively


Project 2007 Class Lessons
:

Lesson 1: Introduction to Project Management
This lesson provides the basics of managing a project using Microsoft Project 2007. You’ll discover how Project 2007 can help you manage project time, resources, costs and scope, plus you’ll learn how to get started in Project 2007.

Lesson 2: Working with Tasks
Defining, listing, organizing and scheduling tasks are key to any project’s success. In this lesson, you’ll discover how to list tasks in a project, organize them into phases and schedule them to be certain your project comes in on time.

Lesson 3: Managing Resources
Most projects involve multiple resources. In this lesson, you’ll discover how to assign people and equipment to tasks and define working times for resources to ensure effective resource management.

Lesson 4: Tracking and Reporting
Once a project has been created and resources assigned, you need to track the project and create reports. In this lesson, you’ll learn how to save a baseline of your project, enter progress data, print your plan and generate reports.



Tags for this post>>

February 10, 2009

2 Free Classes for Developing Web Pages

Here are two free online classes for learning how to create web pages. The first one teaches you how to use and code HTML to develop your web pages, and the second one show you how to use Microsoft Expression Web software. These courses are located in HP’s Learning Center, in their Programming and Web Design and Development class section. Free registration is required.


Building your First Web Page

There are a lot of easy web editors available to help you make your own web pages, but this free HTML tutorial includes the HTML basics you need to make your web pages from scratch. In this course, you’ll create your first web page with HTML and then publish it online. You’ll also learn how to find the right HTML editor, work with website images, and more.

Lesson 1: HTML basics: the language of the web
Get started by exploring the web—what it is, how it works, and which languages it speaks (like HTML, for instance). You’ll learn about the essentials of what you need to create a simple web page, and which tools and software to try.

Lesson 2: HTML tutorial: document structure and text
In this lesson, you’ll take a tour of the building blocks of HTML. The core part of the lesson examines syntax and attributes, document structure, and headings and paragraphs. Those are weighty words for easy-to-use elements that make up a web page.

Lesson 3: Beyond plain text: images, text formatting, and hyperlinks
With the basics down, you’re ready to add some spice to your web page. In this lesson, you’ll find out how to create a simple navigational system using hyperlinks, add images, and control text color, size, and placement.

Lesson 4: Web publishing: putting your page online
Publishing your web page is the final step. In this lesson, you’ll learn how to find an ISP that’s right for you. In addition, you’ll explore hosting options (free and fee-based), take a look at space considerations, and, finally, post your page.


Microsoft Expression Web: Building Websites

This class covers the basics for creating a website with Microsoft’s Expression Web with features such as toolbars, formatting, page layouts and link creation. With this easy website creation software, you’ll apply cascading style sheets, then learn how to create complex queries, how to configure the software for different browsers and how to create interactive web pages with ASP.NET 2.0 capabilities.

Lesson 1: The basics for creating a website
A website presence on the internet for your company is a necessity. This lesson introduces you to the Expression Web software, explains what is needed in a small business website design and helps you start the planning process for your site.

Lesson 2: Cascading style sheets examples

Creating elegant websites is no longer a chore now that cascading style sheets (CSS) are available. In this lesson, you’ll learn how to work with Microsoft Expression Web software’s CSS capabilities to create styles.

Lesson 3: How to build a web page with presence and accessibility
Accessibility, compatibility, query capabilities and data presentation are important aspects of a competitive, functioning website. Learn how to configure and manage Microsoft Expressions Web software to create, present and maintain meaningful content.

Lesson 4: Leveraging ASP.NET 2.0 to make your own website dynamic
In this final lesson, you’ll learn how to work with ASP.NET to make your website an interactive, dynamic web application. We’ll address controls, no-code date binding and master pages.



Tags for this post>>

6 Free Excel 2007 Classes

Here 6 Free Excel 2007 Classes, courtesy of HP’s Learning Center. These online Excel courses cover several important features of this spreadsheet application, such as filtering data, linking data between workbooks, learning the interface, making PivotTables, creating web queries, and creating macros and VBA scripts. These Excel classes are found in this site’s section offering 28 Free Software Classes. Free registration is required.


Microsoft Excel 2007: Extreme
Learn how to push the limits of Microsoft Excel 2007 by learning essential VBA programming, ActiveX controls and web queries.

Microsoft Excel 2007: Filter Data
This animated demonstration shows you how to filter data in Microsoft Excel 2007.

Microsoft Excel 2007: Link and Unlink Content between two Workbooks
This animated demonstration shows you how to link and unlink information between Microsoft Excel workbooks.

Microsoft Excel 2007: Record a Simple Macro and Edit It in VBA
This animated demonstration shows you how to record a simple macro in Excel and edit it in VBA.

Microsoft Excel 2007: Take a Tour of the Interface and Learn Basic Skills
This animated demonstration introduces you to the new Microsoft Excel 2007 interface, which is very different from earlier versions.

Microsoft Excel 2007: Create a PivotTable
This step-by-step demonstration shows you how to summarize a large amount of data to glean some meaning from it using PivotTables in Microsoft Excel 2007.



Tags for this post>>

February 5, 2009

Free Online Photoshop CS2 Class

Here is an excellent Free 24/7 Online Photoshop CS2 Class, from HP’s Learning Center. This Photoshop course, located in the Free Software Classes section of this site, will teach you advanced Photoshop techniques such as special image selection, color correction, layer masks, vignettes, and composite images. You’ll learn how to create complex images and special techniques for image creation, editing, selection and correction. In addition, this Photoshop class covers working with layer masks and creating simple and complex composite images. Free registration is required.


Photoshop CS Class Lessons:

Lesson 1: Simple image compositions and selection methods
This first lesson introduces you to special selection techniques that can help you overcome tricky selection problems. You’ll also work with layers, gradients and several other tools to create a simple image composition.

Lesson 2: Color and more
Photoshop’s color features are all you need to turn good images into great ones. In this lesson, you’ll learn how to use color correction techniques with adjustment layers, as well as use the Levels and Curves features.

Lesson 3: Layer masks and advanced vignettes
Enhancing your image is easy with layer masks. You’ll use a simple layer mask to create special vignette effects to enhance your images. In addition, you’ll create a simple composite image using layer masks.

Lesson 4: Complex composite images
Finally, you’ll learn about complex composite images. You’ll get an overview of composite images, including the skills and tools necessary to create great images. You’ll also learn how to create a Photo Artistic complex composite image using a basic step-by-step approach.



Tags for this post>>

4 Free Word 2007 Classes

Here are 4 Free Word 2007 Classes, from HP’s Learning Center, which offers free 24/7 online computer and software classes covering many areas. These Word classes are located in this site’s Microsoft Office and Adobe course section. Also linked below are free marketing and promotion templates for Word and Publisher. Free registration is required.


Microsoft Word 2007: Advanced
This free Microsoft Word 2007 tutorial will teach you how to create complex documents and master advanced features.

Microsoft Word 2007: Take a Tour of Special Features
Microsoft Word 2007 offers new special features. Follow along with this demonstration to learn how to use a few of them.

Microsoft Word 2007: Take a Tour of the Ribbon
This animated demonstration shows you how to use the Ribbon, the new, tabbed navigation system in Microsoft Word 2007.

Microsoft Word 2007: Use the Track Changes feature
This step-by-step demonstration shows you how to track revisions to documents in Microsoft Word 2007.

Create your own marketing materials with free templates
Customize HP’s free office templates with Microsoft Word or Publisher to create business cards, letterhead, brochures, postcards and more.



Tags for this post>>