PUTHEA Training
PUTHEA Training
  • 152
  • 346 496
How to Use the TRANSPOSE Function in Excel (Quick & Easy Tutorial)
Learn how to use the TRANSPOSE function in Excel to quickly switch your data between rows and columns without manually copying and pasting! This powerful function dynamically updates your transposed data when the original data changes, making it perfect for dynamic spreadsheets.
📌 What you'll learn in this video:
How to apply the TRANSPOSE function step by step.
The benefits of using the TRANSPOSE function over traditional methods.
Practical examples of when to use the TRANSPOSE function in Excel.
🔔 Don’t forget to like, subscribe, and share for more Excel tips!
Our member channel : @E Angkor Tech
----------------About Us---------------
#PutheaTraining
សូមជម្រាបសួរបងប្អូនទាំងអស់គ្នា! ទីនេះជាទីកន្លែងសម្រាប់ធ្វើការបង្ហាញ ណែនាំ បង្រៀន អំពីចំណេះដឹង បច្ចេកវិទ្យា និងស្វែងយល់អំពីកម្មវិធីសម្រាប់ការប្រើប្រាស់ធ្វើការងារប្រចាំថ្ងៃរបស់លោកអ្នក។ សូមជួយគាំទ្រ Channel នេះផង។
Hello everyone! This is a place to introduce, teach, and learn about the program for your daily work. Please support this Channel.
--------------------------------------------
More lesson about Excel:
-How to generate QR Code in Excel using VBA | Create QR Code In Excel
th-cam.com/video/vGgx6-CbKeI/w-d-xo.html
- Easy How To Create QR In Google Sheets | Generate QR By Your Self
th-cam.com/video/yprS6AxWDM4/w-d-xo.html
- How to calculate age in Excel (Date of birth) | Datedif in Excel
th-cam.com/video/Rc4X1fQQLvI/w-d-xo.html
- Difference between IF and IFs In Excel | How to use IFs
th-cam.com/video/pNFvS5Iq0Wo/w-d-xo.html
- Function & Simple Chart in Ms Excel
th-cam.com/video/ajOqU4BkDFM/w-d-xo.html
- Auto/dynamic border in Ms Excel using conditional formatting
th-cam.com/video/dOcgJrfFAHU/w-d-xo.html
- Allow and Protect edit blog of cells
th-cam.com/video/s05GFD7UXew/w-d-xo.html
---------------------------------------------------
Facebook : EAngkora/
Website : www.ifixproblem.com/
TH-cam : th-cam.com/users/EAngkor
Twitter : EAngkor
Some Search :
Excel free lesson, Excel online, Excel definition, Excel video, My Excel, Microsoft Excel, Microsoft Excel Training, Excel tutorial, excel function, excel functions training, excel functions with examples, excel functions tutorial, advanced excel functions, common excel functions, useful excel formulas, basic excel functions list
มุมมอง: 19

วีดีโอ

How to highlight full-color rows in Excel using Conditional Formatting
มุมมอง 5976 หลายเดือนก่อน
How to highlight full-color rows in Excel using Conditional Formatting Our member channel : @E Angkor Tech About Us #PutheaTraining សូមជម្រាបសួរបងប្អូនទាំងអស់គ្នា! ទីនេះជាទីកន្លែងសម្រាប់ធ្វើការបង្ហាញ ណែនាំ បង្រៀន អំពីចំណេះដឹង បច្ចេកវិទ្យា និងស្វែងយល់អំពីកម្មវិធីសម្រាប់ការប្រើប្រាស់ធ្វើការងារប្រចាំថ្ងៃរបស់លោកអ្នក។ សូមជួយគាំទ្រ Channel នេះផង។ Hello everyone! This is a place to introduce, teach, a...
Solve a problem Excel cannot add new column
มุมมอง 2249 หลายเดือนก่อน
Solve a problem Excel cannot add new column Our member channel: @E Angkor Tech About Us #PutheaTraining សូមជម្រាបសួរបងប្អូនទាំងអស់គ្នា! ទីនេះជាទីកន្លែងសម្រាប់ធ្វើការបង្ហាញ ណែនាំ បង្រៀន អំពីចំណេះដឹង បច្ចេកវិទ្យា និងស្វែងយល់អំពីកម្មវិធីសម្រាប់ការប្រើប្រាស់ធ្វើការងារប្រចាំថ្ងៃរបស់លោកអ្នក។ សូមជួយគាំទ្រ Channel នេះផង។ Hello everyone! This is a place to introduce, teach, and learn about the program f...
How to correct a #REF! error in VLOOKUP Excel
มุมมอง 735ปีที่แล้ว
The #REF! error shows when a formula refers to a cell that’s not valid. This happens most often when cells that were referenced by formulas get deleted, or pasted over. =VLOOKUP(A8,A2:D5,5,FALSE) will return a #REF! error because it’s looking for a value to return from column 5, but the reference range is A:D, which is only 4 columns. Our member channel : @E Angkor Tech About Us #PutheaTraining...
Easy How to delete Instagram Account [Update 2023]
มุมมอง 14ปีที่แล้ว
How to delete Instagram account forever professional account, How to delete Instagram account permanently. How to delete Instagram account on phone, how to delete Instagram account on android, how to delete Instagram account on iPhone, delete your account, delete Instagram account link, how to delete Instagram account temporarily. how to delete instagram account, instagram account delete kaise ...
Easy How to deactivate Instagram Account [Update 2023]
มุมมอง 1.8Kปีที่แล้ว
Temporarily deactivate your Instagram account, How to deactivate Instagram account | disable IG account, instagram account deactivate kaise kare, For new update 2023 how to deactivate instagram account Your will reactivate back, when you login your Instagram account. how to deactivate Instagram account permanently (Professional account), if you want to reactivate your account, you just login ba...
Upper, Lower, Proper formula in Excel
มุมมอง 79ปีที่แล้ว
Our member channel : @E Angkor Tech About Us #PutheaTraining សូមជម្រាបសួរបងប្អូនទាំងអស់គ្នា! ទីនេះជាទីកន្លែងសម្រាប់ធ្វើការបង្ហាញ ណែនាំ បង្រៀន អំពីចំណេះដឹង បច្ចេកវិទ្យា និងស្វែងយល់អំពីកម្មវិធីសម្រាប់ការប្រើប្រាស់ធ្វើការងារប្រចាំថ្ងៃរបស់លោកអ្នក។ សូមជួយគាំទ្រ Channel នេះផង។ Hello everyone! This is a place to introduce, teach, and learn about the program for your daily work. Please support this Cha...
Icon Sets Conditional Formatting in Excel
มุมมอง 167ปีที่แล้ว
Icon Sets Conditional Formatting in Excel
How to merge multi Word documents into one PDF file
มุมมอง 522 ปีที่แล้ว
How to merge multi Word documents into one PDF file
Cannot close the application, How can I do it? មិនអាចបិទកម្មវិធីគាំងបាន តើធ្វើយ៉ាងម៉េច?
มุมมอง 372 ปีที่แล้ว
Cannot close the application, How can I do it? មិនអាចបិទកម្មវិធីគាំងបាន តើធ្វើយ៉ាងម៉េច?
How to create intro video using PowerPoint
มุมมอง 662 ปีที่แล้ว
How to create intro video using PowerPoint
How to convert PowerPoint Slide to Video mp4 បំលែងទៅជាវីដេអូ
มุมมอง 502 ปีที่แล้ว
How to convert PowerPoint Slide to Video mp4 បំលែងទៅជាវីដេអូ
How to convert Word to PDF វិធីបំលែងឯកសារ Word ទៅ PDF
มุมมอง 242 ปีที่แล้ว
How to convert Word to PDF វិធីបំលែងឯកសារ Word ទៅ PDF
How to UNLOCK Protected Excel Sheets WITHOUT Password
มุมมอง 3462 ปีที่แล้ว
How to UNLOCK Protected Excel Sheets WITHOUT Password
No Skill, Get Simple Service Invoice Free Template In Excel បង្កើតវិក្កយបត្រមិនចាំបាច់ជំនាញ
มุมมอง 1.3K2 ปีที่แล้ว
No Skill, Get Simple Service Invoice Free Template In Excel បង្កើតវិក្កយបត្រមិនចាំបាច់ជំនាញ
Get Simple Loan Calculator Free In EXCEL គណនាអត្រាការប្រាក់
มุมมอง 3122 ปีที่แล้ว
Get Simple Loan Calculator Free In EXCEL គណនាអត្រាការប្រាក់
How to download voice message in Facebook របៀបទាញយកសារជាសម្លេងពីហ្វេសប៊ុក
มุมมอง 762 ปีที่แล้ว
How to download voice message in Facebook របៀបទាញយកសារជាសម្លេងពីហ្វេសប៊ុក
How to turn off or close News and Interests in Windows 11
มุมมอง 382 ปีที่แล้ว
How to turn off or close News and Interests in Windows 11
How to insert data to the table using data entry form in Excel
มุมมอง 2282 ปีที่แล้ว
How to insert data to the table using data entry form in Excel
How To Set Print Headings Or Titles On Every Page In Excel
มุมมอง 1122 ปีที่แล้ว
How To Set Print Headings Or Titles On Every Page In Excel
How to stop P.O.R.N website video (adult video) in PC
มุมมอง 2522 ปีที่แล้ว
How to stop P.O.R.N website video (adult video) in PC
How To Create Barcode In Google Sheets | Generate Barcode
มุมมอง 852 ปีที่แล้ว
How To Create Barcode In Google Sheets | Generate Barcode
How to stop automatic photo, video, audio download in Telegram
มุมมอง 302 ปีที่แล้ว
How to stop automatic photo, video, audio download in Telegram
LEFT and RIGHT Function in Excel with Exercise
มุมมอง 512 ปีที่แล้ว
LEFT and RIGHT Function in Excel with Exercise
How to Fix Gmail Password Issue in Mail App of Windows
มุมมอง 582 ปีที่แล้ว
How to Fix Gmail Password Issue in Mail App of Windows
How to change handle YouTube channel 2022
มุมมอง 112 ปีที่แล้ว
How to change handle TH-cam channel 2022
How to disable forward, copy, and save the message in Telegram Group
มุมมอง 1.9K2 ปีที่แล้ว
How to disable forward, copy, and save the message in Telegram Group
How to install CapCut for Windows | Video Editor
มุมมอง 242 ปีที่แล้ว
How to install CapCut for Windows | Video Editor
Excel: How to find Duplicate values and Unique values in the Table list
มุมมอง 3612 ปีที่แล้ว
Excel: How to find Duplicate values and Unique values in the Table list
How to get start date and end date of the month in Excel
มุมมอง 1292 ปีที่แล้ว
How to get start date and end date of the month in Excel

ความคิดเห็น

  • @phenchoeun7053
    @phenchoeun7053 5 วันที่ผ่านมา

    សុំទម្រង់ ២៣ មករា ២០១៧ ទៅជា 23/01/2017 វិញបង

    • @PutheaTraining
      @PutheaTraining 4 วันที่ผ่านมา

      បើ date សរសេរជា Unicode ប្រហែលជាមិនអាចទេ

  • @ChavGame-l7r
    @ChavGame-l7r 23 วันที่ผ่านมา

    ចុះបើបញ្ជីបុគ្គលិក យើងមិនទាន់បញ្ចូលទិន្នន័យ ហើយកន្លែងvloopup ចេញសញ្ញាសូន្យ ចង់អោយទទេធ្វើមិច

    • @PutheaTraining
      @PutheaTraining 22 วันที่ผ่านมา

      =IF(B7=0,"") ប្រើបែបនេះក៏បាន

  • @khmerit6733
    @khmerit6733 หลายเดือนก่อน

    សួស្តីបង POP and IAMP ខុសគ្នាដូចម្តេច

    • @PutheaTraining
      @PutheaTraining 22 วันที่ผ่านมา

      POP គឺ download email ពី Server មកផ្ទុកក្នុង Local ហើយអាចបើកមើលជាលក្ខណៈ Offline IMAP គឺរក្សាទុក email នៅតែ Server អាចមើលជាលក្ខណៈ Offline បានតែត្រូវ Sync Update ជាមួយ Server

    • @khmerit6733
      @khmerit6733 21 วันที่ผ่านมา

      @@PutheaTraining អរគុណបង

  • @Zahwa_miku
    @Zahwa_miku 2 หลายเดือนก่อน

    googleapis was deprecated, any others solution dor make qrcode

    • @PutheaTraining
      @PutheaTraining 2 หลายเดือนก่อน

      URL = "api.qrserver.com/v1/create-qr-code/?size=100x100&data=" & qrcode_value You can use this line to generate QR code

  • @SunVuthy-ih6lb
    @SunVuthy-ih6lb 4 หลายเดือนก่อน

    Hello, can you help me teach by oppo mobile

  • @foxynight1688
    @foxynight1688 5 หลายเดือนก่อน

    តើអាចបំលែងថ្ងៃខែឆ្នាំសរុយគតិទៅជាចន្ទគតិបានឬទេ?

  • @kathycrc
    @kathycrc 5 หลายเดือนก่อน

    YOU SIR ARE AMAZING!!!!!!!

  • @chaneric2331
    @chaneric2331 7 หลายเดือนก่อน

    It works 2 weeks, now excel can’t operate the VBA QR code! Please help me fix it ! Thanks!

  • @kakadamoth
    @kakadamoth 9 หลายเดือนก่อน

    why is my outlook cannot search ?

  • @Rico-r2p
    @Rico-r2p 11 หลายเดือนก่อน

    Simple, short, and efficient video, thanks!!

    • @PutheaTraining
      @PutheaTraining 10 หลายเดือนก่อน

      Glad it was helpful!

  • @listentothewordofgod
    @listentothewordofgod ปีที่แล้ว

    Thank you so much for your help

    • @PutheaTraining
      @PutheaTraining 11 หลายเดือนก่อน

      You are most welcome

  • @LeoWEYANT
    @LeoWEYANT ปีที่แล้ว

    purée mec, t'es le seul sur cette terre qui a su m'aider, j'ai cru que ça n'allait jamais marcher. MERCI !

  • @cheychann
    @cheychann ปีที่แล้ว

    លោកគ្រូ រូបមន្ត if &vlookup កន្លែង លក្ខ័ណ >= នៃចំនួន ណាមួយហើយ ខ្ញុំបានអោយចេញ ចំនួននោះ អត់ ចង់បានចេញ yes ឬ noទេ ។តើយើងអាចដាក់លក្ខ័ណមិចវិញលោកគ្រូ

    • @PutheaTraining
      @PutheaTraining ปีที่แล้ว

      បាទ បងអាចដាក់ រូបមន្ដ VLOOKUP ហ្នឹងកន្លែង YES បាន

    • @cheychann
      @cheychann ปีที่แล้ว

      ចឹងបងកន្លែង yes យើង ដាក់ សរសេរ vlookup មែនឬបង

  • @cheychann
    @cheychann ปีที่แล้ว

    លោកគ្រូមានលេខទូរស័ព្ទអត់ ខ្ញុំមានចម្ងល់

  • @World.of.Musikk
    @World.of.Musikk ปีที่แล้ว

    Thanks for sharing

  • @jorgeluissarmiento3575
    @jorgeluissarmiento3575 ปีที่แล้ว

    I struggled with a lot of videos and this was the easiest way to solve my problem. Thank you so much!!

  • @kontunsay3501
    @kontunsay3501 ปีที่แล้ว

    ស្នើរប៉ុន្មានថ្ងៃទើបគេ Email ឆ្លើយតបវិញបង?

  • @soksenghuoray3422
    @soksenghuoray3422 ปีที่แล้ว

    Hello teacher, I have 1Q: How to use vlookup in excel on Mac? Thanks before

  • @voanchivann7674
    @voanchivann7674 ปีที่แล้ว

    ប្រើបានគ្រប់excel version មែនលោកគ្រូ

  • @pnan4049
    @pnan4049 ปีที่แล้ว

    បងអាចប្រាប់ពីរបៀបប្រើVlookup ,if ,Countifបានអត់សុំរូបមន្ត លំហាត់ 1 ដារា ប្រុស វត្តមាន C A C A A A C C C វត្តមាន A អវត្តមាន SEARCH វត្តមាន🎈 អវត្តមាន🎈 បំរាប់ប្រើប្រាស់លេងរៀនក្នុង Search 🔎 គណនារកចំនួនរត្តមានសរុបនិងអវត្តមានសរុបដាក់ក្មុង🎈

  • @RNACTIVITY-ux9oj
    @RNACTIVITY-ux9oj ปีที่แล้ว

    សួស្តីបង ចុះពេលយើងដូរ Data File Location បានន័យថា outlook របស់យើងត្រូវ store លើ Drive D ត្រូវទេ​ ?

    • @PutheaTraining
      @PutheaTraining ปีที่แล้ว

      បាទត្រូវហើយ

  • @athinkt8943
    @athinkt8943 ปีที่แล้ว

    Qr code is generating successfully. But when ever I go to next sheet Qr code is also generating where ever I click in another sheet. Is there a way to generate QR code in a cell and lock aspect ratio

  • @BorinSok-nc4bz
    @BorinSok-nc4bz ปีที่แล้ว

    ❤❤❤

  • @siisii4897
    @siisii4897 ปีที่แล้ว

    Thanks you so much for shearing 😻❤️

  • @readingkhmer49
    @readingkhmer49 ปีที่แล้ว

    សួស្តីបង ខ្ញុំមានចំងល់មួយ ក្នុងexcel អក្សរខ្មែរនៅក្នុងក្រឡាស្អាតធម្មតា តែពេលចូលព្រីនអក្សរខ្មែរបែរជាដាច់សក់ខាងលើវិញអ៊ីចឹង ខ្ញុំប្រើms2021

    • @PutheaTraining
      @PutheaTraining ปีที่แล้ว

      តើអាចជួយផ្ញើ File ចូលក្នុងហ្វេសប៊ុកផេកខ្ញុំបានទេ ចាំខ្ញុំជួយមើលអោយ

  • @alexm.6469
    @alexm.6469 ปีที่แล้ว

    didn't work

  • @tanzimachowdhury5403
    @tanzimachowdhury5403 ปีที่แล้ว

    finally .I was tying to diactive my account for last 15 days finally got the actual process.thanks. saving it to get help again, later ♥️♥️♥️

  • @Lesley1556
    @Lesley1556 ปีที่แล้ว

    Finally a professional got my account fixed the above named user is a professional

  • @blindjoseph2384
    @blindjoseph2384 ปีที่แล้ว

    How it reactive

    • @PutheaTraining
      @PutheaTraining ปีที่แล้ว

      To reactivate your account back, just login your Instagram account before 30 days after deactivate

    • @Lesley1556
      @Lesley1556 ปีที่แล้ว

      I just got my account back with the help of ☝️☝️☝️

    • @PutheaTraining
      @PutheaTraining ปีที่แล้ว

      Thanks for your visiting

  • @prettyzebib7993
    @prettyzebib7993 ปีที่แล้ว

    Why is it not working even tho I followed the steps

  • @asmasultanasume9116
    @asmasultanasume9116 ปีที่แล้ว

    Heyy its saying " something is WRONG

  • @chaimae1505
    @chaimae1505 ปีที่แล้ว

    It's not work...!!!!

  • @aidasmentine
    @aidasmentine ปีที่แล้ว

    thanks, it really worked

  • @LuisGarcia-dm1bv
    @LuisGarcia-dm1bv ปีที่แล้ว

    Good help buddy🎉 you the best!!!

  • @koemmomlifestye8860
    @koemmomlifestye8860 ปีที่แล้ว

    Thanks

  • @sareyudomly8677
    @sareyudomly8677 ปีที่แล้ว

    បងចុះបើភ្លេចpassword វិញតើត្រូវធ្វើរដូចម្ដេចវិញបងប្រុស

    • @PutheaTraining
      @PutheaTraining ปีที่แล้ว

      ចាំខ្ញុំរកវិធីសាស្ដ្រថ្មី

  • @tardisbrou9748
    @tardisbrou9748 ปีที่แล้ว

    Super merci

  • @Carreaction99
    @Carreaction99 ปีที่แล้ว

    ប៉ុន្មានវីឌីអូទើបស្នើរបានបង

    • @PutheaTraining
      @PutheaTraining ปีที่แล้ว

      បាទបង ខ្ញុំក៏មិនដឹងច្បាស់ដែរ តែតាមខ្ញុំធ្លាប់បានគឺទាល់តែវីដេអូយើងគេមើលច្រើន និងចំនួន១០ឡើង

  • @koemsreymom9198
    @koemsreymom9198 ปีที่แล้ว

    សុំមេរៀនទៀតមកលោកគ្រូ

    • @PutheaTraining
      @PutheaTraining ปีที่แล้ว

      ចង់ដឹងពីអី លើកជាឧទាហរណ៍មក ចាំខ្ញុំបង្ហាញ

  • @krishnabawkar6879
    @krishnabawkar6879 ปีที่แล้ว

    If i want qr code in folder... What do i need change in the code.

    • @PutheaTraining
      @PutheaTraining ปีที่แล้ว

      Do you want to save QR code to folder in your PC, right?

    • @krishnabawkar6879
      @krishnabawkar6879 ปีที่แล้ว

      @@PutheaTraining yes sir, please help. And Thank you so much for reply.

    • @PutheaTraining
      @PutheaTraining ปีที่แล้ว

      In excel you can save as to .html for getting QR code to image

    • @krishnabawkar6879
      @krishnabawkar6879 ปีที่แล้ว

      @@PutheaTraining if i want all qr code in one folder with name(take from cell) in. Png format. Then what do in need change in the code.

    • @PutheaTraining
      @PutheaTraining ปีที่แล้ว

      Yes, It should change VBA code.

  • @anayakhan3751
    @anayakhan3751 ปีที่แล้ว

    Bro thats totally wrong

    • @PutheaTraining
      @PutheaTraining ปีที่แล้ว

      Sorry wrong, I forget format my PC with date formatting

    • @anayakhan3751
      @anayakhan3751 ปีที่แล้ว

      @@PutheaTraining its ok

  • @IamZ7
    @IamZ7 ปีที่แล้ว

    Wrong results! Why would you teach this!

    • @PutheaTraining
      @PutheaTraining ปีที่แล้ว

      Sorry wrong, I forget format my PC with date formatting

  • @koemsreymom9198
    @koemsreymom9198 ปีที่แล้ว

    Thanks

  • @koemsreymom9198
    @koemsreymom9198 2 ปีที่แล้ว

    Thanks

  • @chealy168
    @chealy168 2 ปีที่แล้ว

    អាចប្រើសម្រាប់ទាញយករូបភាពបានអត់លោកគ្រូ

    • @PutheaTraining
      @PutheaTraining 2 ปีที่แล้ว

      បាទ វា return តែ Value នោះទេ។

  • @EASYLEARN168
    @EASYLEARN168 2 ปีที่แล้ว

    លោកគ្រូ ទិន្នន័យដែលមានអក្សរខ្មែរ ពេលបម្លែងទៅជាQR CODE ពេលចុចscan វាមិនចេញអក្សរខ្មែរទេ

    • @PutheaTraining
      @PutheaTraining 2 ปีที่แล้ว

      បាទតើវាចេញយ៉ាងម៉េចដែរ?

    • @BestFriendsForeverTrue
      @BestFriendsForeverTrue 2 ปีที่แล้ว

      @@PutheaTraining ចេញតែ???? លោកគ្រូតើមានវិធីសាស្ត្រណាដែលយើងអាចរក្សាទុកqr code ដែលយើងបានgenerateទាំងអស់ saveទុកក្នុងកុំព្យូទ័របានទេ

    • @PutheaTraining
      @PutheaTraining 2 ปีที่แล้ว

      @@BestFriendsForeverTrue ករណីចេញសញ្ញា??? ប្រហែលមកពី VBA អស់ស្គាល់យូនីកូដ

    • @PutheaTraining
      @PutheaTraining 2 ปีที่แล้ว

      @@BestFriendsForeverTrue បើចង់ Save អាច Save វាជា Pdf

  • @rahuldestty
    @rahuldestty 2 ปีที่แล้ว

    Thanks a lot dear, its really useful, is it possible to update the code and save all qr codes as jpg with name of files in another column. Thanks again

  • @MeetkamalSingh
    @MeetkamalSingh 2 ปีที่แล้ว

    Thank You! It worked!

  • @chourbrotana
    @chourbrotana 2 ปีที่แล้ว

    👍

  • @yanchitrayean4283
    @yanchitrayean4283 2 ปีที่แล้ว

    បេីកចង់ព្រីនអោយជាប់ក្បាលអក្សរគ្រប់ទំព័រ​ តេីត្រូវធ្វេីបែបណា?

    • @PutheaTraining
      @PutheaTraining 2 ปีที่แล้ว

      បាទល្ងាចនេះ ខ្ញុំនឹងថតបង្ហាញអំពីរបៀបធ្វើ