Sale Date Ended
You have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel to streamline and enhance your spreadsheets with templates, charts, graphics, data analysis and formulas.
Demonstration will be based on MS Office version.
Participant should familiar with basic excel that contain few functions like sum, max, min etc, formatting like borders, fonts, merge, etc, saving, printing techniques.
Participants need to bring their own laptop with MS Office installed!
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
The participants are requested to bring their own laptop for better understanding and practical experience. The participants may also bring with them live data pertaining to their organisation, so that these can be studied during the workshop, as to how it can be worked out with better solutions.
Chapter 1: Introduction to Microsoft Excel 2007
Chapter 2: Cell References and Range Names
Chapter 3: Working with Formulas and Functions
Chapter 4: Data Validation
Chapter 5: Protection
Chapter 6: Sorting a Database
Chapter 7: Filtering a Database
Chapter 8: Subtotals
Chapter 9: Pivot Tables
Chapter 10: Conditional formatting
Chapter 11: What-if-Analysis Tools
Chapter 12: Working with multiple worksheets, workbooks and applications
Chapter 13:-Working with Charts
Chapter 14: Macros
Medium of Instruction:English, Hindi & Marathi.
Investment (Donation): Rs. 2,400/- + Service Tax 14% per person.
Incentive: Rs. 2,200/- + Service Tax 14% per person for a group of Three or more Members from the same Organization.
Fees include participation, course material (Hard copies or Soft copies), Breakfast, Lunch and tea / coffee.
Cheques, DD, NEFT or net banking to be drawn in favour of ‘Indian Institute of Training & Development’ (IITD), Pune.
√ Reserve your seats today giving details like: Name, Designation & Contact Numbers of the participants on E mail: firstname.lastname@example.org; email@example.com or Call Rohan Mhatre on Mo: 83084 59802/ Rajiv Kolhe on Mo: 9822089898. Register NOW!
√ Advance payment of fees by DD/Cheque/Cash to be drawn in favour of ‘Indian Institute of Training & Development’. Please note our Service Tax No. BDNPK3328J SD001. PAN No. BDNPK3328J.
√ Participation fee is non-refundable/ non-adjustable against any other programme of IITD, but change in nomination(s) is accepted.
√We request youto email us NEFT transaction details at EM: firstname.lastname@example.org
Certificate of Participation would be provided to all the participants.