Working with Excel on the iPad

By Mike Thomas
This course provides a solid introduction to using Excel on an iPad and is aimed at anyone who is either completely new to Excel or has used it at a very basic level.
Course info
Level
Beginner
Updated
Dec 9, 2015
Duration
2h 7m
Table of contents
Introduction to Excel on an iPad
Introduction to the Course 3m Working with Workbooks 2m Screen Interface Elements 3m Saving and Closing a Workbook 3m Printing Your Data 3m Summary 1m
Entering and Editing Data
Introduction 1m Working with Cell Entries 5m Cell Comments 2m Cut, Copy, and Paste 3m Auto Fill 4m Summary 1m
Formatting Your Data
Introduction 1m Resizing Columns and Rows 4m Inserting and Deleting Columns and Rows 2m Applying Formatting to a Cell 9m Hiding and Unhiding Columns and Rows 2m Using Cell Styles 1m Summary 1m
Creating Formulas and Using Functions
Introduction 1m Creating Basic Calculations 10m Copying a Formula 11m Using a Named Cell in a Formula 3m Introduction to Functions 4m Summary 1m
Working with Lists
Introduction 1m Sorting a List of Items into Order 4m Fixing Issues that Prevent Sorting 7m Filtering a List 3m Prevent List Headings Disappearing as You Scroll 2m Creating and Using a Table 2m Summary 1m
Visualize Your Data
Introduction 1m Creating a Column Chart 6m The People Graph 4m Summary 0m
iPad-specific Features
Introduction 1m Connecting Excel to Dropbox 3m Connecting Excel to Box 2m Working with no Internet Connection 3m Multi-tasking in iOS9 2m Limitations of Excel for iPad 4m Module Summary 0m Course Summary 1m
Description
Course info
Level
Beginner
Updated
Dec 9, 2015
Duration
2h 7m
Description

Learn how to use Excel on an iPad! You’ll learn how to set up a spreadsheet from scratch, update an existing spreadsheet, and improve the appearance of a spreadsheet to make it easy to read and understand. You’ll also learn how to create simple calculations, use some of Excel’s functions, work with list based data, print your spreadsheet, represent your data in a visual way, and manage your documents on a mobile device.

About the author
Mike Thomas
About the author

Based in Manchester, England, Mike has 27 years experience in corporate IT training, working with and for organizations across a diverse range of industries. He designs and delivers face-to-face, virtual, written and video-based training, primarily focusing on Microsoft Office, Lync, SharePoint, VBA development and database development.

More from the author
Pivot Tables for Excel 2016
Intermediate
2h 24m
Feb 12, 2016
Getting Started with Excel 2016 for Mac
Beginner
2h 25m
Oct 7, 2015

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT