Free Microsoft Office Training and Tutorial Resources




    



November 18, 2009

Office 2007 Video Tutorial

Here is an excellent Office 2007 Video Tutorial, in wmv format hosted at Office Rocker. This video explains in detail various Office features such as the Partial Ribbon Interface, the Revamped Search in Office, Collapsible Mail folders, RSS features, SharePoint features, the use of XML, new Calendar features, the To-Do Bar, new Flags and follow-up features. This Office tutorial video can be downloaded and saved for later reference, its 14 minutes long and is very helpful and highlights all the features listed below.

Features Taught by this Office tutorial:

 - Partial Ribbon Interface
 -  Revamped Search
 -  Collapsible Mail Folders
 -  RSS Features
 -  SharePoint Features
 -  XML
 - New Calendar Features
 - To-Do Bar
 - New Flags and Follow-up Features



Tags for this post>>

11 Photoshop Tutorials

Here are 11 Photoshop Tutorials, located at handson. These Photoshop tutorials discuss and demonstrate various Photoshop features and tools, such as effects, transparency, backgrounds, colors, masks, and texture wrapping. All of these tutorials can be downloaded and saved for later use.


11 Photoshop Tutorials:

Glass effects
This tutorial imparts knowledge to users on the glass effect and how it can be created in Photoshop.

Drop shadows
This tutorial shows users how to effectively use shadows on images and how shadows can have many variations.

Lighting effects
The lighting effects discussed here show users how to work with the various lighting effects available in Photoshop.

Transparency
Transparency is used by designers between layers and this tutorials show how to use them well.

Dealing with High contrast backgrounds
This tutorials show how to work with high contrast backgrounds and how to use them in Photoshop.

Tiled backgrounds
This tutorial explains how to use tiled backgrounds when working with Photoshop.

216 colors
This tutorial shows how to work with 216 colors when working with GIFs in Photoshop.

Nifty little insert bars
Working with insert bars in Photoshop is discussed in detail in this tutorial.

Lighting effects – Button mask
The tutorial explains working with button masks with a lighting effect in Photoshop.

Lighting effects – more on masks
This tutorial discusses other masks and effects available on masks in Photoshop.

Texture wrapping
This tutorial explains how textures can be wrapped around an object or a shape.



Tags for this post>>

November 17, 2009

10 Excel Tips that Speed up Spreadsheets

Here are two good video tutorials for 10 Excel Tips that Speed up Spreadsheets. Excel is a spreadsheet application from Microsoft that features calculations, graphing tools, pivot tables and a macro programming language called VBA. These two video tutorials explain various features in Excel, such as data entry; moving multiple cells, columns and rows; formatting, charting, inserting line breaks and graphics, and editing strings using functions.


10 Excel Tips to Make Your Life Easier – Part 1
This Excel video tutorial explains how to handle bulk data entry, inserting rows and columns, moving data and utilizing the format painter and format copy tool.

 - Master the Art of Bulk Entry
 - Quickly Inserting Rows & Columns
 - Moving Your Data Around in One Shot
 - Utilize the Format Painter & Format Copying
 - Taking the “Work” out of Worksheets


10 Excel Tips to Make Your Life Easier – Part 2
This video tutorial discusses the use of charts, working with repeated data, inserting line breaks, working with dates, inserting a picture and manipulating strings with functions.

 - Utilizing Quick Charts
 - Easily Remove Repeated Data
 - Inserting Line Breaks & Today’s Date in a Cell
 - Insert a Picture in a Comment
 - Manipulating Strings with Functions



Tags for this post>>

November 13, 2009

9 Photoshop Tutorials

Here are nine Photoshop Tutorials at SwitchOnTheCode.com. These Photoshop tutorials explain some of the important techniques and features used in the most popular graphics editing program, Adobe Photoshop. I think you will find these tutorials useful and helpful.


Creating Duotone Images in Photoshop
This Photoshop tutorial covers taking an image and making it duotone. Duotone simply means two colors.

Do you suck at Photoshop?
This is a series of tutorials created by Donnie Hoyle. This section covers the volumes from 1 through 4.

You Suck At Photoshop – Volume 5
This video tutorial will introduce you to Photoshop’s color select tool.

You Suck at Photoshop – Volumes 6 and 7
The volumes 6 and 7 are covered here. If you don’t like the player, the videos can also be found on YouTube.

White Balance Your Images with Photoshop
With the help of Photoshop, we can fix some of the color problems with a simple click of the mouse. This section covers that.

An Extensive Guide to Photoshop Layer Styles
This tutorial will go through every layer style found in a default installation of Adobe Photoshop CS3, show what it does to your image, and describe some available options.

Photoshop Tutorial – How to Make a Color Picker Gradient
This section will go through all the steps required to create the gradient image using Photoshop.

Photoshop Tutorial – Actions
This section of the tutorial is going to provide a step-by-step guide on how to use Photoshop Actions. Actions are an easy way to apply the same thing (cropping, rotating, filters, etc.) to a large collection of images.

Photoshop Tutorial – Create a Seamless Texture from a Photo
This tutorial will guide you through the process of creating a seamless texture from almost any photo.



Tags for this post>>

HTML And XHTML References and Cheat Sheets

Here are some excellent reference materials and cheat sheets for HTML And XHTML at appletree for all web programmers from the novice to the expert. HTML and XHTML are extensively used for creating and developing interactive web pages. These HTML And XHTML cheat sheets and reference materials here discuss a wide range of topics such as Core HTML, Character Entity Reference Chart, Framesets, DOM, best practices, and configuration options. The reference materials provided here are downloadable in pdf format, and can be used for future use.

 
 - XHTML Best Practice Cheat Sheet 230K   
 - Core HTML 712K   
 - HTML5 Canvas Cheat Sheet 153K    
 - HTML Character Entities Cheat Sheet 495K   
 - HTML Cheat Sheet 62K   
 - HTML DOM 65K   
 - HTML Help Sheet 104K   
 - HTML Help Sheet 02 1.9M   
 - HTML Tidy Configuration Options Quick Reference 148K   
 - Web Designer’s HTML Card 13M   
 - HTML 5 Cheat Sheet 3.0M   
 - What Beautiful HTML Code Looks Like 787K   
 - XHTML Character Entity Reference 163K   
 - XHTML Cheat Sheet 72K   
 - Character Entity Chart 121K   
 - HTML Cheat Sheet 342K   
 - HTML 5 Cheat Sheet 75K   
 - HTML Elements Coordinates 137K   
 - XHTML 1.0 Frameset 64K   
 - XHTML 1.0 Strict 62K   
 - XHTML 1.0 Transitional 64K 



Tags for this post>> |

Word, Excel, and Office Tutorials

Here are some very good tutorials on Word, Excel, and MS Office, hosted by University of Florida. These Word, Excel, and Office tutorials discuss and demonstrate the important features of Microsoft Word, Excel and Office that combine together to provide users with a powerful word editing application and a spreadsheet program. These Office tutorials can be downloaded (doc and ppt formats) and saved for later reference.


Microsoft Office: Word and Excel 531 Kb, 22 pages)
This Word and Excel tutorial discusses features such as tables, toolbars, cell addresses, splitting cells and complex cell manipulation.

 - Word Tables
 - Word Tables and Borders Toolbar
 - Math in Word Tables
 - Math in Excel
 - Order of Operations
 - Cell Addresses
 - Splitting Cells in Microsoft Word
 - Dealing with Complex Cells in Microsoft Word
 - Splitting Cells in Microsoft Excel (Text to Columns)
 - Dealing with Complex Cells in Microsoft Excel


Microsoft Office 2003: Word and Excel  (538 Kb, 23 pages)
This Word and Excel tutorial explains features in Microsoft Office 2003, including math functions in Word and Excel, splitting cells, complex cell manipulation and the creation of tables.

 - Creating Tables
 - Tables and Borders Toolbar
 - Math in Word Tables
 - Math in Excel
 - Functions
 - Splitting Cells in Microsoft Word
 - Dealing with Complex Cells in Microsoft Word
 - Splitting Cells in Microsoft Excel (Text to Columns)
 - Dealing with Complex Cells in Microsoft Excel


Microsoft Office: Drawing Toolbar  (372 Kb, 15 pages)
This tutorial discusses the drawing toolbar in Microsoft Office with its autoshapes, the draw menu, wrapping text around objects and tips and tricks for drawing objects.

 - Drawing Toolbar
 - AutoShapes
 - The Draw Menu
 - Wrapping Text Around Objects in Word 97
 - Wrapping Text Around Objects in Word 2000
 - Tips and Tricks for Graphics and Drawing Objects


Microsoft Office Overview  (719 Kb, 23 slides)
This PowerPoint presentation is a handout of the features of Microsoft Office and its applications.


Microsoft Office Overview  (2.7 Mb, 23 slides)
This PowerPoint presentation provides an in-depth overview of Microsoft Office and its applications.

 - Word
 - Excel
 - PowerPoint
 - Access



Tags for this post>> | | |

November 3, 2009

Excellent PowerPoint Tutorials

These excellent PowerPoint Tutorials and Handouts at Health Science Center Training, University of Florida, discuss and teach many of the important features of PowerPoint 2003 and PowerPoint 2007. Microsoft PowerPoint is a very popular presentation program for the Mac and Windows. These PowerPoint tutorials explain the basics of PowerPoint, followed by PowerPoint formats, animation, and charts and graphs. They can be downloaded and saved for later reference.


PowerPoint 2003 Basics 1.75 Mb
This tutorial provides an in-depth coverage of the basics of PowerPoint 2003 with screenshots.
 
PowerPoint 2003  Formats  59 Kb
This tutorial discusses the various formats that PowerPoint uses when saving presentation documents.
    
PowerPoint 2003_Animation  818 Kb
This tutorial imparts knowledge about the various animation effects that are available to users in PowerPoint
       
PowerPoint 2003_Charts and graphs 842.5 Kb
This tutorial explains how charts and graphs are used with related data for creating an effective presentation.

 - PowerPoint 2003 Animation-Handout  242 Kb  
 - PowerPoint 2003_Animations_Exercise  2. 5 Mb  
 - PowerPoint 2003_ChartsnGraphs 1.36 Mb  
 - PowerPoint 2003_Images 1.93 Mb  
 - PowerPoint 2003_Images 5.12 Mb      
 - PowerPoint 2003_Webify 1.18 Mb
 - PowerPoint 2003_Webify_Comparison 61.5 Kb  
 - PowerPoint 2003_Preliminary Findings 3.67 Mb  
 - PowerPoint 2003_Preliminary Findings_done 3.8 Mb    
 - Animation 903 Kb  
 - More Animations 1.6 Mb  
 - Cheltenham Tables & Charts 240 Kb  
 - Creating a Poster  Using PowerPoint 2007 2.9 Mb  
 - Custom Animations.ppt 69.5 Kb
 - Inserting Clip Art into PowerPoint 253 Kb  
 - Creating a Logo 7 Mb  
 - PowerPoint 2003 2.6 Mb  
 - Posters Presentation 5.1 Mb  
 - PowerPoint 2003 Basics Addendum 447 Kb    
 - PowerPoint Basics 879 Kb
 - PowerPoint Basics Old 802 Kb  
 - PowerPoint Posters 487 Kb  
 - PowerPoint-Charts-and-Graphs 202 Kb  
 - PowerPoint-Level-2 846 Kb  
 - PowerPoint-Webify 1.2 Mb  
 - PowerPoint 2003_Charts and Graphs 470 kb   
 - PowerPoint_2003 1003 Kb  
 - PowerPoint 2003 Basics 1.8 Mb
 - PowerPoint Outline 34 Kb  
 - Powerpoint Basics Addendum 815 Kb
 - Presentation Ideas 1.33 Mb     
 - Presentation Template 2.85 Mb  
 - Powerpoint 2003 Animations 834 Kb
 - Presenting  Report  Information  MA 927 Kb
 - Sample Poster 947 Kb
 - Templates Presentation 1.4 Mb  
 - Webify Addendum 117 Kb  
 - Webify Format Comparison 26.5 Kb  
 - Webify 1.18 Mb

 - PowerPoint 2007_Charts and Graphs  875 kb  
 - PowerPoint 2007 Making Templates 3.2 MB
 - 2007_PowerPoint-Animation-Handout 637 Kb
 - 2007_PowerPoint_Charts and Graphs 1.2 Mb  
 - 2007_PowerPoint_Images 2 Mb  
 - 2007_PowerPoint_Images 2.3 Mb
 - 2007_PowerPoint_Images 4.1 Mb
 - 2007_PowerPoint_Images_DRAFT 5.8 Mb
 - 2007_PowerPoint  Basics  (doc) 5.7  Mb  
 - 2007_PowerPoint  Basics (pdf) 1.6 Mb
 - PowerPoint 2007 2.7 Mb
 - PowerPoint Basics 2007 3.3 Mb
 - PowerPoint Basics 2007 956 Kb



Tags for this post>> | |

3 Adobe Acrobat Tutorials

These 3 excellent Acrobat Tutorials at Health Science Center Training, University of Florida, will provide you understanding about how to use Adobe Acrobat 8 and its new features. Acrobat is a family of computer programs developed by Adobe Systems to create, view and manage PDF files. These Acrobat tutorials start with the basic features and cover more advanced ones, such as Forms. These Acrobat tutorials are in doc and pdf format and can be downloaded for later reference.


Acrobat 8 Fundamentals Tutorial  (746 Kb, 11 pages)
This tutorial discusses the basics of Adobe Acrobat 8 such as the creation of PDF documents, its user interface, the navigation pane, bookmarks and signatures. This tutorial also can be downloaded as pdf.

 - Getting Started
 - PDF Documents
 - Creating PDF Documents from Originating Applications
 - The Adobe Acrobat 8 Professional Interface
 - Toolbars
 - Navigation Pane
 - Creating PDF Documents from within Acrobat
 - Security
 - Signatures
 - Bookmarks
 - Working with pages
 - Editing Text and Images – Advanced Editing Toolbar
 - Comment and Markup


Acrobat 8 Forms Tutorial  (421 Kb, 15 pages)
This tutorial explains to users how to create forms, how to use the forms toolbar, creating spreadsheets from data files and submitting forms.

 - Forms
 - Creating forms
 - Forms Toolbar
 - Add Form Fields to the .pdf document
 - Form Field Characteristics
 - Creating multiples
 - Positioning and Aligning fields
 - Selecting Fields
 - Submit the Form
 - Returning the information by email – Users view
 - Create Spreadsheet from data files
 - Form Field Recognition


Acrobat 9 Fundamentals Tutorial  (421 Kb, 17 pages)
This tutorial presents users with the important features of Adobe Acrobat 9. These features include creating PDF documents, security features, the toolbars, editing text and images and creating headers and footers.

 - Getting Started
 - PDF Documents
 - Creating PDF Documents from Originating Applications
 - The Adobe Acrobat 9 Professional Interface
 - Toolbars
 - Navigation Pane
 - Creating PDF Documents from within Acrobat
 - Security
 - Signatures
 - Bookmarks
 - Working with pages
 - Editing Text and Images – Advanced Editing Toolbar
 - Comment and Markup
 - Creating Headers and Footers


Update Jan. 28, 2011:

Here is their Acrobat 9 Forms Tutorial, describing how to create forms, how to use the forms toolbar, creating spreadsheets from data files and submitting Acrobat forms.



Tags for this post>>