Free Microsoft Office Training and Tutorial Resources




    



February 9, 2006

Training Workshops for Microsoft PowerPoint, Excel, and Access

Mississippi State University offers the some great free training materials, tutorials, and workshops. Here is their content for Microsoft PowerPoint, Excel, and Access. All of these workshop training handouts are provided in PDF format. In addition to the handouts, the Powerpoint presentations and exercise files used during the workshop are provided.


Microsoft PowerPoint Training Workshops

Introduction to Microsoft PowerPoint 2003


Microsoft PowerPoint 2003 II


Introduction to Microsoft PowerPoint 2000


Microsoft PowerPoint 2000 II


Introduction to Microsoft PowerPoint 97

Microsoft PowerPoint 97 II


Microsoft Excel Training Workshops

Introduction to Microsoft Excel 2003
Microsoft Excel 2003 II Introduction to Microsoft Excel 2000 Microsoft Excel 2000 II
Introduction to Microsoft Excel 97
Microsoft Excel 97 II


Microsoft Access Training Workshops



Introduction to Microsoft Access 2003


Introduction to Microsoft Access 2000


Microsoft Access 2003 II

Introduction to Microsoft Access 97

Popularity: 4% [?]


Related Posts:
  • Micrsoft Office 2003 and 2002 Tutorials
  • Workshop Tutorials for Microsoft Word, Excel, and Powerpoint
  • 11 Microsoft Office eBooks
  • 12 Free Office XP Training Manuals
  • 10 PowerPoint Tutorials

  • Photoshop Tutorials in Video and PDF Formats

    Designsbymark.com offers the following 9 Photoshop video tutorials and 26 pdf formatted Photoshop tutorials for your learning pleasure on this popular graphics and photo editing application from Adobe.

    9 Photoshop Video Tutorials

    Snowflake Effects
    Create Dynamic snowflake photo effects
    QuickTime Movie | 12.8 MB | 10 MIN
    Creating Depth of Field
    Create more depth of field and enhance the color in a image.
    QuickTime Movie (5.7mb)
    Convert Raster to Vector
    By high demand! Convert raster/scanned images to vector or Illustrator files.
    QuickTime Movie (10.7mb)
    Remove People out of Photos
    Have something or someone in a photo and you want to remove them? Awesome!
    QuickTime Movie (10.5mb)
    Surprise Tutorial
    The first video of the suprise series. Watch it to find out! Right-click the link and select Save.
    QuickTime Movie (5mb)
    Retouch a stained portrait
    I’ll show you a color match secret I use on a retouching job.
    QuickTime Movie (6.5mb)
    Creating Dotted Lines
    Create vertical dotted lines and dotted boxes in Photoshop.
    QuickTime Movie (5.5mb)
    Enhancing Photographs
    Watch me take this dense image of a lake and turn it into an awesome colorful photograph.
    QuickTime Movie (6mb)
    Software Box with reflection
    Create a 3D software box or book with a glass reflection.
    QuickTime Movie (5mb)


    26 Photoshop Tips and Tutorials

    Steel Text.pdf
    Tampered steel text. Easy to make. Great for beginners.
    Chrome Text.pdf
    Turn a logo or text that you chose into Chrome.
    Download Sea pic for this tutorial.
    Chisled Text.pdf
    Text that looks like it was cut out of a wall with a chisel.
    Round Text.pdf
    Ever wanted round text in Photoshop? I’ll show you how.
    Square Button.pdf
    Good for beginners. Shows how to create a basic square button.
    Basic Menu.pdf
    A vertical interface that you can use on your website.
    Slicing a Menu.pdf
    Need your menu or interface active on the web? This is how they do it.
    Rounded Buttons.pdf
    Create a pill shaped button. This tutorial utilizes Photoshop channels. Good for beginners.
    Rust.pdf
    Nasty old rustic texture. Cool for game stuff or interfaces.
    Wall Texture.pdf
    Basic wall texture. It also includes how to use it as a pattern on your website.
    Wood.pdf
    Need a wood surface or texture? This is the one.
    Gold Texture.pdf
    Old rustic gold texture. Great for backgrounds and images.
    Hammer.pdf
    Household hammer. Includes how to make the genuine hickory handle.
    Cracks.pdf
    Make cracks on your images or text. Great for adding detail.
    Switch.pdf
    Heavy duty switch. Use it with your imagination in images.
    Screws.pdf
    Flat screw head with a realistic texture finish.
    Enhancing Photos.pdf
    Fix images. Brighten images and bring out color in Photos.
    Extract Commands.pdf
    Remove the background behind objects in photos.
    Holly Leaves.pdf
    How to make the leaves using the Pen tool. Intermediate Skill
    Lights.pdf
    Christmas lights to hang around your website.
    Candy Canes.pdf
    A quick way to make Candy canes using a letter.
    Ball Ornaments.pdf
    Little balls for trees and other Christmas graphics.
    Lights 2.pdf
    Another way to create Christmas lights.
    Christmas Trees.pdf
    Make the basic tree shape with a pine tree like texture.
    Candy Hearts.pdf
    Tasty, plastic looking candy hearts that can be use for valentines day graphics.
    Vilentines Day Card.pdf
    A basic card that can be used for greeting that special one.

    Popularity: 2% [?]


    Related Posts:
  • 41 Basic Photoshop Video Tutorials
  • Free Photoshop Video Tutorials
  • FotoFects Photoshop Tutorials
  • Photoshop Crash Course
  • Inserting Video Into PowerPoint Presentations

  • February 10, 2006

    Web Design Video Tips and Tutorials

    Designsbymark.com offers the following excellent 13 video training tutorials for teaching various areas of Web Design. These are in mov format, so you need an application or browser plugin that can play these files, such as Quicktime.

    Web Design Video Tips and Tutorials

    Intro – The Rules of Webdesign
    Mark introduces some very important things you should know about designing websites.
    Part 1 – Main Sections & Subsections
    How to setup the sections on your website, either big or small.
    Part 2 – Navigation Types
    Learn about Nav types on websites.
    Part 3 – Utilities
    What are they and where do they go on a web page.
    Part 4 – Liquid Layout or Frozen?
    Which one should you use? What are they?
    Part 5 – Logo Placement
    Where should your logo go and how large should it be?
    Part 6 – Taglines
    What it is and how to make a good one!
    Part 7 – Search Box
    Find out the best place to put them.
    Part 8 – Footer Links
    Learn what goes in footer links so you can be more organized.
    Part 9 – Happy Talk
    Why it kills the website, and what to replace it with.
    Part 10 – Put it upfront
    Telling your users what you have to offer rather than making them find it on their own.
    Part 11 – Sites with Flash
    The right way and wrong way to use Flash on a site.
    Part 12 – Usability Test
    Test your website and make sure its easy for the average user.

    Popularity: 2% [?]


    Related Posts:
  • Free Training for Photoshop, Illustrator, Dreamweaver, Flash
  • Web Design Tutorials
  • 10 Excel Tips that Speed up Spreadsheets
  • Word Tips and Tutorials
  • Free Dreamweaver Video Tutorials

  • Free Intermediate Excel Course

    This free online Intermediate Excel course, offered by ed2go.com, will show you how to use several advanced features of Exce, including charting, data filters, goal seeking, pivot tables, the solver, macros, and functions. Intermediate Excel: www.ed2go.com/courses/nxl3381/ Lesson 01: Charting Fundamentals: www.ed2go.com/courses/nxl3381/l1-0.html Lesson 02: Advanced Charting: www.ed2go.com/courses/nxl3381/l2-0.html Lesson 03: Data Management/Filtering: www.ed2go.com/courses/nxl3381/l3-0.html Lesson 04: Goal Seeking: www.ed2go.com/courses/nxl3381/l4-0.html Lesson 05: The Pivot Table: www.ed2go.com/courses/nxl3381/l5-0.html Lesson 06: Advanced Pivot Table: www.ed2go.com/courses/nxl3381/l6-0.html Lesson 07: The Solver: www.ed2go.com/courses/nxl3381/l7-0.html Lesson 08: The Solver (Advanced): www.ed2go.com/courses/nxl3381/l8-0.html Lesson 09: Macros: www.ed2go.com/courses/nxl3381/l9-0.html Lesson 10: Intro to Functions: www.ed2go.com/courses/nxl3381/l10-0.html Lesson 11: Math/Trig Functions: www.ed2go.com/courses/nxl3381/l11-0.html Lesson 12: VLOOKUP Function: www.ed2go.com/courses/nxl3381/l12-0.html Final Exam: www.ed2go.com/courses/nxl3381/l13-0.html

    Popularity: 3% [?]


    Related Posts:
  • 11 Microsoft Office eBooks
  • Training Handouts for Microsoft Office Applications
  • Free Excel Training Book for Business Users
  • The Secret Art of HTML Programming and Web Design
  • 26 Free Excel 2003 QuickSkill Tutorials

  • Free Photoshop Video Training and Tutorials

    CBT Cafe offers very well designed and free web based software training and tutorials, covering the most popular web design and graphics software programs. Their free training modules include the following Photoshop Tutorials in html and QuickTime Video training formats.

    New Adobe Photoshop Tutorials

    Creating 3D Effects

    Creating Photoshop 3D Effects

    Photoshop tutorial for creating some quick, 3D effects using the 3D Transform Tool in Photoshop.

    View Tutorial


    Custom Actions

    Text Swoosh

    Photoshop logo tutorial for a very popular logo technique. Just look around, this effect is everywhere and we’ll show you how to create the effect in Photoshop.

    View Tutorial


    Photoshop Cool Dots

    Photoshop Cool Dots Tutorial

    Very popular techno effect that can be used for both text and web graphics

    View Tutorial


    Using the Trim Command

    Using the Trim Command to Crop Your Images

    In this Photoshop tutorial you’ll learn a fast and efficient way to trim the canvas around your images without having to use the crop tool each time.

    View Tutorial


    Custom Actions

    Creating Your Own Custom Photoshop Actions

    Photoshop tutorial for automating your production process by creating custom actions for your frequent tasks.

    View Tutorial


    Batch Processing

    Batch Processing

    Learn how to customize and automate your workflow in Photoshop 7 by using the Batch Processing command to quickly process large groups of images.

    View Tutorial



    Basic Photoshop Tutorials

    Creating 3D Effects

    Creating 3D Effects in Photoshop 7.0

    Great tutorial for creating some quick, 3D effects using the 3D Transform Tool in Photoshop.

    View Tutorial


    Warp Text

    Creative Text Using Warp Text

    Photoshop 6 tutorial covering the new “Create Warp Text” feature.

    QuickTime | HTML


    Flipping Your Images

    Flipping Your Images

    Get a new perspective on your images by using this Photoshop technique.

    QuickTime | HTML


    Rotating Images

    Rotating Images

    A common technique for editing and modifying your images is to Rotate them

    QuickTime | HTML


    Enlarging Your Canvas

    Enlarging Your Canvas

    Does your image take up the whole canvas? Want more room? Take a look how!

    QuickTime | HTML


    Cropping Images

    Cropping Images

    Get rid of the unwanted space around your images using the Crop command in Photoshop

    QuickTime | HTML


    Image Resizing

    Image Resizing

    Scale down your image to fit better in your listing pages

    QuickTime | HTML



    Photoshop Brush & Shape Tutorials

    Pill Shape

    Pill Shape

    Begin creating your very own custom brushes in a few easy steps!

    QuickTime | HTML


    Create A Custom Brush

    Create A Custom Brush

    Begin creating your very own custom brushes in a few easy steps!

    QuickTime | HTML


    Modify Brushes

    Modify Brushes

    Modify one of Photoshop’s built in brushes to suit your needs!

    QuickTime | HTML


    Pill Shape

    Pill Shape

    Another way to create a pill shape. One of the best and fastest around!

    QuickTime | HTML


    Custom Shape Effects

    Custom Shape Effects

    Create custom shapes by using duplicating and rotating in Photoshop 6.

    View Tutorial




    Photoshop Buttons & Web Effects

    Beveled Button

    Beveled Button

    A quick way to get a beveled, 3D button effect in Photoshop.

    QuickTime | HTML


    Slicing Images

    Slicing Images

    Slice your images and let Photoshop build the HTML for you!

    View Tutorial



    Photoshop Text & Special Effects

    Vignette Effect

    Vignette

    Photoshop 6 tutorial for creating feathered edges around an image

    QuickTime | HTML


    Text Swoosh Logo Effect

    Text Swoosh

    This is a popular logo technique. Just look around, this effect is everywhere.

    View Tutorial


    T.V. Scanline Tutorial

    T.V. Scanline Effect

    Create the realistic TV scanlines effect. A very popular effect

    QuickTime | HTML


    Soft Light Tutorial

    Soft Light Effect

    A great effect that creates a glamorous glow on your images using Photoshop

    QuickTime | HTML


    Shadow/Perspective Tutorial

    Shadow/Perspective Text

    Using the new Warp Text option in Photoshop 6, you can quickly create realistic shadow/perspective text

    QuickTime | HTML


    Inset Lines Tutorial

    Inset Lines

    Create inset lines quickly and without any plugins. Great interface effect

    QuickTime | HTML



    Photoshop Tutorials: Textures & Patterns

    Grid Background Tutorial

    Grid Background

    Create a grid background effect for your images or web pages in Photoshop

    QuickTime | HTML


    Cool Dots Tutorial

    Cool Dots

    Very popular techno effect that can be used for both text and web graphics

    QuickTime | HTML


    Custom Grid/Background Tutorial

    Custom Grid/Background

    Great way to use the Define Pattern feature to create great backgrounds

    QuickTime | HTML


    Rock Texture Tutorial

    Rock Texture

    Create a realistic rock texture for graphics and text without any plugins

    QuickTime | HTML

    Popularity: 2% [?]


    Related Posts:
  • Free Photoshop Video Tutorials
  • Free Training for Photoshop, Illustrator, Dreamweaver, Flash
  • 41 Basic Photoshop Video Tutorials
  • FotoFects Photoshop Tutorials
  • 6 Photoshop Tutorials

  • February 13, 2006

    Microsoft Access Tutorials, Templates, and Examples

    Microsoft Access is the database environment and tool for the Microsoft Office suite of applications. Functionx.com provides tutorial lessons, sample databases, and resources on how to use and develop with MS Access. Also provided are some tutorials covering VBA, which is the programming scripting language that comes with Microsoft Office and Access.

    Microsoft Access Tutorials, Templates, and Examples

    Microsoft Access Tutorials

    Introduction to Microsoft Access
    Introduction to Data Sheets
    Intro to Forms and Reports
    Database Fields On Sheet
    Managing Data Fields
    Data Fields on Forms and Reports
    Data Field Design
    Properties of Data Fields
    Operators and Operands
    Introduction to Data Types
    Using Data Types
    Introduction to Relationships
    Managing Relationships
    Referential Integrity
    Introduction to Data Analysis
    The Structured Query Language
    Queries and Relationships
    Exploring Data Analysis
    Data Analysis With Charts
    Formatting Charts
    Action Queries
    Data Maintenance, Import/Export
    Tables and Queries Aesthetics
    Characteristics of Forms
    Windows Controls
    Types of Forms
    Subforms
    Introduction to Expressions
    Controls and Expressions
    Built-In Functions
    Series-Based Functions
    Domain-Based Functions
    Business-Based Functions
    Finance-Based Functions

    Popularity: 5% [?]


    Related Posts:
  • Free Microsoft Office Templates
  • Access 2007 Interactive Guide
  • Microsoft Access Tutorial
  • Microsoft Office Course Handouts and Templates
  • 17 Access 2007 Database Tutorials

  • February 14, 2006

    FrontPage 2002 Tutorials

    Here are several FrontPage 2002 tutorials hosted by Dakota State University. These are illustrated with screen shots to show you how to use many of the features and functions of FrontPage, which is a graphical GUI tool you can use to create web pages and sites. It is a part of Microsoft Office. FrontPage 2002 Tutorials www.support.dsu.edu/FrontPage2002/ Before you begin….Common Design Errors: www.support.dsu.edu/FrontPage2002/Common%20Design%20Errors.doc Beginning Student Workshop (Word Document): www.support.dsu.edu/FrontPage2002/beginning_student_web.htm * Opening FrontPage * Opening A Web * Getting to Know the Workspace * Working with Explorer * Creating your First Web Page * Inserting WordArt * Adding Text Animation * Inserting Hover Buttons * Using Bookmarks * Finding custom Backgrounds * Publishing Web Site to a Zip Disk * Web Design Resources Advanced Student Workshop (Word Document): www.support.dsu.edu/FrontPage2002/Advanced_Workshop_student.htm * On-line Forms * 1. Creating the Form * 2. Customizing the Confirmation Page * Framed Page * Style Sheets * Photo Album * Include Pages * JavaScript Navigation * Shared Borders and a Navigation Bar * Themes Beginning Faculty/Staff Workshop (Word Document): www.support.dsu.edu/FrontPage2002/beginning_workshop2.htm * Opening FrontPage * Opening A Web * Getting to Know the Workspace * Working with Explorer * Creating your First Web Page * Inserting WordArt * Adding Text Animation * Inserting Hover Buttons * Using Bookmarks * Finding custom Backgrounds * Publishing Web Site to a Zip Disk * Changing Permissions * Web Design Resources Advanced Faculty/Staff Workshop (Word Document): www.support.dsu.edu/FrontPage2002/Advanced_Workshop.htm * On-line Forms * 1. Creating the Form * 2. Customizing the Confirmation Page * Framed Page * Style Sheets * Photo Album * Web Search for your Site * Include Pages * JavaScript Navigation * Shared Borders and a Navigation Bar * Themes

    Popularity: 2% [?]


    Related Posts:
  • Free Microsoft FrontPage 2002 Tutorial eBook:
  • 29 Microsoft FrontPage Training Tutorials from Microsoft
  • Photoshop, FrontPage and Acrobat Tutorials
  • Microsoft FrontPage Tutorials and Help
  • 12 Free Office XP Training Manuals

  • Microsoft Word Intermediate Users’ Guide

    For over a year, Microsoft worked closely with some of the leading experts in the legal community to create the Microsoft Word Legal User’s Guide. The Guide contained step-by-step instructions to help legal users accomplish the tasks necessary to build robust legal documents in Microsoft Word 97 or Microsoft Word 2000. This Intermediate Users’ Guide is based closely on the Legal Users’ Guide and supplements it. It contains all the text from the original Legal Users’ Guide together with additional guides and links to other resources. Each chapter also contains a link to the corresponding original Legal Users’ Guide. The guide is not intended as a sales guide, telling you about all of the useful features in Word. Rather, the guide is focused on showing professionals step by step instructions for building great documents. Microsoft Word Intermediate Users’ Guide: www.addbalance.com/usersguide/ - Introduction - Basic Formatting - Legal Numbering - Understanding Styles - Sections, Section Breaks, and Headers-Footers - Complex Legal Documents [Tables of Authorities, Tables of Contents, footnotes, endnotes, bookmarks & cross-references] - Tables in the Legal Environment - Track Changes - Template Basics - Confidentiality and MetaData - Troubleshooting - Document Corruption - Third-Party Vendors Directory - Revisions / Modifications You can download this entire Users Guide in Word format: www.addbalance.com/usersguide/UsersGuide.zip Word Questions and Answers: www.addbalance.com/word/download/WordQuestionsandAnswers.zip 160+ page Word document (in zip format, 170kb). Although written about earlier versions of Word, this guide is very useful and may have answers you’ll have difficulty finding elsewhere.

    Popularity: 2% [?]


    Related Posts:
  • Word 2007 Interactive Guide
  • Excel 2007 Interactive Guide
  • 3 Photoshop Reference Guides
  • Intermediate and Advanced Word 2003 Training Tutorials
  • 4 Freely Available Ebooks on Microsoft Word

  • HTML and CSS Tutorials

    Southern Twilight Design offers this well written tutorials showing you how to and design and develop your web sites using HTML and CSS. HTML and CSS Tutorials: www.southerntwilight.com/tutorials/tutorial.html Complete HTML Tag Listing: www.southerntwilight.com/tutorials/tags.html Code examples and instructions on use CSS Tags, Basics and Tutorials: www.southerntwilight.com/tutorials/css.html For custom scrollbars, lists, borders, margins, positioning and cursors. ASCII Special Characters: www.southerntwilight.com/tutorials/asciicharacters.html Server Side Includes (SSI) with Examples of Each: www.southerntwilight.com/tutorials/ssincludes.shtml Free Polls, Message Boards, Guestbooks, Counters, Etc: www.southerntwilight.com/tutorials/helplinks.html How to Make and Publish a Web Page: www.southerntwilight.com/tutorials/editor.html

    Popularity: 2% [?]


    Related Posts:
  • HTML, Javascript, and MySQL Tutorials
  • HTML Tutorials and How Tos
  • Web Page Authoring Course
  • 324 HTML Tutorials
  • Learning HTML 4.01 and Website Tutorials

  • February 15, 2006

    Lessons on Effective Presentations using PowerPoint

    FunctionX provides the following Microsoft PowerPoint lessons which review and demonstrate different techniques for creating effective  presentations using Powerpoint.

    The lessons are mostly incremental and cumulative. This means that, for example, Lesson 2 assumes that you have reviewed Lesson 1 and Lesson 2 is a prerequisite to Lesson 3.


    Effective Presentations using PowerPoint


    PowerPoint Lessons:

    Introduction
    Getting Help
    The Presentation File
    Presentation Creation
    Showing a Presentation
    Creating Slides
    Printing
    Sequence and Structure of Slides
    Proofreading and Check Spelling
    Text and Slide Formatting
    Introduction to Shapes and Objects
    Formatting Shapes and Objects
    Common Slide Formatting
    The Master Slide
    Tables and Charts
    Animations and Transitions

    Popularity: 2% [?]


    Related Posts:
  • PowerPoint Seminars, Lessons, and Tips
  • Free PowerPoint 2007 Course from Dell
  • Advanced Powerpoint Tutorials
  • Free Online Class: Introduction to Microsoft PowerPoint 2003
  • 2 Powerpoint 2007 Tutorials

  • « Previous PageNext Page »