|
Module 2.1: Creating Charts
Lesson A. Creating A Chart Sheet
- A-1: Starting Microsoft Windows
and Excel
- A-2: Creating a Chart with the F11 Key
- A-3: Examining Chart Terminology
- A-4: Charting Non-Adjacent Worksheet Data
- A-5: Renaming Chart Sheets
Lesson B. Creating an Embedded Chart
- B-1: Creating a Pie Chart; Reviewing
the Chart Wizard Dialogue Boxes
- B-2: Moving an Embedded Chart
- B-3: Sizing an Embedded Chart; Deleting The Legend
- B-4: Examining the Link Between Worksheet Data and Charts
Lesson C. Comparing Chart Sheets with Embedded Charts
- C-1: Comparing
Chart Sheets with Embedded Charts
Practice Unit
Wrap-Up
Module 2.2: Modifying Charts
Lesson A. Chart Types
- A-1: Changing the Chart Type
- A-2: Observing Chart Sub-Types and Custom Chart Types
Lesson B. Modifying Embedded Charts
- B-1: Changing the Chart Type of
an Embedded Chart
- B-2: Exploding a Pie Slice
- B-3: Previewing the Printed Worksheet
- B-4: Working with Page Setup Options
Lesson C. Adding and Deleting Chart Items
- C-1: Adding and Editing
Titles
- C-2: Adding and Deleting Data Labels
- C-3: Adding Selected Data Labels
- C-4: Linking Chart Text to Worksheet Data
Lesson D. Moving and Sizing Chart Items
- D-1: Moving the Chart Title
- D-2: Moving the Legend
- D-3: Sizing the Plot Area
Practice Unit
Wrap-up
Module 2.3: Formatting a Chart
Lesson A. Formatting Chart Text
- A-1: Adding a Border Around
the Chart Title
- A-2: Changing the Font of All Chart Text
- A-3: Changing the Font of Individual Chart Text Items
- A-4: Changing the Alignment of Axis Labels
Lesson B. Formatting Labels
- B-1: Changing The Number Format and Alignment
Labels
Lesson C. Formatting the Chart
- C-1: Formatting the Plot Area
- C-2: Formatting the Data Markers
Lesson D. Printing a Chart Sheet
- D-1: Previewing the Formatted Chart
- D-2: Working with Page Setup Options
Practice Unit
Wrap-up
Module 2.4: Using Graphic Objects
Lesson A. Adding Graphic Objects
- A-1: Experimenting with The
Drawing Toolbar
- A-2: Changing the Order of Graphic Objects
- A-3: Moving and Copying Graphic Objects
Lesson B. Formatting Graphic Objects
- B-1: Formatting Graphic Objects
- B-2: Adding the 3-D Effect to the Text Box
- B-3: Deleting Objects
Lesson C. Using Graphic Objects to Enhance Worksheets And Charts
- C-1:
Using the Drawing Tools to Enhance the Worksheet
- C-2: Using the Drawing Tools to Enhance a Chart Sheet
Practice Unit
Wrap-up
Module 2.5: Sorting Data
Lesson A. Single-Level Sorting
- A-1: Exploring the Worksheet
Sort Data
- A-2: Sorting the List by Using Quick Sort
- A-3: Returning the List to Its Original Order
- A-4: Importing Data from a Text File
Lesson B. Multiple-Level Sorting
- B-1: Performing a Two-Level Sort
- B-2: Performing Consecutive Sorts
- B-3: Performing a Three-Level Sort
Lesson C. Sorting Options
- C-1: Using an Excel Custom Sort Order
- C-2: Creating Subtotals For a Sorted List
- C-3: Examining the Subtotals
Lesson D. Importing Data
- D-1: Importing Data From an Access Database
- D-2: Importing a Table From an HTML File
Lesson E. Design Considerations
- E-1: Considering Design Issues
- E-2: Creating and Using a Data Validation Rule
Practice Unit
Wrap-up
Module 2.6: Filtering Data
Lesson A. Filtering a List
- A-1: Single-Column Filtering
- A-2: Displaying the Entire List
- A-3: Using a Multiple-Column Filter to Create an AND Condition
- A-4: Removing a Single-Column Filter
- A-5: Finding Empty Cells and Non-Blank Cells
Lesson B. Custom Criteria
- B-1: Observing Single-Column AutoFiltering
- B-2: Using Custom Criteria to Create an OR Condition
- B-3: Filtering to Find a Range of Values
- B-4: Filtering by Using the * Wildcard
Lesson C. Multiple-Condition Criteria
- C-1: Observing the Limitations
of AutoFilter
- C-2: Turning off AutoFilter
- C-3: Entering Comparison Criteria in a Range
- C-4: Defining the Criteria Range; Completing the Filter
Lesson D. Managing a Filtered List
- D-1: Sorting a Filtered
List
- D-2: Using the AutoSum Button with a Filtered List
- D-3: Previewing the Filtered List
Practice Unit
Wrap-up
|
