Docstoc

_01_Intro_Workbook

Document Sample
_01_Intro_Workbook Powered By Docstoc
					      Introduction Excel
      Table of Contents
  Nolan Tomboulian 252-675-0176
     TOMBOULIAN@YAHOO.com
       HTTP://TOMBOULIAN.info
  HTTP://TOMBOULIAN.Wikispaces.com

Objectives
Navigation
Order of Operations
M&Ms - Autosum and Charting
Picnic
Numbers and Formatting
Formulas
Autofill
Formatting
Budget Example
Checkbook
Insert
Alt-Enter
Format Exercise
Dates
Absolute Vs Relative formulas
Gradebook
Sort
Pie
Format and Print
House Payments
Car Payments
Retirement
                                                      Nolan Tomboulian 252-675-0176
                                                        TOMBOULIAN@YAHOO.com
                                                          HTTP://TOMBOULIAN.info
                                                     HTTP://TOMBOULIAN.Wikispaces.com
1.       Recognize the file extension of an Office 2007 created file and how it differentiates from Office 2003
2.       Demonstrate how to open Excel 2007 in either a “Blank” worksheet, a “Template” or a “Recent” worksheet.
3.       Discuss how “Templates” are useful designs for computer users
4.       Identify the BUTTON, NEW from Existing and the SAVE AS ” and identify the menu items and their uses
5.       Explain how the Ribbon replaces the Menu tabs and Tool Bar in Excel 2003
6.       Identify how to “Save” a Workbook
7.       Recognize different formats that a Workbook created in Excel 2007 can be saved in to include Office 2007, Of
8.       Worksheet Protection: Button / Prepare / Mark as Final
9.       Identify the “Ribbon” Tabs and their uses
10.   Recognize “Groups” and their uses
11.   Recognize “Command Buttons” and their uses
12.   Exercise “Minimizing” the ribbon (3 ways)
13.   Locate the “Quick Access Toolbar” and understand how to add/modify commonly used buttons
14.   Using the Ribbon Key Tips (Alt Commands) and <F10>
15.   Locate the “Worksheet” pane in the Workbook screen
16.   Identify and use the “Page Lay-out/View Buttons” area
17.   Locate and use the “Zoom” bar
18.   Recognize and use the “Scroll” bars
19.   Specify the difference between a Column and a Row
20.   Describe a “Cell” and its function. Place holder for: Text, Numbers or formulas
21.   Identify and use keyboard navigation commands: {Home}, {tab}, {Ctrl Home},<Arrows>, etc.
22.   Understand the “Order of Operations” utilized in formulas: (Please Excuse My Dear Aunt Sally)
23.   Identify the “Mathematical Operators” utilized in formulas (+, - *, /, ^)
24.   Identify “Simple and Complex Formulas” and working parameters of these formulas
25.   Discuss and use the AUTOFIL, “Copying”,” Cutting”, “Pasting” and “Paste Special” and the clipboard
26.   Change the “Font” attributes of text.(Font, Color, Size, Format: Bold, Italics, Underline)
27.   Use the ALIGNMENT Command buttons: Left , Center, Right, Full, Top, Middle and Bottom
28.   Locate the Formula and/or Function (F x) Bar
29.   Recognize how to format a column or row using the Format Group
30.   Identify how to “Insert” and “Delete” columns or rows Using the Command button or <Right Click>
31.   Discuss “Styles” and how to utilize them
32.   Identify how to “Format a Cell” using the Format Painter
33.   Use the Sort and Filter Option to ort and limit data
34.   Create a simple Chart
35.   Recognize how to “Print” a Workbook
36.   Describe a “Print Area” and how to select a “Print Area”, Headers and Print Attributes
37.   Recognize how to perform a “Spell Check” (if it is not turned on)
38.   Using the [VIEW] {Freeze Pain} features
39.   OTHER…….

Updated: March 7, 2012
(Portable Document Format)




             -        /      *   ^)
 CELL                               ROW
         <Home>                 Column A
         <Enter>                Down a row
         <Shift> <Enter>        Up a Row
         <Tab>                  To the Right 1 column
         <Shift> <Tab>          To the Left 1 column
         <Ctrl> <Home>          Cell A1
         Arrow Keys:            <Up> <Down> <Left> <Right>
         <Shift> <Arrows>       Drag and extend cell selection
         <Ctrl> <End>           Last Row and Column of work
COLUMN   <F5> or Name Box:      GOTO Cell

         <Ctrl> <Arrows>       Last Non-blank Row or Colum
         Page Up / Page Down Move up or down a screen of r
         <Ctrl> <Page Up> / <Ctrl> <Page Down> : Prior and N
         <Ctrl> <F1>           Turn off the Ribbon
         <F2>                  Make the Cell active to be able
                                    ROW
                                  CELL




ht 1 column
 1 column

wn> <Left> <Right>
 xtend cell selection
 nd Column of worksheet data
                                 COLUMN


 lank Row or Column of data
  down a screen of rows
Down> : Prior and Next Sheet
e Ribbon
Cell active to be able to edit
  50    10       5                    PEMDAS
             =       A1 + B1 * C1
             =       (A1 + B1) * C1
             =       A1 / B1 - C1
             =       A1 / (B1-C1)
             =       A1 / B1*C1
             =       A1 / (B1 * C1)
             =       A1 / B1 + B1 / C 1 - A1 / C1 + B1
             =       B1 ^ 2 + B1 * C1
             =       (A1 + B1 * C1) ^ .5
             =       A1 + B1 * C1 + A1
             =       A1 + B1 ^ 2 + C1 ^2
Please      Excuse      My          Dear     Aunt Sally
Parantheses Exponenets [Multiply or Divide] [Add or Subtra
    Aunt Sally
e] [Add or Subtract]
M&M Color Quantity
Red
Yellow
Blue
Green
Orange
Brown




This example will demonstate:
Entering data in a column
Simple Charting (highlighing a range)
Using the AutoSum to find the TOTAL
Typing in the AVERAGE Function
Use the Function Bar to enter the MIN function
Use the AutoSum to find and enter the MAX function
Use of the Absolute Cell Referece in a calculation of Percent of each color
The Picnic for       Planned People 20
                     Actual People    15
                               Cost Per
                               Person
                     Budget    ?
                     Actual    ?

item                            cost
hot dogs                                 15
plates                                    3
forks                                  4.25
matches                                0.25
grill
charcoal                               8.75
lighter fluid                          4.15
potato chips                            7.5
katchup                                2.69
relish                                 1.29
Mustard                                1.75
hot dog buns                             18
Shelter permit fee                       25
Trash bags                                3
Napkins                                3.75
TOTAL

This will demonstart the Auto Sum
Absoulte Cell Reference Multiplier
Formatting and Simple Formulas
                                            Format Numbers
                                     Number
                          Number     Comma      Currancy    Currancy Accounting Accounting
                  General Comma 2 Decimals           US $        US $       US $       US $
Raw Numbers Decimal 2 Decimals (Negative) 2 Decimals 0 Decimals 2 Decimals 0 Decimals
              No
      -4342      -4342.00    -4342      -4342       -4342       -4342      -4342      -4342
   -101.67        -101.67 -101.67    -101.67     -101.67     -101.67    -101.67    -101.67
     -100.6       -100.60   -100.6     -100.6      -100.6      -100.6     -100.6     -100.6
        -100      -100.00      -100       -100        -100        -100       -100       -100
       -22.6       -22.60     -22.6      -22.6       -22.6       -22.6      -22.6      -22.6
       -22.5       -22.50     -22.5      -22.5       -22.5       -22.5      -22.5      -22.5
       -22.4       -22.40     -22.4      -22.4       -22.4       -22.4      -22.4      -22.4
       -0.78        -0.78     -0.78      -0.78       -0.78       -0.78      -0.78      -0.78
         -0.7       -0.70       -0.7       -0.7        -0.7        -0.7       -0.7       -0.7
         -0.5       -0.50       -0.5       -0.5        -0.5        -0.5       -0.5       -0.5
         -0.2       -0.20       -0.2       -0.2        -0.2        -0.2       -0.2       -0.2
         -0.1       -0.10       -0.1       -0.1        -0.1        -0.1       -0.1       -0.1
            0        0.00          0          0           0           0          0          0
        0.07         0.07      0.07       0.07        0.07        0.07       0.07       0.07
            1        1.00          1          1           1           1          1          1
      15.24         15.24    15.24      15.24       15.24       15.24      15.24      15.24
        19.9        19.90      19.9       19.9        19.9        19.9       19.9       19.9
      20.48         20.48    20.48      20.48       20.48       20.48      20.48      20.48
    75.235          75.24  75.235     75.235      75.235      75.235     75.235     75.235
      98.56         98.56    98.56      98.56       98.56       98.56      98.56      98.56
      100.2        100.20    100.2      100.2       100.2       100.2      100.2      100.2
      100.5        100.50    100.5      100.5       100.5       100.5      100.5      100.5
      100.8        100.80    100.8      100.8       100.8       100.8      100.8      100.8
   1345.21        1345.21 1345.21    1345.21     1345.21     1345.21    1345.21    1345.21
       9876       9876.00     9876       9876        9876        9876       9876       9876
     99123      99123.00    99123      99123       99123       99123      99123      99123
    120456 120456.00       120456     120456      120456      120456     120456     120456
Percent
   -4342
-101.67
  -100.6
     -100
    -22.6
    -22.5
    -22.4
    -0.78
      -0.7
      -0.5
      -0.2
      -0.1
         0
     0.07
         1
   15.24
     19.9
   20.48
 75.235
   98.56
   100.2
   100.5
   100.8
1345.21
    9876
  99123
 120456
    80               457       785     125       875     552
   100               785       254      25       442     254
    40               125       256               254    1141
    60               254       252            1245.7   25541
    20              1164       854                      2365
    55                         200                       214
                             433.5

     4                 5        7       16
     8                 3        2       11               220

                      0.1
          Yearly Increase                2
                                5       10
                               10




  1-Feb           2-Feb      3-Feb    4-Feb    5-Feb   6-Feb
  1-Feb           8-Feb     15-Feb   22-Feb   29-Feb   7-Mar
January         February     March




          WHERE ARE THE FORMULAS
     100     110     121     133.1   146.41
     200
     300
     400
     500

              10       5       15
               3       2        4
               2       8       10
               3       6        9
     100




    7-Feb   8-Feb   9-Feb   10-Feb   11-Feb




ORMULAS
          1              1 Monday         1-Jan   Dept202
          2              3                8-Jan


                                                            Row 5




January       February
                   250              225


   15-Feb       15-Mar


Exam 1

101 Elm Street
103 Elm Street
Top-Left                        Top-Center                      Top-Right




Center-Left                     Center-Center                   Center-Right




Bottom-Left                     Bottom-Center                   Bottom-Right


This is a long line that contains lots of text and word wrap is NOT turned on

This is a long line that contains lots of text and word wrap is NOT turned on

This is a long line that contains lots of text and cols A-C will be merged


First Line (No Indent)
  Indent pressed ONE time
    Indent pressed TWO times
      Indent pressed THREE times
Turn Text               Turn Text                Turn Text




Turn Text               Turn Text                Turn Text




                           of text is word wrap is not on
This is a really long linethistext andover the text in D13
ABC Company

First NameLast NameSSN           Address City                   Phone
                                                    State Zip Code
Sara      Marshall 111223333               San      TX
                                 222 Nasa Rd Marcos 2108293944.00
                                                          ####
Joan      Crawford 444556666               Comfort TX 2102222555.00
                                 2454 Painter             ####
Betty     Davis      777889999             Blanco TX 2108295557.00
                                 222 Main St.             ####
Jimmy     Jones      123456789             Bandera TX 2108295935.00
                                 2221 Perdita             ####
Mike      Jones      999999999             San Antonio
                                 100 Gasoline Alley TX 2108297938.00
                                                          ####
Will      Smith      888888888             San Antonio
                                 120 Elwood Lane TX 2108293956.00
                                                          ####
Jane      Smith      100000000             Dublin TX 2108294041.00
                                 421 Raglan Rd.           ####
Fred      Flintstone 222222222   72 Par Rd Blanco TX 2108293940.00
                                                          ####
Fanny     Brice      200000000             San      TX
                                 4301 BroadwayAntonio 2108293988.00
                                                          ####
Bill      Board       73409699             San      TX
                                 4301 BroadwayAntonio 2108297920.00
                                                          ####
Budget Analysis
Expense Amount
Rent           1000
Electric         215
Water             65
Cell Phone        75
Cable TV          45
Medical Insurance200
Car Insurance    120
Life Insurance    80
HomeOwners        60
Car repairs      125
Car /Gas          90
Food             250
Houshold          45
Entertainmnet     35
      2/1/2007 Beginning Balance
 505 2/15/2007 Limited
 501 2/3/2007 School Cafeteria
 507 2/20/2007 Applebee's Restaurant
      2/1/2007 Allowance
 503 2/9/2007 GAP
 502 2/8/2007 School Store
 504 2/14/2007 Sears
     3/14/2007 Babysitting
 506 3/19/2007 School Store
 508 3/23/2007 School Cafeteria

FOLOW THE INTRUCTIONS
1) Put your curser in cell C1. Type:   Ima Student . Press <enter>
2) In C2 Type: Check Register <enter>
3) Adjust the Column Size for column C,
4) Center the Data in the column C.

5) Enter the headers for the columns
 a) In A5, Type: Check Number
 b) In B5, Type: Date
 c) In C5, Type: Description
 d) in D5, Type: Amount of Check
 e) in E5, Type: Deposit
 f) in F5, Type: Balance

6) Type the beginning balance in cell F6: 817.5
7) FORMAT the CELLS in columns: D, E and F to be CURRENCY. Have Negative amounts in (
8) Format the Date to be: Month-Day
9) Put your cursor in F7. Type the formula: =F6-D7+E7 <enter>
         (Take the Prior Balance, Subtact the Check amount and Add a deposit)
10) Copy the formula in F7 down to F16
11) NOW ENTER     Data to Test your calculations.
tive amounts in (   )



 deposit)
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
Col A   Col B   Col C   Col D   Col E   Col F   Col G   Col H
A100   B100   C100   D100   E100   F100
A101   B101   C101   D101   E101   F101
A102   B102   C102   D102   E102   F102
A103   B103   C103   D103   E103   F103
A104   B104   C104   D104   E104   F104
A105   B105   C105   D105   E105   F105
A106   B106   C106   D106   E106   F106
A107   B107   C107   D107   E107   F107
A108   B108   C108   D108   E108   F108
A109   B109   C109   D109   E109   F109
A110   B110   C110   D110   E110   F110
A111   B111   C111   D111   E111   F111


A115   B115   C115   D115   E115   F115
A116   B116   C116   D116   E116   F116
A117   B117   C117   D117   E117   F117
A118   B118   C118   D118   E118   F118
A119   B119   C119   D119   E119   F119
A120   B120   C120   D120   E120   F120
A121   B121   C121   D121   E121   F121
Last     First       Address Phone          Date      DVDs        Price per DVD
                     402 Elm
                     St
                     Merrill, MI (989) 555-
Dawes    Gregory     48637             3433 3/10/2010         7     $17.29
                     1025
                     Drake Ave

                     Exeter,  (603) 555-
Garcia   Susan       NH 03833       1091 3/14/2010           25     $15.79
                     5 North
                     Ln
                     Oswego, (315) 555-
Torbet   Dr. Lilla   NY 13126       7823 3/17/2010           32     $12.99

                     24
                     Mountain
                     Dr.
                     Auburn, (207) 555-
Rhoden   Tony        ME 04210      9915 3/24/2010            20     $15.79
ExerComp
the Intelligent path to Fitness

X310 Yearly Sales Analysis

Units Sold Region    2008 Sales 2009 Sales Increase % Increase
           R01            3605       3853        248    0.068793
           R02            3966       3842       -124    -0.03127
           R03            3760       4035        275    0.073138
           R04            3777       4063        286    0.075721
           R05            3974       3725       -249    -0.06266
           R06            3656       3937        281     0.07686
           R07            3554       3875        321    0.090321
           R08            3844       3844          0           0
           Total:        30136      31174       1038    0.034444

Revenue Region       2008 Sales 2009 Sales Increase % Increase
        R01           104364.8    115397.4    11032.6   0.105712
        R02           114815.7    115067.9      252.2   0.002197
        R03             108852    120848.3   11996.25   0.110207
        R04           109344.2    121686.9    12342.7   0.112879
        R05           115047.3    111563.8   -3483.55   -0.03028
        R06           105841.2    117913.2   12071.95   0.114057
        R07           102888.3    116056.3   13167.95   0.127983
        R08           111283.8    115127.8       3844   0.034542
        Total:        872437.2    933661.3    61224.1   0.070176
Today's Date                     4/4/2012        W ednesday, April 04, 2012


Date of Birth                    4/1/1960                                1


Age                                     52                               2


Date and time            4/4/2012 19:45                               1900


Time                            7:45:58 PM
                                                                         4
Hour                                 07 PM                               3


Seconds                                     58                   3/10/2012


 <F9> is the Recalculate / Refresh Button                            40971
                                                                     41063
TODAY()

DAY(Number)                    32 Day within the Month


MONTH(number)                  32 Returns the Month Number


YEAR(number)                    1 "number" is Days from Jan-1-1900)


WEEKDAY(Number,Type)           32
Type 1= Sun-1 / Sat=7
Type 2= Mon-1 / Sun=7
                        Year        Month          Day
DATE(Year,Month,Day)       2012                3         10


DATEValue(DateString)               03-Mar-2012 <-- formatted as TEXT
                                    03-June-2012
                     Financial Forecast - Get Rich Quick Enterprises
Income                               2003     2004
   Units Sold                      75,000   82,500
   Selling Price                    $3.00
   Gross Revenue                 $225,000
Overhead
   Production facility            $50,000
   Administration                 $25,000
Cost of Goods Sold
   Unit manufacturing cost          $1.00
   Variable manufacturing cost    $75,000
   Unit sales cost                  $0.20
   Variable sales cost            $15,000
Earnings before taxes             $60,000      $0
   Income taxes                   $15,000
Net earnings                      $45,000      $0

Initial conditions
  Units Sold                      75,000    10.0%
  Selling price                     $3.00    5.0%
  Unit manufacturing cost           $1.00   10.0%
  Unit sales cost                   $0.20    0.0%
  Production facility             $50,000    8.0%
  Administration                  $25,000    5.0%
  Tax rate                           25%
  First year of forecast             2003
es
                             Professor's Grade Book - Weighted Semester Averages
                     Soc Sec                                         Test
       Name           Num        Test 1                            Average Homework
Adams, John           111223333    80       71       70      84       76         Poor
Barber, Maryann       444556666    96       98       97      90       92         OK
Boone, Dan            777889999    78       81       70      78       75         OK
Borow, Jeff           123456789    65       65       65      60       62        Great
Brown, James          999999999    92       95       79      80       83         OK
Carson, Kit           888888888    90       90       90      70       80         OK
Coulter, Sara         100000000    60       50       40      79       60         OK
Fegin, Richard        222222222    75       70       65      95       79         OK
Ford, Judd            200000000    90       90       80      90       86         Poor
Glassman, Kris        444444444    82       78       62      77       74         OK
Goodman, Neil         555555555    92       88       65      78       78         OK
Milgrom, Marion       666666666    94       92       86      84       86        Great
Moldof, Adam          300000000    92       78       65      82       78         Poor
Smith, Adam           777777777    60       50       65      80       66         Poor
Average
Highest Grade
Lowest Grade
Range (High - Low)

Exam Weights                          18%      20%      20%       40%
      Grading Criteria                                                     Homework Bonus
      0         F                                                       Poor                0
      60        D-                                                      OK                  1
      63        D                                                       Great               3
      67        D+
      70        C
      77        C+
      80        B-
      83        B
      87        B+
      90        A-
      93        A


Add TEST# to Row 2
Add Formuals for Average, High (MAX), Low (Min) and Range: High-Low
Weight for the Exams needs to dd up to 100%: Add a formula in G22
The "Semester Average" in Column I is not down well. (Hard coded based on Homework
ges
      Semester   Letter
      Average    Grade
         76
         93
         76
         65
         84
         81
         61
         80
         86
         75
         79
         89
         78
         66
First Name    Last Name   Address                City              State        Zipcode   Sex   Race       Sales    Date
James         Bond        007 Danger Street      Dublin            NM             88001   M     W      $     10    Jan-15
Victoria      Bond        99 Smart Drive         Dublin            AZ             70097   F     B      $       5   Jan-19
Phil          Erupp       100 Gasoline Alley     San Antonio       TX             78202   M     B      $     12    Feb-05
John          Belushi     120 Elwood Lane        San Antonio       TX             78222   M     W      $     20    Mar-15
Anne          Frank       897 Atic Place         Freemont          AZ             78012   F     H      $       8   Mar-12
Walker        Board       2454 Painter           Comfort           TX             78148   M     H      $     15    Jan-15
Dana          Smith       1218 Lucinda Street    Dublin            NM             88001   F     A      $       9   Feb-12
Betty         Davis       85 Buggs Bunny Road    Bandera           TX             78109   F     W      $       7   Jan-09
Kathrine      Lewis       123 Elizabeth Dr       Pheonix           AZ             70098   F     W      $       3   Feb-19
Barbara       Tintle      123 Northen Parkway    Freemont          AZ             78012   F     B      $     10    Mar-15
Candy         Cane        123 Sweetgum Rd        Comfort           TX             78148   F     W      $     12    Mar-10
Anne          Bishop      4 Kings Corner         San Antonio       TX             78222   F     B      $     15    Jan-15
Cherri        Johnson     1417 Davis Ave         Blanco            NM             88015   F     H      $     20    Jan-07
Carol         Edwards     215 Elizabeth Ave      Dublin            NM             88001   F     H      $       5   Feb-02
Judy          Collins     222 Main St.           Blanco            TX             78111   F     A      $       3   Feb-09
Carl          Sagan       222 Nasa Rd            San Marcos        TX             78222   M     A      $       1   Mar-15
Andrew        Smith       76 Red Robin Lane      Pheonix           AZ             70098   M     B      $       8   Jan-15
Jane          Goodall     2221 Perdita           Bandera           TX             78109   F     B      $     10    Jan-09
Andy          Goodall     218 Bad Avenue         Bandera           AZ             78015   M     W      $     15    Feb-02
Bill          Board       2454 Painter           Comfort           TX             78148   M     W      $     20    Mar-20
Vanessa       Morrison    421 Raglan Rd.         Dublin            TX             78112   F     A      $       5   Mar-15
Bill          Murray      4301 Broadway          San Antonio       TX             78212   M     A      $       3   Feb-08
Terry         Peak        4301 Broadway          San Antonio       TX             78222   M     B      $     15    Feb-01
Lucy          Linus       623 Peanut Lane        Bandera           NM             88111   F     H      $       3   Jan-15
Lucinda       Baca        634 Elmwood Ave        Blanco            NM             88015   F     H      $       2   Jan-20
Sandy         Batt        6705 Elmwood           Blanco            NM             88015   F     B      $       5   Feb-15
Bob           Jones       72 Par Rd              Blanco            TX             78109   M     W      $       8   Mar-18
Bobby         Bishop      769 Paff Ave           San Antonio       NM             88512   M     W      $       9   Mar-09
Austin        Powers      777 Gold Finger Road   San Marcos        NM             88123   M     B      $     16    Feb-08
Maria         Baca        786 Gladys Dr          Pheonix           AZ             70098   F     H      $     12    Jan-15
Bobbie        Jones       888 Birdie Laae        Blanco            TX             78109   F     A      $       8   Feb-12
Jack          Smith       812 Greenwood          Comfort           NM             88019   M     B      $       7   Mar-11
Charlie       Brown       876 Peanut Lane        Bandera           NM             88111   M     W      $     10    Mar-20
David         Davis       879 Looney Tunes       Bandera           TX             78109   M     A      $     20    Jan-15
Rose          Littleton   945 Elmwood Dr         Freemont          AZ             78012   F     H      $     15    Feb-12




3:15 PM12/12/2013                                       Instructional Technology 32
       My
 Investmen
Investment Category
            Assets
Cash   ts$ 6,144
U.S. Stocks 49,001
          $
Non-U.S. Stocks
           $ 8,035
Bonds     $ 13,077
Other      $ 2,520
   Total Assets
           $ 78,777


Make a Simple Pie, Bar or Column Chart
Adjust Column Widths
Calculate Percentage
Fix/add Formulas for totals and add formatting to Column A (merge A6-A19 and A21-34). Make it look good!

ExerComp
the Intelligent path to Fitness

X310 Monthly Sales Analysis

Units Sold in 2008Month           R01      R02      R03      R04      R05       R06       R07
                  Jan                288      345      326      307      364       310       316
                  Feb                278      304      294      297      310       278       275
                  Mar                294      320      297      304      316       291       297
                  Apr                288      313      300      300      320       284       275
                  May                284      329      304      297      313       288       275
                  Jun                313      339      316      315      326       307       288
                  Jul                313      332      320      310      313       300       304
                  Aug                294      339      315      339      339       304       307
                  Sep                284      310      310      304      316       284       281
                  Oct                284      326      304      297      316       281       281
                  Nov                339      364      326      320      364       345       294
                  Dec                346      345      348      387      377       384       361
                                  3,605    3,966    3,760    3,777    3,974     3,656     3,554

Units Sold in 2009 Month          R01      R02      R03      R04      R05       R06       R07
                  Jan                352      364      345      352      336       361       325
                  Feb                297      326      310      313      288       300       297
                  Mar                307      333      326      316      316       316       310
                  Apr                313      316      329      326      307       304       310
                  May                310      323      326      326      304       313       313
                  Jun                313      348      348      320      329       319       336
                  Jul                323      326      348      329      313       316       326
                  Aug                323      320      326      355      315       326       325
                  Sep                300      297      326      326      297       310       307
                  Oct                300      288      332      313      291       310       313
                  Nov                355      297      355      384      297       361       329
                  Dec                360      304      364      403      332       401       384
                                  3,853    3,842    4,035    4,063    3,725     3,937     3,875
Make it look good!




              R08       Totals
                  352    2,608
                  294    2,330
                  307    2,426
                  295    2,375
                  310    2,400
                  329    2,533
                  336    2,528
                  323    2,560
                  304    2,393
                  300    2,389
                  336    2,688
                  358    2,906
               3,844    30,136

              R08       Totals
                  342    2,777
                  300    2,431
                  316    2,540
                  352    2,557
                  300    2,515
                  326    2,639
                  329    2,610
                  305    2,595
                  293    2,456
                  307    2,454
                  329    2,707
                  345    2,893
               3,844    31,174
House Repayment Schedule                                    Payment Calculator Using the =PMT Form
    Rate:     0.07                                               Amount:    100,000
                                                                    Rate:      0.07
 Amount:    100000                                                 Years:        30

                                                            Montly Payment Amount

         Payment Date
Payment number    Principle   Interest   Payment   New Balance
                     100000
culator Using the =PMT Formula

                     Monthly:
                     Months
                                                 Car Payment Calculator
                                                                       Yearly       Term
                                  Down                  Amount        Inteerest       in                        Total
  Make/Model         Price       Payment   Trade-In     Financed        Rate        Months        PMT         Payments
                                                                              10%
2008 Acura MDX   $     2,000 $       1,000 $    500 $          500    0.00833333           12       -$43.96
                                                    $          -      0.00833333                 #DIV/0!
                                                    $          -      0.00833333                 #DIV/0!
                                                    $          -      0.00833333                 #DIV/0!
                                                    $          -      0.00833333                 #DIV/0!

                                                                                       PMT(rate,Nper,Pv,[Fv],[Type])

                                                                     Rate: The ANNUAL Rate: Divide by "N" payments per year
                                                                     Nper: Number of Periods or payments to make
                                                                     Pv: Present Value: Amount Financed
                                                                     Fv: Future Value: (zero or amount left at end of term)
                                                                     Type: 1=Pay at start of term, 0=Pay at end of term
              Interest
                paid




 Type])

yments per year
 ake

 d of term)
d of term
Retirement
Today's Date               4/4/2012
Bate of Birth
Target Age of Retirement         70


                                           Annual                               Years
Name                           Age     Contribution      Rate of Return   Contributing
Nolan                            52             3000                0.1             1




                             VF(Rate,Nper,Pv,[Fv],[Type])

Rate: The ANNUAL Rate: Divide by "N" payments per year
Nper: Number of Periods
Pmt: Amount of payment per term
Pv: Present Value of an initial Lump Sum Invested
Type: 1=Pay at start of term, 0=Pay at end of term


Assumes a FIXED RATE over the term
  Amount
        at
Retirement
($3,300.00)

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:12/12/2013
language:English
pages:41