【Excel版】Microsoft Copilot Pro使ってみたら…ヤバいことに気づいてしまった。。

わちょんのゆっくりIT

24 Jan 202414:55

Summary

TLDRThe video script discusses the user's experience with the newly released 'Copailot Pro', a premium version of the free 'Copailot' AI assistant with enhanced features like priority access to GPT4, AI-powered image generation, and integration with Microsoft 365. The reviewer finds the initial features less useful than expected, as basic functionalities like GPT4 and image generation are already available in the free version. The main appeal lies in the AI's ability to assist within the Microsoft 365 suite. However, the user faces limitations, such as the product being available only in English and for the web version of Excel, which may not be as widely used as the desktop version. The script also highlights the AI's inability to handle complex tasks beyond table data manipulation, leading to a somewhat underwhelming experience for someone seeking advanced assistance in Excel.

Takeaways

🚀 The video discusses the newly released 'Copailot Pro', a premium version of the free 'Copailot' AI assistant.
🆓 'Copailot Pro' is an enhanced version of the free 'Copailot' that offers priority access to GPT4 and GPT4 Turbo, along with AI-driven image generation.
💡 It is designed to function as an AI assistant within Microsoft 365 apps, providing support during tasks in the apps.
🔍 The user initially found 'Copailot Pro' more cumbersome to use compared to 'Chat GPT', which already offers GPT4 and image generation capabilities.
💻 'Copailot Pro' is currently only available for the web version of Microsoft Excel, not the desktop version, which may limit its utility for many users.
🌐 The functionality of 'Copailot Pro' is only accessible in English, which could be a barrier for non-English speakers.
📊 'Copailot Pro' is capable of creating graphs from table data, which can be a time-saving feature for certain tasks.
📝 However, 'Copailot Pro' can only process data in table format, which limits its applicability to more complex or unstructured data tasks.
🛠️ The user found that 'Copailot Pro' was not able to handle more complex analyses or modify existing graphs, requiring manual adjustments.
💰 The subscription cost for 'Copailot Pro' is considered high by the user, especially compared to a standard Microsoft 365 subscription.
📚 The user suggests that having a strong foundation in Excel will continue to be important, as AI like 'Copailot Pro' may not fully automate complex Excel tasks in the near future.

Q & A

What is Copilot Pro and what was the initial excitement around it?
-Copilot Pro is an enhanced version of the free CoPilot service, which was highly anticipated for its features such as priority access to GPT4 and GPT4 Turbo, AI-powered fast image generation, and the ability to use it as an AI assistant on Microsoft 365 apps.
How does CoPilot Pro differ from the free version of CoPilot?
-CoPilot Pro offers additional features over the free version, including priority access to advanced AI models like GPT4 and GPT4 Turbo, and AI capabilities for image generation and assistance within Microsoft 365 applications.
What was the reviewer's initial impression of CoPilot Pro's usability compared to Chat CoPilot?
-The reviewer found that the initial features of CoPilot Pro, such as GPT4 access and image generation, were already available and functionally similar in Chat CoPilot, leading to the conclusion that Chat CoPilot was more user-friendly.
What was the main feature the reviewer was looking forward to testing with CoPilot Pro?
-The reviewer was particularly interested in testing the support CoPilot Pro could provide during actual app usage, especially since they primarily work with Excel.
What was the reviewer's experience with setting up CoPilot Pro?
-The reviewer found the setup process to be straightforward until the payment was completed. However, they discovered that CoPilot Pro is only available for the web version of Excel, not the desktop version, which was a disappointment.
Why did the reviewer find CoPilot Pro's language limitation frustrating?
-The reviewer found it frustrating that CoPilot Pro's features are only available in English, which made it difficult for them to use since they are not proficient in English.
How did the reviewer feel about the discoverability of CoPilot Pro's features within Excel?
-The reviewer struggled to find the CoPilot Pro feature within Excel, noting that it took them several hours to locate the activation button, and they felt the feature could have been more prominently displayed.
What was the reviewer's opinion on the data handling capabilities of CoPilot Pro?
-The reviewer was disappointed to learn that CoPilot Pro only works with table-formatted data, which limited its utility for more complex or unstructured data tasks.
What were some of the features that the reviewer found underwhelming in CoPilot Pro?
-The reviewer found features like data graphing, emphasis, filtering, sorting, and formula creation to be underwhelming because they were either too basic or already easily achievable with manual Excel operations.
What was the reviewer's final verdict on CoPilot Pro's value for the price?
-The reviewer felt that the price for CoPilot Pro was high, especially considering its limitations and the fact that it only works with the web version of Excel and requires English proficiency.
What advice does the reviewer have for potential users of CoPilot Pro?
-The reviewer suggests that users should try CoPilot Pro, especially since there is a free period, but be prepared to cancel the subscription if it does not meet their needs or expectations.

Outlines

00:00

🤖 Introduction to CoPilot Pro

The speaker begins by introducing CoPilot Pro, a feature-rich version of the free CoPilot service. CoPilot Pro offers prioritized access to advanced AI models like GPT4 and GPT4 Turbo, along with AI-driven image generation and an AI assistant for Microsoft 365 apps. The speaker compares CoPilot Pro with Chat GPT Plus, noting that while the latter also provides access to GPT4 and image generation, it lacks the integrated AI assistant feature. The speaker expresses initial skepticism about the usability of CoPilot Pro, especially in comparison to Chat GPT Plus, and sets the stage for a hands-on evaluation of CoPilot Pro's capabilities.

05:01

🧐 First Impressions and Limitations of CoPilot Pro

The speaker shares their first impressions after trying out CoPilot Pro, focusing on its limitations. They note that CoPilot Pro is only available for the web version of Microsoft Excel, which is a significant drawback for users who rely on the desktop version. The speaker also mentions the language barrier, as CoPilot Pro currently only supports English, which could be a hurdle for non-English speakers. Despite these limitations, the speaker is intrigued by the potential support CoPilot Pro could offer during actual work and decides to test it out, keeping in mind their primary role of explaining Excel.

10:01

📊 CoPilot Pro's Capabilities and Shortcomings

The speaker delves into the specific capabilities and shortcomings of CoPilot Pro. They find that CoPilot Pro is limited to processing table-formatted data, which is a significant limitation for users who work with more complex or unstructured data. While CoPilot Pro can perform tasks such as generating graphs from table data, emphasizing data, filtering, and sorting, these are basic functionalities that can also be done manually and quickly. The speaker also points out that CoPilot Pro's ability to create complex formulas is quite basic, offering only simple examples like a multiplication series. They express disappointment with the lack of advanced features and the overall simplicity of the tasks CoPilot Pro can perform.

💰 Value and Practicality of CoPilot Pro

The speaker reflects on the value and practicality of CoPilot Pro, considering its high cost and current limitations. They compare the subscription price of CoPilot Pro to a standard Microsoft 365 subscription, noting that it is significantly more expensive. The speaker also discusses the ease of unsubscribing from the service, which is a positive aspect. However, they express concerns about the service's practicality, especially given its current limitations, such as the lack of support for the desktop version of Excel and the inability to process non-table data. The speaker concludes by suggesting that users should try CoPilot Pro for themselves and decide whether it is worth the investment, especially since it is free for a limited time.

Mindmap

Keywords

💡Copailot Pro

Copailot Pro is a feature-rich, enhanced version of the free Copailot service, which is a Microsoft 365 application. It offers prioritized access to advanced AI capabilities such as GPT4 and GPT4 Turbo, along with AI-driven image generation. The script discusses the user's experience with Copailot Pro, highlighting its features and comparing it with the free version. It is central to the video's theme as the main subject of the review.

💡GPT4 and GPT4 Turbo

GPT4 and GPT4 Turbo are advanced AI models mentioned in the script, which are part of the enhanced features available in Copailot Pro. These models likely refer to the next generation of AI language models, which are capable of more complex and nuanced understanding and generation of text. They are integral to the video's discussion on the capabilities of Copailot Pro.

💡AI Assistant

The AI Assistant is a feature of Microsoft 365 applications that can be utilized with Copailot Pro. It is designed to assist users in their tasks by providing AI-driven support and automation. The script discusses the user's expectations and actual experience with the AI Assistant functionality within the context of Excel and other Office applications.

💡Image Generation

Image Generation is an AI capability that allows for the creation of images based on text descriptions. In the script, it is mentioned as one of the features available in Copailot Pro. The user expresses their initial excitement about this feature but later notes its limitations in practical use within the context of the video.

💡Excel

Excel is a widely used spreadsheet program from Microsoft Office Suite. The script's main theme revolves around the user's experience with Copailot Pro in the context of using Excel. The user evaluates the utility of AI features for tasks such as data analysis, graph creation, and formula generation within Excel.

💡Web Version vs Desktop Version

The script discusses a limitation of Copailot Pro, which is only available for the web version of Excel, not the desktop version. This distinction is important as many companies still use the desktop version for practical work. The user expresses disappointment with this limitation, as it affects the applicability of Copailot Pro in real-world scenarios.

💡Language Barrier

The language barrier is a significant issue highlighted in the script. Copailot Pro's functionality is currently only available in English, which poses a challenge for users who are not proficient in English. The user had to switch their settings to English to use the service, which could be a barrier for non-English speakers.

💡Data Analysis

Data Analysis is a key aspect of the video where the user tests Copailot Pro's ability to handle and analyze data within Excel. The script mentions that Copailot Pro can perform certain tasks such as graph creation and data filtering, but only with table-formatted data, which limits its practical application in more complex or unstructured datasets.

💡Graph Creation

Graph Creation is a feature of Copailot Pro that allows users to visually represent data in Excel. The script describes the user's experience with this feature, noting that while it can create graphs quickly, the customization and control over these graphs are limited, requiring manual adjustments after creation.

💡Formula Creation

Formula Creation refers to the ability of Copailot Pro to generate formulas within Excel. The script indicates that this feature is quite basic, suggesting that it can only handle simple operations like multiplying two columns together. This simplicity might not meet the needs of users working with more complex data sets.

💡Predictive Text

Predictive Text is a feature that suggests words or phrases as a user types. In the script, the user mentions that while free input prompts often led to unsatisfactory responses, using predictive text to select phrases improved the interaction with Copailot Pro. This feature helps in navigating the limitations of the AI's current capabilities.

Highlights

Copailot Pro has been released and offers enhanced features over the free version of GPT.

Copailot Pro provides prioritized access to GPT4 and GPT4 Turbo, as well as AI-driven image generation.

It functions as an AI assistant within Microsoft 365 apps.

Chat GPT Plus also offers access to GPT4 and image generation, with a code interpreter for tasks like Excel and PowerPoint creation.

The speaker finds Chat GPT to be more user-friendly than the initial offerings of Copailot Pro.

Copailot Pro is currently only available for the web version of Excel, not the desktop version.

The speaker expresses disappointment that many companies still use the desktop version, making Copailot Pro less practical.

Copailot Pro's functionality is only available in English at the moment.

The speaker changed their settings to English to use Copailot Pro's features.

Finding the Copailot Pro activation button in Excel was time-consuming for the speaker.

Copailot Pro only works with data in table format.

The speaker was unable to get assistance with non-table data, which is common in real-world Excel use.

Copailot Pro can create graphs from table data, but with limited customization options.

The speaker found the graph creation to be one of the few useful features of Copailot Pro.

Copailot Pro's responses are limited to what is within the table and it cannot process or recognize graphs it creates.

The speaker suggests that understanding and engineering prompts are necessary to effectively use Copailot Pro.

Copailot Pro's limitations and the need for precise prompting make it stressful to use.

The speaker concludes that Excel's foundational skills will become more important as AI tools like Copailot Pro are developed.

The speaker recommends trying Copailot Pro, but suggests being prepared to cancel the subscription if it does not meet expectations.