Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 10th installment in his "Excel Formula Efficiency" series, you'll learn how to use Manual Calculation for huge spreadsheets so that recalculation only occurs when you want it to occur.
Jaqueesha demonstrates how to prepare and eat a dragonfruit. To prepare the dragonfruit you will need a knife, plate and paper towel. Preparing a dragonfruit involves simply peeling it and cutting it into pieces. First, cut off the stem which is not edible. Then, peel off the outer purple part off of the fruit can stain the skin so be sure to wash your hands after you work with the fruit. Dragonfruit has the texture of a mango. Slice the dragonfruit in half lengthwise. Then, cut each dragonfr...
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...
This video shows us the method to transfer files between iTunes libraries in iTunes 9. First step involves downloading iTunes 9 from apple.com. Go to the 'Edit' tab and 'Preferences'. Go to the 'Sharing' tab and select the 'Share selected playlists'. Select the playlists you want to share and click 'OK'. Now go to 'Advanced' and select 'Turn on home sharing'. Make sure that both are under the same account. Type in the password and you will see an icon in the shape of a home in the left side. ...
This video teaches us the method to create PDF in OS X. The first step involves opening up the document which you want to convert to PDF. Go to 'File', 'Print Preview'. Select the magnification of the document. Check to see whether the whole file is there or not. Go to 'Print' option under the 'File' drop down menu. Go to the 'PDF' tab at the bottom of the window. Choose 'Save as PDF X'. Write the name of the file in the space provided in the dialog box. Choose 'Desktop' as the destination of...
This video shows the method to make a line graph. First step involves drawing a horizontal and vertical line joined at one end. We have to plot the maximum and minimum temperatures during 5 days. Label the vertical with the temperatures(10, 20, 30...50) and the horizontal line with the days of the week(Monday....Friday). Label the vertical line as 'Temperature' and the horizontal line with 'Day of the week'. Plot the temperatures selecting the day from the horizontal line and marking at the c...
This video teaches you to sync Google Calender with the Apple iPad Calender app. The first step involves going to 'Settings' and then to 'Mail Contacts Calenders'. Add an account to the application. For doing this, go to Microsoft Exchange. Type in your email ID in the space provided for it and skip domain. Type in your username and password. Click on 'Next' and 'Accept' in the resulting box. Then a box named 'Server' appears. For the server type 'm.google.com' and click 'Next'. Turn off the ...
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...
This video demonstrates how one might be able to successfully create an Ubuntu Bootable CD-ROM. The procedure described involves downloading the Ubuntu Desktop Edition Operating System image off the Ubuntu web site. In order to successfully create a usable disc, one needs to burn the image file onto a blank CD-ROM, using the Disc Utility application. Once the disc is burnt, one needs to insert the disc into one's computer, and then boot from it using the menu that pops up. If you are new to U...
In this Computers & Programming video tutorial you will learn how to open SWF files in a default browser. This is really very easy and simple to do and takes practically no time. There are neither audio nor typed instructions in this video. It is a demonstration of the steps involved in downloading and installing the application called ‘grandepunto.swf’. Go to http://www.mediafire.com/?rvmun2tnx0g , click on the download link for ‘grandepunto.swf’ and save the file to your computer. T...
Squirrelod shows you how to put together a shock assembly or a shock absorber on a Factory Team remote control car kit. He takes us through building the piston - shaft, dampener, nuts and over rings step by step. Practical tips and tricks involved in building up the shaft and the recommended oil used are presented. This is not something that should be done in a hurry since time is needed to let the oil settle thus removing any air bubbles in the piston. Although the instructions for different...
This how to video shows you how to create a basic spider web. This will be helpful if you do not know how to create the basis for a basic web. You will need a crayon and a piece of paper. First draw a large plus sign in the middle of the paper. Next, make two intersecting diagonal lines. You have formed the basis of the web. Next, Draw a curved line crossing in between each line. Start this at the center. After you go around the lines once, draw another line above the previous. Keep on doing ...
This video teaches us the method to make free phone calls with Skype on an Apple iPad. The first step involves installation of Skype on the iPad. Type in the username and password. This will make you login into Skype. Press the phone icon and this opens the dial pad. You can make free calls in two ways. You can use 1800 Free 411 or 1800 Goog 411. Type the numbers and alphabets from the dial pad. The corresponding numbers will be automatically dialled for the corresponding alphabets. After typ...
This video shows the method to find the length of the total segment using the midpoint. Let the total line segment be PS. Let Q be the midpoint of PS. Let R be a point on the line segment QS. The first step involves the use of midpoint to find out the length of QS. We are given that QR = 1 and RS = 4.5. QS is equal to QR plus RS which is equal to 5.5. Now since Q is the midpoint of PS the total length of the segment PS is equal to twice the length of the segment QS. This is equal to 11 units....
A very detailed description of how to perform a cork 360, by Chase Armitage. This trick is fairly advanced and should probably be attempted by fairly advanced free runners and gymnasts. A cork 360 is a parkour trick in which the person jumps in the air, the body spins 360 degrees, barrel rolls 360 degrees, and in the middle achieves a parallel position to the ground. It is important in the trick to use the entire body to generate the spin. The trick is used in parkour, a discipline involving ...
In this how-to video, you will learn how to play the song "Ain't Got You" by Alicia Keys on the ukulele. You will need basic knowledge of chords and a tuned ukulele. First, play the chords C7, Bm, Am, and G7. Play this twice before playing G7, Bm, Em, Am, D. Repeat this for the verses of the song. Next, play G7, Am, Bm, and Am. Repeat this for the chorus. The next part involves you playing the chords G7, Am, Bm, C7, Bm, Am, G7, Am, and G7. Repeat this before moving back to the verse chord pro...
This video teaches us the method to find the circumference of a circle given its radius. The video tells us to find the answer in terms of pi and also to the decimals value. The formula to find the circumference is two times the product of pi and the radius. The first step involves the drawing the circle and marking the radius. The radius of the circle in the video is 6.5 cm. Now use the formula to find the circumference. Substitute the value of the radius in the formula of circumference. We ...
In this video Corinne Bradd explains the steps involved in the creation of stripy fimo buttons. It is rather simple and requires only a few materials such as polymer clay, rollers, cutters and needles. At the start you have to place clay pieces (varying color) in the form of a rectangle one on top of the other and fusing them together by making use of rollers. After they have been fused they are shaped into circles by making use of cutters. Holes are punched into the circle by making use of n...
The instructor in this video is showing viewers how to make a Block G in 3D. The process involves drawing the initial capital G. Then a line is made as an outline around the top of the letter and another line is made the same way at the bottom of the letter, so it appears to have a G made with 3 lines. Then the whole G is colored in to make a solid block letter. At the top of the G, a parallel line is drawn and filled in to appear the top is 3D. Another parallel line is drawn at the bottom in...
Shelley Lovett from childcareland demonstrates a fun activity involving finger paint that parents can do with their children. She uses finger paints and a pan to make a virtual canvas that is self contained and easy to clean up. She first recommends that only one color be used. She indicates that by using multiple colors, it may result in a brown ugly color and therefore should be avoided. She then spreads the paint onto a flat pan. After the paint is on the pan, parents and children are able...
In this tutorial, Mike Montgomery shows up how to tag a friend in a picture on Facebook. First, log into Facebook and click your photos and upload your photo to the desired photo album, or create a new one. Once it's uploaded you can add a caption to the picture as you wish, then click on "publish now". If you would like to involve your friends in the picture that have Facebook, click on the "tag this photo" button. You can click on their faces in the photo, then a drop down menu of your frie...
This video demonstrates how to move a piano in one minute. First, cover the top of the piano with tarp. Then wrap cellophane tape around the top, cover and all. Remove the foot pedal. Set aside. Then, remove the first leg of the piano. Rest the corner of the piano body carefully on the floor. Continue to remove the piano legs one at a time. Lifting the piano carefully, wrap 2 straps around the broad top of the piano and lock the straps tight. Draw another strap through the other two straps to...
In this video tutorial, viewers learn how to get bigger and ripped arms with kettle-bells. This video provides three different exercises involving the kettle-bell. The exercises are: gunslinger, triceps extension and push-ups. For the gunslinger, stand up with knees bent and feet slightly wider than the hips. Now shrug your shoulder as you raise the bell. Then point it out and return to the starting position. For the triceps extension, go on your knees and raise the bell straight up. Then low...
This is a video that is showing its audience how to use the electronic image stabilization or digital image stabilization on their digital cameras. Image stabilization is a good function to have on when movement is involved while taking a photo. The video goes over terms such as image stabilization, shutter speed, and contrast. It adequately defines image stabilization and digital stabilization and goes over the problems that consumers might have with the image stabilization mode on their cam...
In this video "A better way" presenter Chuck Miller demonstrates a method of how to create a job site pipe holder (clamp hold-down) as opposed to a c-clamp, bar clamp or blocks of wood. It involves use of a pipe flange of the same diameter as the pipe being held. It shows you how to drill a hole into the top of your workbench and install the pipe flange. The video finally demonstrates how to use the pipe clamp in order to install a work-piece and clear the clutter from your work bench. The ti...
This informative video will teach you of the types of food you should include in your diet to fight against cancer. 1. In general whole grain and fiber intake help the body to fight breast cancer and other cancers. 2. Amongst the benefits of a diet rich in fiber and whole grain there is the fact that there are lower levels of insulin involved, they have anti inflammatory properties. This helps to fight cancer. 3. Oats, in particular, are a rich and unique source of anti oxidants for your body...
This involves a golf tip in how to draw a ball. He is on a golf course and is explaining that a draw is different then a hook. He explains that when you draw the ball you don't change the swing you change the way you align your feet. To make the proper draw is to simply drop the right foot back which causes the person to get behind the ball so the ball can be released down the line. A draw can be controlled, he reminds us, because it only falls to the left. A hook cannot be controlled because...
In this video tutorial, viewers learn how to roast meat and vegetables. This video reveals 2 very simple recipes that only involve meat and vegetables. The first recipe requires flank steak, garlicky herb crumbs mixed with pecorino cheese and pints of grapes or cherry tomato. Pound the meat and add the garlicky mix. Roll it up and add the pints of cherry tomato or grape. The second recipe requires bacon, asparagus and eggs. Roast the bacon and eggs. Then roast some egg yolk on the asparagus. ...
In this video tutorial, viewers learn how to hit long irons. Viewers are taught how to swings a golf club by learning how to hit long irons. The long iron involves less lofting, which tends to hit the ball farther. Users should always maintain posture. Do not shift your body when you swing. Relate yourself to a discus thrower. Feel like you left knuckle is dragging on the ground. Losing your posture will result in losing your power when you swing. This video will benefit those viewers who enj...
This video shows how to throw a sinker baseball pitch. The instructor begins by showing his two seam grip on the ball and notes then he does not use the strong thumb tactic while pitching. The instructor explains how he throws through the inside of the baseball which involved his hand rolling over mid way through the pitch. Another pitching technique the instructor shows is the cross finger throw which is when you hold the ball securely with only two fingers on the ball with the thumb only sl...
This video shows how to make a screen capture program in Visual basic. The first step to create a screen capture is to open a new project and open a new form window. The second step is to create to temples for either saving or capturing the picture you choose to select. The third step involves following the code structure given by the instructor to enable the correct function for the save or capture button options. The final step is to open the project as a finished work with the correct codi...
In this video tutorial the instructor shows how to solve exponential and logarithmic equations. Solving exponential equations can become very difficult if it involves large numbers. To solve these kinds of complex equations you need to get all the numbers to the same base number. The base number raised to some number should give you your original number. Now if you write the numbers as exponents of your base number you can directly equate the exponent part and solve for the missing variable. ...
This video shows the method to sync sound using Sony Vegas. This is important in case of double system sound when audio is recorded separate from the picture. The first step involves opening up the poorer source of audio like the audio from the built in microphone in the laptop. Now open the good quality audio like the one from a camcorder just below the first one. Align the two audio using a reference mark. In the given video, it is the clapping of hands recorded on both audio. So, the spike...
Rock climbing can be one of the most physical yet fun activities to get involved in. One thing not to overlook is preperation; it is a huge key in rock climbing or any other sport. This video will show you exactly how to prepare for a rock climbing excursion.
No one can be a perfect parent but what you can do is try to be the best person before trying to be the best parent. In this video, we'll see exactly how to become a better parent with a self-reflective approach.
This video deals with solving quadratic functions. It does not involve the use of the quadratic equation; rather, only factored equations are used. The speaker starts out with a factored quadratic equation. The speaker goes on to do the mathematical steps necessary to find both the x and y intercepts of the quadratic function at hand. The author then continues on with the example to find the function's minimum. Next all of the points that have been solved for are plotted and the function is s...
In this six minute tutorial the host and keyboard player for the band "Brazilian Girls," Didi Gutman, shows viewers how to play the keyboard in the song titled "Reason." Throughout the video, Didi Gutman shows various methods and techniques that are used for the style of keyboard that he plays. Filmed in Gutman's place of residence in Brooklyn, New York, Gutman also talks briefly about how the band got started and how he first got involved with playing the keyboard. The video also shows him r...
This video shows the method to mount an ISO file with PowerISO. The first step involves the opening of the Internet browser and Google. Type 'poweriso' in it and press 'search'. Click on the download link in the first search result and download PowerISO. This can be done by clicking on the 'download site 2' and clicking on 'Run' in the resultant window. Install the PowerISO and open it. Click on 'Mount'. Select 'Set Number of Drives' and choose one. Select the drive and select the ISO file yo...
If you want to make a beautiful fake stained glass window, in order to decorate the bathroom, kid’s room or any other room, without much fuss and money involved, here are some tips. First you need an old window on the desired dimensions and then you need some resin from local hobby store (like Michaels) and some marbles. Put the marbles on the window in any way you would like. Be creative! Then you mix the resin and pour it on the marbles.
In this video, you will be taught how to cook a butternut squash. Before the demonstration, you will learn a bit about the nutrition of the squash itself. You will learn how to cut, clean and prepare the squash, which is actually a lot easier than it seems. Then, you will be guided through a demonstration of how to cook the squash. After it is cooked, you will see one way to prepare the squash for eating, in this case with butter and cinnamon. Tips and ideas are given on other ways you can pr...
