Docstoc

Excel

Document Sample
Excel Powered By Docstoc
					     Excel

By: Brandon Honza
                 Step 1
• Take the CD on the table and put it into
  your computer. Open the Disc. Then
  click and drag the entire Excel folder to
  your desktop. You now have the
  practice Excel and the PowerPoint!
  What Can I Use Excel For?
• Data Collection
  – Making Groups
  – Reflection/Kid Talk
• Making Graphs
• Integration with Students
  Getting Started: The Basics
• Make a table, if you make a mistake and you have
  moved onto another slide you must double click to
  make a minor change
• If you do not double click it will erase everything
  which can be frustrating when you have data or a
  formula
• You can also click once on a cell and then use the
  formula bar to edit.
    Return/Tab Keys/Arrows
• To move from cell to cell you have 4
  options:
  – Click-chooses whatever cell your on
  – Arrow keys-follows direction of arrow
  – Return-drops down one cell
  – Tab-moves right one cell
               Toolbars
• Excel is much easier with toolbars. If
  you do not already have the following
  toolbars get them.
• Standard
• Formatting
• Formula Bar
     Formatting a Cell/Table
• Single cells: Click on the cell, go up to
  the Format Menu and select what you
  want. Most of the time this will be for
  column width or row height. Then you
  can type a number of inches. See next
  slide for shortcut.
    Shortcut on Cell Width or
             Height
• Using the ruler lining
  your spreadsheet move
  your arrow on top of a
  line separating either
  two columns or two
  rows. It will change to
  the icon to the right.
  Click hold down and
  drag to make it the
  desired size.
              Challenge
• Follow slide by slide. Take
  “Practice.xls” and change it according to
  the directions on each slide.
                     Page Set-up
• Excel’s default page is
  “Portrait” just like a
  word document. I find
  this does not work as
  well with Excel. Go to
  the “File” menu and go
  down to “Page Setup”.
  Change it to
  “Landscape” then hit
  the blue OK.
  Formatting Multiple Cells or
        Entire Tables
• Make sure you click,
  hold down, and drag
  to highlight the
  desire cells you
  want to change.
  Then go up to
  “Format” and go
  down to “Cells”.
                   Borders
• You’ll want to
  highlight the entire
  table in order to get
  a border. Click on
  the “outline” and
  “inside” to get a line
  around everything.
  Then use the lines
  to get rid of lines in
  particular places.
              Format of Numbers
• Click and highlight the
  numbers you wanted
  changed only. In this
  case it will be all the
  test scores. In the
  number section click on
  “percentage” and make
  any other changes you
  see fit. Go to next slide
  to see what your table
  should look like.
There are several options for
formatting numbers including
          currency.
             Formatting Alignment
• Click, hold down and
  drag to highlight only
  the categories in the
  chart. Click on the
  “Alignment” tab in the
  “Format Cell” box. Click
  and drag the red dot to
  your desired angle.
  See next slide for
  outcome.
Notice the Categories are
    Now at an Angle
               Formulas
• Excel is great because you can ask it to
  do math for you. If you ever want it to
  do a problem just start off by typing “=“.
  Now it knows you want it to computate
  something for it. If you click on any one
  of the percentages you will notice that it
  is does not say 90.00% but instead the
  problem it divided to find the percentage
  (ie- “=18/20”).
                Arithmetic
• You can do the following basic
  computations.
  – Adding (=34+22)
  – Subtracting (=55-33)
  – Multiplying (=20*5)
  – Dividing (=18/20)

  Note: To multiple do a shift 8 to get the star.
     More Difficult Formula
• This is where Excel is amazing. It
  knows you are going to want to do more
  advanced math so the “Formula Bar”
  will execute the more difficult math
  problems including: sum, average
  (mean), median, mode, minimum,
  maximum, and hundreds even more
  advanced.
 Execute an Average Formula
• We need to find the
  average of each student
  in spelling. Click in
  Dan’s Average cell and
  type “=“. Go over to the
  formula bar and click on
  the blue down arrow to
  find average. Go to
  next slide for continued
  directions.
                Average Continued
• A box will appear. You
  might have to move it
  by clicking and dragging
  it out of the way. Then
  click, hold down, and
  drag to highlight all 5 of
  Dan’s spelling tests.
  Click on the blue OK
  button.
Your Table Should Now Look
         Like This!




Repeat the process for Holly
  and Brad but then stop.
              Your New BFF “Fill”
• There is a short cut so you
  don’t have to do the
  formula’s over and over
  called “Fill”. Start at a cell
  that has the formula
  completed. Click on this
  cell, hold down, and then
  drag to highlight all cells
  you want to have that
  formula. Note all cells must
  be in a straight line. Now
  go to the “Edit” menu, go
  down to “Fill”, and select
  “Down”.
              Pretty Cool!!




• The reason you selected down was because
  you wanted the cells below to get the same
  formula. You can also go right, left, and up if
  the situation presents itself.
               Data Sort




• Now let’s sort the students by their
  percentages. Starting with “Dan” click and
  highlight all students and scores. Next go up
  to “Data” and go to “Sort”.
         Sorting Ascending or
              Descending




• A box will appear. In the “Sort By” box click on the blue arrows
  and change the sort to “Average”. Notice all the categories are
  in the box. Then choose Ascending if you want them to go from
  smallest to largest and descending for the opposite. Click the
  blue OK button.This also works with words for ABC order.
           Making a Graph




• Leslie should now be at the top. Click and
  highlight all the categories, Leslie, and all her
  data. Then go up to “Insert” and down to
  “Chart”.
               Bar Graph
• A box will open with
  all your selections
  for graphs. Choose
  the first bar graph.
  Then click on the
  “Next” button.
         Inserting Graphs
• The majority of graphs are pretty easy.
  The next box will show you a preview.
  You see Leslie’s tests graphed as well
  as her average. Hit the “Next” button
  again to go to another box for labeling
  the different categories. Lable if you
  want and then hit the “Next” button one
  more time.
             Sheet or object




• This final step gives you the option of creating the
  graph as a new sheet or object. Type Leslie’s name
  in the white box and make sure you have the blue dot
  in “As new sheet:”. Then hit the “Finish” button.
  Graph is Now in Your Tabs




• The graph will pop up and your table will
  disappear. The table is a different tab. To
  get back, simply click on the “Sheet 1” tab at
  the bottom of the page.
                Next Student
• The rest of the students
  will require an additional
  step. This time
  highlight Jordan’s name
  and data only. Do not
  highlight the categories.
  Go to “Insert”, to
  “Chart”, select the bar
  graph. At step 2 click
  on the “Series” tab.
         Getting Categories
• Click on the up
  arrow at the bottom
  of the box where it
  says “Category (X)
  axis labels:”. The
  box will shrink to
  one line so you can
  select the labels.
            Selecting Labels




• Click and hold down on “Test 1”. Then drag all the
  way to “Average”. A dotted box will be around the
  categories. Click on the down arrow in the small box
  to go back to the old box.
           Finishing Graph




• The rest of Jordan’s graph should be finished
  like Leslie’s. Note: If you ever make a
  mistake in your data and change a number
  the graphs are automatically updated.
          Super Challenge




• Go to “Sheet 2”. You will find another
  example table. Format the box so it has
  borders and align the categories to be 90˚.
  Refer to previous slides if you forgot.
     Changing Multiple Width’s or
              Height’s
• Sometimes you
  want multiple
  columns or rows to
  be the same size
  and you want to do
  them at the same
  time. Highlight the
  cells you want to be
  uniform.
             Column Width
• Go up to “Format”,
  go down to
  “Column”, and over
  to “Width”. A box
  will pop up. Type
  “.5” in the box then
  type the blue OK
  button.
             Finished Width
• Your table should
  now look like this.
  This will also work if
  you want to change
  multiple heights at
  one time.
    More Advanced Formulas
• Sometimes you don’t
  even need to type
  numbers. All you have
  to do is click in a cell.
  Point Differential is
  “Points For” take away
  “Points Against”. In the
  “Terps” “Point
  Differential” column
  type an “=“.
          Finishing Formula
• Now click on the
  Terps Point’s For
  Column (E6), hit the
  minus sign (-), click
  on the Points
  Against column
  (F6), and hit return.
  You now have your
  answer of 89.
                   Fill Down
• Click, hold down, and
  drag from the 89 down
  to the Celtics column
  and execute a “Fill”
  going down to find the
  other teams. You find
  out there was a mistake
  on the Terp’s Points For
  section. Change it to
  797. What happened to
  the point differential
  column?
          Winning Percentage
• Winning Percentage is
  “Wins” divided by “Total
  Games”. Click in the
  Terp’s Win Per. and
  type “=“. Click on their
  win column (C6), type
  /, and then click on their
  “Total Games” (B6). Hit
  return and do a fill
  down.
 Create a Chart on Your Own!




• Create any chart you want using the data.
       My Chart!

         Point Differential

150

100

 50

  0                                T e rps
         P o int Diffe re ntia l   T a rhe e ls
-50
                                   Bulls
-100
                                   La k e rs
-150                               C eltics

-200

-250

-300
              Teams

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:52
posted:8/8/2012
language:English
pages:45