Real Learning, Real Me

📊 LEFT, MID, dan RIGHT di Google Sheets | Extract Product Code (Bilingual) Bahasa: Indonesia & English 🇮🇩 Studi Kasus Dalam studi kasus video, kita diberikan contoh format kode produk dengan struktur: 3 huruf pertama : Nama/Singkatan produk 3 angka di tengah : Berat produk 3 huruf terakhir : Lokasi penjualan Untuk mengekstrak data ini, kita menggunakan fungsi Excel LEFT , MID , dan RIGHT . 🇬🇧 Case Study In this case study, a product code is formatted as follows: First 3 letters : Product name or abbreviation Middle 3 digits : Product weight Last 3 letters : Sales location We’ll use Excel’s LEFT , MID , and RIGHT functions to extract this information. 🔹 LEFT Function – Nama Produk / Product Name =LEFT(A3, 3) ID: Mengambil 3 karakter pertama dari kiri. EN: Extracts the first 3 characters from the left. Contoh: MIL250JKT → MIL 🔹 MID Function – Berat Produk / Product Weight =MID(A3, 4, 3) ID: Mulai dari karakter ke-4, ambil 3 ...

📌 Learning Basic Formulas: SUM, AVERAGE, MAX, and MIN in Google Sheets Hello! In this article, I’d like to share one of my first steps in learning Google Sheets — especially how to use some of the basic formulas that are essential for office tasks or everyday work. Google Sheets (or Excel) is a powerful tool used in many types of jobs. Understanding basic formulas like SUM, AVERAGE, MIN, and MAX can really help you to: Create sales reports Analyze data Manage budgets or student scores And so much more! I also made a silent video tutorial, which you can follow along. Watch the video below, and then read the explanation of each step. 📝 Step-by-Step Guide:      1️⃣ Open Google Sheets              Go to Google Sheets and click on Blank to create a new spreadsheet.      2️⃣ Enter or Paste Your Data              Create data just like in the video. If you already have data in Exce...