Current Search Results

How To: Use the ROUND function for math calculations in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 7th installment in his "Business Math" series of free video lessons, you'll learn when to use the ROUND function for math calculations.

How To: Make your Mac computer announce the time

Get a Mac Tip for your Mac computer! There's a million things you can do with your Apple computer, and this is just one of them. Watch this video tutorial to learn how to make your Mac computer announce the time. This technique allows a Mac user set the computer up to allow Mr. Macintosh to speak the current time periodically.

How To: Properly cross a stream in trekking or hiking

A short how to video on how to perform a safe stream crossing or ford using trekking poles when ultralight backpacking. Hiking or trail running often involves crossing or fording rivers and streams. Make sure you cross the water properly so that you don't get caught in a current or injured on rocks.

How To: Put an unresponsive iPhone into DFU mode

iPhone not booting up? This video shows how to recover your iPhone if it is unresponsive or even getting ready to Jailbreak it, by putting it into DFU Mode. DFU, device firmware upgrade, mode bypasses the current OS and allows you to upgrade or downgrade. Watch this video cell phone repair tutorial and learn how to restore a crashed iPhone by putting it into DFU mode.

How To: Open .zip files

In this tutorial, we learn how to open .zip files. First, go to the start menu and search for "regedit.exe", then press enter. After this, a new window will pop up, open the computer icon, then open "current user", "software", "Microsoft", "Windows", then "current version". Now, click on the explorer folder, then the "file exts" folder and ".zip" folder. You should now see three different folders, right click on "user choice", then delete it. Exit this program, and now return to your zip fold...

How To: Use the Narrator screen reading tool in Windows 7

In this how to video, you will learn how to use Narrator in Windows 7. To use the program go to start, accessories, ease of access, and Narrator. The program will now open. From here, the program will announce what you can use the program with. Press the control key to pause the program. Use control shift enter to read the currently selected item or the item with current keyboard focus. Ctrl shift space will read the contents of the current window. The narrator window has many options, such a...

How To: Bypass Windows Genuine Advantage notification

Steps adopted to bypass Windows Genuine Advantage Notification in Windows NT are:1. Open my computer2. Open the Local Disk (Where the Operating system is currently installed).3. Open windows folder and enter into the folder, system 32.(Shortcut: My Computer>Local Disk C>System 32)4. After entering system 32 (Folder), find and delete the file-wgatray.exe5. After deleting wgatray.exe file, go to the start menu and launch the run application6. In run, type in regedit and click OK,7. In regedit, ...

How To: Easily change your IP address

This video discusses how to change your IP address in Windows XP. Start by clicking on the Start Button and then Run. Type in "cmd" and press enter. This will open a Command Prompt box. From here type in "ipconfig" which will show your current IP configuration, including your IP Address, Gateway, DNS Servers, etc. Next type "ipconfig /release". This will release all IP information from your current network adaptor. Next open up network connections, right click on Local Area Connection and sel...

How To: Use the percentile formula in Statistics

In this tutorial the instructor explains the percentile formula. He says that the percentile formula is used to find the percentile rank of a data point in a group of data. He takes an example that consists of the lengths of puppies. Now he intends to find out the percentile rank of any puppy in the group. He shows that the formulate to compute a percentile rank of a particular puppy is rank R = 100 * (N< + (1/2)N= )/ Nt, where N< is the number of puppies whose length is less that the length ...

How To: Animate a bully splashing a water bottle in Adobe Flash

This tutorial shows you start to finish how to draw an image of a bully with a water bottle in hand and then fling that water bottle onto someone else using FL Studio. This a useful reference piece for trying to animate splashing water or similar water physics. It's not precisely hard to do, but you'll want to pay attention to some of the detail in each piece. Also make sure that you have the most current version of FL Studio installed!

How To: Install a piano hinge on a side door

A piano hinge is also called a continuous hinge, and is a popular hinge to use on side doors and other small doors. This tutorial shows you the proper method of installing a piano hinge on your current project. Besides the door and the hinge, you will also need some basic hardware: a drill and some screws, as well as a chisel to carve out an inset for the hinge to rest. Make sure you always measure carefully before cutting anything!

How To: Find asset turnover, capital intensity and inventory turnover ratios in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 11th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate asset turnover, capital intensity, inventory turnover, days to sell inventory, receivable turnover, days to collect accounts receivab...

How To: Use the passive voice in Spanish

In this video, we learn how to use the passive voice in Spanish. The first way to use the passive voice in Spanish is to use "ser", the second is by using "se". First, recognize the subject, verb, and object in your sentence. Now, write your sentence using a passive voice, making the object the subject and change the tense of the verb. This is very easy to do and basically just flips the sentence around and changes out the tense of the verb. This will change the sentence into the passive voic...

How To: Use the iPhone maps app

In this video, we learn how to use the iPhone map app. First, go to Google Maps and click on the bottom to find your current location. This will show up in a blue button, which you can tap on to find out more information. The map will go in the direction your iPhone is facing and you can zoom in on information about places around you. You can also type in a place you are searching for, and get directions, then save them to your phone if you prefer. The key is the button on the bottom right wh...

How To: Keep resumes timely with transferable skills

In this video, we learn how to keep resumes timely with transferable skills. You have to keep up with the changes in technology, so don't keep doing things the old way. You are going to have to keep up with people who have a fresh skill set. Don't wait for your employer to send you to school, do it yourself and get ahead of the game. Start to network with people and build your career and future by yourself. You will benefit from this, so take the time and make sure your skills are current and...

How To: Delete your Gmail account

In this tutorial, we learn how to delete your Gmail account. First, log onto your Gmail account and click on "settings". Now, click on "accounts", then go to "Google account settings". Once you click this, you will be directed a new page with your information. Under "my products" you will see an option to click "edit". After you click on this, click on "remove Gmail permanently" under the "delete a product" heading. You will now have a deletion warning, if you are sure about deleting, check t...

How To: Do kayak tricks

In this tutorial, we learn how to do kayak tricks. The first trick is called the cartwheel trick. This is where you throw the bow of your boat down, bringing the stern over your head and slicing it back into the water behind you. You can do cartwheels over and over and over. The next trick is to do a bow stall, which is driving your boat down so the bow is into the water. You then stall in this position with the tail of the boat up, and balancing there. This is done by a few forward paddle st...

How To: Increase the render speed in Final Cut Pro

In this video tutorial, viewers learn how to increase the rendering speed in Adobe Final Cut Pro. Begin by right-clicking on your current sequence and click on Settings. Click on the Video Processing tab and select "Always Render in RGB". Then click OK. This change will only be noticeable when working with really high quality high definition footage or film. Even then, you are able to re-render at a higher bit rate later, without having to affect the original image or export. This video will ...

How To: Create simple math formulas in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 2nd installment in his "Excel Business Math" series of free video lessons, you'll learn how to create math formulas in MS Excel using addition, subtraction, multiplication, division, exponents, and parentheses. See how 2+2*2 is not equal ...

How To: Use relative & absolute cell references in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 6th installment in his "Excel Business Math" series of free video lessons, you'll learn about the importance of cell References in Excel formulas and functions. Learn about a relative and absolute cell references in Excel formulas with th...

How To: Work with cost & selling price markup in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 48th installment in his "Excel Business Math" series of free video lessons, you'll learn about the basics of markup on cost and markup on selling price. Markup on cost uses the base cost. Markup on selling price uses the base selling price.

How To: Calculate markup on selling price in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 50th installment in his "Excel Business Math" series of free video lessons, you'll learn how to make calculations for markup on selling price in MS Excel.

How To: Solve for rate of change in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 29th installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve for rate, amount of change and rate of change.

How To: Round to the penny or dollar in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 9th installment in his "Excel Business Math" series of free video lessons, you'll learn about when you must use the ROUND function in Excel. Round to the penny or dollar with this free video lesson.

How To: Add and subtract numbers with Excel's SUM function

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 10th installment in his "Excel Business Math" series of free video lessons, you'll learn how to add and subtract using the SUM function.

How To: Create a contribution margin income statement in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the very first installment in his "Beauty of Excel" series of free video lessons, you'll learn how to create a contribution margin income statement across various units sold.

How To: Change the default Windows Remote Desktop port

In this Computers & Programming video tutorial you will learn how to change the default Windows Remote Desktop port. It is actually a registry hack. You can check the IP address of our machine by typing ipconfig into the cmd prompt. For hacking into a machine, you should have created a user for the machine and allowed remote desktop to that user. Open up the remote desktop and type in the IP address and it will ask for a login. To hack the registry, click start and type in ‘regedit’ . now go ...

How To: Use high-quality video compression in iMovie HD

In this how-to video, you will learn how to compress iMovie files into QuickTime files to make them look really good on YouTube. First, open iMovie. Click Share and click Share again. Go to Expert Settings and click on Share. Click on Options and go to Settings. Change it to h264, current frames per second, and every. Restrict should be set at 5000. Optimize it for DVD and change encoding to best quality. Change the size to NTSC 720X486. Check de-interlace video and hit okay. Change the sound...

How To: Change the lock pattern on my Android phone

In this video tutorial, viewers learn how to change the lock pattern on an Android phone. The lock pattern allows minimum security on the phone to prevent other people from tampering with your mobile files. Begin by going into the Settings and click on Location & security. Under Screen unlock pattern, select Change unlock pattern. In order to change the unlock pattern, users will have to type in the current unlock pattern. Now type in the new unlock pattern and press Continue. Then retype the...

How To: Tie the Hunter's Bend decorative knot

In this video you will learn how to tie a knot known as the "Hunter's Bend". A "bend" is a type of knot used to join two ends of a rope together. Generally, it should be possible to untie this type of knot, once it's usefulness has passed. This knot was originally created by a man named Phil D. Smith during WWII, at which time he dubbed it the "Rigger's Bend". An English physicist, by the name of Edward Hunter, rediscovered the knot in 1978, and popularized it's use, leading to it's current n...

How To: Create a watermark or background in MS Word 2007

This video shows you how to change the background color and watermark in your Word 2007 document. Both settings are found on the Page Layout tab. The background color can be chosen from a wide palette. The most frequently used colors are immediately applied to the current page as a preview. You can also choose to add a fill effect, like a color gradient, by clicking the Fill Effects item in the Page Color list. The watermark feature allows you to add either a predefined notice, an image or a ...

How To: Insert and remove page numbers in MS Word 2007

This video will demonstrate the process to implement page numbers in your Microsoft Word 2007 documents. The video starts out by showing the Insert Tab on the Microsoft Word 2007 Ribbon. On the Insert Ribbon, you will see an icon titled Page Number. All of the Page Number options are available when you click the down arrow directly beside the icon. The are many different position options such top of page, bottom of page, page margins, or current position. The customization options are as endl...

How To: Operate cruise control in a 2010 Prius

Operating the Toyota Prius 2010 cruise control is very simple if you watch this video. The switches of the cruise control is located on the stock which is behind the right side of the steering wheel. The on/off button is at the end of the stock. Once you turn it on, accelerate to your desired speed and push the stock down to set it on the current speed. If desired to change speed, hold the stock up to increase the speed and release it when speed desired is reached, and to decrease the speed h...

How To: Find if a point lies on a line in point slope form

In this tutorial, the author shows how to determine if a point lies on a given line which is in Point Slope Form. To show the method he takes a sample point order pair and an equation of a line in its point slope form. Now he substitutes the value of the x, y order pair and the equation of the line, and solves the equation on both the sides. If both sides match it means that the point lies on the given line, or else it does not lie on the current line. In this video, the instructor shows how ...

How To: Use the Photoshop CS4 patch tool

As each new version of the award winning Adobe Photoshop is released certain functions remain the same from prior versions while other functions are changed. In the latest version of Photoshop, Adobe Photoshop CS4, the patch tool works significantly differently than prior versions. In this video we are shown how the patch tool originally worked in Adobe Photoshop CS2 compared to how it now functions in Photoshop CS4. Finally the author gives us step by step instructions on how to operate the ...

How To: Combine comments in Adobe Acrobat 9 Pro

In this Adobe Acrobat series of video the instructor shows how to combine comments in a PDF. When we receive comments as a part of a review of a document there is no need to view the comments is a separate document but you can view the comments in the same document. To do this go to the comments menu and select the option of import comments. Now from there you can select one or more PDF documents that contain the comments and integrate it to the current document. This video shows how to combi...

How To: Use ThermaPure to get rid of bed bugs

Bed bugs come out and suck your blood in the middle of the night. ThermaPure can get rid of bed bugs in a safe manner. ThermaPure uses probes to heat up the areas of the house such as the bedding, carpets, and wall voids, to a temperature that will kill the bed bugs. The ThermaPure heater is programmable which allows for a precise duration and electrical current needed to rid your house of bed bugs. ThermaPure is a green technology and will not harm you in the process of ridding your home of ...