5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Certification     Microsoft     Microsoft Office Specialist: Expert (Office 365 and Office 2019)     MO-201: Microsoft Excel Expert (Excel and Excel 2019)

Create a new spreadsheet and workbook, with Excel 2019. During this course, you will begin by learning how to create and open a document, and then learn how to use document templates. This leads into how to manage worksheets, which are used in Excel to manage different sets of data within a workbook. Next, observe how to save your worksheet or workbook as an Excel version or pdf; and recover unsaved documents. Learn how to insert headers and footers, useful if you have additional information to insert into a spreadsheet. Examine how to set your print area; adjust your print page layout, and then print your document. Discover how to check for compatibility issues; edit your document properties; and check for personal information in your document. The course concludes by showing how to create an accessible document, and how to protect your document or restrict all access with a password.


In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Creating & Saving Workbooks Exercise as well as the associated materials in the Resources section.



Objectives

Excel 2019 for Windows: Creating & Saving Workbooks

  • create and open a spreadsheet in Excel 2019
  • use Excel 2019 spreadsheet templates
  • manage your Excel 2019 worksheets
  • save your spreadsheet in Excel 2019
  • save your spreadsheet as a PDF in Excel 2019
  • recover unsaved spreadsheets in Excel 2019
  • insert headers and footers in your Excel 2019 spreadsheet
  • set your print area in Excel 2019
  • adjust your Excel 2019 print page layout
  • print your Excel 2019 spreadsheet
  • check for compatibility issues in Excel 2019
  • edit your Excel 2019 document properties
  • check for personal information in Excel 2019
  • create an accessible spreadsheet in Excel 2019
  • protect your Excel 2019 workbook
  • Knowledge Check: Creating & Saving Workbooks