December 2014
Beginner to advanced
1h 4m
English
Overview
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
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.