We are the voice of Young Indians globally
Yi Salem Session on Business Analytics using MS Excel
Yi Salem Session on Business Analytics using MS Excel
This Programme is a crash course (3 Hours), will let the participants to create visuals and reports that assists management in decision-making. A fictional company data will be used to Create reports & Interactive Dashboard.
Programme Contents
•100% Practical Session
•Case Based Methodology
•Rules for setting up a Business Data
•Organizing and Formatting Business Data
•Understanding and Rectification of Flaws in Setting up a Database
•Convert simple data into Excel Tables for Analysis
•Setup Pivot Tables
•Automating Pivot Tables
•Advanced Analysis
•Data Crunching
•Advanced Filtering techniques
•Using Slicers
•Creating Visualizations using Pivot Charts
•Creating Classic Dashboards in Excel
•Creating IN Cell Charts – Sparkline Graphics
•Using Conditional Formatting Techniques
Key Takeaways for Participants
•Create Sales Reports
•Monitor Sales team Performance
•Sales Target Analysis
•Employee (Sales Man / Team) Performance Analysis
Yi Thalir - TOT at Sri Vasavi School
| Thalir - Train the Trainer module at Sri Vasavi School at Vasavi School Salem, |
Yi Salem Learning Sessions - June Edition
Yi Salem presented a series of interactive learning sessions to the members for building competitive businesses and go ahead to accomplish their business dreams and goals.
As a part of this, 2 accomplished guests were invited, Mr Sundaram R, Co-Convener, Aero Space & Defence Panel, CII Tamil Nadu & Founder cum Managing Director of Aero Space Engineers Pvt Ltd and Mr Faizal Ahamed CM, Founder of SUXUS Menswear.
Mr Sundaram shared his story of how he managed to mark his finger print in the Indian defense & aviation industry with a meager investment in the initial stages. He encouraged members to take up a manufacturing entrepreneurship role in niche domains like defense that will give long lasting returns.
Mr Faizal fascinated the delegates with his formula of getting back the ROI in a span of 21 days where ever he opened up his SUXUS brand store across the state, and also narrated the success of 50 crore turnover making company which was debt ridden with 2 crores.
Out of these session members got a very good exposure and experience from the narration of speakers.
Yi Salem-Gift an Organ - Theater Campaign
Yi Salem Chapter presented a mass theater slide campaign on promoting gift an organ, the slide was filmed for more than 15 days, across 10 screens of Salem.
Yi Salem- Show the Ink See the Prices Sink
Enlightened voters are critical to any democracy. Contrary to the general belief, there is a lack of understanding of the electoral process even among the educated citizens of the country. We are aware and acknowledge the fact, the Election Commission of India (ECI) has embarked on a mission to improve electoral literacy of voters, including people employed in private sector.
Yi Salem Chapter has initiated various campaigns on the registration and voting process, among its member companies and public at large. Apart from the above Yi Salem District has committed our full support to the ECI to improve Voter Awareness. Some of the following initiatives have been taken by us as follows: ? We have encouraged our member companies to display the attached posters in the Notice board and other prominent places in their company premises and we have requested member companies to share the document with all their employees. ? A promotion flyer shall be placed at prominent places of the city with a message on emphasizing on voting. Beyond this; to reach the multitude, we have arranged for a theater advertisement prior to screening of a film across various screens which are located at Salem city.
Yi Salem Pathfinder 2019-20
Young Indians (Yi) – Salem chapter
organized the pathfinder for the year 2019-20 at Salem on the 16th
April 2019. The prime objective for this meet is to define the theme and course
for the year 2019-20.
The
session was chaired by Mr Dilip Krishna, Regional Chair, Young Indians,
Southern Region – Tamil Nadu, Chapter chair Mr Ajay L Rajpal welcomed the
gathering of Yi members and set the tone for the session and he presented a
presentation on the roles and responsibilities of different verticals of Yi
Salem and shared insights about. In addition to this the select executive
committee chairs were nominated and appointed for their respective verticals.
(Their list is attached herewith)
Mr
Dilip Krishna shared his inspirational experiences with Yi during the past
decade and how the organization had benefited him personally and how he could
reach the unreached through Yi, thus by reaching the overall society.
As
a part of the pathfinder a special session was arranged for the members on
“UnConference” by Ms Manjoo Shree a psychologist by profession. She shared an
interactive session that motivated the participants to go further. The vote of
thanks proposed by chapter Co-Chair Mr Abhishek Rajvir.
Yi Salem Project Masoom Initiative
Yi Salem Partners with Childline Salem and Police Department to spread awareness on Child abuse. Under this campaign, Masoom creatives were made and were circulated with local police stations and around 4000 hand bills were released that shall reach the school kids in and around the city.
Session on IPR and Corporate Cyber Security
Yi Salem Chapter along with CII Salem District presented the sessions on Intellectual Property Rights and Corporate Cyber Security, Consultants from Altacit presented the session on IPR and Mr Pratheep Menon, CEO, Lakshya Cyber Security Labs presented the later one. It was an eye opening session for the members and they got a good understanding on various issues with securing their personal cyber space and how it can be protected.
Yi Salem Session on Business Analytics using MS Excel
Yi Salem Session on Business Analytics using MS Excel
This Programme is a crash course (3 Hours), will let the participants to create visuals and reports that assists management in decision-making. A fictional company data will be used to Create reports & Interactive Dashboard.
Programme Contents
•100% Practical Session
•Case Based Methodology
•Rules for setting up a Business Data
•Organizing and Formatting Business Data
•Understanding and Rectification of Flaws in Setting up a Database
•Convert simple data into Excel Tables for Analysis
•Setup Pivot Tables
•Automating Pivot Tables
•Advanced Analysis
•Data Crunching
•Advanced Filtering techniques
•Using Slicers
•Creating Visualizations using Pivot Charts
•Creating Classic Dashboards in Excel
•Creating IN Cell Charts – Sparkline Graphics
•Using Conditional Formatting Techniques
Key Takeaways for Participants
•Create Sales Reports
•Monitor Sales team Performance
•Sales Target Analysis
•Employee (Sales Man / Team) Performance Analysis
Yi Thalir - TOT at Sri Vasavi School
| Thalir - Train the Trainer module at Sri Vasavi School at Vasavi School Salem, |
Yi Salem Learning Sessions - June Edition
Yi Salem presented a series of interactive learning sessions to the members for building competitive businesses and go ahead to accomplish their business dreams and goals.
As a part of this, 2 accomplished guests were invited, Mr Sundaram R, Co-Convener, Aero Space & Defence Panel, CII Tamil Nadu & Founder cum Managing Director of Aero Space Engineers Pvt Ltd and Mr Faizal Ahamed CM, Founder of SUXUS Menswear.
Mr Sundaram shared his story of how he managed to mark his finger print in the Indian defense & aviation industry with a meager investment in the initial stages. He encouraged members to take up a manufacturing entrepreneurship role in niche domains like defense that will give long lasting returns.
Mr Faizal fascinated the delegates with his formula of getting back the ROI in a span of 21 days where ever he opened up his SUXUS brand store across the state, and also narrated the success of 50 crore turnover making company which was debt ridden with 2 crores.
Out of these session members got a very good exposure and experience from the narration of speakers.
Yi Salem-Gift an Organ - Theater Campaign
Yi Salem Chapter presented a mass theater slide campaign on promoting gift an organ, the slide was filmed for more than 15 days, across 10 screens of Salem.
Yi Salem- Show the Ink See the Prices Sink
Enlightened voters are critical to any democracy. Contrary to the general belief, there is a lack of understanding of the electoral process even among the educated citizens of the country. We are aware and acknowledge the fact, the Election Commission of India (ECI) has embarked on a mission to improve electoral literacy of voters, including people employed in private sector.
Yi Salem Chapter has initiated various campaigns on the registration and voting process, among its member companies and public at large. Apart from the above Yi Salem District has committed our full support to the ECI to improve Voter Awareness. Some of the following initiatives have been taken by us as follows: ? We have encouraged our member companies to display the attached posters in the Notice board and other prominent places in their company premises and we have requested member companies to share the document with all their employees. ? A promotion flyer shall be placed at prominent places of the city with a message on emphasizing on voting. Beyond this; to reach the multitude, we have arranged for a theater advertisement prior to screening of a film across various screens which are located at Salem city.
Yi Salem Pathfinder 2019-20
Young Indians (Yi) – Salem chapter
organized the pathfinder for the year 2019-20 at Salem on the 16th
April 2019. The prime objective for this meet is to define the theme and course
for the year 2019-20.
The
session was chaired by Mr Dilip Krishna, Regional Chair, Young Indians,
Southern Region – Tamil Nadu, Chapter chair Mr Ajay L Rajpal welcomed the
gathering of Yi members and set the tone for the session and he presented a
presentation on the roles and responsibilities of different verticals of Yi
Salem and shared insights about. In addition to this the select executive
committee chairs were nominated and appointed for their respective verticals.
(Their list is attached herewith)
Mr
Dilip Krishna shared his inspirational experiences with Yi during the past
decade and how the organization had benefited him personally and how he could
reach the unreached through Yi, thus by reaching the overall society.
As
a part of the pathfinder a special session was arranged for the members on
“UnConference” by Ms Manjoo Shree a psychologist by profession. She shared an
interactive session that motivated the participants to go further. The vote of
thanks proposed by chapter Co-Chair Mr Abhishek Rajvir.
Yi Salem Project Masoom Initiative
Yi Salem Partners with Childline Salem and Police Department to spread awareness on Child abuse. Under this campaign, Masoom creatives were made and were circulated with local police stations and around 4000 hand bills were released that shall reach the school kids in and around the city.
Session on IPR and Corporate Cyber Security
Yi Salem Chapter along with CII Salem District presented the sessions on Intellectual Property Rights and Corporate Cyber Security, Consultants from Altacit presented the session on IPR and Mr Pratheep Menon, CEO, Lakshya Cyber Security Labs presented the later one. It was an eye opening session for the members and they got a good understanding on various issues with securing their personal cyber space and how it can be protected.
Yi Salem Presents UN Water Day Awareness
Yi Salem Presents UN Water Day Awareness
22/03/2019
World Water Day is an annual UN
observance day (always on 22 March) that highlights the importance of
freshwater. The day is used to advocate for the sustainable management of
freshwater resources. World Water Day is celebrated around the world with a
variety of events. These can be educational, theatrical, musical or lobbying in
nature.
Yi Salem Chapter Annual Day 2018-19
Salem
02
February 2019
Yi Salem chapter organised its
annual all members meet for the year 2018-19 on 02 February 2019 at Salem. Dr
Aishwarya Arjun, Chair, Rural Initiatives, Yi National addressed the members
and announced the leadership team for the year 2019-2020. Mr Ajay L Rajpal,
Managing Partner, Lachhman Investments has been designated as the chapter chair
and Mr Abhishek Rajvir, Proprietor, Sri Vishnu Sweets has been nominated as the
Co-Chair of Yi Salem chapter.
Yi Salem Youth Catalyst IAM 2020 Summit II Edition- Sakthikailaash Womens College
Yi Salem Youth Catalyst IAM 2020 Summit II Edition Sakthikailaash Womens College |
Yi Salem Kaja Relief Aid
IWN & Yi Salem Presents - Session on Wealth from Waste
IWN & Yi Salem Presented a session on wealth from waste, a wonderful session by Ms Sumithra Srikanth, Consultant from Chennai. She provided contextual information and analysis about various waste products from which wealth can be generated thus providing a better towards environment protection.
Yi Salem Learning Session on Employee Engagement
Yi Salem
Learning Session on Employee Engagement
16 November
2018 | Sona College of Technology
Yi Salem Chapter
conducted a learning session on Employee Engagement for the enlightenment of
the members. Around 60 delegates participated in the session that represented
various stalk holders of the membership.
About
The Session
Employee Engagement is a
fundamental concept in the effort to understand and describe, both
qualitatively and quantitatively, the nature of the relationship between an
organization and its employees. An "engaged employee" is defined as
one who is fully absorbed by and enthusiastic about their work and so takes
positive action to further the organization's reputation and interests. An
engaged employee has a positive attitude towards the organization and its
values. An organization with "high" employee engagement might
therefore be expected to outperform those with "low" employee
engagement for up to 202%.
About
the Faculty
Mr Ramesh Srinivasan is
corporate consultant with 25+ years of rich industry expertise, Lean Six Sigma
Black Belt Certified Consultant, Certified to administer Thomas International's
Personality Profile Analysis by Thomas, Certified to Create Scientific Job
Description and Behavior Prediction by Harrison Assessments and Certified
Compensation & Benefits Manager by Carlton Advanced Management Institute,
USA.
Masoom Session at Sowdeswari School, Salem
Yi Salem Masoom Session at Sowdeswari School, Salem
Yi Salem Juskiddin Season 4
Yi Salem Juskiddin Season 4
Jus Kiddin is the only premium English standup
comic event at Salem happening successfully for the past 3 years. An evening
show planned this November is definitely on par, featuring artists from
across the country. An evening, packed with a total burst of laughter at
Hotel Grand Estancia and laugh out loud enough to relax and indulge into bliss
of extreme amusement with some astonishing comics.This year more than 250 people participated in the show.
Yi Salem Chapter Industrial Visit to Titan Watches Friday, 21 September 2018 | Hosur
Yi
Salem Chapter Industrial Visit to Titan Watches
Friday,
21 September 2018 | Hosur
Young
Indians (Yi) Salem chapter organized a half day industrial visit to Titan
Company ltd – Watches division, Hosur, Tamil Nadu. Titan Company Limited, a joint venture between the
TATA Group and the Tamil Nadu Industrial Development Corporation (TIDCO)
commenced operations in 1984 under the name Titan Watches Limited. Titan
Company is the fifth largest integrated own brand watch manufacturer in the
world.
Members
had a wonderful session and got an opportunity to witness the design part,
component manufacturing, fabrication and assembling of Titan watches for about
three hours. After that they were exposed to a briefing session on various
management perspectives, strategies and more important insights about the
company as presented by Mr Sivasubramanian, Senior manager.
Along
with Yi members few students representing various institutions have also joined
in the visit and the event received a good response from the participants.
Yi Salem Chapter – All Members Meet
Yi Salem Chapter – All
Members Meet
Tuesday, 21 August 2018 |
Hotel CJ Pallazzio, Salem
On
the cool evening hours of the busy week day, Yi Salem hosted the all members
meet and greet session in the city. Members along with their spouses joined in
the session and a special host was arranged for hosting fun activities during
the session. And one more intriguing part of this session was, a game show was
conducted with the members and a fund of around 15000+ got generated out of
this; which shall be sent to CII Foundation for funding the rehab work being
done at Kerala after the flood havoc. Around 40+ members have taken part in the
session
Yi Salem - Kerala Relief Aid
Yi Salem Chapter – Kerala Flood Relief Aid
21 August 2018
Yi
Salem Chapter collected contributions from the members and contributed new cloths,
medicines and packed eateries worth INR 3,10,000/- for the affected people in
the state of Kerala who had lost their basic supplies out of the devastation
caused by recent torrential floods.
Along
with this Yi Salem extended a cash support of INR 17,000/-
towards the rehabilitation oriented projects.
Swachhta Pakhwada Campaign - Yi Salem
Yi Salem Chapter – Swachhta Pakhwada Campaign
15 August 2018
Yi Salem Chapter observed the Independence Day with the hoisting of the national flag along with the Swachhta Pakhwada campaign with an emphasis on usage of organic products instead of plastics.
For spreading the wings, Yi Salem chapter partnered with Round Table 115 of Salem and purchased bags made of organic material of more than 2000 nos, with worth of around INR 34,000/-. On the evening of this national holiday Yi members who volunteered for this campaign came forward and gathered at the largest mall in the city and distributed these organic bags to the commuters with a private message on avoiding the usage of plastics.
The
reach was huge and the response was vivid in the midst of communities and
during the session the chapter co-chair presented a message to the gathered
public audience on the various issues with the handling of plastics and what
sort of harm it can create to the nature. As a part of this campaign some
select members of the chapter shall be provided with an opportunity to
distribute these bags to their customers at their business offices or retail
stores.
Youth Catalyst - IAM 2020 Summit - Yi Salem
Yi Salem
Chapter
Youth Catalyst
- IAM 2020 Summit
Saturday, 21 July 2018 | Paavai Engineering College,
Namakkal
Host Partner: Paavai Institutions, Namakkal.
Supported by SPK Real Estate Pvt Ltd & Paravasa Ulagam
Amusement Park
Young Indians (Yi) Salem chapter organized a half day conference for Youth with title Youth catalyst IAM 2020 Summit at Paavai Engineering College, Namakkal.
The purpose of this summit is to give an edge to participants on how to respond situations and how effectively manage it. The speakers for the summit were
·
Mr Vijay Kapoor, CEO, Derby Jeans
·
Dr Ebenezer Edwin, Scientist and Head, Kodaikanal
Observatory, IIAP
·
Mr Antony Lenatraja, Senior Solution Architect,
L&T Technology Services
· Prof Sangeetha Abishek, Founder, Sodme Digital
Mr. Vijay Kapoor shared the inspirational story of his entrepreneurship career and how he addressed all the mammoth challenges that were presented to him and how he had grown his brand Derby Jeans Community to a nation renowned brand from a very humble beginning two decades back. Dr. Ebenezer, briefed about the very vast wonders of the universe and how humble elements we are, and amazed the audience with wide illustrations and theories of this universe, Milky Way and much more.
On the other hand Mr Antony, explained about the advancements and scopes in the VLSI domain and he shared his recession experience and how he handled it to turn that a success. Followed by Ms Sangeetha S Abishek narrated her expertise with digital media explosion and how it changed the very nature of communication.
Along with them Dr Ramesh Kumar, Chairman, CII
Salem Dt, Mr Rajaganapathy Sekar, Chair, Yi Salem Chapter, Mr Aravinthan, Past
Chair, Yi Salem Chapter, Mr Abhishek Rajvir, Chair, Youth Catalyst and Mr Ajay L Rajpal, Co- Chair, Yi Salem
Chapter shared their special address.
The summit was Felicitated by Mr Natatajan, Chairman, Paavai Institutions,
Namakkal.
Learning Sessions on Digital Media Marketing for Business Success - Yi Salem Chapter
Yi Salem Chapter Learning Sessions on Digital Media Marketing for
Business Success
Salem
18 July 2018
Yi
Salem Chapter hosted the July edition of learning session here in the city. The
session was presented by Prof Sangeetha S Abishek, a professor and founder of
Sodme, a company dealing with digital media marketing services; presented the
session on “Digital Media Marketing for Business Success”. The session went
very lively and much admired by the members of Salem chapter and few selective
nonmembers.
During the session she precisely explained some unknown nuances of marketing through social mediums and some of the myths prevalent in the minds of business owners when it comes to social media marketing and its reach. And further explained the number game that marketing campaigns are expected to do; which in turn might not be an effective reach; as for as the objective of business promotion is concerned. She further explained the effective and most feasible ways for reaching the potential leads through these social mediums which alone can produce fruits for the business.
Around
60 participants were present and the session was concluded with a networking
dinner and received a very positive feedback.
Yi Salem Chapter Runners Day Marathon
Yi Salem Chapter Runners Day Marathon
Yi Salem Chapter jointly presented the Salem Runners Day marathon in one of the most organic place in the city during the early hours of the day. The event witnessed 150 runners from all walks of life in 2 different categories of 5 Km run and 10 Km run. The location as mentioned one of the most untouched part which in turn a reserved place under the forest department which starts from the downhill area of Yeacaud near kuruvampatti zoological park and runs towards Danishpet.
The runners started with a flagged off by Retd Professor Mr Devaraj from Coimbatore who is 89 years of age now and he himself joined the run and completed 10 km run very successfully without any physical hindrances and indeed a very great source of inspiration to all the participants. He also shared some inspiring words to the participants and emphasized the importance of physical exercise for present day so called busy generation which does not have enough space and time for regular exercises. And how running and extensive walking can influence the health he added.
A
number of Yi members joined in the marathon which includes the chapter chair
and co-chair. The participants spent a morning in a place which was lavished
with such lush greenery and forest.
Yi Salem Environment Day Celebration - Planting of 150 Saplings
Yi Salem World Environment Day – 150 Sapling
planted
Yi Salem Chapter in partnership with AVS College of Technology, Salem observed the UN’s World Environment Day 2018 by planting 150 saplings along the banks of Salem – Attur national highways.
The prime objective of this drive is to bring awareness to the public and communities on protection of trees and significance of their existence. Around 30 students and members volunteered for planting the saplings.
Mr Ajay, Co-Chair of Yi Salem
Chapter presented the importance of tree’s role in balancing the ecosystem, Dr Tholkappia Arasu, Principal, AVS
College of Technology added that in few decades from now water scarcity would
be widened and can become an epidemic as predicted by scientists around 1960s
that water could become a merchandise in the future which had been turned into
a reality now.
Yi Salem World Bicycle Day Rally 2018
Yi Salem Chapter celebrated the UN’s first World Bicycle Day partnering with Salem Cycler's and hosted Salem Bicycle Rally in the early hours of the day. As per the UN’s proclamations it’s been stated that the bicycle is a simple, affordable, reliable, clean and environmentally fit sustainable means of transportation; Bicycle can serve as a tool for development and as a means not just of transportation but also of access to education, health care & sport and it’s a symbol of sustainable transportation and conveys a positive message to foster sustainable consumption and production, and has a positive impact on climate.
There were around 40 cyclers who aged between 7 and 50 have taken part in this program and the rally was flagged of by Mr Vimalan, Past Chairman, CII Salem Dist. and Director, SRC Projects Pvt Ltd who himself is a cycle enthusiast.
There happened a short briefing about the health benefits of cycling by Mr Vimalan, then followed that the rally took off at Pioneer sports club Salem and covered a distance of around 18 kilometers by having kuruvampatti zoological park as mid-return point. The Session was presided by the Co-Chair of Yi Salem Mr Ajay L Rajpal.
International Yoga Day @ Pioneer Sports Club: Salem
International Yoga Day @ Royal Park: Salem
Session on Roof Top Gardening With Jeeva Prakash: Salem
Session on Organ Donation With Dr Hari Janakiraman, MD, Salem Gopi Hospital: Salem
Project Masoom MMS Yerumapalayam & MMS Kalaram Patti: Salem
Project Masoom Veeralakshmi Vidhyalaya: Salem
Project Masoom Training to Doctors Wife: Salem
Yi Movie Evening Kabali: Salem
Session with S Sriram, All India Topper in Chartered Accountancy: Salem
Session with Mr M. Sathya Kumar, Chartered Accountant, Social Activist: Salem
Special interaction with Padma Bhushan Dr Sivathanu Pillai : Salem
