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 ----------------

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

  • @MyLiveSupport
    @MyLiveSupport  Месяц назад +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 Месяц назад +1

      Sir Powerbi ka Course ka video baniye

    • @aksh824
      @aksh824 Месяц назад

      From Basic to advanced

  • @ayodhyaprasad1382
    @ayodhyaprasad1382 21 день назад +3

    Super sir

  • @rajeshkatare4605
    @rajeshkatare4605 18 дней назад +2

    बहुत ही शानदार वीडियो sir

  • @JKVERMA-ey5pp
    @JKVERMA-ey5pp 12 дней назад

    Very nice demonstration ❤

  • @shambhmed
    @shambhmed Месяц назад

    Mindblowing❤❤

  • @accountantrajatsharma2992
    @accountantrajatsharma2992 Месяц назад

    Great 👍

  • @Pratapsingh-nj4uf
    @Pratapsingh-nj4uf Месяц назад

    Very good 👍 information 👌 sir ji

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

    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 👍👍

  • @don-ct6hm
    @don-ct6hm Месяц назад

    Wow

  • @user-zv3jd5uk9t
    @user-zv3jd5uk9t Месяц назад

    This formula is so smart

  • @webnepal5186
    @webnepal5186 Месяц назад

    ❤❤

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

    Nice

  • @Shankersharma87
    @Shankersharma87 Месяц назад

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

  • @GurpreetSingh-ur7gs
    @GurpreetSingh-ur7gs 15 дней назад

    Flash ⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡⚡

  • @bhaskarsiri8664
    @bhaskarsiri8664 Месяц назад

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

  • @smjamadar7781
    @smjamadar7781 Месяц назад +1

    How to apply formula I am using windows 7

  • @navneetkumar5790
    @navneetkumar5790 Месяц назад +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  24 дня назад +1

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

  • @user-cq9qq8bs4c
    @user-cq9qq8bs4c 3 дня назад

    time 7.31 per firs letter J common le raha h pls check

  • @smjamadar7781
    @smjamadar7781 Месяц назад +1

    Windows 2003 using

    • @prashanttyagi1156
      @prashanttyagi1156 Месяц назад

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

  • @syedmahmood2002
    @syedmahmood2002 Месяц назад

    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 Месяц назад

      Windows 19 work ctrl+E , fill down

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

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

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

    Naamune 🤭

  • @siddharthsuman297
    @siddharthsuman297 Месяц назад

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

    • @MyLiveSupport
      @MyLiveSupport  Месяц назад

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

    • @uttarakhandgs9157
      @uttarakhandgs9157 Месяц назад

      Wahan nhi ho Raha h.

  • @ghalder1674
    @ghalder1674 Месяц назад

    Jaldi batao yaar

  • @nirmalbehura9039
    @nirmalbehura9039 Месяц назад

    Last sheet mail id Nehi hota hai flash fill se

    • @MyLiveSupport
      @MyLiveSupport  Месяц назад +1

      Try full name instead of first character

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

    30 sec. Ka video yr 15 min.kar diya