Never miss a story

Get subscribed to our newsletter


×
A college student shares his experience of how a training of MS Excel helped him do better at his internship. Pixabay

About the Author: Rahul Dilip Ahirrao, a student of Sinhgad College of Engineering, shares his experience of learning Advance Excel and how it helped him during his internship. He also taught the basics of Excel to his father which helped him immensely with his daily work.

Though I am an engineering student, I’ve always had an inclination towards business and marketing. During a conversation with a friend, I came to know about the importance of MS Excel for building a career in marketing. I decided to do a training on Excel and started looking for a course which didn’t hinder my college studies and was affordable. A solution showed up in the form of Internshala’s online Excel training and I enrolled in it.



Rahul Dilip Ahirrao, a student of Sinhgad College of Engineering, taught the basics of Excel to his father which helped him immensely with his daily work. Pixabay

The training was well-organised into 4 modules with an assignment and a test in every module. The best part about the training was the flexibility it offered in terms of watching the pre-recorded videos as per my convenience. During the training, I learnt to sort and filter data and display it visually using charts, graphs, and clustered columns. I got to know about various types of charts like gauge, waterfall, thermometer, sparkline, line, and stacked charts and their applications in analysing data. Earlier, I only knew about some basic shortcuts in Excel like copy and paste. The training taught me various other shortcuts like cell addition and deletion along with functions such as index, logical, VLOOKUP, etc. The training comprised of a separate module wherein advanced functions like conditional formatting, pivot table, data validation, etc. were explained. It also consisted of assignments based on real-time industrial data which provided me with a practical exposure as well. I completed the training, received a certificate of completion, and started looking for marketing internships.

Soon enough, I was hired for an internship at WaterHealth International where I was responsible for carrying out a market survey and analyzing the data thereafter. I surveyed around 1200 people, asking them a variety of questions. The one thing that proved to be extremely helpful throughout the internship was my knowledge of MS Excel. It could be daunting for anyone to compile the details of 1200 people; however, with a sound knowledge of various Excel formulas for counting, summation, finding the average, and applying conditions, I completed my task easily and effectively.


MS Excel is necessary for internships and marketing jobs. Pixabay

My skills in Excel not only proved to be a saviour during my internship but also simplified the daily work of my father. He is an industrial supplier, so he collects a lot of data like names, contact numbers, and billing details of vendors and manufacturers on a daily basis. He recorded all this data in a notebook, and it was quite difficult and time-consuming for him to find the details of a particular vendor or manufacturer when he needed them. So I decided to train him in Excel since it would make his work extremely easy.

Also Read- Twitter Expands its Rules Around Hate Speech

I started with teaching him the basic Excel tools, which he mastered within a week, and then moved to functions like date, autofill, search, logic error, graphical surveys, etc. Soon he became proficient in Excel, and now he can look for required details with just one click and does all the calculations in Excel itself!

Courtesy: Internshala Trainings (training.internshala.com) – e-learning platform to learn new-age skills from Internshala.


Popular

Wikipedia

"So my decision to say yes to the film came from the director's vision."

Bollywood actor Arjun Kapoor was never really keen on exploring horror comedy but the story of 'Bhoot Police' pushed him to try his hand at the genre. The actor said, "It's not a genre that I was looking for, script-wise. When I heard it, when I read it, what worked for me was the camaraderie between the brothers, the friction and the banter between them. So I quite liked the friction, the brotherhood and at the same time the love-hate relationship and the witty tone."


Keep Reading Show less
Unsplash

Consumers nowadays seek out wearables that will provide them with the feeling of a high-performance athlete.

Are you still doing things the incorrect way when it comes to working out? Whether you realise it or not, the correct sports bra or leggings can help you achieve your fitness objectives faster or perhaps exceed them. This is something that a high-performance athlete sincerely believes in. Because it's critical to choose clothing that suits your needs in order to achieve the desired result.

This is the era of flexible work schedules and rapid acceptance of a healthy way of living. Everyone is becoming more aware of the importance of keeping good mental and physical fitness, and the sportswear business is now helping to make their lives easier. When you feel good about yourself while working out, it motivates you to go above and beyond. Fitness aficionados today not only exercise at home, but also go to the gym or participate in sports on a regular basis. Comfortable, performance-oriented clothing underpinned by the latest advancements has become a need.

Keep Reading Show less
Unsplash

In demanding office work like graphic designing or editing and developing, gaming laptops are a fantastic choice,

A laptop has evolved from being a luxury item to becoming an essential utility in today's world. Laptops make it easier for professionals to work on the go as more and more of our work shifts online. Whether you're attending a conference or travelling to another location, a laptop allows you to bring your work with you.

Advantages of Gaming laptops:

Keep reading... Show less