Here are 4 Microsoft PowerPoint 2003 Tutorials from the University at Albany that teach and describe some of PowerPoint’s basic and advanced features, which include Views, Outlines, Templates, Special Effects and custom slides. These PowerPoint tutorials will enhance and make your presentation more effective. (Tutorials are in .doc format.)


4 PowerPoint 2003 Tutorials:

PowerPoint 2003 I: Views, Outlines, and Basic Templates
This tutorial explains PowerPoint features such as views, outline and presentation templates an how to effectively use them.

PowerPoint 2003 II: Special Effects, Timing and Interactivity
This tutorial teaches special transitions and effects such as fade out, motion and user interaction. Also discussed are hyperlinks and how they are used in your slides.

PowerPoint 2003 III: Objects, Sounds, Videos and Files
This tutorial explains how into insert sound, video and pictures into your slide presentations to make them more interactive.

PowerPoint 2003 IV: Creating Custom Slides and Templates
This PowerPoint tutorial demonstrates how to create custom designs and templates, insert animations and pictures, insert menus and bullets, and edit fonts in your presentations.

Popularity: 29% [?]

Here are 11 Adobe Photoshop Tutorials at nicetutz.blogspot.com discuss and demonstrate various Photoshop tips and effects that can be quickly created. The effects include fireworks effects, water drops effects, creating metallic fonts and working with retro patterns. These Photoshop Tutorials provide photo and color retouching tips, and pointers on working with layers and tools, and also offer some Photoshop tricks, as well as a list of shortcut keys that will come in handy for any Photoshop user.


11 Photoshop Tutorials:

 - Photo to illustration Vector Effect
 - Fireworks Effects
 - Real Water Drops Effect
 - Retro Pattern
 - Exploding Text Effect
 - Metallic Type Text Effect
 - Adobe Photoshop Tool Tips
 - Adobe Photoshop Layer Tips
 - Dreamy Photo Effect
 - Eyes Color Retouching
 - Adobe Photoshop Shortcuts Keys

Popularity: 27% [?]

These 7 Microsoft Outlook Tutorials from the University at Albany explain various features of Outlook 2003 including its email features, the Calendar, how to effectively manage tasks, scheduling meetings and conferences, working with contacts in the Address Book and how to use Outlook remotely. (tutorials are in .doc format)


7 Outlook 2003 Tutorials:

Outlook 2003 I: Outlook Email Features
This tutorial teaches the email features of Outlook such as managing folders, using the Out Of Office assistant, attaching files to emails and basic mail filtering.

Outlook 2003 II: Calendar Management
This tutorial explains the calendar in Outlook and its features such as creating new appointments, viewing the calendar, adding contacts and the calendar folder rights.

Outlook 2003 III: Task Management
This section teaches the importance of the Task list available in Outlook. Various tasks can be planned and created for a Day, Month or Year and users can efficiently manage and track these tasks to completion.

Archiving and Advanced Folder Management
This Outlook tutorial explains the concept of effective folder management, filtering rules, and archiving old items to a readily accessible location.

OutLook VI: Sheduling Meetings using the new Global Address Book listings for Conference and Training Rooms
This Outlook tutorial covers general aspects of scheduling meetings and conferences using the Address book.

OutLook VII: Importing an Excel Name and Address List into Outlook Contacts
This tutorial teaches how to export and import names and email addresses from and into Outlook contacts.

Outlook Remote Internet Access
This tutorial explains how to access emails in Outlook from anywhere in the world using Microsoft Exchange.

Popularity: 29% [?]

Here are 6 Microsoft Access 2003 Tutorials from the University at Albany. These Access tutorials teach a range of concepts and techniques that are essential for anyone working with and managing Access databases. They cover topics from the basics to the advanced level, which include table design, its capabilities, data entry forms, report design and using the select query. These Access database tutorials cover the essential workflow for any user to get started and be comfortable with Microsoft Access.


6 Access 2003 Tutorials:

Access 2003 Introduction I: Introduction & Concepts – 2 1/2 hrs
This tutorial teaches basic database concepts and how they can be used. The topics covered in this tutorial include the definition of a Relational Database and the database components.

Access 2003 Introduction II: Basic Table Design and Capabilities – 2 1/2 hrs
This tutorial explains how to build a simple database and places the focus on creation of tables, data types and primary keys for the tables.

Access 2003 Introduction III: Introduction to Data Entry Forms – 2 1/2 hrs
In this tutorial, you’ll learn about designing tables with attention to usability and organization of data such that it is easier to match the form to the table and organize the fields.

Access 2003 Introduction IV: Introduction to Select Queries – 2 1/2 hrs
This tutorial shows how to retrieve data from a database, including sorting fields, single and multiple search criteria.

Access 2003 Introduction V: Introduction to Report Design – 2 1/2 hrs
This tutorial demonstrates how to generate a report from the database using the retrieval queries.

Access 2003 Intermediate I: Importing and Exporting Data and Action Queries - 2 1/2 hrs
This tutorial teaches how to import and manipulate data that is from a database other than Access. In this example, data has been imported form an Excel sheet

Popularity: 31% [?]

Here are 50 Ways to Become a Better Designer at computerarts.co.uk. These tips and techniques explain aspects and practices of good design and how one can become a better designer and Photoshop user. They explain key points that a designer should be aware of while creating his design, such as colors, fonts, shading, gradients and channels. The tools used to create designs and some of its options are also discussed in detail. A few tips and tricks of good designers are also given, which discuss shortcuts and quick steps to use in design creation to simplify the work of the designer. This compilation is from 17 leading designers who work in print, video and on the web.


50 Ways to Become a Better Designer:

 - 01 ROUGH COMPS
 - 02 METAPHORS
 - 03 FROM WORDS TOPICTURES
 - 04 BRAND THINKING
 - 05 KEEP YOURBRAINSTORMS REALLY SHORT
 - 06 USE A SKETCHBOOK
 - 07 GET AWAY FROM YOURCOMPUTER
 - 08 JOIN A FORUM
 - 09 TAKE A SHOWER
 - 10 SPECS!
 - 11 KEEP A LIBRARY
 - 12 WEB STANDARDS
 - 13 KEEP IT CURRENT
 - 14 KEEP IT SIMPLE
 - 15 RECORD YOURACTIONS
 - 16 SAVE, SAVE, SAVE!
 - 17 STORE YOUR ASSETS
 - 18 COLLABORATE
 - 19 GET IT RIGHT FIRSTTIME
 - 20 PRACTICE ALWAYSMAKES PERFECT
 - 21 ALPHA CHANNELS INPHOTOSHOP
 - 22 BUY MORE RAM
 - 23 GRADIENTS INPHOTOSHOP
 - 24 MORE LAYERS
 - 25 AIRBRUSH INILLUSTRATOR
 - 26 EVIL FLASH
 - 27 NAME CONVENTIONS
 - 28 GROUP LAYERS
 - 29 FORBIDDEN FRUIT
 - 30 THINK ON PAPER
 - 31 WALK AWAY
 - 32 ACROBATICS
 - 33 KERN!
 - 34 BACK TO THE BRIEF
 - 35 ENOUGH IS ENOUGH
 - 36 PRINT FINISHES
 - 37 ADDING TEXTURE
 - 38 BE PREPARED
 - 39 A LITTLE SHADING
 - 40 BULGING EYES
 - 41 READ AND RE-READ!
 - 42 BE SPECIFIC
 - 43 DON’TRELY ON THE SPELLCHECKER!
 - 44 STICK TO THEBRIEF!
 - 45 WORK WITH CLIENTS
 - 46 STICK TO WHAT YOUKNOW
 - 47 DON’T ASSUMEANYTHING
 - 48 JUSTIFY YOURACTIONS
 - 49 DESIGN HISTORY
 - 50 MANAGEEXPECTATIONS

Popularity: 31% [?]

These 5 excellent Dreamweaver Web Design Tutorials from the University at Albany address the procedures and tools used in creating and maintaining web pages and web sites. These Web Design tutorials also include specific topics to help staff maintain web pages under the University of Albany Web Standards. (these tutorials are in .doc format)


5 Dreamweaver Tutorials:

Introduction to Ualbany Web Design and Site Structure
This tutorial teaches how to plan and organize departmental website structure at UAlbany. We will discuss the term ‘Information Architecture’ and how to think about it when planning your departmental web pages. This tutorial will be taught using Adobe Dreamweaver CS4. Topics covered include discussion of concepts and purpose, discussion of Information Architecture, review and explanation of the worksheet.

Creating and Maintaining your Departmental Web Page using ‘New Look’ UAlbany Templates
This tutorial is offered in Adobe Dreamweaver CS4 and strongly recommend that you use this application when updating your site. This tutorial teaches the procedures, logistics and, especially the reasons for creating and maintaining pages that are compliant with the UAlbany look, including layout, colors and styles.

Working with ‘Includes’ and other structures provided in Web Templates
This tutorial continues the topics started in tutorial I02, with special emphasis on the ‘includes’ attached to the UAlbany Web Templates. The topics covered under this tutorial are what are ‘Includes’, ‘Includes’ on the properties inspector in Dreamweaver, editing ‘Includes’ and other style issues.

Dreamweaver MX2004 I: Introduction to Concepts
This tutorial covers a group of recommendations and suggestions that will help you to more logically execute the new updates to your UAlbany Departmental website. The topics covered in this tutorial are best practices and things to remember.

Dreamweaver MX2004 II: Basic Page Design
This tutorial explains how to use Dreamweaver MX 2004 to build a web page. Participants will become familiar with the various Dreamweaver components, such as the Properties Inspector, Insert Bar tabs, and the Code and Design views. Participants will also learn how to use Dreamweaver to make tables for page layout and control. This tutorial is also covering on how to install and manage images on a web page.

Popularity: 30% [?]

These 5 Microsoft Excel 2003 Tutorials from the University at Albany explain the power of Excel by discussing its important features such as data manipulation, formulas and efficiency, formatting, page setup and print options. These features, along with filtering, sorting and presentation have made Excel the de-facto spread sheet application to work with. (these tutorials are in .doc format)


5 Excel Tutorials:

Excel 2003 I : Introduction, Menus, Toolbars & Selections
This tutorial teaches Excel’s menus, toolbars and selections along with rows, columns, cells, and formulas.

Excel 2003 II : Data, Formulas & Efficiency
This Excel tutorial explains spreadsheet components, their purposes and properties which include formulas, functions, problem solving and workbooks.

Excel 2003 III : Multi Sheet Workbook Creation
This Excel tutorial describes workbook creation, design, maintenance and usability. Workbooks are primarily used as an analysis tool to decide performance, growth, sales etc.

Excel 2003 IV : Design and Formatting
This tutorial teaches the design and formatting of the spreadsheet which includes colors, borders, shading, alignment and fonts.

Excel 2003 V : Page Set Up, Print Area, Options & Security, Filtering and Sorting, and Presentation Charts
This Excel tutorial demonstrates printing options, the page layout, filtering and sorting of the spreadsheet data.

Popularity: 28% [?]

Here are 6 Word 2003 Tutorials from the University at Albany that teach and explain several of Word’s important capabilities, including Menus, Formatting tools, Layout tools, Illustrations, Tables and the Mail merge feature. These features come in handy when working with data that needs to be segregated and formatted for presentation.


6 Word Tutorials:

Word 2003 I: Menus, Capabilities and Basic Skills
This Word tutorial explains the menu options available in Word and the dialog boxes they handle which include Open and Save.

Word 2003 II: Toolbars and Formatting Tools and Techniques
This tutorial demonstrates Word’s toolbars and formatting tools such as tabs, margins, paragraphs, colors and alignment of text on a page.

Word 2003 III: More Formatting Tools & Techniques
This Word tutorial continues from where the previous one left off covering formatting tools and techniques.

Word 2003 V: Illustration & Layout Tools
This tutorial explains various Illustration and Layout tools in Word such as Clipart, Images, Word Art, Shadows and Textboxes.

Word 2003 VII: Tables in Word
This tutorial teaches Word’s capabilities in creating Tables and adding spreadsheets to the document

Word 2003 X: Mail Merge and Labels
This Word tutorial explains the Mail Merge feature that is used to generate multiple documents from a single template and using Labels to add names and other data from a database.

Popularity: 23% [?]

These 9 Access 2007 Tutorials at Microsoft Office Online demonstrate the various features of Access 2007. Access is Microsoft’s traditional database tool and is widely used to interface with and create many database applications. These tutorials are in the form of webcasts, video tips and podcasts with each of them explaining report creation and sorting and filtering features in Access. The video tips show how to carry out simple tasks in Access such as using SharePoint, quick tips and data collection.


Webcast:
Tracking Your Information Is Easier Than You Think with Access 2007
This webcast is recorded directly from Microsoft Office experts and explains how to start out from scratch in Access 2007.


Video tips:
These video tips have experts discuss a host of Access features and are shot directly from the presenter’s desk.

 -  Easily Design Custom Reports in Access  256k | 750k
 -  Easily Sort and Filter Complex Tables with Access 2007 256k | 750k
 -  E-mail Data Collection with Outlook 2007 and Access 2007 256k | 750k
 -  Getting to Know Access 2007 256k | 750k
 -  Quick Tips for Access 2007 256k | 750k
 -  Save a File as a PDF or XPS in Access 2007 256k | 750k
 -  Using SharePoint Server 2007 with Access 2007 256k | 750k


Podcast:
Tracking Your Information Is Easier Than You Think with Access 2007
This podcast contains the audio of the earlier presented webcast and is also available for download.

Popularity: 28% [?]

These 5 excellent Photoshop Tutorials from the University of Albany offer an in depth coverage of Photoshop and scanning. Most images are created by a professional designer or scanned and then modified to create a new image. In both cases, an image editing tool like Photoshop is used to modify or create the image. These Photoshop Tutorials start with the basics such as scanning an image into Photoshop and moves onto more complex actions such as Layer Management and Compositing.


5 Adobe Photoshop Tutorials:

Photoshop I: Scanning with a Flatbed Scanner into Photoshop
This Photoshop tutorial explains how to setup a scanning device and connect it to software for scanning. It also discusses various issues a first time user might have such as resolution, dimensions and output issues.

Photoshop II: Introduction and Basic Image Editing
This Photoshop tutorial teaches the basics of image editing such as image color, brightness and contrast and color balance. It also provides an overview of Photoshop’s features.

Photoshop III: Selecting, Drawing and Painting Tools
This tutorial explains a few of Photoshop’s tools such as the Selecting, Drawing and Painting tools and how they can be effectively used on an image.

Photoshop IV: Layer Management & Photo Compositing
In this tutorial, Photoshop’s photo compositing features and layering systems are discussed. Also covered are background and transparency issues and layer adjustments.

Photoshop V: Filters and Special Effects
This Photoshop tutorial teaches the filters and special effects that can be added to certain areas on an image. Many of these filters are already present in Photoshop while many more can be downloaded and used.

Popularity: 24% [?]