• BERITA & ACARA
  • E-LEARNING
  • MYUMN
  • PENELITIAN & PENGABDIAN
  • GLOBAL OFFICE
  • NEWS & EVENT
  • E-LEARNING
  • MYUMN
  • RESEARCH & SERVICE
  • GLOBAL OFFICE
Logo-web-UMN2-2Logo-web-UMN2-2logo-baru-umnlogo-baru-umn
  • Profile
    • Profile
    • Management
      • Rector Welcome Speech
      • University Board Member
      • Lecturers
    • Business Partner
      • Kompas Gramedia
      • Skystar Ventures
      • UMNConsulting
      • DQ Lab
    • Sustainability Program
    • Master Plan Kampus
  • Why UMN?
    • Facilities
    • Achievements
    • Scholarship
    • Career Opportunity
    • Testimonials
  • Academic
    • Faculty of Information & Technology
      • Informatics
      • Computer Engineering
      • Electrical Engineering
      • Engineering Physics
      • Information System
      • Joint Degree – Informatics Program
    • Faculty of Business
      • Dept of Hotel Operations
      • Accounting
      • Management
      • Joint Degree – Management Program
      • MMT – Master of Technology Management
    • Faculty of Communication
      • Strategic Communication
      • Digital Journalism
      • Strategic Communication (DL)
      • Master Communication Studies
    • Faculty of Art & Design
      • Visual Communication Design
      • Architecture
      • Film & Animation
    • Continuing Education Department (CED)
  • Admission
  • Campus Life
    • Student Activities
      • (BEM)Student Executive Board
      • DKBM
      • UKM
      • KAMI
    • Infrastructure
      • Library
      • Access & Environment
      • Dormitory UMN
      • Bus Kampus
✕
Tetris Program Batch 2 #StackYourSkill: DQLab Returns to Give Data Science Scholarships & Career Opportunities
June 2, 2022
6 Best Careers for Electrical Engineering
6 Job Prospects of Electrical Engineering
June 2, 2022

101 Tips on Learning Data with Excel for Beginners

Published by umnadmin on June 2, 2022
Categories
  • DQLab EN
  • General EN
  • News
Tags
  • artikel dqlab
  • data
  • excel
  • UMN

(dok. DQLab)

(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

Share

Related posts

Ketiga mahasiswa Universiti of Brunei Darussalam, Michelle, Batrisyia, dan Aqilah.(dok. UMN)

February 9, 2023

UMN Welcomes International Students from Brunei Darussalam


Read more
February 9, 2023

Constant Achievers, UMN Accounting Students Win 2nd Place in The Jakarta 2023 Accounting Competition


Read more
February 9, 2023

Skystar Ventures UMN Holds a Bootcamp, Preparing Science Students to Create Startups


Read more
  • Home
  • Profile
  • Admission
  • Academic Calendar
  • Campus Life
  • News & Events
  • Achievements
  • Dormitory UMN
  • Career at UMN
  • CED

Admission Information

Email : [email protected]
Format: name, address, phone number,
majors, and description

UMN Information

Email : [email protected]

Yayasan Multimedia Nusantara
Universitas Multimedia Nusantara

Jl. Boulevard, Gading Serpong, Kel. Curug Sangereng, Kec. Kelapa Dua, Kab. Tangerang,
Prop. Banten, Indonesia
(T)+62-21.5422.0808
(F)+62-21.5422.0800
e-mail: [email protected]

© Copyright Universitas Multimedia Nusantara. Designed by Dorado
      • Daftar Sekarang!

      • Hubungi Kami