2015
Pluralsight
Mike Thomas
2:07
English
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.
Introduction to Excel on an iPad
14m 57s
Introduction to the Course 2m 58s
Working with Workbooks 2m 23s
Screen Interface Elements 3m 14s
Saving and Closing a Workbook 3m 0s
Printing Your Data 2m 49s
Summary 0m 30s
Entering and Editing Data
14m 53s
Introduction 0m 38s
Working with Cell Entries 4m 39s
Cell Comments 1m 51s
Cut, Copy, and Paste 3m 24s
Auto Fill 3m 45s
Summary 0m 35s
Formatting Your Data
20m 21s
Introduction 0m 54s
Resizing Columns and Rows 4m 3s
Inserting and Deleting Columns and Rows 2m 10s
Applying Formatting to a Cell 8m 52s
Hiding and Unhiding Columns and Rows 2m 17s
Using Cell Styles 1m 29s
Summary 0m 34s
Creating Formulas and Using Functions
30m 21s
Introduction 1m 2s
Creating Basic Calculations 10m 16s
Copying a Formula 11m 18s
Using a Named Cell in a Formula 3m 6s
Introduction to Functions 4m 1s
Summary 0m 35s
Working with Lists
20m 19s
Introduction 1m 8s
Sorting a List of Items into Order 3m 59s
Fixing Issues that Prevent Sorting 6m 41s
Filtering a List 3m 9s
Prevent List Headings Disappearing as You Scroll 2m 26s
Creating and Using a Table 2m 14s
Summary 0m 38s
Visualize Your Data
11m 46s
Introduction 0m 31s
Creating a Column Chart 6m 26s
The People Graph 4m 18s
Summary 0m 29s
iPad-specific Features
14m 41s
Introduction 0m 40s
Connecting Excel to Dropbox 2m 30s
Connecting Excel to Box 2m 20s
Working with no Internet Connection 2m 33s
Multi-tasking in iOS9 2m 8s
Limitations of Excel for iPad 3m 33s
Module Summary 0m 21s
Course Summary 0m 32s
pluralsight.com/courses/working-excel-ipad
Download File Size:360.67 MB
|
