Free Microsoft Office Training and Tutorial Resources

Blog Roll:
Free Microsoft Office Training & Tutorials
Free Adobe & Macromedia Training & Tutorials
Free Web Development Training & Tutorials
Intelligentedu.com Blogs
- Free Technical Computer Training
- Free Computer Books & Ebooks

Top Links:
Free Training By Email
Free Computer Training from EdComp
Free Computer and I.T. Training

July 20, 2007

2 Excel Tutorials from the University of Utah

The University of Utah offers several Office Handouts and Tutorials that are nicely illustrated with screenshots. Here are their two Excel Tutorials taking you step-by-step through several beginning and advanced features of this spreadsheet application.

Excel Tutorial Part 1: The Basics of Creating a Spreadsheet
(6 pages, 377kb, pdf format)

Tutorial Contents:
Introduction
– How to Run Excel
Entering Data
– How to Enter Information
– Copying Series Content with AutoFill
- Form Controls
– Editing Cell Content
Formatting Worksheets
– Cell Format
– Row and Column Format
– Conditional Format
- Macros
Formulas and Functions
- Calculating Data with Formulas
– Entering Formulas
- Relative and Absolute Cell References
- Calculating Data with Functions
Saving and Printing Worksheets
- Saving
– Printing

Excel Tutorial Part 2: Displaying, Importing and Analyzing Data
(4 pages, 302kb, pdf format)

Tutorial Contents:
Displaying Data
– Sort
– Auto Filter and Advanced Filter
– Form
- Subtotal
– Freeze and Split
Importing and Exporting Data
– Import Text Files
- Import From or Export To Other Microsoft Applications (Access)
- Import HTML File
Charting and Analyzing Data
- Charts and Graphs
– Editing a Chart
- Pivot Table and Pivot Chart

Popularity: 5% [?]

Beginning and Advanced Access Tutorials

Excel 2003 Tutorial from the University of Texas

Training Handouts for Microsoft Office Applications

Two Excellent Photoshop Tutorials

Tags for this post>> Excel

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 1:06 pm

Comments (0)

July 23, 2007

The Web Designers Killer Handbook

The goal of The Web Designer’s Killer Handbook, by Stefan Mischook, is to present and demonstrate some of the more useful techniques and code, in relation to HTML, JavaScript, and Cascading Style Sheets (CSS), that the author has found when creating websites and web applications. As such it provides useful tips and code snippets. The easiest way to get started with this web designer handbook is to create a practice HTML page, cut and paste the code provided, and then make small changes to see how your changes look in the browser and affect functionality. You will learn more if you try some things on your own and change the code to try to do other things, or break the code, and then see what happens. This article explains why its important to understand and know HTML, JavaScript, and CSS, even when you are using a wysiwyg type of web editor.

Contents of Web Designer’s Killer Handbook:

Styling Your Web Pages

Styling Tips
Change the color of the browser’s scroll bars:
Create link roll-over effects without images:
CSS floating background image
CSS relative positioning
CSS absolute positioning
Fieldset element with CSS styling affecting margin (outside) and padding (inside)
CSS Border style (inline) applied to a table

Miscellaneous Web Design Tips

Subscripts
Supercripts
Prevent the page from jumping
Cause the page to jump
Obfuscated email address to protect yourself from spam
Jump to a spot on another page
ASCII Character Code
Easy navigational drop-down menus
Removing the %20 in URL’s
Add to favorites: How to create an ‘add to favorites’ link
Link made with an image instead of text
A more extensive version of the “Add to Favorites” code

Popularity: 4% [?]

Related Posts:

Web Developer’s Handbook

38 Free Books: Dreamweaver, Fireworks, Director, Flash, Photoshop

Books for Web Developers and Web Designers

Free Books on Web Development and Programming

High Quality Photoshop Tutorials

Tags for this post>> Web Design

Filed under: Free Web Design, Development and Programming Training and Tutorial Resources — computer_teacher @ 12:05 pm

Comments (0)

Beginning and Advanced Access Tutorials

Here are two Microsoft Access Tutorials and two Access Slide Presentations from The University of Utah. The two Access tutorials provide step-by-step instructions, along with screenshot graphics to demonstrate both beginning and advanced features of Access.

Access Basics Presentation (11 Powerpoint slides 67kb)

– Definitions
- Data Integrity
– Access vs. MS Excel
- Examples
– Access vs. MS Excel

2003 Access Basics Tutorial (7 pages, pdf format, 594kb)

Contents of Microsoft Access Tutorial: The Basics:
Part 1: Starting MS Access and the Database Wizard
Part 2: Database Structure: Table Relationships, Fields, Primary Key,
Part 3: Viewing Your Data: Obljects, Tables, Queries, Forms, Reports, Assignment

Advanced Access Presentation (21 Powerpoint slides, 121 kb)

– Definitions
- Basic Database Design Principles
– Main Parts of Database Design
– Sample Database Scenario
- Database Mission Statement
– Mission Statement >>Tables
– Tables and Fields
- Fields in the Table
– Primary Key
- Foreign Keys
– What You Don’t Know Can Cause You Problems
– Access and its Templates Can Help You

Advanced Access Tutorial (9 pages, pdf format, 379kb)

Contents of Microsoft Access Tutorial: Advanced:
Part 1: Create Database
A. Primary and Foreign Keys, Table Design
B. Importing Data
Part 2: Implement Table Relationships
Part 3: Creating Forms and Modifying Queries and Reports
A. Creating and Modifying Forms
   1. Creating Forms
   2. Modifying Forms
   3. Adding Records Using Forms
B. Modifying Queries and Reports
1. Modifying Queries
2. Modifying Reports
C. Setting Up Functions with Queries and Reports to Create a Count Query and Report
   1. Create the Function Column in a Query
   2. Run the Function in a Report
Part 4: Test Your Database
Part 5: Conclusion: Assignment – Design, create and modify MS Access forms, queries and reports and check to be sure that

The exercise files for this advanced Access tutorial are available:
– Calls.xls
- Contact.xls
- Employees.xls

Popularity: 13% [?]

67 PHP Tutorials

Free Microsoft Access Video Training

6 Freely available Ebooks on Microsoft Access 2003 and 2002 (XP)

5 Free Access Workshop Training Tutorials

Tags for this post>> Access

Filed under: Free Microsoft Office Training and Tutorial Resources — computer_teacher @ 9:33 pm

Comments (0)

July 31, 2007

Best 22 Flash Tutorials by Creativepro.com

Here are Top 22 Flash Tutorials hosted and linked by Creativepro.com. These will teach and show you how to do many things for your web sites using Flash, including how to implement sound, use bitmapped images, create movies and animations, switch between video clips, animate masks, and more.

Making Flash Roar – Part 1
This is the first part of a Flash tutorial on how sounds help tell the story and enhance the mood, letting the audience know whether something is funny, scary, or important.

Making Flash Roar – Part 2
This is the second part of a Flash tutorial on how sounds help tell the story and enhance the mood, letting the audience know whether something is funny, scary, or important.

Flash MX: Enabling the Rich Internet
Macromedia’s new vision of Flash offers video and audio integration, a polished and streamlined interface, and enhanced graphic tools.

Too Much Flash on the Brain
Contributing editor Pamela Pfiffner joins Lynda Weinman in a look at the bleeding edge of Web design using Flash.

Flash without Flash
At the recent Thunder Lizard Web Design Conference in Atlanta, a certain brilliant woman posited that “SWF is the PostScript of the twenty-first century.”

How to use bitmapped images in Flash 5
Learn how to use photographic bitmapped images in Flash to add depth to the background of a Web site, enhance buttons and other interactive elements.

Flash in a Flash
Find out how the author created several Flash animated shorts for a Web site, and he did them all in six weeks.

Creating Flash Animations in Adobe Illustrator
Learn how to use the Release to Layers functions in Flash to generate animated SWF files.

Flash Explores New Angles
Macromedia’s Flash MX allows users to do a number of cool tricks, including switching instantaneously between video clips.

Flash Physics: Velocity and Acceleration
Flash, by definition, brings 2D drawing to life. But it lets you do even more: To give your Flash animations a sense of realistic movement, discover how to use the laws of physics and mimic the way objects behave in nature.

Optimize Preloading with Flash 5
This Flash tutorial teaches how to optimize the size of your Flash files, when they are packed with audio and imported graphics.

Macworld’s Flash 5 Expert Guide
Flash’s unintuitive interface, click-intensive dialogs, and limited scripting support have been known to inspire a love-hate relationship between the program and developers. Sure, you can do amazing things in Flash, but it isn’t easy.

Becoming a Flash 5 Master: Lesson 1
Learn how to add snappy interactivity and animations to your Web pages using Flash and without scripting any DHTML.

Flash 5: Shared Libraries
Flash 5 introduces several features that make it easier to control external files and share resources across a project. In this walkthrough we’ll make a gadget that works like a child’s toy keyboard, using an external linked graphic symbol and the new ActionScripting syntax.

Flash Your E-mail
Would you like to have a signature file on your emails that instantly tells recipients you are a good designer? Would you like to bring your client’s newsletters to life with all the capabilities of Flash animation? Then this Flash tutorial is for you.

Hierarchical Menus in Flash
Find out how to create a Hierarchical Menu using Flash. This menu works when the user clicks on the arrow or plus sign, and a sublist of items expands below it pushing everything else down.

From Fireworks to Flash and Back
Fireworks takes care of the bitmap images while Flash handles the vector graphics and animation controls. Learn how to easily import native Fireworks files into Flash, and perform some round-trip editing techniques that make these two applications a perfect combination.

Off the Beaten Path with Flash and LiveMotion
Learn how to animate objects along a custom motion path in Flash and LiveMotion.

Animating Masks in Flash and LiveMotion
Animated masks in Flash and LiveMotion can produce a compellnig effect by revealing only one part of the underlying animation at a time. By including masks in your animations, you can add a sense of complexity and interest.

Getting Started with Coldfusion MX and Flash Remoting
How to use Flash Remoting, allowing you to use ColdFusion MX functionality in your Macromedia Flash movies easily, using familiar Macromedia Flash syntax and objects.

Making a Splash with Flash: An Animation Primer
This tutorial reviews Flash’s user interface and then demonstrates how to use it to build a basic Flash animation, that would be suitable for an introduction movie for your Web site.

One Approach to Mastering Flash
Learn the intricacies of Flash’s Tell Target command, which is used to manage and manipulate nested video clips.