Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 32nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the MATCH & ROW functions to create a logical test to find the first occurrence of items in a list with duplicates.. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
This video shows us the method to find the median and the inter-quartile range. The first step involves the arrangement of the numbers in the ascending order. Median is the middle number. The middle number is the number at (number of numbers + 1)/2 if the number of numbers is odd or the (number of number)/2 if the number of numbers is even. In the example the number is located at [(11+1)/2] or the 6th number. The inter-quartile range is higher quartile - lower quartile. The higher quartile is...
If you want to pass geometry, you will need to know how to calculate volume. In this tutorial, learn exactly how to find the volume of a prism or a cylinder on your own.
In this Computers & Programming video tutorial you will learn how to hack into a compuuter, the easiest way. Go to start > run, type in ‘cmd’ > OK. To find the IP address of a website, type in ‘tracert myspace.com’. This example is to find IP address of myspace.com. Then all the IP addresses of the website will be displayed. If you want to shut down a computer, now you type in ‘shutdown’. A remote shutdown dialog box will open up where you put in the IP address. That’s all. The ...
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...
There are some days when you and your loved ones could be eating dinner and the power suddenly shuts off. The next best thing to do would be to find a flashlight or candle to help make things a bit more clearer in the dark. If you have a flashlight, but need a bit more light, then this video may be for you. This tutorial will show you how to make a small pocket sized light using easy to find household items. Enjoy!
First, open the Excel worksheet you have previously created that you would like to create a table for. Click on any of the cell that contains data for your table. On the menu found on the upper portion of the application, go to the Insert Tab. Find and click Table. Your entire worksheet will now be selected. When a prompt window appears, click OK. Your table should now be created automatically.
The first problem that is show is exponential decay. First you will need to create a table with hours and substance left. The next step is to find the trend by noting that we are left with a certain percentage of the substance. One you have the trend you will use this to calculate the amount of substance left in said hours, in this case 6 hours. The following example shows you how to solve exponential growth. It is essentially the same except for the fact that you will be increasing, so inste...
In this video, our author, atomicinteractive, shows use how to use Fetch FTP to upload a temporary webpage. Please make sure your directory has the html file. Please find your email with ftplogin information. This will also show login information for the control panel and creating alternate email addresses.
In this Computers & Programming video tutorial you will learn how to update a website with an FTP client (v† la FileZilla). Download FileZilla client from www.filezilla-project.org. Find your server IP address from your web host, which will be found in the hosting control center. In the video, it is GoDaddy.com. Open your filezilla client and put in the IP address of your web host and your username and password for your hosting account. Then click ‚Äòquickconnect‚Äô. This will connect you to ...
If your computer is not running properly and you're not sure why, you may need to run the Check Disk utility in Windows to discover the problem.
In this how-to video, you will learn how to check your personal computer's RAM, processor speed, and operating system information on Windows XP. First, go to start and select my computer. From here, click view system information to open a new window. A screen will show you the information you need, such as the type of operating system you are running, the size and speed of the processor, and the amount of ram you have. Click okay to exit this window. This will be helpful for doing upgrades or...
In this tutorial, we learn how to find the best wedding dress for your body type. The rectangle or oval shape body doesn't have a well defined waist line, so you will need a dress that draws attention to the hair and face. A pear shaped body is where the bust and wast are smaller than the lower half of the body. You will want to select a wedding dress with ruffles or shoulder pads to draw attention to the top half of your body. A triangle shaped body has a large bust. You will want to select ...
How to start a square or cube lanyard is demonstrated in this video.There are other videos to demonstrate how to stitch.
It's prom season and many young women along with friends and family, will hit up any store they can to find the perfect dress. Sometimes they'll spend well into the thousands just to find a dress that will be different than anything else will be wearing to the dance. Originality is what they are looking for, but why go to the stores? Why not make your own using different material? Maybe even duct tape? Well if you're interested in standing out of the crowd or just making something for fun thi...
In this video, we learn how to make objects transparent in Flash. First, open your object up and convert it to a symbol in Flash. It doesn't matter if it's a graphic or movie clip, just make sure it's a symbol. Next, click on the symbol you just created and go to "properties". Find the section called "color effect" then find the drop down menu. You will see several options, choose "Alpha". Once you do this, you will have the ability to tweak how transparent you want your object to be. Use the...
To make a butterfly Valentine card, you need scissors, coloured pencils or candy stick and pipe cleaners. The first task to do, is go to Family Fun and print the butterfly template, which you can find on the site. Print your template into coloured cardstock. You can find cardstocks in the scrab-booking section of your craftstore. Cut out your butterfly from the template. Cut along the dotted line to create a slot for your pen or candy stick. Next we rap the pipe cleaner on the top of the cand...
1. Go to Control Panel from the start menu and select Uninstall a program. 2. Start Menu>Control Panel>Uninstall a Program
This video shows how to make a custom jewellery box for cheap. Find any box we want to use. Next find some spare fabric to put on the inside. Make little compartments big enough for whatever we are putting in. Just use cardboard for this. Measure the cardboard into strips and then made triangular cuts so that the cardboard would be more stable. Next make sure whatever we are putting in will fit in the compartments we have made. Use super glue to put the fabric in and pleated the fabric. Now w...
The first thing to do is open up Photoshop. Find a pic of a person and clip art you would like to use. Open those documents. On the side of the toolbar, find the brush tool to adjust the clip art correctly. Make a rectangle inside the clip art. Then hit Ctrl+c to cut the clip art out of the box and paste in the picture of the person. Then you remove the white in the picture by clicking on layers, and darken. When you do that, you are ready to shape the clip art to the body by clicking the box...
This video shows us how to use a formula to find the area of a parallelogram. The formula for finding the area of parallelogram is the same as finding the area of rectangle or a square which is equal to length time’s breadth. But the parallelogram looks a bit different and the parallelogram is basically a rectangle but it is not at right angles. If you draw two altitudes then it is a rectangle with two triangles and if you cut one of the triangles and paste it next to another triangle then we...
In this tutorial, we learn how to find someone's IP address. First, log into What's their IP. Once you open this, enter your email and click the links that can be sent to your friends. Once they click on these links, the website will email you that person's IP address. You can now look this IP up to see the exact location of that person. There are several different options of pages that can be sent to your friends if you want to track their IP addresses. There is also a page that can be sent ...
How to test your graphic frame rate in iTunes
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, ...
This video is about how to crop a photograph in Adobe Photoshop CS4. So the first step that you will have to do is just simply open the Adobe Photoshop CS4. Once it has loaded, just open a picture that you want to crop out. After the picture have been loaded. If the picture is too small, you can simply click on the zoom icon to make the image clearer. After wards, you need to use the marquee tool which is found on the left side of the screen. Just simply right click the icon and choose which ...
This is how to upload pictures to Facebook from an SD card. On Facebook, navigate to the 'picture upload area'; if you can not find this, you can find it by going to: http://www.facebook.com/photos/?ref=sbCreate an album by choosing a name for it, and you can also add a description of the album, and change the privacy settings of the album. After the album is created, click on 'add photos', and go to 'simple uploader'. Click on 'browse'; and navigate to your SD card location, and select the p...
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...
After receiving your dahlia tuber in the mail, dig a hole where you want the flowers to bloom in your garden. It should be big enough to place the whole tuber into and be completely covered by dirt. Before planting your tuber, you need to find where the head is. Find where the stalk was last year. When placing it in the ground, make sure the stalk is pointing up. After planting, your tuber should be flowering in about 4 weeks. Because the wind and rain can be tough on your flowers, it's a goo...
Brightstorm explains how to use definite integrals to find area. There are two basic area problems: one in which the area lies between the function and the x-axis, and one where the area lies between the two functions. In the first case, if the curve lies above the x-axis for x=a to x=b, the definite integral returns the area. If it lies below the x-axis for x=a to x=b, then the definite integral returns a negative area. In the second case, we assume that f(x) is the higher curve and g(x) is ...
This video tutorial from toptenreviews presents how to import media from a hard drive into Corel Video Studio library.First you need to start the application.From top menu click on Capture tab. Normally you would select one of the four options to capture media: Capture video, DV quick scan, Import digital media, Import from mobile device.These options are below the library. But in this case you will need to click on the folder icon above the library.This action will bring up a dialogue box wh...
In this Education video tutorial you will learn how to avoid wrong answers on the SAT critical reading area. Five principles to keep in mind are rephrase the question and predict the answer, answer the question being asked, find evidence in the passage, extreme answers are suspicious and finally remember a little wrong is all wrong. To rephrase the question, read 2 lines before and after, ask the question in your own words and find the answer choice that best matches your prediction. Now comi...
Ever wonder how to do a "back handspring"? TheWebMagician demonstrates step by step on how to do so. First you start by practicing jumping backwards and swinging your arms behind you. TheWebMagician provides examples if you find yourself a little lost. Next, transform your jump backwards into a flip by arching your back and landing on your hands, like jumping into a handstand. You then finish the landing with a bounce or "rebound". If you find yourself struggling, TheWebMagician gives out a f...
Sharptooth catfish can be one of the most difficult to capture, especially because of their size. This particular type of fish is mainly found in parts of South Africa as well as other parts of the world. So find out how to catch a sharptooth catfish with this three part tutorial. Enjoy!
Staying warm is important to making sure that you survive. Whether it be the end of the world or you find yourself lost in the wilderness, keeping dry and warm is key to survival. In this two part tutorial find out how to make a primitive wilderness loom and a mat to sleep on.
If you ever find yourself in the woods after a long day of hunting or fishing, you're going to need a fire. So in this two part video tutorial you'll find out how to build an upside down fire and make it last longer than the traditional method of making a fire. Enjoy!
An atom is a basic unit of matter consisting of a dense, central nucleus surrounded by a cloud of negatively charged ions. The nucleus itself is a mixture of positively charged protons amd electrically neutral neutrons. Different groups of elements have respective atomic numbers. You can use the periodic table as a tool to draw atoms of elements. The periodic table is organized into periods, groups and families. This video is a tutorial that reviews the subatomic particles found in an atom. I...
This video both shows the viewer how to calculate the volume and surface area of a cylinder. It also explains what these different numbers mean. The volume is the amount of ‘matter’ that the cylinder can hold. The surface area is literally the area of the cylinders curved face and the two end circles.
To make mini cupcake earrings first take a piece of sculpey and make a cylinder. Make vertical indentations around the cylinder, similar to those an the edge of a quarter. this forms the bottom of the cupcake. Next take another small piece of sculpy and role it into a line like a piece of yarn. starting at the edge of the top of your cylinder coil the line of sculpy around the edge and up, similar to a piece of novelty poop. this forms the cupcake. stick a earring finding through the top of t...
Fetch is an FTP program for Macs (Smart FTP can be used if you don't have a Mac). These can be downloaded from Download.com
Learn how to connect your PS3 or Xbox 360 to the internet using an Ethernet cable in simple steps. 1. First click on the network icon found in the task bar and select 'Network and sharing center'. 2. Go to the Internet menu and click on 'View status', then click on 'Properties'. 3. Now go to the 'Sharing' tab, select the first option under it, then click 'OK' and close the window. 4. Finally go to the task bar, click the same icon again and you can find that internet is now connected.
