Pengantar Pemrograman Python untuk Ms.Excel (Panas Bumi)

Python, Excel, Visualisasi Data

Created byJIWA Learning

Last updated 3/2025

Indonesian

What you'll learn

Explain the nuances of variables, lists, dictionaries, print statements, and basic data functions in Python
Apply Python functions to real-world scenarios through detailed case studies
Demonstrate the ability to select and implement the most suitable library/package
Import, manipulate, and export data between Python and Microsoft Excel, showcasing adaptability to different data formats
Create and present visually compelling and insightful data visualizations using Python, with a focus on effective communication of data-driven insights.

Course content

8 sections • 28 lectures • 3h 9m total length

Python & Visual Studio Installation6:06
Build your first Python program, discover how to install Python, and learn the basics of coding in this introductory course. Create your first project and print "Hello Word" in your code!8I
Creating a New Project6:10

Intro to Variable6:46
This subject is an introduction to Python programming that covers the basic concepts of variables, lists, and dictionaries. In addition, it also covers IF logic and uses lists as 'for' loops. This subject helps beginners who have never programmed before as well as those who are experienced with Excel.
Print & Data Function8:36
Intro to List7:11
Intro to Dictionary9:05
IF Logic5:39
Python for Loop5:16

Creating a Function5:44
Learn to create a function using Python. It covers functions, parameters & arguments, creating math functions, and examples of applied math functions. Next, we’ll wrap up with a case study that can be used as a template for your own calculations in Python.
Parameters and Arguments in Function6:55
Creating Math Function7:14
Applied Math Function: Example8:09
Case Study: Function for Calculate Saving Interest9:26
Case Study: Function for Calculate a Number of Roof Tiles4:48

Load Workbook6:11
This course shows you how to create an efficient programming workflow by combining Excel and Python. Learn how to extract information from various sources and store it in Excel, then apply formulas and conditional formatting to generate reports that are automatically updated. The course also explains how to access and modify data in a worksheet, create new sheets and delete ones that are no longer needed.
How to Access and Modify Data in the Sheet ?7:17
Create & Select Sheet7:18
Create a New Workbook6:22
Data Update3:05

Case Study: Calculating Geothermal Speculative Resources using Python10:20
Building on how you learned to calculate speculative geothermal resources in Python. This subject describes a Python case study that can help you practice geothermal study/case.

Special thanks to Nayoan & Hendrasto (2020) for providing the data.

References:
Nayoan, A. G., & Hendrasto, F. (2020). PERHITUNGAN POTENSI SUMBER DAYA DAN CADANGAN PANAS BUMI LAPANGAN PANAS BUMI “NYN”, PROVINSI NUSA TENGGARA TIMUR. Jurnal Eksakta Kebumian, 1 (2).
SNI 13-6169-1999. Metode estimasi potensi energy panas bumi di Indonesia. Badan Standarisasi Nasional.
Ujian Pemrograman Python untuk MS Excel

Requirements

No need specific knowledge to begin study of this course

Description

Python adalah bahasa pemrograman yang banyak digunakan oleh jutaan ahli, akademisi, dan perusahaan di seluruh dunia. Tutorial pemrograman Python mudah dipelajari dan memiliki aplikasi yang sangat luas dalam menyelesaikan masalah dunia nyata. Excel telah menjadi aplikasi spreadsheet terkemuka selama beberapa dekade, dan kursus ini akan membahas cara menggunakan Python sebagai alat untuk bekerja dengan lembar kerja Excel.

Kursus ini dirancang untuk anda yang tertarik untuk belajar Python dan dapat menggunakan Microsoft Excel, kursus ini akan mengajarkan cara menggunakan Microdoft Excel yang kuat dengan Python. Kursus cocok untuk pemula yang ingin memahami pemrograman Microsoft Excel menggunakan Python. Kursus mencakup cara menginstal Python di komputer Anda, cara menerapkan konsep dasar pemrograman Python, dan menggunakannya untuk membuat proyek dan fungsi di Microsoft Excel. Kursus ini juga mencakup studi kasus tentang persamaan sederhana dan studi geothermal untuk menghitung sumber daya spekulatif. Ini akan membawa Anda dari tidak tahu apa-apa pada awalnya hingga menjadi ahli penuh pada akhir kursus ini. Selain itu, diharapkan Anda dapat menjadi pemrogram yang dapat diandalkan dan mampu membuat aplikasi unggul di masa depan.

Apa yang Akan Anda Pelajari?

Basic Concept of Python Programming (Intro to variable, list, dictionary, print & data function)
Creating a Function (applied mathematics, includes case study)
Introduction to Libraries/Package of Python
Python and Microsoft Excel Data
Python and Data Visualization

Ayo daftar dalam kursus ini untuk mulai belajar salah satu bahasa pemrograman paling populer di dunia!

Who this course is for:

Participants who understand basic Microsoft Excel (interface, data, & basic formula).
Beginner programmers who want to know the Python programming language.
Beginner-level Python programmer.
Beginner without IT backgrounds can easily understand this course.

Pengantar Pemrograman Python untuk Ms.Excel (Panas Bumi)

What you'll learn

Explore related topics

Course content

Computer Setup2 lectures • 12min

Basic Concept of Python Programming6 lectures • 43min

Creating a Function6 lectures • 42min

Libraries2 lectures • 13min

Python for Microsoft Excel5 lectures • 30min

Python and Data Microsoft Excel4 lectures • 26min

Python and Data Visualization2 lectures • 13min

Geothermal Case Study1 lecture • 10min

Requirements

Description

Who this course is for: