Hi Deb, super useful. I just got it for my Mac and I’m testing. Unfortunately not yet for the corporate Pc. Do you know if it can do VLOOKUP’s and other more complex searches? I’m working on an inventory management API project and we got some data cleansing issues and wondering if Copilot could help. Tnx
Do you know if CoPilot can audit a spreadsheet to see if there are any errors to the formulas, for example a sum of a column labeled total sales where the formula range doesn’t include all the cells in the column. I work on a lot of spreadsheets with multiple worksheets and I am always concerned that I grabbed the wrong cells by mistake.
What you've demonstrated is useful for beginners. I'm more interested in explanations of complex formulas, suggestions for formulas and remediation of formulas. I'd be keen to see examples of that...
The functionality is limited to table data at the moment. You can’t get it to generate formulas to copy and paste. You can only add formula columns. This will change as the product develops.
Great tutorial! Thanks! Imo, it really annoys me that -> by the time I define and enter the correct sentence + processing time -> until then I'll finish the task 3x times. But I can imagine that it could be very useful for those who rarely use Excel, or it would save some time in the case of a specific chart + provide insights. And after the further developments, its functionality will certainly be expanded.
Hello Deb, thanks for sharing your insights and once again it was a great video. As you mentioned we are in early stages and the added value of copilot in excel is not so big. Imagine when the time will come where copilot will compare 2 such tables and let’s say will create a year over year report by just asking for it…
I'm envious since I still don't have access to copilot. One thing... you should really just use voice commands instead. With the english language, it should really not be necessary to type anymore. :)
You have no idea how much i love your videos and teaching style :) Learned a lot! keep enlightening us
Thank you!
Great Deb. love your way :) thank you. شكرا
You're welcome :-)
Fantastic overview, thanks
Hi Deb, super useful. I just got it for my Mac and I’m testing. Unfortunately not yet for the corporate Pc. Do you know if it can do VLOOKUP’s and other more complex searches? I’m working on an inventory management API project and we got some data cleansing issues and wondering if Copilot could help. Tnx
Hi there. At the moment the functionality is limited. It can only work with table data and add formula columns. You can add a VLOOKUP column though!
Do you know if CoPilot can audit a spreadsheet to see if there are any errors to the formulas, for example a sum of a column labeled total sales where the formula range doesn’t include all the cells in the column. I work on a lot of spreadsheets with multiple worksheets and I am always concerned that I grabbed the wrong cells by mistake.
Very useful and insightful!
Thank you!
What you've demonstrated is useful for beginners. I'm more interested in explanations of complex formulas, suggestions for formulas and remediation of formulas. I'd be keen to see examples of that...
The functionality is limited to table data at the moment. You can’t get it to generate formulas to copy and paste. You can only add formula columns. This will change as the product develops.
Great tutorial! Thanks!
Imo, it really annoys me that -> by the time I define and enter the correct sentence + processing time -> until then I'll finish the task 3x times.
But I can imagine that it could be very useful for those who rarely use Excel, or it would save some time in the case of a specific chart + provide insights.
And after the further developments, its functionality will certainly be expanded.
Hello Deb, thanks for sharing your insights and once again it was a great video. As you mentioned we are in early stages and the added value of copilot in excel is not so big. Imagine when the time will come where copilot will compare 2 such tables and let’s say will create a year over year report by just asking for it…
Absolutely! Still in the early stages. I don’t think we are seeing the full potential yet!
Very helpful
Excellent!! :)
Debora, I found some of your courses about Access Online and I would like to know which platform you recommend for me to learn Access 2021
My access courses are on SimonSez IT and GoSkills.
I'm envious since I still don't have access to copilot. One thing... you should really just use voice commands instead. With the english language, it should really not be necessary to type anymore. :)
You can use voice commands. Note the microphone icon at the bottom of the prompt area :)