Course Details
Course Code: Instructor-led
Audience
- Administration Staff
- Financial Executive
- Operational Staff
- Resource and planning team
- Supervisors
- Engineers
Prerequisites
Basic knowledge of Windows is essential with the following pre-requisites:
- Able to switch between task applications
- Able to create a spreadsheet with simple formatting
- Able to use Auto Filter command
- Able to use basic functions – AutoSum, Count, Max, Min and Average functions
Methodology
This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise.
Course Objectives
Upon completion of this program, participants should be able to:
- The Basics
- Setting Up A Project
- Scheduling Work
- Managing Resources
- Managing Tasks
- Creating A Timeline
- Working With Task Calendar, Lag And Lead Time
- Creating Baselines
- Resolving Resource Conflicts
- Tracking Progress
- Creating Progress Lines
- Managing Project Costs
- Comparing Projects
- Printing And Sharing Your Project
- Creating Reports
- Project and other Software
Outlines
Module 1: Getting a summary to meet specific criteria
- Adding up value with SUMIF / SUMIFS
- Finding number of entry with COUNTIF / COUNTIFS
- Average up value with AVERAGEIF / AVERAGEIFS
- return an alternative result with IFERROR
Module 2: Getting a summary to meet specific criteria
- Adding up value with SUMIF / SUMIFS
- Finding number of entry with COUNTIF / COUNTIFS
- Average up value with AVERAGEIF / AVERAGEIFS
- return an alternative result with IFERROR
Module 3: Rules to control user input in a cell
- Dropdown list to limit entries
- Restrict value entry for number and date
- Custom user defined restriction
Module 4: Quick search, compile and compare data from multiple sheets / workbooks
- Vertical search for exact matching data using VLOOKUP
- Horizontal search for matching data using HLOOKUP
- VLOOKUP as alternative for Nested IF function
- Multiple searches with INDEX and MATCH
Module 5: Identify data trends and patterns
- Highlight Cell Rules
- Using Data Bars
- Using Icon Sets
- Creating New Rules with Formula
