• Send Us A Tip
  • Calling all Tech Writers
  • Advertise
Monday, May 12, 2025
  • Login
  • Register
TechStory
  • News
  • Crypto
  • Gadgets
  • Memes
  • Gaming
  • Cars
  • AI
  • Startups
  • Markets
  • How to
No Result
View All Result
  • News
  • Crypto
  • Gadgets
  • Memes
  • Gaming
  • Cars
  • AI
  • Startups
  • Markets
  • How to
No Result
View All Result
TechStory
No Result
View All Result
Home Tech

9 Ways to use ChatGPT for boosting your Microsoft excel game

by Sneha Singh
February 1, 2023
in Tech
Reading Time: 4 mins read
0
ChatGPT
TwitterWhatsappLinkedin

The AI chatbot ChatGPT from OpenAI can converse with you and help with specific queries or tasks. Since ChatGPT is still in its early stages of development, it is free. Although this tool already has some fantastic capabilities, it is being further extended and improved throughout this early phase. Interestingly, with ChatGPT, people using excel can simplify their work. Let’s know more about how ChatGPT can become useful while working on Microsoft Excel.

You might also like

Apple’s 2027 ‘Product Renaissance’: What to Expect

Slate Auto’s $27,000 Electric Truck Aims to Redefine Affordable Mobility

Colorado Legalizes Kei Vehicles: A Big Win for Small Cars

9 cool ways to use ChatGPT in Microsoft Excel 

1.Sum

Most of us have to calculate the total of a column very frequently. For instance, if you have sales data up to this point, you should instantly know the entire amount in the column representing the sales value up to this point. You could see the complete sum immediately, or you could want it as a formula in a different cell. There are several ways to calculate the sum manually or use the insert function of Microsoft Excel. But let’s give it a try to ChatGPT this time. All you need to do is write a simple question on the ChatGPT asking you to calculate the total number of cells or numbers you want. The ChatGPT will provide you with the formal need, and you are all set with the calculation.

ChatGPT

ChatGPT

 

2.Calculating Profit or Loss

Whatever type of small business you operate, you should understand bookkeeping principles, including how to compute profit and loss in Excel. You will have a clearer idea of your next course of action if you know to monitor your company’s finances. However, Microsoft Excel provides you with the formula, but ChatGPT makes it easier. You can calculate the profit for your revenue just by adding the formula that ChatGPT provides you. 

ChatGPT

 

 

3.Left and Find

The LEFT function is one of the many useful ones that Microsoft Excel offers for working with text data. As its name implies, the method enables you to extract a predetermined amount of characters from a text string beginning on the left side. Excel LEFT, nevertheless, is considerably more versatile than it appears to be. You can ask ChatGPT to write the formula to find your desired character. With the provided formula, you can find your desired number or name from the huge data on Microsoft excel. This can help extract names from the data or the mail id provided in the sheet.

4. Unique Count with ChatGPT

By utilising the ChatGPT formula, get the total number of distinct values. The formula disregards text and zero values. This function returns a value equal to how often a particular value has appeared before for the first time. The Unique Count metric indicates a column’s number of distinct (unique) values. Not counting are empty values. The unique counts for columns A and B in the table below are two and three, respectively.

 

5. Macro

An action or collection of actions can be recorded, named, stored, and executed as often as necessary and whenever desired using an Excel macro. We can automate repetitive data manipulation and reporting processes that need to be done repeatedly by using macros. ChatGPT can make that easier for you. You can command ChatGPT to create the formula, and you are all set to go there.

6. Average Percentage 

If you have a column of data and wish to get the average per cent return for only positive values, leaving out the top two values in the series, then do so. Ask Chat GPT, and it will provide the equation. 

7. Index Match

Consider the situation where you have a list of office location numbers and need to know who works in each office. Given the size of the spreadsheet, you could assume that it is a difficult assignment. With a lookup function, it’s fairly simple to accomplish. But while using the ChatGPT, you can command it with the request, and it will provide you with the desired formula.

ChatGPT

8. Counting Number of Words with ChatGPT

Excel doesn’t offer a function that allows you to quickly count the words in a document (like Word does). But is it still feasible to learn the answer? Yes, it is possible with the help of ChatGPT. Type the questions, and ChatGPT will provide you with the formula to count the total number of words in the whole excel sheet.

ChatGPT

9. Data Validation

Data validation is a crucial Excel tool that aids in limiting or controlling user entries in particular cells. Users can customise the validation criteria to limit the kinds of data entered into the associated cells in an Excel sheet. For instance, we can require users to input numbers between 1 and 10, names or passwords with a maximum of 30 characters, enter a value from the specified list of permitted values, or do any combination of those as mentioned above. ChatGPT provides you with the formula for data validation that you can use.ChatGPT

 

Tags: ChatGPTMicrosoft ExcelOpenAI
Tweet54SendShare15
Previous Post

How to access Admirals club airport Lounges by American Airlines

Next Post

Australia discovers a lost radioactive capsule

Sneha Singh

Sneha is a skilled writer with a passion for uncovering the latest stories and breaking news. She has written for a variety of publications, covering topics ranging from politics and business to entertainment and sports.

Recommended For You

Apple’s 2027 ‘Product Renaissance’: What to Expect

by Sneha Singh
May 12, 2025
0
Apple's 2027 'Product Renaissance': What to Expect

Apple will shake up its product lineup with what Bloomberg's Mark Gurman terms a "product renaissance" beginning later in 2026 and running through 2027. Apple had been stacking...

Read more

Slate Auto’s $27,000 Electric Truck Aims to Redefine Affordable Mobility

by Samir Gautam
May 11, 2025
0
Slate Auto’s $27,000 Electric Truck Aims to Redefine Affordable Mobility

Slate Auto, a U.S.-based electric vehicle startup backed by Amazon, is set to shake up the EV market with a radical offering: a no-frills electric pickup truck priced...

Read more

Colorado Legalizes Kei Vehicles: A Big Win for Small Cars

by Samir Gautam
May 11, 2025
0
Colorado Legalizes Kei Vehicles: A Big Win for Small Cars

In a significant move for automotive enthusiasts and advocates of alternative transportation, Colorado Governor Jared Polis has signed HB25-1281 into law, officially legalizing kei vehicles on the state’s...

Read more
Next Post
Australia

Australia discovers a lost radioactive capsule

Please login to join discussion

Techstory

Tech and Business News from around the world. Follow along for latest in the world of Tech, AI, Crypto, EVs, Business Personalities and more.
reach us at [email protected]

Advertise With Us

Reach out at - [email protected]

BROWSE BY TAG

#Crypto #howto 2024 acquisition AI amazon Apple bitcoin Business China cryptocurrency e-commerce electric vehicles Elon Musk Ethereum facebook flipkart funding Gaming Google India Instagram Investment ios iPhone IPO Market Markets Meta Microsoft News NFT samsung Social Media SpaceX startup startups tech technology Tesla TikTok trend trending twitter US

© 2024 Techstory.in

No Result
View All Result
  • News
  • Crypto
  • Gadgets
  • Memes
  • Gaming
  • Cars
  • AI
  • Startups
  • Markets
  • How to

© 2024 Techstory.in

Welcome Back!

Login to your account below

Forgotten Password? Sign Up

Create New Account!

Fill the forms bellow to register

All fields are required. Log In

Retrieve your password

Please enter your username or email address to reset your password.

Log In
Are you sure want to unlock this post?
Unlock left : 0
Are you sure want to cancel subscription?