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.online7 күн бұрын
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_Disney10 күн бұрын
Thank you for your sharing, but I can't download.
@SuperExcel.online9 күн бұрын
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.
@amornratpetchwong576115 күн бұрын
Thank you for your sharing, this very helpful so much.
@user-zq3tn9st5k20 күн бұрын
Very helpful. I will try
@andyandrews270429 күн бұрын
Thank you for the great video and the clear, simple explanation. Excellent work.
@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Ай бұрын
Interesting. Thanks for sharing
@SuperExcel.onlineАй бұрын
Thanks for watching!
@kenjirosarjonator16392 ай бұрын
Thank you, and I apply to use for =XLOOKUP(IFERROR(H13*1,IFERROR(H13&"",H13)), lookup,return)
@SuperExcel.online2 ай бұрын
@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.
@sagarrainaa2 ай бұрын
explained in details, in a simpler way. ty so much
@SuperExcel.online2 ай бұрын
I’m glad you liked it. Thank you🙏!
@adolfocorrea35693 ай бұрын
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.
@ClaudioDrews3 ай бұрын
These new computers are for NPCs only.
@raymondjurado92033 ай бұрын
Good training. Better than Index(match(match))
@raymondjurado92033 ай бұрын
Good training.
@Hae3ro3 ай бұрын
Good explanation and helpful
@SuperExcel.online3 ай бұрын
Glad it was helpful! Thank you!
@gantest-vw2dd3 ай бұрын
Thanks
@gantest-vw2dd3 ай бұрын
Excellent!!!
@ganpot64293 ай бұрын
Thanks!
@ovuegrey-areben92343 ай бұрын
That was very informative
@TAOWEIXIONG19803 ай бұрын
Super helpful. Thanks for sharing!
@SuperExcel.online3 ай бұрын
Glad to know you found it helpful. Thank you, 🙏!
@guruware86123 ай бұрын
"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 ?
@ganpot64293 ай бұрын
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!
@gontest3 ай бұрын
This breakthrough is crazy. In just a few months, we've made another huge leap towards becoming a sci-fi movie.
@biosecurePM3 ай бұрын
Now imagine a BCI without implants in the brain haha, it seems to actually be possible.
@SuperExcel.online3 ай бұрын
Totally!
@biosecurePM3 ай бұрын
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.online3 ай бұрын
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.
@messertruckbecah33833 ай бұрын
This solved my issue with XLOOKUP. Thank you so much!
@SuperExcel.online3 ай бұрын
I’m glad this video helped you😄!
@tchadcarby84393 ай бұрын
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.online3 ай бұрын
I'm happy my thoughts resonated with you, and your research and intention are greatly appreciated. Keep up your great work!
@henryli52564 ай бұрын
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.online4 ай бұрын
Where attention goes, energy flows. Thanks for your beautiful comment to bring our focus on light.
@lucasvieira36604 ай бұрын
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.online4 ай бұрын
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!
@satyabratasatapathy27134 ай бұрын
Glad i was recommended this video😊
@SuperExcel.online4 ай бұрын
Happy that you were glad 😀!
@paulmartin48944 ай бұрын
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.online4 ай бұрын
Wow, very well said! I'd lover to hear more what you are going to say or write here...
@paulmartinlife4 ай бұрын
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.online4 ай бұрын
I love it! You expressed it beautifully - "love, neither requires, not desires..."!
@pauladepitan75164 ай бұрын
Great presentation. Thank you
@SuperExcel.online4 ай бұрын
I’m glad you liked it. Thank you.
@user-rz1lk6ex8d4 ай бұрын
Mate This is great new addition and your explanation was great. Thanks
@SuperExcel.online4 ай бұрын
Thank you, I’m glad you liked it.
@carolfisher95574 ай бұрын
WOW (-: awesome information, thanks for sharing!!
@SuperExcel.online4 ай бұрын
My pleasure!
@Hae3ro4 ай бұрын
Cool stuff
@yfsiah19394 ай бұрын
didnt work at all! this feature is a waste of time.
@SuperExcel.online4 ай бұрын
Mind to tell us more, so we know what didn’t work? It did work on my computer.
@catpolcatpol1234Ай бұрын
Try SumMatch Excel add-in
@amirgulzar39335 ай бұрын
Great,,, Its really magic,,,,thanks for sharing knowledge....
@erichuang84205 ай бұрын
wow, very informative video!
@Hae3ro5 ай бұрын
It works, but it takes much longer than doing it yourself.
@SuperExcel.online5 ай бұрын
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.
@zixinyang39825 ай бұрын
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!
@noellackey1045 ай бұрын
Is there anything available to compile Profit and Loss and Ballance sheet?
@jankolb90795 ай бұрын
Can I upload the sample data somewhere?
@SuperExcel.online5 ай бұрын
@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.
@Hae3ro5 ай бұрын
At least one useful function in Copilot
@ThepExcel6 ай бұрын
I face same issue. Still terrible result comparing to gpt4 in chatgpt
@youMEtubeUK6 ай бұрын
Looks like a struggle session with copilot 😂
@natelawrence7 ай бұрын
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.
@lilyding2177 ай бұрын
为啥我Excel home没有copilot
@SuperExcel.online7 ай бұрын
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
@roldanduarteholguin71027 ай бұрын
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.
@roldanduarteholguin71027 ай бұрын
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-og7fd7 ай бұрын
it was easy
@usernameyourass7 ай бұрын
It’s basically just a beta product they charge 30 AUD a month.
@SuperExcel.online7 ай бұрын
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.
@georgewashington30127 ай бұрын
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.online7 ай бұрын
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.