O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Excel for iPad

Video Description

Easy video tutorials help you make the most of Microsoft Excel on your iPad!

 

Description

Master Excel for iPad through quick, easy video tutorials designed just for iPad users! In just 90 minutes, Excel for iPad User's Guide won't just get you up and running: it'll teach you all the core skills you need to be productive with Excel for your iPad tablet, and collaborate with any Excel user, anywhere! Top Excel expert and Microsoft MVP Zack Barrese walks you through creating, opening, editing, and saving workbooks… using OneDrive to access your workbooks anywhere… sharing workbooks with Excel users on desktops, tablets, or Office 365… sorting, filtering, and validating your data… building reliable formulas and inserting attractive, intuitive charts… even creating powerful PivotTables for analysis!

 

About the Instructor

Zack Barresseis a long-standing Microsoft Excel MVP who has contributed to online help forums for over a decade, and helped to create www.vbaexpress.com. He recently wrote the book on Excel tables and runs exceltables.com. His Excel-related roles have included author, trainer, consultant, template builder for Microsoft, and developer.

 

Skill Level

  • All Levels

 

What You Will Learn

  • How to get Excel for the iPad (and choose amongst Microsoft's available options)
  • How to create, edit, format, open, save, and navigate Excel workbooks
  • How to work with formulas, sort and filter data, and insert charts
  • How to validate, share, and send data
  • How to use and edit PivotTables, and control their source data
  • How to use Excel for iPad with Office 365, and exchange data with other Excel users

 

Who Should Take This Course

  • For everyone who wants to use Excel on an iPad, from administrative assistants to CFOs

 

Course Requirements

  • No experience required (basic familiarity with desktop Excel or the iPad helpful)

 

Table of Contents

Lesson 1: Getting Excel for iPad

Lesson 2: Getting started in Excel for iPad

Lesson 3: Getting around the app

Lesson 4: Using and editing formulas

Lesson 5: Sorting and filtering data

Lesson 6: Charting in Excel for iPad

Lesson 7: Working with shapes

Lesson 8: Sharing and sending your data

Lesson 9: Using and editing PivotTables

Lesson 10: Using coloring and validation features

 

About Que Video

Que Video helps you learn technology efficiently with easy-to-follow video tutorials covering popular software apps, online games, and more. Each Que videos are professionally produced and feature the highest quality step-by-step instruction designed by trusted authors and trainers from Que Publishing, an imprint of Pearson - the world's leading learning company. View Que Videos at: http://www.quepublishing.com/quevideo