Free Microsoft Office Training and Tutorial Resources


February 28, 2007

Basics and Intermediate PowerPoint Tutorials

Here are two PowerPoint Tutorials for PowerPoint Basics on Creating a Slide Presentation, one each for the 2002 (XP) and 2000 versions. Also included here is an Intermediate PowerPoint Tutorial giving you several tips and tricks you can use to make PowerPoint work better and smoother for you. These are provided by California State University, Northridge.

PowerPoint 2002 Basics

This tutorial teaches the steps for making a nice looking slide presentation using PowerPoint XP. Features covered in this tutorial and the one below for Powerpoint 2000 include the following: Startup Choices, The PowerPoint Window, Creating Slides, Layout Choices, Positioning and Resizing a Text Box or Image, Bulleted Items, Adding Clip Art, Charts and Graphs, Tables, Organization Charts, Normal View, Slide Sorter View, Slide Show View, Changing the Look and Feel of Your Presentation, Building Transitions and Effects on Your Slides, Effects, and Using Master Pages to Make Global Changes.

  1. Some PowerPoint Definitions
  2. Opening PowerPoint
  3. Creating Slides – New Layouts
  4. The Many Views of Your PowerPoint Presentation
  5. Changing the Look and Feel of Your PowerPoint Presentation
  6. Building Transitions and Effects on Your Slides
  7. Using Master Pages to Make Global Changes
  8. How to Learn More: PowerPoint’s Help Options

PowerPoint 2000 Basics

This tutorial teaches the steps for making a nice looking slide presentation using PowerPoint 2000.
  1. Some PowerPoint Definitions
  2. Opening PowerPoint
  3. Creating Slides – New Layouts
  4. The Many Views of Your PowerPoint Presentation
  5. Changing the Look and Feel of Your PowerPoint Presentation
  6. Building Transitions and Effects on Your Slides
  7. Making Global Changes to Your PowerPoint Presentation Using the Master Pages Feature
  8. How to Learn More

PowerPoint 2003 - Intermediate Guide – Tips and Tricks
(12 pages, 270kb, pdf format)

The following PowerPoint features and functionality are taught and demonstrated by this tutorials: Recoloring Clip Art, Cropping Clip Art and Images, Ungrouping Clip Art, the Picture Toolbar, Custom Backgrounds, Color Schemes, Modifying a Design Template, Customizing Design Templates, Saving a Template, Applying Animation and Additional Effects, Adding Interactivity, Inserting a Movie or Sound, Putting Your Presentation on the Web. 

Table of Contents:
  1. Course Description
  2. Recoloring Clip Art
  3. Cropping Clip Art and Images
  4. Ungrouping Clip Art
  5. Using the Picture Toolbar
  6. Creating a Custom Background
  7. Change Color Scheme
  8. Modifying a Presentation Design Template
  9. Create a Customized Presentation Design Template
  10. To Save a Template for Future Use
  11. Applying Animation Effects  Additional effects
  12. Adding Interactivity
  13. Insert a Movie and/or Sound Clip
  14. Insert WordArt
  15. Putting Your PowerPoint 2003 Presentation on the Web

PowerPoint 97 Basics

Tags for this post>>
February 26, 2007

Beginners Word Training and Mail Merge

Here are three well written Word Training Guides hosted by California State University, Northridge. Two of these training tutorials are for those getting started with Word and one is a tutorial on Mail Merge Using Word and Excel. Basic Word features demonstrated by these training guides are: Creating a Document, Basic Editing, Correcting Errors, Restoring a Deletion, Adding and Moving Text, Correcting Spelling and Grammatical Errors, Saving a Document, Printing a Document, Text Formatting, Paragraph Formatting, Document Formatting, Page Setup, Headers and Footers, Automatic Page Numbering, and File Management.

Beginner’s Guide to Word 2002

  1. Getting Started
  2. Bare Bones Basics
  3. Text Formatting Features
  4. Paragraph Formatting Features
  5. Document Formatting Features
  6. File Management
  7. How to Learn More
  8. Appendix A: Glossary
  9. Appendix B: Features Table

Beginner’s Guide to Word 2000

This training guide presents an introduction to selected features in the word processing program Word 2000. Please note that the document is not intended to cover all ways in which the basic features can be used or accessed.

  1. Getting Started
  2. Bare Bones Basics
  3. Formatting Features
  4. File Management
  5. How to Learn More
  6. Appendix A: Glossary
  7. Appendix B: Word 2000 Features Table  

Mail Merge Using Word and Excel

Using Word’s Mail Merge function gives you the ability to generate personalized documents by merging together a main document and a data source.

There are three steps to any mail merge project:
    Step 1: Create a data source document in Excel with the information, such as name and addresses, that will vary with each letter or label.
    Step 2: Create a main document in Word, such as a form letter, mailing labels, envelopes, etc.
    Step 3: Merge the main document from step 2 with the data source from step 1.
Mail Merge Table of Contents

  1 Creating and Sorting a Data Source Document   2 Generating Individually Addressed Form Letters   3 Generating Mailing Labels   4 Generating Individually Addressed Envelopes   5 Generating a List (or Catalog)   6 How to Merge and Print Selected Records

  7 How to Learn More

Tags for this post>>

Access Training Guides

Here are three excellent Access Training Guides provided by California State University, Northridge. These Access training tutorials cover the fundamentals for both Access 2000 and 2003, and intermediate and advanced topics for Access 2003. Areas of functionality and features taught by these training guides are as follows: Getting Started, Starting Access 2003, Creating a New Database, Naming Conventions, The Leszynski Naming Convention, Object Naming Conventions, Designing a Table in Design View, Starting a New Table, Data Types, Defining Data Fields, Entering Data in Datasheet View, Creating a Query, Designing an Input Form, Producing a Report, Relationships, Using Operators in Queries, Designing Advanced Queries, and Creating Action Queries.

The Microsoft Access database model consists of data, fields, records, and tables of records, with each table being a flat file database. However this is not all — in addition, in Access, the user can create and run queries, and produce reports from the the fields, records, and tables. This functionality, along with the ability to work with many tables having common elements, makes Access a database management system (DBMS) and a basic relational database.

Access 2003 - Basics & Beyond
(21 pages, 484kb, pdf format)


  • Introduction
    • What is a database?
    • The Access Database Management System
  • Getting Started
    • Starting Access 2003
    • Creating a New Database
  • Naming Conventions
    • The Leszynski Naming Convention
    • Object Naming Conventions
  • Designing a Table in Design View
    • Starting a New Table
    • Data Types
    • Defining Data Fields
  • Entering Data in Datasheet View
  • Creating a Query
  • Designing an Input Form
  • Producing a Report
  • How To Learn More
    • Access Help Options
    • Printed Material
  • Closing a Database and Exiting Access

Access 2003 Intermediate Training Guide
(19 pages, 262kb, pdf format)

  • Relationships
    • Using Related Tables
    • Creating a Relationship
    • Setting Referential Integrity
  • Using Operators in Queries
    • Using Comparison Operators
    • Using an AND Condition
    • Using an OR Condition
    • Using the BETWEEN AND Operator
    • Using the Expression Builder
    • Using a Wildcard Character
  • Designing Advanced Queries
    • Setting Top Values in a Query
    • Creating a Calculated Field
    • Formatting a Calculated Field
    • Creating a Function Query
    • Creating a Parameter Query
    • Creating a Concatenation in a Query
    • Filtering a Query
  • Creating Action Queries
    • Creating a Make Table Query
    • Creating an Update Query
    • Creating an Append Query
    • Creating a Delete Query

Beginner’s Guide to Access 2000

This training guide is intended to acquaint you with the fundamentals of Microsoft Access 2000. At the completion of this series of documents, you will have a basic understanding of database functions and capabilities, and the tools necessary to begin your own exploration and experimentation with Access 2000.

  1. Introduction   2. Getting Started   3. Naming Conventions   4. Designing a Table in Design View   5. Entering Data in Datasheet View 

  6. Creating a Query 

  7. Designing an Input Form 

  8. Producing a Report 

  9. How to Learn More   10. Closing a Database and Exiting Access

Tags for this post>> |

HTML and Web Design Training Guides

California State University Northridge is offering the following HTML and Web Design Training Guides on their self-study training web site. These will help you get started with creating web pages, learning how to code HTML, and also help you think about your web site design strategy, guiding you on style, purpose, and organization.

HTML: Beginner’s Guide

This document provides basic instructions for coding in Hypertext Markup Language (HTML) to create a Web page (an HTML file) on your desktop computer.


Creating an HTML File
Saving & Viewing Your HTML File
Updating (Revising) a Web Page
Style Suggestions
How to Learn More About HTML
Appendix: Sample HTML-Coded Documents

Design and Accessibility

Designing an Effective Web Page

A Web page is a place people visit to obtain information. Web pages can be informational (such as those maintained by CSUN organizations such as University departments) or personal  (as in the case of individuals who wish to communicate something about their own backgrounds and interests). For a business Web page, there may be an interest in marketing products or services. 

When you design a Web page, think about such things as purpose, organization, and style, as well as copyright laws and plagiarism. Making your pages readable to all who view them is also important (see next section).

How to Make Your Web Pages ADA Compliant

Some Accessibility Suggestions

Following are some general suggestions for helping to make your pages readable to all who view them. 

Hearing Access
Visual Access
Mobility Access
Cognitive Access
The Text-Only Alternative
Other Sources

Tags for this post>> |

Dreamweaver Training Guides

California State University at Northridge provides these Dreamweaver Training Guides containing excellent training tutorials for learning how to use many features of Dreamweaver. Topics taught by these training guides include the following: Defining a New Website, The Dreamweaver Work Area, Creating a Basic Web Page, Page Properties, Text, Links, Inserting Common and “Head” Objects, Preparation for Publishing, Using HTML Styles to Format Text, Using Tables in Web Page Design, and Using Templates for Consistent Design.

Dreamweaver MX Basics

The instructions in this document assume the reader has already created web pages using some other web page creation software (e.g., Netscape Composer or Microsoft FrontPage). Some knowledge of HTML coding is also recommended.

Intermediate-Level Dreamweaver Topics:

Using HTML Styles to Format Text

An HTML style is similar to a Word (or other word processing) style in that it can be defined to specify one or more text-formatting features that can be applied to a paragraph or selected text. As with a Word style, you can apply an HTML style over and over. Unlike a Word style, an HTML style only affects specified text at the time you apply the style. This means that if you later change an HTML style, any text to which the style has been applied will not be affected by the change. This characteristic is more like Word’s Format Painter, which applies text formatting only at the time of application.

Using Tables in Web Page Design

One way to give vertical and horizontal structure to a page is to format a web page using tables.

Using Templates for Consistent Design

Dreamweaver provides two types of assets that can help you create Web pages with a consistent content and design — templates and libraries. This document describes the basics of creating and using an HTML template to an generate an identical layout for a set of pages. See also Using Libraries to Reuse or Update Page Elements.

Using Libraries to Reuse or Update Page Content

Dreamweaver provides two types of assets that can help you create Web pages with a consistent content and design — templates and libraries. Use libraries to store items you’d like to use on multiple pages that do not have an identical layout — when you’d like to reuse headers and footers, for example, with different layouts in between. You might also create a library item for content that appears on only a few pages but must be updated frequently. If you want to create multiple pages that have an identical layout, see Using Templates for Consistent Design.

Tags for this post>>
February 22, 2007

24 Microsoft Access Tutorials from Towson University

Here are 24 Microsoft Access Tutorials offered by Towson University. These Access tutorials demonstrate and convey how to perform many basic and advanced Access features and functions, including the following: Creating new databases, Data Entry, Forms, Tables, Relationships, Exporting and Importing Data, Sorting and Filtering Tables, Queries, Reports, Labels, and Lookup Lists. These Access tutorials will help you learn these topics and add to your Access knowledge and skillset. All documents are in pdf format, except the first 3 tutorials, which are videos with sound. 

Access 2003 Video Tutorial: Relationships
Take a tutorial on what relationships are and how to set them up in Access. – with sound

Access 2003 Video Tutorial: Tables
Take a tutorial on the basics of Access tables. - with sound

Access 2003 Video Tutorial: Forms
Take a tutorial on creating forms in Access. - with sound

Access 2003: Basic Workshop Learn how to create a complete new basic database following this step-by-step guide.

Access 2003: Understanding Databases This is a short reference to the basic functions of Access software and understanding the parts of a database.

Access 2003: Creating a New Database Learn how to create a new database using the built in templates. Also, start a blank database and learn how to use table wizards to help build your database.

Access 2003: Data Entry and Forms Learn how to build forms in Access to enter your data into tables without having to go into the Design View.

Access 2003: Exporting and Linking Data Learn how to export your data from Access to Excel, XML or HTML formats.  Also, learn how to link to other data outside of your database.

Access 2003: Importing Data Learn how to import data from Excel, other text files or another Access database.

Access 2003: Sorting and Filtering Tables Learn how to sort and filter the data within your Access tables.

Access 2003: Queries Learn how to run queries and use criteria to help you pull data from your database.

Access 2003: Reports Learn how to make professional looking reports using the Access Reports wizard and modify the results with basic and advanced techniques

Access 2003: Inserting Graphics Learn how to insert a graphic or an object to your tables and forms.

Access 2003: Advanced Tables Design View Learn advanced table features using Design View in Access 2003.

Access 2003: Advanced Forms: Sub-Forms Learn how to use sub-forms in Access 2003.

Access 2003: Advanced Queries: Design View Learn how to use Design View to run advanced queries in Access 2003.

Access 2003: Advanced Reports: Calculations Learn how to make calculations in reports in Access 2003.

Access 97: Converting to Access 2003
This document offers some tips on converting Access 97 databases to Access 2003.

Access: Getting Data from PeopleSoft 
Learn how to connect to PeopleSoft Data through an ODBC to make tables that you can manipulate in Access.

Access 2003: Understanding Relationships
This document offers some tips on understanding and creating relationships in Access 2003.

Access 2003: Creating Labels 
Learn how to create labels by using the information in your Access database.

Access 2003: Creating Switchboards
Learn how to create a switchboard so that when editors open the database they go right to the form screen.

Access 2003: Understanding Tables 
Tables are a key feature in Access, this document will help you better understand them.

Access 2003: Creating a Lookup List
Learn how to create a Lookup List to populate field data and to ensure consistency.

Tags for this post>>

February 21, 2007

10-page Flash Guide

This is a 10-page Guide on “Exploring Macromedia Flash MX” (796kb, pdf format), from Kansas State University. It explains what Flash does, how to start using it, and introduces many important features of Flash.

Flash is a software application that is used to create and display attractive multimedia and web animations and presentations. Programmers use Flash to develop nice looking and compact navigational interfaces, technical graphics, animations, and other compelling user experiences. Illustrations and animations in Flash are made with Flash’s drawing tools, or Flash developers  can import images from their favorite vector and/or bitmap graphics software. Flash has lots of great features, and for those in academics, it is priced quite well at around $100, making it a very accessible multimedia application.

Exploring Macromedia Flash MX

This Flash guide provides instruction and how-to steps for the following functionality:

  • Flash Work Environment
  • The Stage and the Timeline Window
  • The Library Window
  • Symbols and Instances
  • Using the Toolbox
  • Using Scenes
  • Using the Movie Explorer
  • Creating a Basic Animation - Shape Tween and Motion Guides
  • Creating the Shape Tween
  • Prep the Shape Tween before attaching the Motion Guide
  • Create the Motion Guide
  • Creating a very basic Multiple Choice Quiz

Tags for this post>>

Web Tips and Techniques

This is a site named, Dan’s Web Tips, which provides some useful information that Dan has learned and discovered over the years. These web development tips and techniques will hopefully assist you in creating a more compelling and functional website for your visitors. Dan says that many of these are not referred to on other learning sites or in books on web design and development. These web tips are targeted to those who are seeking some assistance with making their web sites better while staying away from potential problems.

  • “How do I force…”
    you may have ask this type of questions, but the answer probably isn’t what you want to hear.
  • Validators
    how to find out if your web pages contain valid HTML code
  • Brand X Browsers
    you need to account for other browsers besides Internet Explorer
  • Graceful Degradation
    how to keep your web site accessible while at the same time using some advanced techniques
  • Nesting
    learn the structure of the elements of an HTML web page
  • Cascading Stylesheets (CSS)
    using CSSs are now the recommended method to code web pages, as doing so separates structure from presentation
  • Colors
    learn about colors and how to use them
  • Images
    understand how to insert images and graphics to your web pages
  • Sounds
    add sound, such as music, to your web site
  • Tables
    here are suggestions for using tables in your HTML.
  • Frames
    prompts you to think if you really need these in your site
  • HTML Comments
    learn how to correctly place comments into your HTML code
  • URL
    find out what relative and absolute addresses are, and the best way to use each
  • Domain Names
    a few words about domain names and what they are
  • E-Mail
    let you web users provide feedback via email
  • Server vs. Client
    learn what components of the Web are managed by server and which by client

Tags for this post>>

160 Excel VBA Tutorials

This is a comprehensive linked list of 160 Excel Tutorials and How Tos teaching how to use Macros and code using VBA in Excel. VBA is an abbreviation for Visual Basic for Applications, its the Microsoft Office scripting language used to customize the applications. These learning materials include instructions for performing the demonstrated tasks and are hosted by three excellent Excel tutorial sites: MrExcelChip Pearson, and John Walkenbach, all together containing over 500 Excel Articles and Tutorials.

Excel VBA Tutorials with Instructions

Excel Macros
Excel VBA Macros
Add a Module with VBA
Add Row while copying and manipulating data
Add the Path to your Worksheet Footer when Printing
Add today’s entries to the next empty row on a master sheet
Adding and Deleting with VBA
Animation in Excel
Application Events
Application-Level Names (Hidden Name Space)
Arrays - CSEs – in Excel Visual Basic
Audio - Playing Sounds in Excel
Automate a tedious process with VBA Macros
Bypass Delete Confirmation
Change Name Box List width
Change macro to import text file in next available row instead of using A1
Change the worksheet tab name to reflect the value in cell A1
Changing a cell’s background color
Changing Tab Color
Color - Counting based on Interior or Font Color
Color - Counting by and Summing By Color
Color - Highlight Duplicate Entries
Color - Highlighting an Active Cell
Color - RGB Values
Convert Text to Lower Case
Converting Measurements To and From
Copy a Macro to Another Workbook Automatically
Copy Sheet, Preserving all Formatting
Copy the Previous row into the Next Blank Row
Counting cells by interior color using VBA
Create 78 Unique Sheet Names with Identical Data
Create a TOC (Table of Contents) for your workbook
Create a unique record number
Create a Word Document from a Row of Data
Create and name a new worksheet with VBA
Creating multiple lines of text in a messagebox
Creating Page Breaks in Excel-automaticaly
Custom Document Properties
Custom Functions
Custom Menus in the Visual Basic Editor(VBE)
Daily Import Automation with Unique Sheet IDs
Data Validation – Use a Defined Name to validate with data on another worksheet
Dates - Day of the Week with VBA
Dates - Find with VBA
Declaring a Variable in VBA
Declaring an Object
Default Properties of a Class
Delete a worksheet in a macro without having to see the “This worksheet will be permanently deleted”
Deleting VBA
Display Screensaver in Excel
Displaying AutoFilter criteria
Document Properties
Downloading Files using Excel
Duplicate Entries – Replace
Eliminate “/” from File Names when Saving with a Macro
Email a Worksheet From Within Excel
Emulate Lotus’ Print Suppression
Excel Crash on Mouse-over of object
Exit a worksheet with or without saving
Export VBA Code to a Text File
Exporting to Text
Fill Next Row with Previous Row’s Data
Find the last row of data in a range
First Monday of the Year
Formatting Time Values
FTP within Excel
Headers and Footers – with VBA
Headers and Footers in Excel
Hidden Name Space – Application-Level Names
Hiding a range depending upon user selections
Highlight Active Cell Location
Highlight Cells with Today’s Date
Highlight the active cell
How do I get rid of a Macro?
Importing - Text Files to Excel
Increment a Counter everytime a Userform is opened
Inputbox to accept specific data
Link back to original workbook
Maximized view on open
Mailing Labels in Excel with VBA Utility
Module-What is it?
No Blank Rows
No Duplicate Rows
OnTime Method
Open Other Applications from Excel
Opening Chm (or HTML Type Help) files
Optimize Your Code!
Phone Calls within Excel
Phone Numbers – Splitting(Parsing)
Play a MIDI File when Value Exceeds Set Limit
Printing - Cell Comments
Printing - Cell Formulas
Programming a messagebox for user responses
PROPER - Converting Text Case
Proper Text
Protecting specified data using VBA
Quicken and Excel: Streamline Categories on Copied Reports
Range - Bringing a Range Center Screen with VBA
Range - Referring to Cells in Another Range
Range - Reverse a Range with VBA
Range - Reverse Cell Order
Range - Select the Current Named Range
Ranges - VBA for Named Ranges
Record/Playback a WAV file in Excel
Record a Macro using Relative References (TechTV)
Recycle Bin
Removing a set number of characters from a cell
Removing hyperlinks from a worsheet
Removing text-string characters
Reset Application.ScreenUpdating for forward compatibility with Excel XP
RGB Colors
Run a Macro Automatically When the Workbook Opens
Run a Macro Following Cell Value Change
Run a Macro from a Command Button
Run a Macro from a Cell
Save - Save and Return to Selection
Save a Workbook with Cell A1′s Data
Scheduled Procedure – Using OnTime
Select Current Array
Selecting files within VBA
Selection Change to Highlight Current Row and Column
Setting a font name with VBA
Sorting - Worksheets
Stopping an Endless Loop
Testing Anti Virus Applications using Excel
Text - Converting to Upper or Lower Case
Text to Columns using VBA
Time - Working with Time Zones
Time: Military Time with No Colon
UDF(User Defined Function)-Use a Calculated Range in a Standard Function
Unselect a Cell or Area
Upper Case – Converting To/From
Use Cells(Row, Column) instead of Range() when looping through several columns
Use Cells(Row, Column).Name = “MyRange” to Simplify Naming a Range
Use Set to create an Object Variable instead of a regular variable when referencing cells
Use Workbook_Open to open a Userform when a workbook is opened
Userforms - Modeless
Userforms in Excel ’97 and beyond
Using Inputboxes
Variable - Declare
VBA How to: Macros on the Web
VBA How To: Record and Customize your own macros
WAV Files in Excel
What is a Code Module?
What is a Module?
Workbook - Close All
Workbook - Returning Properties
Workbook - Save All
Workbook Object – Document Properties
Working with Functions in a Macro
Working with Userform controls
Worksheet - Call a Macro from a Worksheet
Worksheet - Returning Sheet Name
Worksheet Protection after Sorting
Worksheets - Referencing from a Formula
Worksheets - Sorting
Zoom - To a Range
Oracle Data in Excel

Tags for this post>>
February 19, 2007

16 PowerPoint Tutorials from Towson University

Towson University provides the following 16 Microsoft PowerPoint Tutorials. These PowerPoint tutorials teach you many fundamental and advanced PowerPoint features, including the following: basic functions, Creating a presentation, Customizing to a CD, Animation, Views and printing, Autoshapes, Manipulating Objects, Hyperlinks, Splitting and merging slides, Custom backgrounds, Adding slides and embedded objects from other Powerpoint slides, Adding sound, and Shrinking files. These PowerPoint tutorials will help you learn these topics and add to your PowerPoint knowledge and skillset. All documents are in pdf format. 

PowerPoint 2003 Basics Video Tutorial
This video tutorial, with sound, shows you PowerPoint fundamentals and how to create a presentation in PowerPoint.

PowerPoint 2003  Basics Tutorial
This tutorial demonstrates all of the fundamental PowerPoint feature points and functionality you will need.

PowerPoint 2003: Creating a Presentation
Learn how to make a new presentation and save it, along with downloading the PowerPoint 2003 viewer so your users can view your slides without having PowerPoint installed.

PowerPoint 2003: Customizing and Packaging to a CD
This will assist you in understanding how to customize your presentation and package your presentation for a CD.

PowerPoint 2003: Animation
This tutorial teaches using the animation functionality in PowerPoint so various objects in your presentation can have different movement.

PowerPoint 2003: Views and Printing
Demonstrates the processes of printing handouts, adding speaker notes, inserting and deleting slides, and adding footers and headers.

PowerPoint 2003: AutoShapes
Explains the AutoShapes feature contained in PowerPoint 2003.

PowerPoint 2003: Manipulating Objects
This tutorial explains how to manipulate objects within PowerPoint 2003.

PowerPoint 2003: Hyperlinks
Demonstrates the process of adding hyperlinks to your PowerPoint presentation.

PowerPoint 2003: Adding Slides From Other Presentations
Learn how to add slides from other presentations to your current slides in PowerPoint.

PowerPoint 2003: Splitting and Merging Slides
This tutorials show the process of splitting and merging slides in your PowerPoint presentation.

PowerPoint 2003: Custom Backgrounds
Demonstrates making a custom background using the master slide PowerPoint 2003 feature.

PowerPoint 2003: Embedding Objects From Other Programs
This will teach you how to embed objects from other programs into a PowerPoint slide.

PowerPoint 2003: Adding Music and Sound to a Presentation
This tutorial shows you how to insert and manage music from audio CDs and digital music files into your PowerPoint slides.

PowerPoint 2003: Shrinking Files
Describes methods to decrease the size of your PowerPoint slides.

PowerPoint 2003: Effective Uses In Instruction
Get to know the PowerPoint tools and get your slides more user interactive, compelling, and results oriented.

PowerPoint 2003: Printing Handouts
Understand the process of printing PowerPoint handouts from your existing slides.

Tags for this post>>

75 CSS Tutorials, How Tos, and FAQs

Here are 75 Cascading Style Sheets (CSS) Tutorials, How Tos, and FAQs from These provide good CSS introductory knowledge and also will help experienced Web developers with CSS topics such as HTML formatting models, multiple element formatting rules, and Web page layouts and background images . Use these pages to help increase your CSS skillset and to understand CSS coding better from both design and best practices perspectives. Each of the following entries numbered below answers a commonly asked question about CSS web development and programming and many provide exercises to help your CSS training.

CSS (Cascading Style Sheets) Tutorials, How Tos, and FAQs

CSS Tutorials – Introduction To CSS Basics

21 Tutorials, How Tos, and FAQs on CSS fundamentals and functionality. By going through these you will understand the following: CSS syntax basics, contextual, class, and id selectors, CSS cascading order rules, grouping CSS definitions, browswer default CSS definitions

  1. What Is CSS (Cascading Style Sheets)?
  2. What Is the Basic Unit of CSS?
  3. How Many Ways to Attach CSS to HTML Documents?
  4. How To Include CSS Inside a HTML Tag?
  5. How To Include CSS Inside the HEAD Tag?
  6. How To Store CSS Definitions in External Files?
  7. How Many Ways to Select HTML Tag Instances?
  8. What Is a Class Selector?
  9. What Is a ID Selector?
  10. What Is a Contextual Selector?
  11. What Is a Group Selector?
  12. What Is a Mixed Selector?
  13. What Are the Pseudo Classes on <A> Tags?
  14. How To Group CSS Definitions Together?
  15. What Is Style Property Inheritance?
  16. What Is CSS Cascading?
  17. What Are the CSS Cascading Order Rules?
  18. How To Remove the Top White Space of Your Web Page?
  19. How To Set Different Text Fonts Inside Tables?
  20. How To Use Class Selectors to Differentiate Tag Instances?
  21. How To Use IDs to Override Classes?

CSS Tutorials – HTML Formatting Model: Block, Inline and Floating Elements

21 Tutorials, How Tos, and FAQs on HTML formatting models. Specifically, these will teach you the following: block and inline elements, specifying padding spaces and margins, specifying border width and color, transparent and non-transparent backgrounds, positioning background images, line boxes and text paragraphs, setting line height.
  1. What Is the HTML Element Formatting Model?
  2. What Are the Formatting Behaviors of HTML Elements?
  3. What Is a Block Element?
  4. What Is Inline Element?
  5. What Is a Floating Element?
  6. Hot To Specify the Content Box Size of a Block Element?
  7. Hot To Specify the Padding Spaces of a Block Element?
  8. Hot To Test Padding Spaces on All 4 Sides?
  9. How To Specify Borders of a Block Element?
  10. Hot To Test Borders with Different Widths, Styles, and Colors?
  11. How To Specify Margin Spaces of a Block Element?
  12. Hot To Test Margin Spaces on All 4 Sides?
  13. How To Specify Is the Color of the Margin Area?
  14. How To Specify Is the Color of the Padding Area?
  15. What Are the Background Properties of a Block Element?
  16. How To Set Background to Transparent or Non-transparent?
  17. How To Add Images to Backgrounds?
  18. What Is the Text Paragraph Formatting Model?
  19. How In-Line Elements Are Mixed in Text Lines?
  20. How In-line Elements Affect Line Box Heights?
  21. Is FORM a Block Element?

CSS Tutorials – Understanding Multiple Element Formatting Rules

15 Tutorials, How Tos, and FAQs on understanding multiple element formatting rules. Learn the following CSS functionality: stacking and nesting block elements, aligning in-line elements, floating block elements, collapsing margins between elements, balancing widths and heights with parent elements, collapsing white spaces.
  1. How Many Ways Can Elements Relate to Each Other?
  2. How In-line Elements Are Formatted Side by Side?
  3. How Nested Block Elements Are Formatted?
  4. How Two Block Elements Are Formatted as a Stack?
  5. How Floating Elements Are Formatted?
  6. Why Is the Top Margin Not Showing?
  7. How Are Vertical Margins between Two Block Elements Collapsed?
  8. How Are the Parent Padding Spaces Collapsed with the Child Margins?
  9. How Is the Width a Parent Element Related to Child Elements?
  10. How Is the Full Width of a Block Element Extended?
  11. How To Test Child Full Width Extension?
  12. How To Test Parent Content Width Extension?
  13. What Are White Spaces in HTML Documents?
  14. How White Spaces Are Formatted?
  15. What Happens to Multiple White Spaces in In-line Elements?

CSS Tutorials – Page Layout and Background Image Design

18 Tutorials, How Tos, and FAQs on designing Web page layouts and background images. These cover and demonstrate the following CSS topics: screen and browser resolutions, setting Web page width in absolute and relative length units, setting images and font sizes in relative length units, adding multiple background images.
  1. What Needs To Be Considered When Designing Page Layout?
  2. What Is Screen Resolution?
  3. What Is Browser Resolution?
  4. How To Test Browser Resolutions?
  5. How Wide Do You Want Your Page Content to Be?
  6. What Are the Page Widths on Popular Websites?
  7. What Are the Length Units Used in CSS?
  8. How To Set Page Width Relative To the Browser Width?
  9. How To Set Page Width to a Fixed Value?
  10. How To Center Your Page in Browser Windows?
  11. What Happen to Images with Absolute Page Width Units?
  12. How To Set Page Widths to Relative Length Units?
  13. What Happen to Font Sizes with Relative Page Width Units?
  14. How To Set Font Sizes to Relative Length Units?
  15. What Are the Background Style Properties?
  16. How To Specify a Background Image?
  17. How To Position Background Images?
  18. How To Specify Two Background Images on a Page?

Tags for this post>>
February 16, 2007

15 Excel Tutorials from Towson University

Towson University provides the following 15 Microsoft Excel Tutorials. These Excel tutorials teach you many fundamental and advanced Excel features, including the following: basic calculations, functions and references, charts, sorting and filtering, freezing panes, formatting data, printing advanced calculations, and macros. These Excel tutorials will help you learn these topics and add to your Excel knowledge and skillset. All documents are in pdf format. 

Excel 2003: Basic
This tutorial shows you what the fundamental pieces a spreadsheet are and how to move around in Excel.

Excel 2003: Basic Calculations

Provides instruction on performing simple calculations with Excel using formulas and its auto features.

Excel 2003: Functions and References
This Excel tutorial shows how to enter more complicated calculations with Excel’s functions. It describes the various kinds of cell references that can be used with formulas.

Excel 2003: Charts
Provides instructions on how to create charts using data contained in an Excel spreadsheet.

Excel 2003: Custom Charts
Learn how to customize and format charts in Excel, changing their looks, layout, and type.

Excel 2003: Common Chart Types
This tutorial teaches you what Excel’s common charts are and how to use them.

Excel 2003: Convert Number Grades to Letter Grades
This tutorial describes how to convert number grades to letter grades using Excel.

Excel 2003: Sorting and Filtering Data
This tutorial shows you how to sort and filter data in Excel, making it easier to view.

Excel 2003: Working With Large Data Sets
This Excel tutorial demonstrates freezing panes, and using the keyboard to navigate when managing large data sets.

Excel 2003: Formatting Data
Explains and shows how to format your data in Excel.

Excel 2003: Printing
Demonstrates various methods to print your Excel worksheets or portions of them.

Excel 2003: Advanced Calculations
Shows how to enter and set up several of the Functions in Excel in order to do advanced calculations.

Excel 2003:  Use Excel as a Grade Book
This demonstration shows you how to calculate student grades when using Excel as a grade book.

Excel 2003: Common Errors
When Excel shows an error message you need to know how to correct the problem – this tutorial will show you how for several common errors.

Excel 2003: Macros
A Macro is a series of user interactions, such as a key stroke, mouse click, that are recorded and then later played back. This feature saves time for common and repetitive activities. This Excel tutorial shows how to record a macro, modify a macro, create a custom macro toolbar icon, and a worksheet macro icon.

Tags for this post>>

9 Microsoft FrontPage Tutorials

Towson University hosts the following 9 Microsoft FrontPage Tutorials. These FrontPage tutorials will instruct you on using several basic and advanced features of FrontPage, including: clip art, pictures, tables, links, web publishing, direct web editing, restricting web page access, forms, behaviors, and web components. By using these tutorials, you can significantly increase your knowledge and skillset of FrontPage. All but the first tutorial are in pdf format. 

FrontPage Basics Video Tutorial
Explains, with sound, opening a FrontPage Web site and adding web objects such as clip art, pictures, tables and links.

FrontPage 2003: Basics
This tutorial explaings many of FrontPage’s fundamental features to create Web pages.

Web Publishing Pitfalls
Learn about the most common Web publishing problems what to do to avoid them with FrontPage.

Safe Practices for Direct Web Editing
This tutorial explains how to perform direct Web site editing using FrontPage.

Restricting Access to a FrontPage Web site on Pages
This tutorial gives a detailed demonstration on how to set up restricted access to a Web site using FrontPage.

FrontPage 2003: Online Forms
Describes how to insert online forms with FrontPage 2003.

FrontPage 2003: FAQ
Here are answers to five Frequently Asked Questions that come up when using FrontPage.

FrontPage 2003: Web Components
Understand how to use FrontPage’s Web Components feature, with tools such as Dynamic Effects, Hit Counters, Photo Gallery, Spreadsheets and charts, weather and more.

FrontPage 2003: Behaviors
Using this FrontPage tutorial, you will learn how to add “Behaviors” - scripting options that add interactivity and functionality to objects on your Web page.

Tags for this post>>

February 15, 2007

28 Word Tutorials from Towson University

Towson University hosts the following 28 Microsoft Word Tutorials. These Word tutorials will instruct you on using many of the basic and advanced features of Word. You can become an expert Word user in these topics by using these tutorials. Most of these Word tutorials are in pdf format. The last 4 tutorials listed explain how to use Word Art.

Word 2003 Mail Merge to Labels Video Tutorial
Learn how Word 2003 Mail Merge works and make multiple address labels - with sound.

Word 2003: Basic Quick Sheet

Get the basics: open Word, type some sentences, then save the document and exit Word.

Word 2003: Basic Formatting
Explains formatting features in Word that are most commonly used.

Word 2003: Advanced Formatting
Describes how to easily create format styles and templates. 

Word 2003: Mail Merge to Labels
Review the steps of performing Word Mail Merge to print out address labels.

Word 2003: Mail Merge to Letters
Learn how to do Word Mail Merge to address many letters at the same time.

Word 2003: Merging to E-mail
Teaches how to merge email address and messages when sending an email to many people through e-mail. 

Word 2003: Tables
This tutorial demonstrates how to create and manage tables in Word 2003.

Word 2003: Index
Explains how to generate an index at the end of the document, displaying the page number of each area of interest.

Word 2003: Sharing and Tracking Documents
This tutorial describes sharing a Word document and how to highlight the updates people make to it by using tracking and comments.

Word 2003: Basic Sections
Describes how to mark off section breaks in your Word document and when to do this.

Word 2003: Table of Contents
Explains generating a Table of Contents using Word 2003.

Word 2003: Watermarks
This shows you how to place words and graphics into a document’s background.

Word 2003: Copy in Test Bank Questions
How to copy questions from a question bank into a Word document. 

Word 2003: Forms
Learn how to insert forms with check boxes, drop-down options and text boxes.

Word 2003: Page Numbers
Explains inserting and formatting page numbers in a Word document using section breaks.

Word 2003: Formatting Papers 
Learn some Word tips that will help you with formatting papers.

Word 2003: Insert Objects From Other Office Programs
Insert charts, graphs, spreadsheets and other objects from various Office applications into a Word document.

Word 2003: Work Smarter Not Harder
Understand how to use tools in Word, such as templates, AutoCorrect, tables, short-cuts and others.

Word 2003: Routing Documents
Teaches how to use Word’s routing function to route documents automatically through Outlook – and find how what steps to take when receive a routed document. 

Word 2003: Useful Options
Explains the Reading Layout view, how to use the horizontal ruler, insert symbols, compare documents, and obtain a document’s word count.

Word 2003: Creating Booklets
How to make simple booklets using templates from Microsoft.

Word 2003: Add a Custom Styles
How to apply a custom style to a document after making it, and working with it.

Word 2003: Selecting Text Effectively
There are lots of methods to select text in Word (using the mouse, the keyboard and shortcuts), this will show you which ones are more efficient than others.

Word Art Tutorials

Word Art: Basics
This tutorial shows how to use the toolbar, how to add Word Art, and use some of the basic Word Art features. 

Word Art: Formatting
Explains format settings that are used in Word Art.

Word Art: Toolbar
Understand how to use the Word Art toolbar options to change your Word Art.

Word Art: Shadows and 3D Effects
Learn how to add Word Art shadows and 3D effects to your document.

Tags for this post>>

MySQL Basics Tutorials

This is a a sneak preview of the new MySQL Basics training section at the In Pictures web site. It is specifically aimed at non-programmers and addresses the need for basic training tutorials covering the popular open-source MySQL database and its use in web site development and programming. It was edited by non-programmers and anything that they did not understand was removed or reworded in a clear fashion. These MySQL tutorials can also be used as a reference on how to do specific tasks using MySQL. Two more tutorials on Perl and PHP, the most widely-used Web programming languages, will be released by In Pictures in the next few weeks. The site editors hope they’ll give non-programmers a basic understanding of the fundamental concepts upon which Web server programs are based.

MySQL Basics Tutorials

Begin the MySQL Basics Tutorial >>




Tags for this post>> |
February 14, 2007

Dreamweaver 8 Tutorials hosts lots of excellent web development training tutorials. Below are their Dreamweaver 8 Tutorials that demonstrate and explain all of thet functional areas of Dreamweaver. The following features and topics are detailed and taught by these Dreamweaver tutorials: Basic features; The Dreamweaver Interface; Defining a Site; Working with Text; Establishing Web Links; Inserting Images; Setting up Tables; Using Frames; Interactive Forms; Adding Multimedia Elements; Using Dreamweaver Templates; Working with Layers; Using Behaviors; and HTML with Dreamweaver. Also included below are several video Dreamweaver tutorials.

Dreamweaver 8 Tutorials

1. Dreamweaver 8 Basics
2. The Dreamweaver Interface
3. Defining a Site
4. Working with Text
5. Establishing Web Links

6. Inserting Images
7. Setting up Tables
8. Using Frames
9. Interactive Forms
10. Adding Multimedia Elements

11. Using Dreamweaver Templates
12. Working with Layers
13. Using Behaviors
14. Other features
15. HTML and Dreamweaver

Unit 1. Dreamweaver 8 Basics

Introducing Dreamweaver 8
HTML Basics
Editing a web Page
Planning your site online
Starting and closing Dreamweaver 8
Arranging two sessions
Opening and saving documents
My first web Page

Unit 2. The Dreamweaver Interface

The initial Screen
The tool bars
Panels and Inspectors
Customizing the work area
Documents Views
The Help Guide

Unit 3. Defining a Site

Creating and publishing a Website
Using the wizard to define a website
Document Views
Verifying the size to optimize the loading
Documents properties
The color palette

Unit 4. Working with Text

Text Format
Creating Lists
CCS Styles
The CSS Panel

Unit 5. Establishing Web Links

Web Links types
Creating a web link
Setting the URL link
Link Format
Email link format
Broken Links

Unit 6. Inserting Images

Web graphics Formats
Inserting an image
Changing the image size
Image Maps
Inserting Rollover images
Flash buttons
Flash Text
Navegation Bar

Unit 7. Setting up Tables

Inserting a table
Working with cells
Selecting elements in a table
Table Formatting
Cells and table sizes
Eliminating Rows and Columns
Combining and dividing Cells
Tables modes

Unit 8. Using Frames

Creating Frames
Selecting Frames
Saving Frames
Setting up Frames
Frame contents

Unit 9. Interactive Forms

Structure of an interactive form
Creating Interactive Forms
Validating Interactive Forms

Unit 10. Adding Multimedia Elements

Flash movies
Sound files
Movies and videos files

Unit 11. Using Dreamweaver Templates

Creating Templates
Editable regions
Using the template

Unit 12. Working with Layers

Inserting a layer
Layer Format

Unit 13. Using Behaviors

Inserting a behavior
Show and Hide Layer behavior
Using JavaScript code

Unit 14. Other Features

Set the Date
Horizontal Rule
Adding external code
Web Page Resolution

Unit 15. HTML and Dreamweaver

Code Inspector
The Tag Hint List
Code Errors
Find and Replace

Step by Step Dreameaver Exercises

3. Defining the website
3. Creating a new document and modifying the properties
4. Inserting text and modifying the properties
4. Creating a list
4. Creating CCS Styles
5. Creating a web Link
5. Creating an email Link
6. Inserting an image
6. Creating an image Map
6. Creating Flash buttons
7. Creating a table
7. Using Table properties
7. Add and eliminate rows
7. Combining rows
8. Creating frames
9. Inserting elements in an interactive form
10. Inserting an audio file
11. Creating a template
12. Inserting a layer
13. Inserting behaviors
14. Inserting an horizontal rule
15. Find and replace

Dreamweaver Video Tutorials

1. Dreamweaver Basics
2. The Dreamweaver Interface
2. Document Views
2. Help guide
3. Defining the Site
3. Page Properties
4. Text
4. CSS Styles
5. Establishing Web Links
6. Inserting Images
6. Flash buttons
6. Creating a Flash text
7. Inserting a table
8. Inserting frames
9. Working with interactive forms
10. Inserting multimedia elements
11. Creating a template
12. Inserting a layer
13. Inserting behaviors
14. Others features
15. HTML with Dreamweaver

Dreameaver Exercises

3. Defining the site and setting the Page properties
4. Setting the text properties
5. Creating Web Links
6. Inserting images
7. Changing Tables formats
8. Formatting Frames
9. Working with interactive forms
10. Inserting multimedia elements
11. Working with Templates
12. Inserting Layers
13. Creating behaviors
14. Inserting others elements
15. Search and Replace

Dreamweaver Evaluation Tests

1. Dreamweaver 8 Basics
2. The Dreamweaver Interface
3. Defining a Site
4. Working with Text
5. Establishing Web Links
6. Inserting Images
7. Setting up Tables
8. Using Frames
9. Interactive Forms
10. Adding Multimedia Elements
11. Using Dreamweaver Templates
12. Working ith Layers
13. Using Behaviors
14. Other features
15. HTML with Dreamweaver

Tags for this post>>

Access 2003 Tutorials provides many well written software and web development tutorials. Here are their Access 2003 Tutorials that will teach you virtually every topic of Access you need to know and use. The following application and database topics are explained by these Access tutorials: Basic features; Create, Open, and Close a Database; Creating Tables; Modifying Tables; Field Properties; Relationships; Queries; Summery Queries; Cross Reference Queries; Action Queries; Forms; and Reports. Also included below are several video Access tutorials.

Access 2003 Tutorials

1. Basic elements of Access2003
2. Create, open, and close a database
3. Creating datatables.
4. Modifying datatables

5. Properties of the fields
6. Relationships
7. Queries
8. Summery queries

9. Cross reference queries
10. Action queries
11. Forms
12. Reports

Unit 1. Basic elements of Access2003

Opening and closing Access2003
The initial screen
The bars
Intelligent menus

Unit 2. Create, open, and close a database

Basic concepts
Creating a database
Closing a database
Opening a database
More ways to open a database

Unit 3. Creating data tables

Creating a datatable
The field builder
Data types
The lookup wizard
The primary key
Saving a table
Closing a table

Unit 4. Modifying data tables

Modifying the design of a table
Introducing and modifying data in a table
Moving within a table
Finding and replacing data

Unit 5. Properties of the fields

Field size
Field format
Customizing formats
Decimal places
Input mask
Customizing input masks
Default value
Validation rule
Validation text

Unit 6. Relationships

Basic concepts on relationships
Creating the first relationship
Referential integrity
Adding tables to the relationship window
Removing tables from the relationship window
Editing relationships
Deleting relationships
Tidying the relationship window
Showing direct relationships
Visualizing all the relationships


Unit 7. Queries

Types of queries
Creating a query
The Design view
Adding fields
Defining calculated fields
Forming expressions
Column headings
Changing the order of the fields
Saving the query
Running the query
Modifying the query design
Ordering rows
Selecting rows
Multitable queries
Joining tables
The external join

Unit 8. Summary queries

The summary functions
Grouping records
Including expressions
Including search criteria

Unit 9. Crosstab queries

The Crosstab Query wizard
The design view of a crosstab query

Unit 10. Action queries

Make-table queries
Update queries
Append queries
Delete queries
Unshowing confirmation messages

Unit 11. Forms

The form’s wizard
Editing the data in a form
The Form design view
The Form design bar
Properties of a form
The Toolbox
Working with controls

Unit 12. Reports

The Report’s wizard
The Report design view
The Report design bar
The Toolbox
Printing a Report
The Preview window
Grouping and Sorting

Step by Step Access Exercises

Create, open, and close a database
Creating a table
Modifying the design of a table
Introducing data
Moving in a table
Searching for data
Properties of the fields
Creating relationships
Modifying relationships
The relationships window
Creating simple queries I
Creating simple queries II
Multitable queries
Summary queries
Crosstab queries
Make-table queries
Update queries
Append queries
Delete queries
Creating a Form using the wizard
Changing a Form’s design
Creating Subforms
Aligning Controls
Creating Reports with the wizard
Printing Reports
Reports with groups

Access Video Tutorials

2. Create a database
3. Create a table
4. The Datasheet view
5. Changing format and input mask
5. The expression generator and indexes
6. Relationships
7. Create a query
7. Create a multitable query
8. Create a Summary query
10. Create an update query
10. Create an Append query
11. Managing controls in Form design
12. Grouping and sorting in Form design

Tags for this post>> |
February 13, 2007

Flash 8 Tutorials provides many well written web design and development tutorials. Here are their Flash 8 Tutorials teaching you virtually every feature you will need to know and use for Flash 8. The following Flash topics are covered and taught by these tutorials: Animations, Working Environment, Drawing, Texts, Sounds, Objects, Layers, Symbols, Graphics, Movie Clips, Buttons, Movement Animations, Form Transformations, Effects on Animations, Generating and Publishing Movies, and ActionScript 2. Also included here are several  video Flash tutorials.

Flash 8 Tutorials

1. Introduction
2. My first Flash Animation
3. Working Environment
4. Drawing
5. Working with Texts
6. Sounds

7. Working with Objects
8. Layers
9. Symbols
10. Graphics
11. Movie Clips
12. Button

13. Movement Animations
14. Form Transformations
15. Effects on Animations
16. Generating and Publishing Movies
17. Introduction to ActionScript 2.
18. Examples of Use of the ActionScript 2.

Unit 1. Introduction

What’s FLASH 8
Why should we use FLASH 8
From FLASH MX 2004 to FLASH 8
Flash 8 Alternatives. Javascript
Flash 8 Alternatives. CSS
Flash 8 Alternatives. DHTML
The eternal deal.
Javascript, examples and uses.

Unit 2. My First Flash Animation

First Steps
Making the Animation

Unit 3. Flash 8 Environment

Flash 8 Interface
Menu Bar
Work Area
Views or Zooms
Frames. Types and uses

Unit 4. Drawing and Working with Color

Drawing in Flash 8
Tool Bar. Basic Tools
Tools Bar. Advanced Tools
Tools Bar. Options
Mixer Panel
Fill Panel

Unit 5. Texts

Properties of the Texts
Text Types
Static Text
Dynamic Text
Input Text
Writing texts

Unit 6. Sounds

Importing Sounds
Sound Properties
Inserting a Sound
Publishing Sounds
MP3 or WAV
Audio Formates. MP3 and WAV

Unit 7. Working with Objects

The Objects. Initiation
Placing Objects. Alignment Panel
Info Panel

Unit 8. Layers

Layers. Let’s understand them
Working with Layers
Working with Layers. Advanced Options
Reorganizing the Layers
Layer Types

Unit 9. Symbols

What are the Symbols
How to create symbols
The Libraries
The Difference between Symbol and Instance
Modifying an Instance
Instance Properties Panel
Panel of Effects on Instances
Panel of Effects on Instances (II)

Unit 10. Graphics

What’s graphics?
Graphics types
Creating graphics and verifying its properties
Introducing bitmap
Introducing a vectorial file
Exporting a Flash object as bitmap
Exporting a Flash object as animation
Graphics Types

Unit 11. Movie Clips

What’s a Movie Clip
Verifying the Clip properties
Creating a new Clip
Importing and Exporting Movie Clips
Other uses of the Movie Clips.

Unit 12. Buttons

What’s a Button
Creating a Button
Buttons Shapes
Text Buttons. Active Zone Importance
Including Clip in a Button
Bitmaps and buttons
Actions in Buttons
Including a sound in a Button

Unit 13. Movement Animations

Flash Animation
Movement Interpolation (I)
Movement Interpolation (II)
Texts Animation
Lines Animation
Interpolation by Movement Guide
Frame by Frame Animations

Unit 14. Shape Transformations

Interpolations by Shape
Transformating Texts
Shape Advices

Unit 15. Effects on Animations

Effects on the Movement Interpolations
Effects on the Interpolated symbol
Brightness Effect
Tint Effect
Alpha Effect

Unit 16. Generating and Publishing Movies

Considerations about Movies Size
Distributing as swf file in an independent player
Distributing for Web pages

Unit 17. Introduction to ActionScript 2

What’s the ActionScript
Actions Panel
Initial concepts of Programming

Unit 18. Examples of ActionScript 2 use

Examples of use of the ActionScript code
Examples of ActionScript in Buttons
Examples of ActionScript in Movie Clips
Examples of Sounds handling with AS
Examples of ActionScript in abstract objects. The object MATH
Creating of loader or preloader

Video Flash Tutorials

2. My first Animation
3. Types of Views
4. Eyedropper Tool
4. Making a Gradient
5. Interaction Dinamic Texts-Input
6. Importing Sounds
6. Inserting Sounds. 2 posibilities
6. Controlling the sound sincronization
7. Selecting Objects
7. Aligning Objects
7. Working with the basic properties of the objects
7. Groups
8. Working with Layers
8. Working with Layers. Advanced Options
8. Reorganizing the Layers
9. Inserting a Symbol
9. Application of Alpha effect on a Instance
10. Introducing a bitmap

10. Exporting Flash object as image
11. Creating an empty clip
11. Importing Symbols from other Libraries
12. Creating and Publishing a Button
12. Text Buttons. Active Zone
12. Including a Clip in a Button
12. Actions in a button
13. Animation of Lines
13. Interpolation by Movement Guide
14. Interpolation by Form
14. Text Transformating
14. Applicating Form Advices
15. Automatic Rotation
15. Right Rotation
15. Creating a complete animation with effects
16. Publishing a movie for the web
17. Change object Properties using ActionScript

Step by Step Flash Exercises

3. Creating Movement Guides
3. Changing Movies Properties
3. Accessing to the Panels
4. Creating an oval
4. Applicating Color to an oval
4. Creating a Transparent color
5. Changing type of Text
8. Changing Objects in Layer
9. Creating Symbols

9. Modificating Instance
10. Exporting Bitmap
12. Button in Relief
13. Chaining Interpolations
13. Animate text by blocks
15. Accelerating Movement
16. Publishing SWF

Flash Exercises
3. Flash 8 Environment
4. Drawing the Olympic Rings ant Planet Saturn
6. Sounds
7. Objects
9. Symbols
11. Clips
12. Buttons
14. Animation by Form
15. Effects on animations

Tags for this post>>

39 Outlook Tutorials from Towson University

Towson University provides the following 39 Microsoft Outlook Tutorials. These tutorials will teach you how to use all of the basic and advanced features of Outlook. After using these you will be able to use Outlook to its fullest extent. The first group of Outlook tutorials are movies show how to use the application’s features with voice instruction. The third group of tutorials teaches how to use Outlook on the Web with a browser. The non-video tutorials are in pdf format.

Outlook Movie Tutorials with Sound

Outlook 2003 E-mail Basics
Learn all of Outlook 2003′s fundamentals.

Outlook 2003 Calendar Basics
Discover what Outlook’s Calendar features are and how to use them.

Outlook 2003: Checking Your Folder Size
Watch how to check your folder sizes and keep from going over your storage limit or quota.

Outlook 2003: Reclaiming Mailbox Space
Learn how to clean up items in your mailbox and to stay within your storage limit.

Outlook 2003: Recover Deleted Items
This tutorials shows how to recover deleted items in Outlook.

Outlook 2003: Create Personal Folders
Move items to your personal folders and stay within your storage limit.

Outlook Tutorials

Outlook 2003: E-mail and Calendar Basics
Learn how to set up contacts, send and receive mail and use the calendar features in Outlook.

Outlook 2003: Sorting E-Mail
This tutorial details Outlook’s common email sorting features.

Outlook 2003: Forms
This will teach you how to custome a form for auto entry of a field in a message.

Outlook 2003: Organizing and Managing Messages
Shows how to create, move and delete folders. Set up rules using a step-by-step process. Learn how to arrange messages, create read receipts and create out-of-office auto reply’s.

Outlook 2003: Calendar Delegation
Learn several calendar features and how to assign a delegate to set up, send and keep track of appointments. 

Outlook 2003: Personal Folder
Find out how to set up and use your Outlook personal folder to manage your e-mail storage capacity.

Outlook 2003: Keeping Track Of Tasks
Using Outlook, discover how to create, delegate and manage tasks.

Outlook: Inserting Tables
Explains how to insert a table in Outlook so you can organize data better in an email message.

Outlook 2003: Creating and Relocating your Personal Folder (.pst file)
Learn how to keep within the storage capacity of your Outlook Personal Folder by making and then relocating the .pst file.

Outlook 2003: Filters
Teaches how to create an Outlook filter so you can search or view only certain items.

Outlook 2003: Rule to Send E-mail as a Text Message to a Phone
Find out how to set up a rule to send a message as a text message to a phone.

Outlook 2003: Address Book
This tutorial teaches how to use Outlook’s features related to the Address Book, Contacts and Distribution List.

Outlook 2003: Importing Contacts and Copy/Paste Distribution List from Excel
Learn how to import contacts from an Excel spreadsheet into the Outlook 2003 Contacts List. Also shows how to create a quick email distribution list in Excel.

Outlook 2003: Search Folders
Discover how to use Search Folders, how to create customized Search Folders and how Search Folders can be used to manage drive storage capacity.

Outlook 2003: Adding a Mail Drop
Teaches how to request and add a mail drop, which is an e-mail account from which one can send e-mail messages to a group from an alias rather than their own e-mail address. 

Outlook 2003: Attaching Files
How to attach files to Outlook items including messages, calendars and tasks.

Outlook 2003: Upgrading to Version 2003 Personal Contacts and Folders
If you have been upgraded to Office 2003 you may need to re-display your personal contacts and personal folders, this tutorial shows you step by step through this process.

Outlook 2003: Security Setting for Displaying Graphics
Shows how to change Outlook’s settings for viewing and hiding incoming graphics.

Outlook 2003: Creating An E-mail Template
Teaches how to create a template to use for sending out the same message many times.

Outlook 2003: Adding Holidays
Understand how to use Outlook’s Calendar to add standard holidays to your calendar. Also learn how to make custom holidays and add them to your calendar. 

Outlook 2003: Creating Labels From Contacts
This tutorial explains how to use the Contacts list in Outlook to create labels.

Outlook 2003: Locating Correspondences
How to view all the messages you have had with a personal contact.

Outlook 2003: Setting a Rule to Help Filter Spam
This tutorial shows how to set up a rule in Outlook to help reduce unwanted incoming emails.

Outlook 2003: Quarantined Files
Understand how Outlook quarantines various attachments, how to stop this, and how to find attachments that have been quarantined.

Outlook 2003: Shortcut to Enlarge Font Size of Received Messages 
Here is a tip on using the scroll button on the mouse to quickly enlarge or decrease a message’s font size.

Outlook 2003: Signatures 
Learn to set up an Outlook Signature to include in your outgoing email messages.

Outlook 2003: Importing Calendar Data Into Your Outlook Calendar
How to import information contained in a CSV file into your Outlook Calendar.

Outlook 2003: Storage Capacity Management 
An Outlook Archiving tutorial showing how to clean out and manage your Outlook e-mail, how to set up folders, and check your quota and archive folders.

Outlook Web Access Tutorials

Outlook Web Access: Getting Started
This tutorial gets you going with using Outlook Web Access.

Outlook Web Access: E-mail Basics
Teaches Outlook Web Access fundamentals of sending and receiving email.

Outlook Web Access: Contacts and Public Folders
Using Outlook Web Access, find out how to create and use Contacts and access Public Folders.

Outlook Web Access: Calendar, Tasks and Notes
Helps you use the Calendar, Tasks and Notes features of Outlook Web Access.

Outlook Web Access: Advanced Options
Learn Outlook Web Access’ advanced features including creating your Signature, setting up Out of Office, and making Rules.

Tags for this post>>

February 7, 2007

Spreadsheet Training and Learning Resources

Here are more Spreadsheet Training and Learning Resources, from, that will teach you all about Spreadsheets and how to use them. These will get you going to become an expert using Excel, Microsoft’s spreadsheet application. Included here are: content on understanding spreadsheets, help sheets for various Excel functions, many spreadsheet lessons and practice tasks, and a Spreadsheet Mind Map, which a great way to visually understand how spreadsheets are set up and work.

Spreadsheets Theory

Understanding Spreadsheets
These pages give a clear understanding of how spreadsheets work and how to use them.

Spreadsheets Slides
These slides introduce spreadsheets, what they are, and what they are used for. (Powerpoint format) 

Spreadsheets explained
This resource clearly explains the topic of spreadsheets is an easy to understand way. (Word format)

Spreadsheet Formula Sldies
These slides covers the most important Excel formulas that are required to complete the spreadsheet projects. (Powerpoint format)

Excel Function Help Sheets

Here is an excellent set of resources which explain different functions which can be used in Excel. (Word format)
Spreadsheet Lessons and Practice Tasks

Worksheet 1 – Billericay
These are questions that will test if you understand this topic.

Basic Excel Formulas 2
This worksheet demonstrates Excel’s fundamental formulas.

Worksheet 3
A lesson to check your knowledge of spreadsheets. You are given a fill-in-the gaps exercise and then asked to answer some basic questions about spreadsheets.

Worksheet 4
In this speadsheet lesson, you are asked to design a simple spreadsheet for a school fete. 

Worksheet 5
This speadsheet lesson has you design a simple spreadsheet to hold teacher’s marks.

Here you are provided a completed spreadsheet and requested to use it to calculate the nutritional values of a range of foods. Here is the Excel file for this exercise.

The Disco
Use Excel to calcualate the cost of setting up a disco. It begins with simple formulas, then shows the use of absolute cell references and IF..Then functions. 

Supermarket Comparisons
In this spreadsheet exercise gives you a list of groceries and asks you to use Excel to calculate total costs, average, minimum and maximum.

Profit and Loss – Computer Supplies shop
In this spreadsheet lesson, you will create a model to simulate a computer supplies shop and then you will develop the fomulas to calcualate profit and loss. You will then use the spreadsheet to model various scenarios. Here is the Excel file for this exercise.

This is a spreadsheet word search to help with remembering key terms.

This is another exercise to hone your spreadsheet skills with Excel. Here is the Excel file for this exercise.

Basic Spreadsheet Guide
This provides a guide to the fundamental features of Excel and its use. It does not show how to create a formula.

Worksheet - Fill in the gaps
Fill in the gaps of spreadsheet phrases with the right words, to check your knowledge.

Tags for this post>>
Next Page »