From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 22,700 courses taught by industry experts.

Copy to a new workbook and save as a PDF

Copy to a new workbook and save as a PDF - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Copy to a new workbook and save as a PDF

“

- [Instructor] We've got our list of presenters and what day they're presenting on. We can see that Gunther is presenting on Thursday. What's needed now is to get this sheet in a workbook by itself. The person who wants this final result does not want to see this Wednesday and Thursday, and they don't want to see the formulas underneath either. So, we got to copy this sheet to a new workbook, get rid of the underlying formulas, then change the workbook theme to Ion. Then, save the workbook as a PDF called Final Presentations. You got that? All right. Pause the video, get that saved, come back, and I'll let you see how I do it. Okay, you're back. All right, I'm going to right-click, Move or Copy. I want to be sure to create copy and then, put it in a New Book. Okay. Here's our new workbook. We want it to be the Ion theme so go to Page Layout, Themes, Ion, all right? Get rid of the underlying formulas, so I'm…

Contents