Sample chapter: How to Store and Retrieve Data in Microsoft Excel for the iPad

Excel provides a practical yet powerful way to store massive amounts of data. This chapter from Microsoft Office for iPad Step by Step guides you through procedures related to creating workbooks and worksheets, managing worksheets and worksheet elements, populating worksheets with text or numeric data, modifying worksheet structure, and formatting data for presentation. It also includes procedures for efficiently displaying, filtering, and sorting data to provide specific information and perspectives.

In this chapter

  • Create workbooks
  • Create and manage worksheets
  • Enter and edit data on worksheets
  • Modify columns and rows
  • Modify cells and cell content
  • Manage the display of data

Excel provides a practical yet powerful data management framework. You can store massive quantities of data within this deceptively simple structure, analyze that data, and present the resulting information in a variety of structures. The key ingredient in all of these tasks is the original data. The final presentation or analysis is only as good as the data it’s based on. This “garbage in, garbage out” rule is true for many business tools, programs, and processes; Excel is no exception.

A worksheet can contain a vast amount of static and calculated data. You can structure worksheet content so that data is presented correctly on the screen and when printed, and you can format data so that it is easier for readers to locate and understand specific categories of information.

Read the complete chapter here:

Skip to main content