Irvine Training Company                               www.IrvineTrainingCo.com
Excel 210
Excel 210 - Create templates;
Create charts, graphs and organization charts;
Insert and modify pictures and other graphics;
Insert comments and hyperlinks
1/2 day
Prerequisite: Excel 115 or equivalent
click here to return
     Two types of excel files: Workbooks and Templates
      What a template is and why you want to use templates
      Why you do not put a period in a file name
      Hands on - Create a workbook from an existing template
      Hands on - Create your own personal custom template

Comments and hyperlinks
     Hands on - Add a comment to a cell
      Hands on - Edit an existing comment
      Hands on - Delete a comment
      Hands on - Insert a hyperlink into a cell

Charts and Graphs
     Four standard types of Charts and Graphs
     Which of the four standard types is best for your purpose?
      Hands on - Create a chart
      Hands on - Change the chart legend location and change its format
      Hands on - Change the chart data labels and change their format
      Hands on - Change the chart title and change its format
      Hands on - Change the chart area background color
      Hands on - Change the chart type

Organization Charts
     Create an Organization Chart in your Excel Spreadsheet
      Add names to the boxes
      Add subordinates
      Add coworkers
      Change the font of some of the names
      Change the color of some of the boxes
      Change the arrangement of some of the boxes to make them fit better

Graphics
     Hands on - Insert a picture from your picture files
      Hands on - Insert a picture from clip art files
      Hands on - Resize a picture
      Hands on - Change the rotation angle of a picture
      Hands on - Create an arrow
      Hands on - Create a basic shape
      Hands on - Change the arrowhead, size, shape and color of the arrow
      Hands on - Change the size, shape(!) and color of the basic shape
      Hands on - Change the order of graphic objects
      Hands on - Move and copy graphic objects
      Hands on - Group and ungroup graphic objects
      Hands on - Put an attention-grabbing background in your chart