Wiley 978-0-470-18170-6 Datasheet download pdf

What You Can

Do in Excel

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 and 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 for 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.

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.

05_181706 ch01.qxp 1/31/08 9:44 PM Page 4

COPYRIGHTED MATERIAL

1 2 3 4 5 6 ... 15 16

Summary of Contents

Page 1 - COPYRIGHTED MATERIAL

4What You Can Do in ExcelLay Out a WorksheetWhen you sit down to develop a worksheet witha pencil and ledger paper, you do not alwayshave all the info

Page 2

Can I edit or delete the information thatI type in a cell?Yes. You can edit the information either asyou type it or after you type it by pressingthe F

Page 3 - Close Excel

Undo and RedoUndo and RedoYou can use the Undo feature in Excel torecover from editing mistakes that mightotherwise force you to re-enter data. TheUnd

Page 4 - 2 Click Exit Excel

Can I undo more than oneaction at a time?Yes. Click beside todisplay the list of actionsyou can undo. Click theoldest action you want toundo, and Exce

Page 5

Move Around in a WorksheetMove Around in a WorksheetYou can use arrow keys to move around aworksheet, moving the cell pointer up, down,left, or right

Page 6 - Learn Excel Terminology

What happens if I click theSpecial button in the GoTo dialog box?Excel displays the Go ToSpecial dialog box, whereyou can set specialconditions for Ex

Page 7 - Understanding the Ribbon

Move Around in a WorkbookMove Around in a WorkbookYou can move between the worksheets in aworkbook using the tabs and controls at thebottom of the Exc

Page 8 - Work with the Mini Toolbar

Manage the Status BarManage the Status BarYou can add elements to, or remove elementsfrom, the Status Bar to display manydifferent types of informatio

Page 9 - Information

PART IGetting Started with Excel5View DataWhen working with a large worksheet onledger paper, such as a financial statement, youmight have to use a ru

Page 10 - Getting Started with Excel

Start and Close ExcelStart and Close ExcelYou can start the Excel program using theWindows Start menu. When you open theStart menu, a search field app

Page 11 - Undo and Redo

Does Excel prompt me tosave before closing theprogram?If you have not made anychanges to the workbook,Excel closes withoutprompting you to takeany fur

Page 12 - 4 Click the Redo button ( )

8Understanding the Excel ScreenEach time you open Excel, you see a newworkbook named Book1 that contains threeworksheets.BFHIGCADIEA Title BarDisplays

Page 13 - Move Around

PART IGetting Started with Excel9chapter 1Learn Excel TerminologyWorkbookA workbook is a file in which you store yourdata. Think of a workbook as a th

Page 14

10Understanding the RibbonTabs on the RibbonTab PurposeHome This tab helps you format and edit a worksheet.Insert This tab helps you add elements such

Page 15

Work with the Mini Toolbar and Context MenuWork with the Mini Toolbarand Context MenuYou can use the Mini Toolbar and theContext menu to help you quic

Page 16 - Status Bar

Enter InformationEnter InformationYou can quickly and easily type text andnumbers into your worksheet. Most peopleuse Excel primarily to accomplish ma

Comments to this Manuals

No comments

Wiley 978-0-470-18170-6 Datasheet

Browse online or download Datasheet for Software manuals Wiley 978-0-470-18170-6. Wiley Master VISUALLY Excel 2007 User Manual

Summary of Contents

Comments to this Manuals

Related products and manuals for Software manuals Wiley 978-0-470-18170-6