ࡱ>  ` bjbj [3bbbbbbb4jjjhFkk\qbmxm(mmmkokoko$]h¿ib7vIo"ko7v7v¿bbmm+zzz7vbmbmz7vzzjbbmVm a*4j7wl2ȽA0qJ[yB[d[bko#q:z]rYskokoko¿¿QzXkokokoq7v7v7v7vdbggbbbbbb Excel Teaching Notes Excel 2003  DATE \@ "M/d/yyyy" 1/6/2005 Session 1: Tutorial 1 and Tutorial 3 Managing Data and Worksheet Navigation Formatting Cells and Worksheets Spread sheets: Are used to analyze and report on information. They are used for budgeting, inventory management, and decision making. What-if analysis: where one or more values can be changed and then recalculated to determine the effect of the change Workbook: Made up of worksheets Worksheet: Individual sheets Cells: Intersection of Column and Row Columns: Runs top to bottom and contains the headers Row: Runs left to right and contains the records Cell Reference: The location identifier for a cell Active Cell: Cell currently being used Formula Bar: Located above the workbook window where the contents of a cell is displayed Ranges: Can be either adjacent or nonadjacent and is a group of cells Range Reference: Indicates the location and size of a cell range Function: Redefined formula that performs calculations using specific values call arguments Syntax: Is the rule specifying how the function should be written General Syntax rule: Where FUNCTION is the name of the Excel function and arugment1, argument2 and so forth are arguments specifying the cell reference used by the function to calculate a value: FUNCTION(argument1,[argument2=value2]) Entering Data: Ctrl+home takes curser to top left of worksheet Auto Fill: Months, Days, Quarters, Patterns Select styles: click and drag, click/shift/click, click/ctrl/click, black arrow for whole column or row (( () New Spreadsheet - Enter the Following Data: A1: Name B1: Address C1: Date D1: Item E1: Price F1: Quantity G1: Total ABCDEFGAlison Wilson45 Lincoln Street Midtown Fl 804814/18/2006Red Grape142Carl Ramirez900 South Street Crawford, FL 818914/17/2006Navel Oranges172David Wu315 Oak Lane Midtown FL 804224/16/2006Navel Oranges171Jerry Dawson781 Tree Lane Midtown FL 804224/18/2006Deluxe Combo214 Formula for G2:=E2*F2 Copy down column Change Width of Columns: Move pointer to dividing line between column A and B until it changes to double headed arrow and double-click SaveAs: Dalton Select Data: Click and Drag Click/Shift/Click Click/Ctrl/Click Select A1:G5 Move to A5:G9 Select A1 Type: Dalton Food Co-op Select A2 Type: List of Orders Select A3 Type: April 2006 (Note that the formula typed earlier (G6) has changed to refer to the correct cells when it was moved) Auto Sum A10: TOTAL F10: Click the auto Sum button on the toolbar (") Sum cells above Insert Row: Select A10: Right-click and insert row Delete Row: Select row 7 with ( to highlight whole row/right-click and delete row Select E8 Change 21 to 23 Undo/Redo last action Delete Sheet2 and Sheet3 Right-click sheet tab/delete Insert a new worksheet Insert/Worksheet/ Right-click to name the sheet / Documentation Rename Sheet1: Orders Reposition sheets by dragging so that Documentation is ahead of Orders Insert the following information on the Documentation sheet: In A1: Dalton Food Co-opIn A3: Date:In B3 (enter current date)In A4: Created By:In B4: (your name)In A5: PurposeIn B5: To enter orders for the Dalton Food Co-op Spell Check: Switch to Orders Sheet Click G5 Type: Totale (spell it wrong) Click A1 and start spell checker using the ABC spell check button from the toolbar Spell Checker always starts at the active cell and moves down the page Click: spelling button on the toolbar/accept change to Total/OK Print Preview File/print preview Setup will allow changes to Orientation, Margins/Centering table/Gridlines/Rows or Columns to repeat Printing Worksheet Formulas: Display formulas: Ctrl + ` (the second symbol is a grave accent and is found above the tab key: be sure and use it, NOT the key next to enter) OR: Tools/Options/View/Formulas Print Preview will show if the formulas are printing Setup: will allow you to use the Fit to option If you have the fit to option checked: page break sets will not work Ctrl + will remove the formulas from sight (grave accent is found above the tab key). Session 1 (Contd): Tutorial 3 Formatting cells worksheets OPEN: Sales Apply Comma style and remove training zeros: B7:E19 Click Comma Style on the formatting toolbar Click Decrease Decimal on formatting toolbar Apply Currency Style: B23:D25, F23:G26 Click Currency Style button on formatting toolbar Apply Percent style and increase the number of decimal places: H23:H25 Click Percent Style button on the formatting toolbar Click Increase Decimal button on the formatting toolbar Copying Formats: B7: Click the Format Painter button (paintbrush) on the formatting toolbar Drag pointer over the range: E23:E26 Format Cells Dialog Box: B23:D25, F23:G26 Click format on the menu/Cells/Number/Currency (If you choose currency from the toolbar the $ aligns on the left side of the cell. If you choose currency from the format cells menu, the $ aligns on the figure directly to its left) Change Font and Font Size: A1: change font to Times New Roman and size to 18 A6:E6, A22:H22 Bold A19:A26 Italic A1:A3 Font color to Red Aligning Cell contents: B6:E6, B22:H22 Center Center titles and subtitles across the first 8 columns A1:H3 Format/Cells/Alignment/Horizontal/Center Across Selection/OK Indent A7:A18, A23:A25 Increase Indent button on the formatting tool bar Text Wrap: A22:H22 Format/Cells/Check in Wrap text/OK Automatically resize columns Highlight columns use the double-headed arrow between any two column letters/ double-click Borders: A6:E19, A22:H26 Click Borders on the toolbar choose all borders Same range: choose thick Box border form borders button on toolbar Double border lines: A18:E18, A25:H25 Format (on the menu)/cells/Border/Double line Bottom Border/OK Fill/Patterns: A6:E6, A22:H22 Click Fill Color button on formatting toolbar Look at colors and patterns/ choose one Formatting Worksheet: Merge and center cell ranges containing titles A5:E5/ click the merge and center button on the formatting toolbar/Bold A21:H21: same procedure as above (Cannot choose nonadjacent cells to merge) Hide Columns: Select Headings for rows 7 through 18 Right-click/Hide Unhide: Select row headings fro rows 6-19/ Right-click/Unhide Hide Documentation Sheet: Click documentation sheet tab/Format/Sheet/Hide Unhide Documentation Sheet: Format/Sheet/Unhide Formatting Sheet Tabs: Right-click Sales tab/tab color/ choose a color/OK Clearing Formats: A1: Edit/clear/Formats Format: Find and replace Edit/Replace/Options>>/Format/Font/Bold/OK Replace with: Format/Bold/Blue OK Find next/ Replace All after you are sure that it is working correctly AutoFormat: A5:E19 Format/Autoformat/Choose one/OK Change Margins and Center Worksheet on page: Print Preview/Setup/Margins/Change left to 1/Right to 1/Center Horizontally/OK Change Page Orientation: Print Preview/Setup/Page/Landscape/OK Header/Footer: Print Preview/Setup/Header. Footer/Custom Header Left Section type: Filename: click the filename button Right Section: click the date button/ OK Center Section: type Page click page number Close Page Break Preview: A1/View/Page Break Preview/OK Insert page break: Click row 20/Insert/Page Break/OK Change view back to normal Repeat Rows: File/Page Setup/Sheet/Rows to repeat at top/A1:A3 End of Session 1 Session 2: Tutorial 5 Excel Lists Pivot Table and Validation Open Vehicle 1 Freezing Rows and Columns: B2 Click Window on the menu bar Click Freeze panes Scroll right and down: The header row and the first column stay visible Find & Replace: Select column F Edit/Replace Type Telecomm in the Find box Type Telecommunications in the Replace box Find Next/Replace When it is determined that the search is working correctly, Replace all can be used Options in the dialog will allow closer defining of the search Creating a List Range: Select a range of cells/Highlight the Name Box/Type a range name (NO spaces)/ Sort: Click any cell in department Assigned column A single cell can be selected to sort. NEVER select a whole column. Excel will sort ONLY that column. OR select the list/data/sort/ choose the fields to be sorted. Selecting a single cell and sorting from the toolbar allows for only one sort. Maintaining a List: Insert record using data form Make sure the active cell is within the list Click Data on the menu/Form/New ID: 2525 Year: 2005 Make: Chevrolet Type: Sedan Odometer: 1203 Dept Assigned: Police & Security Price: 22400 Maintenance: 76 Close Search using Data Form: Data/Form/Criteria/ID# 2142/Find Next Change the odometer to 3456 Close Search and Delete using Data Form: Data/Form/Criteria/ID# 678/Find Next/Delete button/OK/Close Filter: using AutoFilter: Make sure the active cell is within the list Data/Filter/AutoFilter Click Make/Ford Custom AutoFilter: Allows specific relationships other than equal to Click YEAR on the filter/Custom Is Greater than/2000/And/is less than or equal to/2005/OK Show all records from filtered list: Data/filter/Show All If you close your workbook with the filter on, the next time you open the workbook, the filter will still be on. It will appear that you have lost tons of data, remove the filter. Conditional Formatting: Formatting that appears in a cell when data in the cell meets conditions that are specified or is the result of a formula E2:E73/Format/Conditional Formatting Specify the condition: Cell Value Is/Greater than/100000/Format/Patterns/choose a color/OK This chooses a cell color: Font color is also a choice Add>>/ between 80,000 and 100000/choose different color/OK Deselect range: Calculate Summary stats on a filtered list: Click Type AutoFilter arrow/truck to display only trucks Click Year AutoFilter/custom/Select is greater than or equal to/2000/OK Add a total row to calculate the average maintenance cost Click the Toggle Total Row button on the list toolbar (Shown on left side of sheet) Select H75/click the list arrow/Average Remove the total row for list range: Data/Filter/Show All/Click Toggle Total Row button/scroll down to bottom of list: Total row is removed from list range Calculate Subtotals: Sort list by department/Ascending Data/List/Convert to range/yes Data/Subtotals/At each change in Department Assigned/Use function/Sum In the Add subtotal list box, scroll and select Price check box (Remove check from Maintenance)/Summary below data/OK Subtotals Outline View: Click level buttons to display different levels Remove Subtotals: Data/Subtotals/Remove All Data/List/Create List/OK Pivot Table used to create a data validation list. A validation list is needed for the Department Assigned Column. The Department Assigned is a data column that needs to be filled in correctly to allow the filtering and sorting to function properly. Create a pivot table and move the Department Assigned Tag to the row location on the pivot table. Open Vehicle.xls Use the Pivot table to build a validation list. Click Data( Pivot Table and Chart Wizard( choose Microsoft Excel List or Database(Pivot Table(Next(Select entire A1:H72 cells from Vehicle.xls(click Finish Drag Department Assigned group to Row Area(highlight all department Names and click copy(paste values on new worksheet(Highlight all names(click Insert(Name(Define and type TheList Go back to Vehicle worksheet( highlight all Department Assigned Row(click Data(Validation(check List(and then under source type =TheList(Ok The Validation rule now applies for the data entered in the column. Typing anything other than the values in TheList will be in error and not allowed to be entered. Any corrections needed for TheList may be applied to the named range. End of Session 2 Session 3: Tutorial 4 Charts and Graphs Charts: Open Vega1 Chart Wizard: Clustered Column Chart: A5:D9 Click Chart Wizard button/Column/Clustered Column Hold the View Sample/Next If the data source is not chosen or is incorrect, select the source A data series consists of data values which are plotted on the charts vertical axis (y-axis). The horizontal axis(x-axis) is the data series category values. In this chart the data values are the sales values and the category values are the names of the different telescope models. Click Rows: Excel changes the orientation of the data source. The category values now represent the three regions rather than the four telescope models. Click the Series tab: The Series tab lists all of the data series used in the chart and the corresponding cell references for the cell that contains the name of the data series, the cells that contain the values for the data series, and the cells that contain the category labels. Chart Options: Insert Titles: Choose Titles from the chart wizard Chart title: Telescope Sales by Region Category (X): Region Value (Y): Sales ($US) Check Gridlines tab/Major gridlines for Value (Y) to remove major gridlines Next Choosing Chart Location: -Choose Embedded: Embedded Chart is a chart that is displayed within a worksheet A Chart sheet is a new sheet that is automatically inserted into the workbook. The chart occupies the entire worksheet window and thus provides more space and details for the chart. -If a Chart is highlighted with sizing handles that is what will print and what you will see in print preview. -Resizing a chart using the corner handles will keep it in perspective. Using side handles will pull it longer or taller. A 4-headed arrow will allow relocation of a chart. Pie Chart: A6:A9; E6:E9 Chart Wizard/Pie/Next Title: Total Telescope Sales Click Data Labels/Percentage Next/ As new sheet/Sheet Title: Pie Chart of Sales/Finish Rotate pie chart: Double-click the chart/Options Double-click the value in the angle of the first slice text box/click Degrees up arrow change to 180/ OK Explode Slice: Double-click slice and drag outward Modify Chart: Edit Data source: Switch to Sales worksheet/select column chart Click Chart on the menu bar/Source Data/Series/NightVision 16/remove/OK Switch to Pie chart of Sales/select the chart/click Chart on the menu bar/Click Source Data/verify that the series tab is selected Click Collapse dialog box button select the range A6:A8 Click expand dialog box/ new chart will display Change Chart Options: Click chart on the menu/Chart Options/Data Labels/Value/OK Values are now added to chart Format data labels: Double-click data label $1858,000/Font/color/Yellow Alignment/change to 90 Label position/Inside Base/OK Right-click $2,160,000 Format data Labels/font/color/white/90 degrees/label inside base of each column Select data labels for the NightVision 12 data series by: Click Chart Objects list arrow on the Chart toolbar select NightVision12 data labels Format data/font/color/choose a color/ 90 degrees/label inside base of each column/OK Insert Unattached Text Select Column chart Click in the Formula bar above the chart/ type Vega Sales from the Last Fiscal Year Font Color/Ivory Drag text box to the upper-right corner of plot area Border for the text box: Select text box/Format text box/Colors and Lines/Color/Ivory/OK Fill color of chart columns: Click on a bar (data series) [One click selects all bars of the same type, two clicks selects the bar clicked on] Choose a color or fill effect/OK End of Session 3 Session 4: Tutorial 6 Multiple Worksheets Open LBC1 Grouping Worksheets: With January worksheet selected Click the Last Sheet Button ((| ) //December Click the First Sheet Button (|() to return to first sheet without loosing selection Enter same information in all the sheets in the workgroup: B12: =SUM(B8:B11) calculates the total cash inflow amt. B19: =SUM(B14:B18) calculates total cash outflow amt. B20: =B12-B19 calculates net change in cash B22: =B21+B20 calculates the ending cash balance Check each sheet to review formulas Ungroup Worksheets: Right-click January tab/Ungroup Sheets Referencing Cells and Ranges in other Worksheets: Insert cell reference to the January worksheet in the February worksheet: February tab/B21: = (click the January tab) click B22 3-D Cell Reference from multiple worksheets: Add worksheet to the left of January named Annual Copy values and formats from the January worksheet across the worksheet group: January tab/ & hold/Annual tab to select Jan and Annual sheets In Jan worksheet: A1:B22: Edit/Fill/Across Worksheets/All/OK Ungroup worksheets: he formats and data have been copied Enter formula that includes the 3-D reference: Annual tab: B:8 =SUM (Click the Jan. tab/Last Sheet Button ((| ) //December In the December worksheet click B:8 The formula should read: =SUM (January-December!B:8) Use the fill handle to copy the formula to B:11 Annual tab: B5 type All Months End of Session 4 Session 5: Tutorial 2 Formula and Functions Validation Rule Open: Budget1 Function: redefined formula that performs calculations using specific values call arguments Calculate totals using the SUM function (") Click B8 Type the formula (Formulas ALWAYS begin with =) =SUM(B6:B7) : indicates that the first and last cell and everything in between are used in the calculation , indicates that only the cells listed are included in the calculation Click B22 and type the formula =SUM then use the mouse to select the range B11:B21 Calculate the net income for the first month: Click A24 and type Net Income In B4 enter the formula: =B8-B22 Formulas can be copied and pasted or filled using the + handle Copy the formula from B8 to the range: C8:M8 Copy the formula from B22:B24 to C22:M24 ESC removes the marching ants from the selected range Calculate total using Absolute reference cell Click A25 type: Running Total C25: type the formula: =SUM(B24:C24) Change B24 to an absolute reference ($B$24) This can be done by positioning the curser in front of B24 and pressing the F4 key. This will cause the B24 reference to remain constant while the second reference remains referential as the formula is copied down the column. Paste Special determines what is pasted into a cell: Edit->Paste Special Zoom feature: determines what you see: It does NOT change the print size Change the 100% on the toolbar to another setting Copy the Income and Expense categories: A27: YEAR-END SUMMARY Copy: A5:A24 and Paste it into A29:A48 B28: Total B30: Formula: =SUM(B6:M6) B30: copy into: B31:B32, B35:B46 , B48/ Paste Functions: Average / Minimum / Maximum C28: type Average C30: Insert Function button from tool bar/Statistical/Average/OK B6:M6 are the cells to average/OK C30: copy Select (using Ctrl) C31:C32, C35:C36, C46:C48/ Paste Fill Handle Calculate the year-end minimum and maximum amounts D28: Minimum E28: Maximum D30: formula =Min(B6:M6) E30: formula =Max(B6:M6) (The amount 2,400 will appear in both cells) Select the range: D30:E30 Use the fill handle (+) in the lower-right corner to fill from D30:E48 Select: D33:E34, D47:E47 and delete the contents Using the delete key will delete the contents: Right-clicking and choosing delete will delete the whole cell causing the sheet to change shape by moving cells into the vacant space Use AutoFill for months of the year: Ctrl+home B4: type Jan. Use the fill handle (+) and drag from B4:M4 The computer will add the months in abbreviation across the selection as you drag Date Functions: Switch to the Documentation sheet B4: type formula =TODAY() Todays date will display Insert a New Worksheet within Budget and name it Loan Analysis SaveAs: Budget3 A1: Loan Analysis Copy the labels and the average values from the Budget worksheet (A3:B22) Switch to Budget worksheet and select: A29:A48, C29:C48/Copy Switch to Loan analysis worksheet A3: Paste only the values (Edit/Paste Special) Modify the layout and replace some of the values with formulas: Remove highlighting from pasted range B6: AutoSum (B4:B5) To calculate the total average monthly income B20: AutoSum (B9:B19) To calculate to total average monthly expenses B22: formula to calculate the average monthly net income =B6-B20 Enter the conditions of the loan D3: Loan Conditions D4: Loan Amount E4: -175,000 D5: Length of Loan E5: 30 D6: Annual Interest Rate E6: 5.5% D8: Payment Conditions D9: Payments per Year E9: 12 (for the number of payments per year) D10: Total Payments E10: =E5*E9 D11: Payment Amount Payment Function: PMT functions will calculate the monthly payment required to pay off a loan. The syntax of PMT: =PMT (rate, nper, pv) E11: Insert Function (the pull-down arrow beside the sum button ["] on the tool bar) Choose PMT Rate: E6/12 (E6 is the annual rate; divide by 12 to get the monthly rate; [divide by the amount of payments per year; it would be 6 if you paid bimonthly]) Nper (number of payments): E10 (Use E10 because you have already multiplied the years by months in the sheet: If that is not done you would use the years cell * 12) Pv: (present value): E4 OK A9: House Payment B9: formula to make the value of House Payment equal to the value Payment Amount =E11 (this recalculates the average total monthly expenses) What-if analysis E4: -250,000 The calculations change Undo change E6: 6.5% Calculations change Undo Change Save Calculate familys yearly net income: D13: Is the loan affordable D14: required Savings E14: 5,000 D15: Calculated Savings E15: formula to calculate how much the family saved in one year using the average monthly net income multiplied by 12 months =B22*12 (approximately 4,672) Logical Functions: A function that tests or evaluates whether a condition in the workbook is true or false IF function: Gives you one evaluation if true and another if the value is false D16: Conclusion E16: formula to determine if the loan is affordable =IF(E14?@JLWfgy3 6 zjzZzOGCCCh(mhh.i6hOh.iCJaJh(mh1%5CJOJQJaJh(mh5CJOJQJaJh(mh.i5CJOJQJaJ"hOh1%6>*CJOJQJaJ"hOhO6>*CJOJQJaJ"hOh.i6>*CJOJQJaJh.ihZ956OJQJmHnHuh R56OJQJjh R56OJQJU"hOh.i56CJ$OJQJaJ$ @g5 6  E v & Fdhgd(m & Fgd(m 0^`0gd(mgd.i$0^`0a$gd$a$gdO$a$gdO$0^`0a$gd R$0^`0a$gd6 F w x         7 8 E H K M N h i v ) * 0 2 3 p ~      O b 9 : < = > A B O Q Z  hOh.ihOh.iCJaJ h h h CJaJ h(m6h h(mh.ih(mh.i6Mv * p O 9 : ; < = > ? @ A B Q  & Fgd(mgd gd.i & Fdhd[$gd & Fdhgd  & Fgd & Fdhgd(mFGH\g~&:fGHUVbcɾ h76h7h.i6 h75>*hKh7h.iOJPJQJo( h.i5>*h"{hOh"{CJaJhOh.iCJaJhOhjh 56OJQJ^Jh h 56OJQJ^J jh.ih.i jh.i0HQ]foy$0$If^`0a$gdj $$Ifa$gdj 0^`0gd 0^`0gd.i% $Ifgdjkd$$Ifl֞t eVH:," t0644 la0$If^`0gdj $Ifgdj % $Ifgdjkd$$Ifl֞t eVH:," t0644 la )7:<=0$If^`0gdj $Ifgdj=>GT% $Ifgdjkd*$$Ifl֞t eVH:," t0644 laTeo}0$If^`0gdj $Ifgdj% $Ifgdjkd$$Ifl֞t eVH:," t0644 la0$If^`0gdj $Ifgdj% 0^`0gd.ikdT$$Ifl֞t eVH:," t0644 la~ )D&>2Ff & Fgd.igd"{gd.i 0^`0gd.ifVl   q^kd$$Ifl0 ' '644 la]p0$If^`0gdJ 0^`0gd7 0^`0gd.igd.i cdekl  $89:AKU_`ahowįĕĕįįĕįįĕįįĕn^hO56OJQJ\]^J$hOh.i56OJQJ\]^J&hO56CJOJQJ\]^JaJh.iCJaJ#h.iB*CJOJQJ^JaJph3f)hYVh.iB*CJOJQJ^JaJph3fh.iCJOJQJ^JaJh.ihOh.iCJaJhbh.i5 hbh.i hbh7hbh76$9:M2^kdU$$Ifl0 ' '644 la]p0$If^`0gdJ^kd$$Ifl0 ' '644 la]pM`ap2^kd$$Ifl0 ' '644 la]p^kd$$Ifl0 ' '644 la]p0$If^`0gdJCSTUVWXYv *_`2 & F gdj 0^`0gd.iSVWYtv_`0134<=ɹ鉂zuj\Qh R6>*OJQJhIh R6>*OJQJhY6>*OJQJ hj6hjhj6 hjhjhj hX7h.ihYh.i6>*hY,hp3h.i56CJOJQJ\]^JaJh56OJQJ\]^Jh R56OJQJ\]^JhO56OJQJ\]^Jh.i$hOh.i56OJQJ\]^J234Sopqr(9m&'8=gd R$0^`0a$gd R$a$gd R 0^`0gd.i=FSnpqrx~(n&'8MNf|ʽ|||||jWPjWPWP h^h R%h^h R56KH OJQJ\^J"h^h R5KH OJQJ\^J%hIh R56KH OJQJ\^J$h R5CJ KH OJQJ\^JaJ h R5>*h RhIhR5CJOJQJaJhR5CJOJQJaJh R5CJOJQJaJhIh R5CJOJQJaJhIh R6>*OJQJhj6>*OJQJ=&5MNf|}ABMxy 0^`0gd Rgd RABKMxy\ ] q s :!H!!!!!!! ""*"@"A"X""ʺ۝۝ۀ|i$h R5CJ KH OJQJ\^JaJ h R%hIh R56KH OJQJ\^Jh^h RKH \h^56KH OJQJ\^Jh^h ROJQJ^Jh^h R56OJQJ^Jh^hj56 h^h R%h^h R56KH OJQJ\^J"h^h R5KH OJQJ\^J% = 4 \ ] s !9!:!H!n!! p`^p``gd Rgd^ `^``gd R 0^`0gd R!!!!!! ""*"@"A"X""""""""""#f#g#s#z#### `^``gd R""""""""#f#g#s####$$3$Y$Z$i$>%?%S%%%%&&&&&&&&+&7&ȵȵȵȵȵȵȵȵڭ}mhIh5CJOJQJaJh6>*OJQJhIh6>*OJQJh^6>*OJQJh.ih^h\?5h^h R5%h^h R56KH OJQJ\^J"h^h R5KH OJQJ\^J h^h Rh^h R56OJQJ^Jh^56>*OJQJ^J$#$$3$Y$Z$i$$$%8%>%?%S%q%%%%%%&&&&&+&$a$gdgd.i$a$gd R `^``gd R+&7&R&S&b&c&~&&&&&& '')'I'v'''( (7((( 0^`0gd `^``gdgd$a$gd [$0^`0a$gd7&Q&R&S&X&b&c&~&&& '( (7(((((()))**:*****$+%+'+J+++++ѿۿۿۜ۔یۈۀۿm]ۿh56KH OJQJ\^J$h5CJ KH OJQJ\^JaJ h^h>*h^h^h6h^h:h^h56OJQJ^J%h^h56KH OJQJ\^J"h^h5KH OJQJ\^Jh^h5>* h^hh5CJOJQJaJh [h [5CJOJQJaJ$(()))*9*:*D*P*a*n*}*********++ gd gdgd `^``gd^gdY 0^`0gd+$+%+&+'+J++++++++ ,?,_,,,,---.C.../^gd `^``gdgd++ ,,---... /!/M///0000,1B1D2E2]222222233G3333344142474C4s4}4Գ}yhZ9 h^h]'hAhA5hAh [h]'hV h^h [h^h [56OJQJ^Jh^h `56OJQJ^Jh^hKH h^h6 h^h%h^h56KH OJQJ\^J"h^h5KH OJQJ\^J,/ /!/M////0e0000,1-1B1d111D2E2]222222 0^`0gd `^``gdgd223G3324C4s455P6Q666B7C7D7U7V7W7m777$0^`0a$gd [$a$gd [$a$gd [ & Fgd]'gdVgd [}4~44444444444555595:5g5h5555555555555666666(6)6L6M6O6P6Q6D7T7U7V7W7_7ƶhIh [6>*OJQJhR6>*OJQJh [h [h5CJOJQJaJh [h [5CJOJQJaJ h^h [ h^hA jhAhAhL jhLh]'hZ9 h^h]' jhZ92_7`7m777777777T88888p9}9 :":%;&;5;B;;;;;;;;;<<0<1<@<C<<<8=9===нгСЙЙЙЃ|tЃЃ|oЃ h]'6h]'h [5 h]'h [h]'h]'h [56h^hY6h^h [6"h^h [5KH OJQJ\^Jh^h [5>*%h^h [56KH OJQJ\^J h^h [hIh [5CJOJQJaJhIh [6>*OJQJh [6>*OJQJ+777777778T8p9}9 :":%;&;5;D;j;;;;;;<<`gd]'^gd [gd [ `^``gd [<<0<C<8==\>]>h>u>>>>???5??????????? `^``gd [^gd]'gd]'gd [===\>]>h>>>??????????aAbAxAAAAAB B]BgBCCnDoDpDDyEzE|EzuhhL]&5CJOJQJaJ h [5%h^h^56KH OJQJ\^JhR56KH OJQJ\^Jh^h [6hBx56KH OJQJ\^J"h^h [5KH OJQJ\^Jh^h [5%h^h [56KH OJQJ\^J%h^hR56KH OJQJ\^Jh]' h^h [%?&@p@@1AaAbAxAAAAAB3BQBiBBBJCCCCC(D9DnDoD^gd [ `^``gd [gd [oDpDDDDXEyEzE{E|EEEEEEEEEEEEE$0^`0a$gd [$a$gd [gd.i$a$gd [ 0^`0gd [gd [ `^``gd [|EEEEEEEEEEEEEEEEFF FUFVFøèvdQG??h^h [5 jh^h [%h^h [56KH OJQJ\^J"h^h [5KH OJQJ\^Jh^h [5>* h^h [h [h^fhL]&5CJOJQJaJh [5CJOJQJaJh^fh [5CJOJQJaJh [6>*OJQJh^fh [6>*OJQJhBx6>*OJQJhRh]'CJaJh]'CJaJhRh [5CJOJQJaJEEE5FFFF5GaGGGGGGG%HoHHHII`IIIJJ `^``gd ` 0^`0gd [ `^``gd [VFWFGGGGG%HI II`IJJMJJJJSKTKVKWKhKiKjKkKlKtKuK﫞{tbTIh [6>*OJQJhSZh+6>*OJQJ"h]'h]'6>*CJOJQJaJ h]'h]'h]'h]'6>*CJOJQJaJh [h [5CJOJQJaJhL]&5CJOJQJaJh `5CJOJQJaJ jh^h [h^h [5%h^h [56KH OJQJ\^J"h^h [5KH OJQJ\^J h^h [ jh^h [JMJJJK3KRKSKTKUKVKWKhKiKjKkKlKKKK$0^`0a$gd+gd]'$a$gd+$0^`0a$gd [ 0^`0gd [ `^``gd [uKKKKKKKKK*L~LLLMMMMQNNNNODOOPgQQQQQ.R/R1RĽ|rr_$h^hR56OJQJ\]^Jh^h\?\]h^h\?6h^h\?5'h^h\?56OJQJ\]^Jo($h^h\?56OJQJ\]^Jh^h\?5>* h^h\?h `hSZh [5CJOJQJaJh+5CJOJQJaJh [5CJOJQJaJhSZh+6>*OJQJ KKKK*L,LLLLMM-NLNNNNNNOODOqOOOOP+P 0^`0gd\? 0^`0gd\?+PBPXPgQhQQQQQQ.R/R0R1R2R3R4R\RzRRRRRSS*S & Fgd\? 0^`0gd\? 0^`0gd\?1R3R4RFRGR\RS*SUVgVhVVVVV(W*W+W,W/W0W9W:W=W>WFW[WqWyWWWͽͶͶ{rfrfrfrf_U_h^h+5>* h^h+h^h+6CJaJh>6CJaJhRh\?6CJaJh^h\?6CJaJh^h `5h^h\?5 h^h `h^h\?CJaJ h^h\?hBx56OJQJ\]^J$h^h\?56OJQJ\]^JhI56OJQJ\]^Jh^56OJQJ\]^J*SDSSSSSS'T;TPT]TiTvTTTTUAUUV%V;VVVVVWgd\? 0^`0gd\? 0^`0gd\?W(W)W*W+W,W-W.W/W0WqWWWWWXDXuXvXXXYdYgd+ 0^`0gd+gdRgdf$0^`0a$gd\? 0^`0gd\?WWWWW_XtXuXvXXXYYYYYZZZZ:[;[\\(\v]_^`^^^^__ȶ~pibib[b[b h^h  h^h5Z h^hXfh^h5tOJPJQJo(h<%h^h5t56KH OJQJ\^J h^h5t%h^hI56KH OJQJ\^J h^h% h^hMGhBx h^h+%h^hMG56KH OJQJ\^J%h^h+56KH OJQJ\^J"h^hI5KH OJQJ\^J dYYYYYYYY ZZ,Z5ZLZbZZZZZZZL[(\>\v]`^x^{^^^^gdf^_+_8_9_:_S___h_|________ `````aa`apaaaa^gdf_*_+_8_9_:_S_____````````aa_a`aeaoaaaaaaaнཫwslblll[l[NhR56OJQJ^J h^h!\hBxh9M56 h^h9MhBx%h^h#+56KH OJQJ\^J%h^h9M56KH OJQJ\^J h^h>( h^hmM"h^h&K5KH OJQJ\^J%h^h&K56KH OJQJ\^JhL]&56KH OJQJ\^J"h^hI5KH OJQJ\^J h^hXf h^h&Kaaaabbbbbbbbbbbbbbbcc c cc c!c"c#c 7$8$H$gdL]& 7$8$H$gd [aaaaabb$bbbcc c cc c"c#cxcyccccccccccccccccccccc $%'*46=>¾ٯՈنِUhThT>*hTh [>*hTOJQJh8OJQJ hTh8h^OJQJ h^hL]&hL]&hR h `h [hRxh8hT h^h [h^h\?56OJQJ^Jh^h [56OJQJ^J4#c8c9cxcycccccc%56Ljo 7$8$H$`gdBx & F7$8$H$gdBx 7$8$H$gd [ C5: 2046 D4: 9.50 D5: 40.00 E4: 2 E5: 4 Entry 3: Entry 4: A6: 11/9/2004 A7: 11/09/04 B6: Downtown parking B7: Cinema Tickets Staff Party C6: 2047 C7: 2049 D6: 95.00 D7: 150.00 E6: 3 E7: 4  While you could post each individual entry to the appropriate column, Excel can do it for you if you write an IF function to do the work. F4 Type Formula: =IF($E4=F$2,$D4,0) Copy and Paste in cells F4:I7 Ignore all the zeros for now. You'll see that all the figures from column D have been posted to the correct columns in the worksheet. Add a Total line for the values in columns F thru I. End of Session 5     Page  PAGE 7 Page  PAGE 9 >CJKLNYijl~o~8=qrs~vjh!Uh^fh\?hIOJQJh\?h [5OJQJh\?h [5CJOJQJaJh `h0i5 h [5 h `h [hIkh [ hBxh [ hBxhBxhBxhBx6jh0iUmHnHuh8 h^h [hThT>*hT,:;pqrs 0^`0gdb9gdYaj$a$gd6 $a$gd [gd [ 7$8$H$gdIk 7$8$H$gd [h^fhA0JmHnHu hA0JjhA0JUhAjh!Uh! 0^`0gdb95 01h:p/ =!"#$8% K 01h:pT^/ =!"#$% P0 xx5 01h:pR/ =!"#$8% n%e:d@,D" y3PNG  IHDRotgsRGB pHYsod%\IDATx^흽$Ri$X/+`@Huf3x8#p00x~k#X ܡ.yJ/;:tGQYQYun_~~sm'>U @ henOtb4sQZ*j2^q5Z"PUr~P06ZvW+ 3 x]_x7)emKM_l  i3u 5?YW-WbxZ@YcZq6LМm+,gt<Ȑ( ~{=wyA*qUU]zocmuhlٌh<(LbtΙD:JY{A@1LhxM,";$mehFv{fbc%wknLv̔7ytNRGiތg(u^LGŰX4C@D`L+\e>fZ<[i|s$G{wx[QKTw)5?]=‡ `H`V]SWt70fU3m}׾}NWMN𻲖x'%>渫ͅ@@%0K+;h;ڢI=ûK~1hz׬Lj{%*  [TLC͉_Lbռ7tǫ#n 3R][J\*ߩ)OQ;Q4hyξa   XgvQ`6}^W}.JIޏv}{]d"> ],fFVFE+7[҄7)C@H`@+CN"`Ǵ9fmTFAIheNDj#7]* '9 @mKyۨV!k $!@ǩ@V$p/jE ln?k>!JV#F.[y{b}?]~8'Y`ۯI@ 0蘄 @27~g5l@k5* s^6i/79ܾU-V,X'ǁZ(VQln{zbst1 }MTVa6h8$<^Hk2H@7/65?[mE(O :^)!c8Z)x?Dz&2ϔc]]5ɌG>@½2'BenJ`VWxN+nϺq{0o<îL |O0xxm2}:k.O\A vV&*:3@\D@TQ٪kPʐgwLg:SB&yy4Em^coF;πq\3 t݌}Cf!♺)iҕqS߱M+ a{8TLղ\8zw%dU S2VA jf  n߽}@ NwK!9nV7>}9Nx<{K? auD/TWT7 a  hez @VF @V>7 @%Pkeɧ@@@OVM= @OE@+T8 ʬ/ @ @Xu@he@&@+pp +T  @[i]1@ @+C @ 0wo*@  VO?|19svI.uuD/TWT7 a  hez @j7~ M l n7[ݴmnF Gn m![ٶG XX$y5Y.FSke[ ;.Jf]_lR+sT 8>cMc^v$heL+e dvQW2n( @'ڀ^r+Cs!%pXl]hec8@1 gMe$w̽Aset/!@B`>fsHMxEk\-$h^qU60>"oV`!YWL||EcrNq^\L_L?""Cn0D @ &=@ ϕe2OC v!}a= C,u(I~>MhzMQĤt8$Ix sj -4zdU{(˴pg!L J?J<|-JE>~8~LEviYb> i;Hy~zqa[GY=}P0~fIgș>.o/!O`^hٝK3J*tWiPtꘇb"WN5kRɴE:C@].iW^ݦi̙8+i*}CΆH5Gij)t|Ta3LH_+! Kuh俌X}g{Pte47R"Y+yj3H4LTP%JL$z2UhHo4hxTgTE^4.c~L `f:t~NT -3iTmn/4Jhev{eVtrF~r/T%o\\J!L^tQ'ZhЩ)k:LC\SJa\:j( '%OVļdGzCC$P:|"hͫ f|E7*%;/;"jw5%r6^_w{U;Wd٢psBi)`}Zd%SGzhʸEDݨ(3*CGv%kg8c' 1YGPz{pNM= N,}j4|O,ڗe/v5X9W̾e|tku$Jvʝ[}aL}, y~#)n[l;5Q>pm$lX΄]^OM4[V2>^ö_!e456MN-J;+UTxHmv=+\p%Ebz} %&gRzKV7l:}#5s,!GZ}NKZ? u*BT?zbL#vE&ƺ܉g(`uC///P9 ܾ n&(P!pꈖ&-1M 8]Y~7z h*]2BZc @PV?@I;"쨊*gTQN+IwK2poڨG1yI X9OM^bE cVѓ[>}fcf[T ;yԺgQ}:A&>XWVC2@Q(WGP? ȭLW웾D? VytRH ̶$1Qj-Qm2j*QVcHW?1,2 &CGriܫ.ݖ]S?H!Z#K2]K{Uu;$[F8GG LGb WәEOL.mo~@sA0Ļm͆Gjr[Kn0~Z%/*'Q3>5UuPE 1lQL39PWje,dW>7#7 Bi(tXM+Q(|( KRC`rj2[-B~@(ý@)}{ /~gn_~MML>(S2J]Apn~K]JVT(&ກ~ƍh"mnA?*@H`[hRn?k/?}ዉ!J~b9\ꈖ[&-1M Wv4PZ~x!CԌe lmv˦ P&@+Cu@~VR rj7~>Af.XyDvTEզY|!j6`NF58X~+1<V?婎n}+l;ioD}orn:<+Ӈ YNQ!"&Р!pVc4֏Y dYtK g' ܯ(~%\c,-SdRmQgmigK^ww/N&|NQ,ۣ\\ٱM1dQHoԫxɠ&)ܘKOľ$+nG GD@2wo{*@  ~O?|19svI.uuD/TWT7 a  hez @Ns'U ř}ɎrCJÁy\ԮI4,ͅT)#yHtW]?k>QLd #꽆jO=$#O:<+'ܺ{)g{JGO@!M,n!/z(T+犏WAN&6dT>)X`j}tiysN4V}b737 k;<'mee&m2oճ=Nɇ_lSؐtHCyiI)(j<%as7ohs%&sPWeap]]3[ CzOUq'0l/<" _?{k R]L@l=yĝ 9%;Ŵ;m*f\w><4FWUbyeAX]^GLϥj8 yG1J.\H$G町i,/mUź 5Oժv% I3/W'9/s_2/srfe#xSMMO3vH9aƷ2<)Dd%ܪ&IEwwYsJOTЩ X!ΓhtxgxB]_wldE×nFzUu'$l)7.YJPiV v+|_q)#ɱ~MM wVܫm!m>edᛑr#]f/ě)'Pa)Ns`J ށi)}M98V {Pd~p /ğ7Ͼ7"ATX*8@he.ܑm/wFm@XV>zJz @j?_>|јSx9}WӺ:"S|O+*PL0Q@@o2c CV&|{f5Mʛ]"x8쨊*7(5 ]{8 !O;` ulQDUW9ƺf}ѣc$5d="/|Lۖ}p .图9+4 붢6&D_X020s.m݄WS'`r5 @V8ZI#wRDθd %)xWnejAvaoȱw4~A]EpA>jB#t.#]`lC Z2=[$6j]S[VfT_Ka{uu7Uݩ; .רڸ%j_55 S^B+Ӽ$Z-="6{v!6*~)LG G&@ms`SRTkjŬ͙ ^Fu3ӭx$M;]VF)VpJx{<|sM*k~8I)4[ke,4$^(%öWr23?E׻WfG)SX!Uv $9g(G'Rm.i~ C\ZQzN1ed/[sbWќgR E#ʄ}%_\ GJM}EFmhk%I_m44N^@F_53ڐ@dD7wKZ+X(1sf$Oë(QH7l}YKVF M(4Τ^[2*zM*kfbótTy'РÐD& 9~Z9/h @he.V < wob}*@  Ɇҧ_>|јSx9}WӺ:"S|O+*PL0Q@@o2c C~_C @VnƊ8z @0$ &C @7Zı@!b+Zeن P@+b @heNC @+C @ 0.<\ @*>"R @`B`0)@r LH[+^~c = @@Cmȉ2>|EVxiݻcs:"S|O+*PL0Q@@o2c CV&s&Q@$H 4:&!@"@+cE=  jeM3\$ @ճg$g #sT" @zP` v @>/c{M^14 @]W f@ pʜ t!^.1@9heV@ЫoT hܬǗ_4&y<}N.Ŵ*S/"2!LTA ЛLo؃ @y)y< @V&Si?}8c!@0$ie3|Q@2wN @`#_ ,<\ @V @`a2 '!@ @Xپ>"8-p\ \@y"@4 ,L@*p|@ \:@:wob|*@  O?|19svI.uuD/TWT7 a  hez @ LMCoP@vȷ21 " @(Vfcҽ7G9]@ dZww@ `Hm0Q@@o2c C20Q@@o2c C20Q@@o2c CVdRF @'`U$ @Z@In߽R+U @7HǗ_4&y<}N.Ŵ*S/"2!LTA ЛLo؃ @@B3yTA #Ll[jo @GdZS[m >(c!@@J иP( Bmd ?!@ʤ @Fnjv!@PC F@̖9 @`#je܃dxJ@lLxla @I@*h /`jIENDB`$$If!vh5555555#v#v#v:Vl t6555$$If!vh5555555#v#v#v:Vl t6555$$If!vh5555555#v#v#v:Vl t6555$$If!vh5555555#v#v#v:Vl t6555$$If!vh5555555#v#v#v:Vl t6555$$If]!vh5 5#v #v:V l6,5 59/ /  / a]p$$If]!vh5 5#v #v:V l6,5 59/ / / /  a]p$$If]!vh5 5#v #v:V l6,5 59/ / / /  a]p$$If]!vh5 5#v #v:V l6,5 59/ / / /  a]p$$If]!vh5 5#v #v:V l6,5 59/ / / /  a]p@@@ L]&NormalCJ_HaJmH sH tH Z@Z + Heading 1$<@&5CJ KH OJQJ\^JaJ \@\ .i Heading 2$<@& 56CJOJQJ\]^JaJDA@D Default Paragraph FontRi@R  Table Normal4 l4a (k@(No List4@4 /Header  !4 @4 /Footer  !.)@. / Page Numberj@#j .i Table Grid7:V0(!!5[ 7  @g56Ev*p O9:;<=>?@ABQHQ]foy )7:<=>GTeo}~ ) D  4 @  D Z ' ( ; N O ^ 1 x ABCDEFGdwMN !"A]^_`mn'[&+t#;<Tjk/0;fg+p"JKa'(6\opx./F{| TUah!GHW&,-A_r%@APQlo 7dv %| !'!(!2!>!O!\!k!!!!!!!!!! """""8"t"u"""""""-#M####y$z$$ %1%%%%&&;&v&&&&S'{'|''((0(R(q((2)3)K){)|))))))5** +1+a++,>-?---0.1.2.C.D.E.[.m.n.v........B/^0k00122#222X222222233313&44J5K5V5c5y555556#666666666667^778O8P8f88888 9!9?9W9998:::::;';\;];^;w;;;F<g<h<i<j<{<|<}<~<<<<<<<<<<<#=z===#>O>>>>>>>?]?????N@@@ A A;AAAA!B@BABBBCBDBEBVBWBXBYBZBqBBBBBBCC0C9CiCuCCD:DvDwDDDDDD2E_EEEEEF0FFFUGVGGGGGGHHHH H!H"HJHhHHHHHHHI2IuIIIIIJ)J>JKJWJdJpJJJJ/KK LL)LLLLLLMMMMMMMMM_MoMMMM N2NcNdNNN OROOOOOOOOOPP#P:PPP}PPPPPP:QQQ8RRRR S[SSSSSSSSSST T T1TMTcTnTTU!U"U5UUUUU!V9VFVUVVVxVV W WWWW W(W3WDWNWVWdWoWzWWWWWWWWWWWWWWXX4XSXrXXXXXXXY2YKY[Y]Y^YYY Z+Z,ZZZZZZZZZ[[[[[[ [ [ [ [[ [2[3[6[00000@0@0@0@000 0 0 0 0 0 0 0 0 0 0  0  0  0  0 0@0909090@0=0=0=0=0@ 0B 0B 0B0B0B0B0B0B0B0B0B0B0B 0B 0B 0B 0B 0B 0B 0B 0B 0B0B 0B 0B 0B 0B 0B 0B 0B 0B0B 0B 0B 0B 0B 0B 0B 0B 0B0B 0B 0B 0B 0B 0B 0B 0B 0B0B 0B 0B 0B 0B 0B 0B 0B0B0B0B0@0000@ 0 0 00000000@0 0 0@0 0@04 04 04 0@0 0 0@0 0 0@0Z 0Z  0Z  0Z  0Z  0Z  0Z  0Z  0Z  0Z  0Z  0Z  0Z  0Z  0Z  0Z  0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 0Z 000"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"0"00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 0 0 0 000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 000 0 0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 00 000000000000@0y00@0y00@0y00@0y00@0@0@0@0y00*p ' ( ; N O ^ VBY+Z,Z6[{00{00{00{00{00@0 {00{00@0{00{00@0{00{00@0{00 {00 @0|@0{00 {00{00 22256 c="7&+}4_7=|EVFuK1RW_a>257DHJLORUXY\_acfilnrtv  =TfM2=!#+&(+/27<?oDEJK+P*SWdY^a#c3689:;<=>?@ABCEFGIKMNPQSTVWZ[]^`bdeghjkmosu4 5>5[&-/5!!l,b$e:d@,D" y3%@,(    c TA. S`TS`T"`B S  ?[Y5[Lt" 4D/ /k /0 /Ď /ώ /T0/0/0/1/T1/1/1/2/T2/2/2/3/T3/3/3/4/T4/4/4 /5!/T5"/5#/5$/6%/T6&/\S  GGTT\_ V!V!6[       SS[^dd ##[![!6[   9*urn:schemas-microsoft-com:office:smarttagsState>*urn:schemas-microsoft-com:office:smarttags PostalCode=*urn:schemas-microsoft-com:office:smarttags PlaceType=*urn:schemas-microsoft-com:office:smarttags PlaceNameV*urn:schemas-microsoft-com:office:smarttagsplacehttp://www.5iantlavalamp.com/8*urn:schemas-microsoft-com:office:smarttagsCity;*urn:schemas-microsoft-com:office:smarttagsaddress:*urn:schemas-microsoft-com:office:smarttagsStreet QZoy,,3-:---. .E7P799 LL_MeM0Q4Q6Q8Q8Rg>HAJAAAAAB BjCnC1F5FrFvFFFHHHHLJPJeJiJOLYLLLNN"O$O6Q8QRR"V%VVVYY[[[[[[[[ [ [ [ [3[6[33333333333333333333333333333333 ?)))5*******+0+a+l+m+++=-?-?-v.v.!H"HKYKY[Y\Y]Y]YZZZZ[[[[[[[[[ [ [ [[['[1[6[[[[[[[[[ [ [ [ [3[6[p/X3h>t9qR qU:5VA!)Ao"rrX$V+Ja32e[B:eK>gSږjg'Sh.@S˨t\Y -!eaf ~m6|a>mqnq uHs@t\s2gA{ v;|h^`OJQJo(hHh ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h^`OJQJo(hHh ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h^`OJQJo(hHh ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hHh ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h^`OJQJo(hHh ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h^`OJQJo(hHh ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h^`OJQJo(hHh ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h^`OJQJo(hHh ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHhhh^h`OJQJo(hHh88^8`OJQJ^Jo(hHoh^`OJQJo(hHh  ^ `OJQJo(hHh  ^ `OJQJ^Jo(hHohxx^x`OJQJo(hHhHH^H`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHhhh^h`OJQJo(hHh88^8`OJQJ^Jo(hHoh^`OJQJo(hHh  ^ `OJQJo(hHh  ^ `OJQJ^Jo(hHohxx^x`OJQJo(hHhHH^H`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hHh ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h ^`hH.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h^`OJQJo(hHh ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hHh ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.h^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hH~mqUgSeKg'Snq@S-!eae[BA{ v)Ao"s@t``p/`>fA!a32\9qR`rrX$>mq                                                                                                                                                                                                      !\Vf\?] 6 ) 5tSYV)KR"{9^R?  R !l"h#L]&]'`'5J*W*#+t+b6&3C9CxDEEII!8Ik[I.JO=P0SZT_UXVguWX|=X ZT^C\_z!`p`efoIfmf7g0iGjYajj kmem(m%nEUrrs!u(vBx:{|?l|j5}D~zG81%5Z+K7dKMdBSZIk w%~M5f%<.iY^dy"%MGp!x)A J!/<:\f 8!DYC&K/7LmM60rt~5Nbm b9J9M `y(M [J_D,RxgZ9|Co?qr o\V>(Tq%e^f ;cXf @>bs])7:<=>Geo} ' ( ; N O ^ 6[@----d BC}Q}RzX5[@(@L@\@@UnknownG: Times New Roman5Symbol3& : Arial7Georgia?Wingdings 3A& hMS UI Gothic;Wingdings?5 z Courier New"1h{ڌ& 4b lM. lM.!4dZZ2QHP ?+2Session 2: Tutorial 2 cont djhimesInformation Servicesd                 Oh+'0 0< \ h t  Session 2: Tutorial 2 contdjhimes Normal.dotInformation Services20Microsoft Office Word@WA'@ys@И$@4 lM՜.+,0 hp  Liberty University.Z Session 2: Tutorial 2 contd Title  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ Root Entry Fp.4 Data 1TableWordDocumentSummaryInformation(DocumentSummaryInformation8CompObjq  FMicrosoft Office Word Document MSWordDocWord.Document.89q