Excel 2003 Just the Steps for Dummies or Steal This Computer Book 40

Excel 2003 Just the Steps for Dummies

Author: Diane Koers

Easy steps for creating spreadsheets you can really use

Simple steps...

...for great results

Use AutoOutline

• Choose Data Group and Outline AutoOutline. Figure 11-9 illustrates a worksheet with outline headings for both rows and columns. Row outline symbols are at the top of the worksheet.

• AutoOutline works best if the worksheet has summary formulas that reference cells in the detail cells. The summary formulas must be adjacent to the detail.

• To expand the outline, click the Show Detailbuttons to the left of the rows or above thecolumn headings. (See Figure 11-10.)

• To collapse the outline, click the Hide buttonsto the left of the rows or above the columnheadings.

• To remove the AutoOutline, choose Data Group and outline Clear Outline.

Get ready to

• Format cells and data

• Build formulas and functions

• Save time with Excel tools

• Add color graphics toyour spreadsheets

• Analyze your data

• Create charts and PivotTables

Table of Contents:

Ch. 1	Working with Excel files	5
Ch. 2	Entering spreadsheet data	13
Ch. 3	Building formulas	21
Ch. 4	Formatting cells and data	33
Ch. 5	Adding color and graphics	43
Ch. 6	Working with workbooks	53
Ch. 7	Changing worksheet views	67
Ch. 8	Sorting data	75
Ch. 9	Creating charts with Excel	85
Ch. 10	Printing workbooks	97
Ch. 11	Working with outlines	109
Ch. 12	Filtering data	117
Ch. 13	Creating pivot tables	127
Ch. 14	Building simple macros	139
Ch. 15	Saving time with Excel tools	145
Ch. 16	Creating a commission calculator	153
Ch. 17	Tracking medical expenses	159
Ch. 18	Planning for your financial future	167
Ch. 19	Integrating Excel into Word	171
Ch. 20	Blending Excel and PowerPoint	173
Ch. 21	Using Excel with Access	185

New interesting book: Eating Alive Prevention Thru Good Digestion or Awakening Your Sexuality

Steal This Computer Book 4.0: What They Won't Tell You about the Internet

Author: Wallace Wang

This offbeat, non-technical book examines what hackers do, how they do it, and how readers can protect themselves. Informative, irreverent, and entertaining, the completely revised fourth edition of Steal This Computer Book contains new chapters that discuss the hacker mentality, lock picking, exploiting P2P file sharing networks, and how people manipulate search engines and pop-up ads. Includes a CD with hundreds of megabytes of 100% FREE hacking and security-related programs that tie-in to each chapter in the book.