课程: Excel Weekly Challenge

免费学习该课程！

今天就开通帐号，24,700 门业界名师课程任您挑！

Build a sentence with variable inputs

Build a sentence with variable inputs - Microsoft Excel教程

课程: Excel Weekly Challenge

开始一个月试用 购买团队方案

Build a sentence with variable inputs

“

- [Instructor] It's time to send out completion letters. And we need a statement so that we can do a mail merge or wherever we need to send this data. The statement needs to be in this format. On the completion date, the member completed the course. For the first entry, it should say on 9 September '21, Liliane Boothe completed Stick Wielding for Home Defense. Now, watch out, she's certified now. You do not want to break into her house. You're going to be in trouble. All right? Got to make that statement, and then add a pivot table to get a count of each course, and then sort that count descending. Got that? And this is a little bit tricky but you can handle it. Pause the video, hook it up, come on back and I will show you what's what. (upbeat music) Here we go. The first thing, put this data into a table. Cursor is in the dataset. Format as table. Grab the black color. Table has headers, OK. And…

内容