How to Use ChatGPT in Excel: 5 Practical AI Tricks
Working with Microsoft Excel often involves writing formulas, analysing spreadsheets and preparing sample data. These tasks can take time, especially when you are unfamiliar with Excel functions.
ChatGPT can make this process easier. By describing what you want to calculate in plain English or Hindi, you can ask ChatGPT to suggest suitable Excel formulas, explain how they work and generate datasets for practice.
In this ChatGPT in Excel Hindi tutorial, we demonstrate five practical AI tricks using sales data, product lookups and sample employee records.
The best part? You don’t need advanced programming knowledge to follow these examples.
Video duration: 14 minutes 13 seconds
Language: Hindi
Original YouTube publication: October 14, 2024
Presented by: EduTaxTuber
What You’ll Learn
- Generate Excel SUM formulas using ChatGPT.
- Calculate product-wise sales using SUMIF.
- Find maximum and minimum values using Excel formulas.
- Create lookup formulas with VLOOKUP.
- Generate realistic sample datasets for Excel practice.
1. Generate Excel SUM Formulas with ChatGPT
Imagine you have a spreadsheet containing product names, transaction dates and sales amounts. You need to calculate total sales but aren’t sure which formula to use.
Instead of searching through Excel documentation, you can ask ChatGPT.
Example prompt:
Write an Excel formula to calculate total sales from the amounts in cells D2. Explain the formula.
For this example, the formula is:
=SUM(D2:D8)
The SUM function adds all numeric values in the specified range.
In the video, we demonstrate how to copy spreadsheet data into ChatGPT, request a formula and paste the result into Microsoft Excel.
Practical use: Monthly sales reports, expense calculations, departmental budgets and financial summaries.
2. Calculate Product-Wise Sales with SUMIF
Sometimes, calculating total sales isn’t enough. You may need to know how much revenue came from a particular product.
For example, imagine your spreadsheet contains multiple products, including Samsung, and you want the total sales associated with Samsung.
Example prompt:
Write an Excel formula to calculate the total sales for Samsung. Product names are in C2 and sales amounts are in D2.
ChatGPT can suggest:
=SUMIF(C2:C8,"Samsung",D2:D8)
This formula checks the product column for Samsung and adds the corresponding sales amounts.
You can change the product name or use a cell reference to make the calculation more flexible.
Practical use: Product-wise revenue analysis, customer sales reports and departmental performance reviews.
3. Find Maximum and Minimum Values with ChatGPT
Suppose you want to identify the highest and lowest sales values in a dataset.
You can ask ChatGPT to generate both formulas.
Example prompt:
Write Excel formulas to find the highest and lowest sales amounts in D2.
For the highest value:
=MAX(D2:D8)
For the lowest value:
=MIN(D2:D8)
In the tutorial, we also demonstrate editing an existing ChatGPT prompt rather than writing the entire instruction again.
This is useful when you are performing several calculations on the same dataset.
Practical use: Finding highest sales, lowest expenses, maximum employee ratings or minimum transaction values.
4. Generate VLOOKUP Formulas Using ChatGPT
VLOOKUP is one of the most useful Excel functions for retrieving information from a table.
In the video, we demonstrate a product-price lookup using a Tesla car as the example.
Instead of hardcoding the product name, you can make the formula refer to an input cell.
Example prompt:
Write a VLOOKUP formula to find the price of a product entered in cell B13. Product names and prices are stored in C2. Use an exact match.
A suitable formula is:
=VLOOKUP(B13,C2:D8,2,FALSE)
Here:
B13contains the product you want to find.C2:D8is the lookup table.2returns the value from the second column.FALSErequests an exact match.
The product name must be located in the first column of the lookup range for this formula to work correctly.
Practical use: Product-price lists, employee databases, inventory records and customer information lookups.
5. Generate Excel Practice Data with ChatGPT
One common challenge for Excel beginners is finding suitable data for practice.
ChatGPT can generate fictional sample datasets based on your instructions.
In the tutorial, we create a sample employee dataset using fields such as:
- Serial number
- Date
- Employee name
- Designation
- Salary
- Mobile number
- Employee rating
Example prompt:
Create a fictional dataset of 20 employees for Excel practice. Include serial number, date, employee name, designation, monthly salary and performance rating. Present the data in a table that I can copy into Excel. Do not use real personal information.
You can also write prompts in Hindi.
For example:
मुझे Excel में प्रैक्टिस करने के लिए 20 प्रोडक्ट्स का सैंपल डेटा बनाकर दो, जिसमें Product Name, Rate, Quantity, Amount और Country शामिल हों।
Copy the generated dataset into Excel and use it to practise formulas, filtering, sorting and reporting.
Always review generated values and formulas before using them for real business decisions.
Bonus: Practise Excel Formulas Online
The video also demonstrates an online Excel practice exercise using the COUNTA function.
COUNTA counts non-empty cells within a selected range.
For example:
=COUNTA(A2:A10)
Unlike COUNT, which counts numeric values, COUNTA can count text, numbers and other non-empty entries.
For beginners who are just getting started, read our guide to opening Microsoft Excel using three easy methods.
You can also explore the EduTaxTuber AI Excel Formula Generator to experiment with formula generation and spreadsheet tasks.
Video Chapters
Jump directly to the part of the YouTube tutorial you want to watch:
- 00:00 – Introduction to ChatGPT and Excel
- 00:16 – Getting started with ChatGPT prompts
- 01:26 – Generate a total sales formula
- 03:07 – Calculate product-wise sales
- 04:45 – Maximum and minimum formulas
- 06:04 – VLOOKUP with ChatGPT
- 07:56 – Online Excel practice
- 10:41 – Generate practice datasets
Frequently Asked Questions
Can ChatGPT write Excel formulas?
Yes. ChatGPT can suggest formulas based on your description of a problem. However, you should verify the suggested formula, cell references and results before relying on them.
Can I use ChatGPT with Excel for free?
You can use available ChatGPT features to request Excel formulas and copy them into spreadsheets, subject to the service’s current access limits. The workflow demonstrated in this video does not require an Excel add-in.
Does ChatGPT work directly inside Microsoft Excel?
The tutorial demonstrates ChatGPT and Excel side by side, with formulas copied between them. It does not demonstrate a native or automatic ChatGPT integration inside Excel.
Can ChatGPT create sample Excel data?
Yes. You can request fictional employee records, product tables, sales transactions and many other datasets for learning and testing.
Is this tutorial suitable for beginners?
Yes. It covers basic prompts and introduces Excel formulas through practical examples. Basic familiarity with Microsoft Excel will help.
Final Thoughts
Learning Excel doesn’t have to mean memorising every formula.
ChatGPT can help you discover functions, generate practice data and understand how formulas work. However, knowing the underlying Excel concepts remains important.
Start with the examples in this tutorial, experiment with different prompts and verify the results in your own spreadsheet.
For more practical tutorials on Excel, finance and technology, visit the EduTaxTuber YouTube channel.
Editor’s note: This video was originally published in October 2024. The ChatGPT interface and available features may have changed since recording, although the Excel formula concepts remain applicable.
Disclaimer
This tutorial is intended for educational and informational purposes. Portions of the accompanying written content were prepared with AI assistance and editorial review. AI-generated formulas, datasets and explanations may contain errors. Readers should independently verify results before using them for financial, operational or professional decisions. EduTaxTuber and its contributors are not responsible for losses arising from reliance on unverified information or calculations, to the extent permitted by applicable law.
