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
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
Table of Contents
Getting Excel for iPad
00:02:16
Getting started in Excel for iPad
00:07:04
Getting around the app
00:08:17
Using and editing formulas
00:12:49
Sorting and filtering data
00:06:28
Charting in Excel for iPad
00:04:30
Working with shapes
00:05:55
Sharing and sending your data
00:04:36
Using and editing PivotTables
00:06:31
Using coloring and data validation features
00:05:35