March 2025
Intermediate to advanced
928 pages
22h 31m
English
Content preview from Microsoft 365 Office All-in-One For Dummies, 3rd Edition
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 8
Automating Excel with Copilot
IN THIS CHAPTER
Maximizing Copilot’s usefulness
Using Copilot for analysis, formula building, and conditional formatting
Asking Copilot to sort, filter, and visualize your data
Google the phrase “Excel is hard” and you'll soon see that a distressing number of people agree with that sentiment. I've written many Excel books over the years, and it has always been my goal to move folks from the “Excel is hard” gulag to the “Excel is amazing!” summer camp. Perhaps you've read some or all of the previous seven chapters here in Book 3 and are feeling a little more positive about your relationship with Excel. If so, great! — my work here is done, at least as far as Excel goes.
But if Excel still presents a challenge to you, then there's one more trick that you can try to get on better terms with all this spreadsheet business. If you're fortunate enough to have a Microsoft Copilot license to go along with your Office 365 subscription, then you've got yourself a powerful AI-fueled partner to help you with a wide variety of Excel tasks. Whether it's creating formulas, extracting text, applying conditional formatting, looking up a value, or spotting ...
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.