Teach Yourself VISUALLY Excel 2003, 2nd Edition View Larger Image | Sherry Kinkoph
Wiley, Paperback, 2nd edition, Published September 2005, 320 pages, ISBN 0764596888 | List Price: $24.99
Our Price: $16.50
You Save: $8.49 (34% Off)
| | | Availability: Out-Of-Stock |
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
Are you a visual learner? Do you prefer instructions that show you how to do something
- and skip the long-winded explanations? If so, then this book is for you. Open
it up and you'll find clear, step-by-step screen shots that show you how to tackle
more than 120 Excel 2003 tasks. Each task-based spread includes these great features
to get you up and running on Excel 2003 in no time:
• Helpful sidebars that offer practical tips and tricks
• Succinct explanations that walk you through step by step
• Full-color screen shots that demonstrate each task
•Two-page lessons that break big topics into bite-sized modules
Learn How To:
• Work with task panes and toolbars
• Assign workbook passwords
• Enter data with AutoFill
• Reference absolute and relative cells
• Increase or decrease decimals
• Create charts with Chart Wizard
Table of Contents
Chapter 1: Excel Basics.
An Introduction to Excel.
Start and Close Excel.
Navigate the Excel Program Window.
Work with Task Panes.
Display and Hide Toolbars.
Finding Help.
Chapter 2: Workbook Fundamentals.
Start a New Workbook File.
Save a Workbook.
Open an Existing Workbook.
Close a Workbook.
Delete a Workbook.
Find a Workbook.
Arrange Workbook Windows.
Assign a Workbook Password.
Chapter 3: Working with Worksheets.
Understanding Worksheet Structure.
Navigate Worksheets.
Name a Worksheet.
Add a Worksheet.
Delete a Worksheet.
Move a Worksheet.
Copy a Worksheet.
Format Worksheet Tab Color.
Protect Worksheet Data.
Chapter 4: Entering Data.
Enter Data.
Turn On Text Wrapping.
Resize Columns and Rows.
Select Cells.
Enter Data with AutoFill.
Work with AutoCorrect.
Edit Data.
Work with Smart Tags.
Spell Check a Worksheet.
Chapter 5: Working with Formulas and Functions.
Understanding Formulas.
Create Formulas.
Reference Absolute and Relative Cells.
Copy Formulas.
Name Cells and Ranges.
Reference Ranges in Formulas.
Reference Cells from Other Worksheets.
Understanding Functions.
Apply a Function.
Total Cells with AutoSum.
Check for Formula Errors.
Audit a Worksheet for Errors.
Chapter 6: Rearranging Worksheet Data.
Move and Copy Data.
Delete Data or Cells.
Add Columns and Rows.
Delete Columns and Rows.
Center Data across Columns.
Transpose Columns and Rows.
Set Column Width and Row Height.
Hide Columns and Rows.
Freeze a Column or Row.
Split a Worksheet into Panes.
Find and Replace Data.
Chapter 7: Formatting Worksheets.
Apply Bold, Italics, and Underlining.
Change the Font and Size.
Change Number Formats.
Increase or Decrease Decimals.
Change Data Color.
Format Data with AutoFormat.
Align Cell Data.
Rotate Cell Data.
Control Text Wrap.
Add Borders.
Add Background Color to Cells.4
Assign a Background to a Worksheet.
Copy Cell Formatting.
Create a Style.
Assign Conditional Formatting.
Chapter 8: Adding Graphics.
Insert Image Files.
Insert Clip Art.
View Clip Art with the Clip Organizer.
Download Clip Art from the Web.
Draw AutoShapes.
Draw Lines and Arrows.4
Add a WordArt Object.
Move and Resize Objects.
Rotate and Flip Objects.
Crop a Picture.
Add Shadow and 3-D Effects.
Format an Object.
Group and Ungroup Objects.
Chapter 9: Previewing and Printing.
Add Headers and Footers.
Insert Page Breaks.
Preview a Worksheet.
Set Up Printing Options.
Print a Worksheet.
Define a Print Area
Chapter 10: Working with Charts.
Understanding Excel Charts.
Create a Chart with Chart Wizard.
Move and Resize Charts.
Change the Chart Type.
Change the Axes Titles.
Format Chart Objects.
Add Chart Objects.
Change the Chart Data
Chapter 11: Analyzing Worksheet Data.
Understanding Database Lists.
Create a Database List.
Add Records Using a Data Form.
Edit Records.
Search for Records.
Add Subtotals to a List.
Set Data Validation Rules.
Sort Records.
Filter Data with AutoFilter.
Analyze Data with a PivotTable.
Chapter 12: Using Excel Tools.
Add a Watch Window.
Load Add-Ins.
Using Data Analysis Tools.
Using Goal Seek.
Create Scenarios.
Using Solver.
Chapter 13: Sharing Excel Data.
Link Data.
Edit Linked Data.
Link between Worksheets.
Embed Objects.
Enable Workbook Sharing.
Add a Comment.
Track and Review Workbook Changes.
Merge Workbooks.
E-mail a Workbook.
Import Data.
Export Data
Chapter 14: Using Excel on the Web.
Create an HTML File.
Preview a Worksheet as a Web Page.
Set Alternative Text for an Object.
Insert a Hyperlink.
Download a Stock Quote.
Using the Web Toolbar.
Copy Web Data to a Worksheet.
Run a Web Query.
Chapter 15: Improving Excel Efficiency.
Customize the Excel Program Window.
Customize Toolbars.
Create a Custom Toolbar Button.
Add a Calculator.
Customize Menus.
Change the Default Font.
Change the Default File Location.
Open a Workbook Automatically.
Define Workbook Properties.
Play Back Worksheet Data.
Record a Macro.
Create an Excel Template.
Apply an Excel Template.
About the Author
Sherry Willard Kinkoph has written and edited more than 70 books over the past
10 years covering a variety of computer topics ranging from hardware to software,
from Microsoft Office programs to the Internet. Her recent titles include Master
VISUALLY eBay Business Kit, Teach Yourself VISUALLY Photoshop Elements 3.0,
and Top 100 Simplified Tips and Tricks Office 2003. Sherry’s ongoing quest
is to help users of all levels master the ever-changing computer technologies.
No matter how many times they — the software manufacturers and hardware
conglomerates — throw out a new version or upgrade, Sherry vows to be there
to make sense of it all and help computer users get the most out of their machines.
|
