| |
| |
| Introduction | |
| |
| |
| |
| Starting and Exiting Excel | |
| |
| |
| Starting Excel | |
| |
| |
| A Look at the Excel Screen | |
| |
| |
| Exiting Excel | |
| |
| |
| |
| Creating and Opening Workbook Files | |
| |
| |
| Creating a New Workbook | |
| |
| |
| Opening an Existing Workbook | |
| |
| |
| Finding a Workbook File | |
| |
| |
| |
| Saving and Closing Workbook Files | |
| |
| |
| Saving and Naming a Workbook | |
| |
| |
| Saving a Workbook Under a Name | |
| |
| |
| Closing Workbooks | |
| |
| |
| |
| Using Excel's Toolbars | |
| |
| |
| Using the Toolbars | |
| |
| |
| Turning Toolbars On and Off | |
| |
| |
| Moving Toolbars | |
| |
| |
| Customizing the Toolbars | |
| |
| |
| |
| Getting Around Excel | |
| |
| |
| Moving from Worksheet to Worksheet | |
| |
| |
| Moving from Workbook to Workbook | |
| |
| |
| Moving Within a Worksheet | |
| |
| |
| |
| Getting Help | |
| |
| |
| Asking the Office Assistant for Help | |
| |
| |
| Helping Yourself | |
| |
| |
| |
| Beyond Help | |
| |
| |
| Going Online to Get Help | |
| |
| |
| Turning the Office Assistant On or Off | |
| |
| |
| Changing to a Different Office Assistant | |
| |
| |
| Getting Help with Screen Elements | |
| |
| |
| |
| Changing How You View Your Worksheet | |
| |
| |
| Magnifying and Reducing the Worksheet View | |
| |
| |
| Freezing Column and Row Labels | |
| |
| |
| Splitting Worksheets | |
| |
| |
| Hiding Workbooks, Worksheets, Columns, and Rows | |
| |
| |
| |
| Entering Different Types of Data | |
| |
| |
| Entering Text | |
| |
| |
| Entering Numbers | |
| |
| |
| Entering Dates and Times | |
| |
| |
| Copying (Filling) the Same Data to Other Cells | |
| |
| |
| Entering a Series of Numbers, Dates, and Other Data | |
| |
| |
| Entering the Same Data in a Column Over and Over | |
| |
| |
| |
| Correcting Your Entries | |
| |
| |
| Making Changes to Data | |
| |
| |
| Undoing an Action | |
| |
| |
| Finding and Replacing Data | |
| |
| |
| Checking Your Spelling | |
| |
| |
| |
| Working with Ranges | |
| |
| |
| What Is a Range? | |
| |
| |
| Selecting a Range | |
| |
| |
| Naming Ranges | |
| |
| |
| |
| Copying, Moving, and Deleting Ranges | |
| |
| |
| Copying Data | |
| |
| |
| Moving Data | |
| |
| |
| Using the Office Clipboard to Copy or Move Multiple Items | |
| |
| |
| Deleting Data | |
| |
| |
| |
| Inserting and Removing Cells, Rows, and Columns | |
| |
| |
| Inserting Rows and Columns | |
| |
| |
| Removing Rows and Columns | |
| |
| |
| Merging Cells Together to Form One Large Cell | |
| |
| |
| Inserting Cells Between Existing Data | |
| |
| |
| Removing Cells by Shifting Data | |
| |
| |
| |
| Changing Column Width and Row Height | |
| |
| |
| Adjusting Column Width and Row Height with a Mouse | |
| |
| |
| Using the Format Menu for Precise Control | |
| |
| |
| |
| Managing Your Worksheets | |
| |
| |
| Selecting Worksheets | |
| |
| |
| Inserting Worksheets | |
| |
| |
| Deleting Worksheets | |
| |
| |
| Moving and Copying Worksheets | |
| |
| |
| Changing Worksheet Tab Names | |
| |
| |
| |
| Printing Your Workbook | |
| |
| |
| Changing the Page Setup | |
| |
| |
| Previewing a Print Job | |
| |
| |
| Printing Your Workbook | |
| |
| |
| |
| Printing Large Worksheets | |
| |
| |
| Selecting a Print Area | |
| |
| |
| Adjusting Page Breaks | |
| |
| |
| Printing Column and Row Labels on Every Page | |
| |
| |
| Adding Headers and Footers | |
| |
| |
| Scaling a Worksheet to Fit on a Page | |
| |
| |
| |
| Performing Calculations with Formulas | |
| |
| |
| Understanding Excel Formulas | |
| |
| |
| Order of Operations | |
| |
| |
| Entering Formulas | |
| |
| |
| Displaying Formulas | |
| |
| |
| Editing Formulas | |
| |
| |
| |
| Copying Formulas and Recalculating | |
| |
| |
| Copying Formulas | |
| |
| |
| Using Relative and Absolute Cell Addresses | |
| |
| |
| Controlling When Your Worksheet Is Recalculated | |
| |
| |
| |
| Performing Calculations with Functions | |
| |
| |
| What Are Functions? | |
| |
| |
| Using the Function Wizard | |
| |
| |
| |
| Changing How Numbers Look | |
| |
| |
| Using the Style Buttons to Format Numbers | |
| |
| |
| Formatting Values | |
| |
| |
| Copying Formats with Format Painter | |
| |
| |
| |
| Giving Your Text a New Look | |
| |
| |
| How You Can Make Text Look Different | |
| |
| |
| Changing Text Attributes with Toolbar Buttons | |
| |
| |
| Aligning Text in Cells | |
| |
| |
| Changing Text Attributes with the Format Cells Dialog Box | |
| |
| |
| |
| Adding Cell Borders and Shading | |
| |
| |
| Adding Borders to Cells | |
| |
| |
| Adding Shading to Cells | |
| |
| |
| Using AutoFormat | |
| |
| |
| Applying Conditional Formatting | |
| |
| |
| |
| Creating Charts | |
| |
| |
| Charting Terminology | |
| |
| |
| Chart Types | |
| |
| |
| Creating a Chart | |
| |
| |
| Saving Charts | |
| |
| |
| Printing a Chart | |
| |
| |
| |
| Enhancing Your Charts | |
| |
| |
| Selecting a Chart Part | |
| |
| |
| The Chart Toolbar | |
| |
| |
| Changing the Chart Type | |
| |
| |
| Adding a Title and a Legend | |
| |
| |
| Formatting Text and Numbers on a Chart | |
| |
| |
| Enhancing the Chart Area | |
| |
| |
| |
| More Ways to Enhance Charts | |
| |
| |
| Displaying or Hiding Gridlines | |
| |
| |
| Changing the Start and Stop Values of the Value Axis | |
| |
| |
| Changing the Category Axis | |
| |
| |
| Changing the Perspective of 3D Charts | |
| |
| |
| Selecting Data Series Options | |
| |
| |
| Changing Data Series Values | |
| |
| |
| |
| Saving and Publishing Workbooks to the Internet | |
| |
| |
| Saving a Workbook to an FTP Site | |
| |
| |
| Saving a Workbook in HTML Format | |
| |
| |
| Publishing Interactive Data | |
| |
| |
| Adding Hyperlinks to a Worksheet | |
| |
| |
| |
| Working with a Database | |
| |
| |
| Database Basics | |
| |
| |
| Planning a Database | |
| |
| |
| Creating a Database | |
| |
| |
| Using Data Forms to Add, Edit, or Delete Records | |
| |
| |
| |
| Finding and Sorting Data in a Database | |
| |
| |
| Finding Data with a Data Form | |
| |
| |
| Sorting Data in a Database | |
| |
| |
| Narrowing Your List with AutoFilter | |
| |
| |
| |
| Adding Graphics and Other Objects to Worksheets | |
| |
| |
| Working with Graphic Objects | |
| |
| |
| Inserting Clip Art | |
| |
| |
| Adding Your Own Clip Art, Video Clips, or Sound Clips to the Gallery | |
| |
| |
| Drawing Your Own Pictures | |
| |
| |
| Index | |