Exclusive Training Workshops - MS Excel MS Project PMP Project Management
Dear Sir / Madam,
It’s our pleasure to offer you “Professional Training Workshops” on MS Excel, MS Project and PMP ® - Project Management Professional as per following which are designed for:-
ü Accounts & Finance, Commercial, Sales & Marketing, Engineering, Quality, R&D, HR & Administration and IT professionals.
ü Chartered Accountants, ICWA’s, CS’s, Project Managers, Executive Assistants, Personal Assistants, Secretaries.
ü Students of professional courses gearing up for campus placements and jobs.
ü Tech savvy Business owners, and for all those who want to make their life easy with the use of this beautiful tools & techniques.
Once you attend these workshops you will be benefitted in your day to day life to achieve new milestones by bringing efficiency & accuracy in your work.
MS Excel 2007
(One Day – 9.30 am to 5.00 pm)
1) Excel Quick Overview : Difference between Excel 2003 and 2007, Use of Excel, its boundaries & features
2) Data Formatting & Custom settings : Number, Text, Date, Currency, Custom settings. Data formatting & cleaning
3) Conditional Formatting : Once defined, Excel will automatically change the color of your values e.g. up or down, high or low, pass or fail, profit or loss etc.
4) Filters, Queries & Data Sorting : Drill down your data to your desired level based on multiple choices & conditions. Sort data based on your choice e.g. like North, East, West, South rather than alphabetically.
5) Formula Writing & Fixing Errors: Financial, Logical, Text, Day and Time, Statistical, Mathematical etc Sum, Average, Count, Minimum, Maximum, Absolute, Concatenate, Count, CountA, CountBlank, CountIf, Day, Today, Even, Exact, Exp, Find, Int, IsBlank, Left, Len, Lower, Upper, Proper, Now, Power, Rank, Right, Round, Trim etc.
6) If-Then-Else & Nested If commands : You can produce different set of results based on slabs, conditions, stages etc.
7) Vlookup / Hlookup : You have large amount of data placed at different locations & you want to merge it based on common values & it’s relevance. We will show how this can be done with Vlookup & Hlookup.
8) Graphs & Charts : In this workshop you will learn how to create, modify & update graphs / charts like Column, Line, Pie, Bar, Area, Scatter, 3D etc.
9) Hyper / Data Linking : Hyper & data linking, within or outside Worksheet / Excel File is an important feature. This helps update data automatically.
10) Grouping / Ungrouping : Sometime data needs to be grouped for summarized results and crisp view. No problem, grouping and ungrouping feature will help you do so.
11) Pivot Tables : It helps you summarizes your data as per your desire. You need to select data in a range & produce consolidated results in pre-defined or user defined reporting formats.
12) Macros Recording, use, editing, linking : Record, edit and use Macros with little or no programming knowledge, automated recording of functions or actions helps a lot for quick execution with shortcut keys.
13) Security & Protection for worksheet and file : It will help you protect your cells, worksheet or an excel file from unauthorized use.
14) Data validation : With this feature you can prevent wrong data entry in your specified format.
MS Project 2007
(Two Days – 9.30 am to 5.00 pm)
1) Introduction to MS Project
Introduction to MS Project application & it’s usage in current industry scenario’s, Introduction to Project & Project Management
2) Creating a Project Plan
Understanding Project plans, How to create a New Project Plan, Assigning a specific Project Calendar as per our requirements, Adding Tasks to the Project Plan, Entering the Task Duration Estimates, Adding Resources in the Project Plan
3) Managing Tasks in a Project Plan
Understanding tasks, Outlining Tasks in a project plan, Adding a Recurring Task, Linking Dependent Tasks, Setting a Constraint to a Task, Setting a Task Deadline, Adding Notes to a Task
4) Managing Resources in a Project Plan
Understanding resources, Creating a Resource Calendar, Assigning Resources to Tasks, Assigning Additional Resources to a Task, Entering Costs for Resources, Entering Values for Budget Resources, Resolving Resource Conflicts
5) Finalizing the Project Plan
Understanding Critical path, Displaying the Critical Path, Shortening the Project Duration, Setting a Baseline, Printing a Project Summary Report
6) Exchanging Project Plan Data with Other Applications (Only Overview)
Overview of importing Project Information, Exporting Project Plan Data into Excel, Copying a Picture of the Project Plan Information
7) Updating a Project Plan
Entering Task Progress, Entering Overtime Work, Splitting a Task, Rescheduling a Task, Filtering Tasks, Setting an Interim Plan, Creating a Custom Table, Creating a Custom Report
8) Managing Project Costs
Managing and updating project costs, Updating Cost Rate Tables, Grouping Costs, Linking Documents to a Project Plan
9) Reporting Project Data Visually Overview
Understanding Reporting requirements from a Project Plan and knowing options available for reporting, Creating a Visual Report, Customizing a Visual Report as per our specific requirements, Creating a Visual Report Template
10) Questions & Answers
During and after the workshop
PMP ® (Project Management Professional)
(Four Days – 9.30 am to 5.00 pm)
PMP® is a credential offered by the Project Management Institute (PMI), is widely recognized and valued worldwide. Organizations employ PMP certified Project Managers in an attempt to improve the success rate of projects in all areas of knowledge, by applying a standardized and evolving set of project management principles as contained in PMI's PMBOK Guide. Professionals obtain the credential to verify their proficiency in project management with an internationally accepted certificate.
Project & Project Management
a) Project & Project Management Overview
b) Program & Portfolio Management
c) Project Life Cycle
d) Project Management Process Groups
e) Project Initiation
f) Project Planning
g) Project Execution
h) Project Monitoring & Controlling
i) Project Closing
Project Management Knowledge Areas:
a) Project Integration Management
b) Project Scope Management
c) Project Time Management
d) Project Cost Management
e) Project Quality Management
f) Project Human Resource Management
g) Project Communications Management
h) Project Risk Management
i) Project Procurement Management
· Training will be conducted by Authorized Education Provider.
· 35 PDUs will be given to all participant’s.
· Guidance will be provided for
a) PMP application filing
b) Exam Preparation
c) PMP tips
· Lunch and Tea/Coffee along with snacks will be provided to all participant’s.
· Training manual alongwith reference material will be provided by us.
· We suggest you to bring your laptop for the MS Excel & MS Project workshops (not necessary).
PROGRAM CALENDAR & VENUE (Timings 9.30 am to 5.00 pm)
MS Excel
New Delhi 19th September 2010, Sunday
Paharpur Business Center, Opposite Inter Continental,
Nehru Place
Mumbai 19th September 2010, Sunday
Hotel Athithi, 77, Nehru Road, Vile Parle (E),
Near Domestic Airport
Bangalore 26th September 2010, Sunday
Hotel Golden Landmark, 20-21 Seshadri Road,
Race Course Road, Close to MG Road
Chennai 12th September 2010, Sunday
Hotel The Vijay Park, Jawaharlal Nehru Salai,
Inner Ring Road,Arumbakkam
Please also contact for Corporate Workshops throughout India or abroad.
MS Project
New Delhi 25th & 26th September 2010, Sat & Sun
Paharpur Business Center, Opposite Inter Continental,
Nehru Place
Mumbai 25th & 26th September 2010, Sat & Sun
Hotel Athithi, 77, Nehru Road, Vile Parle (E),
Near Domestic Airport
Bangalore 18th & 19th September 2010, Sat & Sun
Hotel Golden Landmark, 20-21 Seshadri Road,
Race Course Road, Close to MG Road
Chennai 18th & 19th September 2010, Sat & Sun
Hotel The Vijay Park, Jawaharlal Nehru Salai,
Inner Ring Road,Arumbakkam
Please also contact for Corporate Workshops throughout India or abroad.
PMP ®
New Delhi, 16th – 19th September 2010, Thu-Sun
Paharpur Business Center, Opposite Inter Continental, Nehru Place
Mumbai, 16th – 19th September 2010, Thu-Sun
Hotel Athithi, 77, Nehru Road, Vile Parle (E), Near Domestic Airport
Bangalore, 23rd – 26th September 2010, Thu-Sun
Hotel Golden Landmark, 20-21 Seshadri Road, Race Course Road, Close to MG Road
Chennai, 23rd – 26th September 2010, Thu-Sun
Hotel Vijay Park, Jawaharlal Nehru Salai, Inner Ring Road,Arumbakkam
Please also contact for Corporate Workshops throughout India or abroad.
REGISTRATION & PAYMENT PROCESS
Registration ProcessPlease reply to this mail with following details:-
[1] Name of Participant [2] Company Name [3] Training Location (Mumbai / Bangalore / New Delhi / Chennai) [4] Course (Excel / MS Project / PMP) [5] Participation Fee Details (Cheque No. / Cheque Date / Bank Name / Courier or Deposit Date or Transfer Date)
Payment Option – 1
(Anywhere in India)Deposit Cash / Cheque / DD / onwebIn favor of HEURISTIC KNOWLEDGE BASE SOLUTIONS & SERVICES in any Axis Bank Branch across India
Bank Account No.910020006995418
For onweb TransferMICR 110211063, IFSC UTIB0000723, Axis Bank Limited, Correnthum, Branch Sector 62, Noida (UP)
