Download
powerpoint presentations n.
Skip this Video
Loading SlideShow in 5 Seconds..
Powerpoint Presentations PowerPoint Presentation
Download Presentation
Powerpoint Presentations

Powerpoint Presentations

138 Vues Download Presentation
Télécharger la présentation

Powerpoint Presentations

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Powerpoint Presentations Ideas for Glitz & Some ideas for substance

  2. What can you do? • Cute things for a slideshow • Backgrounds (try ‘em all -- use one you like) • Clip art (really cute, this...) • Slide “builds” • Slide transitions • Clicking on objects (v. 7.0) • Builds and transitions can be useful...

  3. What can you do? • Cute things for a slideshow • Backgrounds • it’s not hard to get carried away by templates... • Clip art (really cute, this...) • Slide “builds” • Slide transitions • Clicking on objects (v. 7.0) • Builds and transitions can be useful...

  4. What can you do? • Cute things for a slideshow • Backgrounds • and borders... • Clip art (really cute, this...) • Slide “builds” • Slide transitions • Clicking on objects (v. 7.0) • Builds and transitions can be useful...

  5. What can you do? • Cute things for a slideshow • Backgrounds • until the background overwhelms the message.... • Clip art (really cute, this...) • Slide “builds” • Slide transitions • Clicking on objects (v. 7.0) • Builds and transitions can be useful...

  6. What can you do? • Cute things for a slideshow • Backgrounds • what really works for your purpose....? • Clip art (really cute, this...) • Slide “builds” • Slide transitions • Clicking on objects (v. 7.0) • Builds and transitions can be useful...

  7. What can you do? • Cute things for a slideshow • Backgrounds • what really works for your purpose....? • and in case you hadn’t noticed, color is distracting... • Clip art (really cute, this...) • Slide “builds” • Slide transitions • Clicking on objects (v. 7.0)

  8. Is this a good thing? After the twenty-fifth picture? With the inevitable cartoons? ...and bad business graphics? Clip Art

  9. Clip Art Please ... ...let your art serve your content’s purpose and keep the cute pix to a minimum.

  10. What can you do? • Thoughts for a slideshow • Backgrounds • what really works for your purpose....? • and in case you hadn’t noticed, color is distracting... • Clip art (really cute, this...) • Slide “builds” • Slide transitions • Clicking on objects (v. 7.0)

  11. The Babson MBA~ First Year ~ Module 1: Acculturate - Build a base Module 2: External Competitive Perspective Module 3: Operational Effectiveness & Efficiency Module 4: Global Reintegration Mentor Company Project Foundation for real-world application and feedback

  12. The Babson MBA~ First Year ~ Module 1: Acculturate - Build a base Module 2: External Competitive Perspective Module 3: Operational Effectiveness & Efficiency Module 4: Global Reintegration Mentor Company Project Foundation for real-world application and feedback • Does this improve over a list of bullets? Maybe.

  13. What can you do? • Thoughts for a slideshow • Backgrounds • what really works for your purpose....? • and in case you hadn’t noticed, color is distracting... • Clip art (really cute, this...) • Slide “builds” • Slide transitions • Clicking on objects (v. 7.0)

  14. IF( ) Vlookup Charts Scenarios Macros Sheet Design Moving between Slides • Objects that shift between slides • A quick Excel briefing book • What have we covered so far? • Here are some examples

  15. Excel Help Files IF( ) • Objects that shift between slides • A quick Excel briefing book • What have we covered so far? • Here are some examples Vlookup Charts Scenarios Macros Sheet Design

  16. IF( ) Function IF(logical_test, value_if_true, value_if_false) Logical_test is any value or expression that can be evaluated to TRUE or FALSE. Value_if_true is the value that is returned if logical_test is TRUE. (If logical_test is TRUE and value_if_true is omitted, TRUE is returned.) Value_if_false is the value that is returned if logical_test is FALSE. (If logical_test is FALSE and value_if_false is omitted, FALSE is returned.) If an expense worksheet contains in B2:B4 the data for "Actual Expenses" for January, February, and March: 1500, 500, 500, and C2:C4 contains the data for "Predicted Expenses" for the same periods: 900, 900, 925, then generate text for a message with the following formulas: IF(B2>C2,"Over Budget","OK") equals "Over Budget" IF(B3>C3,"Over Budget","OK") equals "OK IF( ) Vlookup Charts Scenarios Macros Sheet Design

  17. Vlookup( ) VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) Lookup_value is the value to be found in the first column of the array. Lookup_value can be a value, a reference, or a text string. Table_array is the table of information in which data is looked up. Use a reference to a range or a range name, such as Database or List. IF( ) Vlookup Charts Scenarios Macros Sheet Design

  18. Create a Chart Create a chart If you want a chart to appear next to your worksheet data, create an embedded chart on the worksheet. To display a chart on a separate sheet in your workbook, create a chart sheet. Embedded charts and chart sheets are linked to the worksheet data they are created from, and both kinds of charts are updated when you update the worksheet data. You can create charts from cells or ranges that are not adjacent to (next to) one another. Control-click to select the nonadjacent range(s). Nonadjacent selections must form a rectangle. You can also create charts from a PivotTable. Tip As a shortcut to creating a chart sheet, you can select the data you want to plot - including category and series names - and then press F11. If Microsoft Excel cannot determine how to plot the data based on your selection, the ChartWizard starts. IF( ) Vlookup Charts Scenarios Macros Sheet Design

  19. Create a Scenario Create a scenario 1 On the Tools menu, click Scenarios. 2 Click Add. 3 In the Scenario Name box, type a name for your scenario. 4 In the Changing Cells box, enter the references for the cells that you want to modify. 5 Under Protection, select the options that you want. 6 In the Scenario Values dialog box, type the values you want for the changing cells. Tip Any cell that contains data can be a changing cell. The names you give these cells appear in related dialog boxes and reports. IF( ) Vlookup Charts Scenarios Macros Sheet Design

  20. Record a Macro Record a macro You can a record a macro when you want to automate a repetitive task. 1 On the Tools menu, point to Record Macro, and then click Record New Macro. 2 To give the macro a name other than the one Microsoft Excel suggests, type a name in the Macro Name box. 3 To include a brief description of the macro, type whatever text you want in the Description box. 4 To set options for the macro, click Options, and then select the options you want. These include choosing an accelerator key for running the macro. 5 Click OK. 6 Carry out the actions you want to record. 7 Click the stop button. (Don’t forget to do this...). To see the code you just recorded: Your macro is recorded as Visual Basic code on a module sheet. 1 On the Tools menu, click Macro. 2 In the Macro Name/Reference box, choose the name of your macro. 3 Click Edit. IF( ) Vlookup Charts Scenarios Macros Sheet Design

  21. Spreadsheet design ideas Some ideas for Spreadsheet design 1 Make as many assumptions explicit as you can. 2 Consider using named ranges to improve your later understanding of the logic and formulas you have created. 3 Think about laying the spreadsheet out in blocks -- assumptions, then preliminary calculations, then major calculations, then results. 4 Consider the layout of your sheet beforehand in case you want to graph parts of it after you’ve finished the arithmetic. 5 Never, never type what you can copy. IF( ) Vlookup Charts Scenarios Macros Sheet Design

  22. A Sequence for Spreadsheet Design & Construction Design Plan Analysis Plan Layout Plan Dynamics Plan Assumptions Implement Name Ranges Build Formulas Build Charts Record Macros

  23. Powerpoint Presentations Good luck with Module II