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

Flickr

Hackers have stolen crypto tokens worth $120 million from Blockchain-based decentralised finance (DeFi) platform BadgerDAO.

Hackers have stolen crypto tokens worth $120 million from Blockchain-based decentralised finance (DeFi) platform BadgerDAO. Several crypto wallets were drained before the platform could stop the cyber attack. In a tweet, Badger said it has received reports of unauthorised withdrawals of user funds. "As Badger engineers investigate this, all smart contracts have been paused to prevent further withdrawals. Our investigation is ongoing and we will release further information as soon as possible," the company said late on Thursday.

According to the blockchain security and data analytics Peckshield, the various tokens stolen in the attack are worth about $120 million, reports The Verge. According to reports, someone inserted a malicious script in the user interface (UI) of their website. Badger has retained data forensics experts Chainalysis to explore the full scale of the incident and authorities in both the US and Canada have been informed. "Badger is cooperating fully with external investigations as well as proceeding with its own," it said. DeFi is a collective term for financial products and services that are open, decentralised and accessible to anyone. DeFi products open up financial services to anyone with an internet connection and they are largely owned and maintained by their users. While the attack didn't reveal specific flaws within Blockchain tech itself, it managed to exploit the older "web 2.0" technology that most users need to use to perform transactions, according to reports. (IANS/ MBI)


Keep Reading Show less
IANS

Kishan said that the organisers have been asked to strictly follow all Covid-19 protocols.

A total of 120 top Bollywood and other celebrities are expected to attend the wedding of film stars Katrina Kaif and Vicky Kaushal which is scheduled on December 9 in Rajasthan, said Rajendra Kishan, the District Collector (DC) of Sawai Madhopur district of the state on Friday. The District Collector told mediapersons: "These 120 guests shall follow all COVID-19 protocols and fully vaccinated guests will get entry in the much-hyped celebrity wedding."

Kishan said that the organisers have been asked to strictly follow all Covid-19 protocols. Also, those who are not vaccinated, will not be allowed without the negative RT-PCR test report, he added. "We have been informed by organisers that a total of 120 guests are invited to the wedding and the events will take place between December 7 to December 10," he added.

Earlier at 10.30 a.m., Kishan called a meeting which was attended by administrative, police and forest department officials, hotel and event managers to ensure adequate arrangements for crowd control, smooth regulation of traffic, and law and order situation amid the VIP movement. The wedding venue Fort Barwara, that has been converted into a heritage hotel, is situated in the panchayat samiti Chauth Ka Barwara. The venue is around 22 km away from Sawai Madhopur and is around 174 km from Jaipur. Sawai Madhopur district is famous for the Ranthambore National Tiger Reserve and as per reports, the guests are likely to be taken for a tiger safari. (IANS/ MBI)


Keep Reading Show less
Pixabay

The National Centre for Biological Sciences (NCBS) is continuously monitoring the situation in four cities - Bengaluru, Hyderabad, New Delhi, and Pune.

The National Centre for Biological Sciences (NCBS), which confirmed the first two cases of the Omicron variant in Bengaluru on Thursday, is continuously monitoring the situation in four cities - Bengaluru, Hyderabad, New Delhi, and Pune. The NCBS is a part of a consortium of national laboratories performing genomic surveillance across four city clusters. The consortium was established four months ago with support from The Rockefeller Foundation's Pandemic Prevention Institute, and is led by the Centre for Cellular and Molecular Biology (CCMB) in Hyderabad.

Dr Rakesh Mishra at the CCMB said on Friday that the consortium is continuously monitoring the situation in all the four cities and has upscaled its efforts to sequence as many samples as possible Apart from the CCMB and the NCBS, the consortium includes CSIR-Institute of Genomics and Integrative Biology - IGIB in New Delhi and the Pune Knowledge Cluster, Indian Institute of Science Education and Research (IISER), Pune, and CSIR-National Chemical Laboratory in Pune.

covid virus The first case of the Omicron variant was detected in South Africa and reported to the World Health Organization on November 24. | Unsplash

Keep reading... Show less