Filtered Result Calculation & Delete Empty Rows in Data | Google Sheets Tutorial

Поділитися
Вставка
  • Опубліковано 12 вер 2024
  • Filtered Result Calculation & Delete Empty Rows in Data | Google Sheets Tutorial
    Download the Assignment Master Practice Folder here (All Playlist Example at one place)
    drive.google.c...
    Music: www.bensound.com
    ===========VIDEO COURSE============================
    ✅ Mastering Excel Video Course
    www.innozant.c...
    ✅ Mastering Power BI Video Course
    www.innozant.c...
    ✅ Mastering VBA Video Course
    www.innozant.c...
    ✅ Mastering SQL Video Course
    www.innozant.c...
    Visit - innozant.com
    =====================================================
    ===========HYBRID CLASSES============================
    ✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
    ✅ Database Training(SQL , PL\SQL , Oracle Developer)
    ✅ Mastering Data Science
    Visit - innozant.com
    ====================================================
    Videos in a Sequence -Basic to Advanced EXCEL
    Basic Excel- • Basic Excel-The Learni...
    Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
    Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
    Excel What if Analysis- • Excel What if Analysis
    Excel Array and Sumproduct- • Excel Array & Sumprodu...
    Excel Lookup Functions- • Excel Lookup Functions...
    Excel Pivot Tables- • Excel Pivot Tables
    Excel Power Pivot- • Excel Power Pivot
    Excel Power Query- • Excel Power Query
    Excel Chart and Infographics- • Excel Chart and Infogr...
    Excel Dashboard & Reports- • Excel Dashboard & Reports
    Value add-ons Playlist
    ProQuest-Check Point- • Excel ProQuest-Check P...
    Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
    StudsTalk -The Journey begins- • StudsTalk-The Journey ...
    QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
    Excel Tips and Tricks- • Excel Tips & Tricks
    MIS Interview Cracker- • MIS Interview Cracker
    MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
    Excel Maharaj- • EXCEL MAHARAJ - For Ex...
    Microsoft Powerpoint- • Microsoft Powerpoint
    Microsoft Word- • Microsoft Word
    Office 365- • Office 365
    Google Sheets- • Google Sheets
    Microsoft Outlook- • Microsoft Outlook
    Power BI- • Power BI
    Excel VBA- • Excel VBA Macro
    TezXL Jata Shorts- • #shorts | जो TRIM के ब...
    Announcements- • Announcements
    Website - "www.innozant.com"
    Let's Connect:
    Instagram ► / innozantinfotech
    Facebook ► / innozantinfotech
    Telegram►t.me/innozanti...
    #googlesheets#googlesheetstutorial#innozant #googlesheetsfullcourse#googlesheetsfullcourse #removeblankrow #subtotal

КОМЕНТАРІ • 54

  • @sandeepaswal8944
    @sandeepaswal8944 2 роки тому +3

    Sir, I'm glad I got a teacher like you. You explained it so well as always. I've learned a lot from your video's. Thanks for sharing sir

  • @nandanravi594
    @nandanravi594 2 роки тому +1

    sir, aapke sundar vichar aur prena dene vale vichar ke liye bahut bahut shukriya.

    • @Innozant
      @Innozant  2 роки тому

      God bless you dear

  • @sunilparmar2808
    @sunilparmar2808 2 роки тому +1

    Subtotal function bahut kaam ka hai. Great sir

  • @muhammadsaqlain5162
    @muhammadsaqlain5162 2 роки тому +1

    Kya zaberdast tricks bataya sir ap nay very powerful tricks.

  • @Ashokyadav-hj4bi
    @Ashokyadav-hj4bi 2 роки тому +1

    Excel charts and infographics playlist is not uploaded video

  • @surendrarajput731
    @surendrarajput731 6 місяців тому

    Very Helpful Video Thanks

  • @mohammadilyas2240
    @mohammadilyas2240 2 роки тому

    Excellent زبردست U R great keep it up from PAKISTAN

  • @DilwaleChawlaJi
    @DilwaleChawlaJi 9 місяців тому

    Really awesome tutorials made by you and thanks a bunch Sir.

  • @surendrarajput731
    @surendrarajput731 6 місяців тому

    Excellent Sir ji Thanks

  • @createyour6681
    @createyour6681 2 роки тому +1

    Very great sir

  • @satishojha6240
    @satishojha6240 2 роки тому

    Thanku for the video sir 🙏🙏🙏. Good night

  • @RakeshSingh-qo5nd
    @RakeshSingh-qo5nd 2 роки тому

    Thank you sir

  • @arvindmevalaljaiswal7234
    @arvindmevalaljaiswal7234 2 роки тому

    जबरजस्त बहुत बहुत धन्यवाद🙏💕

  • @arjunspata1913
    @arjunspata1913 2 роки тому

    Jakkkaaaash sir 👍

  • @gauravbhatia7987
    @gauravbhatia7987 2 роки тому

    Thanq sir

  • @DBS-2030
    @DBS-2030 9 місяців тому

    Imp tips to work fastly

  • @vasimuddinsheikh3766
    @vasimuddinsheikh3766 2 роки тому

    Sir, I have completed you basic to advance tutorial, Now I need a job but don't know where and how to look for a MIS job?

  • @vijayjoshi1012
    @vijayjoshi1012 2 роки тому

    Sir time stamp and planned time and delay time ka bhi ek video dijiye

    • @Innozant
      @Innozant  2 роки тому

      Ok...noted ..milega time to jaroor bnayenge dear

  • @shiningstar9122
    @shiningstar9122 6 місяців тому

    Great 👌

  • @DilwaleChawlaJi
    @DilwaleChawlaJi Рік тому +1

    Sir in this video sum function is not calculating as per the number of employees. You were saying that based on counted employees the salary will be calculated but it is not happening. Please help us.

    • @Altaf_Alam
      @Altaf_Alam 4 місяці тому

      Use subtotal, not sum. Function... In subtotal the code of sum function is 9 😊

  • @mohitjaiswal4023
    @mohitjaiswal4023 2 роки тому

    Awesome sir... Keep it up... Google sheet series videos very useful for me ..and I got a more knowledge... by your videos concepts..sir 👍🙋🏻

    • @Innozant
      @Innozant  2 роки тому

      Thanks Mohit

    • @jeetpatel1872
      @jeetpatel1872 2 роки тому

      Great sir I am very happy to get your video it's very useful for me

  • @kishorpanara4191
    @kishorpanara4191 2 роки тому

    Awesome dear Sir thank you sir

  • @RahulKumar93555
    @RahulKumar93555 6 місяців тому

    Love you Sir

  • @nurulhaque89
    @nurulhaque89 2 роки тому

    Nice

  • @umairzahid3743
    @umairzahid3743 Рік тому

    Sir
    Subtotal formula salary per nhi laga Tha isi wajeh sy employee to change ho gye magar salary nhi hue thi

  • @shrikantbadge3978
    @shrikantbadge3978 2 роки тому

    Very helpful 🙏

  • @bhagwatsingh-pureancientkn8424

    sir normal sum will not work with filted data

  • @hsgusain2054
    @hsgusain2054 2 роки тому

    Thanks sir Ji

  • @Ann_2208
    @Ann_2208 2 роки тому

    G-Suite Query ki playlist or FMS PMS ki playlist nahi mil rahi hai please help me 🙏🏻

  • @merichitrakari
    @merichitrakari 6 місяців тому +1

    4:53 sir salary sum change nhi hua.

    • @Altaf_Alam
      @Altaf_Alam 4 місяці тому

      Kyuki sir by misktake function ka name sum likh diye... Waha per subtotal likhe jarur hoga 👍

  • @durgeshrai8938
    @durgeshrai8938 2 роки тому

    🙏🙏

  • @subrataghosh799
    @subrataghosh799 2 роки тому

    Subtotal bahat e kam ki function hai sir

  • @kunalsharma2661
    @kunalsharma2661 2 роки тому

    Sir humare office m "Open Office" use hota h becoz free h isiliye.
    Or m chahta hu power query ki practise krna.But humare boss ne microsoft excel download krne se mnaa kiya h
    To m aapse ye jaanna chahta hu ki aisi koi website yaa feature h, jisse ki m power query ki practice kr saku.

  • @arvindmevalaljaiswal7234
    @arvindmevalaljaiswal7234 2 роки тому

    Sar Excel Mein quotation banana bataiye jo ke PDF mein jakar save ho.

  • @balamira297
    @balamira297 2 роки тому

    First view!

    • @Innozant
      @Innozant  2 роки тому

      😊😊😊❤️❤️❤️ Thanks

  • @ravisahani104
    @ravisahani104 2 роки тому

    Sir mujhe advance Excel+VBA ka course karna hai how can I contact you

    • @Innozant
      @Innozant  2 роки тому +1

      Hi Ravi Kindly visit Innozant website for more details and you may contact/Whatsapp us for career counseling.(Contact no. Available in latest video intro or Innozant website)

  • @obaydullahalmahmudt
    @obaydullahalmahmudt 8 місяців тому

    Filtered sum doesn't changed!!!

  • @amanraj2105
    @amanraj2105 Рік тому

    Bhai apne salary ki cell code galat dali hai. Pehle bhi 962558 tha aur filtered data ke bad bhi 962558 hi hai...ap dekho lo ache se
    Wrong code/ =sum(9,selected range)
    Right code/ =subtotal(9,selected range)

    • @Innozant
      @Innozant  Рік тому

      Oh..may be by mistake video ke flow ma galat cell pick kar liya hoga

  • @usmanahmad7758
    @usmanahmad7758 5 місяців тому

    =sum(9,😂😂😂) never works