Absolute Beginners Guide to Microsoft Office Excel 2003 - page 1
- Main Page
- 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
