Free Training for Photoshop, Flash, Dreamweaver, FrontPage, and other Adobe & Macromedia Apps




    



October 30, 2007

Dreamweaver MX Tutorial

This is a well written, illustrated Dreamweaver MX Tutorial, titled ‘Intro to Macromedia Dreamweaver MX’, from the San Antonio Independent School District. Dreamweaver features and funcationality demonstrated and shown in this Dreamweaver tutorial include: Panel Groups, Tool Bars, Create a New Site, Site Panel, Page Properties, Saving a Page, Images, Horizontal Rules, Navigation Bar, Create a Template, Bullets, Hyperlinks, Templates, and Rollovers. This tutorial is found on this site’s Macromedia MX tutorial page.


Intro to Macromedia Dreamweaver MX
(51 pages, 1.6mb, pdf format)

What is Macromedia Dreamweaver?
    What should I consider before beginning?
Beginning Basics
    Opening Dreamweaver
    Dreamweaver Window Overview
    Panel Groups Overview
    Dreamweaver Tool Bars
Setting Up a Site
    Creating a New Site
    Setting up Server Access
    Using Site Panel
Creating a Web Site
    Setting Page Properties
    Preparing your Page
    Adding Title to Document
    Saving the Page
    Creating an Email Link
    Inserting an Image into the title
    Horizontal Rule
    Navigation Bar
    Creating a template
    Creating Web Site Pages
    Creating Numbered or Bulleted Lists
    Adding Hyperlinks
    Applying Template
Dreamweaver Extras
    Adding Fireworks or Flash objects
    Creating Rollovers
    Adding Time and Date Stamp
    Adding Copyright information
Helpful Hints for Dreamweaver
    Using Dreamweaver Help
    Standard View vs Layout View
Test for Knowledge
    Create a Classroom Web Page
    Mini-Power Point Quiz
Evaluation Form
    Geometric Reflections and Evaluation
Resources, Links, and Citations


Tags for this post>>

PowerPoint XP Tutorial and Guide

This is a great, informative PowerPoint XP Tutorial and Guide, titled ‘Your Guide To Microsoft PowerPoint XP, from San Antonio Independent School District. PowerPoint features and functions taught by this PowerPoint tutorial include: Create New Presentation, Slide Views, Slide Layouts and Colors, Fonts, Headers and Footers, Word Art, Clip Art and Graphics, Charts, Tables, Sounds, Slide Shows, and Packaging Presentations. This tutorial is hosted on this site’s MS Office XP tutorial page.


Your Guide To Microsoft PowerPoint XP
(43 pages, 2.3mb, pdf format)

What is Power Point XP?
   What should you consider before beginning?
Beginning Basics
   Opening Power Point
   Power Point Window Overview
   Creating a new presentation
   Slide Views
Basic Slide Editing
   Slide Layouts
   Slide Color Scheme
   Font Settings
   Headers and Footers
Adding Content
   Adding Text
   A New Slide
   Word Art
   Graphics from Clip Art
   Graphics from a File
   An Organizational Chart
   A Chart
   Tables
   Sound
   Hyperlinks
Slide Show Secrets
    Slide Show Animations
    Slide Show Transitions
    Slide Show Timing
    Speaker Notes
Playing the Slide Show
   Navigation Through a Slide Show
   Additional Slide Show Features
Packaging a Presentation
   Saving a presentation for preview
   Saving a presentation for preview on the web
   Saving a presentation for preview on any platform
   Printing a presentation
Helpful Hints For Power Point
   Replace Fonts Globally
   Show slides out of order
   Create a Photo Album
   Protect your Presentation
Test for Knowledge
   Create a presentation based on your life
   Mini-Power Point Quiz
Evaluation Form
   Geometric Reflections and Evaluation
Resources, Links, and Citations


Tags for this post>>

October 26, 2007

Tutorials on Fireworks, Flash, Dreamweaver

I just wrote a post on our Web Development Tutorial blog covering nine screen-shot illustrated Web Page Design Tutorials, from the San Antonio Independent School District. Web design and development topics and software presented by these tutorials include the following: Web Design Theory, Images, Fireworks, Flash, Dreamweaver, CSS, and Templates.


Tags for this post>> | | |

Web Page Design Tutorials

Here are nine illustrated Web Page Design Tutorials, courtesy of the San Antonio Independent School District. Web design and development topics taught and covered by these tutorials include the following: web design theory, images, Fireworks, Flash, Dreamweaver, CSS, and templates. This educational website’s Technology Literacy Institute provides access to free web-based tutorials and resources. These training documents are in pdf format.


Web Design Academy – Part One


Day One – Theory, MS Word and PowerPoint
(28 pages)

Day Two – MS PowerPoint, Digital Images and Fireworks MX
(42 pages)

Day Three – Macromedia Flash MX
(32 pages)

Day Four – Macromedia Dreamweaver and Fireworks MX
(16 pages)

Day Five -Website Prep and Final Product
(16 pages)


Web Design Academy – Part Two


Day One – Theory, MS PowerPoint and Digital Images
(44 pages)
 
Day Two – Macromedia Fireworks and Dreamweaver MX

(28 pages)

Day Three – Cascading Style Sheets (CSS) and Templates
(20 pages)
 
Day Four – Macromedia Flash, Dreamweaver MX, and Website Prep

(9 pages)


Tags for this post>>

Excel XP Tutorial and Guide

This is an excellent, feature rich, 56-page Excel Tutorial, titled Your Guide To Microsoft Excel XP, hosted by the San Antonio Independent School District. Many Excel features are presented and  taught this Excel tutorial including the following: Menu Bar, Toolbar area, entering and formatting data, working with columns and rows, formatting cells, navigating and managing worksheets, using formulas, and creating charts and graphs. You can take a quiz at the end to test your Excel knowledge. This Excel tutorial is located on this site’s MS Office XP Tutorials page.


Excel XP Tutorial and Guide
(56 pages, 1.8mb, pdf format)

What is Excel XP
   What Should you consider before beginning?
Beginning Basics
   Opening Excel XP
   Parts of the Excel window
   How to get help in Excel SP
   Help options found on the Menu Bar/Toolbar Area
      Screen Tips
      The Office Assistant
      Ask a Question Wizard
      The What’s This arrow
Working with Worksheets
   Entering data into a worksheet
   Formatting problems with data entry
   Changing the appearance of Columns and Rows
      Resizing column widths
      Resizing row widths
   Inserting and Deleting Columns and Rows
      Inserting new Columns
      Inserting new Rows
      Deleting Columns
      Deleting Rows
   Changing the appearance of Cells
      Selecting Cells
      Adding color to cells
      Adding borders to cells
   Navigating a worksheet and/or workbook
      Scrolling up and down
      Scrolling left and right
      Switching between worksheets
   Inserting, deleting, naming, and moving a worksheet
      Inserting a worksheet
      Deleting a worksheet
      Naming a worksheet
      Moving a worksheet
Using Formulas
   Simple Formulas
      Errors found in formulas
      Relative cell references
      Using fill option
      Absolute cell references
   Functions
      Types of functions
      Example of AVERAGE function
      Using the AutoSum icon
   Linking Formulas
Creating Charts or Graphs
   Using the Chart Wizard
Copying a worksheet into MS Word
   A simple copy and paste
   Inserting a worksheet
Helpful Information
Test for Knowledge
   Create the following in MS Excel XP
   Mini MS Excel XP Quiz
Evaluation Form
   Geometric Reflection and Evaluation
Resources, Links & Citations


Tags for this post>>

October 25, 2007

Guide and Tutorial for Word XP

Here is a great 44-page Word Tutorial, titled Your Guide To Microsoft Word XP, provided by the San Antonio Independent School District. Features taught and demonstrated by this Word tutorial include: Views, Text, Fonts, Tables, Borders, Clip Art, Word Art, and Pictures. It includes a quiz at the end you can take to test your Word knowledge. This website’s Technology Literacy Institute offers several excellent web-based Office tutorials and software learning resources. This Word tutorial is located on their MS Office XP Tutorials page.


Guide and Tutorial for Word XP
(44 pages, 1.2mb, pdf format)

Topics   Page
What is Word XP?
   What should you consider before beginning?
   Plan Ahead!
MS Word XP Basics
   Window Overview
   How to get help in Word
   Help options found on the Menu Bar/Toolbar area
   Screen Tips
   The Office Assistant
   Ask a Questions Wizard
   The What’s This arrow
Different Views in Word XP
   Different Views
Working with Text
   Working with Font types, size and color
   Working with the Alignment
Working with Borders and Tables
   Creating Page Borders
   How to add a border to a page
   How to add color to your border
   How to add standard text to your certificate
   Creating a table to add non-standard text
   Inserting a table
   To Center a Field
   To change the Size of a Cell in aTable
   to Eliminate Unnecessary Borders around the Cell
Working with Clipart
   How to Insert Clip Art
Working with Wort Art
   How to Insert Word Art
Working with Pictures
   How to Insert a Picture
Helpful Information
   Use the Help Options to find out more
Test for Knowledge
   Create the following in MS Word XP
   Mini MS Word XP Quiz
Evaluation Form
   Geometric Reflecitons and Evaulation
Software Integration—Content Area
   MS Word XP Integration
Resources, Links & Citations


Tags for this post>>

Photoshop 7 Tutorial

This Photoshop 7 Tutorial, titled ‘Getting Started with Adobe Photoshop’, the fundamentals of using many Photoshop’s features when working with your digital images. Using this tutorial gives you a great way to increase your working knowledge of Photoshop and its functionality. This tutorial demonstrates and teaches you the following Photoshop functionality: Photoshop Interface, File management, Toolbar, Image menu, Layer management, working with Text, amd creating Graphics.  This Photoshop tutorial is located on the Graphics and Multimedia Tutorials page at the University of Texas.

 
Photoshop Tutorial Contents:

  - Familiarizing Yourself with the Photoshop Interface
  – Opening/Creating files
  – Using the Toolbar
  – Using the Image Menu
  – Layer Management
  – Working with Text
  – Creating Graphics
  – Tips & Fun Stuff
  – Evaluate this tutorial
  – PDF Handout
  – Tools PDF Handout


Tags for this post>>

October 24, 2007

Web Outlook Tutorial Guide

Here is an excellent Web Outlook Tutorial Guide, complete with well produced screen illustrations, step-by-step instructions, and explanations of everything you need to know to use this web email tool to its fullest extent. This is a free training document and published by the San Antonio Independent School District. Document format is pdf.


Your Guide To Microsoft Web Outlook
(85 pages, 3.7mb, pdf)


Individual Chapters of Web Outlook Guide
:


Chapter 1 – Overview
– 14 pages

What is Microsoft Web Outlook?
What should you consider before beginning?
How to access MS Web Outlook
Parts of the MS Web Outlook Window
   Shortcut View
   Folders View
Parts of the Inbox
   The Different Views
   The Inbox Toolbar
   Inbox Items

Chapter 2 – Your Inbox
- 14 pages
Working in the Inbox
   How to create a new message
   Important Inbox Items
   Important Inbox Definitions
Working with messages
   Searching for a message
   Deleting a message
   Recover a message from the Deleted Items Folder
   Emptying the Deleted Items folder
   Recover Deleted Items
   Saving a message to your computer
   Printing a message
Working with attachments
   Sending an attachment
   Opening an attachment
   Common file extensions for attachments

Chapter 3 – Options in Web Outlook
– 8 pages
Message Options
   Formatting a message
   Changing your message options
Other Options in Web Outlook
   Using the Outlook Assistant
   Turn off Out of Office Assistant
   E-mail Options
   Reminder Options
Working with your Password
   How to change your password

Chapter 4 – Working with Others – 24 pages
Working with Contacts
   Adding new contacts
   To find a contact
   Send a message to a contact
   Delete a contact
Working with Distribution List
   Creating a Distribution List
   Send a message to members of a Distribution List
Working with the calendar
   Date Navigator
   Selecting a View
   Creating appointments
   Creating recurring appointments
   Planning a meeting
   Reschedule a meeting
   Cancel a meeting
   Replay a meeting request
How to Forward e-mail from your Staff mail account
How to Log Off your account

Appendix - MS Web Outlook
– 17 pages
Helpful Information
    Keyboard shortcuts for working with Outlook messages
    Microsoft Web Outlook 2000 Quick Reference Card
Test for Knowledge
    Create the following in MS Web Outlook
    Mini MS Web Outlook Quiz
Software Integration
    Web Outlook Integration
Resources, Links & Citations

Outlook Training Materials for creating Personal Outlook Folders - 8 pages


Tags for this post>>

Dreamweaver MX 2004 Tutorial

Here is a good Dreamweaver MX 2004 Tutorial, from the University of Texas, that describes how to do many important tasks using this web development application. When finished reading and using it, you will have the understanding to easily create new web pages.


Tutorial Objectives:

  • Explore interface, menus & properties manager
  • Create a basic web page
  • Add text, links, tables and images
  • Change fonts and alignment
  • Review transferring files and images to the server and learn techniques for effective management of your server space

Contents of Dreamweaver MX 2004 Tutorial:

  - Getting Started
  – Connecting to Your Server Space
  – Creating Your Page
  – Inserting Images
  – Inserting Tables
  – Links
  - Anchors
  - Page Properties
  – Resources
  - Evaluate this tutorial
  – PDF Handout

Tags for this post>>
October 18, 2007

2 Dreamweaver MX Tutorials

Here are two Dreamweaver MX Tutorials from the University of Texas, located on their Web Devleopment Tutorials page. The first one helps you get started creating your web site, and the second tutorial teaches you more Dreamweaver features, such as inserting Flash objects, applying CCS to your pages, creating and using Dreamweaver Templates, and creating a web photo album.


Dreamweaver can simplify many of the complexities involved with creating a web page or site. However, in order to utilize all of the functionality of Dreamweaver, a site must be created. This first Dreamweaver tutorial will help you do just that: Creating Your Site with Dreamweaver MX.

Tutorial Contents:

  – Saving Your Page
  – Insert a Table
  – Insert an Image
  – Links & Anchors
  – Font & Color
  – Preview & Post
  – Evaluate this tutorial

Print a Handout:



This second Dreamweaver MX tutorial, named Even More Dreamweaver MX Tutorial, teaches and demonstrates more design functionality using Dreamweaver MX. At the completion of this tutorial, you will know:

  1. How to create your Web page in layout view
  2. How to insert Flash Text and Flash Button objects
  3. How to apply Cascading Style Sheets to your Web pages
  4. How to create and use Dreamweaver Templates
  5. How to create a Web Photo Album
Even More Dreamweaver Tutorial Contents:

  - Page Layout
  – Flash Button and Flash Text
  - Cascading Style Sheet
  - Templates
  – Web Photo Album
  - Evaluate this tutorial
  - PDF Handout



Tags for this post>>
October 15, 2007

Two HTML Tutorials and a CSS Tutorial

Here are two HTML Tutorials and a CSS Tutorial from the University of Texas. These will help you learn the fundamentals of both HTML markup language and CSS (cascading style sheets) to design and create your web pages and web sites.


Basic HTML Tutorial



Even More HTML Tutorial

This HTML tutorial teaches you how to create a web page resume using a text editor with HTML. It shows you how to center and justify text, create tables in HTML, build lists, insert a footer, and add meta tags. 

Objectives of this HTML Tutorial:

  • Center and justify text
  • Design a web page table with rows and columns of text
  • Write the HTML for an invisible table that creates side-by-side columns
  • Create a table that has different colored cells
  • Build a list of items with indented text block definitions
  • Insert a footer at the bottom of your Web page
  • Add embedded information that will help others find your site using Internet searches


Even More HTML Tutorial Contents
:



What Is CSS?

CSS is an acronym for Cascading Style Sheets. A style sheet is a text file coded to control the rendering and display of web content marked up using HTML. Style sheets are used to make it easier to manage a web site because a single style sheet can control multiple web pages. Using CSS on your web site permits more flexibility, saves time, provides for more efficient site maintenance, and decreases download times.

CSS Tutorial Contents:



Tags for this post>> | |
October 11, 2007

5 Free Book Chapters for Dreamweaver

Here are 5 free Book Chapters for Dreamweaver, from friendsofed.com, four for Dreamweaver 8 and one for Dreamweaver CS3. These will show you how to do the following in Dreamweaver: work with images, web page layout, create a blog and a photo gallery, and create site navigation.


Chapter 6: Working With Images
28 pages, 1.9mv
from Foundation Web Design with Dreamweaver 8

  • Choosing the best image format
  • Avoiding common errors
  • Adding images to web pages
  • Editing images
  • Styling images

Chapter 9: Beginning Page Layout In Dreamweaver
20 pages, 764kb
  • Types of web page layout
  • How to create frames with Dreamweaver
  • How to create and edit tables
  • How to work with Cascading Style Sheets
  • How to set page defaults

Chapter 11: Displaying A Blog and Photo Gallery
32 pages, 679kb
from Foundation PHP for Dreamweaver 8
  • Storing and formatting dates in MySQL
  • Handling image details in a database
  • Displaying a message when no records are found
  • Alternating the colors of table rows
  • Displaying an extract of a long text item
  • Using Live Data view with a URL parameter
  • Dynamically generating the code for the dimensions of an image
  • Using a commercial extension to loop horizontally

Chapter 9: Creating A Blog
25 pages, 754kb
from Foundation ASP for Dreamweaver 8


Chapter 7: Building Site Navigation With The Spry Menu Bar
26 pages, 1.4mb
from The Essential Guide to Dreamweaver CS3

Tags for this post>>

PowerPoint Tips and Guidelines

Here are 9 PowerPoint Tips and Guidelines Documents, in pdf format. These tips will help you use many features of PowerPoint more efficiently with greater ease, and create more attractive and compelling to your audience.


PowerPoint Tips
PowerPoint Tips. design Keys for Classroom Presentations. Inclusiveness. Typography. Design. Serif vs. Sans Serif. fonts styles 


General PowerPoint Tips
General PowerPoint Tips. The graphics you project on the screen to support what you say should help clarify. ideas, emphasize key points, show relationships


PowerPoint Tips to A Better Presentation
Here are ten tips to help you create a better slide presentation.


PowerPoint Design Tips

  • Do not Overuse Effects or Overcrowd Slides
  • Use Bulleted Points Effectively
  • Think Like Someone in Your Audience
  • Never Forget Your Conclusion Slide
  • Don’t read your presentation
  • Slide Design Elements

PowerPoint Tool Tips

  • Changing the template (background)
  • Changing the colors on a slide
  • Adding clip art
  • Repositioning clip art
  • Resizing clip art
  • Adding animation to clip art or text
  • Adding transitions between slides
  • Changing text on action buttons

Supplemental PowerPoint Tips
  • Reduce the Chances of File Corruption
  • Blanking the Screen During a PowerPoint Slide Show
  • Changing from Cursor to the Pen During a PowerPoint Slide Show
  • Reducing the size of PowerPoint files

PowerPoint Shortcuts, Tips, and Tricks
  • Presentation Tips
  • Display Shortcuts During a Slide Show
  • Keep Track of Action Items During a Slide Show
  • Take a Break During a PowerPoint Slide Show
  • Using Ctrl-Drag to Copy
  • Preview Slide Show Effects
  • Making Presentation Files Smaller

Tips for Creating and Using Effective PowerPoint Presentations
  • Hints for a successful presentation
  • Effective PowerPoint slides
  • Text guidelines
  • Clip art, graphic and other features

PowerPoint Guides, Tips, and Help
  • Keep It Simple
  • Brainstorm
  • Slide Design
  • Color
  • Template Galleries
  • FAQs


Tags for this post>>
October 10, 2007

Flash 8 Tutorials eBook

This is a free Flash 8 Tutorials eBook, from Macromedia, providing step-by-step Flash tutorials that teach and demonstrate the fundamental features of using Flash 8. It is suggested that you use these Flash lessons with the sample files located in the Samples and Tutorials folder in the Flash installation folder. The path to the sample file is provided in each lesson. By using these Flash tutorials, you will learn how to create a Flash document, add text, graphics, and animation to your Flash applications, write ActionScript, work with video and video control behaviors, and add a Flash component. These lessons are for beginners to intermediate-level Flash designers and developers who want to learn the features of Flash quickly. Each Flash tutorial lesson takes about 10 to 20 minutes to finish. This pdf document is 290 pages in length and 3.1mb in size. Also available at this site are these free Flash ebooks: Using Flash, Learning Actionscript 2.0 in Flash, Getting  Started with Flash, Extending Flash, and Using  Components.


Contents of Flash 8 Tutorials eBook
:

  • Chapter 1: Basic Tasks: Create a Document
  • Chapter 2: Basic Tasks: Creating a banner, Part 1
  • Chapter 3: Basic Tasks: Creating a banner, Part 2
  • Chapter 4: Basic Tasks: Creating a banner, Part 3
  • Chapter 5: Basic Tasks: Create Accessible Flash Content
  • Chapter 6: Basic Tasks: Work with Layers
  • Chapter 7: Basic Tasks: Create an Application
  • Chapter 8: Basic Tasks: Use Layout Tools
  • Chapter 9: Basic Tasks: Create Symbols and Instances
  • Chapter 10: Basic Tasks: Add Button Animationstep-by-step tutorials
  • Chapter 11: Basic Tasks: Create a Presentation with Screens
  • Chapter 12: Creating Graphics: Draw in Flash
  • Chapter 13: Creating Graphics: Create a Timeline Animation
  • Chapter 14: Creating Graphics: Making Animations
  • Chapter 15: Creating Graphics: Applying Gradients
  • Chapter 16: Creating Graphics: Apply Graphic Filters
  • Chapter 17: Text: Add Text to a Document
  • Chapter 18: ActionScript: Use Script Assist mode
  • Chapter 19: ActionScript: Write Scripts
  • Chapter 20: ActionScript: Add Interactivity
  • Chapter 21: ActionScript: Create a Form with Conditional Logic and Send Data
  • Chapter 22: ActionScript: Work with Objects and Classes
  • Chapter 23: Data Integration: Overview
  • Chapter 24: Data Integration: Using the Macromedia Tips Web Service
  • Chapter 25: Data Integration: Using XML for a Timesheet
  • Chapter 26: Data Integration: Using XUpdate to Update the Timesheet


Tags for this post>>

36 Excel Tutorials and Learning Manuals

Here are 36 Excel Tutorials and Learning Manuals, in pdf format, courtesy of acrobatfiles.com. These are located in their Microsoft Office section. They cover many topics and features of Excel that will help you use this spreadsheet application more effectively, especially with functions and formulas. Most of these free Excel training and tutorial documents are located at higher education and university web sites. You may have to register for free at this site.


Excel Tutorial
Measuring Evaluation Results with Microsoft Excel. The purpose of this tutorial is to provide instruction on performing basic functions using Microsoft …

Tutorial: Microsoft Office Word 2003: Collaboration Introduction
Tutorial: Microsoft Office Word 2003:. Collaboration. Introduction:. In your work, you may find that you need to create and edit text documents with …

Excel Tutorial Commonly used Excel functions
This tutorial will introduce you to some essential features of Excel that we … Parts of this tutorial borrow from Albert Whangbo’s Excel Solver Tutorial. …

Excel Tutorial: How to use Excel for Graphs and Calculations
Excel Tutorial: How to use Excel for Graphs and Calculations. Excel is powerful tool and can make your life easier if you are proficient in using it. You …

Microsoft Excel Tutorial Handout The Excel Screen
Microsoft Excel Tutorial Handout. Opening Microsoft Excel. 1. Click on the Start button. 2. Click on Programs. 3. Click on Microsoft Excel. The Excel Screen …

Tutorial: Microsoft Office Excel 2003 Introduction: Opening Excel
Tutorial ‘ Microsoft Office Excel 2003. Introduction:. Microsoft Excel is the most widespread program for creating spreadsheets on the. market today. …

Using Excel Tutorial
Click on the title to take you directly to a specific part of this tutorial booklet. Introduction to Excel. Adding Worksheets, Rows, and Columns …

Excel 2003 Tutorial I
Excel 2003 – Tutorial I. Use the mouse to select a cell you want to begin adding data to …

Tutorial Selected Applications OF MS Excel
Summary of cell contents for Excel tutorial. Cells. Entry. C8 : E13. As shown in Table 1. H15. As shown in Table 1. C14. Excel toolbar …

Excel 2003 Tutorial II
Excel 2003 – Tutorial II. Cchart allows you to visually display your data. Chats help users compare data and identify …

Setting Up Linear Programs In Excel
This tutorial will introduce you to some essential features of Excel and its plug-in, Solver, …. Excel Solver Tutorial.  Solver Output Options …

Using formulae and functions in Microsoft Excel 2003
It thinks about where cells. are in relation to the cell in which the formula is entered. Guide 35: Using formulae and functions in Microsoft Excel 2003 …

Microsoft Excel, Part II
Microsoft Excel, Part II. Displaying, Im porting and Analyzing Data. Displaying Data. Allyson Mower, Instructor  …

Introduction Topics Advanced Microsoft Excel: Formulas and Functions
II. Manipulating Formulas. III. Conditional Functions. IV. Lookup Functions. Advanced Microsoft Excel: Formulas and Functions …

MS Office Excel 2003 Basics
Microsoft Excel Help - Displays a search window for Microsoft Excel help topics.  Toolbar Options – Gives you the option to Show buttons on One Row or …

Simple MS Excel Formula Example
Simple MS Excel Formula Example. With Excel, it is easy to sum and average your data. Here’s how to insert a formula:. 1. Click on a cell (where you would …

A Tutorial for Excel 2002 for Windows
Using Charts with Microsoft Excel 2002. A Tutorial for Excel. 2002 for Windows. Author: Information Systems Services. Date: August 2004. Edition: 2.0 …

Using Grade Book with Microsoft Excel
If you want to use Microsoft Excel to manage your Grade Book, you can. upload and download your Grade Book to and from Vista. …

Microsoft PowerPoint 2007
When you open Powerpoint 2007, you will notice that it looks quite … This tutorial uses PowerPoint 2007 and you can use it as a quick reference guide for …

Introductory Exercises In Microsoft Excel 2000 This document
Getting Started With Microsoft Excel (BEG 17) document available from. the Help Desk. … Writing Formulae with Microsoft Excel 2000 (TUT 47) …

Intermediate Excel for Windows
included with it, as shown below. Just click on Help Microsoft Excel Help. - You can also learn more about Excel at the Microsoft web site: …

The Misuse of RC4 in Microsoft Word and Excel
This kind of mistake takes place in the Microsoft Office (Word and Excel) … Microsoft Office (Word or Excel) document with a password and save that file. …

Problems With Using Microsoft Excel for Statistics
However, Excel’s help for statistics is quite poor. …. Distributions in Microsoft Excel 97,. Computational Statistics and Data Analysis,. 1998, 26, pp. …

Getting Started with Excel
Microsoft Excel Help. window. Enter the topic that you would like help on. and click on … Microsoft Excel features extensive help guides and …

Beginning Excel for Windows
Just click on Help Microsoft Excel Help.  You can also learn more about Excel at the Microsoft web site.

Microsoft Excel: Excellent Gradebooks

Using Microsoft Excel to keep track of your Students’ Grades ….. To access Excel’s Help screens for. formulas, choose Help on the toolbar, and then click …

Vista Gradebook with Excel
Improving Vista Gradekeeping Using Excel. Page 3. Step-By-Step  Exporting Grade Book. The following instructions are specific to Microsoft Excel. …

Tutorial 1 2007 Excel for statistical data analysis
Tutorial 1. 2007. Excel for statistical data analysis. When using a computer in one of our labs, move the mouse to activate the screen. Do …

Financial Management
Reports in Microsoft Office Excel. Execute and display multi-level reports in Office Excel for easy. manipulation, integration of non-accounting business …

Excel: Functions & Data Analysis Tools
A function is a predefined formula that performs calculations by using … the formula bar (=) or the Paste Function button ( ) on the Standard. toolbar. …

Analytical Accounting
Reports in Microsoft Office Excel. Multi-level reports are executed and displayed in Excel for easy manipulation,. integration of non-accounting business …

Excel Formulas & Functions
your formula. Inserting a function. Each of Excel’s functions is a predefined formula, and most act on. a range of cells that you select. …

Excel XP/2000: Formulas and Functions
To create a formula that begins with an Excel function, select Function… from the … the Insert Function button the fx button located in the formula bar. …

Excel Basics: Formulas and Functions
Some functions operate on groups of cells. We describe those groups in the formula by. their upper left-hand and lower right-hand cells separated by a colon …

Formulas and the Sum Function in Excel
05/04/04. Formulas and the Sum Function in Excel. Quick Reference Guide. To Sum a Column of Values. 1. Click in the cell in which to enter the formula. …

Excel Lesson
Identify the parts of a function formula. Use the AVERAGE, COUNT, MAX, and MIN. functions. … Function Formulas. A function formula has three components: …

Tags for this post>>

October 9, 2007

Mail Merge Tutorial

Mail Merge is what you need to do, using Word and Excel, to copy one row of information at a time from a spreadsheet document into a Word document. Using this Mail Merge Tutorial, you will create personalized letters and mailing labels using these two documents. Using this technique, you do not have to manually edit each letter and label over and over again, thus saving work and time. To perform a mail merge, you will need a Word dcoument and an Excel spreadsheet with similar data in each row, signifying a record.

After reading this Word Excel Mail Merge tutorial, you will be able to:

  1. Create a new mail merge from a document and a data source using the PC Mail Merge Sidebar Wizard.
  2. Edit an existing merged document using the Mail Merge Toolbar.
  3. Get a taste for creating and editing mail merge on a Mac.

Mail Merge Tutorial Contents:

  – Part I: Creating Mail Merge on a PC

  - Steps 1 & 2: Starting the Mail Merge Process

  – Step 3: Linking to the Data Source

  – Step 4: Inserting Merge Fields

  – Step 5: Previewing the Merge

  – Step 6: Completing the Merge

  – Part II: Mail Merge Toolbar or Maillings Tab on a PC

  – Part III: Tips and Tricks

  – Part IV: Data Mail Merge Manager on a Mac

  – Additional Resources

  – Evaluate this tutorial

  – PDF Handout

Tags for this post>>

Visio 2003 Tutorial

Here is the Visio 2003 Tutorial from the University of Texas. Visio allows you to draw and render ideas, concepts, and structures into a visual representation. This application gives you already defined shapes, symbols, backgrounds, and borders to work with. This Visio tutorial teaches you how to create flowchart diagrams, and demonstrates how a web design wire frame and an organization chart look in Visio after they are  drawn. After going through this tutorial, you can try out the tools to create other kinds of charts and graphs, and web diagrams. 

You will learn the following Visio features:

  • Open a new Visio document
  • Create a flowchart diagram using shapes and connectors
  • move or add shapes
  • Add text to a diagram and format the text
  • Create a background
  • Modify the color palette
  • Add a hyperlink
  • Print a diagram or insert it into a PowerPoint or Word document
  • Edit a diagram while remaining in PowerPoint or Word  

Visio 2003 Tutorial Contents:

  – Getting Started and Navigating in Visio

  - Creating a New Diagram

  – Adding and Modifying Text

  – Creating a Background

  - Modifying the Color Scheme

  - Adding a Hyperlink

  – What to do with Your Visio Drawing

  - Other Types of Visio Drawings

  – Resources

  - Evaluate this tutorial

  - PDF Handout

Tags for this post>> |
October 8, 2007

Microsoft Access 2003 Tutorial from the Univeristy of Texas

Here is the Microsoft Access 2003 Tutorial written and hosted by the University of Texas. Using this Access tutorial, you will learn how to use and apply database concepts and operations. It demonstrates step-by-step how these are accomplished in Access 2003. This tutorial covers frequently-used Access features, such as the creating tables, developing queries, entering and editing data, sorting and finding records, and importing spreadsheet into Access.


Access Tutorial Objectives
:

  • Launch Access and identify the parts of the screen
  • Define fields and field properties constructing table structures
  • Enter and edit records in a table
  • Find, sort data
  • Design custom queries to display data
  • Import data between Excel and Access

Access 2003 Tutorial Contents:

  – Definitions

  - Access VS. Excel

  – Starting Access and Opening a Database

  – Database Components

  – Creating Tables in Design View

  – Adding and Deleting Fields to Tables

  – Entering and Editing Data

  – Sorting and Finding Records

  – Table Relationships

  – Creating Queries

  – Importing Excel Data to Access

  – Additional Resources

  – Evaluate this tutorial

  – PDF Handout

Tags for this post>> |

51 Photoshop Learning Documents

AcrobatFiles.com provides free documents, learning and training materials, and articles for many software products. Here are 51 Photoshop Learning and Training Documents in their Software category, all are in pdf format. Included here, at the bottom, are five documents covering Adobe InDesign and one for Adobe Illustrator.


Documents to Help You Learn  Photoshop:

Adobe Photoshop CS2
process with the Stove-with-. Clock file. Double-click directly. on each layer’s name and give. them descriptive names. Photoshop Tutorials. …

Adobe Photoshop CS3
Adobe Photoshop CS3 User Guide. This guide, a subset of Help, contains feature descriptions.

Photoshop Tutorial
Photoshop Tutorial. University of Chicago Computer Science Instructional Laboratory.

Photoshop 7 Basic User Manual
Having successfully completed the Photoshop Module Basic I, … what you want to do with Photoshop. 

Photoshop Tutorial: Ray of Light 1. 2. 3.
Photoshop Tutorial: Ray of Light Tutorial. Page 1 of 7. Written by Trevor Morris

What is Adobe Photoshop 7.0 – Opening Adobe Photoshop 7.0 – Creating
Photoshop, now up to version 7.0, is the leading professional image-editing program, … Photoshop is useful for both creating and editing images to be …

Adobe Photoshop CS3 Adobe PhotoshopCS3Extended
platforms: Adobe Photoshop CS3 and Adobe Photoshop CS3 Extended. … Q. Who should be interested in Photoshop CS3 Extended either as a stand-alone product …

Creating a Border Background with Photoshop – Adobe Photoshop
Creating a Border Background with Photoshop – Adobe Photoshop Tutorial … This tutorial will also work with newer versions of …

Photoshop Tutorial: Rounded Corners 1. 2. 3.
Photoshop Tutorial: Rounded Corners. Written by Trevor Morris

Adobe Photoshop CS3 – Introduction
Adobe Photoshop CS3 – Introduction. Duration:2 days. Course Synopsis:. This class provides you with the concepts and skills to use Adobe Photoshop CS3 …

Top 10 Photoshop CS3 Features for Easing Your Workflow
Since the day Adobe released the public beta version of Photoshop CS3, … Besides being the most apparent change when you launch Photoshop CS3, the new …

Adobe Photoshop Elements Adobe Premiere Elements
Adobe Photoshop Elements 5.0 plus Adobe Premiere. Elements 3.0 software combines two … Adobe Photoshop Elements. 

Adobe InDesign CS3 Scripting Tutorial
Adobe InDesign CS3 Scripting Guide contains. hundreds of tutorial ….. Adobe InDesign CS3 Scripting Tutorial. Scripting and the InDesign Object Model 8 …

Introduction to Photoshop Tutorial Supplement
Introduction to Photoshop. Tutorial Supplement. Haas Computing Services. Making an Image From Scratch. We’ll briefly demonstrate a very …

Mastering Photoshops Interface
Mastering Photoshop?s Interface. By Steve Broback, Avondale Media. Adapted from Secrets of the Photoshop Masters,. an instructional DVD from Avondale Media, …

Adobe Photoshop CS3 What’s New
Photoshop CS3 speeds the path from imagination to imagery. … What’s New in Photoshop CS3 covers the features and enhancements that are …

Adobe Photoshop CS3 Extended for Film & Video Professionals
Adobe Photoshop CS3 Extended starts with the comprehensive. toolset of the professional standard in digital imaging, and adds …

Photoshop & After Effects Get Your Toolbox Out
Mastering Photoshop is an important step in. mastering After Effects. In fact, 80% of my After. Effects work is completed in Photoshop. With the …

What’s New in Adobe Photoshop CS3
the first prototype version of Photoshop. Photoshop CS3 … Figure 1.2 The new Photoshop CS3 Mac OS X layout. In this screenshot the …

Adobe Photoshop CS3 Extended for Manufacturing
Adobe Photoshop CS3 Extended software adds powerful new. features and enhancements to the professional standard in digital …

Adobe Photoshop CS3 Scripting Guide
Photoshop CS3. Adobe Photoshop CS3 Scripting Guide. Photoshop CS3 Scripting Basics 8. A single script can perform actions that involve multiple …

Adobe Photoshop Cs extended
between Photoshop CS3 Extended and Acrobat 3D software. Convert myriad 3D CAD formats to the robust U3D interchange format, enhance models and create …

Adobe Photoshop CS3 Extended for AEC
Adobe Photoshop CS3 Extended starts with the professional. standard in digital imaging, and adds powerful new features …

Whats New in Adobe Photoshop CS3
Figure 1.2 The new Photoshop CS3 Mac OS X layout. In this screenshot the …. Figure 1.13 In this example I wanted to sample from the letter ?O? on the left …

The Photoshop CS3 Interface
CS3 is the new interface design, which is part of a wider … Figure 5 This is the Photoshop CS3 interface showing the default layout for all. the palettes. …

Introduction to Photoshop Information and Instructional Technology
Channels: Adobe Photoshop uses channels in two ways: to store color information about … A path is any line or curve you draw using the Photoshop …

Production Information Graphic Design & Photography
Maximum halftone density: 1270 ? Line screen: 110 lpi. Picture resolution (at correct size): Newsprint 220 dpi, Photoshop. ads 600 dpi, Glossy ads 300 dpi …

Why your Photoshop color separations are wrong and how to fix
Adobe Photoshop?s Working Color Space allows the image to exist on a parallel … highlights, measurably deeper shadows on glossy …

Quick reference guide to the top reasons to upgrade
Photoshop CS3 Extended for specialized image editing, Illustrator CS3 for vector … Quick reference guide to the top reasons to upgrade. Continued Page 2 …

lynda.com Announces Release of Photoshop CS3 Extended for 3D and Video
Photoshop CS3 Extended adds revolutionary support. for 3D and video files. In Photoshop CS3 Extended … A separate DVD version of Photoshop CS3 Extended …

Mastering Photoshops Interface
Mastering Photoshop?s Interface. By Steve Broback, Avondale Media. Adapted from Secrets of the Photoshop Masters,. an instructional DVD from Avondale Media, …

Photoshop Elements
Elements. 5.0. ?. New or enhanced feature. Product overview. Adobe Photoshop Elements 5.0 software combines power and simplicity so you can …

Photoshop & After Effects Get Your Toolbox Out
Mastering Photoshop is an important step in. mastering After Effects. In fact, 80% of my After. Effects work is completed in Photoshop. With the …

Advanced After Effects & Photoshop
animations. Mastering Photoshop is an important step in mastering After Effects. In fact, 80% of my After Effects work. is completed in Photoshop. With …

Photoshop Elements
Elements. Macintosh. 

Enterprise Deployment Options for Adobe Creative Suite 3 Editions
Adobe InCopy CS3. Adobe Creative Suite 3 Web Standard. ? Adobe InDesign CS3. Adobe After Effects CS3. ? Adobe Photoshop CS3. Adobe Contribute CS3 …

Photoshop Elements
Elements. 4.0. FEATURES. Product overview. Adobe Photoshop Elements 4.0 software combines power and simplicity to help you do …

Instructions for using custom profiles in Adobe Photoshop when
Close Photoshop ? profiles will not appear if installed when Photoshop is … When using Kodak Premium Rapid-Dry Photographic Glossy or Luster/ 260g: …

Using ICC Colour Profiles 1. Printing with ICC profiles
Photoshop version 5.x and version 6 are ICC aware but vary in the …. Glossy Film. Custom. Photo-. 1440dpi. High Quality. Color Controls. Automatic …

Digital SIG Graphics Demo Combining Adobe Illustrator & Adobe
essential things to master using Photoshop . If you have any weakness with these tools. it will just make your road to mastering Photoshop a lot steeper and …

Adobe Photoshop CS3 Extended for medical professionals
digital medical images, Photoshop CS3 Extended can assist you with patient care, … Photoshop CS3 Extended software?s unmatched range of high-quality …

Photoshop Elements
Adobe Photoshop Elements 5.0 software combines power. and simplicity so you can make your photos look their. best; show them off in creative, …

Digital SIG Graphics Demo Combining Illustrator & Photoshop
Essential things to master using Photoshop . If you have any weakness with these tools. it will just make your road to mastering Photoshop a lot steeper and …

Creating Border Backgrounds with Photoshop CS3, Adobe Photoshop
Although this tutorial is geared for making Web graphics with Photoshop. CS3, it also works for Photoshop 5.5 and above. This tutorial will also work with …

Adobe Photoshop CS Tutorial
Adobe Photoshop CS 3. Getting Started. Begin by opening Adobe Photoshop …. In this tutorial, only the basic tools will be discussed in depth. …

Photoshop Tutorial : Making Colored Sketches Out of Photos Here
So as you can see, in this tutorial you will learn how to make a colored sketch out. of a normal photograph. Step 1: Open the file you will be working with …

Using Curves Function in Photoshop 7, CS, CS2, CS3 and PSE 5
INTRO TO CURVES FUNCTION IN PHOTOSHOP 7, CS, CS2, CS3. by Kim Hill. If you have any questions about this tutorial …

PhotoShop 7.0 Tutorial- Character Masking
PhotoShop 7.0 Tutorial- Character Masking. 1. Open PhotoShop and go to File. then click on Open. 2. Select the picture you want for. your character mask. …

PhotoShop 7.0 Tutorial- Extraction
PhotoShop 7.0 Tutorial- Extraction. 1. In PhotoShop, open a picture. To do this, go to FILE then OPEN. 2. Select the picture you desire and click OPEN …

Editing Images with Adobe Photoshop 7.0
In an earlier section of this tutorial, you saved an image with a. transparent background, using the GIF89a Export command. An image can …

3D Transformation Tutorial- PhotoShop 7
3D Transformation Tutorial- PhotoShop 7. Sphere Shape:. 1. Open a picture (RGB). 2. Go to File > New and create a text in a new window- NOTE: make …

Adobe Illustrator CS3 At A Glance for Adobe Creative Suite 3
Top features for post-production in Adobe Illustrator CS3. New Document Profiles?Select pre-built profiles specifically for video that automatically …

Adobe InDesign CS3 Scripts Read Me Tutorial
Adobe InDesign CS3 Scripting Tutorial, Introduces InDesign scripting. … InDesign CS3 Tutorial Scripts.zip. ?. InDesign CS3 Guide Scripts.zip …

Adobe InDesign CS3 Scripting Tutorial
Placing InDesign Files. InDesign CS3 provides the ability to place an InDesign file. Sample code demonstrating the Place feature is …

Adobe InDesign CS3 Scripting Tutorial
InDesign CS3 includes the following sample scripts: … Sample Scripts ReadMe for Adobe InDesign CS3. Installation 2. Installation …

InDesign CS3 For Dummies: Setting Up Your Printer
InDesign For Dummies. To see whether your printer is actually installed correctly, …. InDesign For Dummies.

Tags for this post>>

October 5, 2007

PowerPoint 2003 Tutorial from the University of Texas

Here is a well written PowerPoint 2003 Tutorial, from the University of Texas, that will help you get up to speed with using many features of PowerPoint. You will also learn what these PowerPoint terms mean and how to use them: Presentation, Slides, Layout, View, Design Template, Slide Show, Placeholder, and Sizing handles. Most of the topics demonstrated in this Excel tutorial can also be used in earlier versions of Excel.


This PowerPoint tutorial teaches the following:

  • Start PowerPoint
  • Work with layouts, text, and slides
  • Work with templates and images
  • Work with drawing tools
  • Use different views and printing options
  • Put your presentation on the World Wide Web
  • Identify and employ elements of a good presentation

PowerPoint 2003 Tutorial Contents:

  – Starting PowerPoint

  - Layouts, Text and Slides

  - Design Templates and Images

  – Drawing Tools

  - Views and Printing

  - Displaying your Presentation on the WWW

  – Elements of a Good Presentation

  – Tips and Additional Resources

  – Evaluate this tutorial

  - PDF Handout

Tags for this post>> |
Next Page »