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

β€”
▍ Three Common Sized Balance Sheet with Single Formula (ACCGT 455). #Short Excel Trick 30
Β» https://www.youtube.com/watch?v=onTPvqUJ5jw
β€”
▍ Tired of Manual Formatting in Excel? Try This Trick! 🌟
Β» https://www.youtube.com/watch?v=HhiPDqt9lTA
β€”
▍ ACCTG 455, Excel Finance Class 14: Financial Statement Cash Flow Equation Algebra Hint for HW 19
Β» https://www.youtube.com/watch?v=48dkMgIXfe8
β€”
▍ 5 Ways to Count Blank Cells in Microsoft Excel
Β» https://www.howtoexcel.org/count-blank-cells/
β€”
▍ The Ultimate Guide to Cube Root Function in Excel
Β» https://www.myexcelonline.com/blog/cube-root-function-in-excel/
β€”
▍ Perfect Shape Alignment in Seconds! πŸš€
Β» https://www.youtube.com/watch?v=hcO4g0BgmKA
β€”
▍ 5 Ways to Calculate Percentile in Microsoft Excel
Β» https://www.howtoexcel.org/calculate-percentile/
β€”
▍ Single Formula to Create Multiple Common Sized Income Statements! (ACCGT 455). #Short Excel Trick 29
Β» https://www.youtube.com/watch?v=KbBguAB7qyE
β€”
▍ How to Switch Tabs with Keyboard in Excel – Step by Step Guide
Β» https://www.myexcelonline.com/blog/how-to-switch-tabs-with-keyboard/
β€”
▍ 5 Ways to Add Commas to Numbers in Microsoft Excel
Β» https://www.howtoexcel.org/add-commas-to-numbers/
β€”
▍ How to Find Area of a Trapezoid in Excel – Area under the Curve
Β» https://www.myexcelonline.com/blog/area-of-a-trapezoid-in-excel/
β€”
▍ Excel Running Total-Rolling Total-Examples-Video
Β» https://www.contextures.com/excelrunningtotalexamples.html
β€”
▍ How to Solve a Rubik’s Cube – Easiest Method
Β» https://www.xelplus.com/how-to-solve-a-rubiks-cube-easy/
β€”
▍ Excel Common Size Income Statement with MS 365 Excel (ACCGT 455). #Short Excel Trick 28
Β» https://www.youtube.com/watch?v=HfZbckTC5gc
β€”
▍ Create All Possible Combinations From Multiple Lists in Excel (Power Query & Formula)
Β» https://www.youtube.com/watch?v=qBS_LbYgjRA
β€”
▍ 25 New Excel Features That Will Blow Your Mind
Β» https://www.youtube.com/watch?v=6HZxH3Q0UBw
β€”
▍ How to Calculate Beta Formula in Excel
Β» https://www.myexcelonline.com/blog/excel-beta-formula/
β€”
▍ What is a Whole Number in Excel – Round Numbers with Ease
Β» https://www.myexcelonline.com/blog/what-is-a-whole-number-in-excel/
β€”
▍ How To Make Your Worksheet Formula Solution Better!
Β» https://www.youtube.com/watch?v=NscoEeEEaTQ
β€”
▍ 5 Ways to Select Entire Table in Microsoft Excel
Β» https://www.howtoexcel.org/select-entire-table/
β€”
▍ 25 Excel Updates You Need to Try Now
Β» https://www.excelcampus.com/tips-shortcuts/25-new-excel-features-from-2024/
β€”
▍ 5 Ways to Count Yes in Microsoft Excel
Β» https://www.howtoexcel.org/count-yes/
β€”
▍ Surface Area of a Cone in Excel – Step by Step Formula Guide
Β» https://www.myexcelonline.com/blog/surface-area-of-a-cone/

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

β€”
▍ Fixed Monthly Value Between Dates
Β» https://www.excel-university.com/fixed-monthly-value-between-dates/
β€”
▍ How To Build An Apartment Management Application – Designed From Scratch + Free Template
Β» https://www.youtube.com/watch?v=BP9CwF-eHdM
β€”
▍ Your TEXTSPLIT Formulas are USELESS, Until You Do This!!
Β» https://www.youtube.com/watch?v=CeEttQDhO-Q
β€”
▍ ACCTG 455: Excel Finance Class 19.75: DuPont ROE Analysis
Β» https://www.youtube.com/watch?v=XdquZ6pnRWY
β€”
▍ Happy Excel Day 45678
Β» https://contexturesblog.com/archives/2025/01/21/happy-excel-day-45678/?utm_source=rss&utm_medium=rss&utm_campaign=happy-excel-day-45678
β€”
▍ How to Make Precise CTR Formula for Improved Clicks in Excel
Β» https://www.myexcelonline.com/blog/ctr-formula-in-excel/
β€”
▍ ACCTG 455: Excel Finance Class 19.5: Why DuPont ROE Analysis is So Clever!
Β» https://www.youtube.com/watch?v=_k5azgi1_GY
β€”
▍ Stop Manual Formatting! Try this Excel Trick! ✨
Β» https://www.youtube.com/watch?v=-o_sN4uAGbo
β€”
▍ The Ultimate Guide to Excel Cross Referencing – How to Sync Two Sheets
Β» https://www.myexcelonline.com/blog/excel-cross-referencing/
β€”
▍ World’s Greatest Excel Keyboard Short Cut? It’s a Tie Between Two!!! #Short Excel Magic Trick 32
Β» https://www.youtube.com/watch?v=ToJD2wFDjvE
β€”
▍ How to Check Blanks in Excel – Step by Step Guide
Β» https://www.myexcelonline.com/blog/check-blanks-in-excel/
β€”
▍ The Ultimate Guide to Range in Excel
Β» https://www.myexcelonline.com/blog/range-in-excel/
β€”
▍ Clean Data 10x Faster with This Trick
Β» https://www.youtube.com/watch?v=q-7dqxXz4c4

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

β€”
▍ How To Become A Master At Conditional Formatting In Excel
Β» https://www.youtube.com/watch?v=dWLZ_oBC-9Y
β€”
▍ Stop Wasting Time on Org Charts! πŸš€ Learn the Faster Way!
Β» https://www.youtube.com/watch?v=SPJ1NPJHCZE
β€”
▍ What is Difference Between Clustered Column & Stack Column Excel Charts? #Short Excel Trick 39
Β» https://www.youtube.com/watch?v=rEP6M5UYX64
β€”
▍ CSV and XLSX Files Look The Same!?!? Here Is How To Fix That!. #Short Excel Trick 38
Β» https://www.youtube.com/watch?v=OhISrahHN5Q
β€”
▍ The Ultimate Guide to MUNIT Function in Excel
Β» https://www.myexcelonline.com/blog/munit-function-in-excel/
β€”
▍ Excel Formulas: Arrow Keys or Mouse? Return on Assets & Return on Equity Show the Best! #Short ET 37
Β» https://www.youtube.com/watch?v=XtR1B1W62rs
β€”
▍ Chart Hacks that you should know!πŸ”₯πŸ“ˆ
Β» https://www.youtube.com/watch?v=45jBCtTT0k0
β€”
▍ How to Convert Word to Excel – Step by Step Export Guide
Β» https://www.myexcelonline.com/blog/convert-word-to-excel/
β€”
▍ How to Center Values in Table in Excel
Β» https://www.myexcelonline.com/blog/how-to-center-values-in-table/
β€”
▍ The Ultimate Guide to Ceiling Function in Excel
Β» https://www.myexcelonline.com/blog/master-ceiling-function-in-excel/
β€”
▍ I Can’t See All of My Excel Worksheet Tabs!?!?! #Short Excel Trick 36
Β» https://www.youtube.com/watch?v=5sfUPMW_3_Q
β€”
▍ Compare 2 Excel Sheets (Easy Bank Reconciliation)
Β» https://www.youtube.com/watch?v=H7k_DY-iPJE
β€”
▍ The Ultimate Guide to Cotangent Formula in Excel
Β» https://www.myexcelonline.com/blog/cotangent-formula-in-excel/
β€”
▍ How to Compare Two Sheets in Excel: Bank Reconciliations Made Easy
Β» https://www.excelcampus.com/pivot-tables/bank-reconciliations/
β€”
▍ Subtle Excel Keyboard Awesomeness: Ctrl + Shift + Arrow, then, Shift + Arrow #Short Excel Trick 35
Β» https://www.youtube.com/watch?v=JBYLhGecLIE
β€”
▍ How to Add a Row in Excel – Step by Step Guide
Β» https://www.myexcelonline.com/blog/how-to-add-a-row-in-excel/

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

β€”
▍ How To Create Dependent Drop Down Lists In Userforms
Β» https://www.youtube.com/watch?v=-qR4UMxIDfU
β€”
▍ Deep Discount Loan Amortization Table (Treasury Bonds) . #Short Excel Trick 42. ACCTG 455.
Β» https://www.youtube.com/watch?v=Hp6--4BPbWM
β€”
▍ Add a Search Box with Highlights in Excel! πŸ”βœ¨
Β» https://www.youtube.com/watch?v=IJi9wU8IzGU
β€”
▍ The Ultimate Guide to Excel Discount Factor – Formula and DCF Calculation
Β» https://www.myexcelonline.com/blog/excel-discount-factor/
β€”
▍ Excel Spilled Equal Principal Payment Amortization Table . #Short Excel Trick 41. ACCTG 455.
Β» https://www.youtube.com/watch?v=U9Eh7ixFxo8
β€”
▍ How to Aggregate Data in Excel
Β» https://www.myexcelonline.com/blog/aggregate-data-in-excel/
β€”
▍ How to Abbreviate Numbers in Excel – Step by Step Guide
Β» https://www.myexcelonline.com/blog/abbreviate-number-in-excel/
β€”
▍ Excel Spilled Loan Amortization Table. #Short Excel Trick 40. ACCTG 455.
Β» https://www.youtube.com/watch?v=iT3F-Jzp0m0
β€”
▍ The Ultimate Guide to Add a Carriage Return within Cells in Excel
Β» https://www.myexcelonline.com/blog/carriage-return-in-excel/
β€”
▍ How to Avoid #NUM! Error – 0 to Power of 0 in Excel
Β» https://www.myexcelonline.com/blog/0-to-power-of-0-in-excel/
β€”
▍ Who Knew Excel has a Hidden QR code Creator (actually 2!)
Β» https://www.youtube.com/watch?v=4eeSlyGwUzg
β€”
▍ How to Truncate Numbers with TRUNC in Excel
Β» https://www.myexcelonline.com/blog/trunc-in-excel/
β€”
▍ Excel Kill The Annoying Copilot Floating Icon - Episode 2667
Β» https://www.youtube.com/watch?v=aQmvtiLfqeU

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

β€”
▍ How To Get A Free Loan Amortization Template
Β» https://www.excel-university.com/how-to-get-a-free-loan-amortization-template/
β€”
▍ Excel Change 3D Map From City To State - Episode 2669
Β» https://www.youtube.com/watch?v=O4Dd0SGYHBc
β€”
▍ Crush Your Super Bowl Bets with Excel! πŸˆπŸ“Š
Β» https://www.youtube.com/watch?v=5lVsRR3U6Yk
β€”
▍ Your Marketing Expert: Generate ANY Content In 1 Click
Β» https://www.youtube.com/watch?v=Mer_NNZ-2XM
β€”
▍ Spill Bond Valuation PV Function Formula Across YTM Rates. #Short Excel Trick 45. ACCTG 455 #50.3
Β» https://www.youtube.com/watch?v=FOIy72ySTJ0
β€”
▍ Beyond Power BI - Data Skills You need in 2025 to GROW πŸš€
Β» https://www.youtube.com/watch?v=RDipBFRmlPc
β€”
▍ How to Convert Unix Timestamp to Date in Excel
Β» https://www.myexcelonline.com/blog/convert-unix-timestamp-to-date-in-excel/
β€”
▍ How to Roll the Dice in Excel – Step by Step Guide for Gamers
Β» https://www.myexcelonline.com/blog/roll-the-dice-in-excel/
β€”
▍ How to Show "Discount 10%" in Excel Using Formulas & Custom Formatting - Episode 2668
Β» https://www.youtube.com/watch?v=UWI5Jq1BX9w
β€”
▍ IFS Function for Bond Value "Par", "Discount", or "Premium". #Short Excel Trick 44. ACCTG 455 # 50.2
Β» https://www.youtube.com/watch?v=_lFHok0ceYA
β€”
▍ How to Use Pythagorean Theorem in Excel – Step by Step Formula Guide
Β» https://www.myexcelonline.com/blog/pythagorean-theorem-in-excel/
β€”
▍ How to Calculate Ageing in Excel Fast
Β» https://www.myexcelonline.com/blog/calculate-ageing-in-excel/
β€”
▍ Make Awesome Wall Street Journal Charts in Excel
Β» https://www.youtube.com/watch?v=tfQSabvSjDE

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

β€”
▍ Automate Image Insertion in Excel – Save Time & Effort! πŸ–ΌοΈ
Β» https://www.youtube.com/watch?v=umWAUYE-gVM
β€”
▍ 10 INCREDIBLE Ways To Hide Data In Excel
Β» https://www.youtube.com/watch?v=rc9HH_wDiiU
β€”
▍ Bond Rate Risk: Lower Coupon Rate, The More YTM Affects Bond Price. #Short 48. ACCTG 455 #54.2
Β» https://www.youtube.com/watch?v=Fwb0mt7LtD0
β€”
▍ Add a Real-Time Clock in Excel ⏰ Easy & Automatic!
Β» https://www.youtube.com/watch?v=2qaTqScoEkg
β€”
▍ How To Calculate How Many Weeks Between Two Dates in Excel
Β» https://www.myexcelonline.com/blog/how-many-weeks-between-two-dates/
β€”
▍ The Ultimate Guide to CV Analysis – Coefficient of Variation Formula in Excel
Β» https://www.myexcelonline.com/blog/coefficient-of-variation-formula/
β€”
▍ Excelisfun Needs Your Help in Solving A Formula Number Formatting Mystery. #Short 52 Part 02
Β» https://www.youtube.com/watch?v=7guOaXkqB_A
β€”
▍ How to Get First Numeric Number in Range in Excel – Step by Step Guide
Β» https://www.myexcelonline.com/blog/get-first-numeric-number-in-range/
β€”
▍ How to Define Data Bars in Excel
Β» https://www.myexcelonline.com/blog/define-data-bars-in-excel/
β€”
▍ πŸ‘€ Dark Mode in Excel is FINALLY here (here is how to enable it)
Β» https://www.youtube.com/watch?v=4jGUf4YMZHA
β€”
▍ Excel Copilot Versus Deep Seek Head to Head - Episode 2671
Β» https://www.youtube.com/watch?v=omXgX9Azn78
β€”
▍ Bond Rate Risk: Longer Maturity, More YTM Affects Bond Price. #Short 47. ACCTG 455 #54.1
Β» https://www.youtube.com/watch?v=BYQYmf1hQFU
β€”
▍ Excel Data Cleanup Made Easy (QuickBooks Edition)
Β» https://www.youtube.com/watch?v=x61ugTIrwDM
β€”
▍ The Ultimate Guide to Budget Tracking – Best Excel Expense Sheet Template Free
Β» https://www.myexcelonline.com/blog/excel-expense-sheet-template/
β€”
▍ The Ultimate Guide to Shared Workbooks in Excel
Β» https://www.myexcelonline.com/blog/excel-shared-workbooks/

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

β€”
▍ Excel Three Bots Versus Three Gurus Episode 2672
Β» https://www.youtube.com/watch?v=GPLLrcq3D3A
β€”
▍ Unbelievable Dashboards (in 3 easy steps)
Β» https://www.excel-university.com/unbelievable-dashboards-in-3-easy-steps/
β€”
▍ How To Create A Simple Purchase Order With Inventory FROM SCRATCH + Free Download
Β» https://www.youtube.com/watch?v=vu8-0K96JtA
β€”
▍ Build Text Formula for Dynamic Label For Financial Model. #Short 51. ACCTG 455 #68.1
Β» https://www.youtube.com/watch?v=D3pB5W_ZkzE
β€”
▍ Why Are Cumulative Averages So Hard in Excel? (and an easy fix πŸ‘Œ)
Β» https://www.youtube.com/watch?v=dPGICQVQIk0
β€”
▍ How to Calculate Distance Between Two Cities in Excel – Step by Step Guide
Β» https://www.myexcelonline.com/blog/calculate-distance-between-two-cities/
β€”
▍ 8 Ways to Recover a Deleted Sheet in Microsoft Excel
Β» https://www.howtoexcel.org/recover-deleted-sheet/
β€”
▍ 3 Ways To Add Vertical Line in Excel Graph
Β» https://www.howtoexcel.org/add-vertical-line-in-graph/
β€”
▍ 5 Ways to Import TXT to Microsoft Excel
Β» https://www.howtoexcel.org/import-txt-file/
β€”
▍ 5 Ways to Insert a Photo in Microsoft Excel
Β» https://www.howtoexcel.org/insert-photos/
β€”
▍ 6 Ways to Lock an Excel Spreadsheet From Editing
Β» https://www.howtoexcel.org/lock-spreadsheet-from-editing/
β€”
▍ Smart Drop-Downs That Highlight Automatically! 🎨✨
Β» https://www.youtube.com/watch?v=f1fSfRf1aS0
β€”
▍ How to Calculate Hours Worked in Excel
Β» https://www.myexcelonline.com/blog/how-to-calculate-hours-worked-in-excel/
β€”
▍ Visualize How Stock Values Changes as Required Rate of Return Changes. #Short 50. ACCTG 455 #63.2
Β» https://www.youtube.com/watch?v=o8DxP15KonU
β€”
▍ How to Convert Stones to Pounds in Excel
Β» https://www.myexcelonline.com/blog/convert-stones-to-pounds/
β€”
▍ How to Use Excel Cut Shortcut
Β» https://www.myexcelonline.com/blog/excel-cut-shortcut/
β€”
▍ Automate Copy-Pasting in Excel With This Simple Trick
Β» https://www.youtube.com/watch?v=PmAGKzaHb2I

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

β€”
▍ Can A Single Cell Hold 4 Different Values? Let’s Find Out!
Β» https://www.youtube.com/watch?v=xKJsTf2ZwFw
β€”
▍ 5 Ways to Separate Addresses in Microsoft Excel
Β» https://www.howtoexcel.org/separate-addresses/
β€”
▍ Transform Numbers into Visuals! πŸ“Š
Β» https://www.youtube.com/watch?v=-o2XXFfHd1A
β€”
▍ Net Present Value Profile Spilled Formula: Table and X-Y Scatter Chart. #Short 54. ACCTG 455 #68.4
Β» https://www.youtube.com/watch?v=u-qpKt6gizc
β€”
▍ The Ultimate Guide to Do While Loops in Excel VBA
Β» https://www.myexcelonline.com/blog/do-while-loops-in-excel-vba/
β€”
▍ Enable Dark Mode in Microsoft Excel
Β» https://trumpexcel.com/dark-mode-excel/
β€”
▍ How to Get Social Security Number Format in Excel
Β» https://www.myexcelonline.com/blog/social-security-number-format-in-excel/
β€”
▍ 6 Ways To Delete Notes in Microsoft Excel
Β» https://www.howtoexcel.org/delete-notes/
β€”
▍ The Ultimate Guide to Inserting Registered Mark Character in Excel
Β» https://www.myexcelonline.com/blog/registered-mark-character-in-excel/
β€”
▍ Internal Rate of Return = IRR (Rate at Which NPV = 0). #Short 53. ACCTG 455 #68.3
Β» https://www.youtube.com/watch?v=QyQkyydXmQo
β€”
▍ The Best Version of Excel (+which to Avoid)
Β» https://www.youtube.com/watch?v=NGbUYaMPbjw
β€”
▍ The Ultimate Guide to GMT to EST Conversion in Excel
Β» https://www.myexcelonline.com/blog/gmt-to-est-conversion-in-excel/
β€”
▍ 5 Ways to Calculate Months Between Two Dates in Microsoft Excel
Β» https://www.howtoexcel.org/calculate-months-between-two-dates/
β€”
▍ The Ultimate Guide to Master VBA Variables in Excel
Β» https://www.myexcelonline.com/blog/vba-variables-in-excel/

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

β€”
▍ Free Personal Budget Template
Β» https://www.excel-university.com/free-personal-budget-template/
β€”
▍ Create Column of 8 Excel Text Formulas from Rectangle Range with Single Spilled Formula. #Short 56
Β» https://www.youtube.com/watch?v=jz5FAlMMUGc
β€”
▍ How To Automatically Extract Email Data Into Excel & Google Sheets
Β» https://www.youtube.com/watch?v=26riQXfJVkc
β€”
▍ This NEW Excel function is insanely powerful!
Β» https://www.youtube.com/watch?v=M_-5nwJnO3o
β€”
▍ How to Deselect Cells in Excel Fast
Β» https://www.myexcelonline.com/blog/how-to-deselect-cells-in-excel/
β€”
▍ How to Save $30 on Microsoft 365 Subscription – Opt Out of Microsoft Copilot
Β» https://www.myexcelonline.com/blog/opt-out-of-microsoft-copilot-in-excel/
β€”
▍ Stay Ahead with Auto Stock Updates in Excel! πŸ“ˆπŸ“‰
Β» https://www.youtube.com/watch?v=vbATjOaUleM
β€”
▍ Excel's Amazing SCAN Function: Spill Formula That Acts On Previous Spilled Value!?! #Short Excel 55
Β» https://www.youtube.com/watch?v=MIgrv7NgaZ8
β€”
▍ The Ultimate Guide to Excel DCF – Discounted Cash Flow Formula
Β» https://www.myexcelonline.com/blog/discounted-cash-flow-formula-in-excel/
β€”
▍ How to Convert Decimal to Hexadecimal – Step by Step Excel DEC2HEX Guide
Β» https://www.myexcelonline.com/blog/how-to-convert-decimal-to-hexadecimal/
β€”
▍ Make an Advanced Data Entry Form in Excel (Fully Automated)
Β» https://www.youtube.com/watch?v=pZbpx_7E36U

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