Program Details

[Harish]

Title: Untitled Document

MS Excel(2007/2010) Training (One Day – 10.00 am to 5.00 pm)	MS Power Point (2007/2010) Training (One Day – 10.00 am to 5.00 pm)
Why Excel is important: Microsoft Excel is one of the greatest, most powerful, most important software applications of all time. Many in the industry will have no doubt about it. It provides enormous capacity to do quantitative analysis, letting you do anything from statistical analyses of databases with hundreds of thousands of records to complex estimation tools with user-friendly front ends. And unlike traditional statistical programs, it provides an intuitive interface that lets you see what happens to the data as you process them. Excel is everywhere you look in the business world—especially in areas where people are adding up numbers a lot, like marketing, business development, sales, and, yes, finance. Extracting data from back-end systems and shoving it around in Excel spread sheets. Hope you will get great learning from this session.	Why Power Point is important: Success in the business world depends mostly on presentation skills. The reasons for this are simple. Most businesses run on presentations. Be it internal presentations to your management about the status of a project or a sales presentation to a potential client, failing there could end up costing you your job. Business professional from all departments need to know how to present effectively. Whether you are training a group of new recruits or holding an advanced training session for a technical team; effective presentation is a key to success. These days’ professionals also have to use PowerPoint to relay information to their own team mates and colleagues. Even the HR department professionals also need to master PowerPoint skills. They need to use it quite often during appraisals, hiring process, induction of new recruits, policy change announcements etc.
Program Topics - MS Excel	Program Topics - MS Power Point
1) Excel Quick Overview : Use of Excel, its boundaries & features. What’s latest in new releases. 2) Data Formatting & Custom settings : Number, Text, Date, Currency, Custom settings. Data formatting & cleaning 3) 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. 4) 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. 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 : Produce different set of results based on slabs, conditions. Learn to use Nested if (if within if) for complex situations. 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. 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 & crisp view. Grouping & ungrouping feature will help you do so. 11) Pivot Tables : Summarize your data as per your desire. You need to select data in a range & produce consolidated results in user defined reporting formats. 12) Macros Recording, use, editing, linking : Record, edit & use Macros with little or no programming knowledge. You can automate various day to day things using Macros which will help you save time and efforts. 13) Security & Protection : It will help you protect your cells, worksheet or an excel file from unauthorized use. You can create various kind of forms to enable users to fill date. 14) Data validation : prevent wrong data entry in your specified format. This will help you design various formats based on company requirements.	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. Experience the steps to do this. 3) Formatting Presentation How to make your presentation look effective. Working on fonts, styles, effects, Word art, Alignment, Text direction etc will help you master in formatting presentations as per your need.. 4) Simple Presentation Making presentations starts with creating a simple presentation then taking it to the next level. Creating general presentation by using templates etc. These presentations are system built and easy to use and create. 5) Custom Presentation Do you want to apply worldwide accepted formats or if you have very less time to format presentations then creating own style presentation by adding logos, pictures, formats etc. 6) Adding Graphics A picture is worth a thousand words. It applies to making presentations as well. 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 etc. These animation effects will make your presentation look professional. 9) Adding Charts Creating chart, editing chart, Chart tools etc. Copying charts from Word and Excel etc. Graphics adds lot of value to your presentation. 10) Adding Notes As a speaker you can add notes to presentation so you could refer to those notes while presentation. They help you keep track of the presentation. You can put important notes in the presentation which are visible to you not to the participants. 11) Printing Tips & Slide Sorter You might need to include some notes so you could forget while presenting yourself. Creating speaker notes, Handouts etc will help you do this. Slide sorter helps you manage and sort  slides
Program Schedule (10.00 am to 5.00 pm)
MS Excel (One Day – 10.00 am to 5.00 pm)	MS Power Point (One Day – 10.00 am to 5.00 pm)
New Delhi 11th April 2015 (Saturday) - Hotel Conclave Boutique, A- 20 Kailash Colony (Close to Kailash Colony Metro Station), South Delhi, New Delhi	New Delhi 12th April 2015 (Sunday) Hotel Conclave Boutique, A- 20 Kailash Colony (Close to Kailash Colony Metro Station), South Delhi, New Delhi
Mumbai 25th April 2015 (Saturday) Hotel Residency, Andheri – Kurla Rd, Andheri (East), Mumbai .	Mumbai 26th April 2015 (Sunday) Hotel Residency, Andheri – Kurla Rd, Andheri (East), Mumbai
Bangalore 18th April 2015 (Saturday) The Infantry Hotel, #66, Infantry Road, Bangalore – 01 .	Bangalore 19th April 2015 (Sunday) The Infantry Hotel, #66, Infantry Road, Bangalore – 01
Chennai 4th April 2015 (Saturday) – Session Done .	Chennai 5th April 2015 (Sunday) – Session Done .
Program Cost
MS Excel Rs. 5,000/- Per Person	MS Power Point Rs. 5,000/- Per Person.
Note: Lunch, Tea/Coffee, Snacks & Training Material will be provided to all participants. Please bring your laptop preloaded with MS Office 2007 or 2010 for the above programs. Participants from same company can share the laptops .
Registration Procedure
Pay fee by depositing Cheque or Cash or Online Transfer in any of ICICI Bank Branch in favor of : HEURISTIC KNOWLEDGEBASE SOLUTIONS PVT LTD ICICI Bank Account Number 158005000145 (IFSC code ICIC0001580. Contact us to pay by Debit/Credit card or Net Banking) Upon fee payment, Email following details to register @ 2015-16 .in [1] Participant Name  [2] Company Name                [3] Contact Number & E-Mail ID of Participant [4] Training Program  [5] Training Location & Date [6] Payment Details
Heuristic Knowledgebase Solutions Pvt Ltd Contact Us : 91-9818415819, 91-120-4543425
Terms & Conditions : Training once registered can’t be cancelled or rescheduled by participant(s). In case of unavoidable circumstances like Administrative reasons (riots, strike, bandh, agitation, curfew etc), Natural calamities (flood, earthquake, bad whether etc.), unavoidable emergency or circumstances with trainer or training place or Insufficient enrollments, or any other reasons, we holds the rights to reschedule or cancel the session. All participants will be intimated as early as possible & they will need to rejoin the rescheduled session. We 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 any circumstances. In case of permanent cancellation of the Program, training fee will be refunded to participants excluding Service Tax & TDS. Training venue can be changed due to administrative reasons. MS Office version for all Training will be 2010. Numbers of seats are subject to change. Registrations will be done on first come first serve basis. For programs where computer/laptop is necessary, participants need to bring their own laptop with required software installed on it. Participants will be responsible for the safety of their laptops / valuables. Training fee will be refunded only in the case of Program cancellation. All disputes are subject to Delhi Jurisdiction.

Unsubscribe Me