8 ай бұрын
Пікірлер
@akutagawasdefender 4 күн бұрын
THANK YOU SO MUCH I WAS STRUGGLING WITH THIS PORTION OF MY COMP. EXAM TYSM YOU SAVED ME!!! LOVE THE WAY YOU EXPLAIN CLEARLY!!
@skillsphere47 4 күн бұрын
Thank you so much 😊 for your kind words! I'm so glad my explanation helped you. Best of luck with your exam.
@akutagawasdefender 4 күн бұрын
@@skillsphere47 thank you!!! keep providing and i hope yuo reach your goals!! 💗💗
@dakshachopdekar3232 15 күн бұрын
Thanks
@monikapandey2917 Ай бұрын
Thanks bro you helped a lot
@skillsphere47 Ай бұрын
Glad you found it helpful! 😊
@PreetamI-x5p 2 ай бұрын
Thank you Sir, It would be helpful if you teach, what if we paid extra emi, or extra payments for some months.
@skillsphere47 2 ай бұрын
Thanks, All contents are free for everyone in my channel... you can share the topics, i will try to create video for same...
@aneeq7531 2 ай бұрын
Please make video to filter function and index and match same as sumifs
@skillsphere47 2 ай бұрын
Sure, will be uploaded soon..
@skillsphere47 Ай бұрын
@aneeq7531 Check out this video : kzbin.info/www/bejne/noHScniJrpdkgtksi=gYmhck4UUdjyN_ri (Filter Function)
@veryutils 5 ай бұрын
Thank you for your informative video! I recommend trying the VeryPDF PDF to Excel Converter. This Windows software automatically converts PDF files into Excel spreadsheets and allows you to combine multiple PDFs while maintaining formatting.
@MiracleManGaming 5 ай бұрын
Does this works on same datasheet or multi data sheet or different document?
@skillsphere47 5 ай бұрын
Yes, you can use in any datasheet.
@SportsHunterArea 5 ай бұрын
Create video on the click on item picture or object to add value or cost that item with total results. Like click on pizza picture 🍕 add value of pizza with total
@skillsphere47 5 ай бұрын
Sure, thanks for your kind suggestion, will upload the video soon.✌️
@SportsHunterArea 5 ай бұрын
@@skillsphere47 thanks 👍👍👍
@henrystevens3993 6 ай бұрын
Awesome
@FlyWithFrisbee 6 ай бұрын
Congratulations 🎉🎉
@ohayo4699 7 ай бұрын
Can u explain this @*\: in format cell i don't understand this step
@skillsphere47 7 ай бұрын
This is custom formatting to put collon sign ":" at the end of text and cell without typing it manually. In custom formatting there are different ways of expressing text, numbers.
@ewilcox3211 7 ай бұрын
Promo sm
@AmitSingh-ro3dm 7 ай бұрын
Unique video on KZbin . Thanks for providing such knowledgeable videos.
@DishuMittal05 8 ай бұрын
Very informative video 👏❤
@skillsphere47 8 ай бұрын
Thank You 😊
@precisionsoundworksstudio 8 ай бұрын
👏🏻👏🏻👏🏻👏🏻👏🏻
@precisionsoundworksstudio 8 ай бұрын
Nice. New Subby here!
@skillsphere47 8 ай бұрын
Thanks 😊
@AmitSingh-ro3dm 8 ай бұрын
Very nice video sir. Keep it up
@skillsphere47 8 ай бұрын
Thanks and welcome
@kevonmanuel 8 ай бұрын
Subscribed!....
@AmitSingh-ro3dm 8 ай бұрын
Thanks for your great effort
@skillsphere47 8 ай бұрын
Glad you enjoyed the video, thanks for the support!
@AmitSingh-ro3dm 8 ай бұрын
Very knowledgeable video sir
@Bharathmanju9241 8 ай бұрын
Thank you Sir, it's helpful for me
@juanmontero883 8 ай бұрын
IT DOESN'T WORK, DON'T LOSE YOUR TIME
@skillsphere47 8 ай бұрын
Hi, thanks for your comment, use excel 365 and follow all the steps. Thanks
@syedumairbukhari767 9 ай бұрын
Great job
@Dan_De_Man 11 ай бұрын
To show no data found, you need to remove ,"" from your formula
@Usmanghani063 11 ай бұрын
Please make video in zooming view so can be easily understand.... though video is very informative. thank you.
@skillsphere47 11 ай бұрын
Sure thanks, feedback appreciated
@mehtacomputer Жыл бұрын
Nicely explained. Keep it up 👍
@skillsphere47 11 ай бұрын
Thank you 🙏🏻
@amazon5665 Жыл бұрын
thanks a lot, I have a question, what if a pdf contains 200pages and while uploading on power query the pages are unsorted, how to fix it?
@skillsphere47 11 ай бұрын
Hi @amazon5665, Apologies for delay response, i was stuck in some work. Can you please share me screenshort of the the page where you are stuck. I will try to help you to resolve this, or soon i will come up with new video. Meanwhile you can follow below steps: 1. Load table from pdf (Data -> Get Data -> From File -> From PDF) 2. Select all the tables that you want to load. 3. Click on Transform Data 4. Go to Home Tab -> Append Queries -> Append Queries as New 5. Select "Three or more tables. 6. From: Available Tables Box - Add all the tables in sequence in Tables to Append Box and Click OK. A new table will be created Named "Append1" that will contain all the data from all selected tables in same order. If any other query, feel free to write. Thanks...😊
@amazon5665 11 ай бұрын
@@skillsphere47 gr8 I will share with u as soon as possible
@jerrydellasala7643 Жыл бұрын
Brilliant! Save an Excel File in Google Sheets. DOESN'T WORK! How about trying Web Excel or just share the file with any Cloud Share like OneDrive or Dropbox? 👎🏼🤬😠 Also, these functions have been out for months!
@singh3846 Жыл бұрын
Good bro
@skillsphere47 Жыл бұрын
Thanks bro
@rahuludhas4133 Жыл бұрын
Sir aap warehouse Management me Excel work related 1 Inventory management 2 Receiving and Dispatching 3 Order Tracking 4 Reporting 5 Data Analysis 6 Barcode and Label generation pe ek video banaiye jisme ye sari bat aajaye or hame kuch sikhne ko mile
@skillsphere47 Жыл бұрын
Thank you for suggesting, will create ASAP.👍
@surajit.worlds Жыл бұрын
thanks bro .😘😘😘😘😘😘 need this typ of more smart tips & tricks video adv level ,(cause there r so many tutorial for beginers )
@skillsphere47 11 ай бұрын
Thanks for the feedback, will come up with more advanced tutorial
@Veena135R Жыл бұрын
Happy Diwali🎉🎉