Free Microsoft Office Training and Tutorials Blog




    



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


Getting Started Handouts for Word, Excel, PowerPoint, & Access

Here are 4 Getting Started With Training Handouts covering Word, Excel, PowerPoint, and Access, from  the University of Texas. If you need to learn more about these applications' basic features and tasks, then these will help you do that.


Getting Started with Microsoft Word
This handout provides an introduction to Microsoft Word's basic functionality. It covers starting Word, the Word interface, creating a Word document, editing a Word document, selection techniques, paragraph and character formatting, spell checking, printing, graphics and tables.

Getting Started with Microsoft Excel
This handout introduces the basic features of Microsoft Excel. It shows how to enter and edit data, perform formatting, enter formulas, do page setups, and print spreadsheets.

Getting Started with Microsoft PowerPoint
This handout introduces the basic features of Microsoft PowerPoint and shows how to create simple presentations, along with and editing and formatting your PowerPoint slides.

Getting Started with Microsoft Access
Microsoft Access is a relational database application with which you can efficiently save and retrieve data in many formats. This handout explains how to navigate the Access interface, create simple tables and queries, and relate information from one table to another.


12 Free Office 2000 Training Manuals

Here are 12 Free Office 2000 Training Manuals for all of these Microsoft applications: Word, Excel, PowerPoint, Outlook, Access, Project, Visio, and FrontPage. These excellent free Office training documents, from microsofttrainingcourses.co.uk, include tutorials and instructions for learning both introductory and advanced features, and also provide Macro and VBA training. The documents are downloaded in zip format, and when unzipped are in Word (.doc) format. They are comprehensive and teach you all of the features and topics for these apps in a step-by-step format.


MS Office 2000 Training Manuals


MS Word Training Manuals


MS Excel Training Manuals

MS PowerPoint Training Manual

MS Outlook Training Manual
MS Access Training Manuals

MS Project Training Manual
MS FrontPage Training Manual

12 Free Office XP Training Manuals

Here are 12 Free Office XP Training Manuals for all of these Microsoft applications: Word, Excel, PowerPoint, Outlook, Access, Project, Visio, and FrontPage. These excellent free Office training documents, from microsofttrainingcourses.co.uk, include tutorials and instructions for learning both introductory and advanced features, and also provide Macro and VBA training. The documents are downloaded in zip format, and when unzipped are in Word (.doc) format. They are comprehensive and teach you all of the features and topics for these apps in a step-by-step format.


MS Office 2002 / XP Training Manuals


MS Word Training Manuals


MS Excel Training Manuals
MS PowerPoint Training Manual

MS Outlook Training Manual


MS Access Training Manuals

MS Project Training Manual

MS Visio Training Manual

MS FrontPage Training Manual

Free Microsoft Project 2003 Training Manual

Using Microsoft Project, you are able to to define projects, manage, update, and communicate information about a project. The details of the project's tasks and associated resources are entered into the system as a new project.  Project then shows the information such that the relationships of the tasks and their time scales can clearly be seen and potential problem areas identified.

Here is a Free Microsoft Project 2003 Training Manual, from microsofttrainingcourses.co.uk. This training document is 140 pages in length, the zipped download size is 711kb, and the resulting doc file size is 1.3mb. It will teach and show you all of Project's important features and functionality, as listed below, including the 3 main methods of viewing and editing project data: charts, forms, and sheets. Charts can be either Gantt Charts or Network Diagram Charts both of which are a diagrammatic representation of the project data. Forms contain the data relevant to a single specific task or resource. Sheets are a table of all the Tasks or all the Resources that are part of the Project.


Project 2003 Training Manual Table of Contents:

Section 1
Understanding Project Management
Project Language
Terminology
Views and Tables
The Tracking Gantt View
Project's Menus
Project's The Tool Bars
The Stages of Project Management
Monitoring and Adjusting

Section 2
Planning and Defining the Project
Defining the Project
The Goal and Objectives
The Specification and Limitations
Project Properties
Creating a New Base Calendar
Save the New Project File
Saving and Ending a Project Session

Section 3
Entering Tasks
The Task Information box/Task Sheet
Tables and descriptions
In the Gantt Chart or the Task Sheet
Using the Task Information Form
Using The Network Diagram Chart
Adding and Linking Tasks
Defining the Summary Tasks
The AutoCorrect Feature

Section 4
Resource Management
Reviewing and Navigating the Resource Sheet
Adding Resources to the Resource Sheet
The Resource Graph
Set Resource Calendars
Allocate Resources
Review Resource Usage
Working with Resources
Updating Resource Information on the Fly
Planned Time Scale
Lead Time and Lag Time
The Outlining View (Summary)
Promoting and Demoting Tasks

Section 5
Display Data and Cost Factors
Using Gantt Charts
Changing Time Scale and the Palette
Using Network Diagram Charts
Changing the contents of a Node
Changing the layout of the Chart
Elements of the Network Diagram Chart
Applying and Customizing Filters
Examining the Cost Factor

Section 6
Page Setup
Printing Charts, Forms and Sheets
Reports Setup & Editing Reports
Task and Cost Information
Cost information
Reports by Report Type

Section 7
Updating the Project
Updating Task Data
Entering Task Names and Durations
Tracking Progress
Viewing the Gantt Chart and the Resource Graph
Modifying the Project to Match Resources
Levelling
Define an Update Point

Section 8
Multiple Projects
Using Common Resources
Adding Sub Projects
Consolidating Projects created in earlier versions of Project
Recurring Tasks
Task Relationships
The Organizer


Page :  1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 
30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 
60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79