Numbers for iPad & iPad Pro (Vole Guides)

Book excerpt: This handy guide covers all of Numbers for iOS, Apple's chart-topping spreadsheet app tuned to work with your iPad, iPhone, and iPod touch. If you're coming from Numbers for Mac or Microsoft Excel, you'll find all the steps needed to transfer your spreadsheets and make a painless transition from point-and-click to tap-and-drag. - Use just your fingers to create spreadsheets with tables, charts, graphics, and media. - Create spreadsheets based on Apple's professionally designed templates or your own custom templates. - Store spreadsheets in iCloud or third-party cloud locations such as Dropbox or Google Drive. - Use Handoff to pass spreadsheets seamlessly between your Mac, iPhone, iPad, and iPod touch. - View or restore earlier versions of your spreadsheets. - Organize your spreadsheets into folders. - Restrict access to your spreadsheets by password-protecting them. - Add multiple sheets and tables to your spreadsheets. - Print spreadsheets wirelessly from an AirPrint-capable printer. - Edit and format cells and use the built-in editing tools. - Enter data with sliders, steppers, pop-up menus, checkboxes, star ratings, and intelligent keyboards. - Add comments and highlights to your work. - Cut, copy, paste, merge, fill, and sort cells. - Use forms to edit lists easily. - Enter, copy, move, and troubleshoot formulas. - Choose from more than 250 built-in functions and operators to build formulas. - Chart your data to reveal trends and relationships. - Embellish your spreadsheets with photos, videos, text boxes, arrows, lines, and shapes. - Export Numbers, Excel, PDF, or CSV files. - Import Numbers, Excel, or CSV files. - Send copies of spreadsheets via email, Messages, or AirDrop. - Transfer spreadsheets via remote server. - Use iCloud to store, share, sync, or collaborate on spreadsheets online. - Plenty of tips, tricks, and timesavers. - Fully cross-referenced, linked, and searchable. Contents 1. Getting Started with Numbers 2. Spreadsheet Basics 3. Entering Data 4. Formulas and Functions 5. Charts 6. Media, Text Boxes, and Shapes 7. Sharing and Converting Spreadsheets