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.

Certification by PEAK SUCCESS ABUNDANCE – Graduates Your Colleagues

Certification by PEAK SUCCESS ABUNDANCE – With Thanks

Congratulations on Completing the Training by PEAK SUCCESS ABUNDANCE

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 Malaysia TMF Group
TESCO Malaysia Qatar Petrochemical Company Ltd.
Maybank ECC KAF Investment Bank Berhad
LB Aluminium Berhad Panasonic Electronic Devices Malaysia S/B
Nokia Siemen Network Royal Selangor Golf Club
ERIKS Sdn Bhd AVNET Malaysia Sdn Bhd
ThaiExpress Sdn Bhd The Venetian Macao-Resort-Hotel
Dentsu Sdn Bhd SOMFY Sdn Bhd
SGS Malaysia Sdn Bhd UOP Malaysia Sdn Bhd
SGS Labuan Kawan Food Berhad
DataStream Solution (Brunei) Sdn Bhd Faber Castell Sdn Bhd
Goodrich Global (KL) Sdn Bhd ELTETE Malaysia Sdn Bhd
MERGE Energy Berhad Puratos Malaysia
Syngenta PUMA
TAR University College Nitritex Malaysia Sdn Bhd
MediTech Media Barry Callebaut Malaysia Sdn Bhd
Telepaper (M) Sdn Bhd TJ/H2b Analytical Services, Inc
BP Asia Pacific (Malaysia) Sdn Bhd Recron (Malaysia) Sdn. Bhd.
Pamir Development Sdn Bhd, Johor AA Mewah Sdn Bhd
Sam McCoy Engineering Sdn. Bhd GODELL
TOTO Malaysia Sdn Bhd Branson Ultrasonics
Barry Callebaut Services Asia Pacific S/B Norgren 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 97 Microsoft Office 2000
Microsoft Office XP Microsoft Office 2003
Microsoft Office 2007 Microsoft Office 2010
Microsoft Outlook Microsoft Project
Microsoft FrontPage Microsoft Visio
Lotus Smart Suite Lotus Notes End-User
Dreamweaver MX Flash

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”