Working with Excel on the iPad

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
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
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 23m
Feb 12, 2016
Getting Started with Excel 2016 for Mac
Beginner
2h 25m
Oct 7, 2015
Section Introduction Transcripts
Section Introduction Transcripts

Entering and Editing Data
In this module I'm going to teach you about entering data into cells. We'll look at the difference between text, numbers, and dates, and I'll show you a cool trick to solve a problem where you have numeric values that begin with a 0. I'll be showing you how to amend and delete the contents of a cell, and you'll also learn about a valuable, yet underused feature of Excel called Cell Comments. And finally, we'll look at three great ways to save time when entering data into Excel, Cut, Copy, and Fill.

Formatting Your Data
In this module we're going to focus on formatting, which is all about improving the appearance of a spreadsheet to make it easy to read and understand. You'll learn how to change the width of a column and the height of a row, how to insert and delete rows and columns within existing data, and how to hide rows and columns. Then I'll teach you about cell formatting. In addition to learning how to change the font, the size, and the color of cells, we'll look at changing the alignment of data in a cell and a how to change the way that numbers and dates are displayed. Even something simple like adding a separator character will make very large numbers easy to read. And you'll also learn about a couple of great time savers, copying formatting and cell styles.

Creating Formulas and Using Functions
Although it's perfectly possible to use Excel without ever creating a formula or using a function, if you don't, you're missing out on a huge part of the application's power. Formulas allow you to do things such as add up numbers, subtract one number from another, as well as divide and multiply. In this module you'll learn how to create formulas to do all of these things. You'll also learn about the importance of using brackets or parenthesis in formulas. And I'll show you what happens when you copy a formula and how sometimes you need to make a cell reference in a formula fixed or absolute, so that the formula copies correctly. Functions are like formulas except they're predefined and built into Excel. There's over 300 functions, and I'll show you a few of the basic, but useful ones. But let's start this module by looking at creating basic formulas.

Working with Lists
This section of the course is all about Working with Lists. This could be a list of numbers, a list of dates, a list of text entries, or a multicolumn list. Excel is perfect for manipulating lists of data. A list can be sorted, for example, a list of numbers can be sorted into highest to lowest order. You can apply a filter to a list, for example, show me a list of all the employees who are based in the New York office, and we'll look at sorting and filtering in this part of the course. More and more people are using Excel to work with data that's come from other sources, and a common issue with this kind of data is that it often needs to be tidied up and cleaned to make it useable, and you'll learn about some of the ways that you can do this. In this module I'll answer an often-asked question, how do I stop my list headings from disappearing as I scroll down the screen? And finally, you'll learn about the benefits of using tables. So with that, let's move on and look at sorting.

Visualize Your Data
They say a picture is worth a thousand words, and Excel is no exception to this. It's often easier to look at a chart or graph to interpret trends in a set of data than to look at a set of figures. In this module of the course, you'll learn how to create a column chart. I'll also show you the recommended charts feature. And finally, we'll look at the people graph, which allows you to display a set of data as a kind of infographic.

iPad-specific Features
In this module you'll learn how to connect your iPad to Dropbox and Box, two cloud-based file storage services. I'll also show you how to access your files when you have no internet connection, for example when you're on an airplane. And if you have iOS 9, that's the latest iPad operating system installed on your iPad, you can take advantage of the multitasking features, and I'll show you how to do that. Finally in this module, I'll demonstrate some of the limitations of using Excel on an iPad compared to Excel on a desktop computer.