Creating, Saving, & Exporting Workbooks in Excel 2013 for Windows

Excel 2013 (Windows)    |    Beginner
  • 15 videos | 1h 27m 33s
  • Earns a Badge
Likes 45 Likes 45
Learn the basics of working with Excel 2013, including creating workbooks, using templates, saving, adding headers and footers, adjusting print options and printing, editing workbook properties, and protecting a workbook.

WHAT YOU WILL LEARN

  • Creating & opening a document
    Using document templates
    Managing your worksheets
    Saving your document
    Saving your document as a PDF
    Returning to a previous version of your document
    Inserting headers & footers
    Adjusting your print page layout
  • Adjusting your print options
    Printing your document
    Checking for compatibility issues
    Editing your document properties
    Checking for personal information in your document
    Creating an accessible document
    Protecting your document

IN THIS COURSE

  • 6m 11s
    Before getting to grips with Excel 2013, you are going to need to know how to create a new spreadsheet document (called workbooks) and how to open existing documents. Excel 2013 can also help you to quickly find the documents you work on frequently by storing shortcuts to recently accessed documents. FREE ACCESS
  • 5m 31s
    Excel 2013 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 2013 for Windows
    6m 54s
    Worksheets are used in Excel 2013 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 2013, 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 2013 for Windows
    6m 42s
    Saving your Excel 2013 spreadsheets is an essential skill that allows you to work on your document over multiple sessions. You can specify the name of your file, where it is stored and the format it is stored in. Excel 2013 supports a large number of different file formats. FREE ACCESS
  • Locked
    5.  Saving your document as a PDF in Excel 2013 for Windows
    5m 15s
    A PDF can be opened and viewed by the vast majority of operating systems and devices. It is therefore a very good 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 2013 can quickly convert your document to PDF. FREE ACCESS
  • Locked
    6.  Returning to a previous version of your document in Excel 2013 for Windows
    4m 23s
    If your device crashes while you are working on a spreadsheet, there is always the possibility that any recent unsaved changes you have made will be lost. You should know however that Excel 2013 performs regular backup operations on documents that you are working on. It is therefore a good idea to know how to browse through these backup copies in case your 'lost' document has been saved automatically. FREE ACCESS
  • Locked
    7.  Inserting headers & footers in Excel 2013 for Windows
    6m 58s
    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 2013. FREE ACCESS
  • Locked
    8.  Adjusting your print page layout in Excel 2013 for Windows
    5m 11s
    Before printing your spreadsheet, it is a good idea to check how it is arranged on your page. Excel 2013 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 options in Excel 2013 for Windows
    7m 35s
    Before printing your document in Excel 2013, 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 2013 for Windows
    7m 4s
    When it comes to printing your document, Excel 2013 allows 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 2013 for Windows
    4m 52s
    Excel 2013 can check for any compatibility issues that might be present in your workbook. This can help you to make sure that your document will be accessible and useable in older versions of Excel. This is important as there are certain tools and features - such as SmartArt items - that are not supported fully or will experience fidelity losses in older versions of Excel. FREE ACCESS
  • Locked
    12.  Editing your document properties in Excel 2013 for Windows
    6m 8s
    Your Excel 2013 workbook contains additional information relating to the document. These properties, which cover information on the document author, its modification dates, and a host of other categories, are not stored in a worksheet. It is therefore important to know how to access this information and modify it. FREE ACCESS
  • Locked
    13.  Checking for personal information in your document in Excel 2013 for Windows
    4m 2s
    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 2013 document inspector can find comments, data inserted into headers and footers, and even hidden rows and columns. Once you have identified any elements that could be considered confidential or personal, Excel 2013 can help you to decide what to do with them. FREE ACCESS
  • Locked
    14.  Creating an accessible document in Excel 2013 for Windows
    4m 39s
    Individuals with sight difficulties often use specialist tools to identify tags and other structural information embedded in your document. Excel 2013 features a document scan 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 2013 for Windows
    6m 9s
    If you need to protect the data that you have inserted into your Excel 2013 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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 1237 Likes 1237  
Likes 219 Likes 219