Excel : the missing manual / Matthew MacDonald.

Format:

Book

Author/Creator:

MacDonald, Matthew.

Series:

Missing manual.

Missing manual

The Missing manual

Language:

English

Subjects (All):

Microsoft Excel (Computer file).

Business--Computer programs.

Business.

Electronic spreadsheets--Computer programs.

Electronic spreadsheets.

Physical Description:

1 online resource (792 p.)

Edition:

First edition.

Place of Publication:

Beijing ; Sebastopol, California : Pogue Press/O'Reilly, 2004.

Language Note:

English

System Details:

text file

Summary:

Whether you are an Excel neophyte, a sophisticate who knows the program inside out, or an intermediate-level plodder eager to hone your skills, Excel: The Missing Manual is sure to become your go-to resource for all things Excel. Covering all the features of Excel 2002 and 2003, the most recent versions for Windows, Excel: The Missing Manual is an easy-to-read, thorough and downright enjoyable guide to one of the world's most popular, (and annoyingly complicated!) computer programs. Never a candidate for ""the most user-friendly of Microsoft programs,"" Excel dema

Contents:

1.5. Opening Files2. Adding Information to Worksheets; 2.1.1.2. How Excel decides your data is numeric; 2.1.1.3. How Excel decides your data is a date or time; 2.2. Quick Ways to Add Data; 2.2.2. AutoCorrect; 2.2.3. AutoFill; 2.2.4. AutoFit; 2.2.5. Undo and Redo; 3. Moving Data Around a Worksheet; 3.1.2. Making Non-Contiguous Selections; 3.1.3. Automatically Selecting Your Data; 3.1.4. Making Selections with the Keyboard; 3.2. Moving Cells Around; 3.2.2. A Fancy Cut-and-Paste or Copy-and-Paste; 3.2.3. The Clipboard; 3.2.4. Special Pasting; 3.3. Adding and Moving Columns or Rows

3.3.2. Inserting Rows3.3.3. Inserting Copied or Cut Cells; 3.3.4. Deleting Columns and Rows; 4. Formatting Worksheets; 4.1.1.2. Number; 4.1.1.3. Currency; 4.1.1.4. Accounting; 4.1.1.5. Percentage; 4.1.1.6. Fraction; 4.1.1.7. Scientific; 4.1.1.8. Text; 4.1.2. Formatting Dates and Times; 4.1.3. Special Formats for Special Numbers; 4.1.4. Custom Formats; 4.1.4.2. Custom format string codes; 4.1.4.3. Date and time format strings; 4.1.4.4. Number format strings; 4.1.4.5. Text format strings; 4.2. Formatting Cell Appearance; 4.2.2. Fonts and Color; 4.2.3. Borders and Patterns

4.3. Smart Ways to Apply Formatting4.3.1.2. Formatting individual characters; 4.3.2. AutoFormat; 4.3.3. The Format Painter; 4.3.4. Using Styles; 4.3.4.2. Applying a style; 4.3.4.3. Transferring styles; 4.3.5. Conditional Formatting; 5. Managing Worksheets and Workbooks; 5.1.2. Naming and Rearranging Worksheets; 5.1.3. Grouping Sheets; 5.1.3.2. Formatting cells, columns, and rows in grouped worksheets; 5.1.3.3. Entering data or changing cells in grouped worksheets; 5.1.3.4. Cutting, copying, and pasting cells in grouped worksheets

5.1.3.5. Adjusting printing and display options in grouped worksheets5.1.4. Moving Worksheets from One Workbook to Another; 5.2. Find and Replace; 5.2.2. More Advanced Searches; 5.2.3. Finding Formatted Cells; 5.2.4. Finding and Replacing Values; 5.3. Spell Check; 6. Viewing and Printing Worksheets; 6.1.2. Viewing Distant Parts of a Spreadsheet at Once; 6.1.3. Freezing Columns or Rows; 6.1.4. Hiding Data; 6.1.5. Saving View Settings; 6.1.6. Viewing Multiple Workbooks at Once; 6.2. Printing; 6.2.2. Customizing Print Settings; 6.2.2.2. Margins settings; 6.2.2.3. Creating headers and footers

6.2.2.4. Sheet settings

Notes:

"Covers versions 2002 and 2003."

"Master the world's greatest spreadsheet program."

Includes index.

Description based on print version record.

ISBN:

9781306817554

1306817552

9780596517830

0596517831

9780596550592

0596550596

OCLC:

609841302

Publisher Number:

0596006640