This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...
Following are the steps to describe how-to prepare pita bread or pita chips: 1. Ingredients needed are: 2 tablespoon of dry yeast, 1 tablespoon of sugar, one and a quarter cup of warm water, 3 and a half cup of all purpose flour, 1/2 teaspoon of salt and oil as per requirement.
First of all you need a single sheet of paper 12 by 12 inches to make a mini book with four pages and measures 6 by 3 inches. You also need a tool for making creases and a knife to cut the paper. Start by folding the paper in half and then crease the middle line. You must always try to make the crease line as crisp and sharp as possible. Now open it out and then again fold it in the middle in the other side. After this step you have to place the paper with the length facing towards you. Now f...
Whethamsolution’s Quick tip walks us through some of the issues caused by use of add-ons in Internet explorer 8 web browser. The video also shows how to manage the add-ons installed in IE8. Add-ons are software’s which enhance the functionality of a web browser. Though most add-ons enhance the browser functionality to a great extent they often tend to slow down the browser drastically. Moreover unwanted add-ons like toolbar's and malicious scripts may cause nuisance to browsing experience...
This video demonstrates how to knit with a serenity loom. A serenity loom can produce a blanket up to 10 feet. To start, thread a double loop of thread through a straw. Then use the loop of thread to pull through a piece of yarn. The straw will help you place the yarn around the pegs of the loom easier. Tie a loop around the anchor of the inside of the loom. Then loop completely around each peg, being sure to place the loops in the middle of the pegs consistantly. Wrap as far as you want your...
In order to make a Silicone Ring Mold you should first get a small plastic container. This will be your mold box. First, you should cut the bottom out of the container. Next, use double sided tape to stick the ring down to the base of this. Next, secure the mold walls to the base. Now, mix the silicone mix in a separate mixing cup. Make sure you mix this thoroughly until the color is uniform. Now pour the silicone into the mold in a fine stream on the side of the ring, this will help prevent ...
In this how to video, you will learn how to calculate the polygon area in ArcMap. First, open the program ArcMap. Next, go to the left column and right click it. Select attribute table. From here, go to options and click add field. Type in Area and click double. Next, right click area at the top and select calculate geometry. Next, select area disabled. Exit the windows. Next, click the red icon at the top and select data management tools. From here, select project. At the top drop down menu,...
This how to video shows you how to become a better lineman. First, you will need to know that blocking is a matter of position, leverage, and force. You should have courage, determination, intelligence, and willingness to give maximum effort for six seconds. For the first drill, you will have the fit drill. You will line up against a team mate and drive them up for five yards. The next drill is the two step punch and fit drill. You will emphasize your first initial step into the blocker. Thro...
Julissa Roberts shows how to shuck an oyster. She shows us how to determine whether the oyster is safe to eat, how to shuck the oyster, and then one way to prepare a plate of oysters. If you don't properly check the oyster, and clean it, you could get a mouth full of sand, or get an oyster that smells like rotten fish. To check whether the oyster is good, smell it, it will smell like rotten fish if it's bad. Then tap the oyster on something solid, if the oyster is dead, it will sound hollow, ...
Experts say that every house has around 1500 dollars worth of merchandise that could be sold on eBay. eBay is a great alternative to the traditional garage sale these days, and with more and more people joining the site every day - why not get in on the action? eBay is an exciting Internet tool that allows anyone to sell anything. Check out this tutorial, for information and tips on how to start your own eBay seller's account. This is a great video to check out if you are new to eBay or have ...
This video tutorial from Magix presents how to burn (S)VCDs and DVDs using Magix Movie Edit Pro 15 application.First you need to group videos you want to burn.If you want to play movies using remote control you have to place chapter markers. You can set markers manually or choose automatic? marker setting which places markers before each new scene.Once all chapter markers are placed, click Burn button.Here you can choose Start Menu Templates. To change movie titles and chapter headings double...
This video teaches us the method to draw the letter F in 3D. First draw F normally. Now double the outlines of the F on both sides of the outlines. Draw a line that is parallel and of the same length of the longer top arm of F. Join the ends of the line to the ends of the top arm by parallel lines. Color the parallelogram with a darker shade. Make a parallelogram by joining the ends of a line drawn parallel and equal to the smaller side of the rectangle of the top arm. Draw a vertical line an...
This video demonstrates how to make a notebook with ribbon binding. Take a stalk of plain white paper and it would be 5 1/2" long and 8" wide. Fold it in half. Trim off the excess with a ruler. Then align the edges of the white paper. Put this in a cardstock which is 8 1/2" wide and 5 1/2" long. Cover rapid around the white paper stalk to make sure that it the spine is bounded. Take the grid ruler and center it and mark the center and also 1" from the center at each side to the left and right...
This video helps you to draw a boat. First draw the base with double lines. Then draw a cabin and a wheel. Next draw small circles on the base. Now paint the entire lines with black. Next draw spokes on the wheel. Shade the base of the boat with a lighter brown color and over-coat it with a dark brown. Paint the cabin with orange and brown color as shown in the video. Give a dark brown to the outer area of the circles in the base and fill the inner areas with black color. Give a white line to...
This is a demonstration of making a felt flower accessory for your head bands, waist band and even for your clothes. You will require wool fibers, bubble wrap, felt sponge rolling pin, washing bags and a container of hot water and a spray for soap water. First loose fibers are taken of the color you prefer for your flower and laid in one direction to the size and shape of the flower. Then a second layer is laid at right angle to the previous layer. Some strand of fiber is twisted and laid on ...
In this how-to video, you will learn how to make a light saber or similar image in the Final Cut Express program. First, go to the effects tab and go to video generators and select color solid. Drag this to the viewer. Go to the control tab and select the blue color. Now drag it to the time line. Double effect the color solid and go to mask shape. Select filters and change the effects settings to 2.5 horizontal scale. For the vertical scale, select 75 to 85. Go to the effects, video effects, ...
Auto tune is a popular effect made popular by T-pain. To do this you will need two programs. The first one is Auto-tune and the other one is music editing program called Mix craft. You can also use other music editing programs of your choice. Download this programs from their website. You can also use the trial versions. Now open up Mix Craft and under the effects you can find the Auto Tune effects in VST effects. Open some kind of music. Double click and import the required music. You can al...
This video demonstrates how to make lip balm. For this project, you will need the following: essential oils, lipstick, pure vitamin, beeswax, shea butter, flavoring, and sweet almond oil.
Begin with starting the program Picasa. If the program has been opened, choose an image for editing. Double click on one of the images and it will open. On the left of the screen there is an editing toolbar. The next option after this is to Crop the picture. Click "Crop Picture". Then choose the format you want the picture to be cropped to. Then hit Enter.The next option is "I'm Feeling Lucky". With this option you can give the picture the best color possible.Following with Redeye Repair. Cho...
First of all use a grey color shade to draw the outline sketch of the figure. First draw the trapezium in the front. Now draw a rectangle at the side of the trapezium. Make a flat top to the figure. From the middle of the trapezium draw a string protruding downwards. Now divide the figure into three equal sections. Now you have to darken sections on the rectangular side. Draw the vertical lines of the rectangular side curved outwards at the far end. At the front end of the rectangular side ma...
Looking for a new way to jazz up your traditional scone recipe? This video might have the solution you've been looking for. The addition of sour cream is sure to mix things up and add a new twist to your baking adventures.
First of all open the image of Daniel Craig. Go to 'layer' and create a 'duplicate' the current layer. Then from top choose 'colors' then 'saturation'. Now click the 'r' from right side bar and also adjust up the 'hue' to 108 till he looks green. Now adjust the 'saturation' bar till 100 and then click 'ok'. Now go to 'filters' at top bar and then click 'distort' and then 'iwrap' filter. This shall open a new screen. Drag the image large. Now click 'move' and then 'deform radius’. This shall m...
This video demonstrates how to stitch a blind hem. A blind hem does not show stitching on the outer side of the garment, like a pair of pants or a shirt. If you turn the garment you do see the stitching. The reason you don't see the stitching on the outside of the garment is that it's not complete stitching. Depending on your machine it is actually a half of a zigzag stitch and then 3 or 4 strait stitches repeated down the seam. The only stitch that shows is the half a zigzag stitch. Before y...
Wants to add more nuts and seeds to your diet but don't know the best way to incorporate them? With this video tutorial, let Kardena from Kardena's Kitchen show you how to get the most out of a variety of nuts and seeds for maximum flavor and nutritional value.
In this video, a man with an 8 string ukulele teaches you how to tune such a musical instrument, which is similar to tuning 4 strings of a guitar.
So, you've just got yourself an Apple iPad, but it already needs fixed, or you want to check the innards out for yourself, you're going to have to know how to open that sucker up. This video tutorial will show you how to do just that.
If you don't have a Wi-Fi network, you can still easily SSH into your iPhone. Just follow the steps outlined in this video tutorial. First, you will need a Mac or iPhone along with Fuju. Just download the program. Once you have all of this, click on the Wi-Fi bar and click on Create New Network. As a name, click on iPhone SSH and click Manual. This creates your new network, which you will see on the desktop. Double click on it and then look at your iPhone. Go to iPhone. Connect to the network...
Learn how to access the PS3 secret recovery menu by following this tutorial. You will need a PS3, PS3 remote, and a USB charger cable. Hold the power button on your system. Listen for three beeps (as you keep your finger on the power button). The third beep will turn your system off. Repeat this process, but this time, you will hear only two beeps (one beep followed by a quick double beep). Turn your TV on and it will tell you to connect your controller to the PSP. Connect your USB cable to t...
This video takes us through the process of using the Stream Writer and the Save File Dialog Step 1
Learn how to crochet a new born hunnie pot hat. This informative twelve part tutorial takes you step by step, re-enforcing each detail while crocheting. In no time you'll have your hunnie pot hat for your new born using a half double crochet.
To organize the closet you have to start with the donate or keep principle. Start your piles and get rid of the stuff that you no longer need. You can also have a "can't decide" pile that you put somewhere until you decide but the general rule is, if you haven't used it in a year you probably never will. There are six areas in a closet. First is short hang. It is the most common and includes shirts, blouses, and folded pants. Short hang can be hung in one level or double hang levels. Hangers ...
learnaniche shows you how to unzip compressed .zip files using his own example. You'll need an unzipping program for this; usually, WinZip is standard. If you don't have it or if it's expired, you can search "WinZip" on a search engine and click "WinZip - Download Evaluation Page" or CNET's download page. If you're on CNET, just click "Download Now" to download it quickly. Save it to a destination and then open it from there to install it. When you click on the link to download the file, your...
This video shows the method to find the variance and standard deviation using Excel. The variance shows the variability of the data points from the median. We find the difference of the median and the mean. We write the formula using '=' sign. The median and data points are put in it by selecting the appropriate cell. The median is made an absolute constant by pressing the F4 key. This is squared by using '^2'. This is multiplied to the frequency using '*'. The result is found for all the dat...
This video shows how to change the advanced settings to make Firefox faster on Mac and PC.
In this video from PEOPLE celebrity trainer Tracy Anderson shows us how to get a sexy body and keep it that way! First exercise is with your feet a little wider than shoulder length apart and bend and straighten. Do as many as you can. Try not to take breaks. Do up to 100. Next exercise is the butt pulse. Grab a chair and straighten your leg behind you holding yourself up by grabbing the chair. Lift the leg as high as you can and make little tiny pulses towards the ceiling. Next is the outer ...
In this Adobe After Effects tutorial the instructor introduces to cameras. A camera is a different way of viewing your composition. You can have the camera move around and view it in all different kinds of angles and distances. Remember that the closer the camera is to the composition the bigger it appears and the further away you are the smaller it appears. To create a camera go to the layer, new and select Camera. Now a camera pops up in your layer panel. You can edit the camera there it se...
The video shows us how to create a dreamy effect in Photoshop. Firstly load the image in the Photoshop and then unlock the layer by double clicking on the layer, press unlock and OK. Now make sure your background and the foreground are black and white respectively and if it’s not then press D and it will reset. And then go to filter, click on distort and select diffuse glow. Here you put graininess as zero, glow amount as 6 and clear amount as 19 and press OK which will make the glow with lig...
Handmade cards with rubber stamps can be made easily with the following instructions. First, fold a sheet of cardstock in half horizontally or vertically, whichever way you prefer to make your card. Then, trim around the edges with scrapbooking scissors to create a design, or leave the edges straight. You can also find rubber stamps with inspirational messages that you can stamp straight onto the cardstock. Now you can decorate the card front with any rubber stamp you like, but stamp it onto ...
This video shows you how to perform a superset of abdominal exercises. The instructor calls this workout the Super Abs workout. The 1st exercise is dumbbell crunches. To perform dumbbell crunches , lay flat on a stability ball with a suitable weight held behind your head and do normal crunches. Do not jerk your neck. Do up to 15-25 reps. Next exercise is hanging knee raises. You hang onto a pull-up bar and raise your knees up to your chest. Do 15-25 reps. The 3rd exercise is ball roll-ins. Pl...
Understand basic video tricks. A great way to prop up your camcorder when you don't have a tripod and you want a low angle shot from the ground is to use a rubber doorstop. It stays put and you can move it up and back to set the shot higher or lower.
