Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 28th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the INDEX, RANDBETWEEN, COUNTA, IF, AND, & VLOOKUP functions together to select a random employee from a list, determine if they have meet the given criteria and then conditionally format the relevant cells according to the result. Learn to love digi...
In this video tutorial, viewers learn how to convert You Tube videos to MP3. Begin by going to the You Tube website and find the video that you want to take the audio from. Once you have found your video, copy the URL of the video. Then go to this website: and paste the You Tube URL. Change the Convert to format to MP3 and click Start. Now wait for the website to finish loading the MP3 and provide you with a download link. This video will benefit those viewers who enjoy lis...
In this how to video, you will learn how to convert a flash video to an AVI file. First, download the Pazera Converter program. Open the program. At the left hand corner, click add files and find your flv file. Next, select and open it. Once it is imported, go to output directory and choose which folder you want the new file to be placed. Go to output file format and click AVI. You can also choose MPG instead if you want. Now click the convert button at the top. You will see a progress bar. O...
Insert DVD containing Mac OS software into system drive. Reboot system. Confirm installation and agree with license. When prompted to select drive, select disk utility from menu bar. Select hard drive and click on erase button. Select Mac OS extended file system. Confirm erasing all data. Once drive formatted, close disk utility. Select to install in hard drive that was erased. After installation completes and system reboots, select Language and Keyboard for your country. When asked if alread...
In this Electronics video tutorial you will learn how to use the browser on the Blackberry Storm 9500. To use your browser, select browser from the main blackberry menu. This will bring up your bookmark and the history of your previously visited websites. There is also a handy Google search bar. Type in the address of the site in to address bar at the top. Once the page loads, you can view it in landscape or portrait format by moving the handset. To zoom in and out, use the magnifying glass "...
In this video tutorial, viewers learn how to burn a CD or DVD on a Mac computer with the Burn application. Burn is able to create data, audio and video discs. The Inspector window allows users to edit extra information about the disc. To open Inspector, press the Command and I button. It is also able to create disc copies. To burn a disc, name the disc and select a format. Them simply drag the file(s) into the program and click Burn. This video will benefit those viewers who have a file on th...
In this video tutorial, viewers learn how to add custom music in the game, WWE Smack Down vs. Raw 2009. Users will need a blank recordable CD and cannot use MP3s or any other audio format. Begin by recording all the music files into the CD and the insert it into the Xbox360. In the Xbox360 dashboard, go to My Xbox and select Play CD. Click on Rip CD and name the information of the CD. Now select the song that you want and add in into a play-list. Now to select the song in the game, select use...
If you own a jailbroken iPod Touch 1G or 2G and have ever wanted to know what it takes to setup your iPod's alarm clock to wake you up with music from your own music library, now you can. First you'll use WinSCP to get connect to your iPod Touch over SSH. Then you'll locate the MP3 file desired for use as your alarm, then you'll convert that file to an AAC-formatted M4A file. After that, you'll use WinSCP to transfer that file to the secret location revealed in the video as the location of au...
Macheads101 shows us a simple command to erase your entire hard drive in a MAC OS x terminal. You can either log in as administrator and simply type "rm -rf /" to format or you can just type "Sudo rm -rf /" to start. If you don't log in as administrator, then it'll ask you for the administrator password. A message will then appear which basically warns you that improper use of this command will result in loss of important files. Next type in "sudo mount -uw /" to edit the file command system....
In this Computers & Programming video tutorial you will learn how to reformat your hard drive to install Windows XP. You will need a copy of window XP. Insert the CD in to your CD drive. Restart your computer and the command prompt will show. Press any key to boot from the windows XP set up CD. The set up screen will be displayed. Click enter and agree to all the terms. Then select the driver on which you want to put the XP and click enter. Then select the NTFS file system and not the ‘quic...
This video describes how to use Adobe Photoshop CS4 software to create and manipulate text in animated .GIFs. GIF stands for Graphic Interchange Format, a type of image file which allows short animated sequences to be displayed. A preselected scene from a television show is opened as a GIF in Photoshop CS4. Animation window is opened by selecting window then animation. The text tool is selected and a textbox is drawn by clicking and dragging. Photoshop CS4 then applies the text to the frames ...
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 141st installment in their series of digital spreadsheet magic tricks, you'll learn how to take the number 1 (for day one of the month) and use the DATE function to convert it to a serial number formatted as a date.
Namuoc demonstrates how to create a line chart in Excel. To create a simple line chart in Excel 2007, first highlight the cells in your worksheet that you would like to include in the chart. Then, select the insert tab on the top of the worksheet toolbar. Next, click on the line option. Select the two dimensional line graph option from the given choices. Move the chart to a new sheet. Label the new sheet in the appropriate field and click the OK button. Your line chart will now be created usi...
In this video tutorial, viewers learn how to export MP3 with Audacity. Users will need to download the Lame_enc.dll encoder. The download link is located in the video description. Once downloaded, open Audacity and find the song that you want. Once you have found your song, simply drag the song into the program. Now click on File and select Export As MP3. It will then ask you to Lame_enc.dll file. Click on Yes and locate the file. Now wait for your file to finish encoding. This video will ben...
This video demonstrates how to turn your favorite songs into ringtones for your Blackberry Curve. You will need a USB cable to connect your Blackberry to your computer. After connecting your Blackberry, a message will ask you if you would like to turn on "Mass Storage Mode". Select yes. On your computer, open the Blackberry in a window, and then open "music". Then click-and-drag songs from your computer onto your Blackberry. You can transfer files to either music or ringtones (as long as its ...
This is a software demo. This Mac software allows you to play a song or music or audio track and reduce its speed without affecting the pitch. Select a guitar riff or chord sequence, loop it, and speed up or slow down that loop so it runs faster or slower, without changing the pitch. The program has some sound editing functionality, like EQ, but is mainly a tool for changing a recording's speed. Import a track from iTunes, or directly from a CD, adjust the speed, apply the optional equalizer ...
In this video from Act2Scene5 we learn how to convert movie files to a DVD with DVD Exact Copy. Using 1 Click DVD Movie you can convert your movie files into DVD's. All you have to do is pull your movie file from where you have it on your computer. Open it up in the program. Then 1 Click DVD Movie will scan the file. Click the Start button and the program will transcode the movie file and it will convert it to a format that can be burned onto a blank DVD. It can also create menus for your DVD...
This video will show you how to make your essay appear longer then it actually is with just a few quick changes to your Microsoft word settings. First, you want to go to the "Edit" tab and click "Replace", from there in the replace with box put a period. Then click on format and click on font and change the size of the period from 12 pt font to 14 or 16 pt font and click replace all. The next change you want to make is with your margins and in the left and right margins change it from 1. 25 t...
In this video tutorial, viewers learn how to repair the write protect on an SD card. An SD card is a non-volatile memory card format that is used in portable devices. If the write protect on a SD card is broken, the user cannot record any files onto the card. To fix this, viewers will need a small piece of scotch tape. Put the tape on the notch of the SD card. Do not cover the metal tabs at the back. This video will benefit those viewers who have a SD card and would like to repair the write p...
In this video tutorial, viewers learn how to make a slow motion video on a camcorder in Sony Vegas. In a film camera, this is called "overcranking". On your camcorder, set your rec format to PH 720.60 P. Then open your clip in Sony Vegas and set up a time line. Then make a region around the entire clip and select Render As. Go to Custom and change the frame rate to 59. 940 (Double NTSC). Now save it. This video ill benefit those viewers who produce videos and would like to learn how to make t...
There are many new features which will make you more comfortable in doing your work in PowerPoint 2007 which will force you to switch from PowerPoint 2003 to PowerPoint 2007. There are number of new features in PowerPoint 2007.
This video in the Education category will show you how to make any school paper look longer. Open the normal word document. Go to ‘edit’ and select ‘find’ and then to ‘replace’ tab. In the find what box type in ‘.’ (a full stop). Then, in ‘replace with’ box type in ‘.’. Now go to ‘format’ and click on ‘font’. In the box for font size select size 16 or 18 and click ‘replace all’. There you go, you have just made your paper longer without adding any text. In the video, a one and a half pages lo...
Follow along as we learn how to get free ringbones for your cell phone. -To begin you are going to go to myxtertones.com/make. This site will be used to email your ringbones to your cell phone.
Windows Movie Maker can be used to make HD movies. This step by step clip shows you how. The first step is to import your picture or video and make sure they're in your timeline. When you've finished editing, go to tools and options and choose the advanced tab. In video properties there's video format and aspect ratio. Select NTSC and 16:9. If you're using a cell phone or video camera, you'll be using 4:3 which is pretty small for YouTube and similar sites in order to get full screen. Save th...
This tutorial explains how to save your work in Pinnacle Studio. The first step is to go to "File". Next is saving projects by using the drop down menu from the top left corner of the program. When you save your project it does not mean that all the video files will be saved. In fact, all the original files have to be stored in the exact same place so this will work. To save your new project you have to go to movie and make and output format like Vdix or VCL.
The video describes how to use Pinnacle Plus Studio. The narrator first describes the various tabs and features of Pinnacle Studio. He then describes how to import a video into Pinnacle Studio for editing. The video demonstrates how to add still photos, sound effects, music, and transitions to your video using the various tabs and options along with what the narrator calls the timeline. Finally, he describes how to make a movie after you have finished editing your video. He gives a good overv...
HelpVids user mel_bone teaches you how to cut, copy and paste to the clipboard in Microsoft Word 2007. Select the first paragraph by either triple clicking on it or selecting it with your mouse. Click "Copy" in the top ribbon or press "ctrl + c". Then use "Paste" or "ctrl + v". To cut a paragraph, select it and click "Cut" or press "ctrl + x". Using the paste options, you can only paste the text, without its formatting. By clicking the small icon next to the Clipboard tab, you will open the p...
User mel_bone teaches you how to use navigation and selection techniques in Microsoft Word 2007. You will notice in the bottom right corner of the main window a slider. This controls the zoom. You can thus increase the page size or decrease it, as you need. When you have a document that has more than one page, you can go to the end of the document by pressing ctrl+end. Ctrl+home brings you to the start of the document. Clicking and holding the mouse button pressed on the navigation bar lets y...
This video teaches the secrets of partitioning a hard drive on a MAC in simple steps. First open the disk utility, select the root directory of your hard drive and click partition. Now select the required partitions under the volume scheme, adjust the drive space and name them. Select the format a MAC OS Extended (Journaled) and select GUID Partition table from option if you want to boot it. Click 'Apply' to start the partitioning and when its done start using it.
This tutorial looks at how to describe a linear system without actually graphing it. In order to do that, you will need to convert both equations of a problem into the Y=mx+b format. Once you have done this, you will be analyzing the m and b values. There are a few rules to follow. If the slopes (or m) and the Y intercepts (or b) are equal, there are an infinite number of solutions (or dependent equations). A second rule is if the slopes are equal and the Y intercepts are different, then the ...
If your into data based business,then this one's for you. Text field's are very much important while making a data based solution in FileMaker Pro 10.You can go to file menu>manage>database and there is the field's tab. Text field is used for storing text and no other such use. Text field's can hold up to 2GB of information. It can help to store raw data and formatting information, i.e., color,point size as well as type face.
In this video the instructor gives tips on how to erase a PC hard drive. An MIT study shows that 74 percent of the discarded hard drives contain private data on them that can be read and recovered by others. So you should learn how to completely erase all the data so that no one can recover or read from it later. Now formatting the drive or deleting a few files wont do it. For this you will need to have a proper software that meets or exceeds that US Department of Defense standards for data r...
For anyone who has accidentally deleted a file, follow the steps in this tutorial to learn how to recover the file on Ubuntu. Learn what commands to type to run a search that will allow you to undelete a deleted file. This tutorial shows you letter by letter what command to type and in what format it should be typed to scan your hard drive for the deleted file. Once your search has found the file, the tutorial also shows how it can be recovered and then saved back onto your hard drive.
How to resize the background image in Xara3D6? First go to windows>frame size. Go in Sara and change the size of the image to the frame size. Make the image transparent. Then export the image as a PNG format. Now go back to Xara3D6 and go to view>background texture and open the previous image which was saved. That’s it; the image is resized to that particular document properly. It will help in resizing photos to be uploaded on the net.
This video teaches you how to test for symmetry algebraically. You will need to know the basic formats of graphs and the (x,y) setup. Once you get your equation of the line, you will need to replace y with negative y and x with negative x and solve the equation. You will need to solve for x and also for y for the odd and even. If the equations do not equal each other then they are not even or they are not odd. If this is the case then the lines are not symmetrical and that is how you test for...
The ability to create professional and clean presentations can be a valuable asset to one’s career. With this video tutorial, learn how to use Adobe Presenter in order to augment Power Point presentations. Presenter offers users the ability to record narration under a set order of slides in a simple interface, and provides an interactive quiz option to further engage audience members. Alternatively, users may also convert a presentation into PDF format, for use as a physical or virtual document.
Graphing a line in slope-intercept form is easy in simple after watching this video. In this math tutorial, you'll be guided step-by-step how to graph a line from an equation in the y=mx+b format. The steps include determining the slope and the y-intercept, plotting the y-intercept on the graph, and finally applying the slope to connect the points. The video guides you through the entire process by illustrating and demonstrating all the necessary steps, thus making graphing a snap.
This video by WirelessZone gives an overview and shows the first steps of setting up a recently unboxed Motorola Barrage. The demonstrator runs through the basic display settings, sound setting, the ring tones (almost all the default ones) and many more. The display settings include the wallpaper, display back light, keypad back light, feeling, icons, clock formats etc. The sound settings include the digital dial readout which reads out the number that was keyed in without looking at the phone.
In this video, you will see the steps for finding the volume of a rectangular prism written on a white board. The steps are labeled along the right side. A blue cursor boxes the steps as they are introduced on the board. The formula for finding volume is written along the top left. Colored arrows point out the measurements. Each step is presented in a colored format so it is easy to follow the steps. The final answer is circled in yellow so it is a cinch to compare your answer with the correc...
This WirelessZone video gives a first-look and shows how to setup a recently un-boxed Razzle from Verizon Wireless. First the features of the unique Razzle with its flip speaker keyboard combo is highlighted, thereafter a walk-through is given on how to set up the display banner, screen back-light, keypad back-light, wallpaper, themes, menu layout, menu type, clock format, dial tones, and most of the sound settings in great detail. The video also features the default ring-tones on the phone s...
