Best Regards
Vikas Thakur
Capital Placement Services.
Gurgaon Haryana India
capitalhr@gmail.com
09899409300
++++++++++++++++++++++++++++++
| Dear Sir / Madam, It's our pleasure to offer you "Professional Training Workshops" on 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. ü MD's, CEO's, CFO's, CIO's, VP's, GM's, Managers etc. 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. |
| Mastering Microsoft Excel (One Day Program Contents) | Mastering Microsoft Project (Two Days Program Contents) | | |
| 1) Excel Quick Overview - Difference between Excel 2003 and 2007, Use of Excel, its boundaries & features 2) Data formation in Excel - Data in database shape is very important. Unless, it's in proper shape your analysis will not work. We will help you understand data rules required to bring your data in a right state for analysis. Base data correctness is extremely important for a true analysis. Remember, database is a garbage in garbage out. 3) Data Formatting & Custom settings - Number, Text, Date, Currency, Custom settings. Data formatting & cleaning 4) Conditional Formatting - It will help you automate formatting of conditional results in such a way which is color coded and easy to see and understand. 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. 5) Filters, Queries & Data Sorting - You have bunch of data and you want to drill it down to your desired level based on multiple choices and conditions. We will explain all the steps so that you can produce results quickly with very little efforts. Sort data based on your choice e.g. like North, East, West, South rather than alphabetically. 6) Formula Writing, Fixing Errors and Using Formulas in Combination - We will teach you by applying various formulas in the categories of 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, Sumif, Trim etc. 7) If-Then-Else and Nested If commands - You can produce different set of results based on slabs, conditions, stages etc. It requires logical understating not any programming skills. 8) Vlookup / Hlookup - This is back bone of excel. You have large amount of data placed at different locations and you want to merge it based on common values and it's relevance. We will show how this can be done with Vertical Lookup and Horizontal Lookup commands. 9) Graphs & Charts - Graphs are important part of any analysis or reporting. They get the more attention of management on concern areas when time is very limited. In this workshop you will learn how to create, modify & update graphs / charts like Column, Line, Pie, Bar, Area, Scatter, 3D etc. 10) Hyper / Data Linking - Hyper & data linking, within or outside Worksheet / Excel File is an important feature of Excel. This helps update data automatically or based on user requirements without any additional effort to produce combination or results and simulations. 11) Grouping / Ungrouping - Have lot of data which needs to be grouped for summarized results and crisp view. No problem, grouping and ungrouping feature of Excel will help you group / ungroup data with lot of ease and on click of a mouse. 12) Pivot Tables - One of Excel feature which helps you summarizes your data as per your desire. You need to select data in a range and produced consolidated results in pre-defined or user defined reporting formats. 13) Macros Recording, use, editing, linking - We will teach you how to record, edit and use Macros. For persons with little or no programming knowledge, automated recording of functions or actions helps a lot for quick execution with shortcut keys and mouse clicks. If you are a programmer with Visual Basic knowledge, you can custom built your functions at your own. 14) Security & Protection – for worksheet and file - Security and protection will help you protect your cells, worksheet area, worksheet or an excel file from unauthorized or misuse. You can secure your confidential data with this feature. 15) Data validation - Suppose you want the user not to enter or to enter some data in some specified fields when they are inputting the data for further analysis or use. You can define your custom built data validation rules which are easy to implement, use and manage as well. | 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 | | |
| Program Calendar | | ||
| MS Excel | MS Project | | |
| New Delhi 13th June 2010, Sunday Paharpur Business Center, Nehru Place Mumbai 13th June 2010, Sunday Hotel Athithi, 77, Nehru Road, Vile Parle (E) Bangalore 6th June 2010, Sunday Place to be informed before the program (To be near MG Road) Chennai 13th June 2010, Sunday Place to be informed before the program Kolkata 27th June 2010, Sunday Place to be informed before the program Hyderabad 27th June 2010, Sunday Place to be informed before the program | New Delhi or Noida 12th – 13th June 2010 Place to be informed before the program Mumbai 26th – 27th June 2010 Place to be informed before the program Bangalore 19th – 20th June 2010 Place to be informed before the program | | |
| Participation Fee | | ||
| MS Excel | MS Project | | |
| Rs. 3500/- Per Person | Rs. 10,000/- Per Person . | | |
· Refreshment with Tea / Coffee, and Lunch will be provided to all participants.
· Please bring your own laptop preloaded with MS Office 2007 for Excel Workshop and MS Project 2007 for MS Project Workshop.
| Registration & Payment Process | ||
| Payment Option – 1 (anywhere in India) | Deposit Cash / Cheque / DD / Online | In favor of HEURISTIC KNOWLEDGE BASE SOLUTIONS & SERVICES |
| Bank Account No. | 910020006995418 | |
| Bank and Branch | Axis Bank Limited, Branch Sector 62, Noida (UP) | |
| For Online Transfer – MICR | 110211063 | |
| For Online Transfer – IFSC Code | UTIB0000723 | |
| Payment Option - 2 | Post or Courier Cheque to | Rubina Jindal, 12, Harmony, C-58/16, Near TOT Mall Market, Sector 62, Noida (201301) INDIA Contact No. 91-9818410425, 91-120-4543425 |
| Registration Process | Click here to submit participation details | |
| Important Instructions | Registration of seats on First Come First Serve Basis. Participation will be confirmed only when payment is received. All registrations without payment and payment details will not be entertained. Please excuse for on spot registrations. | |
| Customers & Testimonials |
| Click here to check our list of Customers Click here to check our Customer's Testimonials |
| About Us |
| 'Heuristic' means to "Find" or "Discover" something by applying experience-based techniques that help in problem solving, learning and discovery. Heuristics are "rules of thumb", educated guesses, intuitive judgments or simply common sense. Similar way, we have adopted a unique business model to setup a foundation for a long and successful business enterprise. Heuristic Knowledgebase targets to value its stakeholders, customers, associates and the society in ways of innovation and creativity. We believe in "Adding Value to Expand Worth" in every human life. To make this happen, every single person's association is very much important for us and we will value that. Please visit our website http://www.heuristic.co.in/ for more details. |
| Best Regards, Heuristic Knowledge Base Solutions & Services 12, Harmony, C-58/16, Sector-62, Noida (UP), INDIA Website: www.heuristic.co.in E-Mail: info@heuristic.co.in G-Talk: info.heuristic@gmail.com Contact No. : 098184-15819, 0120-4543425 |
Note: We do conduct Corporate Workshops on following also. Please do contact us separately for requirements in these areas.
| Project & Service Management Training | · *PMP (Project Management Professional) – 4 Days Training Workshop · *ITIL V3 Foundation (Information Technology Infrastructure Library) – 3 Days Workshop |
| Skills Enhancement Training | · Communication, Negotiation, Leadership, Presentation, Stake Holders Management, Team Work, Customer Service, Sales & Business Development, Decision Making, E-Mail & Conference, Working in a Global Environment etc. |
| ERP's (Enterprise Resource Planning) o SAP, Oracle, Navision etc. | · If you have implemented an ERP or Planning to Implement an ERP, We can help you in the areas of:- o Consultancy on Complete Project Implementation o End User Training in all Business Areas o Manpower Outsourcing for small to longer duration |
| Office Automation Tools Training | · MS Word, MS Excel, MS Power Point, MS Outlook etc. |
* We do conduct these programs through our Authorized Education Partners.
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