Absolute Beginner's Guide to Microsoft Office Excel 2003

by Kraynak, Joe E.

• ISBN13: 9780789729415
• ISBN10: 0789729415
• Edition: 1st
• Format: Paperback
• Copyright: 2003-09-11
• Publisher: Que Pub

Summary

Microsoft Excel 2003 is an incredibly versatile and easy-to-use spreadsheet program that helps users calculate and analyze numerical data.Absolute Beginner's Guide to Microsoft Office Excel 2003teaches new users to get the most from the latest version of the software. With the help of this book, users learn to: Create spreadsheets that include formulas and built-in Excel functions. Format numbers and text so that Excel printouts are easy to read. Use clip art, pictures, borders, and colors to add interest to spreadsheets. Take Excel data and publish it to the World Wide Web. Use the Excel Function Wizard to choose the right function to calculate the appropriate result. Use the Autoformat feature to quickly format an entire worksheet. Use the new speech feature for voice dictation and voice commands.

Author Biography

Joe Kraynak has taught hundreds of thousands of new PC users how to make the most of their computers with his easy-to-read books. Joe has been writing and editing successful training manuals and computer books for more than 12 years. His titles include Easy Internet, 5E, Que's Official Internet Yellow Pages 2003 Edition, and The Complete Idiot's Guide to Microsoft Office XP.

Table of Contents

Introduction	p. 1
A Book for the True Beginner	p. 1
How This Book is Organized	p. 1
Conventions Used in This Book	p. 3
Excel Worksheet Orientation Day	p. 5
Understanding Excel Worksheets (Spreadsheets)	p. 7
Starting and Navigating Excel	p. 21
Working with Workbook Files	p. 49
Creating Your First Worksheet	p. 69
Entering and Editing Labels and Values	p. 71
Controlling Rows, Columns, and Cells	p. 95
Automating Calculations with Formulas and Functions	p. 107
Formatting, Charting, and Printing Your Worksheet	p. 127
Formatting Your Worksheet	p. 129
Charting (Graphing) the Worksheet Data	p. 147
Inserting Clip Art and Other Graphics	p. 161
Printing and Protecting Your Workbook, Worksheets, and Charts	p. 185
Going Beyond the Basics	p. 203
Managing a Database with Excel	p. 205
Customizing Excel	p. 225
Automating Tasks with Macros	p. 243
Using Excel on the Web	p. 255
Using Excel's Speech and Handwriting Recognition Features	p. 273
Excel Shortcut Keys	p. 291
Index	p. 307
Table of Contents provided by Blackwell. All Rights Reserved.