4-month course

Excel Lanjutan untuk Bisnis & Keuangan

Grow Companies and Careers with Microsoft Excel Proficiency

  • Requires a laptop/PC only
  • Beginner Friendly

Get a consultation on the course

Understanding and becoming an expert in using Microsoft Excel can enhance careers as well as assist company owners in faster and comprehensive data-driven decision making. The more proficient in using Microsoft Excel, the more profit will be gained by professionals and business owners like you! menyederhanakan kehidupan dan bisnis. Tingkatkan keterampilan Anda! Ubah proses menjadi spreadsheet dan otomatisasi dengan mudah setelah menyelesaikan kursus ini. Selama pelatihan, Anda akan mendapatkan keterampilan praktis menggunakan macro, functions, dan formula array. Hasilnya, Anda dapat membuat keputusan yang tepat dengan cepat menggunakan fitur Excel tingkat lanjut.  

5 Reasons You Should Take Excel Classes
  • Menganalisis data, merencanakan anggaran, dan mengidentifikasi hubungan sebab-akibat. Ini adalah alat yang sangat berguna di tangan seorang analis.
  • Menyajikan data kepada para kolega, membuat, menggabungkan, dan memformat berbagai jenis grafik untuk pelaporan.  
  • Menyederhanakan alur kerja, menghilangkanbeberapa tugas rutin, dan menghemat waktu. Membuat Otomatisasi dibandingkan harus mereview secara manual.

UNTUK SIAPA KURSUS INI

Master all the tips and tricks

Taught by professionals who are ready to share tips and tricks using Microsoft Excel to maximize data

Work 1:1 with your mentor

That will answer all your questions and guide you in the learning process

Better career prospects

With expertise using Excel, you will improve your career prospects and get a promotion or job in a dream company because you will stand out from other professionals

How you will learn

Learn Topics
This course is organized on the GROWIA learning management system consisting of specific and easy-to-understand video lessons that you can learn at any time.
1/4
Join live sessions
Our mentors will support you in your education at GROWIA. Come to the Live session to be part of a friendly community and get feedback/feedback from mentors.
4.2
Create Portfolio
You will perform many practical tasks to turn your knowledge into skills. At the end of the course, you will have a portfolio with completed projects to show to your prospective company in the future.
3/4
Build a career or become a freelancer
Meet our career consultants to craft a great resume, prepare for interviews, and apply for first positions.
4.4

Course Curriculum

It’s your
future
certificate
1/ Introduction to Microsoft ExcelPendahuluan
  • Introduction to interface and basic navigation
  • Get to know worksheets, workbooks, and cells
  • Security of workbooks and worksheets
2/ Basic Operations in Microsoft ExcelFormula dan Fungsi Lanjutan
  • The use of simple formulas (summation, subtraction)
  • Use of data aggregation (count, average, min, max, count)
    - LOOKUP (VLOOKUP, HLOOKUP, XLOOKUP).  
    - INDEX dan MATCH untuk pengambilan data dinamis.  
    - Fungsi TEKS (TEXTJOIN, TEXTSPLIT).  
    - Fungsi logika (AND, OR, NOT).  
    - Fungsi keuangan (NPV, IRR, PMT).
3/ Data Formatting and VisualizationAnalisis Data dan Visualisasi
  • Formatting cells and cell ranges
  • Basic chart creation: bar, pie, line chart
    - PivotTable dan PivotChart.  
    - Power Query untuk transformasi data.  
    - Validasi data dan format bersyarat.
  • Graphic formatting and modification
4/ Introduction to Power QueryPemodelan Keuangan  
  • Introduction to power queries: basic concepts and benefits in data processing
  • Importing and using power queries
  • Use of basic transformations: data type, filter, sort, remove duplicates, delete
  • Refresh data settings and data source management
5/ Using Advanced FunctionsOtomasi dan Makro
  • Intermediate Math Functions (Rounding, Rank, Root, Trigonometry, Statistics, Random numbers)
  • Use of logic functions (If, and, or, if nested, iferror)
  • Search function (vlookup, hlookup, index, match)
6/ Complex Data ManagementKeamanan Data dan Kolaborasi
  • Use of data validation features and drop down lists
  • Use of dynamic tables (pivot tables) and pivot charts for data analysis
  • Use of structured tables (excel tables)
7/ Advanced Data Transformation Using Power QueryProyek Akhir
  • Combine data using power query: merge, add, merge
  • Manipulating columns and values
  • Pivot and unpivot
It’s your
future
certificate

Our Mentors

Vinson Ciawandy
Senior Data Scientist at one of Indonesia's largest e-commerce companies
Data Scientist with experience in 5 different industries: e-Commece, consulting, education, telecommunications, finance. Winner of 4 data analysis competitions. Trains more than 200 students in data analytics and data science.
Tantut Revelation Setyoko
Data Scientist
Has extensive experience as a Data Analyst and Data Scientist and 5+ years of experience in teaching. Expert in telling data stories through data processing with SQL and Python, then visualizing and relaying all the hidden information using multiple BI Tools.
Daftar Sekarang dan Dapatkan Diskon 52%! Ayo daftar segera!
Bids end in:
00
:
00
:
00