Here are 5 Excel XP Training Guides and Tutorials, courtesy of Durham University. These Excel learning documents are will written and will show you many important Excel features, including Charting, Formulas, Functions, Macros, and Data Management. These Excel tutorials are in pdf format. The sample files referred to in these Excel training documents are available here.


An Introduction to Microsoft Excel XP (476kb, 41 pages)
A hands-on beginner’s training tutorial for working with spreadsheets using Excel. Features covered include:  the Excel screen, Task panes, Cell references, entering and editing data into cells, ranges, column widths, formatting cells, working with sheets, borders, spell checking, entering and copying formulas, and creating and working with charts.

Creating Charts in Microsoft Excel XP (677kb, 51 pages)
This Excel tutorial teaches you the steps and knowledge for creating and working with charts in Excel.

Using Formulas and Functions in Microsoft Excel XP (508kb, 50 pages)
This training tutorial gives you step-by-step instructions for performing calculations in Excel XP.

Introduction to Using Macros in Microsoft Excel XP (757kb, 63 pages)
This training guide demonstrates how to use macros in Excel XP. You will learn how to record macros, and write simple macros in Visual Basic for Applications.

Lists and Data Management in Excel XP (420kb)
Learn how to work with and manage lists and data in Excel 2002. 

Popularity: 19% [?]

Related Posts:

4 Excel 2003 Training Guides and Tutorials

Software Learning Guides for Word, Excel, and PowerPoint

Microsoft Word, Excel, and PowerPoint Workshop Tutorials and User Guides

Microsoft Office Articles and Training Tutorials for all Applications

9 Excel Tutorials

Tags for this post>> Excel

Here is a Flash MX 2004 Tutorial that takes you step-by-step, with screen shots, through the process of learning and using Flash to create and publish animations. It teaches you these Flash topics: basic drawing tools and the drawing environment; animation control using the timeline; frame-by-frame, shape tween, and motion tween animations; simple animation control using ActionScript; importing graphics into Flash; and publishing Flash animations in various formats. (319kb, 27 pages, pdf format)


Flash Tutorial Contents:
 - Introduction
 - Definitions
 - Using Flash
 - Basic Tools
 - Vector Graphics
 - Stage Elements and Properties
 - Layers
 - The Timeline
 - Frame-by-Frame Animation
 - Motion Tween Animation with Symbols
 - Editing Symbols
 - Motion Guide Animation
 - Frame Adjustments
 - Shape Tween Animation
 - Breaking Apart Symbols
 - More on Tweening
 - Importing Graphics into Flash
 - Introduction to ActionScript
 - Frame Actions: stop()
 - Button Actions: Event Handlers
 - Publishing Flash Files to the Internet
 - For More Information
 - Getting Additional Help

Here are the Flash Definitions from this document:
ActionScript - Adds interactivity and/or playback efficiency to a movie via coding. Similar to JavaScript, ActionScript is an object-oriented programming language.
Alpha effect – Adjusts the transparency of an instance.
Bitmaps - Images using colored dots, called pixels, arranged within a grid. Typical of most web graphics.
Breaking apart - Converts symbols into basic shapes so that shape tweening can be used.
Button symbol – Used to create interactive buttons in a movie that respond to mouse clicks or other actions.
Component - A pre-made movie clip that provides some functionality, such as a button, a scroll pane, or a progress bar. Components allow you to create animations with complex functionality, but with a minimum of effort.
Easing option – By default, the rate of change between tweened frames is constant. Easing creates a more natural appearance of transformation by gradually adjusting the rate of change.
Frame-by-Frame animation - An animation technique that involves subsequently creating a slightly altered image in sequence and then playing back the entire sequence.
Graphic symbol – Used for static images and to create reusable pieces of animation that are tied to the Timeline of the main movie.
Keyframe - A frame in which a change in an animation is defined. Keyframes are an important part of tweened animation.
Layer - Helps organize symbols and other separate animation entities by allowing you to draw and edit objects on one layer without affecting objects on another layer.
Library – Stores symbols, such as graphic symbols and button symbols, and allows you to view and organize these files as you work. Helps in selecting and copying instances of symbols on the main stage.
Motion guide – Lets you draw paths along which tweened instances, groups, or text blocks can be animated from one keyframe to another.
Motion tweening – To tween the changes in properties of instances, groups, and type, you use motion tweening. Flash can tween position, size, rotation, and skew of instances, groups, and type. Additionally, Flash can tween the color of instances and type, creating gradual color shifts or making an instance fade in or out.
Shape tweening – In shape tweening, you draw a shape at one point in time, and then you change that shape or draw another shape at another point in time. Flash interpolates the values or shapes for the frames in between, creating the “morphing” animation. Symbols must be broken apart before using shape tweening.
Symbol - A reusable graphical object that is stored in a Library. You can then create multiple instances of the symbol. There are three symbol types: graphic, button, and movie clip.
Timeline - Organizes and controls a movie’s content over time in layers and frames. The major components of the Timeline are layers, frames, and the playhead.
Vector graphic – Describes images using lines and curves, called vectors, which also include color and position properties. You can move, resize, reshape, and change the color of a vector graphic without changing the quality of its appearance.

Popularity: 18% [?]

Related Posts:

2 Top Flash MX 2004 Professional Tutorials

12 Free Ebooks for Flash, Dreamweaver, Fireworks, Macromedia CF MX 7

Flash Tutorials and Free Flash Templates

6 Freely available Ebooks for Macromedia Flash

17 Freely Available Flash eBooks

Tags for this post>> Flash

Here are two Word XP Tutorials from Kansas Univeristy, located on their Word Tutorial Handout page. The first is an introduction to Word tutorial, and the second is their intermediate Word training tutorial. Both of these are easy to follow with illustrated screen shots.


Word XP: Introduction

This introductory Word training tutorial will show you how to perform the fundamental tasks with using Word XP. These include: creating a new document, formatting a document, using the toolbars, setting tabs, page setup, selecting text, copying and pasting, undoing mistakes, formatting documents and text, spelling and grammar checking, and printing.
(449kb, 22 pages, pdf format)

The goal of this workshop is to introduce participants to the introductory commands and features of Microsoft Word. After today’s workshop, participants will be able to:
 - Create a new document
 - Use toolbars
 - Apply formatting commands
 - Rearrange text
 - Use the spell checking function
 - Insert and manipulate tabs
  - Save, open, and print a document

Contents of Word XP Introduction Tutorial:
Introduction 
Objectives 
Definitions 
Creating a Document
Toolbars
   Moving and Resizing the Toolbars
Rulers
The Status Bar
Task Pane
Page Setup
Selecting Text
   Select Nonconsecutive Items
Copying and Pasting
Drag and Drop Text
Correcting and Deleting 
Undoing Mistakes
Formatting Documents
Headers and Footers
  Different First Page Header/Footer
Formatting text by using styles
  Applying a different style to text
  Modifying a style
  Creating a new style
Reveal and Adjust Text Formatting
Setting Tabs
Indent Paragraphs
  Create a first-line indent
  Increase or decrease the left indent of a paragraph
  Change the right indent of a paragraph
  Set an indent by using the Tab key
  Create a hanging indent
Spelling and Grammar Checking
Saving Documents
Opening Documents
Easy Access to Documents You Use Often
Word Count Toolbar
Printing
Printing Envelopes
Viewing Multiple Pages in Word
Handy Shortcuts for Word Users
For More Information
  Online
Getting Additional Help 


Word XP: Intermediate

This Intermediate Word training tutorial introduces the following Word topics and tasks: creating and managing tables, inserting and editing images, inserting and using hyperlinks, using editing tools to review and revise documents, and use the Mail Merge utility. (401kb, 23 pages, pdf format)

After using this Word turorial, you will be able to:
 - Create a table
 - Add and delete rows and/or columns from a table
 - Apply borders and shading to a table
 - Insert and edit images in a document
 - Add Section Breaks and Hyperlinks to a document
 - Use the Track Changes tools for reviewing documents
 - Create and edit a main document and a data source for Mail Merge
 - Create and print envelopes using the Mail Merge tool
 - Customize toolbars

Contents of Intermediate Word XP Tutorial:
Introduction
Objectives
Definitions 
Tables 
   Creating a New Table
   Changing a Column Width Manually
   Adding Columns or Rows
   Deleting Columns or Rows
   Moving or Copying the Contents of a Column or Row
   Creating a Table from Existing Text
   Adding Borders and Shading
   Creating Table Headings
Inserting Images
   Inserting ClipArt
   Inserting Pictures from a File
   Clips Online
   Formatting Images
Inserting Symbols
Working with Page Breaks
Inserting Hyperlinks
   Creating a Link
   Using and Modifying Hyperlinks
Mail Merge
   Creating a Mail Merge using the Wizard
   Stopping and Resuming Mail Merge Wizard
   Printing Envelopes Using Mail Merge Wizard
Reviewing Documents
Inserting Comments
   Modifying Comments
   Deleting Comments
   Deleting Multiple Comments
Tracking Changes
   Displaying Tracked Changes
   Reviewing Tracked Changes
   Changing the Look of Tracked Changes
     Changing the size or appearance of balloon text
     Changing the default style for comment text 
     Changing other display and layout options
   Merging Tracked Changes from Several Reviewers into one Document
Toolbars
   Customizing Toolbars 
Getting Additional Help 

Popularity: 17% [?]

Related Posts:

8 Microsoft Word Lessons with Exercises

In Word, How Do I…

Word 2007 Slide Presentation

Microsoft Word Mail Merge Tutorials

Word 2007 Interactive Guide

Tags for this post>> Word

Here are 2 Photoshop CS2 Tutorials from Kansas University that will show you how to use Photoshop to perform many image editing and manipulation tasks. Using Photoshop, you can customize graphics, edit photographs and create images for both print and the web. The first tutorial is an Introduction to Photoshop and the second is an Intermediate Photoshop Tutorial.


Photoshop CS2 Introduction Tutorial

This tutorial covers the fundamental features of Photoshop, including common tools and palettes as well as basic image manipulation. (609kb, 18 pages, pdf format)

After completing this Photoshop tutorial, will be able to do the following:
  – Be familiar with the Photoshop environment.
  – Understand and use the Photoshop Toolbox tools.
  – Use options with each tool with the Option Bar.
  – Use the various work area Palettes.
  – Create images using Layers.

Contents of Photoshop Introduction Tutorial:
 - Introduction
 - Objectives
 - Prerequisites
 - The Photoshop Environment
    - Photoshop Toolbox
    - Overview of the tools
 - Using the tool options bar
    - To display the tool options bar
    - To return a tool or all tools to the default settings
 - Using palettes
    - Displaying palettes
 - Correcting mistakes
    - To undo the last operation
 -    To redo the last operation
 -    To revert to the last saved version
 - The History Palette
 -    To delete one or more states of the image
 -    Using context menus
 - The Color palette
 -    To display the Color palette
 - Working with Layers
 -    The Layers palette
 - Related Training Available from Instructional Services
 - Exercise: To create our little penguin


Intermeditate Photoshop CS2 Tutorial

This tutorial teaches you how to perform advanced selection techniques (masks), raster vs. vector drawing, placing type in images, and filters. It also shows you some useful Photoshop tips, tricks and features. (424kb, 14 pages, pdf format)

Upon finishing this Photoshop tutorial, will be able to do the following:
  – Use color correction techniques for photo retouching.
  – Create Paths for image manipulation
  – Make complex selections using Masks
  – Modify image content with Filters
  – Learn to create advance text graphics with the gradient fill tool.
  – Create a Vignette
  – Use the Picture Package feature for photographs

Contents of Intermediate Photoshop Tutorial:
  – Introduction
  – Objectives
  – Prerequisites
  –    Color Correction
  – Color correction tools
  – Painting versus Drawing
  –    Bitmap versus Vector Graphics
  –    Shapes
  –    Paths
  – Masks
  –    Quick Mask Mode
  –    Alpha Channels
  – Filters
  – Creating gradient filled type with the Type Mask tool
  – Vignette
  – Picture Package
  – For More Information
  – Getting Additional Help

Popularity: 18% [?]

Related Posts:

High Quality Photoshop Tutorials

3 Photoshop eBooks

Photoshop 7 for the Internet Course

Great Photoshop Tutorials

Photoshop Elements for the Web Tutorials

Tags for this post>> Photoshop

Here is a Web Graphics ImageReady Tutorial that will show you how to optimize your images for the web, along with a slide presentation that informs you about the image creation and editing process. Both of these are from Kansas University.


ImageReady Web Graphics Tutorial

This ImageReady tutorial shows you how to do tasks associated with creating, formatting, and manipulating web-based images. It demonstrates using ImageReady to do tasks such as optimizing, slicing, creating rollovers, and GIF animation. (407kb, 14 pages, pdf format)

After completing this Photoshop tutorial, will be able to do the following:
 - Optimize your image file type and file size.
 - Use slicing tools to decrease image/Web page load times.
 - Create interactive navigation buttons using image rollovers.
 - Animate GIF images to use on a Web page.

Contents of ImageReady Web Graphics Tutorial:
Introduction
Objectives
Prerequisites
Web Graphic File Types
   GIF Image File Format
   JPEG Image File Format
   PNG Image File Format
   Optimizing Web Graphics
Using Graphical Slices
   Viewing Slices
   Image Rollovers
   Preview in Browser
Web Animations
   To Insert a Second Frame
   Tween Frames
Getting Additional Help


Graphics Foundation

To create the best possible images you need to make informed choices about various image properties. This slide presentation will help you understand the image production process, from acquisition/creation, through manipulation and editing, saving, and deployment. It covers digital image terminology, such as resolution, color depth, and file formats. (1.9mb, 31 pages, pdf format)

Popularity: 19% [?]

Related Posts:

61 ImageReady Tutorials

9 Photoshop and ImageReady Tutorials

Viewlet Tutorials for Acrobat, GoLive, ImageReady, InDesign, Photoshop

Free Training Tutorials on Photoshop, Flash, Dreamweaver, Fireworks, more

Over 600 Photoshop and ImageReady Tutorials

Tags for this post>> ImageReady

Collectionofbooks.blogspot.com offers a freely available download link for the Dreamweaver ebook, Dreamweaver CS3 Classroom in a Book. To download this ebook, click on the link “Mirror: Download from Depositfiles.com“, then on the depositfiles page, click on the red download button, wait 60 seconds, then enter the 4 character code and click on the red “Download the file” button.

This Dreamweaver ebook will show you how to perform many important tasks and features using Dreamweaver, including the following: how to customize a Dreamweaver workspace, apply cascading style sheets, enter headline and body text, insert graphics and rollovers, add links to a page, add interactive elements, add new code or code snippets, and publish your website to the Web. The ebook is 320 pages in length, in CHM format, and 38.94mb in size.

Popularity: 21% [?]

Related Posts:

10 Freely Available Ebooks for Dreamweaver, Flash, and more

16 eBooks and Books for Photoshop and more

Advanced Microsoft Word Tutorials

2 Free Photoshop 6 eBooks

Tutorials for Common Functions of Office Applications

Tags for this post>> Dreamweaver

Here are four excellent, illustrated Word 2003 Tutorials from Kansas University. These tutorials will teach and show you how to perform many Word tasks and use several important features of Word 2003.


Word Everyday Tasks Tutorial
This Word tutorial demonstrates the fundamental tasks, such as creating a new document, formatting that document, using the toolbars, setting tabs, formatting, spell checking, and printing. (16 pages, 192kb, pdf format)

After completing this Word tutorial, you should be able to:
  - Create a new document
  – Use toolbars
  - Apply formatting commands
  – Rearrange text
  - Use the spell checking function
  – Insert and manipulate tabs
  – Save, open, and print a document

Contents of Word Everyday Tasks Tutorial:
Introduction
Objectives
Definitions
Creating a Document
Toolbars
   Moving and Resizing the Toolbars
Rulers
The Status Bar
Task Pane
Page Setup
Selecting Text
   Select Nonconsecutive Items
Copying and Pasting
Drag and Drop Text
Correcting and Deleting
Undoing Mistakes
Formatting Documents
Setting Tabs
Indent Paragraphs
   Create a first-line indent
   Increase or decrease the left indent of a paragraph
   Change the right indent of a paragraph
   Set an indent by using the Tab key
   Create a hanging indent
Spelling and Grammar Checking
Saving Documents
Opening Documents
Easy Access to Documents You Use Often
Word Count Toolbar
Printing
Printing Envelopes
Viewing Multiple Pages in Word
Handy Shortcuts for Word Users
For More Information
   Online
Getting Additional Help


Word Document Enhancement Tutorial
This Word training tutorial shows ou how to use Word features to perform these tasks: creating and managing tables, inserting and editing images, inserting and using hyperlinks, and using editing tools to review and revise documents.  (16 pages, 252kb, pdf format)

When finished with this Word tutorial you will be able to:
  - Create a table
  – Add and delete rows and/or columns from a table
  – Apply borders and shading to a table
  – Insert and edit images in a document
  - Add Section Breaks and Hyperlinks to a document
  - Customize toolbars

Contents of Word Document Enhancement Tutorial:
Introduction
Objectives
Definitions
Tables
   Creating a New Table
   Changing a Column Width Manually
   Adding Columns or Rows
   Deleting Columns or Rows
   Moving or Copying the Contents of a Column or Row
   Creating a Table from Existing Text
   Adding Borders and Shading
   Creating Table Headings
Inserting Images
   Inserting ClipArt
   Inserting Pictures from a File
   Clips Online
Inserting Symbols
Working with Page Breaks
Inserting Hyperlinks
   Creating a Link
   Using and Modifying Hyperlinks
Headers and Footers
   Different First Page Header/Footer
Toolbars
   Customizing Toolbars
Getting Additional Help


Word Tutorial for Creating Long Documents
This Word tutorial shows how to use Word’s features for creating longer documents, such as dissertations, monographs, long reports, and full-length manuals. These features include footnotes and endnotes; section breaks; special page numbering; automatically generated tables of contents, tables of figures, and indices; and concordance files for use with indices.  (29 pages, 303kb, pdf format)

Contents of Word Tutorial for Creating Long Documents:
Introduction
Definitions
Before You Start: Planning Your Document
   Limits of Word
Setting Up Your Document
   Margins
   Styles
   Page Numbers
Using Section Breaks
   Viewing Section Breaks
   Deleting Section Breaks
Footnotes and Endnotes
   Using EndNote and Word
Cross-References
Generating a Table of Contents
   Updating a Table of Contents.
Generating a Table of Figures
   Labeling Images with Captions
   Building the Table of Figures
Building an Index.
   Manually Marking Index Entries
   Using Concordance Files and Automark.
   Generating the Index
Getting Additional Help


Word Mail Merge Tutorial
Here’s a tutorial showing how Word’s Mail Merge feature works, specifically, how to create a form letter and merge mailing lists to create individualized letters.  (12 pages, 117kb, pdf format)

Upon completion of this Mail Merge tutorial, you will be able to:
  - Create and edit a main document and a data source for Mail Merge
  - Create and print envelopes using the Mail Merge tool

Contents of Word Mail Merge Tutorial:
Introduction
Objectives
Definitions
Mail Merge
Creating a Mail Merge using the Wizard
Stopping and Resuming Mail Merge Wizard
Creating and Printing Envelopes for a mass mailing using Mail Merge Wizard
Getting Additional Help

Popularity: 20% [?]

Related Posts:

Word 2007 Slide Presentation

Microsoft Office XP and 2003 Tutorials

6 Word 2003 Tutorials

Features of Office XP and Office 2003

Word 2003 Tutorial from the University of Texas

Tags for this post>> Word | Word 2003

Getting used to using the new interface, the Ribbon, in Word 2007 takes some time. This Word 2007 Slide Presentation, from Kansas University, will help you learn more about the Ribbon and how you can create and edit Word documents quickly and easily. (28 slides, 1.23mb, pdf format)

Word 2007 Presentation goals:

  – Find out more about the new Word file formats and how they affect you and your work.
  – Learn what the Ribbon does for you to make it easier to create and edit documents.
  - How to find and use the everyday, common Word commands.

Popularity: 25% [?]

Related Posts:

2 Video PowerPoint 2007 Tutorials

PowerPoint 2000-XP Tutorial

4 PowerPoint 2007 Tutorials

2 PowerPoint 2007 Tutorials

Word 2007 Interactive Guide

Tags for this post>> Word 2007

What is Web Accessibility? A web page is accessible if all users are able to access the document and read the content. Users should be able to access it without needing to change their browser, or adjust the browser settings. A well-designed site will work in any browser with any reasonable settings. Many accessibility improvements also make it easier for everyone to use the site. For example, improving the navigation structure of a web site helps everyone, but also especially helps people with poor memory. There are also pure usability problems such as broken links, which affect everyone equally.

Here is an Accessible Web Design Guide, from Durham University, that will help you design and make your web sites accessible to all users, regardless of disability or choice of browser. This Guide explains the benefits of accessible design, and techniques for writing accessible websites. (22 pages, 174kb, pdf)


Contents of Accessible Web Design Guide:
1   About accessibility
  1.1 What is accessibility?
  1.2 What is usability?
  1.3 Legal Requirements
    1.3.1 Quotes from SENDA
    1.3.2 Maguire v Socog
  1.4 Browser compatibility
  1.5 Search Engines
  1.6 University Policy
  1.7 The Web Accessibility Initiative
    1.7.1 Priority 1 recommendations
    1.7.2 Priority 2 recommendations
    1.7.3 Priority 3 recommendations
  1.8 Other terms used in this Guide
2   Finding Accessibility Problems
  2.1 Examples of inaccessible pages
  2.2 Tools for finding accessibility problems
    2.2.1 Web Browsers
    2.2.2 Checking Tools
  2.3 Identifying accessibility problems
    2.3.1 Some of the accessibility problems with the example site
3   Fixing accessibility problems
  3.1 Accessible text
    3.1.1 Example of rewriting text
  3.2 Accessible Graphics
    3.2.1 Using Dreamweaver to make accessible images
    3.2.2 Text Equivalents
    3.2.3 Examples of ‘text equivalents’
  3.3 Accessible Tables  10
    3.3.1 Using Dreamweaver to add header information
    3.3.2 Example of adding headers to tables
  3.4 Accessible use of color
    3.4.1 Partial specification of color
    3.4.2 Specification of colour in Dreamweaver
    3.4.3 Examples
  3.5 Scripts, Java applets, Flash and similar technologies
  3.6 Frames
4   Other accessibility issues
  4.1 Structural Markup
  4.2 Validation
  4.3 Navigation
  4.4 Other areas to consider 
    4.4.1 Tables for layout 
    4.4.2 Forms for user input
    4.4.3 Colour contrast
5   Useful tools
  5.1 Browsers
  5.2 Validators
  5.3 Accessibility Checking Tools
  5.4 Other tools
    5.4.1 Specialist accessibility checking assistants
    5.4.2 Link checkers
    5.4.3 Tidy 
6   Summary

Popularity: 19% [?]

Related Posts:

Creating Accessible Web Pages from a PowerPoint Presentation

Web Site Accessibility Tutorial

Tutorials for FrontPage and Creating Accessible Web Pages

10-page Flash Guide

10 Free Web Design and Development Books

Tags for this post>> Web Design

Here are 4 illustrated Excel 2003 Tutorials from Kansas University that demonstrate how use use many important features of Excel. These tutorials take you step-by-step through each task being taught using screen shots and easy-to-follow instructions. 


Excel Introduction Tutorial

This introductory Excel tutorial will get you going with using Excel to perform fundamental tasks, such as creating, saving, and opening new Excel workbooks and worksheets; selecting, copying, and moving data; constructing formulas; formatting worksheets; and setting up worksheets for printing. (22 pages, 424kb, pdf format)

After using this Excel tutorial, you will be able to:
 - Create, open, and save Excel workbooks
 - Select, copy, and move data
 - Create formulas using relative and absolute references
 - Format worksheets
 - Use Page Setup to set up worksheets for printing

Introduction
Objectives
Definitions
Creating and Opening Excel Workbooks
Inside an Excel Worksheet
Creating Formulas
Editing & Deleting Formulas
Copying Formulas and Values
Changing the Workbook or Worksheet Appearance
Getting Additional Help


Excel Data Management Tutorial
This Excel 2003 tutorial describes you how to use Excel to work with lists, data forms, filtering, and subtotals features, along with managing windows and link to data and formulas. (18 pages, 267kb, pdf format)

After using this Excel tutorial, you should be able to:
 - Sort a data list
 - Filter a data list according to criteria
 - Extract data list information
 - Use the subtotal function
 - Adjust the spreadsheet windows

Contents of Excel Data Management Tutorial:
Introduction
Objectives
Using Excel lists
   Creating a List 
Sorting
   To perform a Simple Sort
   To Sort by Multiple Columns
Data Forms
   Adding Data Using the Data Form
   Finding Records Using Criteria
Filtering Data
   AutoFilter
   Advanced Filters
   Special Features for Filtered Lists
Totals and Subtotals
   Total Row
   Subtotals 
Managing Windows
   Multiple Windows
   Splitting Windows
   Freezing Panes
Linking Data
Getting Additional Help


Excel Tutorial on Functions and Data Analysis Tools
This Excel 2003 tutorial will show you how to use Excel’s functions and data analysis tools. Topics explained include functions such as Average and Sum, and data analysis tools such as pivot tables and conditional summations. (19 pages, 371kb, pdf format)

After reading and applying this Excel tutorial, you will be able to:
 - Define terms related to using functions
 - Create and edit a function
 - Identify add-in functions
 - Perform data analysis using Data Analysis Tools
 - Create a formula with the Conditional Sum wizard
 - Learn to troubleshoot a formula

Contents of Excel Tutorial on Functions and Data Analysis Tools:
Introduction
Objectives
Definitions
Inserting Functions
   Sample Functions
Add-In Commands and Functions
   Loading an Add-In
   Unloading an Add-In 
Data Analysis Tools 
   Histogram
   Conditional Sum
   Analyzing Data with the PivotTable
   Array Formulas
Getting Additional Help


Excel Charting Tutorial
Learn how to use Excel to create and edit charts, modify chart options, and format chart objects, as well as use trendlines, forecasts, and error bars to present data graphically. (17 pages, 361kb, pdf format)

You will be able to do the following after going through this Excel tutorial:
 - Create and edit charts
 - Modify chart options
 - Format chart objects
 - Apply trendlines and error bars

Contents of Excel Charting Tutorial:
Introduction
Objectives
Definitions
Creating a Chart 
   Using the Chart Wizard
Modifying Charts
   Formatting Chart Objects
   Trendlines
Pie Charts
   Creating a Pie Chart
Printing Charts
   Printing an Embedded Chart on a Separate Page
Getting Additional Help

Popularity: 22% [?]

Related Posts:

Excel 2003 Tutorial from the University of Texas

Microsoft Office XP and 2003 Tutorials

4 Excel 2003 Training Guides and Tutorials

5-Lesson Excel 2003 Tutorial

5 Excel 2003 Tutorials

Tags for this post>> Excel | Excel 2003