From the course: Microsoft Copilot for Excel

Unlock this course with a free trial

Join today to access over 25,200 courses taught by industry experts.

Summarizing data

Summarizing data

From the course: Microsoft Copilot for Excel

Start my 1-month free trial Buy for my team

Summarizing data

“

- [Instructor] Next up, we're going to use Copilot to help summarize our data, which means that we're going to start asking some real questions that are relevant to the HR department, so let's launch Copilot and start with something simple, so, "How much are we paying out in bonuses this year?" Send that across. Wait for Copilot to work its magic. I'm going to wait just for this first one here. It really is just summing a column, but it's taking quite a while, and it looks like it understood the wrong context, so it's summing the bonus, but where DateOfHire is 2023 or later, and that's because of the this year portion, but the DateOfHire has nothing to do with what we're asking here, so let's just say, "How much are we paying out in bonuses?" Know this year. Send that over, and again, all it really needs to do is sum... Where is it? This bonus column. All right, there we go, so the total payout in bonuses will be $659,448. Fair enough. Now, we could have just done this. Select the…

Contents