Free Microsoft Office Training and Tutorial Resources




    



September 15, 2010

5 Project 2007 Training Tutorials

Here are 5 Project 2007 Training Tutorials, located at agileconcepts. All of these are in pptx Powerpoint format. These MS Project learning tutorials will show you how to work with lag/lead times, task dependencies, creating a web page of your project, and copying your project information to other Office applications.


3 Beginning Project 2007 Tutorials:

(pptx) Learn How to Create Lag Time and Lead Time in your projects

(pptx) Creating task Dependency Links so Project Tasks are in a Locked Order

(pptx) How to Use Dependency Links to Adjust the Schedule when your Plan changes


2 Intermediate Project 2007 Tutorials:

(pptx) Copying your Project Information to a Web Page

(pptx) How to Copy your Project information to an Office application



Tags for this post>> |

May 13, 2010

20 Office 2007 eBooks

Here are 20 downloadable MS Office eBooks, mostly for the Office 2007 version, including Word, Excel, Access, Outlook, and Project. These are in PDF an CHM (Windows Help) format.


Microsoft Office eBooks:
 - Outlook 2007
 - Word 2007
 - Access 2007
 - Excel 2007
 - Project 2007
 - Access 2007
 - Microsoft Office 2007
 - Excel 2007 VBA
 - Programming Excel
 - Excel Data Analysis with SQL
 - Excel VBA and dotNet
 - Access VBA
 - Access 2007 VBA



Tags for this post>> | | | | |

April 9, 2010

Microsoft Project Reference Guide

Here is a Microsoft Project Reference Guide, located at Ohio University. This Project tutorial reference teaches you about several important features of this project management application, and will assist you in developing plans, assigning resources to tasks, tracking progress, managing budgets and analyzing workloads. The topics listed below include screenshots with explanations. This document is in pdf format.


Microsoft Project Reference Guide  (8 pages, 252kb)
 - Project groundwork
 - Enter tasks and estimate durations
 - List resources and costs
 - Customizing views



Tags for this post>>

January 21, 2010

eBooks on Office, Excel, Access, Powerpoint, and Project


Update: Here are 7 more Microsoft Office eBooks, covering Excel, Word, Access, PowerPoint, and Project. The first 3 are in Windows Help format (chm) and the last for are in pdf format.


 - Excel ebook

 - Word ebook

 - Microsoft Access ebook

 - Powerpoint 2003 ebook

 - Microsoft Project 2003 ebook

 - Microsoft Office 2003 ebook

 - Microsoft Office 2007 ebook

Here are 10 eBooks covering Microsoft Office, Excel, Access, and Project.


 - Excel 2003 ebook 1
 - Excel 2003 ebook 2
 - Excel 2003 Programming ebook 1
 - Excel Programming ebook 2

 - Microsoft Office 2003 ebook 1
 - Microsoft Office 2003 ebook 2

 - Microsoft Access 2003 ebook 1
 - Microsoft Access 2003 ebook 2
 - Microsoft Access 2003 ebook 3

 - Microsoft Project 2003 ebook



Tags for this post>> | | | | |

February 16, 2009

Free Microsoft Project 2007 Class

Here is HP’s Free Microsoft Project 2007 Class, which will give you a good introduction to Project management using Microsoft Project. This online course, available 24/7, will help you to sharpen and demonstrate your project management skills. You’ll learn the basics of project management  and how to manage a project’s scope, deadlines, costs and resources using Project 2007. You can enroll for free at any time.

Project features you will learn:
 - Understand project management basics of time, money, resources and scope
 - Set up and manage tasks
 - Manage human and material resources
 - Track projects more effectively


Project 2007 Class Lessons
:

Lesson 1: Introduction to Project Management
This lesson provides the basics of managing a project using Microsoft Project 2007. You’ll discover how Project 2007 can help you manage project time, resources, costs and scope, plus you’ll learn how to get started in Project 2007.

Lesson 2: Working with Tasks
Defining, listing, organizing and scheduling tasks are key to any project’s success. In this lesson, you’ll discover how to list tasks in a project, organize them into phases and schedule them to be certain your project comes in on time.

Lesson 3: Managing Resources
Most projects involve multiple resources. In this lesson, you’ll discover how to assign people and equipment to tasks and define working times for resources to ensure effective resource management.

Lesson 4: Tracking and Reporting
Once a project has been created and resources assigned, you need to track the project and create reports. In this lesson, you’ll learn how to save a baseline of your project, enter progress data, print your plan and generate reports.



Tags for this post>>

June 19, 2008

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


Tags for this post>> | | | | | |
June 18, 2008

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


Tags for this post>> | | | | | | |
June 17, 2008

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



Tags for this post>>

May 27, 2008

Download Links for Office eBooks

Here are three sites that provide download links for Office eBooks covering all of the Microsoft Office applications, including Word, Excel, PowerPoint, Outlook, Access, Visio, and Project. These computer ebooks are located at download sites like rapidshare.com. On rapidshare.com, you need to click on the ‘Free’ button, and then click on the ‘Download via…’ button (you may need to enter a 3-4 character code). On other download sites you may need to click on the ‘Request ticket’ link.

1) FreeBookSpot links to several Office eBooks in its Microsoft Office category.  Some ebooks on this site have two or three download links. The link(s) to download each ebook are under the Download Instructions heading on each ebook’s description page.

2) Here is Computerebook.net‘s Office category. To download an ebook from this site, you need to first click on the link under the ‘Server’ column on the ebook’s description page, then on the next page click on the ‘Download eBook’ link. Some of these links are not working.

3) Lastly, here is KnowFree 2.0′s Office category. Some of the links on this site are not working, but many are.


Tags for this post>> | | | | | |

September 13, 2007

Freely Available Microsoft Office eBooks

Here are links to freely available Microsoft Office ebooks from freebooklinks.com. This site bills itselfs as “A 100% free resource to hundreds of free ebook downloads from all over the web.”


Freely Available Microsoft Office eBooks



Tags for this post>> | | | | | | | | |
May 9, 2007

2 Microsoft Project Tutorials

Here are 2 Microsoft Project Tutorials loaded with screens shots that demonstrate the features being taught. Also included here are 2 pages of discussions about project management, what it is and some recommendations about how to do it right. These tutorials describe the basic concepts of project management using Microsoft Project.


Project Management with Microsoft Project  
 
Project Management 1

  • Projects, their outcomes
  • What does it mean to manage a project?
  • The ‘Systems view’
  • Project phases
Project Management 2
  • Pitfalls of ad hoc management
  • The shoot-from-the-hip style doesn’t cut it
  • Discipline and flexibility
  • Common sense as a management technique
Microsoft Project 1
  • Define the project
  • Establish a timeline
  • Arrange tasks
  • Critical Path Management (CPM/PERT
Microsoft Project 2
  • Manage the resources
  • People and materials
  • Track costs


Tags for this post>>
March 22, 2007

Office Quick Reference Guides

Here are eight excellent 2-page Office Quick Reference Guides for Word 2003, Excel 2003, Outlook 2003 and 2002, PowerPoint 2003, Project 2002, and Visio Professional 2003 and 2002. These will come in handy when you need to find out how to do a task and perform a feature quickly in these Office applications.

Word 2003

Excel 2003

Outlook 2003

Outlook 2002

PowerPoint 2003

Project 2002

Visio 2003 Professional

Visio 2002 Professional



Tags for this post>> | | | | | | | | | |

December 13, 2006

Microsoft Project and Gantt Chart Tutorials

This is a nicely illustrated, 2-page tutorial covering Microsoft Project that introduces you to Project and demonstrates its basic functionality. This application has many features and capabilities and some of the most important are shown in this tutorial.

Microsoft Project Tutorial


Gantt Charts are an important concept that is used in Microsoft Project and its important to understand how to use these types of charts. Here is a 4 page GANTT Chart Tutorial (pdf) that discusses project planning basics (tasks, milestones, work breakdown statements) and how to use Project to make Gantt Charts. Also, here is how to Design the GANTT Chart (pdf).



Tags for this post>>
October 10, 2006

Microsoft Project Slides, Examples, and Tutorial

These Workshop Slides, Examples, and Tutorial will teach you how to use Microsoft Project. The Project tutorial contains illustrated explanations and examples of the features being taught, followed by detailed learning activities. These slides, examples and tutorial will help you will learn the basic skills for using and understanding Project’s features and functions.


Project Management Workshop Slides, Examples, and Tutorial

  • Project Management Concepts Presentation – 42 Slides
    • Project Management Concepts
    • Why bother?
    • Survey Results
    • Projects, Programs, and Operations
    • What is a Project?
    • Why Projects Fail
    • Golden Rules of Project Success
    • Golden Rules (continued)
    • Purpose of Project Management
    • Project Management
    • Stakeholders
    • Success of a Project
    • Communications Channels
    • Successful Project Manager
    • Basic Project Management Step
    • Initiate the Project
    • Plan
    • Implement
    • Close
    • Project Life Cycle
    • Task Definition
    • Work Breakdown Structure: Outline FormWork Breakdown Structure: Hierarchical Form
    • Common Project Management Diagrams: Gantt Charts,  Calendars, PERT Charts & Critical Paths
    • Project Tracking

  • Introduction to Microsoft Project (pdf, 32 pages, 212kb)
    • Project Environment
    • File Management
      • Creating a new project
      • Opening an Existing Project
      • Saving a Project
    • Project Templates
    • Project Views
    • Tasks
      • Types of tasks
      • Tasks Entry Form
      • New Tasks
      • Moving Tasks
      • Recurring Tasks
      • Deleting Tasks
      • Linking Tasks
    • Resources
      • Adding Resources
      • Removing a Resource
      • Assigning Resources
      • Removing Resource Assignments
      • Viewing Resource Information
    • Data Storage
    • Viewing Project Data
      • Calendar View
      • Gantt Chart
      • Network Diagrams
    • Maintaining your project
      • Creating a baseline
      • Viewing your baseline task sheet
      • Updating Tasks
      • Updating Tasks
      • Tracking Gantt Chart
    • Tools
      • Spell Check
      • AutoCorrect
    • Project Reports
      • Standard Reports
      • Viewing Standard Reports
  • Microsoft Project Class Files [zip] (9 .mpp documents, 176kb)
Example Reports: Project Plan Template
  • Template Outline is as follows: Executive Summary, Scope, Limitations, Description of Work, Baseline Schedule, Resource Requirements, Cost Analysis, Progress Reports, Attachmentes / References.
  • PDF Version (4 pages, 10kb)
  • Word Version (4 pages)


Tags for this post>>
August 9, 2006

3 Free Microsoft Project Ebooks

Here are 3 freely available ebooks on Microsoft Project 2003 and 2002 (XP). Project is the task and resource scheduling application in the Microsoft Office application suite. These Project ebooks provide many details and instructions on how to use the features and functions of this resource allocation application.

Dynamic Scheduling With Microsoft Project 2002
(pdf, 8472 kb)

Show Me Microsoft Office Project 2003
(chm, 19203 kb)

Project 2003 Personal Trainer
(chm, 10063 kb)


Tags for this post>>
July 20, 2006

Free Training for FrontPage 2002, Project 2002, and Visio 2002

Here are free Microsoft Office XP training courses for FrontPage 2002, Project 2002, and Visio 2002 offered by the Instruction Technology Group at the University of Nebraska at Lincoln as part of their Microsoft eLearning Library. These interactive Office application training modules and tutorials were created by Microsoft. Note that to view the main training tutorials, you must be using Windows and Internet Explorer, however, you can use any platform/browser to view the Tutorial How-to Steps for each Lesson.

Free Training for FrontPage 2002, Project 2002, and Visio 2002


Core Training for Microsoft FrontPage 2002 / XP

  • Training Modules for Microsoft FrontPage 2002 / XP:
    • Pre-Assessment
    • Getting to Know FrontPage
    • Creating Your Own Web Site
    • Presenting Information in Lists and Tables
    • Adding Graphics to Your Web Site
    • Creating a Web Site from Scratch
    • Changing Web Page Layout
    • Enhancing Your Web Site
    • Communicating with Your Web Site’s Visitors
    • Creating a Web Site to Support Team Projects
    • Connecting Your Web Site to a Database
    • Hosting a Web Site
    • Managing Your Web Site
    • Post Assessment
    • Quick Reference
    • Glossary


Core Training for Microsoft Project 2002 / XP

  • Training Modules for Microsoft Project 2002 / XP:
    • Pre-Assessment
    • Getting Started with Microsoft Project
    • Creating a Task List
    • Setting Up and Assigning Resources
    • Formatting and Printing Your Plan
    • Tracking Progress on Tasks
    • Fine-Tuning Task Details
    • Fine-Tuning Resource and Assignment Details
    • Fine-Tuning a Project Plan
    • Organizing and Formatting Project Details
    • Publishing Project Information
    • Sharing Project Information with Other Programs
    • Tracking Project Progress
    • Consolidating Projects and Resources
    • Post Assessment
    • Quick Reference
    • Glossary


Core Training for Microsoft Visio 2002 / XP

  • Training Modules for Microsoft Visio 2002 / XP:
    • Pre-Assessment
    • Creating a Diagram
    • Adding Shapes to Diagrams
    • Formatting Shapes and Diagrams
    • Connecting Shapes
    • Creating Project Schedules
    • Creating an Organization Chart
    • Laying Out Office Space
    • Creating a Network Diagram
    • Using Visio with Office XP
    • Customizing Shapes and Templates
    • Post Assessment
    • Quick Reference
    • Glossary


Tags for this post>> | |
July 17, 2006

Free Training for Access 2003, FrontPage 2003, and Project 2003

Here are free Microsoft Office training courses for Access 2003, FrontPage 2003, and Project 2003 offered by the Instruction Technology Group at the University of Nebraska at Lincoln as part of their Microsoft eLearning Library. These interactive Office application training modules and tutorials were created by Microsoft. Note that to view the main training tutorials, you must be using Windows and Internet Explorer, however, you can use any platform/browser to view the Tutorial How-to Steps for each Lesson.

Free Training for Access 2003, FrontPage 2003, and Project 2003


Core Training for Microsoft Access 2003

  • Training Modules for Microsoft Access 2003:
    • Pre-Assessment
    • Getting to Know Access
    • Creating a New Database
    • Importing and Exporting Information
    • Simplifying Data Entry with Forms
    • Locating Specific Information
    • Keeping Information Accurate
    • Working with Reports
    • Making It Easy for Others to Use the Database
    • Keeping Information Secured
    • Post Assessment
    • Quick Reference
    • Glossary


Core Training for Microsoft FrontPage 2003

  • Training Modules for Microsoft FrontPage 2003:
    • Pre-Assessment
    • Understanding How FrontPage Works
    • Creating a Web Site
    • Presenting Information in Lists and Tables
    • Enhancing Your Web Site with Graphics
    • Creating a New Web Site Page by Page
    • Changing Web Page Layout
    • Enhancing the Capabilities of Your Web Site
    • Communicating with Your Visitors
    • Creating a Web Site to Support Team Projects
    • Publishing and Managing Your Web Site
    • Post Assessment
    • Quick Reference
    • Glossary


Core Training for Microsoft Project 2003

  • Training Modules for Microsoft Project 2003:
    • Pre-Assessment
    • Getting Started with Project
    • Creating a Task List
    • Setting Up Resources
    • Assigning Resources to Tasks
    • Formatting a Project Plan
    • Tracking Progress on Tasks
    • Fine-Tuning Task Details
    • Fine-Tuning the Project Plan
    • Organizing and Formatting Project Details
    • Printing Project Information
    • Publishing Project Information Online
    • Sharing Project Information
    • Tracking and Reporting Project Status
    • Getting a Project Back on Track
    • Post Assessment
    • Quick Reference
    • Glossary


Tags for this post>> | | | |
June 6, 2006

Microsoft Office Quick Reference Guides

Rhodes State College offers the following free Quick Reference Guides for all of the Microsoft Office applications, in pdf format. These are excellent for learning the details of many of the features of these software programs.

Microsoft Office Quick Reference Guides


Word: | 1997 | 2000 | 2002 | 2003 |

Excel: | 1997 | 2000 | 2002 | 2003 |

Outlook: | 1997 | 2000 | 2002 | 2004 |

PowerPoint: | 1997 | 2000 | 2002 | 2003 |

Access: | 1997 | 2000 | 2002 | 2003 |

Project: | 2000 | 2002 |

Visio: | 2002 |

FrontPage: | 2000 | 2002 |

Windows: | 1995 | 1998 | 2000 | ME | NT | XP |



Tags for this post>> | | | | | | | | | | | |
May 1, 2006

Freely Available Microsoft Project Ebook

Here is a freely available ebook on Microsoft Project containing 960 pages. Book Description:
  • A comprehensive, soup-to-nuts resource showing how to master Microsoft Project functions and features
  • Demonstrates how to create a new project, track a project’s progress, and work in groups
  • More advanced topics explained are: customizing Project, using macros, and importing and exporting data
  • Also explains the following: building tasks, using views, modifying the appearance of a project, and resolving scheduling and resource problems
  • A new chapter on using Visual Basic for Applications (VBA) and VBScript with Project
  • Provides expanded coverage of Project Server-installation, hardware and software requirements, and software configurations-all needed to ensure that Project Server is administered and used effectively
To access the download link on rapidshare.de, click on the Free button near the bottom of the rapidshare page, wait about 30 seconds, then enter the 3 character code and click on the download button. To uncompress .rar files you can use 7-Zip.

Google groups post with link to Microsoft Project 2003 Bible



Tags for this post>>
April 11, 2006

Tutorials and Help for Microsoft Office Project 2003

Here are lots of tutorials, articles, and support documents for helping you learn and use Microsoft Project 2003. These will get you up-to-speed on and using many of the basic and advanced features of this project planning application. These are authored by Microsoft.

Tutorials and Help for Microsoft Office Project 2003


Startup and Settings
Getting Help | Accessibility | Installing and Customizing | More…

Working with Project Files
Creating and Opening Projects | Saving and Closing Projects | Finding Files

Creating a Project Plan
The Project Map | Establishing the Project Start or Finish Date | Entering Tasks | More…

Viewing Project Information
Using Views | Work with the Network Diagram View | Work with a Predefined or Custom Form | More…

Working with Calendars

Working with Resources and Assignments
Add Resources to Your Project | Resource Pools | Enterprise Resources | More…

Collaboration
Using Microsoft Office Project Server 2003 | Collaborating with the Team | Managing Documents | More…

Tracking Progress
Updating Actuals | Reviewing Progress | Critical Path | More…

Printing
Views | Reports | Printer Setup | More…

OLE and Graphics
Working with Other Programs

Managing Costs
Entering Costs | Viewing Costs | Adjusting Costs

Microsoft Office Project and the Web
Web Toolbar

Work Essentials with Project
Architecture | Consulting | Finance | More…

Columns, Demos, and Quizzes
Crabby Office Lady | Taming Templates | Demos | More…

Reference
Dialog Box Reference | Fields Reference

Programmability
Using the Component Object Model (COM) Add-ins | Using Macros

Security and Privacy
Security | Privacy

Language-Specific Features
Language Setup | Unicode


Tags for this post>>
Next Page »