Free Microsoft Office Training and Tutorial Resources




    



September 24, 2007

Creating Newsletters and Brochures with Word 2002

This course handout from the University of Waterloo shows you how to use Word 2002 to create newsletters and 3-fold brochures. The tasks you will learn as you develop these documents also cover the features for many other types of Word documents as well. The training document is titled “Creating Newsletters and Brochures with Word 2002“. This newsletter and brochure training handout can also be used for Word 2003. It is in pdf format, 35 pages in length, and 616 kb in size.


Creating Newsletters and Brochures Contents:

  • Overview
  • Our First Canadian Cybernetics Conference Newsletter
  • Setting Up Our Pages
  • Creating Our Masthead
  • Setting Up Columns
  • Modifying our Newsletter Styles
  • Creating Drop Caps
  • Adding Graphics
  • Adding a “Pull Quote”
  • Creating a Table of Contents
  • Balancing Columns
  • Sections in a Word Document
  • Headers and Footers
  • Finishing Up
  • A Newsletter With a Different Format
  • Creating a Masthead with Wordart
  • Creating Columns of Unequal Widths
  • Re-Defining Column Widths for Subsequent Pages
  • Linking Text Boxes
  • Creating a “Continued On Page…” Item
  • Shading a Portion of the Page
  • Finishing up Newsletter 2
  • Creating a Three Part Brochure
  • Setting Up Our Page
  • Name of Conference
  • Text of Brochure
  • Headings
  • Using The Styles
  • Creating A New Style
  • A Text Box With Rotated Text
  • Some Pictures


Tags for this post>>

Mail Merge Using Microsoft Word 2002

Here is a course handout from the University of Waterloo that teaches you how to use Word 2002 to create form letters, mailing labels, department directories etc. by using Word’s built-in Mail Merge feature. The training document is titled “Mail Merge Using Microsoft Word 2002“. This mail merge training handout can also be used for Word 2003. It is in pdf format, 37 pages in length, and 583 kb in size.


Word 2002 Mail Merge Contents:

  * Starting a Mail Merge
     o Creating the data to be merged
     o Creating the main document
     o Merging to letters
     o Merging using email
     o Specifying data fields in the main document
     o Storing data to be merged
  * Selecting data to be merged
  * Inserting data into a document based on the value of a field
  * Merging to a new document
  * Merging directly to the printer
  * Merging to mailing labels
  * Merging to lists (e.g. departmental phone directories)
  * Merging data that is not stored in your word processing document
     o merging from a text file
     o merging from an Excel spreadsheet
     o merging from an Access database
        + initiating the Merge from your word processor
        + initiating the Merge from Access

Tags for this post>>

Photoshop 7 for the Internet Course

Here is an excellent small online course, from Trainingtools.com, that teaches Photoshop 7 for the Internet. These Photoshop lessons cover many of the  basic features you need to master to use Photoshop effectively. Areas covered include the Workspace, Photoshop Documents, Selections and Channels, Layers, Editing Images, Vectors, Optimizing Images for the web, and ImageReady.


Tags for this post>>

Flash Tutorials From Clever Tutorials

Clever Tutorials is offers a good quantity of quality Flash Tutorials that are linked from many of the better Flash tutorial sites on the web. Linked below are just some of these, check out their site for many more. These Flash tutorials cover 3D Effects, ActionScript,  Basics, Interactivity, Text Effects, and Tips and Tricks.


Flash Tutorials From Clever Tutorials:

3D Effects


Creating a Virtual Display Screen in Flash
This is a great effect to wow customers to your site or place as a banner. Simple to create. Only motion tweens and layers, no actionscript.

3D Hologram effect in Flash using Swift 3D
Bring your flash site to life with a 3D hologram effect. This tutorial will show you how to create a 3D spinning hologram in Flash using the 3rd party Swift 3D software and various other techniques.

Futuristic city, Learn some clever 3D techniques in Flash
See the tricks behind the advanced Flash animation that was used to bring a futuristic cityscape to life.

Creating a 3D Tunnel Effect in Flash
Learn how to create this very cool 3D tunnel effect in Flash using some simple 2D animation techniques.

3D circle animation in flash
Using this lesson, you will see how to create a circle that is rotate 3D.

Chrome effect in Flash using vector graphics
Why importing heavy bitmaps in Flash when, with a bit of patience, you should be able to create fancy 3D chrome effect using vector graphics.

Motion Tweening using a Path
How to use motion tweening in conjunction with a path.

Flash 3D Rotation and Revaluation
This tutorial is covering the basics about 3d rotation in Flash.

Letters World
Learn how to create a circle that rotates using Mask trick

Moving Text Around a Path
This tutorial covers basic text generation, and shows how to get it to deform and follow a circular path.


Actionscript

Star flash preloader
Using this lesson, you will see how to create star flash preloader using the action script code.

Practical flash curosor
This simple tutorial will show you how to create practical flash cursor using the action script code and on that way, hide the standard cursor.

Changing object color on click
In this step by step tutorial, you will see how to change a object color using the action script code and color buttons.

Movie Clip controlling using the action script
In this lesson you will learn how to control movie clip.

Continuous object movment in flash
In this Macromedia Flash tutorial you will see how to make an object move across the stage, and when its done it will start over.

Digital clock in flash
Using this little tutorial, you will see how to create simple digital clock in flash using a little action script code.

Creating a Video Portfolio (FLV Video Player) in Flash
This tutorial will teach you how to create an interactive FLV video player that lets the user select which video to load at run time.

Creating a Basic Slideshow in Flash
In this tutorial, Craig Campbell shows you how to create a basic slideshow from scratch by importing pictures into their own keyframes and creating “next” and “previous” buttons so the user can cycle through the images.

Picture rotation by action script
In this little tutorial, you will see how to rotate image using the action script code.

Info about object
Using this lesson, you will see how to create info panel about any object. To create this lesson, you have to use Action Script code.

Creating an Interactive Map in Flash
This tutorial will teach you how to create an interactive map in which a map marker flies over to the city highlighted and shows a small photograph of that city.

Actionscript jump to random frame
In this Macromedia Flash tutorial I will show you how to make a simple actionscript code to jump to a random frame in the timeline.

Customizing Flash Context Menu
Learn how to customize the context menu by removing default items and adding your own items instead.

Advanced full flash site – Part 2
In this part, You will see how to load flash site after preloader animation.

Actionscript dynamic load image into flash
In this Macromedia Flash tutorial I will show you how to load in a image into flash dynamically through actionscripting


Basics

Symbol Types: Movie Clip or Graphic?
Have you ever wondered what exactly is the difference between a “Movie Clip” or “Graphic” symbol? Should you use both types or just one? ?In this free video tutorial, you’ll be shown the exact differences and you’ll learn when and where to use both types! ??If you’ve only been using “Movie Clip” symbols for your animations, then this tutorial will be an eye-opening experience!

Tips and tricks for designing logos
A guide for how to go about designing a logo, it covers good font techniques, how to get inspiration, playing with layouts and how to simplify complicated objects for use in logos.

Simple shape animation
In this tutorial you will see how to transform image in many shapes.

Timing: Ease In and Ease Out
Getting your animation to move more naturally can be very easy once you know how to use the Ease in/out slider for tweening. Understanding these timing principles will improve your animation and keep your movements from seeing robotic and unnatural.

Changing the Pivot Point of a Symbol
Change the default center point of a symbol to allow for easier character animation.

Animating arm movements using speed lines
Animate your character’s arms and other limbs by using speed lines. A fast way to achieve natural looking movement. Comes with FREE downloadable Flash file of speed line art!

Changing Colors inside Symbols
Whether you want to customize the colors of a Character Pack, or change the colors of a hand pose to match the character you are animating with, this video tutorial demonstrates how easy it can be!

Animating Dialogue using the “Mouth Comp” system
With this step by step quicktime video, you’ll quickly learn, a faster, better way to animate your character’s dialogue!

Character Animation using Symbols
Watch step by step with this quicktime video to see just how fast and easy it is to animate using symbols!

Change the context menu of your Flash content
Learn how to change the context menu of your Flash content.

Motion tweening (the basics)
Use some basic motion tweening for animation.

Filling bottle preloader
Learn to make an image-based preloader: a bottle that slowly fills up as your movie loads. This cool effect can be applied to any photo, image, etc. Make a different preloader!!!

Make a Pac-Man animation
Create and animate the most-widely recognize arcade game character: the classical PacMan!

Using Motion Guides in Flash
In this tutorial, you will learn how to animate a graphic on a guided path using the motion guide. You will also learn how to place your graphic or movieclip on the correct points of the motion guide.

Copy to Grid Effect
Learn how to repeat objects with the copy to grid feature.


Interactivity

Little sunshine animation
See how to create little sunshine animation in flash using a special picture, flash 8 filters and some special flash tricks.

Scrolling Text in Flash
In this tutorial, you will learn a very important lesson on building and using the scrolling text box. You will learn to assign a Scrollbar from the components list in Flash and how to wrap text within the box.

Drag and Drop
Learn how to apply Drag and Drop technique on any object.

Creating a Password Protected Section in Flash
Have a restricted area section in your website.

Full Monitor Presentation
This tutorial will teach you how to create advanced monitor presentation using the picture of monitor and mask effect.

St. Valentine Day Ad Banner
Make an interesting ad banner for St. Valentine’s Day. Very effective and eye-catching. You will learn a lot of ActionScript.

Continuous up and over button animation
Create an advanced button animation.

Simple Flash Painting Program
Create a simple painting program using Actionscript. Includes simulated canvas, simple painting effect, and option to clear the canvas.

Cool image revealing mask effect in Flash
Learn how to make a great image revaling mask effect in Macromedia Flash in just a few easy steps.

Creating an Interactive Story
You’re lost. It’s late at night. The only light you see is the glow of a doorbell. You’re desperate. You ring the doorbell. Suddenly all of the lights go on. Okay, we’ve all seen this opening scene. But have you tried creating your own version in Flash?

Drag
Simple dragging effect using Flash 8.

Easy Flash Quiz
Tutorial about how to make quiz with correct answer counter.

Follow the mouse
Learn to make objects follow the mouse pointer.

Simple Drag and Drop
This tutorial will show you how create a drag and drop movie.

Flash Photo Gallery
In this tutorial, you have a chance to learn how to create photo gallery in flash 8 with no Action Script.


Text Effects

Rotating letter effect in text
See this tutorial and learn how to rotate letters in series using some special flash tricks.

Vanishing text effect
In this lesson, you will see how to create vanishing text effect.

Circle animation
See this tutorial and learn how to create simple circle animation, using a lot circles.

Vertical text effect
Using this tutorial, you will see how to create on a simple way in few steps vertical text effect.

Image flashing text mask effect in Flash
In this Macromedia Flash tutorial I will show you how to make a cool image flashing text mask effect.

Simple blink text effect
In this tutorial, you will see how to create a text effect which is blinking, using the flash filters.

Text revealing glow effect in flash
In this Macromedia Flash tutorial I will show you how to make a stylish text glow effect in just a few easy steps.

Attractive text effect
In this step by step tutorial, you will see how to create attractive text effect that you can use for any banner, flash advertisment…

Titration text effect
Using this tutorial, you will see how to create a text that is titration, using some special flash tips and tricks.

Mask text effect by alpha
See this lesson and learn how to create a cool text effect, using the mask and alpha in flash.

Mask text appearance
Using this lesson, you will see how to create a typing text which is appears, using the mask and Pencil Tool (Y).

Text shadow effect
Read this tutorial and see how to create text shadow effect in flash with no Action Script.

Sliced Fading Text
This tutorial will show you how to create a sliced, fading text effect, using Flash.

Flash Trailing Text Effect
This tutorial will illustrate how to add the symbol (s) that trail after the mouse cursor.

Shake Effect
This tutorial will help you to learn how to apply shake effect on any object using the Action Script.


Tips and Tricks

Lip Sync Animation: Using an X sheet
Learn how to use your timeline as a X sheet to write the dialogue and speed up the animation process. This is especially helpful with scenes with lots of dialogue.

A simple image transisson effect in flash
In this Macromedia Flash tutorial you will see how to make a simple image transission effect in just a few steps.

3D animation by mask
In this detailed lesson made for flash, you will learn how to create 3D animation using the mask and some special flash tricks

Picture Shadow effect
Discover how to create to create a great picture shadow effect, without Action Script.

Styling Flash Text Fields Using CSS
Learn how to control the formatting of text fields in flash using Cascading Style Sheets.

Practical photography demonstration
In this easy lesson, you will see how to create Practical photography demonstration using a some special tricks in Adobe Flash.

Tags for this post>>

September 23, 2007

HTML and CSS Tutorials By Example


Here are several excellent HTML and CSS Tutorials, from csshtmltutorial.com, that show and teach you these web development coding techniques using examples and asking you to enter your own code to see how it works and looks in the browser.


HTML Tutorials

Introduction to HTML

Learn what HTML is, what the basic structure of an HTML document and about HTML tags, attributes and elements.
basic HTML tags

Learn the basic HTML tags that are used when making web pages, such as the <title> tag, the <p> tag, the <head> tag and more.
HTML link code tutorial

This tutorial shows you how to make links, how to open links in a new web browser window, how to use images as links and more.
HTML image code tutorial

Learn how to place images on your web sites.
HTML list code tutorial

This tutorial shows you how to make the 3 kinds of list that are supported in HTML: ordered, un-ordered and definition.
HTML table code tutorial

This tutorial shows you how to make tables in HTML.
HTML form code tutorial

Learn about forms in HTML and how to make them.


CSS Tutorials

Introduction to CSS
Learn what CSS is and how to apply it to your web pages.

CSS background code tutorial
CSS can be used to define the background effects of a web page. Learn how to set the background color of a web page, how to set an image as the background and more.

CSS text code tutorial

CSS font code tutorial

CSS border code tutorial

CSS margin code tutorial

CSS padding code tutorial

CSS list code tutorial


Free Tools

Free Website Hit Counters
Track the number of visitors to your websites or web pages by adding a hit counter to your web pages. There are different styles to choose from.

Google Page Rank Tool
See what the Google page rank of the web page that you are viewing is by placing a Google page rank button on the web page.

Tags for this post>> | |
September 22, 2007

Free Excel Training Videos

Auditexcel.co.za offers a fair amount of free Excel Training and Tutorials covering many features and functions of Excel. Most of these are provided through screen videos, so you will need Windows Media Player to see and use these Excel training videos. Also take a look at their page of Vital Tips in Using Microsoft Excel.


Free Excel Training Videos


Excel Database Video Tutorial
Learn how to use all the functions that start with a D, for example: DSUM and DCOUNT.


Microsoft Excel Function Tutorials


Financial Functions in Excel
Learn from these Excel tutorials how to use the financial calculations.

Rate (2 min)
Calculate the interest RATE charged on a constant annuity cash flow. Excel Help File Description:  Returns the interest rate per period of an annuity. RATE is calculated by iteration and can have zero or more solutions. If the successive results of RATE do not converge to within 0.0000001 after 20 iterations, RATE returns the #NUM! error value.

Internal Rate of Return / IRR (2 min)
Calculate the Internal Rate of Return of a series of cash flows. Excel Help File Description: Returns the internal rate of return for a series of cash flows represented by the numbers in values. These cash flows do not have to be even, as they would be for an annuity. However, the cash flows must occur at regular intervals, such as monthly or annually. The internal rate of return is the interest rate received for an investment consisting of payments (negative values) and income (positive values) that occur at regular periods.

Net Present Value/ NPV (3 min)
Calculate the Net Present Value of a series of cash flows. Excel Help File Description:  Calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values).

Calculate the Compound Annual Growth Rate (CAGR) using Excel (2 min)
Use the RATE function to calculate the CAGR

PMT (2 min)
The PMT function calculates the required repayment amount to amortise (pay off) a debt or loan based on the original capital amount, interest charged and term of the loanExcel Help File Description: Calculates the payment for a loan based on constant payments and a constant interest rate

CUMIPMT & CUMPRINC (4 min)
The CUMIPMT and CUMPRINC functions allow you calculate the total interest or capital (principal) paid between any two periods without having to build an amortization table. Excel Help File Description: Returns the cumulative interest paid (or principal paid) on a loan between start period and end period. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in (follow this link to learn how).


Date Funtion Tutorials for Excel
Here are Excel tutorials showing you how to use the Date functions in Microsoft Excel.

DATE, DAY, MONTH, and YEAR (4 min)
These functions allow you easily extract various components of a date for further manipulations, or to combine bits of a date into a format that Excel can understand.

EOMONTH (4 min)
The EOMONTH (end of month) function allows  you to generate a month end date no matter what the original date (even taking into account leap years). Extremely useful when you want to report on standardized dates. Excel Help File Description: Returns the serial number for the last day of the month that is the indicated number of months before or after start date. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in (follow this link to learn how).

EDATE (4 min)
The EDATE function generates a date a specified number of months before or after a reference date. Excel Help File Description: Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date). Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue. If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in. (follow this link to learn how)


Excel Tutorials for Statistics Functions
Learn how to perform statistical analysis using Excel, such as calculating the rank of a cell in a list, or the minimum or maximum numbers in a list.

Rank (5 min)
The Rank function allows you to rank a selection of cells in ascending or descending order automatically. Easier than using complex IF functions to achieve the same goal. Once you have learnt this, go to Tips and Tricks, to see how to automatically move cells around depending on there order. Excel Help File Description: Returns the rank of a number in a list of numbers. The rank of a number is its size relative to other values in a list. (If you were to sort the list, the rank of the number would be its position.)

Max & Min (2 min)
Max and Min allows you to specify the maximum or minimum number that can appear in a cell. Excel Help File Description: Returns the largest (or smallest) value in a set of values.


Logical Functions in Excel
These Excel tutorials show you how to use the logical operators IF, AND, and OR in your functions.

IF
The IF function allows you to perform alternate actions depending on certain criteria. Excel Help File Description: Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. Use IF to conduct conditional tests on values and formulas.

AND & OR
These functions allow you to check multiple criteria that they either all meet the criteria (AND) or at least some of them do (OR). Excel Help File Description: AND- Returns TRUE if all its arguments are TRUE; returns FALSE if one or more argument is FALSE. OR- Returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.


Learn Text Excel Functions
Learn how to use several the text manipulation functions.

FIND
The FIND function allows you to search for a particular character within some text which is especially useful when trying to extract parts of the text. Excel Help File Description: FIND finds one text string (find_text) within another text string (within_text), and returns the number of the starting position of find_text, from the first character of within_text. You can also use SEARCH to find one text string within another, but unlike SEARCH, FIND is case sensitive and doesn’t allow wildcard characters.

LEN
The LEN function tells you how many characters make up a cell which is particularly useful when trying the manipulate the text within the cell. Excel Help File Description: LEN returns the number of characters in a text string.

Concatenate or &
The Concatenate (or &) can be used to join up the contents of multiple cells into one cell. This text function is extremely useful for generating unique keywords or preparing intelligent reports. Excel Help File Description: Joins several text strings into one text string

Lower, Upper & Proper
These text functions give you the ability to change the capitalization (case) of cells to being all lower, or all UPPER, or Proper. Excel Help File Description: Lower and Upper converts all uppercase (lowercase) letters in a text string to lowercase (uppercase). Proper capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters

Left, Right & Mid
These text functions give you the ability to to extract certain segments of a cell (normally text). Useful if only part of a cell’s text contains the information you want.. Excel Help File Description: LEFT (RIGHT) returns the first (last) character or characters in a text string, based on the number of characters you specify. MID returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.


Information Functions in Excel
Find out about functions and formulas that will provide you with added information about a cell, worksheet or workbook in Excel.

ISERROR
The ISERROR function allows you to test whether a cell has generated an error message. This is particularly useful for division by zero (#DIV/0!) errors and is often combined with an IF statement to provide an alternate action if an error is generated. Excel Help File Description: Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).


Math and Trig Excel Function Tutorials
This Excel tutorial demonstrates useful mathematical and trigonometry functions.

SUMIF and COUNTIF
The Sumif and Countif commands allow you to sum or count cells depending on whether they meet the stated criteria. Excel Help File Description: Counts or sums the number of cells within a range that meet the given criteria


Tips and Tricks in using Excel

Show the underlying formulas in all cells (1 min)
A shortcut which allows you to show either the results in all cells or the underlying formula in the cells. 

Filling in the blank cells quickly and easily (3 min)
There are occasions when you would like to fill in all blank cells with a formula. This is a quick and easy way to achieve this. Use is made of the GoTo Special command so it may be worthwhile learning about it.

Cleaning up data using the Data Autofilter (7 min)
Excel is often used as a means of cleaning up data and produces reports. Often the most time consuming aspect is the data cleanup. Using the Data AutoFilter it is possible to achieve more in less time.

Changing Multiple Worksheets at the same time (4 min)
In Excel it is possible to change a number of worksheets at the same time. Extremely useful but don’t forget to switch it off once you are done! 

Automatic sorting of a list (5 min)
Rank a list of numbers and then automatically (without macros) have the numbers sort themselves into your preferred order (and pull other information with it if necessary). Can be used to generate sport league tables e.g. English Premiership log or the World Cup Soccer logs. You need to know the workings of the VLOOKUP and RANK functions.


Absolute Musts to Use Microsoft Excel

Function Wizard (3 min)
The function wizard allows you to use any of Excels functions in a very user friendly way. You therefore do not need to remember the complex syntax of any of the commands.

Auditing Toolbar (5 min)
The Auditing Toolbar is one if Excel’s best kept secrets. It allows you to visualise the cells used in any formulae. In particular is allows you to view what cells are being used by a particular formulae, what other cells are relying on the cell you have specified, follow links to other spreadsheets and more recent versions of Excel include some error checking capabilities.

Good Spreadsheet Design Techniques (15 min)
The are some basic aspects of spreadsheets which should be considered. When developing your spreadsheets some upfront thought can be vital. After you have viewed the free material on How Errors Happen, this will further enforce some good design tips. PLEASE NOTE THAT THIS IS A BIG FILE. GIVE IT SOME TIME TO DOWNLOAD

Loading the freely available Add Ins (2 min)
With a standard installation of Excel, you are provided with a number of add ins that you can activate. These add significant functionality to Excel and should be loaded.


Running Sensitivities and What If Analysis in Excel

Goalseek (3 min)
The Goalseek feature allows you to specify the result you require and which input can change. Then the computer will calculate the required number. Very useful for break even analysis. This clip also shows you how to perform a goalseek straight off a graph. 

Data Tables (8 min)
Learn how to use Excel’s Data Tables feature to automatically run multiple scenarios through a model, based on either one or two variables. 

Multiple Scenarios (4 min)
The scenario feature allows you to quickly change a number of input cells based on some pre defined situations e.g. Low case, High Case, Realistic Case. You can then switch between the various scenarios. 

Watch Window (3 min)
The watch window allows you to continuously view cells that interest you (no matter where they are on the spreadsheet) while making changes to inputs in the model. 


Lookup and Reference Excel Tutorials
These Excel tutorials will teach you how to use the lookup and reference functions, useful when using tables of information. For learning vlookup, see tutorials immediately below.

Transpose (3 min)
Two methods to quickly and easily move information from row format into a column format, or a column into a row. Excel Help File Description: Converts a vertical range of cells to a horizontal range, or vica versa.

CHOOSE (3 min) 
The Choose function allows you to refer to different cells depending on the results of a cell. Often useful as an alternate to the IF function (especially if you are tempted to use nested IF functions). Excel Help File Description: Uses index num to return a value from the list of value arguments. Use CHOOSE to select one of up to 29 values based on the index number. For example, if value1 through value7 are the days of the week, CHOOSE returns one of the days when a number between 1 and 7 is used as index num.

OFFSET (3 min)
Offset allows you to refer to cells above, below, left or right of a reference cell. Very useful for cash flow forecasts where the receipt or payment of money can move between periods. Excel Help File Description: Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells. You can specify the number of rows and the number of columns to be returned.


Using and Understanding Microsoft Excel’s VLOOKUP function

VLOOKUP Basics (7 min)
Learn how to use the VLOOKUP function in Microsoft Excel which allows you to request Excel to reference certain information and pull through some related information. This can either be done based on an exact match of the criteria or an approximate match. Excel Help File Description: Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify. By default the table must be sorted in ascending order. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data you want to find. The V in VLOOKUP stands for “Vertical.”

Handling Large VLOOKUP tables (6 min)
Once you have mastered VLOOKUP you may find that you use it for large datasets. The problem is that when you make changes to your spreadsheet you sometimes need to go through all the VLOOKUP cells and change the column reference. Learn how to avoid this! 

Typical Errors made when using VLOOKUP (5 min)
As useful as the VLOOKUP function is, there is a significant risk of errors. Learn what you must watch for. 

Automatic Sorting of lists (5 min)
By combining the VLOOKUP and RANK functions you can have Excel automatically sort a list of data into a specific order. 


Tags for this post>>
September 13, 2007

Freely Available Web Development eBooks

Here are links to freely available Web Development ebooks from freebooklinks.com. This site bills itselfs as “A 100% free resource to hundreds of free ebook downloads from all over the web.”


Freely Available Web Development eBooks



Tags for this post>> |

Freely Available Microsoft Office eBooks

Here are links to freely available Microsoft Office ebooks from freebooklinks.com. This site bills itselfs as “A 100% free resource to hundreds of free ebook downloads from all over the web.”


Freely Available Microsoft Office eBooks



Tags for this post>> | | | | | | | | |

Freely Available eBooks for Adobe Software

Here are links to freely available ebooks covering Adobe Software and Applications from freebooklinks.com. This site bills itselfs as “A 100% free resource to hundreds of free ebook downloads from all over the web.”


Freely Available eBooks for Adobe Software



Tags for this post>> | | | | | | |
September 10, 2007

Web Development and Design Tutorials

Let Stefan Mischook teach you the latest web design techniques. He has been busy writing Web Development and Web Design Tutorials and Articles covering new methods of web design that will help you develop great web sites. He says its his job to to filter out the unnecessary stuff and teach you the latest web design techniques that work in the real world. His background includes more than 10 years experience in web design to help you avoid all the mistakes he has made.


Opinion


Techniques


Theory


Web Development Tutorials


A beginner’s tutorial on creating CSS based web sites
As promised, we will be taking the next step towards total nerd glory with this first of a three-part article on creating a pure CSS web page…

Get started programming with Java Script
In part one of this series, our goal is to get you used to some of the concepts found in JavaScript programming. These concepts are also applicable to many other programming languages like Java, PHP, and several others…

Building Websites with web design templates
Website templates (web design templates) can be an excellent tool when building a new web site; a tool that can speed up the production schedule, improve the quality of the final web site and just make the whole process of building a web site much easier.

How to get your website ‘live’ on the web
You are at the point where you built and tested your website on your own computer and now you want to show the world your new creation, but how do you do it? Now that you’ve come to think about it, you’re not even sure how people actually get to websites; where are the websites actually sitting, what is the web in the first place?

An introduction to Cascading Style Sheets
CSS is the acronym for: ‘Cascading Style Sheets’. CSS is an extension to basic HTML that allows you to style your web pages. An example of a style change would be to make words bold…

Tips for the new web designer
This first article is meant to provide some helpful tips for those just learning to build websites. I am not going to go into details explaining specific technology; rather I am going to point out a few things that many people just starting may find useful.

The do’s and don’ts of web site design: Part 1
There are many options available when creating web pages, many good and many bad. The following is a list of some of those options and how I think you should deal with them.

The do’s and don’ts of web site design: Part 2
I’ve received many emails on the first do’s and don’ts article, people wanted more, so I thought a part 2 was in order.

The do’s and don’ts of web site design: Part 3
I’ve received many emails on the first and second do’s and don’ts articles, so …


Beginner’s
Web Development Tutorials

Creating Multimedia Content

In this article I look at some of the options available to create multimedia presentations with an emphasize on introducing you to the basics of multimedia.

HTML fundamentals: Logical vs. Inline tags
The differences between logical and physical tags is one of the fundamental concepts in HTML that, when understood, can have a huge impact on a web designer’s way of doing things.

Database driven websites explained
Database driven websites: What are they and how are they built?

The Creating Killer Web Sites HTML Table Tutorial
When Netscape added tables to HTML in 1995, second-generation site design became possible. Although tables weren’t meant to contain lots of text, people soon found they could use them to get margins and do better typography. This section discusses the thrills and dangers of using tables to do real typography.

What is Flash, when and why to use it
Flash is a vector animation software originally designed to create animations for display on web pages. Vector graphics are ideal for the web because they are so lightweight.

Formatting your web pages – text and font considerations
There are many subtle aspects that can make a web page and a web site look bad, messy or (heaven forbid!) amateurish, one of these is too many fonts on the page.

Web site designer tips for the beginner
Web site designers today have plenty of options in terms of tools and technologies they can use to build their web pages. Many questions come up: should we use Flash, do we need database driven web pages, do we need a shopping cart for our e-commerce web site, etc …

Graphics in web pages – the types of software you can use
There are many companies selling software to make graphics for both the web and print. All of these products have their own nuances and capabilities, but generally speaking graphic images that have been processed by a computer can usually be divided into two distinct categories.

A look at acronyms used in web design 
An overview of some commonly used technologies in the world of the web.

What you need to get started making websites
Making websites doesn’t require much at all; a text editor like notepad and a browser to test your code and you’re ready to go if you know HTML.

Cascading Style Sheets vs. classic web page design methods
The web today is a much different place than it was just 5 years ago. Technology for the web has grown in leaps and bounds and is reflected in the sites we see and the way they are built…

Working with website designers
This article is targeted at business owners, small and large, who are interested in getting a web site built for them. When approaching a website design firm, or individual web designers, these preliminary questions will go a long way in forwarding the project.

Sending email from a web page
We discuss ways of sending email from a web page.

ASCII Characters: Inserting special characters in your web pages
ASCII stands for American Standard Code for Information Interchange. Computers can only understand numbers, so an ASCII code is the numerical representation of a character …

HTML forms – part 1
An HTML form is made up of a bunch of HTML tags that allow people visiting web sites to enter information or select information from a list that can then be transmitted to the server for processing.

MVC - Learn how to build web applications using MVC
It’s easy to fall into a trap and treat designing dynamic web sites in the same way one treats developing static web sites. In this article we will be looking at how the MVC design pattern works and why we should use it.

Automatic HTML table formatting with JavaScript
I could have taken the easy way out, and just manually colored the many table rows. But I quickly realized that the manual way was going to be just too much freaking work – too much work just goes against my basic sensibilities. Too much video game playing time would be lost, so something had to be done!


You can also find Stefan Mischook’s latest web development and web design tutorials and articles on his ‘Killer’ Blog on Web Design.

Web Development and Design Article Categories:


Tags for this post>>

Two Adobe Illustrator Tutorials

Here are two easy to follow Adobe Illustrator Tutorials from steeldolphin.com. One teaches you how to use the trim tool and the free transform tool. The other shows you how to create a stylized logo using Illustrator.


Creating a Swoosh

In this Adobe Illustrator tutorial you will learn how to use the trim tool, and the free transform tool. This tutorial is targeted to those who are in the beginning stages of learning how to use Illustrator.


Logo Design in Adobe Illustrator

In this tutorial, learn how to create a stylized logo using Adobe Illustrator.

Tags for this post>>

September 5, 2007

Free Outlook 2007 Training

Here are Four Free Training Resources for Learning Outlook 2007. The first one is a free online course that will introduce you on using the Ribbon, finding familiar features, and understanding the new XML file format. The second one is a reference document that shows you the locations of Outlook 2003 commands in Outlook 2007. The third learning resource presents the top 10 tips for using Outlook 2007. The fourth document is a spreadsheet that cross-references all Outlook 2003 menu and toobar items to Outlook 2007′s ribbon interface.


1) Free Outlook 2007 Online Course: Up to Speed with Outlook 2007

After completing this course you will be able to:

  • Move around in Outlook 2007 and understand some of the things that have changed, and why.
  • Find commands on the Ribbon to do the things you do every day: read and send e-mail, work with appointments and meetings, and use your contacts.
  • Send and receive pictures and attachments. Ensure that recipients will be able to open attached files that use the new 2007 Microsoft Office release file formats.
This course includes:
  • Three self-paced lessons and three practice sessions for hands-on experience. Practices require Outlook 2007.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.

Outlook 2007 Course Contents
:

What’s changed and why
Find everyday commands in Outlook 2007
Send and receive attachments and pictures
Feedback

Quick Reference Card


2) Reference: Locations of Outlook 2003 commands in Outlook 2007

This tutorial describes the items of the new Microsoft Office Fluent user interface that are in Microsoft Outlook 2007. It presents Outlook 2003 commands that you may already know, and explains how to do the same things in Outlook 2007.


3) Top 10 Tips for Outlook 2007

The first time you open Outlook 2007 you might be disappointed to see that,on the face of it, Outlook does not display the new ribbon and newinterface that you will see in the other major applications in theOffice 2007 suite such as Word, Outlook, and PowerPoint. Dig a little deeper under the surface, however, and you’ll see that the Ribbon and new interface are there in places. Here are our ten best tips for working with the newOutlook 2007.


4) Outlook Ribbon Mapping Workbook

This spreadsheet (.xls) maps all of the menu and toolbar features and options in Outlook 2003 to the equivalent in Outlook 2007.
  • Actions menuOutl
  • Edit menu
  • File menu
  • Form menu
  • Format menu
  • Help menu
  • Insert menu
  • Layout menu
  • Tools menu
  • View menu
  • Table menu
  • Envelope toolbar
  • Formatting toolbar
  • Standard toolbar
  • Tables and Borders toolbar
  • 3-D Settings toolbar
  • AutoSummarize toolbar
  • AutoText toolbar
  • Compare Side by Side toolbar
  • Diagram toolbar
  • Extended Formatting toolbar
  • Email toolbar
  • Drawing toolbar
  • Drawing Canvass toolbar
  • Forms toolbar
  • Frames toolbar
  • Function Key Display toolbar
  • Header and Footer toolbar
  • Ink Annotations toolbar
  • Ink Drawing and Writing toolbar
  • Mail Merger toolbar
  • Online Meeting toolbar
  • Organization Chart toolbar
  • Outlining toolbar
  • Picture toolbar
  • Print Preview toolbar
  • Reading Layout toolbar
  • Refresh toolbar
  • Reviewing toolbar
  • Shadow Settings toolbar
  • System toolbar
  • Text Box toolbar
  • Visual Basic toolbar
  • Web toolbar
  • Web Tools toolbar
  • Word Count toolbar
  • WordArt toolbar
  • Database toolbar
  • Control Toolbox toolbar
  • Form Design toolbar


Tags for this post>>
September 4, 2007

8 Photoshop and 4 Art Design Tutorials

Here are 8 Photoshop 7 Tutorials from steeldolphin.com. These teach several Photoshop features and effectgs, such as Coloring, Painting, Lineart, that will help you master this important graphics and photo editing application. These Photoshop tutorials are presented in an easy to follow step-by-step format. Also included in this post are 4 Art Design Theory Tutorials, also from this site. These tutorials explain the theory that is behind creating art, and what are the building blocks of successful art and design.


8 Photoshop Tutorials:

Digital Painting Steps
This is a walkthrough of one of the author’s digital paints in Adobe Photoshop.

Cloud painting Tutorial - Photoshop 7
This teaches you how to digitally paint some quick and easy clouds in Adobe Photoshop.

Digital Coloring – Part I – Preparing Lineart for Coloring
This Photoshop tutorial, the next one, will show you to color comics like the pros. This first part explains how this is accomplished, from taking a dirty scan, to creating an alpha channel, to storing your final line art. 

Digital Coloring – Part II – The Render
This digital coloring tutorial part II teaches you how to fully render a comic book art using industry techniques.

Scanning Lineart
This tutorial goes into detail showing you how to scan and clean up line art in Adobe Photoshop.

Ethereal Effect
Learn how to correctly the this effect in Photoshop to incorporate into other objects.

Midnight Effect
A simple Photoshop tutorial that teaches your how to correctly use this effect into other objects.

Unsharp Mask for Sharpening Scans
Discover how to accurately more effectively sharpen your scanned photos in Adobe Photoshop.


4 Art Design Theory Tutorials:

Color Theory Primer
This color theory tutorial provides diagrams of the various color schemes and suggestions for color moods.

Color Schemer Tool
Here is a free utility to assist you with selecting and creating impressive new color schemes for your graphic design and art projects.

Design Tip #1 – Format
First part of an article on the principles and elements of design, explaining the importance of Format.

Design Tip #2 – Line
Second part  of an article on the principles and elements of design, teaching the importance of Line.

Tags for this post>>

Free Training for Access 2007

Here are Three Free Training Resources for Learning Access 2007. The first one is an online course that will get you up to speed with using the Ribbon, finding familiar features, and understanding and using the new XML file format. The second one is a reference tutorial for the locations of Access 2003 commands in Access 2007. The third document is a spreadsheet that maps all Access 2003 menu and toobar items to Access 2007′s ribbon interface.


1) Free Access 2007 Online Course: Up to Speed with Access 2007

After completing this course you will be able to:

  • Download a database from the new Getting Started page.
  • Create database objects by using the new Ribbon.
  • Save and share your data in appropriate formats.
This course includes:
  • Three self-paced lessons and three practice sessions for hands-on experience. Practices require Access 2007.
  • A short test at the end of each lesson; tests are not scored.
  • A Quick Reference Card you can take away from the course.

Access 2007 Course Contents:

Overview

A new beginning
OK, back to work
Save your files in the format that works best
Feedback

Quick Reference Card


2) Reference: Locations of Access 2003 commands in Access 2007

This tutorial describes the items of the new Microsoft Office Fluent user interface that are in Microsoft Access 2007. It also lists commands which you may already know how to use in Access 2003, and explains how to perform the same tasks using Access 2007.


3) Access Ribbon Mapping Workbook

This spreadsheet (.xls) maps all of the menu and toolbar features and options in Access 2003 to the equivalent in Access 2007.
  • Database menu
  • File menu
  • Edit menu
  • View menu
  • Relationships menu
  • Insert menu
  • Query menu
  • Diagram menu
  • Format menu
  • Records menu
  • PivotTable menu
  • PivotChart menu
  • Filter menu
  • Run menu
  • Tools menu
  • Window menu
  • Help menu
  • Formatting toolbar
  • Page View toolbar
  • Alignment and Sizing toolbar
  • Page Design toolbar
  • Web toolbar
  • Macro Design toolbar
  • Toolbox toolbar
  • Print Preview toolbar
  • Report Design toolbar
  • Filter or Sort toolbar
  • Form View toolbar
  • Form Design toolbar
  • Table Datasheet toolbar
  • Table Design toolbar
  • Source Code Control toolbar
  • View Design toolbar
  • Diagram Design toolbar
  • Stored Procedure Design toolbar
  • Trigger Design toolbar
  • Function Design toolbar
  • Font Fill Line toolbar
  • Special Effect toolbar
  • Databsheet Special Effect toolbar
  • Gridlines toolbar
  • Appearance toolbar


Tags for this post>>