Wiley 978-0-470-50164-1 Datenblatt PDF herunterladen

➟

Working with

Excel Files

xcel is like a giant accountant ledger sheet composed of a grid made up

of columns and rows. At each row and column intersection is a cell. A

single worksheet contains 16,374 columns across the top (stretching from

column A to column XFD) and 1,048,576 rows down the side. That’s over

17 billion cells in a single worksheet. A cell address is the description of the

intersection of a column and a row, such as D23 (in this example, D is the

column name and 23 is the row).

The Excel interface provides you with the right tools at the right time. In

most Windows programs, you see menus and toolbars to select your options

from. Instead of the traditional look, Excel provides icon- and button-laden

tabs on the Ribbon containing most Excel features.

Throughout the course of this book, you discover methods to use Excel as a

spreadsheet, of course; but you also discover how to use it as a database, a

calculator, a planner, and even a graphic illustrator. I start with the basics

and work into the more advanced Excel actions.

In this chapter, you discover how to

➟

Open and close the Excel program.

➟

Work in the new Backstage View.

➟

Select commands with your keyboard.

➟

Change information on your status bar.

➟

Create, open, and save Excel workbooks.

➟

Convert earlier files to Excel 2010.

➟

Delete and rename workbook files.

➟

Use workbook properties to better manage your files.

Get ready to. . .

➟

Open and Explore Excel ............................... 6

➟

Explore Backstage View ...............................7

➟

Close Excel .................................................. 7

➟

Select Commands with the Keyboard ............8

➟

Change Status Bar Indicators .......................8

➟

Create a New Excel File ...............................9

➟

Save a Workbook ........................................ 9

➟

Save a Workbook in a Different Format .......10

➟

Open an Existing Excel File ........................ 10

➟

Convert a Prior Version File to Excel 2010 .......11

➟

Delete a File .............................................11

➟

Rename a File ........................................... 12

➟

Specify Workbook Properties .....................12

➟

Chapter

05_501641-ch01.indd 505_501641-ch01.indd 5 4/23/10 8:59 PM4/23/10 8:59 PM

COPYRIGHTED MATERIAL

1 2 3 4 5 6 7 8

Inhaltsverzeichnis

Seite 1 - Excel Files

➟Working with Excel FilesExcel is like a giant accountant ledger sheet composed of a grid made up of columns and rows. At each row and column intersec

Seite 2 - Open and Explore Excel

6Chapter 1: Working with Excel FilesFigure 1-1Figure 1-2Open and Explore Excel 1. Choose Start➪All Programs➪Microsoft Office➪Microsoft Excel 2010. The

Seite 3 - Close Excel

7Close ExcelFigure 1-3Figure 1-4Explore Backstage View 1. Click File. Excel Backstage View opens with three columns. The left column represents action

Seite 4 - Change Status Bar Indicators

8Chapter 1: Working with Excel Files 4. Click anywhere in the Excel workbook to close the Customize Status Bar menu.Figure 1-5Figure 1-6Select Command

Seite 5 - Save a Workbook

9Save a WorkbookFigure 1-7Figure 1-8Create a New Excel File 1. Choose File➪New. Backstage View shows templates you can choose from in the middle colum

Seite 6 - Open an Existing Excel File

10Chapter 1: Working with Excel FilesFigure 1-9Figure 1-10Save a Workbook in a Different Format 1. Click File and, from Backstage View that appears, c

Seite 7 - Delete a File

11Delete a FileFigure 1-11Figure 1-12Convert a Prior Version File to Excel 2010 1. Open a workbook created in an earlier version of Excel; the title b

Seite 8 - Specify Workbook Properties

12Chapter 1: Working with Excel FilesFigure 1-13Figure 1-14Rename a File 1. Open Excel but don’t open the file you want to rename. Choose File➪Open or

Kommentare zu diesen Handbüchern

Keine Kommentare

Wiley 978-0-470-50164-1 Datenblatt

Stöbern Sie online oder laden Sie Datenblatt nach Software-Handbücher Wiley 978-0-470-50164-1 herunter. Wiley Excel 2010 Just the Steps For Dummies Benutzerhandbuch

Inhaltsverzeichnis

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Software-Handbücher Wiley 978-0-470-50164-1