Wiley 978-0-470-57769-1 Datasheet download pdf

What You Can Do

in Excel

icrosoft Excel is one of the world’s most

popular spreadsheet programs. You could

create worksheets on ledger paper and use

a calculator or draw charts on graph paper, but Excel

makes these tasks and others related to managing

numeric information easier. You can use the program

to create worksheets, databases, and charts. Without

a doubt, you could perform the following functions

manually, but you can use Excel to make them easier.

Lay Out a Worksheet

When you sit down to develop a worksheet

with a pencil and ledger paper, you do not

always have all the information to complete the

design and layout of the worksheet. Ideas may

occur to you after you sketch the layout of your

worksheet. After you are finished jotting down

the column headings and the row headings,

you might think of another column or row

that you did not include. If you are working with

pencil and paper, restructuring the layout of a

worksheet can be tedious and time-consuming.

With Excel, you can easily insert columns and

rows as well as move information from one

location to another.

Calculate Numbers

Think about the tasks involved in managing your

checkbook register. You subtract the amount of

each check written and add the deposits to the

running balance. You then use your bank

statement to balance your checkbook, and it is

not at all uncommon to find math errors in your

checkbook. So, you must then recalculate the

numbers in your checkbook register and jot

down the new answers. If you set up an Excel

workbook to do the same tasks, you can use

formulas that subtract checks and add deposits.

You enter the formulas only once and simply

supply the amounts of your checks and deposits,

much as you record them in your checkbook

workbook, Excel uses the formulas to recalculate

the information in your workbook and instantly

gives you the new answers — in most cases,

without the associated math errors.

Organize, Sort, and Filter Lists

You can create tables to organize your data in

lists. For example, you can create inventory lists,

employee lists, customer lists, student grade lists,

and sales records. In Excel, you can add, delete,

sort, search, and display records in the list as

often as required to maintain the list. You can

sort data on the worksheet alphabetically and

numerically in ascending or descending order.

For example, you can sort sales records in

chronological order by dates. You can also use

the AutoFilter feature to quickly find information

that meets a specific criterion or to find the top

or bottom ten values in the list without sorting.

04_577691-ch01.indd 404_577691-ch01.indd 4 6/3/10 10:45 AM6/3/10 10:45 AM

COPYRIGHTED MATERIAL

1 2 3 4 5 6 ... 15 16

Summary of Contents

Page 1 - COPYRIGHTED MATERIAL

4What You Can Do in ExcelMicrosoft Excel is one of the world’s most popular spreadsheet programs. You could create worksheets on ledger paper and use

Page 2

Getting Started with Excelchapter 113PART I••34Is there a way to return to working in Excel without making any selections in Backstage view? Yes. You

Page 3 - Close Excel

14•••312Enter Text1 Click a cell.Note: See Chapter 4 for more on selecting cells.2 Type text.• As you type, the information appears both in the cell a

Page 4 - 2 Click Exit

Getting Started with Excelchapter 115PART I••1••1Can I edit or delete the information that I type in a cell? Yes. You can edit the information either

Page 5 - Understanding

162312 Perform another action. In this example, italics are added.Note: See Chapter 3 for more on using italics.3 Click the Undo button ().1 Perform

Page 6 - Terminology

Getting Started with Excelchapter 117PART ICan I undo more than one action at a time? Yes. Click the drop-down arrow () beside the Undo button () to

Page 7

18•••2 Press the right arrow key.• Excel moves the active cell one column to the right. You can press any arrow key to move the active cell one cell

Page 8 - Work with the Mini Toolbar

Getting Started with Excelchapter 119PART I•67When I open Excel, I see Sheet1, Sheet2, and Sheet3 at the bottom of the screen. What are these? Every

Page 9 - Backstage View

5PART Ichapter 1Getting Started with ExcelView DataWhen working with a large worksheet on ledger paper, such as a financial statement, you might have

Page 10 - 4 Repeat step 2 until you

6••2341• All Programs changes to Back.3 Click Microsoft Office.• The list of installed Microsoft Office programs appears.4 Click Microsoft Excel 2010.

Page 11 - Information

Getting Started with Excelchapter 17PART I•12Does Excel prompt me to save before closing the program? If you have not made any changes to the workboo

Page 12 - Enter Numbers

8Each time you open Excel, you see a new workbook named Book1 that contains three worksheets.Understanding the Excel ScreenB ADCHGEF HA Title BarDispl

Page 13 - 3 Click the Undo button

Getting Started with Excelchapter 19PART IWorkbookA workbook is a file in which you store your data. Think of a workbook as a three-ring binder. Each

Page 14 - 4 Click the Redo button

10On the Ribbon, you find tabs, which take the place of menus in Excel 2010. Each tab contains a collection of buttons that you use to perform a parti

Page 15 - Move Around

Getting Started with Excelchapter 111PART I1••2 Right-click on the selection.• The Mini toolbar and Context menu appear, with the Mini toolbar above t

Page 16 - 7 Click OK

12•••12•• In Backstage view, commonly used file-management commands appear here.• The title of the open workbook appears here.• Buttons that represent

Comments to this Manuals

No comments

Wiley 978-0-470-57769-1 Datasheet

Browse online or download Datasheet for Software manuals Wiley 978-0-470-57769-1. Wiley Master VISUALLY Excel 2010 User Manual

Summary of Contents

Comments to this Manuals

Related products and manuals for Software manuals Wiley 978-0-470-57769-1