| |
| |
| Project | |
| |
| |
| |
| Advanced Formatting | |
| |
| |
| |
| Apply Number Formats | |
| |
| |
| |
| Create Custom Formats | |
| |
| |
| |
| Use Styles and AutoFormats | |
| |
| |
| |
| Using Conditional Formatting | |
| |
| |
| Project | |
| |
| |
| |
| Using Charts and Maps | |
| |
| |
| |
| Creating a Chart | |
| |
| |
| |
| Formatting Text in a Chart | |
| |
| |
| |
| Changing the Chart Type | |
| |
| |
| |
| Enhancing a Chart | |
| |
| |
| |
| Printing a Chart | |
| |
| |
| |
| Creating a Data Map | |
| |
| |
| Project | |
| |
| |
| |
| Creating More Complex Charts | |
| |
| |
| |
| Formatting a Chart with Predefined Formats | |
| |
| |
| |
| Creating a Custom Chart Format | |
| |
| |
| |
| Adding a Trend Line to a Chart | |
| |
| |
| |
| Adding a Data Table to a Chart | |
| |
| |
| |
| Grouping Charts together | |
| |
| |
| Project | |
| |
| |
| |
| Managing Multiple Worksheets and Workbooks | |
| |
| |
| |
| Editing Multiple Worksheets Simultaneously | |
| |
| |
| |
| Building and Organizing a Multiple-Sheet Workbook | |
| |
| |
| |
| Moving and Copying Worksheets between Workbooks | |
| |
| |
| |
| linking Cell Data across Workbooks | |
| |
| |
| |
| Annotating a Worksheet with Comments | |
| |
| |
| |
| Annotating a Worksheet with Text Boxes | |
| |
| |
| |
| Previewing and Printing Workbooks | |
| |
| |
| |
| Managing Multiple Workbooks | |
| |
| |
| Projects | |
| |
| |
| |
| Personalizing the Excel Workplace | |
| |
| |
| |
| Changing Excel's Default Settings | |
| |
| |
| |
| Viewing and Moving Toolbars | |
| |
| |
| |
| Customizing a Toolbar | |
| |
| |
| |
| Creating a New Toolbar | |
| |
| |
| |
| Adding Menus to Toolbars and Buttons to Menus | |
| |
| |
| |
| Zooming In and Out on a Worksheet | |
| |
| |
| |
| Splitting and Freezing Window Panes | |
| |
| |
| |
| Arranging Multiple Windows | |
| |
| |
| |
| Using Summary Information | |
| |
| |
| Project | |
| |
| |
| |
| Using Excel with Other Programs | |
| |
| |
| |
| Switching Among Applications | |
| |
| |
| |
| Copying Data between Applications | |
| |
| |
| |
| Linking Data between Applications | |
| |
| |
| |
| Working with Embedded Data | |
| |
| |
| |
| Saving Files in Other Formats | |
| |
| |
| |
| Importing Data from Other Applications | |
| |
| |
| Project | |
| |
| |
| |
| Automating Tasks with Macros | |
| |
| |
| |
| Preparing to Record a Macro | |
| |
| |
| |
| Recording a Macro | |
| |
| |
| |
| Playing a Macro | |
| |
| |
| |
| Recording a Macro to the Personal Macro Workbook | |
| |
| |
| |
| Playing a Macro from the Personal Macro Workbook | |
| |
| |
| |
| Unhiding and Editing the Personal Macro Workbook | |
| |
| |
| |
| Creating a Macro Button in a Workbook | |
| |
| |
| |
| Adding a Macro Button to a Toolbar | |
| |
| |
| Project | |
| |
| |
| |
| Managing Data | |
| |
| |
| |
| Naming a List | |
| |
| |
| |
| Adding Records | |
| |
| |
| |
| Sorting Records | |
| |
| |
| |
| Finding and Deleting Records | |
| |
| |
| |
| Extracting Records Using AutoFilter | |
| |
| |
| Project | |
| |
| |
| |
| Designing Forms with Excel | |
| |
| |
| |
| Adding a Check Box to Worksheet | |
| |
| |
| |
| Adding an Option Button to a Worksheet | |
| |
| |
| |
| Adding a Combo Box and Link to a Worksheet | |
| |
| |
| |
| Adding a Spinner to a Worksheet | |
| |
| |
| |
| Enhancing a Form Lesson Protecting a Form | |
| |
| |
| |
| Saving a Form as a Template | |
| |
| |
| |
| Using a Form Template | |
| |
| |
| Lesson Editing Templates | |
| |
| |
| Project | |
| |
| |
| |
| Creating Summary Reports | |
| |
| |
| |
| Creating an Outline from an Existing Report | |
| |
| |
| |
| Charting an Outline | |
| |
| |
| |
| Creating Subtotal Reports | |
| |
| |
| |
| Creating Multiple Subtotal Rows | |
| |
| |
| |
| Consolidating Your Worksheets | |
| |
| |
| Project | |
| |
| |
| |
| Creating Custom Reports with Pivot Tables | |
| |
| |
| |
| Using the Pivot Table Wizard | |
| |
| |
| |
| Rearranging Data in the Pivot table | |
| |
| |
| |
| Adding Data to a Pivot Table | |
| |
| |
| |
| Adding and Changing a Pivot Table Summary Function | |
| |
| |
| |
| Hiding and Showing Pivot Table Details | |
| |
| |
| |
| Formatting Your Pivot Table | |
| |
| |
| Project | |
| |
| |
| |
| Comparing Data with Advanced Pivot Tables | |
| |
| |
| |
| Updating a List | |
| |
| |
| |
| Refreshing Pivot Tables | |
| |
| |
| |
| Adding Fields to a List | |
| |
| |
| |
| Editing a Pivot Table | |
| |
| |
| |
| Grouping Data in a Pivot Table | |
| |
| |
| |
| Creating a Chart from Pivot Table Data | |
| |
| |
| |
| Changing the Pivot Table View and Updating a Chart | |
| |
| |
| Project | |
| |
| |
| |
| Using Advanced Data Analysis Techniques | |
| |
| |
| Lesson 1 | |
| |
| |
| Lesson 2 | |
| |
| |
| Lesson 3 | |
| |
| |
| Lesson 4 | |
| |
| |
| Lesson 5 | |
| |
| |
| Lesson 6 | |
| |
| |
| Lesson 7 | |
| |
| |
| Project | |
| |
| |
| |
| Sharing Workbooks on the Network | |
| |
| |
| Lesson 1 | |
| |
| |
| Lesson 2 | |
| |
| |
| Lesson 3 | |
| |
| |
| Lesson 4 | |
| |
| |
| Lesson 5 | |
| |
| |
| Appendices | |
| |
| |
| Working with Windows | |
| |
| |
| 95 Glossary | |
| |
| |
| Student Exam Preparation Guide | |