How to Use Wps AI/Chatgpt to Data Analysis: Guide for Beginners

August 2, 2023 749 views

In the vast realm of data, Excel shines as a powerful ally—a tool to conquer complexity with ease. But a question remains: How can we unleash its full potential effortlessly? Enter Excel AI—the gateway to seamless data analysis, freeing us from complexity's grasp and unlocking endless possibilities. Join this transformative journey as Excel AI redefines your data analysis experience, revealing new horizons of discovery.

Part 1: How to Use WPS AI to Data Analysis

WPS AI, an intelligent assistant for office scenarios, leveraging cutting-edge artificial intelligence technology. Similar to ChatGPT, WPS AI enhances productivity across various office applications, enabling seamless document editing, form processing, and presentation creation. Its remarkable text generation capabilities simplify content creation, summarization, and translation tasks with ease.


Step 1 Uploaded data

Upload your data, which will be safely saved.

Step 2 Pose questions

To get insights and make visualizations, ask questions about your data.

Step 3 Obtain outcomes

Based on your selection, you will receive a response in the form of a table or data visualization.

Advantages of WPS AI for Data Analysis:

  • User-Friendly Interface: WPS AI offers an intuitive interface, making data analysis accessible to all users.

  • AI-Driven Insights: With AI-powered recommendations, WPS AI helps you uncover valuable insights faster.

  • Seamless Integration: WPS AI seamlessly integrates with various office applications, streamlining your workflow.

  • Time-Saving Automation: Automate repetitive data analysis tasks, saving time and effort.

  • Versatile Text Generation: WPS AI's powerful text generation capabilities support diverse content creation needs.

How to Download WPS AI

Step 1: Launch your browser and go to WPS AI.

Step 2: Log in to your WPS account, fill up the necessary information, and wait for an email invitation.

Step 3: After approval, WPS AI will send clients an email with instructions on how to download and install WPS AI on their systems.

  • Consider joining the WPS AI Discord community to communicate with other beta testers, exchange observations, and seek assistance if necessary.

Step 4: After approval, WPS AI will send clients an email with instructions on how to download and install WPS AI on their systems.

WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
Algirdas Jasaitis

Part 2: How to Use ChatGpt to Data Analysis

Step 1: Prepare your data.

The first step is to prepare your data in a format that ChatGPT can understand. ChatGPT can be used to analyze a variety of data formats, including CSV files, Excel spreadsheets, and JSON files.

Step 2: Formulate your questions.

Formulate your questions

Once your data is uploaded, you can start to formulate your questions to ChatGPT. Be as specific as possible when formulating your questions.

Step 3: Automating the Process:


Step 4: Iterate

You may need to iterate through steps 2-4 multiple times to get the information you need. For example, you may need to ask ChatGPT more specific questions to get the answers you are looking for.

ChatGpt Prompts

  • Data Cleaning: ChatGPT assists in identifying and rectifying data errors, ensuring accurate and reliable analysis.

  • Data Exploration: Discover hidden patterns and insights as ChatGPT helps you explore your data comprehensively.

  • Data Analysis: Analyze your data effectively with ChatGPT's support, spotting trends, anomalies, and relationships between variables.

  • Data Visualization: Create intuitive data visualizations using ChatGPT, simplifying data comprehension and insights sharing.

  • Data Forecasting: Utilize ChatGPT to forecast future trends and make data-driven predictions with confidence.

Part 3: Take a Closer Look at Excel AI

Excel, a long-standing powerhouse for data manipulation and analysis, has evolved remarkably with advancing technology. Embracing artificial intelligence (AI) capabilities, it now empowers users to conduct complex data analysis and gain insights with newfound efficiency.

Benefit of AI Tool

  • Efficiency: AI automates repetitive tasks, saving time and effort in data processing, cleansing, and transformation.

  • Advanced Analytics: AI enables predictive modeling, trend analysis, and anomaly detection, unlocking deeper insights from data.

  • Data Visualization: AI-driven charts and graphs offer dynamic visual representations, facilitating better comprehension of complex data.

  • Personalization: AI tailors analysis based on user preferences, optimizing recommendations and insights for individual needs.

Some AI Tools

  • Formula Generator: Formula Generator is an Excel add-in that uses AI to help you create and debug formulas. It can help you find the right formula for your data, and it can also help you troubleshoot formulas that are not working correctly.

  • Sheet+: Sheet+ is a cloud-based formula generator that can be used with Excel or Google Sheets.

  • WPS AI: WPS AI is a suite of AI-powered tools that help users with data analysis and visualization. It includes tools for data cleaning, data exploration, data visualization, and data forecasting.


What Should I Do If I Get a Code Error?

If you encounter a code error running locally, simply mention it in the follow-up prompt. ChatGPT learns from mistakes and provides a better solution.

Do I Need Programming Skills to Use AI for Data Analysis in Excel?

No, programming skills are not necessary. AI integration in Excel offers a user-friendly experience with intuitive interfaces and pre-built functions.

How Can AI Help in Detecting Anomalies or Fraud in Data?

AI excels at detecting anomalies and fraud by analyzing historical data, identifying deviations from normal patterns, and proactively flagging suspicious activities for fraud prevention.


This article is a beginner's guide on using WPS AI and ChatGPT for data analysis in Excel. It highlights Excel's power in handling complex data and introduces Excel AI as the gateway to seamless data analysis, freeing users from complexity and unlocking new possibilities. The guide covers how to download WPS AI, use ChatGPT prompts, and explores AI's role in detecting anomalies and fraud in data.

Throughout the article, WPS AI takes center stage as a vital tool for data analysis. It's portrayed as user-friendly and powerful, complementing Excel's capabilities. From downloading WPS AI to using ChatGPT prompts, its integration into Excel is showcased as the key to effortlessly unlock AI's potential, empowering users with robust data analysis tools without needing extensive programming skills.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.