Return to Main CISD Home Page CISD Schools CISD Departments What's New in CISD CISD Help Desk Services Please Email us your comments. Conroe Independent School District

Conroe Independent School District
Technology Competencies
 
Intermediate Spreadsheets
Description: First, this course guides participants through Excel’s charting features. Participants learn how to create and edit charts; modify chart options; format chart objects; work with multiple worksheets and workbooks. teachers also gain
hands-on experience using styles, custom formats, and conditional formatting.
Prerequisite Skills: Introduction to Spreadsheets
Outline
A. Working with Charts
  1. Creating a Chart
  2. Modifying a Chart
  3. Previewing and Printing a Chart
  4. Deleting a Chart
B. Modifying Chart Options
  1. Modifying Titles and Labels
  2. Modifying Axes, Gridlines, and Legends
  3. Working with Data Tables
  4. Changing the Data Range
  5. Working with Data Series
C. Formatting Charts
  1. Activating Chart Objects
  2. Changing Colors, Borders, and Patterns
  3. Changing Font and Number Formatting
  4. Formatting Axes and Gridlines
  5. Formatting Data Series and Chart Area Options
D. Customizing Worksheets and Working with Formats
  1. Creating Borders
  2. Creating Custom Number Formats
  3. Freezing and Splitting Panes
  4. Text Rotation
E. Working with Graphics
  1. Inserting Clipart
  2. Drawing Objects
  3. Grouping Objects
  4. Ordering Objects
  5. Inserting WordArt
 F. Working with AutoFilter Feature
  1. Working with Filtered Data
  2. Removing AutoFilter
  3. Creating a Custom AutoFilter
G. Performing Calculations
  1. Using Range Names in Formulas
  2. Displaying List of Worksheet Functions
  3. Using Advanced Functions
  4. Using Relative, Absolute, and Mixed References
  5. Understanding Relative and Absolute Formulas
  6. Creating an Absolute Reference
  7. Creating a Mixed Reference
H. Working with Multiple Worksheets and Workbooks
  1. Working Across Worksheets and Workbooks
  2. Working with Multiple Sheet Formulas
  3. Consolidating Information
  4. Inserting and Deleting Worksheets
  5. Hiding Columns
  6. Linking Information Between Workbooks
I. Printing
  1. Setting Page Breaks
  2. Printing Page Order
  3. Printing Selected Ranges
  4. Specify Printers