Wednesday, February 23, 2011

How to Add Videos to iPod

With the lone exception of the iPod Shuffle, iPods come with video screens that allow you to display album covers, music information and play videos as well. Apple's iTunes store offers a number of movies, TV shows and music videos for download, and you can also transfer home videos to an iPod through iTunes. Once you do, it's very easy to upload video from iTunes to the iPod itself.

Instructions



Things You'll Need:

  • Personal computer
  • iTunes software
  • Quicktime software
  • iPod and connecting cable
  • Videos in digital format
  1. Save your video in a format that is compatible with iTunes. That usually means either a Quicktime format or an MP4 format. You can tell which ones they are by the extension name after the movie's title: it should say either ".mp4", ".m4v" or ".mov". Quicktime allows you to convert most movie files to these formats. Simply open the file in Quicktime and click "Save As" in the File menu at the top of the screen. It will automatically save a new version of the file as a Quicktime movie, which is iTunes compatible. In addition, videos directly downloaded from the iTunes store should automatically be compatible.

  2. Import the video into iTunes if it is not there already, either by using the "Add File to Library" command under the "File" bar in iTunes or simply clicking and dragging the file onto the open iTunes screen. Check the "Videos" or "Movies" file on your iTunes display to see that the movie is there, and click "Play" to let it run and ensure that it is working correctly.

  3. Highlight the video, then go to the "Advanced" menu on the menu bar on top of the screen. Click "Create iPod Version" or "Convert Selection for iPod." Wait a few minutes while the conversion completes (this could take quite some time for large files). If you have downloaded the video from the iTunes store, you may skip this step.

  4. Connect your iPod to your computer, using the cable provided for this purpose.

  5. Click on the iPod symbol under "Devices" in the iTunes library to bring up the iPod's options.

  6. Click the tab labeled "Movies" or "Videos," then check the box labeled "Automatically Update All Videos" or "Sync All Movies." Then click the "Sync" button in the lower right-hand corner of the iTunes screen.

  7. Wait a few minutes while the iPod syncs up. When it is finished, click on the eject symbol next to the iPod symbol in the iTunes library. Disconnect the iPod from the computer.

  8. Press the "Menu" button on the iPod and scroll down to the "Movies" or "Videos" selection, then click on it.

  9. Find the title of the video you have imported, then click on it again. It should begin to play on your iPod. You can use the iPod controls to rewind, fast forward or exit the video.

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.

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:
Adding up Rows in Excel
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
The Autofill Cursor
  • 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
Filling the rows
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:
The AutoFilled Rows
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.

how to add brushes to photoshop

You may install the brushes to any folder.
I like to keep my brushes in a subdirectory of Photoshop in a folder named brushes.

Photoshop 5.0 Brushes Window Photoshop 6.0 Brushes Window
Photoshop 5.0 Photoshop 6.0

From the Brushes Palette in Photoshop, click the small arrow in the upper right corner of the palette, and choose load brushes.
Locate the directory where you have stored the brushes (.abr files) and select the file you want and click "load".
The brushes will be added to the current brushes.

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: