MOUS Essentials Excel 2000 - Table of Contents
© Prentice Hall Inc.
A Pearson Education Company
Upper Saddle River, New Jersey 07458
Legal Statement
|
|
|
MOUS Essentials Excel 2000 - Table of Contents | |
| Project 1 | Getting Started with Excel 2000 |
| Lesson 1 | Exploring the Excel Workspace |
| Lesson 2 | Entering Text and Numbers |
| Lesson 3 | Saving a Workbook |
| Lesson 4 | Getting Help |
| Lesson 5 | Entering a Formula |
| Lesson 6 | Preparing a Worksheet for Printing |
| Lesson 7 | Printing a Worksheet |
| Lesson 8 | Closing a File and Exiting Excel |
| Project 2 | Modifying a Worksheet |
| Lesson 1 | Opening an Existing Worksheet |
| Lesson 2 | Selecting Worksheet Items |
| Lesson 3 | Using AutoFill |
| Lesson 4 | Inserting and Deleting Rows and Columns |
| Lesson 5 | Copying and Moving Cell Contents |
| Lesson 6 | Using AutoSum |
| Lesson 7 | Copying a Formula with Relative References |
| Lesson 8 | Spell-Checking a Worksheet
|
| Project 3 | Improving Worksheet Appearance |
| Lesson 1 | Formatting Numbers |
| Lesson 2 | Aligning Cell Contents |
| Lesson 3 | Changing Font and Font Size |
| Lesson 4 | Applying Bold, Italic and Underline |
| Lesson 5 | Adding Color |
| Lesson 6 | Adding Borders |
| Lesson 7 | Using Format Painter |
| Lesson 8 | Removing Formatting
|
| Project 4 | Entering Formulas |
| Lesson 1 | Working with Operators and Order of Precedence |
| Lesson 2 | Typing and Pointing Formulas |
| Lesson 3 | Comparing Absolute and Relative Cell References |
| Lesson 4 | Creating and Copying Formulas with Relative or Absolute Cell References |
| Lesson 5 | Freezing and Splitting Worksheet Display |
| Lesson 6 | Hiding and Unhiding Rows and Columns |
| Lesson 7 | Displaying Formulas Instead of Formula Results |
| Lesson 8 | Using Save As to Change File Name, File Type or Storage Location
|
| Project 5 | Working with Functions |
| Lesson 1 | Using AVERAGE, MAX and MIN |
| Lesson 2 | Calculating a Payment using PMT |
| Lesson 3 | Creating a Loan Payment Table |
| Lesson 4 | Evaluating Investment Plans with FV |
| Lesson 5 | Using IF to Display Messages |
| Lesson 6 | Using IF to Calculate |
| Lesson 7 | Using NOW and DATE |
| Lesson 8 | Using VLOOKUP to Convert Data
|
| Project 6 | Creating and Modifying Charts |
| Lesson 1 | Identifying Common Chart Types and Features |
| Lesson 2 | Using Chart Wizard to Create an Embedded Pie Chart |
| Lesson 3 | Using Chart Wizard to Create an Embedded Column Chart |
| Lesson 4 | Changing Chart Type |
| Lesson 5 | Charting Non-Adjacent Data Series |
| Lesson 6 | Modifying Chart Formulas |
| Lesson 7 | Adding, Removing and Reordering Data Series |
| Lesson 8 | Creating and Printing a Combination Chart
|
| Project 7 | Developing a Multiple-Sheet Workbook |
| Lesson 1 | Copying Data from Another Application |
| Lesson 2 | Renaming Worksheets |
| Lesson 3 | Edited Grouped Worksheets |
| Lesson 4 | Subtotaling Data |
| Lesson 5 | Linking Worksheets |
| Lesson 6 | Applying Conditional Formatting |
| Lesson 7 | Using a Worksheet to Solve a Problem |
| Lesson 8 | Saving a Worksheet with Chart as a web page
|
| Project 8 | Working with Custom Formats, Auto Formats, Templates and Styles |
| Lesson 1 | Inserting and Deleting Cells |
| Lesson 2 | Rotating and Indenting Text |
| Lesson 3 | Creating a Custom Format |
| Lesson 4 | Applying an Auto Format |
| Lesson 5 | Creating a Template |
| Lesson 6 | Editing and Applying a Template |
| Lesson 7 | Defining, Applying and Removing a Style |
| Lesson 8 | Sending an Excel File via Email
|
| Project 9 | Creating Special Effects in a Worksheet |
| Lesson 1 | Creating WordArt |
| Lesson 2 | Inserting and Rotating an AutoShape |
| Lesson 3 | Grouping Objects |
| Lesson 4 | Adding Emphasis with Lines and Arrows |
| Lesson 5 | Add Emphasis with Callouts |
| Lesson 6 | Inserting a Graphics File |
| Lesson 7 | Embedding Sound |
| Lesson 8 | Using Find and Replace
|
| Project 10 | Sorting, Filtering and Editing Lists |
| Lesson 1 | Using an Excel List as a Database |
| Lesson 2 | Sorting Records on One Field |
| Lesson 3 | Sorting Records on Two or More Fields |
| Lesson 4 | Using AutoFilter with One Condition |
| Lesson 5 | Using Custom AutoFilter: OR Criteria |
| Lesson 6 | Using Custom AutoFilter: AND Criteria |
| Lesson 7 | Using a Form to Add and Delete Records |
| Lesson 8 | Using a Form to Edit Records
|
| Project 11 | Documenting and Protecting Worksheets and Workbooks |
| Lesson 1 | Creating, Using and Deleting Range Names |
| Lesson 2 | Attaching, Editing and Deleting Comments |
| Lesson 3 | Getting Help on Security Features |
| Lesson 4 | Protecting Worksheet Contents and Objects |
| Lesson 5 | Unlocking Cells |
| Lesson 6 | Unlocking Objects |
| Lesson 7 | Viewing and Setting File Properties |
| Lesson 8 | Requiring a Password
|
| Project 12 | Guiding Cell Entry with Data Validation |
| Lesson 1 | Attaching an Input Message to a Cell |
| Lesson 2 | Restricting Cell Entries to Data in a List |
| Lesson 3 | Restricting Cell Entries to a Range |
| Lesson 4 | Creating an Error Alert Messages |
| Lesson 5 | Copying data Restrictions and Messages |
| Lesson 6 | Using Audit Tools to Find Invalid Data |
| Lesson 7 | Editing Errors in Validation Settings |
| Lesson 8 | Finding Cells with Data Restrictions
|
| Project 13 | Creating PivotTable and PivotChart Reports |
| Lesson 1 | Displaying Help on Pivot Tables and Related Charts |
| Lesson 2 | Creating a Pivot Table |
| Lesson 3 | Expanding a Pivot Table |
| Lesson 4 | Removing, Hiding and Showing |
| Lesson 5 | Refreshing a Pivot Table |
| Lesson 6 | Creating a Chart from Pivot Table Data |
| Lesson 7 | Applying Predefined Formats to a Pivot Table |
| Lesson 8 | Creating Interactive Pivot Tables for the Web
|
| Project 14 | Creating Consolidated Data, Outlines, Views and Reports |
| Lesson 1 | Consolidating Data in Multiple Worksheets |
| Lesson 2 | Consolidating Multiple Workbooks |
| Lesson 3 | Creating an Auto Outline |
| Lesson 4 | Creating a Manual Outline |
| Lesson 5 | Creating and Using Custom Views |
| Lesson 6 | Creating Reports Using Report Manager |
| Lesson 7 | Editing and Printing Reports Using Report Manager
|
| Projects 15 | Automating Tasks with Macros |
| Lesson 1 | Preparing to Record a Macro |
| Lesson 2 | Recording a Macro |
| Lesson 3 | Playing a Macro |
| Lesson 4 | Recording a Macro in a Personal Macro Workbook |
| Lesson 5 | Playing a Macro from the Personal Macro Workbook |
| Lesson 6 | Unhiding and Editing the Personal Macro Workbook |
| Lesson 7 | Creating a Macro Button in a Workbook |
| Lesson 8 | Adding a Macro Button to a Toolbar
|
| Project 16 | Using Goal Seek, Scenarios, Solver, and Auditing Tools |
| Lesson 1 | Using Audit Tools to Interpret Error Messages |
| Lesson 2 | Using Auditing Tools to Check Worksheet Formulas |
| Lesson 3 | Using Auditing Tools to "Reverse Engineer" a Worksheet |
| Lesson 4 | Using Goal Seek to Forecast Revenues |
| Lesson 5 | Performing What-if Analysis with Data Tables |
| Lesson 6 | Using Scenarios to Perform What-If Analyses |
| Lesson 7 | Using Solver to Maximize Profits |
| Lesson 8 | Using Solver to Minimize Costs
|
| Project 17 | Using Collaborative Tools and Creating HyperLinks |
| Lesson 1 | Tracking Changes in a Workbook |
| Lesson 2 | Accepting or Rejecting Changes |
| Lesson 3 | Sharing a Workbook |
| Lesson 4 | Using Hyperlinks within a Workbook |
| Lesson 5 | Using a Hyperlink in a Word Document to Reference Excel Data |
| Lesson 6 | Using a Hyperlink in a PowerPoint Slide to Reference Excel Data |
| Lesson 7 | Converting an Excel Workbook into a Web Page |
| Lesson 8 | Viewing and Editing an Excel Web Document
|
| Project 18 | Integrating Applications |
| Lesson 1 | Linking Excel Data to a Word Document |
| Lesson 2 | Embedding Excel Data in a Word Document |
| Lesson 3 | Linking Excel data to a PowerPoint Slide |
| Lesson 4 | Linking an Excel Chart to a PowerPoint Slide |
| Lesson 5 | Converting an Excel List to an Access Database |
| Lesson 6 | Importing Data from a Text File |
| Lesson 7 | Importing Data from an Access Database |
| Lesson 8 | Importing Data from an HTML File |
|
© Prentice Hall Inc. A Pearson Education Company Upper Saddle River, New Jersey 07458 Legal Statement |
|