Here is a one-page Adobe Illustrator CS2 Tutorial at Brown University. Illustrator is a comprehensive vector graphics drawing application. that works with lines and algorithms for various shapes, and is unlike PhotoShop, which works in pixels (raster images). This Illustrator tutorial explains the Illustrator environment, tool bar, palettes and status bar. The tutorial also offers details on saving files and explains the various formats we can save them in. It also teaches you the general concepts and some enhanced features of Illustrator CS2. Finally, it provides a hands-on project to evaluate your experience.


Features and Tools Taught by this Illustrator Tutorial:

Adobe Illustrator Environment:
 - Artwork Window
 - Toolbox
 - Palettes
 - Status Bar

General Concepts In Adobe Illustrator:
 - Selecting and Moving
 - Drawing Paths and Shapes
 - Pencil Tool
 - Pen Tool
 - Paintbrush Tool
 - Shape Tools
 - Symbol Sprayer Tool
 - Applying Color
 - Creating Type
 - Saving Files and File Types

Enhanced Features In Adobe Illustrator:
 - Gradients
 - Transparency
 - Filters

Adobe Illustrator Projects:
 - Creating a Flower and Using the Rotate and Transform Tools
 - Creating a Cow and Using the Pathfinder Toolbox
 - Tracing an Intricate Butterfly and Practicing with the Pen Tool

Popularity: 22% [?]

This illustrated Microsoft Access Tutorial from Brown University discusses how a database works, describes the Access GUI, and the usage of queries in Access. The basics of Access are covered in this tutorial, which include creating a blank database, table creation and formatting, importing and exporting external data, SQL queries and the relationship between tables in Access. Also provided are examples with screen shots which help better demonstrate these and other features of Microsoft Access.


Features taught by this Microsoft Access Tutorial:


Key Terms used in Microsoft Access:
This section lists the generic terms used in database and Access.

Creating a New Database in Microsoft Access:
 - Blank Access database

Screen Layouts in Microsoft Access:
This section talks about different screen layouts available in Access.

Creating Tables in Microsoft Access:
Creating tables in Microsoft Access is detailed here.

Formatting Tables in Microsoft Access:
 - Adding and Deleting Columns
 - Resizing Rows and Columns
 - Freezing Columns
 - Hiding Columns

Importing/Exporting from External Data in Microsoft Access:
 - Importing from Excel
 - Exporting is done in a similar fashion

Locating Specific Information in Microsoft Access:
 - Finding Data in a Table
 - Replacing Data
 - Check Spelling and AutoCorrect

SQL Queries in Microsoft Access:
 - Create a Query in Design View

Relationships between Tables in Microsoft Access:
This section expalins database relationships in Access with screenshots.

Simplifying Data Entry with Forms in Microsoft Access:
Access provides an easier way to modify the records. This section discusses that.

Popularity: 26% [?]

Here are some of the best Browser, CSS, and HTML / XHTML Tutorials found at alistapart.com. These web development tutorials explain how Browsers, CSS, HTML and XHTML are used in developing many features of today’s web pages. All web servers and browsers support these technologies and thus any web programmer can make professional looking web pages. These CSS, HTML and XHTML tutorials are easy to follow, understand and implement.


Browser Tutorials:
How well does a browser handle content and data from different sources? Can all the design, code and applications interface and survive on one common platform without conflict? These tutorials discuss standards that should be followed while developing for the web so that these components can talk to each other without conflict. It also covers topics that include version targeting, positioning and HTML semantics.

 - Advanced Debugging with JavaScript
 - Semantics in HTML 5
 - Return of the Mobile Style Sheet
 - Understanding Progressive Enhancement
 - Faux Absolute Positioning
 - They Shoot Browsers, Don’t They?
 - Version Targeting: Threat or Menace?
 - Keeping Your Elements’ Kids in Line with Offspring
 - From Switches to Targets: A Standardista’s Journey
 - Beyond DOCTYPE: Web Standards, Forward Compatibility, and IE8


CSS Tutorials:
CSS is a language used to present a document in a mrkup language. HTML and XHTML use CSS to style web pages to be displayed in them. These tutorials explain how CSS can be effectively used in web pages to define color, fonts, layout and presentation. It also provides code samples to write simple CSS sheets and execute them.

 - Fluid Grids
 - Return of the Mobile Style Sheet
 - Progressive Enhancement with CSS
 - Understanding Progressive Enhancement
 - CSS Sprites2 – It’s JavaScript Time
 - Faux Absolute Positioning
 - Accessible Data Visualization with Web Standards
 - Version Targeting: Threat or Menace?
 - Keeping Your Elements’ Kids in Line with Offspring
 - Beyond DOCTYPE: Web Standards, Forward Compatibility, and IE8


HTML and XHTML Tutorials:
HTML and XHTML go hand in hand as XHTML has the same syntax as HTML and are inline with XML standards. These tutorials help explain how HTML and XHTML work with CSS and Javascript. They also explain how Javascript is used with CSS to style web pages and how they can be centrally located.

 - Fluid Grids
 - Semantics in HTML 5
 - Return of the Mobile Style Sheet
 - A More Useful 404
 - Progressive Enhancement with JavaScript
 - Progressive Enhancement with CSS
 - Understanding Progressive Enhancement
 - CSS Sprites2 – It’s JavaScript Time
 - Faux Absolute Positioning
 - They Shoot Browsers, Don’t They?

Popularity: 32% [?]

Here is a one-page Dreamweaver Tutorial at Brown University that teaches Site Design and Management. Dreamweaver is a web development application originally created by Macromedia, and now produced by Adobe Systems. This Dreamweaver Tutorial will help you design web sites using Dreamweaver. It initially explains how to create a website, how to start using CSS classes with Dreamweaver, how to define a CSS class and how to apply the CSS style to a page. This is followed by an explanation of how to use styles created for another page in the current page.


Features taught by this Dreamweaver Tutorial:

Site Management in Dreamweaver:
 - Create a Site

Dreamweaver SFTP:
This section desribes about Dreamweaver’s built-in SFTP client.

Cascading Style-Sheets in Dreamweaver:
 - The 3 Types of CSS
 - Using CSS to Change the Appearance of a Tag
 - Defining a CSS Class
 - To Apply a Class Style to Your Page
 - To Create CSS Link Rollovers
 - To Use the Styles You’ve Created on Another Page

Popularity: 22% [?]

Here are 2 nicely illustrated PowerPoint 2003 Tutorials at Brown University. The first tutorial teaches the basics of PowerPoint 2003 and the second tutorial covers PowerPoint tips and tricks.


Powerpoint 2003 Tutorial
This tutorial covers PowerPoint features such as design templates and using them in the presentation, adding slides and how to effectively use the Format Menu for slides. Addition of animation is discussed for both PowerPoint 2003 and PowerPoint 2004 and also how to save the presentations.

Create/Open a Presentation and Add Slides In PowerPoint:
 - Open PowerPoint
 - Add slides

Format Menu, Applying a Design In PowerPoint:
 - Design Templates
 - Format Menu

Viewing Slides In PowerPoint:
This section explains how you can view slides in PowerPoint.

Added Attractions In PowerPoint:
 - Text Boxes
 - Clip Art

Changing the Slide Master In PowerPoint:
Learn how to update the slide master, which is where text color, alignment and font face, bullet choices, background colors and graphics are all specified.

Adding Animation In PowerPoint:
 - PowerPoint 2003
 - PowerPoint 2004

Saving Your Presentation to the Web In PowerPoint:
This section explains how to save the files in PowerPoint.


PowerPoint Intermediate – Tips and Tricks for Better Presentations
Intermediate users can learn how to better use PowerPoint by going through the quick tips and tricks section. This section also includes precision layouts, adding animation throughout the presentation. It also introduces slide transitions and how to insert charts in the PowerPoint slides.

Precision Layouts In PowerPoint:
This sections talks about how we can make the layouts more precise.

Masters In PowerPoint:
 - Presentation-Wide Animations
 - Adding Some Branding

Transitions In PowerPoint:
Transitions add professionalism to a presentation, this section talks about that.

Inserting Charts In PowerPoint:
This section explains about the PowerPoint’s ability to incorporate charts.

Saving Options In PowerPoint:
 - Saving to the Web
 - PowerPoint Show

Popularity: 31% [?]

Here are 2 PowerPoint 2007 Tutorials at Brown University. The first PowerPoint tutorial teaches the basics of opening, creation and addition of new slides. The second PowerPoint tutorial focuses on background, colors, fonts and layout modifications.


PowerPoint 2007 Basics Tutorial
This PowerPoint tutorial teaches the basics of PowerPoint 2007 that include opening, creation and addition of new slides in a presentation, adding themes and styles to an existing presentation and then viewing them. It also teaches the user to add a text box, insert a clipart or an image and add animation to the presentation.

New in Office 2007:
Shows the new Ribbon, which is a series of buttons with text labels that exposes the important functions of Office

Create/Open a Presentation and Add Slides In PowerPoint 2007:
 - Open PowerPoint
 - Add slides

Design Tab, Applying Themes:
 - Themes
 - Design Tab

Viewing Slides In PowerPoint 2007:
This section explains how you can view slides in PowerPoint.

Added Attractions In PowerPoint 2007:
 - Text Boxes
 - Images and Clip Art

Changing the Slide Master In PowerPoint:
How to change the slide master, which controls the text color, alignment and font face, bullet choices, background colors and graphics.

Adding Animation In PowerPoint:
Selecting the elements on your slide that you want to animate, and then choose an effect, or make a custom animation.

Printing Your Presentation:
Details on printing your slides, including ‘Print range’ and ‘Print what’.


PowerPoint 2007 Intermediate Tutorial
- Creating Design Templates with the Slide Master
The focus then shifts to this tutorial for intermediate users of PowerPoint 2007 providing instructions to make changes across all slides (making global changes) that include background, colors, fonts and layout modifications. Users can create and save their own theme to be used at a later stage or for another presentation and a small section explains this in detail.

Introduction to the Slide Master:
This sections shows how we can make the layouts more precise.

Accessing the Slide Master:
Learn more about the Slide Master and Layout Slides and what the difference is between these.

Making Global Changes:
 - Changing the Background Color/Graphic
 - Changing the Fonts
 - Adding an Image
 - Choosing a Color Theme

Making Changes to Layouts:
 - Layout Slide Text
 - Adding Placeholders

Saving Your Theme:
How to save your .thmx presentation theme file.

Saving Your Theme:
 - Exiting the Slide Master
 - Adding Slides to Your Presentation

Popularity: 32% [?]

This is a Fireworks Tutorial, from Brown University, for those just learning how to use this application. Adobe Fireworks, originally developed by Macromedia and currently by Adobe, is a vector graphics editing application. It can be easily integrated with Dreamweaver and Flash. This Fireworks tutorial covers how to create simple graphics that include a logo banner. Images can be optimized for use on the Internet and in other applications, and a section here demonstrates image optimization. Also explained is GIF animation in Fireworks. This Fireworks tutorial is short and simple and each section provides an example to complement it.


Features Taught by this Fireworks Tutorial:

Creating a Logo Banner In Fireworks:
This section explains how to create a logo banner with example.

Fireworks Photo Image Optimization:
This example is to create simple photo image button.

Creating An Animated GIF Using Fireworks:
This example shows how to create an animated GIF banner using Fireworks.

Popularity: 25% [?]

Here is a pretty good PHP Cheat Sheet at addedbytes.com. This PHP Cheat Sheet is a quick guide and reference to the functions used in PHP for file manipulation, regular expression handling and last but not the least, date handling and formatting. (pdf format)


Function List:

Lists PHP’s array functions, string functions, file system functions, regular expression functions and datetime functions. These functions are essential for every PHP developer for quick reference and usage.


fopen() Modes:

The fopen() modes are used for file manipulation. This section details out the different modes to create, read and write files and what modes these files should be opened with. File handling modes are of paramount importance while handling scripts in PHP.


Regular Expression Syntax:

Regular expressions are commonly used in most programming and scripting languages. The first step to learning them is to understand the regular expression syntax and their meaning in PHP. This section of the pdf is a quick reference to regular expressions.


PCRE Modifiers:

While on the topic of Regular Expressions, it is important to note that PHP uses Perl Compatible Regular Expressions, or PRCE functions to split and replace expressions. This section helps explain PRCE better, giving an insight into its intricacies.


Date Formatting:

All programming and scripting languages deal with date formatting at some point or the other. This section deals with a whole range of date formatting options in PHP.

Popularity: 31% [?]

Here are 12 Flash Tutorials, from alistapart.com, that cover Flash basics, inserting rich media and the aesthetics of designing in Flash. These Flash tutorials also demonstrate gaming and game creation in Flash using ActionScript, Layers and Positioning. Flash has set about various trends in design and layout and this aspect is explored in depth here. A small section on Flash MX is provided which details authoring in Flash MX and Flash 6. These Flash tutorials also explain platform and browser limitations with regards to Flash, and areas of improvement such as Tab Order, Document Structure, Voicing Strategy and ‘Skip to Content’ links.


12 Flash Tutorials:

 - Semantic Flash: Slippery When Wet
 - Flash Embedding Cage Match
 - Bye Bye Embed
 - Flash Satay: Embedding Flash While Supporting Standards
 - Flash MX: Moving Toward Accessible Rich Media
 - Flash MX: Clarifying the Concept
 - The Flash Aesthetic
 - Game Design in Flash 5, Part II: Heroes & Villains
 - Flash’s Got a Brand New Bag
 - The Declination of Independence
 - Flash Access: Unclear on the Concept
 - Sympathy for the Plug-in

Popularity: 26% [?]

Here are 25 Excel Tutorials at bukisa.com that cover diverse and complex topics such as sorting, importing and exporting data to and from Excel. The below Excel Tutorials explain table formatting, applying conditional formulas, automatically totalling values in cells, and exchanging data between Word and Excel. These Excel tutorials also provide several quick tips that are sure to come in handy; and a small segment on working with Excel in Mac OS X.


25 Excel Tutorials:

 - How to Add Export to Microsoft Excel to the Right Click Menu in IE.
 - How to Export HTML Table to Excel
 -  How To Create an Excel Spreadsheet to Manage Your Articles (or Anything)
 - Sorting Data in an Excel Spreadsheet Column
 - How to Add Microsoft Excel Toolbar Buttons – Insert and Delete Rows and Columns
 - Microsoft Excel Quick Tip – Merging Cells on a Spreadsheet
 - Creating a Microsoft Excel 2008 Automator Workflow in Mac OS X
 - How to Use Excel - “Automatically Total Amounts” – Easy Excel Series – EE2
 - How to keep a Food Diary in Microsoft Excel
 - How to Combine MS Word and MS Excel Spreadsheets into One Document
 - Learn Excel from MrExcel Episode 921 – Workbook Sheets
 - MrExcel’s Learn Excel #911 – WIIW – Equals
 - MrExcel’s Learn Excel #914 – Selection Color
 - MrExcel’s Learn Excel #923 – Icon Set Alignment
 - MrExcel’s Learn Excel #915 – Partially Bold
 - Learn Excel from MrExcel Episode 920 – 2003 Dialogs
 - How to compare and match two files using Excel VLOOKUP?
 - MrExcel’s Learn Excel #952 – Mouse to End
 - MrExcel’s Learn Excel #953 – Ctrl+N Compatibility Mode
 - MrExcel’s Learn Excel #944 – Excel to Word
 - MrExcel’s Learn Excel #933 WIIW – Conditional Formula
 - MrExcel’s Learn Excel #934 – Table Formatting
 - Learn Excel from MrExcel Episode 917 – Chart Background
 - MrExcel’s Learn Excel #927 – Pivot Compare            
 - Import Contacts from Excel to Outlook

Popularity: 34% [?]