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
Пікірлер
Hi, how would you get the formula to ignore empty cells? Also can this formula search for second most repeated item?
There is no link
Link has been updated.
THANK YOU SIR. FOR THE INFORMATION WHICH WE NEED♥
Hi Sir, transaction list box is not showing any results. Can you send me the link where I can download the latest file. Thanks
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
ESME CUSTOMER AUR DATE DONO KA CHECK KARNA HO TO KESE KAREGE
And how to ths steps? If you have multiple, or double header in your table?
Hi.. im from philippines.. what to do, in my Excel i Don't have "FILTER" Function , pls...help
Unfortunately, filter function is not available in old Excel versions, to use this, you should have lateat version.
Nice!
Thank you🙏
Please share practice file
Practice file is in video description
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
im clicking the link it taking me to another place , where i can down load
You can download from the website, there you have the practice workbooks listed.
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.💯👏♥️
Thanks for the tip!
Sir Can you provide mis executive interview questions
im way behind in excel knowledge...thanks for sharing!:) Note: couldnt find the link for the practice workbook
Link is there in description, you have to select more.. if its not visible
Link is there in description, you have to select more.. if its not visible
@@spreadsheet_power Thanks
good work bro, but cant find any worksheet in the description
quite clear to understand...faced no issues thanks
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
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
Workbooks download link is in the video description of each video
Good! where is the practice workbook file ? I'm unable to find out, plz help me to find out
it has been updated in description now.
it deletes other colors I have assigned to cells everytime I switch cells
A great work! Thanks a lot #Spreadsheet Power.
Thanks and welcome
GOOD One
Sir kindly make a video Sendkeys for onother program data entry please
That is awesome, Thanks!!!
Great yar
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.
Many thanks!
Thank you! 🙏
thank you so much!
Welcome 🙏
I'm having issues opening this on a Mac.
Please check if this method works kzread.info/dash/bejne/oG2Nlrdwj67eYso.html
Sir, project password??
unlock_im
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
@ilayaraja9169 this cant be done in this particular template, however this is possible by editing the code.
thank you very much could you plz send the coding
Please refer to this video kzread.info/dash/bejne/eaxnuZaoac-2kso.html
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.
I would like to discuss a project I'm working on. How do I contact you, the person who did the excel work?
Very informative tutorial. There is one question. The cost price / sale price may vary within a month. What to do?
Thanks. What insights can you gain from the CAGR calculation?
🎉great
I got it
Wondering what I did wrong I did the a.bat file but when I clicked on it, it didn’t create the folders
It should, please recheck if all steps are followed 🙏
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.
VERY NICE VIDEO. Thank you
Welcome
Thanks for sharing
My pleasure
Could a pivot table also be used ??
Sala angrej ke chodal
Link not available
Last Date Of Receipt Cleared Receipt date
Sir E smai Last Receipt date chhaiye
GOOD . FULLY INFORMATIVE . EASY WAY TO EXPLAIN .THANKS A LOT
GOOD JOB SIR .
Sir, please give Password for code
Fantastic! Amazing!!!!!!!!!!!!!!!!!!!!!!! 😇
Thank you
@@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...
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.
@@spreadsheet_power That is so generous of you! Appreciated! I am so eager to learn more about it🤞