Пікірлер
@haziqmehboob1299
@haziqmehboob1299 7 күн бұрын
i was using the excel 2024 version ...and when i put image in the cell and after that i close it after saving ...and when i open is again the image is gone and they show me unknown msg why?...kindly give me the solution of this error
@SuperExcel.online
@SuperExcel.online 7 күн бұрын
Thanks for your question. To get to the bottom of the problem, we may need to have few rounds of back and forth communication. First of all, are you using the subscription based Microsoft 365 version of Excel? There is not really an official 2024 version of Excel in the non-subscription version of Excel. As far as I am aware, "picture in cell" feature is only available in MS 365 version of Excel starting from summer 2023, and rolling out gradually to MS 365 subscriber. Were you able to put the image "in" the cell in the first place (instead of "over" the cell)?
@Manel_Disney
@Manel_Disney 10 күн бұрын
Thank you for your sharing, but I can't download.
@SuperExcel.online
@SuperExcel.online 9 күн бұрын
Thanks for letting me know. I'm not sure what you encountered when trying to download, there are all kinds of causes. If you like, you can email me with more details, I'm willing to explore with you together to find out the cause. You can find my email on my website. We may need to go back and forth multiple times to investigate.
@amornratpetchwong5761
@amornratpetchwong5761 15 күн бұрын
Thank you for your sharing, this very helpful so much.
@user-zq3tn9st5k
@user-zq3tn9st5k 20 күн бұрын
Very helpful. I will try
@andyandrews2704
@andyandrews2704 29 күн бұрын
Thank you for the great video and the clear, simple explanation. Excellent work.
@SuperExcel.online
@SuperExcel.online Ай бұрын
I also did a similar demo of this for the Microsoft Copilot Learning Hub series, check it out here learn.microsoft.com/en-us/shows/copilot-learning-hub/revolutionize-your-budgeting-with-copilot-for-finance-in-excel
@brianivandertp
@brianivandertp Ай бұрын
Interesting. Thanks for sharing
@SuperExcel.online
@SuperExcel.online Ай бұрын
Thanks for watching!
@kenjirosarjonator1639
@kenjirosarjonator1639 2 ай бұрын
Thank you, and I apply to use for =XLOOKUP(IFERROR(H13*1,IFERROR(H13&"",H13)), lookup,return)
@SuperExcel.online
@SuperExcel.online 2 ай бұрын
@kenjirosarjonator1639, thanks for your comment. My first impression is that this approach seemed to handle both number and text too with the two IFERROR functions. When I actually looked into it, I realized it would not work for few different reasons. First of all, the second IFERROR function - IFERROR(H13&"",H13) would only return H13 value as text, regardless H13 cell is a number cell or text cell. When H13 cell combines with a blank text string, it will never turn out to be an error, so it always return H13&"". So, in this context, IFERROR(H13&"",H13) would be equivalent to H13&"". Secondly, if cell H13 contains numerical values, regardless the cell H13 being text or number, the formula IFERROR(H13*1,IFERROR(H13&"",H13)) will always return H13 cell value as number. When you multiply H13 with 1, either way, it return the value as number. It will only return the second IFERROR result (as text) when cell H13 contains text string values. In that case, the second IFERROR does not do anything as it is text in the first place. So, overall, this formula you mentioned will only lookup H13 as number if it contains numerical values; and will lookup H13 as text when it contains text string value. And it cannot lookup H13 as text if H13 contains only numerical values, while that value in the range you are looking within might be text value. I hope my explanation takes you deeper into the formulas world.
@sagarrainaa
@sagarrainaa 2 ай бұрын
explained in details, in a simpler way. ty so much
@SuperExcel.online
@SuperExcel.online 2 ай бұрын
I’m glad you liked it. Thank you🙏!
@adolfocorrea3569
@adolfocorrea3569 3 ай бұрын
How long will Microsoft maitain X64 and ARM versions of Windows before shifting completely to ARM? How would Excel, PowerBi change and other will change? We have seen apps as basic as Outlook lose A LOT of functionality just to be lighter.
@ClaudioDrews
@ClaudioDrews 3 ай бұрын
These new computers are for NPCs only.
@raymondjurado9203
@raymondjurado9203 3 ай бұрын
Good training. Better than Index(match(match))
@raymondjurado9203
@raymondjurado9203 3 ай бұрын
Good training.
@Hae3ro
@Hae3ro 3 ай бұрын
Good explanation and helpful
@SuperExcel.online
@SuperExcel.online 3 ай бұрын
Glad it was helpful! Thank you!
@gantest-vw2dd
@gantest-vw2dd 3 ай бұрын
Thanks
@gantest-vw2dd
@gantest-vw2dd 3 ай бұрын
Excellent!!!
@ganpot6429
@ganpot6429 3 ай бұрын
Thanks!
@ovuegrey-areben9234
@ovuegrey-areben9234 3 ай бұрын
That was very informative
@TAOWEIXIONG1980
@TAOWEIXIONG1980 3 ай бұрын
Super helpful. Thanks for sharing!
@SuperExcel.online
@SuperExcel.online 3 ай бұрын
Glad to know you found it helpful. Thank you, 🙏!
@guruware8612
@guruware8612 3 ай бұрын
"i'm sooo excited, blah blah, and more blah". People want to spend their life like an us-based company imagines life on this planet ? - what an utter nonsense. Who needs another annoying girlfriend besides the current annoying girlfriend ? Ask how late it is, how long does it take to get an actual answer ? Please help me how to use that parachute! AI: "Ahh, yes lest try, its soooo exciting to be here. How are you today ?" THUNK! AI: "Hello are you there, i found some informations on parachutes, do you want to hear it ? Hello, are you there ? Hello ?
@ganpot6429
@ganpot6429 3 ай бұрын
I really like how in this announcement Open AI is really committed to giving free access to AI for all users. Along with the introduction of APIs, who knows how fast AI tools will spread and grow!
@gontest
@gontest 3 ай бұрын
This breakthrough is crazy. In just a few months, we've made another huge leap towards becoming a sci-fi movie.
@biosecurePM
@biosecurePM 3 ай бұрын
Now imagine a BCI without implants in the brain haha, it seems to actually be possible.
@SuperExcel.online
@SuperExcel.online 3 ай бұрын
Totally!
@biosecurePM
@biosecurePM 3 ай бұрын
In the BCI stage in general you have of course the option of sending drug like experiences to humans for customized behaviour incentivization and demand control (VDLE = Virtual Drug-Like Experiences). Which if the real AI transmits ultra euphoria or cohesion or love via VDLE to the humans and perhaps with a back channel vice versa humans to the real AI, it would already be this "love" interface stage.
@SuperExcel.online
@SuperExcel.online 3 ай бұрын
Wow, eye opening! It never occurred to me thinking about sending VDLE from AI to human or human to AI. Now, when I think about some people's "downloading" experiences, it makes perfect sense.
@messertruckbecah3383
@messertruckbecah3383 3 ай бұрын
This solved my issue with XLOOKUP. Thank you so much!
@SuperExcel.online
@SuperExcel.online 3 ай бұрын
I’m glad this video helped you😄!
@tchadcarby8439
@tchadcarby8439 3 ай бұрын
Hello there! I was listening your video for the first time while driving and I felt this overwhelming weight lifted from my entire body. Am a independent researcher In AI and I have been thinking about how we can quickly use Ai and our collective knowledge and intelligence as a species to get the next stage and I 1000% believe that what you have communicated is the TRUTH! A framework of guidance and understanding will be created.
@SuperExcel.online
@SuperExcel.online 3 ай бұрын
I'm happy my thoughts resonated with you, and your research and intention are greatly appreciated. Keep up your great work!
@henryli5256
@henryli5256 4 ай бұрын
I really appreciate this daring and equally graceful prediction on the next stages of ai. During a time where content on ai is focused on how it might threaten humanity, the shifting of our attention back to themes of love and unity really shines bright.
@SuperExcel.online
@SuperExcel.online 4 ай бұрын
Where attention goes, energy flows. Thanks for your beautiful comment to bring our focus on light.
@lucasvieira3660
@lucasvieira3660 4 ай бұрын
I totally believe in this, and interestingly this is corroborated by many reports of contact with advanced extraterrestrial races, in books like those from Dolores Cannon. Take a look at the book by Suzy Hansen called "The Dual soul connection", she tells about her experiences in abductions where the extraterrestrial beings perfomed cognitive tests with this type of consciousness interface that you talked about. She precisely reports using feelings and intuition to operate their computers. Thanks for the video!
@SuperExcel.online
@SuperExcel.online 4 ай бұрын
You read my mind?! I actually read 18 of Dolores' 20 books. I took her level 1 and level 2 trainings as well. I did not come across Suzy Hansen's book until now you said it, I will definitely read "The Dual Soul Connection". Thank you for the recommendation!
@satyabratasatapathy2713
@satyabratasatapathy2713 4 ай бұрын
Glad i was recommended this video😊
@SuperExcel.online
@SuperExcel.online 4 ай бұрын
Happy that you were glad 😀!
@paulmartin4894
@paulmartin4894 4 ай бұрын
Very interesting and insightful analysis. I agree with your focus on love, and I see that interfacing with consciousness on the way. These technologies all work within the confines of this 3D reality, which is electrical in nature, as is the human brain. Love, however, in its pure form is consciousness itself, and
@SuperExcel.online
@SuperExcel.online 4 ай бұрын
Wow, very well said! I'd lover to hear more what you are going to say or write here...
@paulmartinlife
@paulmartinlife 4 ай бұрын
Very interesting and insightful analysis. I agree with your focus on love, and I see that interfacing with consciousness is on the way. These technologies all work within the confines of this 3D reality, which is electrical in nature, as is the human brain. Love, however, in its pure form is consciousness itself, and neither requires nor desires to interface with the inferior technology. It's the brain and the mind that will be consumed by the seeming magic of technology, theat merely imitates the divine.
@SuperExcel.online
@SuperExcel.online 4 ай бұрын
I love it! You expressed it beautifully - "love, neither requires, not desires..."!
@pauladepitan7516
@pauladepitan7516 4 ай бұрын
Great presentation. Thank you
@SuperExcel.online
@SuperExcel.online 4 ай бұрын
I’m glad you liked it. Thank you.
@user-rz1lk6ex8d
@user-rz1lk6ex8d 4 ай бұрын
Mate This is great new addition and your explanation was great. Thanks
@SuperExcel.online
@SuperExcel.online 4 ай бұрын
Thank you, I’m glad you liked it.
@carolfisher9557
@carolfisher9557 4 ай бұрын
WOW (-: awesome information, thanks for sharing!!
@SuperExcel.online
@SuperExcel.online 4 ай бұрын
My pleasure!
@Hae3ro
@Hae3ro 4 ай бұрын
Cool stuff
@yfsiah1939
@yfsiah1939 4 ай бұрын
didnt work at all! this feature is a waste of time.
@SuperExcel.online
@SuperExcel.online 4 ай бұрын
Mind to tell us more, so we know what didn’t work? It did work on my computer.
@catpolcatpol1234
@catpolcatpol1234 Ай бұрын
Try SumMatch Excel add-in
@amirgulzar3933
@amirgulzar3933 5 ай бұрын
Great,,, Its really magic,,,,thanks for sharing knowledge....
@erichuang8420
@erichuang8420 5 ай бұрын
wow, very informative video!
@Hae3ro
@Hae3ro 5 ай бұрын
It works, but it takes much longer than doing it yourself.
@SuperExcel.online
@SuperExcel.online 5 ай бұрын
Yes, for those formulas that we know how to write ourselves, it's much quicker to write it ourselves. For some more challenging circumstances, ChatGPT Data Analyst could easily come up with the required nested formulas, while we may struggle. And for some people who are basic or intermediate Excel users, then ChatGPT Data Analyst could be a lifesaver.
@zixinyang3982
@zixinyang3982 5 ай бұрын
Is there a way to check whether images are placed above/within cells? if all are placed above cells, is there a way to convert them all within cells? Thank you!
@noellackey104
@noellackey104 5 ай бұрын
Is there anything available to compile Profit and Loss and Ballance sheet?
@jankolb9079
@jankolb9079 5 ай бұрын
Can I upload the sample data somewhere?
@SuperExcel.online
@SuperExcel.online 5 ай бұрын
@jankolb9079, Do you mean to “download” the sample data used in the video? If that’s the case, you can use the link provided in the video description to download.
@Hae3ro
@Hae3ro 5 ай бұрын
At least one useful function in Copilot
@ThepExcel
@ThepExcel 6 ай бұрын
I face same issue. Still terrible result comparing to gpt4 in chatgpt
@youMEtubeUK
@youMEtubeUK 6 ай бұрын
Looks like a struggle session with copilot 😂
@natelawrence
@natelawrence 7 ай бұрын
Thank you for recording this video. I've been interested in CoPilot in Excel since they first announced it for Office, but from your test it seems like it will need more time to be helpful to me.
@lilyding217
@lilyding217 7 ай бұрын
为啥我Excel home没有copilot
@SuperExcel.online
@SuperExcel.online 7 ай бұрын
The reason that Copilot does not appear on your Excel application Home tab, is most likely you (your organization) have not purchased the subscription for Copilot. I have a video talking about in which countries Copilot is available, and what prerequisite subscription you need to have (depending on for individual or business), how to purchase, how to activate Copilot after purchase. Here is the link kzfaq.info/get/bejne/ec6phbNip92zpp8.html
@roldanduarteholguin7102
@roldanduarteholguin7102 7 ай бұрын
Export the Quantum, Chat GPT, Revit, Plant 3D, Civil 3D, Inventor, ENGI file of the Building or Refinery to Excel, prepare Budget 1 and export it to COBRA. Prepare Budget 2 and export it to Microsoft Project. Solve the problems of Overallocated Resources, Planning Problems, prepare the Budget 3 with which the construction of the Building or the Refinery is going to be quoted.
@roldanduarteholguin7102
@roldanduarteholguin7102 7 ай бұрын
We want to share with Companies, Universities and Governments 57 years of successful professional experience in several countries, in Oil and Gas, Petrochemical, Steel, Hydroelectric, Engineering and Construction Projects. Since 1981 we have been developing the Digital Twin, which is the most complete technological tool to optimize all types of Companies, Cities and Countries. kzfaq.info/get/bejne/m8eUlLSascWle2Q.html kzfaq.info/get/bejne/nL6co5eCscq7gac.html
@jennifersanta-og7fd
@jennifersanta-og7fd 7 ай бұрын
it was easy
@usernameyourass
@usernameyourass 7 ай бұрын
It’s basically just a beta product they charge 30 AUD a month.
@SuperExcel.online
@SuperExcel.online 7 ай бұрын
It's not useful in Excel yet. The $30 AUD a month also gives you Copilot in Word, PowerPoint, Outlook, OneNote, which are more beneficial, as outputs from those programs typically are not subject to strict objective right and wrong criteria.
@georgewashington3012
@georgewashington3012 7 ай бұрын
I haven’t tried Copilot for M365 yet, but Copilot in Edge and Copilot in Windows hallucinate way too frequently. Having to manually verify the responses usually completely negate any advantage the services provide. I’m not impressed. But yeah, one day it’ll be worthwhile. Currently, it’s essentially a paid beta product.
@SuperExcel.online
@SuperExcel.online 7 ай бұрын
That's very true. Copilot is at very early infant stage. While it's not reliable for factual information, it is very helpful for generating innovative ideas and perspectives that an individual may not have the creativity to come up with. Overall, it's really like a small baby - rich in imagination and unable to discern the boundaries between the realms of reality and dreams.