Project Management is the key focus area nowadays. Due to globalization of enterprises, companies are moving from conventional Project Management to modernized Project Management. Cost, Timelines, Quality, Risks etc etc are the highly focus areas. Any variation in these could result into disastrous situations. 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 1) Project & Project Management Overview 2) Program & Portfolio Management 3) Project Life Cycle 4) Project Management 5) Process Groups Project 6) Initiation 7) Project Planning 8) Project Execution 9) Project Monitoring Controlling 10) Project Closing PROJECT MANAGEMENT KNOWLEDGE AREAS 1) Project Integration Management 2) Project Scope Management 3) Project Time Management 4) Project Cost Management 5) Project Quality Management 6) Project Human Resource Management 7) Project Communications Management 8) Project Risk Management 9) Project Procurement Management | Excel Quick Overview : Use of Excel, its boundaries & features Data Formatting & Custom settings : Number, Text, Date, Currency, Custom settings. Data formatting & cleaning Conditional Formatting : Once defined, it will automatically change color of values e.g. up or down, high or low, pass or fail, profit or loss etc. Filters, Queries & Data Sorting : Drill down your data to your desired level. Sort data based on your choice e.g. like North, East, West, South rather than alphabetically. 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. If-Then-Else & Nested If commands : Produce different set of results based on slabs, conditions. Vlookup / Hlookup : You have large amount of data placed at different locations & you want to merge it based on common values & it’s relevance. Graphs & Charts : In this workshop you will learn how to create, modify & update graphs / charts like Column, Line, Pie, Bar, Area, Scatter, 3D etc. Hyper / Data Linking : Hyper & data linking, within or outside Worksheet / Excel File is an important feature. This helps update data automatically. Grouping - Ungrouping : Sometime data needs to be grouped for summarized results & crisp view. Grouping & ungrouping feature will help you do so. Pivot Tables : Summarize your data as per your desire. You need to select data in a range & produce consolidated results in user defined formats. Macros Recording, use, editing, linking : Record, edit & use Macros with no programming knowledge. Security & Protection : It will help you protect your cells, worksheet or an excel file from misuse. Data validation : prevent wrong data entry. Specify your own format and conditions for data entry so that right data should be entered & accepted by the Excel. | 1) Power Point Overview Overview of MS word in terms of Screen layout, Menus, The Ribbon, Quick Access Toolbar etc. 2) Creating a Presentation You can start a new presentation from a blank slide, a template, existing presentations, or a Word outline. 3) Formatting Presentation Working on fonts, styles, effects, Word art, Alignment, Text direction etc. 4) Simple Presentation Creating general presentation by using templates etc. These presentations are system built and easy to use and create. 5) Custom Presentation Creating own style presentation by adding logos, pictures, formats etc. 6) Adding Graphics Adding pictures, Clip Art, Shapes, Smart Art, Photo album etc. These graphics can be animated. 7) Adding Tables Creating tables, modifying structure, Inserting Table from Word or Excel to prevent the rework. Tables can be modified and used in a colorful manner. 8) Adding Animation Slide effects, Slide Transitions, Slide Animations, Animation Preview, Setting up slide show, 9) Adding Charts Creating chart, editing chart, Chart tools etc. Copying charts from Word and Excel etc. 10) Adding Notes As a speaker you can add notes to presentation so you could refer to those notes while presentation. 11) Printing Tips Creating speaker notes, Handouts etc. Tips on printing slides and handouts. 12) Slide Sorter Sort slides based on your requirement. You could have large number of slides may be in hundreds. No worry, slide sorter will help you do so with lot of ease and comfort. |
