How an online training helped me land an internship at Pepsico

How-an-online-training-helped-me-land-an-internship-at-Pepsico1

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%. 

You may also like

27 thoughts on “How an online training helped me land an internship at Pepsico

  • December 14, 2018 at 8:56 AM

    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

    Reply
    • December 14, 2018 at 4:44 PM

      Thank you very much for your response.

      Surely you will get more blog too.

      Reply
  • December 20, 2018 at 2:38 PM

    Hello
    Thanks for sharing this article,ur article is very beneficial for me….

    Reply
  • December 24, 2018 at 4:44 PM

    Thank you

    Reply
  • January 10, 2019 at 2:43 PM

    Thanks for sharing information and knowledge

    Reply
    • January 11, 2019 at 11:14 PM

      Welcome

      Reply
    • January 25, 2019 at 4:35 PM

      Thank you so much for your kind words.

      Reply
    • January 25, 2019 at 4:37 PM

      Thank you so much for your kind words.

      Reply
  • January 21, 2019 at 7:21 PM

    Thanks for sharing this information, it is so inspiring.

    Reply
  • January 22, 2019 at 12:11 PM

    Thanks for this post. It is Very nice Blog. I like it. Thanks for sharing knowledge. Ask you to share good Blog again.

    Reply
  • January 25, 2019 at 4:36 PM

    Thank you so much for your kind words.

    Reply
  • January 25, 2019 at 4:38 PM

    Thank you so much for your kind words.

    Reply
  • January 26, 2019 at 6:23 PM

    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.

    Reply
  • February 10, 2019 at 12:19 AM

    If You Want To Watch Or Read Update Phones Review, Mobile Review and Device Review With Discount Coupe Visit Today On Device Review Website.

    Reply
  • February 12, 2019 at 11:05 AM

    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.

    Reply
  • February 12, 2019 at 2:22 PM

    Thank you for the blog it was very helpful

    Reply
  • February 13, 2019 at 4:08 PM

    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.

    Reply
  • February 23, 2019 at 5:16 PM

    Thank You :0 For Motivation. This Blog Give a Lot of positive vibes and Motivation

    Reply
  • March 9, 2019 at 1:51 PM

    I really love your content i appreciate your knowledge.

    Reply
  • March 12, 2019 at 7:19 PM

    great information thank so much

    Reply
  • March 13, 2019 at 2:35 PM

    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.

    Reply
  • March 19, 2019 at 1:34 AM

    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 …

    Reply
  • March 28, 2019 at 5:57 PM

    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

    Reply
  • April 10, 2019 at 3:30 PM

    I want to big thanks for sharing wonderful list Nice work

    Reply

Leave a Reply to Sandeep Saroha Cancel reply

Your email address will not be published. Required fields are marked *