ProfBurnett.com - Master a Skill / Learn for Life

ITI 494 Microsoft Word and Excel Foundations

Session 5 – Microsoft® Office Excel® 2019: Part 1

  • Lesson 5: Printing Workbooks
  • Lesson 6: Managing Workbooks

Session Outline

Lesson 5: Printing Workbooks

You put a lot of work into creating, populating, and formatting your workbook. Now you may need to print hard copies of your workbooks to share with your colleagues, supervisor, or organizational leaders. Your workbooks may contain multiple worksheets, each of which could contain thousands of data entries, formulas, and results. Instead of printing all of this indiscriminately, you will need to print only what is necessary to deliver critical information to your audience. Microsoft® Office Excel® 2019 has a wide variety of printing options that can save your document recipients from having to sift through mounds of irrelevant data

Lesson 6: Managing Workbooks

So far, you have largely worked within workbooks and worksheets to enter, view, analyze, format, and present your organizational data. But there's more to being proficient in Microsoft® Office Excel® 2019 than simply working within your workbooks. Managing the overall structure of your workbooks, manipulating how you view your workbooks, and knowing how to find the workbook you need, when you need it, are all critical tasks you'll need to perform from time to time. Understanding what functionality is available and knowing how to use it will ensure you're able to get the most out of the workbooks, worksheets, and data you've already worked so hard to create

Lesson Objectives

  • Preview and print a workbook.
  • Set up the page layout.
  • Configure headers and footers.
  • Manage worksheets.
  • Manage workbook and worksheet views.
  • Manage workbook properties

Class Presentation Files

Class Exercises

  1. Download zip file from Profburnett.com class website to the c: drive.
  2. Exercise Zip File
  3. Unzip file to c: drive
  4. Exercise files will be in new folder

Addtional Course Material

Microsoft Office Word 2019: Part 1

Microsoft Office Word 2019: Part 1
Access Key(s) for enrollment in the subscription: APU6DOP3RW
URL: https://lochoice.com

eBook - Microsoft Office Word 2019: Part 1 - Student Edition

eBook - Microsoft Office Word 2019: Part 1 - Instructor Edition


Microsoft® Office Excel® 2019: Part 1

Microsoft Office Excel 2019: Part 1
Access Key(s) for enrollment in the subscription: APICKTLZFH
URL: https://lochoice.com

eBook - Microsoft® Office Excel® 2019: Part 1 - Student Edition

eBook - Microsoft® Office Excel® 2019: Part 1 - Instructor Edition

Colleges and Universities