How To Create and present a custom show in PowerPoint

Create a basic custom show

1. On the Slide Show tab, in the Start Slide Show group, click the arrow next to Custom Slide Show, and then click Custom Shows.
2. In the Custom Shows dialog box, click New.
3. Under Slides in presentation, click the slides that you want to include in the custom show, and then click Add.

 Tip   To select multiple sequential slides, click the first slide, and then hold down SHIFT while you click the last slide that you want to select. To select multiple nonsequential slides, hold down CTRL while you click each slide that you want to select.

4. To change the order in which slides appear, under Slides in custom show, click a slide, and then click one of the arrows to move the slide up or down in the list.
5. Type a name in the Slide show name box, and then click OK. To create additional custom shows with any slides in your presentation, repeat steps 1 through 5.

 Tip   To preview a custom show, click the name of the show in the Custom Shows dialog box, and then click Show.

Create a hyperlinked custom show

1. On the Slide Show tab, in the Start Slide Show group, click the arrow next to Custom Slide Show, and then click Custom Shows.
2. In the Custom Shows dialog box, click New.
3. Under Slides in presentation, click the slides that you want to include in the main custom show, and then click Add.

 Tip   To select multiple sequential slides, click the first slide, and then hold down SHIFT while you click the last slide that you want to select. To select multiple nonsequential slides, hold down CTRL while you click each slide that you want to select.

4. To change the order in which slides appear, under Slides in custom show, click a slide, and then click one of the arrows to move the slide up or down in the list.
5. Type a name in the Slide show name box, and then click OK. To create additional custom shows with any slides in your presentation, repeat steps 1 through 5.
6. To create a hyperlink from the main show to a supporting show, select the text or object that you want to represent the hyperlink.
7. On the Insert tab, in the Links group, click Hyperlink.
8. Under Link to, click Place in This Document.
9. Do one of the following:
• To link to a custom show, in the Select a place in this document list, select the custom show that you want to go to, and then select the Show and return check box.
• To link to a location in the current presentation, in the Select a place in this document list, select the slide that you want to go to.

 Tip   To preview a custom show, click the name of the show in the Custom Shows dialog box, and then click Show.

Start a custom show from within Office PowerPoint 2007

1. On the Slide Show tab, in the Set Up group, click Set Up Slide Show.
2. In the Set Up Show dialog box, under Show slides, click Custom show, and then click the custom show that you want.
3. Click OK.
4. On the Slide Show tab, in the Start Slide Show group, click Custom Slide Show, and then click Custom Shows.
5. In the Custom shows list, select a show, and then click Show.

Read More

How to Add Two Cells in Excel

One of the best things about a spreadsheet is using formulas to calculate values automatically. When you tell Microsoft Excel to add two cells (perhaps the cells that represent the number of men and women in a class that you are teaching), the program will automatically recalculate the answer if the values of the cells being added change. These steps work with Microsoft Excel 97.

Instructions

Things You'll Need:

• Excel Book
• Microsoft Excel
• Microsoft Office

1. Start Microsoft Excel, and open the file you want to use.
   
   
2. Click on the cell in which you want the total to appear.
   
   
3. Press the + key on the keyboard. This character will appear in the cell and in the Formula Bar.
   
   
4. Click on the first cell you want to add. That cell's name, such as B6, appears in the Formula Bar after the + sign.
   
   
5. Press the + key again.
   
   
6. Click on the second cell you want to add. That cell's name appears in the Formula Bar.
   
   
7. Press Enter to complete the equation. The total will appear in the initial cell.
   

Read More

how to add cells in excel

In this section, we're going to use the Chocolate addiction spreadsheet from the last section. We'll add to it, and learn how to do some multiplying. We'll also learn how to copy and paste numbers from one column to another. We'll get some more practice with adding columns and rows.
In the last section, you saw how to add up a column of numbers. The long way to do it was this = Sum(A1 + A2 + A3 + A4 + A5). But for a column of consecutive cells, you learnt that there was an easier way. This: = Sum(A1: A5).
We can use that last formula to add up a Row of consecutive cells, too. So, click on cell J3 of your spreadsheet and enter the text "Individual Totals". Widen the column a bit. Your spreadsheet should now look like the one below:

What we're going to do now is add up the Rows. We want to know how many Mars Bars are eaten in any one week, how many Twix, how many Bounty bars, and how many Other bars. So the sum is the Monday total, plus the Tuesday total, plus the Wednesday total, plus the Thursday total, plus the Friday total, plus the Saturday total, plus the Sunday total.
If we start on the Mars Bars, we need to know which cells we want to add up. Then we tell Excel to do the sum. The first Mars Bar total is in cell B4, the second is in C4, the third in D4, the fourth in E4, the fifth F4, the sixth in G4, and the seventh total is in H4. So those are the cells we want to add up. As they are consecutive cells we can use the colon - B4:H4.
Next we decide where we want Excel to put the answer. We've just added a new headings called Individual Totals. This was in the J column. The Mars Bar heading was on Row 4. So the first total needs to go into cell J4.

• So click on cell J4 with your left mouse button
• Click inside the formula bar at the top
• Type in the following formula:

=Sum(B4:H4)

• Hit the Return key on your keyboard
• The answer to all that addition should appear in cell J4

Once we have the answer in cell J4, we can use Auto Fill to get the answers to the other 3 Rows.

• Click on cell J4
• Move your mouse to the bottom right of the cell
• The cursor turns into a black cross, as in the image below

• When the cursor turns into a black cross, hold down your left mouse button
• Keep the left mouse button held down and drag your mouse downwards to cell J7

When your cursor gets to cell J7, let go of the left mouse button. Excel will Auto Fill the other three cells, inserting a formula based on the first one. The J column of your spreadsheet now looks like the one below:

Click on any of those four cells in the J Column. Then take a look at the formula bar to see the formulas. Make sure you understand what is being added up in each Row, and how the answer is derived.

All right, we have the individual total for the chocolate bars. But we can also work out how many chocolate bars are eaten in any one week. The grand total, in other words.

• Click on cell A11
• Enter the text "Number of Chocolate bars consumed in a week"
• Press the return key on your keyboard
• Click back in cell A11
• Highlight all of your new text and merge the cells (Do you remember how to do this? Click on Format from the menu bar. From the drop down menu, click Cells. Click the alignment tab strip in the dialogue box that pops up. Put a tick in the bottom box "Merge cells".)
• Centre your new text and make it bold. The font should be Arial, 10 points

From our spreadsheet, there are two ways we can find out what the weekly total is. One way would be to add up all the Individual Totals in the J column. The other way is to … Well, what is the other way? What else could we add up to get the weekly total? We're sure you'll have no problem coming up with the answer.

Exercise

• Click inside cell F11
• Enter a formula to calculate the weekly total
• Press the Return key on your keyboard when you have the correct formula
• The answer should be 80

In the next part, we'll take a look at how to copy and paste in Excel.

Read More

how to add time in excel

Adding or Summing Time in Microsoft Excel

The biggest problem people encounter when they try to add time values is incorrect formatting of the results cell.
In our demonstration, both A1 and B1 are automatically formatted as time. A simple sum formula works fine at this point to provide a total of 4 hours.

Things change drastically when we try to add 12.5 hours to 12.5 hours, we only get a result of 1 hour.

That's because it's adding the time of day, and not hours. So if you add 12.5 hours to 12:30 on the clock, it's now 1:00 am. You wanted a result of 25 hours.
In the following demonstration, the resulting cell is formatted to properly add the hours. Note the square brackets around the hour format. If desired, just delete the last 3 characters in the Type box so you don't see the seconds values.

The only thing I've changed is the format of the resulting cell:

Read More