Absolute Beginners Guide to Microsoft Office Excel 2003
Absolute Beginners Guide to Microsoft Office Excel 2003
ISBN: 0789729415
EAN: 2147483647
EAN: 2147483647
Year: 2002
Pages: 189
Pages: 189
Authors: Joe E. Kraynak
- Main Page
- Table of content
- Copyright
- About the Author
- Acknowledgments
- We Want to Hear from You
- Introduction
- A Book for the True Beginner
- How This Book Is Organized
- Conventions Used in This Book
- Part I: Excel Worksheet Orientation Day
- Chapter 1. Understanding Excel Worksheets (Spreadsheets)
- What Is a Worksheet?
- What Is a Workbook?
- Examining Columns, Rows, and Cells
- Understanding Cell Addresses
- Understanding Formulas and Functions
- Making Data Graphical with Charts
- Chapter 2. Starting and Navigating Excel
- Starting Excel
- Touring Excel s Program Window
- Touring Excel s Workbook Window
- Using the Toolbars
- Selecting Commands from Menus
- Making Selections in Dialog Boxes
- Maneuvering in Excel s Task Panes
- Getting Help
- Exiting Excel
- Chapter 3. Working with Workbook Files
- Starting with an Excel Workbook Template
- Creating Workbooks from Scratch
- Saving and Naming Your Workbook
- Saving a Workbook as a Template
- Opening a Saved Workbook
- Managing Worksheets
- Part II: Creating Your First Worksheet
- Chapter 4. Entering and Editing Labels and Values
- Understanding Types of Data Entries
- Moving from Cell to Cell
- Entering Data
- Entering Data Quickly with Auto Fill
- Viewing and Using Smart Tags
- Editing Data Entries
- Selecting Cells
- Copying and Moving Data
- Undoing Actions and Commands
- Chapter 5. Controlling Rows, Columns, and Cells
- Changing Column Widths
- Changing Row Heights
- Wrapping Text in Cells
- Merging Cells
- Locking Headings in Place with Freeze Panes
- Inserting Rows and Columns
- Inserting Cells
- Deleting Rows and Columns
- Deleting Cells
- Chapter 6. Automating Calculations with Formulas and Functions
- Learning the Order of Operations
- Entering Formulas
- Editing Formulas
- Copying and Pasting Formulas
- Changing the Recalculation Setting
- Using the Auto Calculate Feature
- Doing Higher Math with Functions
- Troubleshooting Errors in Formulas
- Playing What If? with Scenarios
- Part III: Formatting, Charting, and Printing Your Worksheet
- Chapter 7. Formatting Your Worksheet
- Letting Excel Design Your Worksheet with AutoFormat
- Changing the Appearance of Entries
- Adding Cell Borders
- Adding Shading to Cells
- Using Conditional Formatting to Flag Entries
- Copying Formatting with the Format Painter
- Formatting with Styles
- Chapter 8. Charting (Graphing) the Worksheet Data
- Understanding Charting Terminology
- Creating a Chart
- Formatting Text on a Chart
- Formatting the Chart Axes
- Enhancing the Chart Frame
- Changing the Appearance of 3-D Charts
- Chapter 9. Inserting Clip Art and Other Graphics
- Working with Graphic Objects
- Inserting Clip Art and Other Graphics
- Resizing and Reshaping Your Pictures
- Touching Up Images with the Picture Toolbar
- Inserting WordArt Objects
- Adding Text Outside a Cell
- Drawing Your Own Pictures from Scratch
- Working with Layers of Objects
- Changing an Object s Appearance
- Creating an Organization Chart
- Chapter 10. Printing and Protecting Your Workbook, Worksheets, and Charts
- Previewing Your Worksheets Before Printing
- Changing the Page Setup
- Checking and Adjusting Page Breaks
- Hiding Columns and Rows
- Printing Your Worksheets
- Previewing and Printing Charts
- Preventing Unauthorized Changes to a Workbook
- Part IV: Going Beyond the Basics
- Chapter 11. Managing a Database with Excel
- What Is a Database?
- Database Terminology
- Creating Your Database
- Finding Records in Your Database
- Sorting Your Records
- Narrowing Your List with AutoFilter
- Summarizing and Comparing Data with Pivot Tables
- Chapter 12. Customizing Excel
- Customizing Excel s Toolbars
- Reconfiguring Excel s Menus
- Creating Your Own Menus
- Setting Toolbar and Menu Options
- Changing Excel s Default Settings
- Installing Optional Components
- Chapter 13. Automating Tasks with Macros
- What Is a Macro?
- Recording a Macro
- Running a Macro
- Creating a Toolbar Button for Your Macro
- Editing Macros in Visual Basic Editor
- Protecting Your System Against Macro Viruses
- Chapter 14. Using Excel on the Web
- Transforming Worksheets into Web Pages
- Inserting Links on Your Worksheets
- Publishing Your Worksheets on the Web
- Importing Data from the Web into Your Worksheets
- E-mailing Your Worksheet
- Saving Your Workbook as an XML File
- Chapter 15. Using Excel s Speech and Handwriting Recognition Features
- Making Sure You Have the Essential Equipment
- Checking Your Sound System
- Installing Speech Recognition
- Training Excel to Recognize Your Voice
- Dictating Your Entries
- Entering Voice Commands
- Handwriting Your Entries
- Part V: Appendixes
- Appendix A. Excel Shortcut Keys
- Glossary
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J-K-L
- M
- N
- O
- P
- Q-R
- S
- T
- U-V
- W
- X-Y-Z
- Index
- Index SYMBOL
- Index A
- Index B
- Index C
- Index D
- Index E
- Index F
- Index G
- Index H
- Index I
- Index K
- Index L
- Index M
- Index N
- Index O
- Index P
- Index Q
- Index R
- Index S
- Index T
- Index U
- Index V
- Index W
- Index X
Absolute Beginners Guide to Microsoft Office Excel 2003
ISBN: 0789729415
EAN: 2147483647
EAN: 2147483647
Year: 2002
Pages: 189
Pages: 189
Authors: Joe E. Kraynak