Inserting Tables & Illustrations in Excel for iPhone

Excel for iPhone    |    Intermediate
  • 8 videos | 33m
  • Earns a Badge
Rating 4.8 of 6 users Rating 4.8 of 6 users (6)
You can add a variety of different objects to your Excel workbook. Charts and tables help you analyze and visualize your data, while images, shapes, and hyperlinks allow you to illustrate and enrich your documents.

WHAT YOU WILL LEARN

  • Create quick tables in excel for iphone
    Edit tables in excel for iphone
    Sort data in your workbook on excel for iphone
    Filter data in your workbook on excel for iphone
  • Insert your first chart in excel for iphone
    Add images to your spreadsheet in excel for iphone
    Insert and edit shapes in excel for iphone
    Insert hyperlinks in excel for iphone

IN THIS COURSE

  • 3m 17s
    Your data ranges can be arranged into tables. Excel for iPhone can very quickly create a table using a data range that you have selected. Once you have created a table, you can apply a filter and sort your data according to different criteria. FREE ACCESS
  • 4m 40s
    If you want to ensure that your data is readable and correctly displayed, then at some point early on you will need to know how to resize your columns and rows. See how to resize your columns and rows as well as modify your table style with the Excel for iPhone application. FREE ACCESS
  • Locked
    3.  Sorting the data in your table in Excel for iPhone
    3m 18s
    The sort options in Excel for iPhone are a very good way of changing how your data values appear in your Excel workbook. You can sort your data in alphabetical or numerical order. FREE ACCESS
  • Locked
    4.  Filtering the data in your table in Excel for iPhone
    3m 31s
    The filters in your document are a great way of hiding or showing particular data values in your workbook on Excel for iPhone. You can even combine these different filters to simplify your table. FREE ACCESS
  • Locked
    5.  Inserting your first chart in Excel for iPhone
    5m 47s
    Charts can be used to analyze and present your data in a visually attractive manner. Excel for iPhone comes complete with a large number of different chart types, all of which can be adjusted to suit your preferences. FREE ACCESS
  • Locked
    6.  Adding an image in Excel for iPhone
    4m 53s
    You can illustrate your spreadsheet by adding images to your Excel for iPhone worksheet. See how to add photos from the Photos application . You can even change the size or add effects to the image once it's added. FREE ACCESS
  • Locked
    7.  Inserting & editing shapes in Excel for iPhone
    3m 33s
    In Excel for iPhone you can insert many different shapes. See how to insert a shape, edit a shape as well as add text to a shape. FREE ACCESS
  • Locked
    8.  Inserting a hyperlink in Excel for iPhone
    4m 4s
    Hyperlinks are clickable links that can be inserted into your workbook so that users can  be quickly redirected to websites or start email drafts directed towards a specific recipient. Excel for iPhone automatically recognizes email addresses and websites as hyperlinks. 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

Course Working with diagrams in Word 365
Rating 4.5 of 37 users Rating 4.5 of 37 users (37)
Course Using charts in PowerPoint 365
Rating 4.5 of 99 users Rating 4.5 of 99 users (99)
Journey Microsoft Excel
Rating 3.7 of 9 users Rating 3.7 of 9 users (9)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Taking Responsibility for Your Accountability
Rating 4.5 of 3218 users Rating 4.5 of 3218 users (3218)
Course Using the iPad Camera & Photo Tools in iOS 12
Rating 4.2 of 5 users Rating 4.2 of 5 users (5)
Course Advanced and Interactive Visualization in R Bootcamp: Session 3 Replay
Rating 4.8 of 4 users Rating 4.8 of 4 users (4)