Chapter 11. Entering the Data

In This Chapter

  • Creating an Excel workbook

  • Understanding what a worksheet is

  • Entering text, as well as numeric, date, and time data

  • Editing data in a worksheet

  • Changing a worksheet's layout

This chapter introduces Excel Web App, the official Office Web App number cruncher. The purpose of Excel Web App is to track and tabulate numbers. Use the program to project profits and losses, formulate a budget, or analyze Elvis sightings in North America. Doing the setup work takes time, but after you enter the numbers and tell Excel Web App how to tabulate them, you're on Easy Street. Excel Web App does the math for you. All you have to do is kick off your shoes, sit back, and see how the numbers stack up.

This chapter explains what a workbook and a worksheet are, and how rows and columns on a worksheet determine where cell addresses are. You also discover tips and tricks for entering data in a worksheet and making a worksheet easier to understand and read. And in case you're a fan of Excel 2010, this chapter outlines the differences between the Excel Web App and its cousin Excel 2010.

Creating Workbooks with Excel Web App

Chapter 2 explains in excruciating detail how to create an Excel workbook with Excel Web App and how to open workbooks you already created. In case you haven't visited Chapter 2, here are shorthand instructions for opening a workbook with Excel Web App:

  1. Click the New link and choose Excel Workbook on the drop-down list.

    You see the New Microsoft Excel ...

Get Office 2010 Web Apps For Dummies® now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.