Free Microsoft Office Training and Tutorial Resources




    



July 2, 2008

Free Courseware for Microsoft Office

Rai OpenCourseware offers freely available course content, or courseware, which is literally a “treasure trove of knowledge and related resources”.  Their Computing Courses provide higher education and learning for Information Technology to all students and professionals who like to study and learn on their own. Educational institutions can also use this free course content.

Here is Rai OpenCourseware’s Microsoft Office Training, that will teach you several important features of using Word, PowerPoint, Excel, and Access. These free Office training tutorials are well illustrated and provide step-by-step instructions for using these applications. The course tutorials are in pdf format and are also available here, here, and here.


Basic Concepts Of Computers

 - Computer Organisation
 - Operating System
 - Microsoft Office Overview
 - Introduction Word Processing


Getting Started With Microsot Word

 - Formatting Paragraphs
 - Styles
 - Tables
 - Macros
 - Mail Merge


Introduction To Microsoft PowerPoint

 - Adding Content
 - Color Scheme
 - Master Slides


Introduction To Microsoft Excel

 - Formulas and functions
 - Charts
 - Paper properties and printing


Microsoft Access

 - Table Relationships
 - Queries
 - Forms
 - Reports
 - Importing, Exporting, Linking

Popularity: 26% [?]


Related Posts:
  • Free Microsoft Office Live and On-Demand Webcasts
  • Free Microsoft Office Templates
  • 8 Free Ebooks for Microsoft Word, Excel, Access, Office 2003
  • Microsoft Office Assistance Center
  • Free Books on Microsoft Office, Excel, Project, and FrontPage

  • Tags for this post>> | |

    Free Internet and Website Management Course

    Rai OpenCourseware offers freely available course content, or courseware, which is literally a “treasure trove of knowledge and related resources”.  Their Computing Courses provide higher education and learning for Information Technology to all students and professionals who like to study and learn on their own. Educational institutions can also use this free course content.

    Here is Rai OpenCourseware’s Internet and Website Management Course, that will teach and show you how to use many Internet and Web development technologies, including HTML, Java, Java Servlets, Cookies, DHTML, CSS, VBScript, JavaScript, Perl, XML, software configuration, and website management. These free website application development training tutorial lessons are well illustrated and provide step-by-step instructions for using the Internet technologies and web programming tools and languages being taught. The course tutorials are in pdf format.


    Internet and Website Management Course Lessons:

    Introduction to Client / Server Model
    Introduction To Protocols And Internet Service Providers
    Introduction To Internet Service Providers
    Introduction to Hyper Text Mark-up Language (HTML)
    Frames In HTML
    HTML Style Sheets
    HTML Images And Image Mapping
    HTML Images And Image Mapping
    Making Animated GIF
    Introduction To CGI Scripting
    Introduction To Java
    Data Types
    Variables And Their Assignment
    Objects And Classes
    More On Classes, Java Classes
    Object Oriented Design
    The First Program
    Abstract Window Toolkit
    Applets
    Servlets
    Cookies
    Introduction to DHTML & CSS
    Filters and Transitions
    DHTML Document Object Model
    Direct Animation and The Structured Graphic Control
    Introduction to Multimedia
    VBScript Data Types, Variables, and Operators
    String Processing, Classes & Objects
    JavaScript
    Arrays & Javascript objects
    Common Gateway Interface Concepts & Perl Basics
    Perl Programming Concepts
    XML
    Project Planning
    Software Models
    Software Configuration Management
    Growth model & Risk Management
    Website Management

    Popularity: 26% [?]


    Related Posts:
  • Web-Wise-Wizard – A Web Developers Internet Toolbox
  • 2 Microsoft Project Tutorials
  • Free HTML and Javascript Course
  • Dreamweaver Tutorial on Site Design and Management
  • Web Design Tutorial

  • Tags for this post>> |
    July 3, 2008

    PowerPoint Tutorials from the University of California

    Here are several excellent PowerPoint Training Tutorials from the University of California. These will show and teach you how to use many features of PowerPoint, as shown and linked to below. The first document is a comprehensive PowerPoint Guide with 9 screen video tutorials. This free training document will take you through practices and recommendations for creating and using PowerPoint presentations. This tutorial guide was created using PowerPoint XP and 2003, but many of the specific instructions are also applicable to version 2000. The remaining PowerPoint tutorials are available in several formats: .doc, .pdf, and video.


    PowerPoint Tutorials from the University of California:


    PowerPoint In the Classroom:

    Popularity: 22% [?]


    Related Posts:
  • 6 Powerpoint Tutorials
  • Microsoft Office XP and 2003 Tutorials
  • Inserting Video Into PowerPoint Presentations
  • Photoshop Tutorials from the University of California
  • Microsoft Word, Excel, and PowerPoint Workshop Tutorials and User Guides

  • Tags for this post>>

    2 Web Design and Development Training Guides

    Here are two Web Design and Development Learning Guides hosted by the University of California. The first is a nice 73-page guide covering web design and usability. The second one is a 3-part HTML basics tutorial that will help you get started with developing a web site.


    Web Design and Usability Guidelines
    This 73-page pdf document is an excellent comprehensive Web Design Guide that will help you accurately design your website. (2.35mb)

    Contents of Web Design and Usability Guide:
     - Design Process
     - Design Considerations
     - Content and Content Organization
     - Titles and Headings
     - Page Length
     - Page Layout
     - Font and Text Size
     - Reading and Scanning
     - Links
     - Graphics
     - Search
     - Navigation
     - Software and Hardware
     - Accessibility


    Elementary HTML Tutorial – Part 1

    1. Create a Web Page
    2. Adding Headings
    3. Inserting Breaks
    4. Style
    5. Indented Lists & Sublists

    Elementary HTML Tutorial – Part 2

    6. Visuals – incorporating images
    7. In-house links
    8. Internet links
    9. A Touch-up
    10. Link with Images
    11. Niceties
    12. Organizing Files, Links to folders

    Elementary HTML Tutorial – Part 3

    13. Links within a page
    14. Tables
    15. Tags & References

    Popularity: 23% [?]


    Related Posts:
  • 6 Free Web Design Guides
  • Web Design Reference Guide
  • 15 Web Design Guides
  • Microsoft Office Reference Guide
  • First Blog Post: Discovering Free Web Development and Programming Training

  • Tags for this post>>

    Photoshop Tutorials from the University of California

    Here are several well written Photoshop Training Tutorials from the University of California. These will show you how to use what the author considers the most useful and straight-forward Photoshop techniques for creating, preparing, and fixing images for web pages. They do not go into details about pixels, resolution, and color management.


    Photoshop Tutorials:

     - Optimizing Images for the Web and PowerPoint (.doc, pdf, video-5.6mb)
     - Batch Processing in Photoshop (with emphasis on Cropping) (.doc, pdf)
     - Resizing Images (.doc, pdf)
     - Saving Images in Different File Formats (.doc, pdf, video-4.9mb)
     - Saving Images for the Web (.doc, pdf)

    Adobe Photoshop Tutorial  (9 pages, 1.26mb, pdf format)
      I. Introduction
      II. Finding images
      III. To start this tutorial
      IV. Important Help
      V. Preparing digital images for website posting
      VI. Adding text
      VII. Improving appearance of graphs and figures
      VIII. Final image format

    Photoshop Elements Tutorial  (9 pages, 852kb, pdf format)
    Photoshop Elements is designed to be used with photos from digital camera images, it does have useful tools for editing Web images and it is much less costly than the full Photoshop.
      I. Introduction
      II. Finding images
      III. To start this tutorial
      IV. Important Help
      V. Preparing digital images for website posting
      VI. Adding text
      VII. Improving appearance of graphs and figures
      VIII. Final image format

    Popularity: 21% [?]


    Related Posts:
  • 6 Photoshop Tutorials
  • Dreamweaver Tutorials from the University of California
  • Dreamweaver. Flash, Photoshop Workshop Tutorials and User Guides
  • 2 Photoshop Tutorials
  • High Quality Photoshop Tutorials

  • Tags for this post>>
    July 4, 2008

    Dreamweaver Tutorials from the University of California

    Using Dreamweaver, you can create, view, and organize an entire web site. Although it is possible to start constructing a web site by composing individual pages, it is best to define and set up the general site structure ahead of time. Here are several excellent Dreamweaver Training Tutorials from the University of California. These will show and teach you how to use Dreamweaver’s features to set-up and create a web site, along with preparing images for it.


    Dreamweaver Tutorials from the University of California:

    Dreamweaver Tutorial
    This 38-page, 5-part tutorial guides you through the process of creating a web site with Dreamweaver MX 2004. (38 pages, 2.9mb, pdf format)
       Part I deals with the basic tools.
       Part II tells how to put the material online.
       Part III pertains to site management, and more advanced topics.
       Part IV explains how to construct a style sheet
       Part V is a ready-to-use model for a course website

    Popularity: 22% [?]


    Related Posts:
  • 11 Dreamweaver Tutorials
  • 1-page Dreamweaver Tutorial
  • Dreamweaver. Flash, Photoshop Workshop Tutorials and User Guides
  • Dreamweaver Tutorial on Site Design and Management
  • Free Dreamweaver Training Tutorials

  • Tags for this post>>

    Free Desktop Publishing Course

    Rai OpenCourseware offers freely available course content, or courseware, which is literally a “treasure trove of knowledge and related resources”.  Their Computing Courses provide higher education and learning for Information Technology to all students and professionals who like to study and learn on their own. Educational institutions can also use this free course content.

    Here is Rai OpenCourseware’s Desktop Publishing Training, that will teach you important publishing features and tasks of  Word, PowerPoint, Pagemaker. These free desktop publishing training tutorials are well illustrated and provide step-by-step instructions for using these applications. They are also available here, here, here, and here.


    Desktop Publishing: An Introduction

     - Principles Of Layout And Design
     - Grids And Columns Layout
     - Creating, Saving, Navigating And Viewing A Word Document
     - Working With Multiple Documents,Windows And Text
     - Correcting Spelling And Grammer, Using Theasurus And Symbols
     - File Management And Advanced Printing Options
     - Quiz
     - Assignment


    Learning About Powerpoint


     - Identifying Toolbars
     - Creating Custom Design Templates
     - Creating Bulleted Lists
     - Drawing Objects
     - Using Images And Other “Clip Art”
     - Animating The Presentation-I
     - Animating The Presentation-II
     - Giving An On Screen Presentation
     - Introduction To Photoshop Interface
     - Earse Tools, Paint, Gradient,Transformation
     - House Styles- Styles Guide & Typeface
     - Styles Guide- Headlines & Fonts
     - Projects


    Introduction To Pagemaker


     - Pagemaker Toolbox
     - Laying Out A Pagemaker Document
     - Working With Text
     - Working With Text Exercises
     - Working With Graphic Objects
     - Using The Story Editor
     - Working With Multiple Pages
     - Quiz
     - DTP- Quiz

    Popularity: 21% [?]


    Related Posts:
  • Free Training for Microsoft FrontPage XP and 2003
  • Free Advanced Training for Excel 2003, Outlook 2003, and Word 2003
  • Free Training for Access 2003, FrontPage 2003, and Project 2003
  • Free Training for Advanced Excel XP, Advanced Outlook XP, Advanced Word XP
  • Desktop Publishing Workshop Tutorials for Photoshop, Illustrator, InDesign

  • Tags for this post>>
    July 5, 2008

    Free Internet Technologies Course

    Here is the Internet Technologies Course from Rai OpenCourseware. The tutorials and lessons in this course review and cover serveral important Internet and Web development technologies, including networking and internetworking, OSI, TCP-IP, Internet Hubs and Bridges, Internet Routers, HTML, Java, Java AWT, Java Servlets, DHTML, and VB Script. These free Internet and Web training lessons are well illustrated and provide step-by-step instructions. The course tutorial lessons are in pdf format.


    Course Lessons for Internet Technologies:

    Internet
    Networking & Internetworking
    OSI & Tcp/Ip Model Interconnection: Maintaining End-To-End Service Through Multiple Providers
    Internet Addresses
    Internet Protocol Addresses Hubs And Bridges
    Routing Router Security Switching & Internet Protocol Multicast Mobile Routing
    Browsing The World Wide Web
    Online Services
    Hyper Text Markup Language
    Hyper Text Mark Up Language-I
    Frames & Graphic Designs
    Learning The Java Language
    Language Basics
    Object Basics And Simple Data Objects
    Classes And Inheritance
    Java Input/ Output Streams
    Introduction To AWT
    Java Servlets
    DHTML
    Scripting Introduction To VB Script

    Popularity: 24% [?]


    Related Posts:
  • Free Internet and Website Management Course
  • Web Development Tutorials using Microsoft Technologies
  • 35 Free XML Book Chapters
  • Web-Wise-Wizard – A Web Developers Internet Toolbox
  • 3 Best Flash Tutorials from Sitepoint.com

  • Tags for this post>> |
    July 14, 2008

    60 Free Word 2007 Tutorial Videos

    Here are 60 Free Word 2007 Tutorial Videos (in Flash  format) from Officesessions.com. These are excellent training modules for learning these features and tasks in Word 2007, including editing the fonts, creating a chart, adding clipart, creating headers and footers, home tab, insert tab, mailing tab, paragraph alignment, updating themes, using the thesaurus, add comments, tracking changes, adding graphics, creating tables, updating the style, performing a spell check, encrypting a document, creating bookmarks, make columns, and using watermarks.


    Word 2007 Video Tutorials:

    1. About the Add-Ins Tab
    2. How to Change the Background Color
    3. How to Make Font Bold
    4. How to Change the Font
    5. How to Change the Font Size
    6. How to Create a Chart
    7. How to Add Clipart
    8. How to Change The Text Color
    9. How to Create a Document Compatible with Microsoft Word 97-2003
    10. How to Copy Text
    11. How to Create a New Document
    12. How to Cut Text
    13. How to Create a Footer
    14. How to Create a Header
    15. About the Home Tab
    16. About the Insert Tab
    17. Intro to Microsoft Word 2007
    18. How to Put Words in Italics
    19. How to Left Justify, Right Justify, and Center
    20. About the Mailings Tab
    21. How to Insert Page Numbers
    22. How to Insert Text Boxes
    23. How to Change the Page Color
    24. How to Change Themes
    25. How to View the Word Count
    26. How to Use The Thesaurus
    27. How to Translate Text
    28. How to Add a Comment
    29. How to Track Changes
    30. How to Use the Research Function
    31. How to Open a Document
    32. How to Change the Page Layout
    33. How to Paste Text
    34. How to Add a Picture
    35. How to Print a Document
    36. How to Do a Print Preview
    37. How to Do a Quick Print
    38. About the References Tab
    39. About the Review Tab
    40. How to Edit the Ribbon
    41. How to Save a Document
    42. How to Save a Document Compatible with Word 97-2007
    43. How to Do a Spell Check
    44. How to Change the Style
    45. How to Create a Table
    46. How to Save a Document as a Template
    47. How to Underline Text
    48. About the View Tab
    49. How to Zoom
    50. How to Modify Word Properties
    51. How to Inspect a Document
    52. How to Mark a Document as Final
    53. How to Encrypt a Document
    54. How to Turn Marked as Final Off
    55. How to Create a Bookmark
    56. How to Go to a Bookmark
    57. How to Use Symbols
    58. How to Make Columns
    59. How to Change Orientation
    60. How to Use a Watermark

    Popularity: 28% [?]


    Related Posts:
  • 17 Access 2007 Database Tutorials
  • Word 2007 Interactive Guide
  • Free Training Videos for Microsoft Office Applications
  • 4 Free Word 2007 Classes
  • Word 2007 Slide Presentation

  • Tags for this post>>

    78 Free Excel 2007 Tutorial Videos

    Here are 78 Free Excel 2007 Tutorial Videos (in Flash  format) from Officesessions.com. These are well done training tutorials for the following functionality in Excel 2007: Add-Ins Tab, Data Tab, Formulas Tab, Home Tab, Insert Tab, View Tab, Inspect and Encrypt the worksheet, Edit Fonts, Formta Cells, Find and Replace, Spell Check, Using the Thesaurus, Protect Sheets and Workbooks, Insert Pictures, Insert Clipart, Insert Shapes, Create Charts, Create Headers and Footers, Update the Theme, Display Sum of Cells, Change the Background, Undo and Redo, and the Quick Access Bar..


    Excel 2007 Video Tutorials:

    1.About the Add-Ins Tab
    2. About the Data Tab
    3. How to Delete a Cell
    4. How to Delete a Column
    5. How to Delete a Row
    6. About the Formulas Tab
    7. About the Home Tab
    8. About the Insert Tab
    9. How to Create a Document
    10. How to Open a Document
    11. About the Page Layout Tab
    12. How to Print a Document
    13. How to Use the Print Preview
    14. How to Use the Quick Print
    15. About the Review Tab
    16. How to Save a Document
    17. How to Use the Save As
    18. How to Save as a Binary Document
    19. How to Save for Excel 97-2003
    20. How to Save as a Macro-Enabled
    21. About the View Tab
    22. Properties
    23. Inspect Document
    24. Encrypt Document
    25. Mark as Final
    26. Turn Mark as Final Off
    27. Run Compatibility Checker
    28. Change Font
    29. Change Font Size
    30. How to Put Text in Italics
    31. How to Bold Text
    32. How to Underline Text
    33. How to Change the Text Color
    34. How to Change the Cell Color
    35. How to Center, Left or Right Justify
    36. How to Change a Cell to Dollars
    37. How to Change a Cell to Other Currencies
    38. How to Put a Cell Into Percentage
    39. How to Increase Decimal Places
    40. How to Find Something On the Sheet
    41. How to Replace Found Text
    42. How to Use the Autosum Feature
    43. How to Cut Something
    44. How to Paste Something
    45. How to Use the Spell Check
    46. How to Use the Research Function
    47. How to Use the Thesaurus
    48. How to Use the Translate Function
    49. How to Protect a Sheet
    40. How to Create a Table
    51. How to Zoom In/Out
    52. How to Insert a Picture
    53. How to Insert Clipart
    54. How to Insert Shapes
    55. How to Insert Smart Art
    56. How to Create a Column Chart
    57. How to Create a Line Chart
    58. How to Create a Pie Chart
    59. How to Create a Bar Chart
    60. How to Create a Scatter Chart
    61. How to Create a Area Chart
    62. How to Add Hyperlinks
    63. How to Insert a Text Box
    64. How to Create a Header
    65. How to Create a Footer
    66. How to Insert Word Art
    67. How to Insert a Object
    68. How to Decrease Decimal Places
    69. Into to Excel
    70. How to Copy Something
    71. How to Change the Theme
    72. How to Display Sum of Cells
    73. How to Change the Background
    74. How to Protect a Workbook
    75. How to Add a Sheet
    76. How to Use the Undo Function
    77. How to Use the Redo Function
    78. About the Quick Access Bar

    Popularity: 26% [?]


    Related Posts:
  • 17 Access 2007 Database Tutorials
  • 20 Office 2007 eBooks
  • Free Excel 2007 Course from Dell
  • Free Training Videos for Microsoft Office Applications
  • 6 Excel 2007 Tutorials

  • Tags for this post>>
    Next Page »