Using Workbooks in Excel iPad

Excel iPad    |    Beginner
  • 8 videos | 26m 53s
  • Earns a Badge
Likes 10 Likes 10
Get the most out of Excel for iPad. Discover the interface, and learn where to locate tools, how to create, open, manage, save, and print workbooks, and convert file formats.


  • use the Excel for iPad app
    create a new spreadsheet in Excel for iPad
    open an existing spreadsheet in Excel for iPad
    manage your worksheets in Excel for iPad
  • use the zoom function in Excel for iPad
    save your workbook in Excel for iPad
    understand and covert file formats in Excel for iPad
    print your spreadsheet from Excel for iPad


  • 5m 23s
    To get the most out of Excel for iPad, you are going to need to understand its interface and where all the tools are found. Almost all the tools that you will need to use can be found in the ribbon, which is divided into different thematic tabs. Knowing what each tab offers will really speed up your work in Excel for iPad. FREE ACCESS
  • 2m 50s
    The first thing you'll need to learn how to do in Excel for iPad is create a new document. There are ready to use templates at your disposal, but you can also create a document from scratch. Learn how to do both in this tutorial. FREE ACCESS
  • Locked
    3.  Opening an existing document in Excel iPad
    2m 50s
    After creating a document, you'll need to learn how to find and open it. This tutorial will focus on locating and quickly opening saved documents so that you can consult and modify them using Excel for iPad. You'll also learn a way to easily find documents you recently opened. FREE ACCESS
  • Locked
    4.  Managing your worksheets in Excel iPad
    4m 17s
    Worksheets are used in Excel for iPad 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 for iPad, you are going to need to know how to navigate between your worksheets and how to modify their properties, such as their position and their name. FREE ACCESS
  • Locked
    5.  Using the zoom function in Excel iPad
    1m 36s
    Excel for iPad's zoom function can be used to change the level of detail in which you view your workbook. Zooming in allows you to take a look at a particular element of your document more closely, while zooming out can help you get an overall view. FREE ACCESS
  • Locked
    6.  Saving your workbook in Excel iPad
    3m 51s
    In Excel for iPad you can choose to manually or automatically save changes to your document. If you choose to save online documents automatically, any changes you make to your workbook will be automatically and instantly saved online, ensuring that you will always have the latest version available. You can also download a copy of your workbook to create a local version as backup or for sharing with users offline. FREE ACCESS
  • Locked
    7.  Understanding & converting file formats in Excel iPad
    2m 33s
    If you want to open a document that is saved in an older Excel format with the extension XLS, you'll have to convert the file before making any changes. Learn how to tell the difference between an SLX and an XLSX file, convert a file saved in the older version and, finally, save this file to an appropriate location before beginning the editing process. FREE ACCESS
  • Locked
    8.  Printing your document in Excel iPad
    3m 33s
    The Excel for iPad print options allow you to choose between portrait and landscape format as well as adjust the margin sizes. You can also select which pages you'd like a hard copy of as well as how many copies of each you'd like to print. FREE ACCESS


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.


Likes 1 Likes 1  
Likes 1300 Likes 1300