Essentials

PROJECT 1. GETTING STARTED WITH EXCEL.

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 Workbook.
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 THE APPEARANCE OF A WORKSHEET.

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 FORMULA IN WELL-DESIGNED WORKSHEETS.

Lesson 1. Working with Operators and Order of Precedence.
Lesson 2. Using Type-and-Point to Enter Formulas.
Lesson 3. Comparing Absolute and Relative Cell References.
Lesson 4. Creating and Copying Formulas with Absolute or Relative 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 the Filename, File Type or Storage Location.
PROJECT 5. WORKING WITH FUNCTIONS.

Lesson 1. Analyzing Data with AVERAGE, MAX and MIN.
Lesson 2. Calculating a Loan Payment with 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 to Display the Current Date.
Lesson 8. Using Dates in Calculations.
PROJECT 6. SORTING, FILTERING AND EDITING LISTS.

Lesson 1. Using an Excel List as a Database.
Lesson 2. Sorting Records on the Content of One Field.
Lesson 3. Sorting Records on the Contents of Two or More Fields.
Lesson 4. Using AutoFilter with One Search Condition.
Lesson 5. Using Custom AutoFilter with OR Search Criteria.
Lesson 6. Using Custom AutoFilter with AND Search Criteria.
Lesson 7. Adding and Deleting Records Using a Form.
Lesson 8. Editing Records Using a Form.
PROJECT 7. WORKING WITH 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 the Chart Type.
Lesson 5. Charting Non-Adjacent Data Series.
Lesson 6. Modifying Chart Formats.
Lesson 7. Adding, Reordering and Deleting a Data Series.
Lesson 8. Creating and Printing a Combination Chart.
PROJECT 8. DEVELOPING A MULTIPLE-SHEET WORKBOOK.

Lesson 1. Copying Data from Another Application.
Lesson 2. Inserting, Moving, Renaming Worksheets.
Lesson 3. Editing Multiple Worksheets Simultaneously.
Lesson 4. Subtotaling Data.
Lesson 5. Linking Worksheets.
Lesson 6. Applying Conditional Formatting.
Lesson 7. Setting a Print Area.
Lesson 8. Saving a Worksheet with Chart as a Web Page.