Office for iPad and Mac For Dummies

Chapter 10

Up and Running with Excel 2011

In This Chapter

Creating an Excel workbook

Understanding what a worksheet is

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

Using the AutoFill command to enter lists and serial data

Establishing conditional formats for text

Setting up data-validation rules

This chapter introduces Excel, the world’s greatest number cruncher. The purpose of Excel is to track, analyze, 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 how to tabulate them, you’re on Easy Street. Excel 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 is, and how rows and columns on a worksheet ...