Creating & Saving Workbooks

Excel 2019 (Windows)    |    Beginner
  • 15 Videos | 1h 25m 52s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 172 Likes 172
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Creating & opening a document
    2m 57s
    UP NEXT
  • Playable
    2. 
    Using document templates
    4m
  • Locked
    3. 
    Managing your worksheets
    4m 54s
  • Locked
    4. 
    Saving your document
    4m 54s
  • Locked
    5. 
    Saving your document as a PDF
    4m 11s
  • Locked
    6. 
    Recovering unsaved documents
    4m 43s
  • Locked
    7. 
    Inserting headers & footers
    4m 15s
  • Locked
    8. 
    Setting your print area
    3m 51s
  • Locked
    9. 
    Adjusting your print page layout
    4m 2s
  • Locked
    10. 
    Printing your document
    5m 3s
  • Locked
    11. 
    Checking for compatibility issues
    4m 42s
  • Locked
    12. 
    Editing your document properties
    3m 38s
  • Locked
    13. 
    Checking for personal information in your document
    3m 5s
  • Locked
    14. 
    Creating an accessible document
    3m 46s
  • Locked
    15. 
    Protecting your document
    5m 21s