101 Tips on Learning Data with Excel for Beginners

(Doc. DQLab)

Tangerang – Microsoft Excel helps data talent to present processed data. This numerical data processing application provides various features to visualize processed data. This can make it easier and faster for data talents to do their job. This live session discusses Microsoft Excel, which is also one of DQLab’s efforts in introducing the importance of Excel to data talents. This talkshow is one of the DQGRATIS programs held online on Friday, 20 May 2022. The event invited speaker Tantut Wahyu Setyoko, a Data Analyst at RupaRupa.com.

Microsoft Excel was created with the aim of excellerate and accelerate. So, it is hoped that Excel will become one of the excellent and fast tools in dealing with problems. Excel has a variety of formulas and functions that can be used to complete arithmetic calculations accurately and quickly.

In Excel, several hidden hacks or functions are provided to speed up work: organizational structure, data cleansing, conditional formatting, and data validation for lists. Apart from that, Excel also provides a special feature to create charts quickly. In companies, Excel is used for dashboard creations.

According to Tantut, data practitioners can use Excel for validation and make reports quickly. Excel is also suitable for non-IT data talent and beginners, considering that Python and R are new for beginners and non-IT.

As a Data Analyst, Tantut is in charge of providing the data needed by the user. In his work, he also uses Excel to help with validation and a few things that can be done quickly.

Read also Mahasiswa Wajib Tahu Bagaimana Hasilkan Insight Menarik Melalui Dashboard Excel

“Excel is one of the foundations that data talent needs to master,” Tantut said.

“One of the communications used is Excel, so we (Data Analysts) often send Excel files or spreadsheets. So it’s easier,” Tantut said.

Data practitioners will usually be in contact with several teams, such as the managerial team and the operational team. When blasting or creating promoting campaigns, the data team will deposit data using Excel or spreadsheets. From there, the team working with data practitioners will easily understand and gain insight. Tantut also illustrated that Excel also helps data practitioners in presenting data to the managerial team.

“The first time I came to RupaRupa.com, I was given a test on Excel. Maybe, in theory, I understand, but in practice, I still often get it wrong. So, from there, I started watching Excel tutorials on YouTube often,” Tantut said.

Before closing this live session, Tantut gave a special message for beginners and non-IT people who want to learn Excel. He shared that even though you are familiar with Excel, you still have to increase your direct Excel implementation.

As a continuation of this live session, DQLab provides an opportunity for data talents who want to learn and have a successful career like Tantut. Through the Basic Excel Workshop to Advice, DQLab opens opportunities by registering via https://bit.ly/DaftarWorkshopExcel. Learn Excel from now on, and feel the benefits in the future.

*by Agnes Nurlisa | DQLab

Kuliah di Jakarta untuk jurusan program studi Informatika| Sistem Informasi | Teknik Komputer | Teknik Elektro | Teknik Fisika | Akuntansi | Manajemen| Komunikasi Strategis | Jurnalistik | Desain Komunikasi Visual | Film dan Animasi | Arsitektur | D3 Perhotelan | International Program, di Universitas Multimedia Nusantara. www.umn.ac.id