by Zack Barresse | Released December 2014 | ISBN: 9780134076621

Easy video tutorials help you make the most of Microsoft Excel on your iPad! DescriptionMaster 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 InstructorZack 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 LevelAll Levels What You Will LearnHow to get Excel for the iPad (and choose amongst Microsoft's available options)How to create, edit, format, open, save, and navigate Excel workbooksHow to work with formulas, sort and filter data, and insert chartsHow to validate, share, and send dataHow to use and edit PivotTables, and control their source dataHow to use Excel for iPad with Office 365, and exchange data with other Excel users Who Should Take This CourseFor everyone who wants to use Excel on an iPad, from administrative assistants to CFOs Course RequirementsNo experience required (basic familiarity with desktop Excel or the iPad helpful) Table of ContentsLesson 1: Getting Excel for iPadLesson 2: Getting started in Excel for iPadLesson 3: Getting around the appLesson 4: Using and editing formulasLesson 5: Sorting and filtering dataLesson 6: Charting in Excel for iPadLesson 7: Working with shapesLesson 8: Sharing and sending your dataLesson 9: Using and editing PivotTablesLesson 10: Using coloring and validation features About Que VideoQue 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 Show and hide more

1. Getting Excel for iPad 00:02:16
2. Getting started in Excel for iPad 00:07:04
3. Getting around the app 00:08:17
4. Using and editing formulas 00:12:49
5. Sorting and filtering data 00:06:28
6. Charting in Excel for iPad 00:04:30
7. Working with shapes 00:05:55
8. Sharing and sending your data 00:04:36
9. Using and editing PivotTables 00:06:31
10. Using coloring and data validation features 00:05:35
Show and hide more