Powerpoint / MS Excel / MS Project - Exclusive Training Workshops

Dear Sir / Madam,

It’s our pleasure to offer you “Professional Training Workshops” on MS Power Point / MS Excel and MS Project as per following which are designed for:-

ü Accounts & Finance, Commercial, Sales & Marketing, Engineering, Quality, R&D, HR & Administration and IT professionals

ü Chartered Accountants, 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 tool.

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 Power Point 2007

(One Day – 9.30 am to 5.00 pm)

MS Excel 2007

(One Day – 9.30 am to 5.00 pm)

MS Project 2007

(Two Day – 9.30 am to 5.00 pm)

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.

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.

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

· 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 workshop (not mandatory).

PROGRAM CALENDAR & VENUE (Timings 9.30 am to 5.00 pm)

MS Power Point

MS Excel

MS Project

New Delhi 12th February 2011, Saturday

Paharpur Business Center, Opposite Inter Continental, Nehru Place

Mumbai 19th February 2011, Saturday

Hotel Athithi, 77, Nehru Road, Vile Parle (E), Near Domestic Airport

Pune 5th February 2011, Saturday

Hotel Shree Pancharatna, 7, Tadiwala Road, Near Pune Station

Bangalore 22nd January 2011, Saturday

Hotel Golden Landmark, 20-21 Seshadri / Race Course Road, Close to MG Road

Chennai 29th January 2011, Saturday

Hotel The Vijay Park, Jawaharlal Nehru Salai, Inner Ring Road,Arumbakkam

Also contact us for Corporate Workshops throughout India or abroad.

New Delhi 13th February 2011, Sunday

Paharpur Business Center, Opposite Inter Continental, Nehru Place

Mumbai 20th February 2011, Sunday

Hotel Athithi, 77, Nehru Road, Vile Parle (E), Near Domestic Airport

Pune 6th February 2011, Sunday

Hotel Shree Pancharatna, 7, Tadiwala Road, Near Pune Station

Bangalore 23rd January 2011, Sunday

Hotel Golden Landmark, 20-21 Seshadri / Race Course Road, Close to MG Road

Chennai 30th January 2011, Sunday

Hotel The Vijay Park, Jawaharlal Nehru Salai, Inner Ring Road,Arumbakkam

Also contact us for Corporate Workshops throughout India or abroad.

New Delhi 2nd & 3rd April 2011, Sat & Sun

Paharpur Business Center, Opposite Inter Continental, Nehru Place

Mumbai 9th & 10th April 2011, Sat & Sun

Hotel Athithi, 77, Nehru Road, Vile Parle (E), Near Domestic Airport

Pune 12th & 13th February 2011, Sat & Sun

Hotel Shree Pancharatna, 7, Tadiwala Road, Near Pune Station

Bangalore 29th & 30th January 2011, Sat & Sun

Hotel Golden Landmark, 20-21 Seshadri / Race Course Road, Near MG Road

Chennai 5th & 6th February 2011, Sat & Sun

Hotel The Vijay Park, Jawaharlal Nehru Salai, Inner Ring Road,Arumbakkam

Also contact us for Corporate Workshops throughout India or abroad.

.

MS Power Point

MS Excel

MS Project

Rs. 3,000/- Per Person

Rs. 3,000/- Per Person

Rs. 9,000/- Per Person

.

REGISTRATION & PAYMENT PROCESS

Registration

Process

Please reply to this mail with following details:-

[1] Name of Participant & Company [2] Training Location [3] Course - Excel / Power Point / MS Project [4] Participation Fee Details

Payment Option – 1

(Anywhere in India)

Deposit Cash / Cheque / DD / Online

In favor of HEURISTIC KNOWLEDGE BASE SOLUTIONS & SERVICES in any Axis Bank Branch across India

Bank Account No.

910020006995418

For Online Transfer

MICR 110211063, IFSC UTIB0000723, Axis Bank Limited, Correnthum, Branch Sector 62, Noida (UP)

Payment Option - 2

Post or Courier Cheque to

Heuristic Knowledgebase, 12, Harmony, C-58/16, Sector 62, Noida (201301) Contact 9818415819, 0120-4543425

Best Regards,

Heuristic Knowledge Base Solutions & Services

12, Harmony, C-58/16, Sector-62, Noida 201301 (UP) INDIA

E-Mail: info@heuristic.co.in , info.heuristic@gmail.com

Contact No. : 098184-15819, 0120-4543425

Website: http://www.heuristic.co.in/

Participation Cancellation & Rescheduling Policy : Training once registered can’t be canceled by participant. Rescheduling of Training can be allowed with 7 days of prior intimation in all cases from the training program. In case of unavoidable circumstances like Administrative reasons (riots, strike, bandh, agitation, curfew etc), Natural calamities (flood, earthquake, bad whether etc.), Some unavoidable emergency or circumstances with trainer or training place or Insufficient enrollments, Heuristic holds the rights to reschedule the session. All participants will be intimated as early as possible & they can rejoin the rescheduled session against canceled one without extra charges. Heuristic will not be liable to pay any expenses incurred by the participant’s to attend the training program in case if the Training program is cancelled or rescheduled due to the above circumstances. Heuristic holds the rights to take final decision on any of the circumstance / scenario not mentioned above. All disputes are subject to Noida Jurisdiction.

Disclaimer: All contents provided in the mail are Heuristic’s own contents and are not allowed for copy and reuse without our permission. Please consider this mail as an invitation to offer you participation to our Training Workshop & other programs only as described in the mail. Please ignore if you are not interested or send us reply to unsubscribe.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.