The Microsoft Office Specialist Certification program (MOS) provides computer program literacy, measures proficiency, and identifies opportunities for skills enhancement. Successful candidates receive an Office Specialist certificate that sets them apart from their peers in the competitive job market. Microsoft’s MOS (Microsoft Office Specialist) certification is meant for people in any industry and with various job roles who want to demonstrate a high-level of proficiency in the various Office applications: Word, Excel, Access, PowerPoint, and Outlook.. The Microsoft Office Specialist program is the only comprehensive, performance-based certification program approved by Microsoft to validate desktop computer skills using the following Microsoft Office programs:

• Microsoft Word
• Microsoft Excel
• Microsoft Outlook
• Microsoft PowerPoint
• Microsoft Access
• Microsoft Project

Here are several free training documents and tutorials that will help you study and pass the Microsoft Office Certifcation Exams for each given application. These tutorials and practice exams will help you learn and master the Microsoft Office applications, you can use and study these even if you are not planning to take the exam(s). The Cramsession training documents here (pdf format) are available after you register for free.

Word XP MOS Practice Exams with Answers

• MOS Microsoft MOS-WXP v03 19 04 082q
• MOS Microsoft MOS-WXP v04 08 05 082q

Excel XP MOS Practice Exams with Answers

• MOS Microsoft MOS-EXP v10 13 04 084q
• MOS Microsoft MOS-EXP v04 01 05 084q
• MOS Microsoft MOS-E2E v05 12 05 030q

Outlook XP MOS Practice Exams with Answers

• MOS Microsoft MOS-OXP v03 18 04 083q
• MOS Microsoft MOS-OXP v04 07 05 083q

PowerPoint XP MOS Practice Exams with Answers

• MOS Microsoft MOS-P2K v04 16 04 032q

Access XP MOS Database Practice Exams with Answers

• MOS Microsoft MOS-AXP v03 22 04 082q
• MOS Microsoft MOS-AXP v05 23 05 082q

 

MOS XP Cramsession Study Guides

• Access XP / 2002 Study Guide
• Excel XP / 2002 Study Guide
• Outlook XP / 2002 Study Guide
• PowerPoint XP / 2002 Study Guide
• Word XP / 2002 Study Guide

MOS XP Cramsession Expert Study Guides

• Excel XP / 2002 Expert Study Guide
• Word XP / 2002 Expert Study Guide

MOS 2000 Cramsession Study Guides

• Access 2000 Study Guide
• Excel 2000 Study GuideOutlook 2000 Study Guide
• Powerpoint 2000 Study Guide
• Project 2000 Study Guide
• Word 2000 Study Guide

MOS 2000 Cramsession Expert Study Guides

• Excel 2000 Expert Study Guide
• Word 2000 Expert Study Guide

Popularity: 33% [?]

Related Posts:

Free CIW Foundations Certification Exam Training Course

Free Advanced Training for Excel 2003, Outlook 2003, and Word 2003

Free Training for Excel 2003, Outlook 2003, PowerPoint 2003, Word 2003

Free Microsoft Office Live and On-Demand Webcasts

Free Training Videos for Microsoft Office Applications

Tags for this post>> Access | Excel | Outlook | Powerpoint | Word

Nortellearnit.org offers these fantastic free video-based training modules for learning how to work with images, graphics, and photos. By taking and going through these imaging training videos you will learn about the different type of images, image resolution, and image colors. You will also and gain the skills necessary to capture images using digital camaras, screen captures, and scanners. After that you can take the training modules for working with and publishing your images, graphics, and photos, learning how to manipulate and adjust them, and to how format them for the web. Some of these training videos demonstrate the use of Irfanview and Photoshop. Irfanview is a completely free imaging and graphics application.

Free Imaging and Graphics Video-based Training


Introduction

Digital Images [2:31]
An introduction to digital images and the move from film to digital imaging.  
Real | Windows Media | Flash

Digital Imaging Project [2:41]
In this series you can get hands-on experience by completing a collage project using either Irfanview or Photoshop.
Real | Windows Media | Flash


Digital Image Basics

Raster and Vector Images [6:34]
An introduction to raster and vector images, their file types and when to use them.  
Real | Windows Media | Flash

Image Resolution [5:25]
What is image resolution and how does it affect things like file size and image quality?  
Real | Windows Media | Flash

Image Colors [5:11]
How do digital images support colors and how does it work – a little math in this one.  
Real | Windows Media | Flash

Raster File Types [9:47]
A detailed look at raster file types including tiff, png, gif, bitmap, and jpeg.  
Real | Windows Media | Flash

Vector File Types [5:48]
A detailed look at vector file types and the differences from rastor files as well as how they are supported in software and online.  
Real | Windows Media | Flash


Creating Digital Images

Digital Cameras [10:35]
Learn the basic functions of digital cameras and what exactly does 3 Mega pixels mean.  
Real | Windows Media | Flash

Screen Captures [4:39]
How do you capture images from your computer so you can edit and share them?  
Real | Windows Media | Flash

Scanners [8:22]
A scanner is an inexpensive computer peripheral for capturing digital images and more – get to know your scanner.  
Real | Windows Media | Flash

Digital Camera Peripherals [4:47]
Learn more about digital camera peripherals that can help make digital imaging easier for you.  
Real | Windows Media | Flash

Online Images [2:52]
There are lots of digital images online - how do you access them?  
Real | Windows Media | Flash


Working with Digital Images

Digital Imaging Tools [4:47]
An introduction to the many software tools to help you with your digital imaging needs.
Real | Windows Media | Flash

Irfanview - Image Adjustment [5:40]
Irfanview is a free download. This video starts with an introduction to Irfanview and how to do basic adjustments that will make the most of your images.  
Real | Windows Media | Flash

Irfanview - Selection Tools [5:17]
Irfanview and how to use the selection tool to edit and crop your images.  
Real | Windows Media | Flash

Irfanview - Photo Manipulation [5:35]Irfanview and how to do more advanced editing such as red-eye reduction and special effects.  
Real | Windows Media | Flash

Irfanview - Collage Project [6:55]
Create a collage using your images captured from different sources using Irfanview. Learn by practicing all the skills you have seen in this series of videos.  
Real | Windows Media | Flash

Photoshop - Image Adjustment [5:37]
An introduction to Photoshop and basic adjustments to make the most of your images.  
Real | Windows Media | Flash

Photoshop - Selection Tools [7:11]
Photoshop and how to use the different selection tools to edit and crop your images.  
Real | Windows Media | Flash

Photoshop - Photo Manipulation [8:32]
Photoshop and how to do more advanced editing, reduction and special effects.  
Real | Windows Media | Flash

Photoshop - Layers [6:30]
Layers offer a distinct advantage to editing in a more advanced program like Photoshop. Try them out and see how much more you can do.  
Real | Windows Media | Flash

Photoshop - Collage Project [5:17]
Create a collage using your images captured from different sources and Photoshop. Learn by using all the skills you have seen in this series of videos.  
Real | Windows Media | Flash


Publishing

Formatting for the Web [7:19]
What are the basics of getting your images ready for display on the web or computer screen – file size and resolution make a big difference.  
Real | Windows Media | Flash

Storing Pictures [7:55]
You are in the age of digital images and you need to learn new ways to deal with all of the images you are collecting.  
Real | Windows Media | Flash

Printers [7:28]
In the end you will want to print some of your images. What is important so you get good quality printed images of all sizes?  
Real | Windows Media | Flash

Popularity: 20% [?]

Related Posts:

Graphic Imaging Editing Tutorial using Photoshop

Free Training for Photoshop, Illustrator, Dreamweaver, Flash

PowerPoint Video Tutorials

Free Flash 8 Video Tutorials

Free Dreamweaver Video Tutorials

Tags for this post>> Photoshop

Allen Wyatt’s Word Tips provides you over 1,600 free tips and tricks on how to use Word better, faster, and more easily. You can quickly access the answers you need in two ways:

1. Find a topic or feature area below that you need to learn more about, then click on the link. (A bracketed number after a topic indicates the number of articles related to that topic.)
   
2. Enter your question or keywords in the search box at the top-right corner of every page.

Search for answers:
  

Information in this Word learning resource site covers several versions of Microsoft Word, including Word 97, Word 2000, Word 2002, and Word 2003. Tips are clearly marked as to the versions to which they apply.

Over 1600 Microsoft Word Tips

• Bullets and Numbering [52]

• Creating Documents [3]

• Customizing Word [81]

• Editing [331]

• Fields [108]

• Files [139]

• Find and Replace [71]

• Footnotes and Endnotes [38]

• Formatting [494]

• General [80]

• Graphics [163]

• Headers and Footers [25]

• Languages [6]

• Macros [358]

• Master and Subdocuments [8]

• Online and Web [30]

• Outlines [12]

• Printing [172]

• Shortcut Keys [47]

• Sorting Information [11]

• Styles [40]

• Tables [125]

• Templates [25]

• Tools [363]

• Using the Mouse [12]

• Word’s Environment and Interface [112]

• Working with Other Programs [23]

Popularity: 19% [?]

Related Posts:

Word Tips and Tutorials

9 Short Word Tutorials

17 Word 2007 Tutorials

Word Tips and Tricks Tutorial

My First Blog Post: Discovering and Sharing Free Microsoft Office Training

Tags for this post>> Word

Here is a comprehensive linked list of 67 Excel articles, tutorials, and tips covering Excel Add-ins, Excel Charting and Graphing, and Pivot Tables. These learning materials are hosted by three excellent Excel tutorial sites: MrExcel, Chip Pearson, and John Walkenbach, all together containing over 500 Excel Articles and Tutorials.

These Excel articles and tutorials are presented in this post within these categories:

Add-Ins for Excel – Find out where to get Excel add-ins and how to use them.

Charts and Graphing in Excel – Learn how to Chart and Graph in Excel, from beginning to end.

Pivot Tables – Learn this important Excel data analysis feature.

9 Add-Ins for Excel

• Add-Ins - Free, Third-Party Add-Ins
• Analysis Tool Pack-Excel
• Cool accessories for Excel
• Empower Excel with the amazing DigDB Add-In
• Games in Excel
• The Spreadsheet Assistant for Excel
• Use MathEasy Add-In to simplify entering math formulas
• Using the Analysis ToolPack
• Using the Small Business Financial Manager in Excel with Quickbooks Data
  

31 Charting and Graphing Excel Tutorials

• Add a Trendline with 3 clicks
• Business Diagrams & Org Charts
• Charting with Time on the X-axis
• Charting Tips
• Create a Chart with 1 Keystroke
• Create a Time Line
• Creating a thermometer style chart
• Creating a transparent chart series
• Creating combination charts
• Demonstrate fractions with a pie chart
• Drawing with Excel – grid paper
• Expand the Chart Range
• Extend the Data Range
• Extending with Data Points
• Format Charts with Right-Click
• Histogram - Create a Dual Sided Histogram in Excel
• Gantt Chart with Conditional Formatting
• Handle missing data in a line chart
• In-cell Column Chart
• Layouts for column charts
• Multiple charts on a single Chart sheet
• Non-graphic chart directly in a range
• Saving a chart as a GIF file
• SmartArt Graphics in Excel 2007
• Speedometer Charts in Excel
• Students creating bar charts for survey data
• Summarize Data using a Pivot Charts
• Tips for the ‘Perfect Chart’
• Track Progress Towards a Goal
• Track Student Reading Progress with a Dynamic Chart
• Thermometer Charts

27 Excel Tutorials on Pivot Tables

• Access Data with Pivot Tables to Break Through Excel’s 65,536 row limit
• Add Median to Pivot Tables with DigDB’s One-Step-Summary
• Advanced Pivot Table Tips
• Cursor Meaning when Dropping Fields on a Pivot Table
• Monthly Summarizing
• Pareto Analysis with Pivot Tables
• Percent of Total in a Pivot Tables
• Pivot Charts
• Pivot Table: Use the Group Feature to Change to Monthly or Annual Output
• Pivot Tables: Consistent Colors on all Charts
• Pivot Tables: Correct Out-of-Sequence Data
• Pivot Tables: Group Daily Report up to Months
• Pivot Tables: Top 10 Customer Report with Top 10 AutoShow
• Pivot Tables: Use AutoFormat with Pivot Tables
• Pivot Tables: Use VBA to Print All Page Fields
• Pivot Tables: Use VBA to Transform Data for Optimal Analysis
• Pivot Tables to analyze market research data
• Pivot Tables to Summarize Data
• Produce a report for every department with Show Pages
• Replace Pivot Tables with DigDB’s One-Step-Summary
• Summarize Data by the Hour( =Hour() )
• Summarizing data with a pivot table
• Seasonality Analysis with a Pivot Tables
• Summary Table to Database Table
• Unique list of customers with a Pivot Tables
• Using Edit – GoTo to Clean up your Pivot Table
• What is a Pivot Table?

Popularity: 19% [?]

Related Posts:

Free Intermediate Excel Course

9 Excel Tutorials

12 Step-by-Step Excel Tutorials

Free Advanced Excel 2003 Training Manual

2 Excel Tutorials

Tags for this post>> Excel

Here are a total of 187 Excel articles, tutorials, and examples for learning how to create, work with, and use Excel Formulas. These learning materials are hosted by three Excel tutorial sites: MrExcel, Chip Pearson, and John Walkenbach, which host over 500 excellent Excel Articles and Tutorials.

187 Excel Formula Tutorials and Examples

• Absolute References
• Adding every other cell in a column with =SUM(MOD…
• Array to Columns
• Array-CSE Further Uses
• Array-CSE Uses
• Array-CSE Entering using Conditional Sum Wizard
• Arrays-CSE
• Attendance Tracker using COUNTIF
• AutoAverage - using the dropdown next to AutoSum to access other functions
• Automatically add a character in a cell
• Automatically get the date and time with =NOW() Function
• Auto-Update Charts upon entering new data
• Averaging Highest-Lowest
• Averaging Range Values
• Avoid error displays in formulas
• Avoiding error displays in formulas
• Calculating a conditional average
• Calculating Age and Birthdays
• Car Loan Payments in Excel with =PMT() function.
• Calling a Function
• Cell Value vs. Displayed Text
• Change a Cell Value without Changing the Formula
• Changing #N/A to “Your Response” text with =IF()
• Changing ‘All Caps’ to proper text with =PROPER()
• Changing Cell References
• Changing grades (in numeric format) to Letter Grades with =VLOOKUP
• Changing Numbers to Text
• Color -Shading Cells
• Compare ranges by using an array-CSE-formula
• Concatenate values: (Bringing two cell Values together as one)
• Concatenating a cell with text and a cell with a date
• Concatenation
• Conditional Formatting – Referencing another sheet
• Conditional Sum Wizard
• Convert 11.5 to 11 minutes and 30 seconds
• Convert Text to Proper Case
• Coordinates - Degrees, Minutes, Seconds
• Count Between Two Values
• Count Text or Numeric Entries with COUNTA instead of COUNT
• CountIF in an Array-CSE
• CountIf or Sumif with two conditions
• Counting Cells with specific content with =COUNT
• Counting distinct entries in a range
• Creating a “Mega-formula”
• Creating proper names format with =PROPER()
• Custom Function: Parsing with characters
• Dates in Excel from TechTV
• DATEDIF to find the difference between dates
• Dates -Adding and Subtracting
• Dates -As Intervals
• Dates - Calculating # of Days from Today
• Dates -Creating a Series
• Dates -DATEDIF Function
• Dates -Day of the Week(Month)
• Dates -Day of the Week(Year)
• Dates -Determining Quarters
• Dates -Difference Between
• Dice in Excel using RANDBETWEEN
• Dates -Distributing
• Dates -Easter Calculation
• Fill a Range with Weekdays
• Dates -First and Last Day of the Month
• Dates -First Monday
• Dates -Julian
• Dates -Leap Years
• Dates -Number of days in a month
• Dates -Thanksgiving Calculation
• Dates -The day of the year and days remaining
• Dates - Live formula to calculate Today
• Dates -Two Digit Year
• Dates -Week Numbers (ISO)
• Duplicate Entry – Identify
• Duplicate Tooltip over DDE Formula
• Dynamic Range
• Find and Replace
• Find the elapsed time between two time entries
• Find the longest entry in a range of text entries
• Finding an average between two data sets
• Finding Minimum and Maximum Values
• Force a global recalculation
• Formatting Time Values
• Formula Auditing
• Formula to add years to a given date
• Fractions in Excel
• Grades -Calculating and Converting
• Have an IF statement return “Yes”-”No” with =IF
• Hiding your formulas
• High and Low Values – =MAX
• Holidays -Calculating
• How to calculate and display the largest value with =MAX
• How to create a “Top 9″
• How to Reverse the Sign on a Difference
• INDEX(MATCH())
• INDIRECT
• Joining two Columns
• Joining Text in two columns with the Concatenation Operator
• Keeping a running total in an adjacent column with =SUM
• Latitude and Longitude
• Lists -Auto-Numbering
• Lists -Common to Two Lists
• Lists -Minimum and Maximum Values
• Lists -Transpose (Reverse) Order
• Lists -Unique to One of Two
• Loan Payments in Excel with =PMT() function.
• Lookup -Closest Match
• Lookup -Multiple Criteria
• Lookup -Return Value to Left
• Magic Squares in Excel
• Math Exercise Sheets in Excel using RANDBETWEEN
• Matching Lists vith VLOOKUP
• Merge Values to One (using Area Code and Phone Number)
• Most or Least Common Value
• Multiply Hours by Rate
• Named Range
• Naming a Worksheet as the value of a target cell with =INDIRECT Function
• Nested Function
• No Blank Cells
• Ordinal Numbers
• Parsing Dates with =MID Function
• Parsing -Names
• Parsing -Phone Numbers
• Parsing phone numbers with =MID Function
• Paste Special Values to prevent #REF! errors
• Perform two-way table lookups
• Pricing -Bracketing and Progressive
• Proper Case – Changing a Name to Proper Case
• PROPER() function to convert text to upper and lower case
• Random Samples with RAND
• Range -Convert to Columns
• Range -Dynamic
• Range -Named
• Range -Transpose
• Range -Used Cells
• Range -Variable
• Ranking Data
• Ranking without repetitive ranks with =RANK and =COUNTIF
• Referencing a sheet indirectly
• Referencing Cells
• Relative Cell References
• Return End Of Month Date with =DATE
• Return File Name
• Return Nth Value
• Returning specific data on examining a range
• Returning Zero instead of #N/A with =IF()
• Round time to the nearest quarter hour
• Round values to the nearest fraction
• Rounding Numbers with =CEILING
• Rounding numbers with =ROUND
• Rounding time to a specific value
• Rounding to n significant digits
• select Random numbers from a column with =RAND()
• Show Formulas
• Splitting the contents of a cell/column into two distinct cells/columns
• Strings -Counting Characters
• Strings -Counting Characters
• Strings -Extracting Words from a String
• Strings -Most or Least Common
• Sum Every Nth Value
• Sum only the visible cells
• Sum the largest values in a range
• SUMIF in an Array – CSE
• SUMIF to conditionally sum data
• SumIf with two conditions
• Summing times that exceed 24 hours
• Text and values in one cell
• Text value response to input with =IF
• Time -Adding and Subtracting
• Time - Adding When Total is over 24 hours
• Time -Between Two Dates
• Time -Calculating Overtime
• Time -Quick Entry Method
• Time -Range last Updated(Not available after Excel ‘97)
• Time -Rounding
• Transforming Data With Formulas
• Transpose a Range
• Unique Entries -Counting
• Unique Entries -Extracting
• Unique Entries -Ranking
• Use Index and Match to lookup a cell to the left of your key cell
• VLOOKUP
• Use absolute references when tracking student grades
• Working with Dates with =DATE
• Working with time formats with =TEXT
• Worksheets -Referencing Previous and Next
• Worksheets -Return Sheet Name
• Write a Formula that always points to the same column, but is free to move to different rows as it is copied
• Zero Values-Ignoring

Popularity: 82% [?]

Related Posts:

Microsoft Excel Tutorial

Tutorials for Excel 2003 and 2007

Training Tutorials for Micrsoft Word, Excel, and Powerpoint

6 Excel 2007 Tutorials

Free Microsoft Excel Training Tutorials

Tags for this post>> Excel

Microsoft Publisher is a very effective desktop publishing program that helps you design and develop professional quality documents, including creating newsletters, flyers, logos, signs, forms and much more.  With Publisher’s features, you can also combine text, graphics, illustrations, and photographs.  Publisher also uses additional tools over and above those usually found in word processing packages.  The application also includes design templates, graphic manipulation tools, color schemes, and multiple page wizards and templates.

Anderson School District in Pendleton, SC, has provided the following Publisher Tutorial.  It teaches you how to use many features of Publisher, such as creating an advertising flyer, adding color and border to a text frame and editing graphics.  All of the features demonstrated here are also available in Publisher 2003.

Microsoft Publisher Tutorial
(pdf format, 5 pages, 148kb)

• Starting Publisher
• Creating an Advertising Flyer
• Editing Text
• Graphics
• Adding Color and Border to a Text Frame:
• Adding an Attention Getter:
• Saving
• Newsletters
• Importing a File into a Newsletter
• Editing Personal Information Components
• Editing Attention Getters
• Editing the Graphics
• Inserting a Line with Arrows

Popularity: 34% [?]

Related Posts:

Free Microsoft Publisher Video Training

Publisher Tutorial

Microsoft Publisher Tutorials

10 Publisher 2003 Tutorials

Publisher Tutorial

Tags for this post>> Publisher

Anaturb.net offers the following Cascading Style Sheets Reference Guide, with examples, covering text properties, font properties, box properties, list style, background and units.  

Cascading Style Sheets Reference Guide

• Text Properties
• Font Properties
• Box Properties
• List Style
• Background
• Units

Popularity: 19% [?]

Related Posts:

2 CSS Tutorials and Guides

Free Books on Web Development and Programming

Tutorials for Cascading Style Sheets

Cascading Style Sheets Tutorials

2 CSS Training Tutorials

Tags for this post>> CSS

URL: tutorial.templates247.com/tutorial2/ Time: 30 Mins Difficulty Level: Intermediate Summary: How to make a pseudo-zoom effect Assumed knowledge: Tween, Photoshop Filters Author: Chris Calangi Website: Templates247.com Tutorial Files: Source Description: How to make a pseudo-zoom effect. It gives the illusion that you are zooming the actual object from flash. :icon_mrgreen:

Popularity: 21% [?]

Related Posts:

59 Flash Tutorials

21 Flash MX 2004 Tutorials

Free Macromedia Flash MX ActionScript Training Course

7 Flash ActionScript eBooks

Beginning Flash and ActionScript Tutorials

Tags for this post>> Flash

URL: tutorial.templates247.com/tutorial3/ Title: Actionscripted Fader Time: 30 Mins Difficulty Level: Intermediate Summary: How to fade an mc using Actionscript. Assumed knowledge: Tween, Functions / Global, Movieclip Actions Author: Chris Calangi Website: Templates247.com Tutorial Files: Source Description: How to fade an mc using Actionscript. This is a useful script that you can use to fade any movieclip in your flash. URL: tutorial.templates247.com/tutorial3/ :icon_mrgreen:

Popularity: 19% [?]

Related Posts:

Advanced Flash Tutorials

Tags for this post>> Flash

Title: Custom Easing in Flash 8 URL: tutorial.templates247.com/tutorial4/ Time: 30 Mins Difficulty Level: Intermediate Summary: How Custom Easing in flash 8 works. Assumed knowledge: Tween, Custom Easing Author: Chris Calangi Website: Templates247.com Tutorial Files: Source Description: How Custom Easing in flash 8 works. The tutorial describes the basics of Custom Easing a new feature in flash8. URL: tutorial.templates247.com/tutorial4/ :icon_cool:

Popularity: 19% [?]

Related Posts:

12 Excellent Flash Tutorials

51 Flash Tutorials from Layersmagazine.com

Flash Tutorials from InsideGraphics.com

104 Excellent Flash Tutorials

Free Flash 8 Training and Tutorials from Macromedia Flash Developer Center

Tags for this post>> Flash