Creating & Saving Workbooks in Excel 2019 for Windows

Excel 2019 (Windows)    |    Beginner
  • 15 videos | 1h 3m 22s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.4 of 855 users Rating 4.4 of 855 users (855)
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

  • 2m 57s
    The first step in putting together your spreadsheet is creating a new document. With Excel, you can quickly create a new workbook and start entering your data. You can also use Excel to open an existing workbook. FREE ACCESS
  • 4m
    Excel comes with a large library of spreadsheet templates. These are predefined, preformatted workbooks that can be used to get started on a project quickly. Rather than creating everything from scratch, you can download a template and insert your data. If you need to adjust the template that you have downloaded, you can, of course, make your own changes as well. FREE ACCESS
  • Locked
    3.  Managing your worksheets in Excel 2019 for Windows
    4m 54s
    Worksheets are used in Excel to manage different sets of data within a workbook. A single workbook can contain multiple worksheets, all of which can be modified and managed individually. If you want to get the most out of Excel, you are going to need to know how to navigate between your worksheets and how to modify their properties, such as their position, their name, and even their color. FREE ACCESS
  • Locked
    4.  Saving your document in Excel 2019 for Windows
    4m 54s
    Knowing how to save your Excel spreadsheets is essential to being able to work on your document over multiple sessions. When saving the document, you can specify the name of your file, where you'd like to store it and the Excel version that you'd like to save it in. FREE ACCESS
  • Locked
    5.  Saving your document as a PDF in Excel 2019 for Windows
    4m 11s
    A PDF can be opened and viewed by the majority of operating systems and devices -making it a great format for sharing your workbooks and worksheets. Before sharing your document, it is a good idea to adjust your spreadsheet's page layout. Once this is done, Excel can quickly convert your document to PDF. FREE ACCESS
  • Locked
    6.  Recovering unsaved documents in Excel 2019 for Windows
    4m 43s
    If your device crashes while you are working on a spreadsheet, there is always the possibility that any recent unsaved changes will be lost. However, Excel automatically saves documents that you are working on which you can browse through in case your 'lost' document has been automatically saved. FREE ACCESS
  • Locked
    7.  Inserting headers & footers in Excel 2019 for Windows
    4m 15s
    If you have additional information to insert in your spreadsheet - such as the document's author, the date it was printed, or its total number of pages - you may find the header and footer tools useful. Headers and footers are areas that are managed independently of any cells and which appear automatically at the top and bottom of every page in your document. They are therefore very useful for storing general information about the spreadsheet that you have open in Excel. FREE ACCESS
  • Locked
    8.  Setting your print area in Excel 2019 for Windows
    3m 51s
    Before printing your spreadsheet, it is a good idea to check how it is arranged on your page. Excel features a special view mode - Page Break Preview - which is very useful for visualizing the exact layout of your worksheet. There are also a number of other useful tools which you can use to adjust your worksheet's margins and print area. FREE ACCESS
  • Locked
    9.  Adjusting your print page layout in Excel 2019 for Windows
    4m 2s
    Before printing your document in Excel, you should check to make sure it is properly laid out. You can choose the paper format, the margin size, and orientation, and even which additional formatting elements are printed as well. FREE ACCESS
  • Locked
    10.  Printing your document in Excel 2019 for Windows
    5m 3s
    When it comes to printing your document, Excel gives you control over a large number of settings and variables. You can, for example, specify how many copies you want to print out, which pages you print, the orientation of your document, and even the paper format used by your printer. FREE ACCESS
  • Locked
    11.  Checking for compatibility issues in Excel 2019 for Windows
    4m 42s
  • Locked
    12.  Editing your document properties in Excel 2019 for Windows
    3m 38s
    Your Excel workbook contains document properties with additional information about your document. These properties, include the document author, modification dates, and a host of other categories. See how to edit your document properties, how to access this information and modify it. FREE ACCESS
  • Locked
    13.  Checking for personal information in your document in Excel 2019 for Windows
    3m 5s
    Before sharing your document with other users, it is a good idea to check for any personal or confidential information that might have been added. The Excel document inspector can find comments, data inserted into headers and footers as well as even hidden rows and columns. Once you have identified any elements that could be considered confidential or personal, Excel can help you to decide what to do with them. FREE ACCESS
  • Locked
    14.  Creating an accessible document in Excel 2019 for Windows
    3m 46s
    Individuals with sight difficulties often use specialized tools to identify tags and other structural information embedded in your document. Excel features a document scanner that can ensure that your spreadsheet is as accessible as possible for all users reading it. FREE ACCESS
  • Locked
    15.  Protecting your document in Excel 2019 for Windows
    5m 21s
    If you need to protect the data that you have inserted into your Excel workbook, you can use the protection settings. You can choose to protect individual worksheets and their data contents, prevent users from restructuring your workbook or locking your entire document with a password. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Rating 4.4 of 91 users Rating 4.4 of 91 users (91)
Rating 3.0 of 2 users Rating 3.0 of 2 users (2)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 616 users Rating 4.4 of 616 users (616)
Rating 4.5 of 1588 users Rating 4.5 of 1588 users (1588)
Rating 4.5 of 487 users Rating 4.5 of 487 users (487)