Kelas Excel
19.2K subscribers
70 photos
4 videos
7 files
1.53K links
Kelas Excel | Tutorial Microsoft Excel Indonesia

Telegram Channel by Kelas Excel
(https://www.kelasexcel.id)

πŸ’¬ Grup Diskusi Β» @belajarmicrosoftexcel
🎟 Get Microsoft 365 » @microsoft365family
🦸 Support » t.me/boost/kelasexcel
Download Telegram
#ExcelRadar #Spreadsheet #Microsoft #Office #Excel #M365

β€”
▍ Excel Tips: Bar Chart
Β» https://www.youtube.com/watch?v=7phAJ7OC1Zs
β€”
▍ Rotate Text in Seconds!
Β» https://www.youtube.com/watch?v=eCwAyDCzgoU
β€”
▍ How to Convert Percent to Decimal in Excel
Β» https://www.myexcelonline.com/blog/convert-percent-to-decimal/
β€”
▍ How to Combine Two Columns in Excel
Β» https://www.xelplus.com/combine-two-columns-excel/
β€”
▍ The Ultimate Guide to Inches to Meters – Excel Convert Function Guide
Β» https://www.myexcelonline.com/blog/inches-to-meters-in-excel/
β€”
▍ Advanced Conditional Formatting with Formula-Based Rules
Β» https://www.exceldemy.com/advanced-conditional-formatting-formula-based-rules/
β€”
▍ How to Wrap Text in Excel
Β» https://www.xelplus.com/wrap-text-in-excel/
β€”
▍ Advanced Error Handling in Complex Spreadsheets
Β» https://www.exceldemy.com/advanced-error-handling-complex-spreadsheets/
β€”
▍ How to Insert Text Box in Excel – Step by Step Guide
Β» https://www.myexcelonline.com/blog/how-to-insert-text-box-in-excel/
β€”
▍ Get This Excel Advent Calendar With No Macros
Β» https://contexturesblog.com/archives/2024/11/28/excel-advent-calendar-no-macros-toys/?utm_source=rss&utm_medium=rss&utm_campaign=excel-advent-calendar-no-macros-toys
β€”
▍ How to Create Drop down list in Excel with Multiple Selections
Β» https://www.myexcelonline.com/blog/how-to-create-drop-down-list-in-excel-with-multiple-selections/

βž–βž–βž–
❀️ Anda suka? Jangan lupa tinggalkan emote reaksinya.
#ExcelRadar #Spreadsheet #Microsoft #Office #Excel #M365

β€”
▍ 5 Ways to Automate Your Workflow in Excel
Β» https://www.exceldemy.com/5-ways-automate-workflow-excel/
β€”
▍ Sum Positive Numbers Between Dates
Β» https://www.excel-university.com/sum-positive-numbers-between-dates/
β€”
▍ Import ANY Data into Excel With This FREE Add-in
Β» https://www.youtube.com/watch?v=RScbe19Eqmw
β€”
▍ Stop Dragging in Excel, there is a BETTER way!
Β» https://www.youtube.com/watch?v=Jq2gRt8Boik
β€”
▍ How to Convert Excel to Word – Step by Step Guide
Β» https://www.myexcelonline.com/blog/convert-excel-to-word/
β€”
▍ Translate to Any Language in Excel with this NEW Function | TRANSLATE Function in Excel
Β» https://www.youtube.com/watch?v=VMR2oa9pTxQ
β€”
▍ This FREE Excel Template Manages Your Holiday Gift List With Ease
Β» https://www.youtube.com/watch?v=3ZsBoDg2swU
β€”
▍ The Ultimate Guide to Area of Parallelogram Formula in Excel
Β» https://www.myexcelonline.com/blog/area-of-parallelogram-formula/
β€”
▍ New Feature in Excel! 😱
Β» https://www.youtube.com/watch?v=qUHDNdQWhAY
β€”
▍ How to Add Microsoft Teams to Outlook
Β» https://www.myexcelonline.com/blog/how-to-add-microsoft-teams-to-outlook/
β€”
▍ How to Make Calls on Microsoft Teams Fast
Β» https://www.myexcelonline.com/blog/make-calls-on-microsoft-teams/
β€”
▍ How Much Does a Data Analyst Consultant Cost?
Β» https://p3adaptive.com/how-much-does-a-data-analyst-consultant-cost/
β€”
▍ How Much Does a Data Analyst Consultant Cost?
Β» https://p3adaptive.com/how-much-does-a-data-analyst-consultant-cost/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE
β€”
▍ How Do You Do Data Strategy
Β» https://p3adaptive.com/how-do-you-do-data-strategy/
β€”
▍ How Do You Do Data Strategy
Β» https://p3adaptive.com/how-do-you-do-data-strategy/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE
β€”
▍ What Is A Data-Based Strategy?
Β» https://p3adaptive.com/what-is-a-data-based-strategy/
β€”
▍ What Is A Data-Based Strategy?
Β» https://p3adaptive.com/what-is-a-data-based-strategy/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE
β€”
▍ What Is A Data Strategy Framework?
Β» https://p3adaptive.com/what-is-a-data-strategy-framework/
β€”
▍ What Is A Data Strategy Framework?
Β» https://p3adaptive.com/what-is-a-data-strategy-framework/?utm_source=google&utm_medium=cpc&utm_term=p3%20adaptive&utm_content=US_Awareness_BrandP3Brand_Malificent&utm_campaign=US_Brand_BrandRecBrandRec_TheOne&gclid=CjwKCAjwrIixBhBbEiwACEqDJek7yJFN180C-vRI3ZEQ8c9NkbwiLLMUOzbWbKSgrp3clSdDJUefVBoCoBcQAvD_BwE
β€”
▍ Change These 10 Settings Before You Use Excel Again
Β» https://www.youtube.com/watch?v=iTz3985Ubf8

βž–βž–βž–
❀️ Anda suka? Jangan lupa tinggalkan emote reaksinya.
#ExcelRadar #Spreadsheet #Microsoft #Office #Excel #M365

β€”
▍ Must-Know Tips for Effortless Data Cleaning
Β» https://www.youtube.com/watch?v=eXAo8D-DSlw
β€”
▍ Excel - Unlock the Secrets of Excel's New Compatibility Version! - Episode 2663
Β» https://www.youtube.com/watch?v=biuTPoonMmI
β€”
▍ How to Use Copilot Chat Helper in Excel
Β» https://www.myexcelonline.com/blog/copilot-chat-helper-in-excel/
β€”
▍ How to Get First Match in Excel – Step by Step MATCH Formula Tutorial
Β» https://www.myexcelonline.com/blog/get-first-match-in-excel/
β€”
▍ How to Calculate Growth with the RRI Function in Excel
Β» https://www.myexcelonline.com/blog/rri-function-in-excel/
β€”
▍ Regular Expressions in Excel
Β» https://exceljet.net/articles/regular-expressions-in-excel
β€”
▍ How to Use Not Equal To, Greater/Less Than Operators in Excel – Step by Step Guide
Β» https://www.myexcelonline.com/blog/not-equal-to-in-excel/
β€”
▍ How to Transform If Negative then Zero in Excel
Β» https://www.myexcelonline.com/blog/if-negative-then-zero/
β€”
▍ Creating Multi-Level Dependent Drop Down Lists in Excel - New and Better Way!
Β» https://www.youtube.com/watch?v=F92BOYiJF4o
β€”
▍ Copilot in OneDrive - Who thought THIS was possible?!
Β» https://www.youtube.com/watch?v=6WEqOrx6_Rg
β€”
▍ The Ultimate Guide to VLOOKUP Versus INDEX MATCH in Excel
Β» https://www.myexcelonline.com/blog/vlookup-versus-index-match-in-excel/
β€”
▍ Excel Change Column Numbers to Letters Easy Steps
Β» https://www.contextures.com/excelcolumnsnumbersletters.html

βž–βž–βž–
❀️ Anda suka? Jangan lupa tinggalkan emote reaksinya.
#ExcelRadar #Spreadsheet #Microsoft #Office #Excel #M365

β€”
▍ Formula to Remove Duplicates
Β» https://www.excel-university.com/formula-to-remove-duplicates/
β€”
▍ The Easy Way To Create A ChatGPT Function In Excel
Β» https://www.youtube.com/watch?v=TqYtRCdJsrQ
β€”
▍ Debra’s Excel News–December 2024
Β» https://contexturesblog.com/archives/2024/12/10/debras-excel-news-dec-2024/?utm_source=rss&utm_medium=rss&utm_campaign=debras-excel-news-dec-2024
β€”
▍ The Ultimate Guide to Use Conditional Formatting with Copilot in Excel
Β» https://www.myexcelonline.com/blog/conditional-formatting-with-copilot/
β€”
▍ Easy TRICK to Reset Dependent Drop-Down Lists in Excel (without VBA)
Β» https://www.youtube.com/watch?v=P02RpILkCXI
β€”
▍ How to Transform Data Analysis using Copilot in Excel
Β» https://www.myexcelonline.com/blog/data-analysis-using-copilot-in-excel/
β€”
▍ Easily Import Excel Data Like a PRO with This Free Add-in
Β» https://www.youtube.com/watch?v=NizFu1tiJAE
β€”
▍ How to Convert EST to IST in Excel – Step by Step Guide
Β» https://www.myexcelonline.com/blog/convert-est-to-ist-in-excel/
β€”
▍ 5 Creative Uses of Conditional Formatting in Excel
Β» https://www.exceldemy.com/5-creative-uses-conditional-formatting-excel/
β€”
▍ The Ultimate Guide to Calculate Differences in Excel
Β» https://www.myexcelonline.com/blog/calculate-differences-in-excel/
β€”
▍ How to Translate Portuguese to English in Excel
Β» https://www.myexcelonline.com/blog/translate-portuguese-to-english/
β€”
▍ Try This Function Instead of IF Statements
Β» https://www.youtube.com/watch?v=sL1Liu8po1Y

βž–βž–βž–
❀️ Anda suka? Jangan lupa tinggalkan emote reaksinya.
#ExcelRadar #Spreadsheet #Microsoft #Office #Excel #M365

β€”
▍ How to Clear History in Microsoft Teams – Step by Step Chat Delete Guide
Β» https://www.myexcelonline.com/blog/how-to-clear-history-in-microsoft-teams/
β€”
▍ Using Excel for Project Management
Β» https://www.exceldemy.com/using-excel-project-management/
β€”
▍ The Ultimate Guide to Excel Exponents – Calculate 2 to the power of 10
Β» https://www.myexcelonline.com/blog/2-to-the-power-of-10/
β€”
▍ How to Print an Excel Spreadsheet – Step by Step Guide
Β» https://www.myexcelonline.com/blog/how-to-print-an-excel-spreadsheet/
β€”
▍ Excel As Your Project Tracker: How to Make Real Progress Bars
Β» https://www.exceldemy.com/excel-project-tracker-real-progress-bars/
β€”
▍ How to Share a Page in OneNote
Β» https://www.myexcelonline.com/blog/how-to-share-a-page-in-onenote/
β€”
▍ GroupBy in Excel
Β» https://www.youtube.com/watch?v=3u4aJBK6ij4
β€”
▍ MS 365 Excel Basics #5: IF Function & Logical Test. IFS, IFNA, OR, AND, NOT, ISNUMBER Functions More
Β» https://www.youtube.com/watch?v=cRmEVw89FUE
β€”
▍ The Ultimate Guide to Top Margin Formula in Excel for Profits
Β» https://www.myexcelonline.com/blog/margin-formula-in-excel/
β€”
▍ This NEW Excel Function is NOT for Beginners (unless you watch this)
Β» https://www.youtube.com/watch?v=WlJSMyFOtk0
β€”
▍ Bar Graph vs Histogram in Excel – Which is Better?
Β» https://www.myexcelonline.com/blog/bar-graph-vs-histogram/
β€”
▍ The 2024 Gift Guide for Excel Enthusiasts
Β» https://www.excelcampus.com/tips-shortcuts/the-2024-gift-guide-for-excel-enthusiasts/

βž–βž–βž–
❀️ Anda suka? Jangan lupa tinggalkan emote reaksinya.
#ExcelRadar #Spreadsheet #Microsoft #Office #Excel #M365

β€”
▍ Highlight Incorrect Answers
Β» https://www.excel-university.com/highlight-incorrect-answers/
β€”
▍ Implementing Monte Carlo Simulation Using Excel
Β» https://www.exceldemy.com/implementing-monte-carlo-simulation-excel/
β€”
▍ Use AI To Generate Your Job Cover Letter, Resume & CV + Free Template
Β» https://www.youtube.com/watch?v=2Bzf0FzUn_U
β€”
▍ Python For Loops & Lists in 20 minutes (with a faster for loop trick πŸ’‘)
Β» https://www.youtube.com/watch?v=vSHUjaxBf14
β€”
▍ The Best Microsoft Teams Apps for Project Management
Β» https://www.myexcelonline.com/blog/best-microsoft-teams-apps-for-project-management/
β€”
▍ EASIEST Way (Ever) to Split Number and Text in Excel
Β» https://www.youtube.com/watch?v=GhP7Q3BvvFg
β€”
▍ How to Write Vertically in Excel
Β» https://trumpexcel.com/write-vertically-excel/
β€”
▍ Excel Plurals – How to Create Multiple Forms
Β» https://www.myexcelonline.com/blog/plurals-in-excel/
β€”
▍ How to Link Excel to Word?
Β» https://www.youtube.com/watch?v=lIcM5UoBTUM
β€”
▍ How to Set Out of Office Status in Microsoft Teams Fast
Β» https://www.myexcelonline.com/blog/how-to-set-out-of-office-status-in-microsoft-teams/
β€”
▍ ChatGPT In Excel? See How It Answers Questions And Assigns Accounts!
Β» https://www.youtube.com/watch?v=i4t9AccO85g
β€”
▍ How to Convert String to DateTime in Excel
Β» https://www.myexcelonline.com/blog/convert-string-to-datetime-in-excel/
β€”
▍ How to Insert Copyright Symbol in Excel Easily
Β» https://www.myexcelonline.com/blog/insert-copyright-symbol-in-excel/
β€”
▍ Simplify ANY Excel Formula With This Trick
Β» https://www.youtube.com/watch?v=zVyJCCk0sTY

βž–βž–βž–
❀️ Anda suka? Jangan lupa tinggalkan emote reaksinya.
#ExcelRadar #Spreadsheet #Microsoft #Office #Excel #M365

β€”
▍ How to Merge PowerPoint Presentations – Step by Step Guide
Β» https://www.myexcelonline.com/blog/how-to-merge-powerpoint-presentations/
β€”
▍ Automate Form Underlines in Excel Like a Pro!
Β» https://www.youtube.com/watch?v=IiIf8lugF2I
β€”
▍ How to Search for a Word in Excel Fast
Β» https://www.myexcelonline.com/blog/search-for-a-word-in-excel/
β€”
▍ How to Insert Approximate Symbol in Excel Fast
Β» https://www.myexcelonline.com/blog/insert-approximate-symbol-in-excel/
β€”
▍ How to Top Channels in Microsoft Teams for Collaboration
Β» https://www.myexcelonline.com/blog/channels-in-microsoft-teams/
β€”
▍ Google Sheets API Integration for Automation
Β» https://www.exceldemy.com/google-sheets-api-integration-automation/
β€”
▍ How to Convert Percentage to Basis Point in Excel – Step by Step Basis Point Calculator
Β» https://www.myexcelonline.com/blog/basis-point-calculator-in-excel/
β€”
▍ 🀯 This ONE Excel Formula Makes a Full Month's Calendar (No VBA!)
Β» https://www.youtube.com/watch?v=AbEZ8GIi6ms
β€”
▍ The Ultimate Guide to AND, OR, XOR, and NOT Functions in Excel
Β» https://www.myexcelonline.com/blog/and-or-xor-and-not-functions/
β€”
▍ How to Filter Strikethrough in Excel
Β» https://trumpexcel.com/filter-strikethrough-excel/
β€”
▍ AI Resume Builder Promo EDITED TextAdded
Β» https://www.youtube.com/watch?v=mtntQGsQQsI
β€”
▍ How to Stop Microsoft Teams from Opening at Startup – Step by Step Guide
Β» https://www.myexcelonline.com/blog/how-to-stop-microsoft-teams-from-opening-at-startup/

βž–βž–βž–
❀️ Anda suka? Jangan lupa tinggalkan emote reaksinya.
#ExcelRadar #Spreadsheet #Microsoft #Office #Excel #M365

β€”
▍ Stop Using SUBTOTAL! Use this instead
Β» https://www.youtube.com/watch?v=6FKy55kFUvA
β€”
▍ How To Turn Contacts Into VCF (vCard) Files In 1 Click + FREE DOWNLOAD
Β» https://www.youtube.com/watch?v=35D-_vKSQ4w
β€”
▍ The Ultimate Guide to Floor Function in Excel
Β» https://www.myexcelonline.com/blog/floor-function-in-excel/
β€”
▍ How to Convert Numbers to Scientific Notation in Excel
Β» https://www.myexcelonline.com/blog/how-to-convert-numbers-to-scientific-notation/
β€”
▍ The Ultimate Guide to Excel Formulas to Get Sheet Names
Β» https://www.myexcelonline.com/blog/get-sheet-names-in-excel/
β€”
▍ How to Find Population Mean in Excel – Step by Step Guide
Β» https://www.myexcelonline.com/blog/how-to-find-population-mean/
β€”
▍ Where to Find FREE Real-World Datasets for Practice
Β» https://www.youtube.com/watch?v=lpbJF99M64k
β€”
▍ How do I Create a New Team in Microsoft Teams
Β» https://www.myexcelonline.com/blog/how-do-i-create-a-new-team-in-microsoft-teams/

βž–βž–βž–
❀️ Anda suka? Jangan lupa tinggalkan emote reaksinya.
#ExcelRadar #Spreadsheet #Microsoft #Office #Excel #M365

β€”
▍ Macro VBA Menghitung Minggu Usia Kehamilan
Β» https://www.youtube.com/watch?v=E7sg1CAWFds
β€”
▍ VBA Menghitung Usia Kehamilan
Β» https://vba.co.id/vba-menghitung-usia-kehamilan/
β€”
▍ What is a Row and Its Functions – Step by Step Excel Guide
Β» https://www.myexcelonline.com/blog/excel-what-is-a-row/
β€”
▍ How to Calculate Per Unit Price Fast in Excel – Step by Step Guide
Β» https://www.myexcelonline.com/blog/per-unit-price-in-excel/
β€”
▍ The Ultimate Guide to Create and Print Graph Paper in Excel
Β» https://www.myexcelonline.com/blog/print-graph-paper-in-excel/
β€”
▍ Rumus Mencari Kombinasi Nilai Dari Nilai Yang Acak
Β» https://www.youtube.com/watch?v=xNfht-ROapA
β€”
▍ How to Open and Manage Dialog Boxes with Excel Shortcuts
Β» https://www.myexcelonline.com/blog/dialog-box-in-excel/
β€”
▍ Complete Excel Tutorial for Data Analysis in 4 Hours (with FREE Files)
Β» https://www.youtube.com/watch?v=7QNgqq154gE
β€”
▍ The Ultimate Guide to Inverse Cosine in Excel – Step by Step ACOS Guide
Β» https://www.myexcelonline.com/blog/master-inverse-cosine-in-excel/
β€”
▍ FREE 4 Hours Complete Excel Course
Β» https://chandoo.org/wp/complete-excel-course-free/
β€”
▍ How to Use the X Bar Symbol in Excel
Β» https://www.myexcelonline.com/blog/x-bar-symbol-in-excel/
β€”
▍ How to Link an Excel Chart to PowerPoint Slides
Β» https://www.myexcelonline.com/blog/how-to-link-an-excel-chart-to-powerpoint/

βž–βž–βž–
❀️ Anda suka? Jangan lupa tinggalkan emote reaksinya.
#ExcelRadar #Spreadsheet #Microsoft #Office #Excel #M365

β€”
▍ Automatic Check Boxes
Β» https://www.excel-university.com/automatic-check-boxes/
β€”
▍ Excel I Need A Once In A Lifetime Formula For 2025 - Episode 2665
Β» https://www.youtube.com/watch?v=_sJiLN5edko
β€”
▍ How To Track Sales Rep Commissions In Excel + FREE DOWNLOAD
Β» https://www.youtube.com/watch?v=8Oqkb_5JV_Q
β€”
▍ Automate Your Inventory in Excel: Create an Auto-Updating Inventory List!
Β» https://www.youtube.com/watch?v=opE3jj4U7i0
β€”
▍ The Ultimate Guide to Spearman Correlation in Excel – Rank Correlation Guide
Β» https://www.myexcelonline.com/blog/spearman-correlation-in-excel/
β€”
▍ Top Excel Inventory Templates – Step by Step Guide
Β» https://www.myexcelonline.com/blog/excel-inventory-templates/
β€”
▍ ExcelDemy’s Favorite Tutorials From 2024
Β» https://www.exceldemy.com/favorite-tutorials-2024/
β€”
▍ Excel Podcast #34: The Best Microsoft Excel Tips & Tricks in 2024
Β» https://www.myexcelonline.com/podcast/excel-podcast-34-the-best-microsoft-excel-tips-tricks-in-2024/
β€”
▍ Conquering Excel's Formatting Quirks with Creative Hacks - Episode 2664
Β» https://www.youtube.com/watch?v=yua8vu0pxyA
β€”
▍ The Ultimate Guide to Excel User Defined Functions – Create Custom Functions in Excel
Β» https://www.myexcelonline.com/blog/excel-user-defined-functions/
β€”
▍ Dynamic Arrays Without VBA: FILTER, SORT, UNIQUE, and SEQUENCE Functions
Β» https://www.exceldemy.com/dynamic-arrays-without-vba-filter-sort-unique-sequence-functions/
β€”
▍ Turn Your Contacts into VCF Files in SECONDS!
Β» https://www.youtube.com/watch?v=PzM2pIWeQKo
β€”
▍ How to Calculate OT Pay in Excel
Β» https://www.myexcelonline.com/blog/how-to-calculate-ot-in-excel/

βž–βž–βž–
❀️ Anda suka? Jangan lupa tinggalkan emote reaksinya.