It all started when as an Internshala Student Partner, I was intimating my college mates about the importance of learning new skills through their 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 sceptical 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 the platform.
Important Announcement – EasyShiksha has now started Online Internship Program “Ab India Sikhega Ghar Se”
Top Courses in Virtual Reality
More Courses With Certification
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.
-
Top Courses in Software Engineering Top Courses in Software Engineering
Loading...More Courses With Certification
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 their training, 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 a 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 analysis, 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.
Courtesy: Internshala Trainings (training.internshala.com) – e-learning platform to learn new-age skills from Internshala
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.
Top Courses in Networking
Empower your team. Lead the industry
Get a subscription to a library of online courses and digital learning tools for your organization with EasyShiksha
Request NowQ. Are EasyShiksha's internships truly free?
Yes, all internships offered by EasyShiksha are completely free of charge.
Q. How can I apply for an internship with EasyShiksha?
You can apply by visiting our website, browsing available internships, and following the application instructions provided.
Q. What types of internships are available through EasyShiksha?
EasyShiksha offers a wide range of internships across technology, business, marketing, healthcare, and more. Opportunities are continuously updated.
Q. Will I receive a certificate upon completing an internship?
Yes, upon successful completion, you will receive a certificate recognizing your participation and achievements.
Q. Are EasyShiksha's internship certificates recognized by universities and employers?
Yes, the certificates are recognized by universities, colleges, and employers worldwide.
Q. Is the download of certificates free or paid?
Access to internships and courses is free, but there is a small fee to download certificates, covering administrative costs.
Q. When can I start the course?
You can choose any course and start immediately without delay.
Q. What are the course and session timings?
These are fully online courses. You can learn at any time and pace. We recommend following a routine, but it depends on your schedule.
Q. What will happen when my course is over?
After completion, you will have lifetime access to the course for future reference.
Q. Can I download the notes and study material?
Yes, you can access and download course materials and have lifetime access for future reference.
Q. What software/tools would be needed for the course?
All necessary software/tools will be shared during the training as needed.
Q. I’m unable to make a payment. What should I do?
Try using a different card or account. If the problem persists, email us at info@easyshiksha.com.
Q. Do I get the certificate in hard copy?
No, only a soft copy is provided, which can be downloaded and printed if required.
Q. The payment got deducted but shows “failed”. What to do?
Technical errors may cause this. The deducted amount will be returned to your account in 7-10 working days.
Q. Payment was successful but dashboard shows ‘Buy Now’?
Sometimes payment reflection is delayed. If it takes longer than 30 minutes, email info@easyshiksha.com with the payment screenshot.
Q. What is the refund policy?
If you face technical issues, you can request a refund. No refunds are issued once the certificate has been generated.
Q. Can I enroll in a single course?
Yes, select the course of interest, fill in the details, make payment, and start learning. You will also earn a certificate.
Q. My questions are not listed above. I need further help.
Contact us at info@easyshiksha.com for further assistance.
ALSO READ: 5-lucrative-career-opportunities-for-creative-writers
Get Courrse: Microsoft-Excel2007-Tutorial-for-Beginners
