Creating & Saving Workbooks

Excel 2019 (Windows)    |    Beginner
  • 15 Videos | 1h 3m 22s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
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. 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.

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
    FREE ACCESS
  • Locked
    4. 
    Saving your document
    4m 54s
    FREE ACCESS
  • Locked
    5. 
    Saving your document as a PDF
    4m 11s
    FREE ACCESS
  • Locked
    6. 
    Recovering unsaved documents
    4m 43s
    FREE ACCESS
  • Locked
    7. 
    Inserting headers & footers
    4m 15s
    FREE ACCESS
  • Locked
    8. 
    Setting your print area
    3m 51s
    FREE ACCESS
  • Locked
    9. 
    Adjusting your print page layout
    4m 2s
    FREE ACCESS
  • Locked
    10. 
    Printing your document
    5m 3s
    FREE ACCESS
  • Locked
    11. 
    Checking for compatibility issues
    4m 42s
    FREE ACCESS
  • Locked
    12. 
    Editing your document properties
    3m 38s
    FREE ACCESS
  • Locked
    13. 
    Checking for personal information in your document
    3m 5s
    FREE ACCESS
  • Locked
    14. 
    Creating an accessible document
    3m 46s
    FREE ACCESS
  • Locked
    15. 
    Protecting your document
    5m 21s
    FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Working with Excel Tables
Likes 351 Likes 351  
BOOK Essential Excel 2019: A Step-By-Step Guide, Second Edition
COURSE Using Basic Formulas
Likes 266 Likes 266  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Illustrating Documents
Likes 83 Likes 83  
COURSE Sorting & Filtering Data
Likes 96 Likes 96  
COURSE Sharing & Collaborating on a Document
Likes 76 Likes 76