April 2026
Beginner
390 pages
9h 23m
English
Content preview from Learning Generative AI Tools for Excel
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 3. Speeding Up Common Operations with ChatGPT
Everyone has to deal with some tedious, time-consuming, and repetitive tasks. One of these for me is making the bed every morning, not only mine (and my husband’s) but also my children’s. You must do it for the decorum of the house, but it’s very dull, takes time, and is repetitive. To solve the problem, I could hire a housekeeper and ask them to arrange the beds for me. This is a bit like what ChatGPT does in the digital world. You can ask it to become your housekeeper and to carry out tedious and repetitive tasks for you. If there were a ChatGPT that could make beds, I would definitely buy it (of course, only at a reasonable cost).
Similarly, when you use Excel, you often have to deal with tedious, time-consuming, and repetitive tasks. You want to speed them up as much as possible. These include, for example, the creation of templates, filling tables with patterns defined as dates or progressive numbers, and even enriching a dataset with values external to the dataset. Well, ChatGPT can be your housekeeper.
In Chapter 2, you saw that ChatGPT can be a companion in your activities, an assistant, or a secretary—call it what you want. The idea is that ChatGPT assists you while you carry out your tasks. In this chapter, you will use ChatGPT in a new way: as a housekeeper, to carry out tedious, repetitive, and time-consuming tasks for you.
This chapter shows you how to use ChatGPT for:
-
Creating templates
-
Autofill
-
Data enrichment ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.