Microsoft Excel for iPad Quick Reference Guide: Introduction (Cheat Sheet of Instructions, Tips & Shortcuts)

Note: This guide was updated in August 2015 and reissued under ISBN 978-1-939791-56-6. Please search that ISBN to get the latest version of this guide. Four page quick reference guide in a new, compact iPad-friendly format (8.5 inches x 5.5 inches) to help you create and edit your spreadsheets using Microsoft's new Excel app for the iPad.

Written with Beezix's trademark focus on clarity, accuracy, and the user's perspective, this guide will be a valuable resource to improve your proficiency in using Excel for iPad.

The following topics are covered:

Getting Started: Using the Numerical Onscreen Keyboard; Entering New Data; Editing or Replacing the Contents of a Cell; Selecting Cells; Resizing Column Width/ Row Height; Inserting Rows or Columns; Inserting Cells; Clearing Cells; Deleting Rows, Columns, or Cells; Shading and Text Color; Setting Borders; Formatting Number Cells; Aligning Within Cells; Merging Cells; Entering Dates; Entering a Sequence.

Formulas and Functions: Entering a Formula; Entering a Function; Quick Entry of SUM & Other Functions; Absolute vs. Relative Cell References; Changing a Function/ Formula to a Value.

Copying and Moving Data: Copying to Adjacent Cells; Moving Cells with Drag and Drop; Adding a Sheet; Renaming a Sheet; Moving Among Sheets; Moving Sheets; Duplicating a Sheet; Deleting a Sheet; Freezing Panes; Wrapping Text; Creating an Excel Table; Converting a Table to a List Range; Using a List Range for Sorting or Filtering; Sorting; Filtering; Inserting a Chart; Customizing a Chart.

Also includes a list of shortcuts.