Powerpoint presentations
Download
1 / 23

Download PowerPoint 986 k - PowerPoint PPT Presentation


  • 342 Views
  • Uploaded on

Powerpoint Presentations Ideas for Glitz & Some ideas for substance 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)

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Download PowerPoint 986 k' - Audrey


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Powerpoint presentations l.jpg

Powerpoint Presentations

Ideas for Glitz

&

Some ideas for substance


What can you do l.jpg
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...


What can you do3 l.jpg
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...


What can you do4 l.jpg
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...


What can you do5 l.jpg
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...


What can you do6 l.jpg
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...


What can you do7 l.jpg
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)


Clip art l.jpg

Is this a good thing?

After the twenty-fifth picture?

With the inevitable cartoons?

...and bad business graphics?

Clip Art


Clip art9 l.jpg
Clip Art

Please ...

...let your art serve your content’s purpose

and keep the cute pix to a minimum.


What can you do10 l.jpg
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)


The babson mba first year l.jpg
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


The babson mba first year12 l.jpg
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.


What can you do13 l.jpg
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)


Moving between slides l.jpg

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


Excel help files l.jpg
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


If function l.jpg
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


Vlookup l.jpg
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


Create a chart l.jpg
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


Create a scenario l.jpg
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


Record a macro l.jpg
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


Spreadsheet design ideas l.jpg
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


A sequence for spreadsheet design construction l.jpg
A Sequence for Spreadsheet Design & Construction

Design

Plan

Analysis

Plan

Layout

Plan

Dynamics

Plan

Assumptions

Implement

Name

Ranges

Build

Formulas

Build

Charts

Record

Macros


Powerpoint presentations23 l.jpg

Powerpoint Presentations

Good luck with Module II


ad