20+ Excel Problem Solved | एक Keyboard Shortcut 900 Excel Formula पर भारी

Поделиться
HTML-код
  • Опубликовано: 13 июн 2024
  • 20+ Excel Problem Solved | एक Keyboard Shortcut 900 Excel Formula पर भारी
    🔥Buy Our Paid Computer Courses - mylivesupport.in/
    🔥Download Excel file for Practice - bit.ly/3KGmGCj
    Welcome to our comprehensive tutorial on using Excel's Flash Fill function, where we solve 20+ common Excel problems with a single keyboard shortcut: Ctrl+E. In this video, you'll learn how to harness the power of Flash Fill to automate data entry and formatting tasks that would otherwise require complex formulas.
    Whether you're a beginner or an advanced Excel user, this video will show you how to save time and increase your productivity with Excel's Flash Fill feature.
    In this video, we cover:
    1. Extracting first and last names from full names.
    2. Formatting phone numbers.
    3. Extracting domains from email addresses.
    4. Combining address components into a single string.
    5. Creating usernames from full names.
    6. Extracting initials from names.
    7. And many more practical examples!
    ❤Show your LOVE by “ LIKE COMMENT & SHARE this video ”
    ❤Don’t forget to “SUBSCRIBE & PRESS THE BELL ICON”
    Please support me on
    Follow us on Telegram - t.me/mylivesupport
    Like us on Facebook - / mylivesupport
    Website - mylivesupport.in/
    Follow us on Twitter - / mylivesupport
    Follow us Instagram - / mylivesupport
    Facebook Myself - / chandankumar926
    RUclips - / mylivesupport
    ▶️WATCH ALL VIDEOS FROM BELOW PLAYLIST :
    ▶️All Video for MS Excel Magic Trick Series - goo.gl/qS296Q
    ▶️Top 10 Excel Video in Hindi - goo.gl/McEe53
    ▶️All Videos of Excel in Hindi - goo.gl/boUo8C
    ▶️All Videos of Technology in Hindi - goo.gl/E9VyCA
    ▶️All Videos of MS Excel VBA in Hindi - goo.gl/W4pb5t
    ▶️All Videos for Tally.ERP9 GST in Hindi - goo.gl/CbsFhr
    #20ExcelProblemSolved #ExcelTutorial #CtrlE #ExcelShortcuts #DataEntry #Productivity #ExcelFormulas #ExcelAutomation #MicrosoftExcel #ExcelTutorial #Spreadsheet #Office365 #FlashFill
    Our aim behind making this channel to make you expert in Microsoft Excel, Microsoft Word, Tally.ERP9, Computer and Technology. You can easily learn Excel, Word, Tally, Internet, Computer in Hindi language. So don’t forget to Subscribe Our Channel.
    ---------------- Chandan Kumar ----------------

Комментарии • 35

  • @MyLiveSupport
    @MyLiveSupport  27 дней назад +1

    🔥Enroll in our Computer Courses - mylivesupport.in/
    🔥Download Excel file for Practice - bit.ly/3KGmGCj
    Don't forget to LIKE COMMENT and Share this video and Do SUBSCRIBE :)

    • @aksh824
      @aksh824 26 дней назад +1

      Sir Powerbi ka Course ka video baniye

    • @aksh824
      @aksh824 26 дней назад

      From Basic to advanced

  • @ayodhyaprasad1382
    @ayodhyaprasad1382 6 часов назад +1

    Super sir

  • @bishankanwar937
    @bishankanwar937 2 дня назад

    Nice

  • @ihgamingfun6295
    @ihgamingfun6295 4 дня назад

    Bhahut khuub 👍👍 socha nahi ta Flash Fill itna sara kam kar k dega 😮😮 this particular video is more value than any paid course... So many examples are given.. No one will give these kind of examples in paid course also... Very nice 👍👍

  • @shambhmed
    @shambhmed 27 дней назад

    Mindblowing❤❤

  • @accountantrajatsharma2992
    @accountantrajatsharma2992 26 дней назад

    Great 👍

  • @Pratapsingh-nj4uf
    @Pratapsingh-nj4uf 17 дней назад

    Very good 👍 information 👌 sir ji

  • @user-zv3jd5uk9t
    @user-zv3jd5uk9t 21 день назад

    This formula is so smart

  • @navneetkumar5790
    @navneetkumar5790 19 дней назад +5

    Baat karte ho smart work ki aur jo baat 2 minute mein samjhai ja sakti hai uske liye 15 minute kha gaye

    • @MyLiveSupport
      @MyLiveSupport  3 дня назад

      Jaruri nahi ki aapki tarah sabhi log samajhdar ho. Different examples ke sath video banaya ha isliye time thoda sa jarur laga hai.

  • @don-ct6hm
    @don-ct6hm 10 дней назад

    Wow

  • @Shankersharma87
    @Shankersharma87 17 дней назад

    Computer password change aur resat karne key videos. Baney jal hi ❤

  • @smjamadar7781
    @smjamadar7781 26 дней назад +1

    How to apply formula I am using windows 7

  • @webnepal5186
    @webnepal5186 16 дней назад

    ❤❤

  • @user-tv3to2hm7d
    @user-tv3to2hm7d 10 дней назад

    Nice video.sachin sawant l.i.c.you tuber

  • @bhaskarsiri8664
    @bhaskarsiri8664 21 день назад

    👌👌👌👌👌👌👌👌🙏🙏🙏🙏🙏🙏

  • @rajadey1552
    @rajadey1552 7 дней назад

    Naamune 🤭

  • @smjamadar7781
    @smjamadar7781 26 дней назад +1

    Windows 2003 using

    • @prashanttyagi1156
      @prashanttyagi1156 26 дней назад

      Not problem ur using win 2003 u can use excel latest version then u can use office 365 online.

  • @ghalder1674
    @ghalder1674 27 дней назад

    Jaldi batao yaar

  • @syedmahmood2002
    @syedmahmood2002 19 дней назад

    Ctrl+E formula didn't work on create email ID. Formula is copying all names' initial as "J" only. Pls check and advise. Thanks.

    • @poonamchandsahu2401
      @poonamchandsahu2401 11 дней назад

      Windows 19 work ctrl+E , fill down

    • @MyLiveSupport
      @MyLiveSupport  3 дня назад

      Type two initials like J and M. After that select all the cells including initials and press Ctrl+E

  • @siddharthsuman297
    @siddharthsuman297 11 дней назад

    Bhai main windows 7 user hun wahan pe bhi apply kar sakte hain kya

    • @MyLiveSupport
      @MyLiveSupport  9 дней назад

      Excel version 2013 and above hona chahiye. Windows version se matlab nahi hai

    • @uttarakhandgs9157
      @uttarakhandgs9157 9 дней назад

      Wahan nhi ho Raha h.

  • @nirmalbehura9039
    @nirmalbehura9039 25 дней назад

    Last sheet mail id Nehi hota hai flash fill se

    • @MyLiveSupport
      @MyLiveSupport  25 дней назад +1

      Try full name instead of first character

  • @Excelsmart23
    @Excelsmart23 12 часов назад

    30 sec. Ka video yr 15 min.kar diya