Spreadsheet Power

Spreadsheet Power

Welcome to Spreadsheet Power KZread channel!🙏

Are you ready to unlock the full potential of spreadsheets and take your data management and analysis skills to new heights? Look no further! On this channel, we're dedicated to providing you with in-depth tutorials, tips, and tricks that will transform you into a spreadsheet wizard.

Whether you're a beginner looking to learn the basics or an experienced user seeking advanced techniques, our videos cater to all skill levels. We cover a wide range of spreadsheet software, including Excel, Google Sheets, and more, ensuring you can excel in any platform.

Get ready to master functions, formulas, pivot tables, data visualization, macros, and much more. Our step-by-step guides and practical examples make even complex concepts easy to understand and implement.
Subscribe now and let's dive into the exciting journey of mastering spreadsheets.🙏






Regenerate response

Error Handling in XLOOKUP Function

Error Handling in XLOOKUP Function

VLOOKUP Approximate Match Function

VLOOKUP Approximate Match Function

Пікірлер

  • @davidtitz2346
    @davidtitz23462 сағат бұрын

    Hi, how would you get the formula to ignore empty cells? Also can this formula search for second most repeated item?

  • @DincerDogan-g1r
    @DincerDogan-g1r11 сағат бұрын

    There is no link

  • @spreadsheet_power
    @spreadsheet_power8 сағат бұрын

    Link has been updated.

  • @islammussa3860
    @islammussa3860Күн бұрын

    THANK YOU SIR. FOR THE INFORMATION WHICH WE NEED♥

  • @Yumi-ww9sv
    @Yumi-ww9sv2 күн бұрын

    Hi Sir, transaction list box is not showing any results. Can you send me the link where I can download the latest file. Thanks

  • @spreadsheet_power
    @spreadsheet_power2 күн бұрын

    One of the reason not getting transactions in list box is because of improper date range selection. If transactions is on back date, need to select back date in from and to date. File download link will appear at video end screen

  • @MahasiddhiVinayak
    @MahasiddhiVinayak2 күн бұрын

    ESME CUSTOMER AUR DATE DONO KA CHECK KARNA HO TO KESE KAREGE

  • @stemariemasong1255
    @stemariemasong12552 күн бұрын

    And how to ths steps? If you have multiple, or double header in your table?

  • @stemariemasong1255
    @stemariemasong12552 күн бұрын

    Hi.. im from philippines.. what to do, in my Excel i Don't have "FILTER" Function , pls...help

  • @spreadsheet_power
    @spreadsheet_powerКүн бұрын

    Unfortunately, filter function is not available in old Excel versions, to use this, you should have lateat version.

  • @kaelt75
    @kaelt752 күн бұрын

    Nice!

  • @spreadsheet_power
    @spreadsheet_power2 күн бұрын

    Thank you🙏

  • @srinivaspopuri162
    @srinivaspopuri1623 күн бұрын

    Please share practice file

  • @spreadsheet_power
    @spreadsheet_power3 күн бұрын

    Practice file is in video description

  • @MahasiddhiVinayak
    @MahasiddhiVinayak3 күн бұрын

    Hello Sir, Muje Es Sheet Me Total Outstading Ke Sath Me Muje Invoice Date Se 14 Days Ke Bad Me Hone Wale Payment Ka hi Formulla Chahiye baki Ka Nhi Chahiye For Example Mene Signal Customer Ki 5 alg Alg date Ki invoice Date Me Bill Kiya 01-06-2024,05-06-2024,06-06-2024,07-06-2024,09-06-2024 ab muje 14 days bad hi enka payment lena hai 1-06-2024 me 14 days ke bad 15-06-2024 ko kitna payment due hoga uska hi payment chaiye 05-06-2024 se 09-06-2024 tak ka payment show nhi hona chaiye aur jese hi 19-06-2024 hoti hai to muje 01-06-2024 aur 05-06-2024 ka payment show hona chahiye agar payment received huwa hai to wo payment less hona chahiye please help sir

  • @roopi101
    @roopi1013 күн бұрын

    im clicking the link it taking me to another place , where i can down load

  • @spreadsheet_power
    @spreadsheet_power3 күн бұрын

    You can download from the website, there you have the practice workbooks listed.

  • @benjiealvarez6229
    @benjiealvarez62294 күн бұрын

    thank you so much, its help me alot superb tutorial and its easy to follow your steps. by the way you can add in your video on how to put developer tab most of us doesn’t show that tab.💯👏♥️

  • @spreadsheet_power
    @spreadsheet_power4 күн бұрын

    Thanks for the tip!

  • @Abhisheksoni8738
    @Abhisheksoni87384 күн бұрын

    Sir Can you provide mis executive interview questions

  • @girishb7267
    @girishb72675 күн бұрын

    im way behind in excel knowledge...thanks for sharing!:) Note: couldnt find the link for the practice workbook

  • @spreadsheet_power
    @spreadsheet_power5 күн бұрын

    Link is there in description, you have to select more.. if its not visible

  • @spreadsheet_power
    @spreadsheet_power5 күн бұрын

    Link is there in description, you have to select more.. if its not visible

  • @bhavneshparikh8283
    @bhavneshparikh82835 күн бұрын

    @@spreadsheet_power Thanks

  • @girishb7267
    @girishb72675 күн бұрын

    good work bro, but cant find any worksheet in the description

  • @girishb7267
    @girishb72675 күн бұрын

    quite clear to understand...faced no issues thanks

  • @girishb7267
    @girishb72675 күн бұрын

    my 2nd video im watching of urs! again great work..very simple to understand! i just noticed u are recording this at 5:30am! U wake up really early bro! Thanks for sharing this 😊 its really appreciated

  • @girishb7267
    @girishb72675 күн бұрын

    Nice. This was helpful. I am learning excel and your videos as a great starter! Simple and easy to understand. 1 Request i have though, if u can provide the sample data u r using in ur videos in the description for download for us to practice it would be great! Thank u

  • @spreadsheet_power
    @spreadsheet_power5 күн бұрын

    Workbooks download link is in the video description of each video

  • @55-Fifty_Five
    @55-Fifty_Five7 күн бұрын

    Good! where is the practice workbook file ? I'm unable to find out, plz help me to find out

  • @spreadsheet_power
    @spreadsheet_power7 күн бұрын

    it has been updated in description now.

  • @MDSports-pt4js
    @MDSports-pt4js7 күн бұрын

    it deletes other colors I have assigned to cells everytime I switch cells

  • @daviddifodaysonambago3510
    @daviddifodaysonambago35108 күн бұрын

    A great work! Thanks a lot #Spreadsheet Power.

  • @spreadsheet_power
    @spreadsheet_power8 күн бұрын

    Thanks and welcome

  • @mathspuzzlesbrainquistive2288
    @mathspuzzlesbrainquistive22889 күн бұрын

    GOOD One

  • @shaharyarahmed6124
    @shaharyarahmed61249 күн бұрын

    Sir kindly make a video Sendkeys for onother program data entry please

  • @abhishek.paliya
    @abhishek.paliya10 күн бұрын

    That is awesome, Thanks!!!

  • @mmgaffoor
    @mmgaffoor11 күн бұрын

    Great yar

  • @Mikey-wg2xu
    @Mikey-wg2xu11 күн бұрын

    Well done sir. Very clearly and very precise without wasting time. A nice touch to compare with the manual mathematical method to help prove that that Excel function works as expected. Subscribed.

  • @spreadsheet_power
    @spreadsheet_power11 күн бұрын

    Many thanks!

  • @laurabarber6697
    @laurabarber669711 күн бұрын

    Thank you! 🙏

  • @princess_soluz
    @princess_soluz11 күн бұрын

    thank you so much!

  • @spreadsheet_power
    @spreadsheet_power11 күн бұрын

    Welcome 🙏

  • @davidm8046
    @davidm804611 күн бұрын

    I'm having issues opening this on a Mac.

  • @spreadsheet_power
    @spreadsheet_power11 күн бұрын

    Please check if this method works kzread.info/dash/bejne/oG2Nlrdwj67eYso.html

  • @ilayaraja9169
    @ilayaraja916910 күн бұрын

    Sir, project password??

  • @spreadsheet_power
    @spreadsheet_power10 күн бұрын

    unlock_im

  • @ilayaraja9169
    @ilayaraja916910 күн бұрын

    Thank u sir, can we add items directly to the sheet , instead of product master userform ... B caz I have more than 500 items in my book shop

  • @spreadsheet_power
    @spreadsheet_power10 күн бұрын

    @ilayaraja9169 this cant be done in this particular template, however this is possible by editing the code.

  • @tajer733
    @tajer73312 күн бұрын

    thank you very much could you plz send the coding

  • @spreadsheet_power
    @spreadsheet_power12 күн бұрын

    Please refer to this video kzread.info/dash/bejne/eaxnuZaoac-2kso.html

  • @rameshacharya6941
    @rameshacharya694112 күн бұрын

    Please make a video on the EOQ Model in Excel with the profit & Loss account and how to separate carrying and ordering costs from the given conventional P&L account.

  • @WarrenCecilBeard78
    @WarrenCecilBeard7812 күн бұрын

    I would like to discuss a project I'm working on. How do I contact you, the person who did the excel work?

  • @jayantade2911
    @jayantade291112 күн бұрын

    Very informative tutorial. There is one question. The cost price / sale price may vary within a month. What to do?

  • @fatemeazizi1863
    @fatemeazizi186313 күн бұрын

    Thanks. What insights can you gain from the CAGR calculation?

  • @bbiswas84
    @bbiswas8413 күн бұрын

    🎉great

  • @vincebatista120
    @vincebatista12013 күн бұрын

    I got it

  • @vincebatista120
    @vincebatista12013 күн бұрын

    Wondering what I did wrong I did the a.bat file but when I clicked on it, it didn’t create the folders

  • @spreadsheet_power
    @spreadsheet_power13 күн бұрын

    It should, please recheck if all steps are followed 🙏

  • @vincebatista120
    @vincebatista12013 күн бұрын

    I double checked everything and did it the same way. When I click the a.bat file, it looks like it’s trying to create the folders, but it doesn’t.

  • @AbhayKumar-qp4hy
    @AbhayKumar-qp4hy14 күн бұрын

    VERY NICE VIDEO. Thank you

  • @spreadsheet_power
    @spreadsheet_power14 күн бұрын

    Welcome

  • @bernadetagalea7118
    @bernadetagalea711814 күн бұрын

    Thanks for sharing

  • @spreadsheet_power
    @spreadsheet_power13 күн бұрын

    My pleasure

  • @bigmac703
    @bigmac70314 күн бұрын

    Could a pivot table also be used ??

  • @user-ru5tm2iv4d
    @user-ru5tm2iv4d15 күн бұрын

    Sala angrej ke chodal

  • @bhavneshparikh8283
    @bhavneshparikh828317 күн бұрын

    Link not available

  • @Manitambasta
    @Manitambasta17 күн бұрын

    Last Date Of Receipt Cleared Receipt date

  • @Manitambasta
    @Manitambasta17 күн бұрын

    Sir E smai Last Receipt date chhaiye

  • @TanveerAhmed-hv4gn
    @TanveerAhmed-hv4gn17 күн бұрын

    GOOD . FULLY INFORMATIVE . EASY WAY TO EXPLAIN .THANKS A LOT

  • @TanveerAhmed-hv4gn
    @TanveerAhmed-hv4gn17 күн бұрын

    GOOD JOB SIR .

  • @ilayaraja9169
    @ilayaraja916917 күн бұрын

    Sir, please give Password for code

  • @daviddifodaysonambago3510
    @daviddifodaysonambago351018 күн бұрын

    Fantastic! Amazing!!!!!!!!!!!!!!!!!!!!!!! 😇

  • @spreadsheet_power
    @spreadsheet_power18 күн бұрын

    Thank you

  • @daviddifodaysonambago3510
    @daviddifodaysonambago351018 күн бұрын

    @@spreadsheet_power Most welcome! I have one question, or I can say an idea: What if I wanted to link the visible table to an updatable table? e.g., I have a database that is updated frequently with new data but still I wanted to show it within the 10 rows range of my scrollable table. Any advice or hints please...

  • @spreadsheet_power
    @spreadsheet_power18 күн бұрын

    For this we have to use macro codes in VBA to dynamically control the maximum value in the scrollbar, i will upload a video tutorial on this few hours later.

  • @daviddifodaysonambago3510
    @daviddifodaysonambago351018 күн бұрын

    @@spreadsheet_power That is so generous of you! Appreciated! I am so eager to learn more about it🤞