In this video, we learn how to quickly copy and paste data in Microsoft Excel. First, if you have two columns that you want to add up, you will highlight the columns and then copy and paste them into the other cells. Another way is to select the cell and go to the bottom right hand corner, then drag it down. This will fill your formula in to every cell below it! This will save you a lot of time instead of having to type in formulas for the columns that you are trying to do equations with! Thi...
Yes, we know, most manga girls look innocent anyways (though the same isn't always true for their personalities), but this manga girl is truly adorable and friendly-looking. Of course, the big, bright childish eyes and pursed lips probably help with that.
Chances are, if you have some elder relatives who have paid you a visit during the holidays, then you probably have more than your fair share of cable-knit sweaters in various ugly Christmas designs. While we're certainly not a fan of these types of sweaters, the cable-knit technique is one that is used very commonly in knitting and is one of the most basic.
Wire jewelry is one of the most beautiful types out there. With a delicate appearance and ability to bend into gorgeous curvalinear patterns or wrap endlessly around necklace pendants, wire jewelry is also easy to maneuver for beginners.
In this video tutorial, viewers learn how to create drop down menus in Microsoft Excel. This task is very easy, fast and easy to do. Begin by highlighting a desired cell. Then click on the Data tab and click on Data Validation under Data Tools. When the Data Validates window opens, click on the Error tab and deselect "Show error alert after invalid data is entered". Then click on OK. Now simply type in the data into the selected cell. This video will benefit those viewers who use Microsoft Ex...
In this tutorial, Shawn Powers shows us hot to update ISOs with Zsync. First, download and install this, then type in "i" and enter in the c file. Then, enter the http address where the zsync file lives, and press enter. After this, it will download the file and compare it to your 'c' file. You can also use a desktop CD as a seed and use the change for an alternate CD if you prefer. When finished, exit out of the program and you will be done. This will save you bandwidth and only take a few s...
In this tutorial, we learn how to make a Halloween card using Cricut Paper Doll. First, cut a skeleton out of the PaperDoll Dressup package, then cut it out two more times. Glue these together to make the skeleton thicker, so it pops out of the page. You can place this next to a paper sentiment that says "bone to be wild", with a black card stock underneath it. You can use die cuts with a view papers to make it look more interesting. Use any other type of decorations you like to decorate your...
In this tutorial, we learn how to create "viva la diva" lip art. First, prime your lips and blend it out with clean fingers. Next, take your favorite type of lipstick and then use lip liner on the edges. Blot the lipstick on the back of your hand, then apply the lipstick again. Next, grab rhinestones and apply them on your lips using a q-tip and Duo glue. When you are done with this, apply a clear lip gloss to the top of your lips. This will give you a glam look with beautiful rhinestones on ...
In this tutorial, we learn how to give personality to your puppets with Paul Louis. Personality is everything when it comes to puppets. Your design should give the puppet a certain type of personality. Create a voice when you put the puppet onto your arm and use it to become a new character. Use different styles of clothing and jewelry accessories to make the character different. Give the puppet the look of the voice you are going to give it. If you want it to look tough, give it a leather ja...
In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.
This video tutorial is in the Computers & Programming category where you will learn how to save multiple locations in Yelp. Yelp is great for finding businesses in your neighborhood. You can also search for something in other cities. You can enter the location in the 'near' box to search for something somewhere else. You can also save locations to easily search later. Click on 'account' and then on 'manage saved locations'. Here you click on 'add new location', type in the location name and t...
In order to make a mini cappuccino machine for a dollhouse, you will need the following: a copper fitting (from the hardware store), glue, pliers, and old jewelry.
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...
In this tutorial, we learn how to make tequila cake with edible puke. This is a great cake to make for a college graduation. You will make the bottle by using Rice Krispies that are shaped into the bottle. Place fondant over the bottle and color it into the right colors. Place a cake underneath the bottle of tequila, and then make the puke by coloring different types of icing. You can place pistachios inside the icing to make it look more like puke as well. Squeeze this icing onto the tequila...
One of the few technical advantage the Nintendo Wii has against its high-tech rival the XBox 360 is that it allows users to browse the web on their console. Trying to do so using only a Wiimote, however, is impractical. Did you know that you could use a USB keyboard instead? This video will show you how to connect a USB keyboard to your Wii, making it MUCH easier and more practical to use the Opera web browser available in the Wii Store. Now can surf the web on a giant screen while reclined o...
Expand your crocheting repertoire by learning how to crochet a crinkle stitch, which does indeed replicate fabric crinkles. With very hole-y yet tightly woven vertical lines of yarn intersection with horizontal ones, this type of stitch creates excellent warm fabric for scarves and cold weather gear.
Margie McCoy teaches us how to make flower corsages in this tutorial. Start by using three of your favorite flowers and take a wire and place it on the top of the flower until it reaches half way through. Then, take your floral take and tire it as tight as possible around the top of the stem until you reach the bottom, stretching as you go. Next, combine all the flowers together, and tie them together until you have the type of arrangement you want for the corsage. Now, add this on a ribbon s...
In this Autos, Motorcycles & Planes video tutorial you will learn how to apply fiberglass filler to a welded area. Fiberglass or aluminum filler should always be added to an area that is welded. This will ensure proper sealing and prevent moisture ingress. There are two types of fiberglass fillers; long haired and short haired. Long haired is stronger than short haired filler. First you got to mix the filler and hardener together as per directions on the containers. Wear rubber gloves and a p...
Learn how to calculate BPM for different types of DNB. While DJing might appear simple to the untrained eye, truly mastering the turntables requires as much time and dedication as mastering any other instrument. Fortunately, the internet is awash in free video DJing lessons like this one, which make the learning process easier than it's ever been. For more information, including detailed, step-by-step instructions,
You've probably seen old t-shirts being turned into dresses, miniskirts, and if you're a fan of Gianny L, even two-piece bikinis, but you've probably never even thought about it transforming them into underwear. It may seem a bit odd at first, but making these intimate pieces from t-shirts means you can customize the pattern as well as the type of cut (cheeky, granny top, or thong?).
Forget dogs - tripods are a man's best friend (well, if he's a photographer). Eliminating many of the factors that create crappy photos, including the instability of holding the camera up by hand, photo blurs, and general strain of weilding those hulking digital SLRs, tripods are always there to lend a helping leg. Or three.
In this tutorial, Science Bob shows us how to do a science experiment with dry ice. First, take a block of dry ice and place a quarter on top of it. Make sure you are using rubber gloves when you do this, it's dangerous to touch gloves with your bare hands. When you press the quarter down, it will cause it to vibrate very quickly. You can put any type of metal on top of the dry ice and it will make different noises. This is only one of the many things you can do with dry ice. You can also use...
In this tutorial, we learn how to apply full coverage evening foundation. First, you will want to apply a cream that has Silica in it, which will fill in any fine lines. Next, you will want to apply a powder foundation, something like Mac StudioFix Full Coverage Foundation. Make sure you use a brush on your skin to apply evenly. Next, if have you have light skin, you can apply your favorite type of powder bronzer on your cheeks with a kabuki brush. Now, apply concealer underneath your eyes on...
Why would you blow upwards of $200 or $300 on a bikini when you can craft a perfect good one yourself? Don't believe us? Then watch this video by fashion DIY expert Gianny L to prove yourself wrong.
David Beckham is known around the world for his incredible curved shot in soccer. In this tutorial, learn exactly what you need to do with your body to inspire the same curve from your free kick.
The cool thing about Just Cause 2, is not only do you play a shoot first, ask questions later type of character, but the game is stocked with a lot of hidden secrets. Or as they are referred to, easter eggs. This video tutorial is presented by the guys at Achievement Hunter and they show you how to find the "Baby" Panay Moustache easter egg. It's easy to find and involves some interesting art. Enjoy!
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create seven types of charts — X-Y scatter diagrams, pie charts, column charts, bar charts, stacked bar charts, line charts, and column and line chart combined. ...
In order to de-hull leafy bean sprouts, you will need a salad spinner. The type of salad spinner you use will make a big difference. Separate the sprouts. Work your way through the sprouts. Separate them as much as you can.
In this video tutorial, viewers learn how to measure the long-board clearance to determine the correct trucks to use. Users will need a measuring tape. The board clearance is a term used to describe the width of the deck, over top of the trucks. There will be 4 holes that make up the bracket. Users will be measuring the distance in between those holes. Measure both the front and tail of the board. The 3 types of trucks to decide from are: S6 truck, S8 truck and S10 truck. This video will bene...
Make an adorable puppy dog out of two balloons, perfect to entertain children with! You can make your balloon creation more interesting and more detailed by adding more balloons. This balloon figure can become any number of different types of dogs if it's decided to change the colors and proportions. Your Balloon Man, Mr. Fudge, is full of balloon tricks! Be sure to find other balloon videos on WonderHowTo from Mr. Fudge teaching everything from animals to planes! In a few twists and a few ti...
In this how-to video, you will learn how to format one of your hard drives in Windows 7. First, go to start and right click my computer. Select manage and a new window will pop up. Go to storage and select disc management. Now, right click the drive you want to format. Type in the name you want for the label and check quick format. Once this is done, press okay. Click okay to continue. This does not take too long. You have now formatted a hard drive. This video shows you the basic steps it ta...
In this how-to video, you will learn how to hold your pick in different ways for certain styles of guitar playing. You must have a pick and guitar. Hold the pick between your index finger and thumb. Feel free to modify the way to hold it so that you are comfortable with it. For strumming, keep your picking hand loose. This will allow you to comfortable strum up and down. For picking chords, relax your picking hand and allow the pick to be slightly more perpendicular when picking. For shreddin...
In this how-to video, you will learn how to set up Windows 7 that system alerts will come up as images rather than sounds. First, go to start, control panel, and click on ease of access. Next, at the top of the window, click replace sounds with visual keys. Check the box that says Turn on visual notifications. You can choose the different types of visual warnings, such as flash desktop or flash active caption bar. Once this is done, click okay to complete the task. Now your computer is set up...
This video tells us the method to remove Trojan Virus from the computer. This can be done in a couple of steps. The first step involves the downloading of a specific application from the web. We have to search this application in Google. Type 'malwarebytes' in the search engine and press enter. Go to the third result starting with 'Malwarebytes Anti-Malware'. Click on 'Download Now' on the resulting page. Open the application and select 'Perform quick scan'. This will scan the computer for Tr...
Decimal numbers, fractions and percents are pretty much three versions of the exact same value. In this tutorial, learn how to work with all three and convert them within each other.
Starting from the beginning is a good thing when it comes to entering the world of break dancing. A beginning break dance move involves getting into a crouch and moving into a type of running position. Find out how to move the feet to complete this break dance move with help from two experts & a free lesson.
Twitter is a powerful social networking website which can be used to update you friends on what you are doing. To send different messages through twitter you will need a twitter account. Twitter account can be registered for free. Log in to your twitter account and go to your home page. There is a text box provided at the top with the text 'What are you doing?'. Enter the message you want in the text box provided. Click update and this message will be shown to all the people that are followin...
In this video tutorial, viewers learn how to hand-write on an HP Touch Smart computer. The HP Touch Smart is a touchscreen all-in-one desktop computer. The input panel allows users to hand-write or type text right on the screen. There are 3 different writing modes in the input screen. The modes are: writing pad, character pad and on-screen keyboard. It can be used in many HP programs such as the calendar and notes. This video will benefit those viewers who have an HP Touch Smart computer and ...
How To Crochet: Double Crochet Stitch is a short video that demonstrates how to create the double stitch. As show in the video, you will need yarn as well as a crochet hook. The video shows step by step how to create this specific type of stitch. The narrator explains that the double crochet stitch is twice the height of the single stitch and also has wider spaces between each stitch. Advice is also given to count your stitches at the end of every row as the narrator cites "losing" and "gaini...
In this how-to video, you will learn how to install a lawn irrigation system. You must have a digital controller with an AV program. This controls the zones at which the water comes on. These can save you a lot on water use. The controller controls the valve which accesses the water. Make sure all your sprinkler heads are all the same. There are different types of heads, each serving for different situations. Backflow preventers are needed as well, as they prevent contaminants from going back...
