| Introduction | |
| Excel Worksheet Orientation Day | |
| 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 | |
| Starting and Navigating Excel | |
| Starting Excel | |
| Touring Excels Program Window | |
| Touring Excels Workbook Window | |
| Using the Toolbars | |
| Selecting Commands from Menus | |
| Making Selections in Dialog Boxes | |
| Maneuvering in Excels Task Panes | |
| Getting Help | |
| Exiting Excel | |
| 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 | |
| Creating Your First Worksheet | |
| Entering and Editing Labels and Values | |
| Understanding Types of Data Entries | |
| Moving from Cell to Cell | |
| Entering Data | |
| Entering Data Quickly with AutoFill | |
| Viewing and Using Smart Tags | |
| Editing Data Entries | |
| Selecting Cells | |
| Copying and Moving Data | |
| Undoing Actions and Commands | |
| 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 | |
| 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 | |
| Formatting, Charting, and Printing Your Worksheet | |
| 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 | |
| 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 3D Charts | |
| 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 Objects Appearance | |
| Creating an Organization Chart | |
| 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 | |
| Going Beyond the Basics | |
| 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 | |
| Customizing Excel | |
| Customizing Excels Toolbars | |
| Reconfiguring Excels Menus | |
| Setting Toolbar and Menu Options | |
| Changing Excels Default Settings | |
| Installing Optional Components | |
| 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 | |
| Using Excel on the Web | |
| Table of Contents provided by Publisher. All Rights Reserved. |