How an online training helped me land an internship at Pepsico
About the Author: Mukul Agrawal, a student of IPS Business School, enrolled in the Advanced Excel training from Internshala. He shares how the training helped him during his internship at Pepsico.
It all started when as an Internshala Student Partner, I was intimating my college mates about the importance of learning new skills through Internshala Trainings. The trainings and their content piqued my interest, and I thought about enrolling in their Advanced Excel training since being a management student, I knew it’d come in handy. Even though I was a bit skeptical about taking up an online training, I enrolled in it after reading a few reviews and experiences of students who had done a training from Internshala.
The training was divided into 4 modules, and each module had an assignment along with a test. The first module familiarised me with the basic operations and formulas of Excel, and I went on to learn about the features such as Paste Special, LOOKUP function, sparkline, advanced charts, data analysis through various charts, and conditional formatting. I also learnt to summarize data in a spreadsheet through pivot tables and to put hyperlinks in a cell along with file protection and an advanced filter. The training was so interactive that it felt like a two-way conversation. The assignments were based on real-time industrial data which let me get my hands dirty on some practical applications of Excel. The training also had an option to download the videos which made sure that internet was never an issue while learning the advanced techniques of Excel. During the training, I faced some issues while working on flash-fill, scenario manager, relative performance, etc. but with the help of the live chat support, I was able to resolve all my doubts. There was a Q&A forum where I could post my questions and get an answer within 24 hours.
After I completed the training, I started looking for internships. I applied to a summer internship at Pepsico, wanting to get a chance to work with Varun Beverages Limited. Soon after, I received an email mentioning that I was shortlisted for the internship and they’d like to schedule a telephonic interview. The interview revolved around my educational background and marketing knowledge along with a few questions on MS-Excel, which was a primary requirement for the internship. Next, I was called in for a face-to-face interview wherein I was asked why I chose to pursue a career in sales and marketing, what were my strengths and weaknesses, and why would I be a good fit for the internship. The interviewers also asked me to walk them through my resume followed by a few questions about the PepsiCo products. Since Excel was an important criterion for hiring the intern for this position, I was asked quite a lot of questions evaluating my knowledge of the subject such as the difference between VLOOKUP and HLOOKUP. Thanks to Internshala Trainings, I could answer all these questions without the least bit of difficulty!
As a sales and marketing intern, I was responsible for analysing the activity in the market and presenting it in a spreadsheet. I generated Keep Performance Initiative (KPI) of employees along with targets like year till date (YTD) and month till date (MTD) and added the Stock Keeping Unit (SKU) in Excel sheets. Throughout the internship, I used the knowledge I had gained during the internship. I found lookup features, data anlaysis, sorting, filters, table functions, and conditional formatting particularly useful while recording and managing in-person communications between Varun Beverages and its market community, exploring and monetizing data, keeping stock, and onboarding the merchants. The Advanced Excel training not only helped me get this internship but also helped me in making my internship an absolute success.
Doesn’t Mukul’s review of Internshala Advanced Excel training amaze you? Are you also looking to up your game with the knowledge of the highly sought-after Excel skills? Enroll in Internshala’s Advanced Excel Training and get an additional discount of 10%.
Hiii mukul
This is sanjeet
Congratulations for writing a good blog I like your blog it will increase my interest in Advance Excell thanks to give your views on that topic and wish you good luck for your upcoming blog I definitely reads your blog
Thank you very much for your response.
Surely you will get more blog too.
Hello
Thanks for sharing this article,ur article is very beneficial for me….
Thank you
Thanks for sharing information and knowledge
Welcome
HI
Thanks for sharing this article,ur article is very beneficial for me….
http://www.raminfotech.net
Thank you so much for your kind words.
Awesome! Thank you for the kind words!
Link:https://webroot-support-usa.com/
Thank you so much for your kind words.
Thanks for sharing this information, it is so inspiring.
Thanks for this post. It is Very nice Blog. I like it. Thanks for sharing knowledge. Ask you to share good Blog again.
Thank you so much for your kind words.
Thank you so much for your kind words.
Visit website and call for price Azura Condos is a project under development by Capital-Developments. It is an award-winning real-estate company that came into being back in 2006. After that, the company established itself in Eastern and Central Europe. In this region, the company brought innovation in terms of architecture and commercial culture.
If You Want To Watch Or Read Update Phones Review, Mobile Review and Device Review With Discount Coupe Visit Today On Device Review Website.
Lacewing technoogies is trending website and software development company in vashi navi mumbai. We provide web development, web designing, software development , SEO, website ranking etc services.
Thank you for the blog it was very helpful
Thank You Intershala To Post Such important blog, I have been the Same kind of trouble facing while I had just passed out from College suffering to getting a job but after the Complete the Online training of Digital marketing from intershala.
Thank You :0 For Motivation. This Blog Give a Lot of positive vibes and Motivation
I really love your content i appreciate your knowledge.
great information thank so much
This blog is very important regarding internships with any organization through intershala. Intershala provides very good opportunities for the students those who are seeking internships and jobs from different Multi National Companies.
Mar 8, 2019 – List of high quality blog commenting sites with their DA for 2019. Blog commenting sites list includes blogging, health, finance, travel & lifestyle …
You are right man. But, I would like to add that this may not be the case for everyone. I also started my digital marketing career through online training and then got an internship in a software house. Now, I remotely work with a top company in Australia & New Zealand who deals in cat accessories especially self cleaning cat litter box.
Those who are committed to their career will definitely find their way. No excuses for passion and commitment
I want to big thanks for sharing wonderful list Nice work
Your article is very useful and knowledgeable post.
Thanks for sharing this article,ur article is very beneficial for me….