Crypto

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!

Anda akan belajar cara kerja cryptocurrency, bagaimana membeli, menyimpan, dan memperdagangkannya dengan aman sambil menghindari penipuan. Di akhir kursus, Anda akan percaya diri untuk menjelajahi dunia kripto, melakukan perdagangan pertama Anda, dan menemukan peluang baru dalam keuangan digital.

SIAPA YANG COCOK UNTUK 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

Introduction to interface and basic navigation
Get to know worksheets, workbooks, and cells
Security of workbooks and worksheets

The use of simple formulas (summation, subtraction)
Use of data aggregation (count, average, min, max, count)
Absolute and relative reference in the formula

Formatting cells and cell ranges
Basic chart creation: bar, pie, line chart
Graphic formatting and modification

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

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)

Use of data validation features and drop down lists
Use of dynamic tables (pivot tables) and pivot charts for data analysis
Bagaimana menghadapi kerugian tanpa panik

Combine data using power query: merge, add, merge
Manipulating columns and values
Pivot and unpivot

Use of “What-If” data analysis tools with Goal Seek and Solver
Data modeling with scenario manager
Use of add-ins for statistical analysis

It’s your
future
certificate

Our Mentors

Budi Santoso

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

Konsultan Blockchain & Ahli Keamanan

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.

Dasar-Dasar Kripto

Kursus online untuk memahami cryptocurrency dan mulai menghasilkan dari aset digital

Get a consultation on the course

SIAPA YANG COCOK UNTUK KURSUS INI?

How you will learn

Course Curriculum

Our Mentors