Microsoft Project For Intermediate/Advanced Level

TECHNICAL PROGRAMS

microsoft project training course banner

Training Videos

This course is for individuals who are proficient in the basic functions, features and commands of Microsoft Project and wish to take their skills to the next level. Emphasis is placed on key topics, including building tasks, creating resources & assigning costs, reporting on progress, resolving scheduling problems and tracking progress. This workshop is especially suited for those who constantly develop, plan & schedule project information, manage resource workloads & expenses and use Gantt & Network diagrams to understand project relationships & dependencies.

At end of this course, you should be able to:

  • Exchange project plan data with other applications
  • Update a project plan
  • Manage project costs
  • Report project data visually
  • Reuse project plan information

Individuals on a project management career path who need to sharpen their skills in scheduling, novice & experienced project managers & schedulers, and anyone who is involved in or responsible for scheduling, estimating, coordinating, controlling, budgeting/staffing of projects & supporting other users of Microsoft Project

1. BUILDING TASKS

  • Establishing Timing for Tasks
    • Changing the Task Type
    • Effort-driven tasks
    • Setting scheduling options
    • Assigning a calendar to a task
  • Creating milestones
  • Using Recurring Tasks
  • Setting Constraints and Deadline Dates
  • Establishing and Setting Dependencies Among Tasks
    • Allowing for delays and overlap

2. CREATING RESOURCES & ASSIGNING COSTS

  • Creating a Resource List
    • Modifying Resource Information
    • Specifying resource availability
    • Modifying a resource’s working hours
  • Assigning Resources to Tasks
  • Removing or replacing a resource assignment

3. UNDERSTANDING THE BASICS OF VIEWS

  • What Is a View?
    • Changing a Table
    • Calendar View
    • Gantt Chart
    • Tracking Gantt
    • Multiple Baselines Gantt
    • Resource Form, Allocation and Graph
    • Task Details Form
  • Customizing Views
    • Hiding and inserting columns
    • Creating a combination view
  • Creating WBS codes
    • Renumbering WBS codes
  • Defining outline numbers

4. REPORTING ON PROGRESS

  • Project Summary
    • Creating Text Reports
  • Customizing reports
    • Cash Flow
    • Preparing reports on work assignments
    • Crosstab report
    • Taking Advantage of Visual Reporting

5. RESOLVING SCHEDULING PROBLEMS

  • Identifying Scheduling Problems
  • Resolving Scheduling Conflicts
  • Adding resources to tasks
    • Using overtime
    • Adding time to tasks
  • Letting Project level resource loads
    • Making adjustments to leveling
  • Changing task constraints
    • Adjusting dependencies
    • Splitting a task
    • Identifying the critical path

6. TRACKING YOUR PROGRESS

  • Making adjustments as you go
  • Using Baselines
    • What is a baseline?
    • Setting a baseline
    • Changing the Baseline
  • Using interim plans
  • Clearing a baseline or interim plan

7. WAYS TO REVIEW PROGRESS

  • Organizing and Updating Process
    • Setting the Project Status Date
    • Setting the Percent Complete value
    • Setting work completed
    • Setting remaining durations
  • Recording progress for manually scheduled tasks
  • Accelerating the updating process
    • Letting Project reschedule uncompleted work

8. MODIFYING TEMPLATES

  • Create a Template from an Existing Project
  • Using a New Template
  • Editing an Existing Template
  • Using Organizer to Edit Templates

9. INTEGRATION WITH OTHER APPLICATIONS

  • Copy and Paste
  • Linking
  • Embedding
  • Exporting to Excel
  • Export Map Wizard
  • Importing Excel data into Project
  • Copy Picture of Gantt Chart
  • Integration with SharePoint
  • Exporting Report Data

10. EARNED VALUE ANALYSIS

  • Understanding Earned Value
  • Interpreting Earned Value
  • Viewing Earned Value Data

11. PROJECT LINKING

  • Master and Sub-projects
  • Remove a sub project
  • Breaking Task Links between Projects
  • Inserting Links
  • Combining Projects

12. SHARED RESOURCE POOL

  • Create a Resource Pool
  • Sharing a Resource Pool
  • Assigning Resources from a Resource Pool
  • Levelling Shared Resources
  • Checking Pool Links
  • Managing Shared Resource Files

13. VBA AND MACROS

  • Macro Security
  • Record a Macro
  • Play a Macro
  • Assign a Macro to the Quick Access Toolbar
  • Assign a Macro to the Ribbon
  • Fixing Mistakes

COURSE METHODOLOGY

Please bring your laptop, hands-on practical sessions. Highly practical, easy to understand/apply with demonstrations, question & answer session, discussion, presentation, relevant exercise, revision sessions for total complete understanding

KENT LAU

Kent Lau holds a Degree (Hons) in Computing. He worked with several software companies as software developer. As a certified Microsoft Office Specialist (MOS Excel Core) and PSMB trainer, he is able to deliver a better, systematic training with proper training methods and trainer’s tool.

Kent had successfully trained more than 2500 participants from the following companies:

Bank Negara MalaysiaTMF Group
TESCO MalaysiaQatar Petrochemical Company Ltd.
Maybank ECCKAF Investment Bank Berhad
LB Aluminium BerhadPanasonic Electronic Devices Malaysia S/B
Nokia Siemen NetworkRoyal Selangor Golf Club
ERIKS Sdn BhdAVNET Malaysia Sdn Bhd
ThaiExpress Sdn BhdThe Venetian Macao-Resort-Hotel
Dentsu Sdn BhdSOMFY Sdn Bhd
SGS Malaysia Sdn BhdUOP Malaysia Sdn Bhd
SGS LabuanKawan Food Berhad
DataStream Solution (Brunei) Sdn BhdFaber Castell Sdn Bhd
Goodrich Global (KL) Sdn BhdELTETE Malaysia Sdn Bhd
MERGE Energy BerhadPuratos Malaysia
SyngentaPUMA
TAR University CollegeNitritex Malaysia Sdn Bhd
MediTech MediaBarry Callebaut Malaysia Sdn Bhd
Telepaper (M) Sdn BhdTJ/H2b Analytical Services, Inc
BP Asia Pacific (Malaysia) Sdn BhdRecron (Malaysia) Sdn. Bhd.
Pamir Development Sdn Bhd, JohorAA Mewah Sdn Bhd
Sam McCoy Engineering Sdn. BhdGODELL
TOTO Malaysia Sdn BhdBranson Ultrasonics
Barry Callebaut Services Asia Pacific S/BNorgren Sdn Bhd

OR

SHIVONNE LOUIS

Shivonne Louis is qualified with a City and Guilds 746 & 747 Diploma in Computer Programming and has 24 years of training specializing in Microsoft Office and Lotus Applications as well as Lotus Notes End User programs. She completed the Microsoft Office 2000 User Specialist Examination (MOUS) in 2001. She has also completed the Microsoft Office XP (2002) and 2003 Specialist (MOS) Exams.

Working Experiences ….

  • 2000 – 2005 (COMAT Horizon Training Services)

Joined as a Corporate Trainer where she trained corporate clients from various industries in Microsoft Office, Lotus Applications and Lotus Notes End User programs.

  • 1996 – 1998 (SEC System Education Centre Sdn Bhd)

Was a Corporate Trainer/Consultant conducting training for corporate customers on Microsoft Office 97 and Lotus Smart Suite’97 applications. Create training manuals on Lotus Smart Suite’97 applications as well as provide hotline support.

  • 1991 – 1996 (Glass Onion Sdn Bhd)

Joined as a Corporate Trainer/Manager. Job description included responsible for the overall setting up of the training labs (software & hardware), create training manuals on all Microsoft Office applications, scheduling training date, administrative duties e.g. preparing quotations and Invoices, Conducted training for corporate clients from multi-national companies and banks.

Certification

Microsoft Office Specialist – MASTER (2000 & XP)

Courses certified (Office 2000, XP & 2003)

  • Microsoft Word Expert
  • Microsoft Excel Expert
  • Microsoft Power Point
  • Microsoft Access
  • Microsoft Outlook

Specialized in the following courses:

Microsoft Office 97Microsoft Office 2000
Microsoft Office XPMicrosoft Office 2003
Microsoft Office 2007Microsoft Office 2010
Microsoft OutlookMicrosoft Project
Microsoft FrontPageMicrosoft Visio
Lotus Smart SuiteLotus Notes End-User
Dreamweaver MXFlash

KENT LAU

1. LB Aluminium Bhd
“Kent is an extraordinary trainer. He has helped us to train our staff to reduce data analysis time in HR department”

2. Nitritex (M) Sdn Bhd
“He also does the extra miles for us to make sure we can immediately apply the knowledge seamlessly”

3. Puratos (M) Sdn Bhd
“He ensures participants able to pick up the skills and encourages participants from time to time”

Close Menu