This tutorial aimed at someone new to Microsoft Excel shows you how to navigate the basic functions of a spreadsheet. It goes over formulas, functions, formula inputs and cell references, all of which you'll need to master in order to use Excel effectively.
Two Corpses in One Grave is a difficult achievement in Halo: Reach if you don't know where to look on mission 3. You will have your chance right after you acquire the Target Locator when two Wraiths show up for the killing! Just be sure to aim straight and true and you will be alright!
Grafting plants together is the oldest and thus far most important kind of genetic engineering practiced in the world. This video features a farmer demonstrating how to graft plants together, using a tomato and a eggplant as an example. He aims to create an eggplant that will yield for longer by grafting the tomato plant into it. Learning these skills will allow you to expand the world of your gardening by creating your own plants!
MAKE zine aims to bring the DIY aesthetic and mindset to all the technology in your life. They want you to break open things and put them back together in a better way. In this video, MAKE and KipKay show you how to build a plexiglass drawer organizer so you'll be able to find your stuff in a pinch. This isn't a project for novice crafters, but the steps here aren't hard to follow.
MAKE zine aims to bring the DIY aesthetic and mindset to all the technology in your life. They want you to break open things and put them back together in a better way. In this video, MAKE and KipKay show you how to build a lost screw finder attachment. It'll help you find any screw, including plastic ones that a magnet would not be able to pick up.
Ian Beckman of Azerothian Super Villains fame introduces the third installment of How 2 Machinima. This series of tutorials is aimed to introduce both the fundamentals and advanced techniques of WoW machinima-making. Use Adobe Premiere to model machinima and create proper machinima or video game films. Change the lighting to diffused, specular or ambient lighting.
In this tutorial, Peter John teaches us how to palm read: Crosses & islands on the main lines. Lines in the hand show how a person makes a change. When there is an island on the hand, this means the person needs to slow down and be careful. This could also mean their work is going to slow down or something in their career is going to change. If the island continues on throughout the hand, this means the person will manage to carry on and stay within their line of work when they are challenged...
In this Spirituality video tutorial you will learn how to palm read; crosses and islands on the main lines. These very often come on the main lines and sometimes they show a lot of changes in the person's life. If there is a cross on the heart line, it implies an emotional change. It could be a divorce. Islands on the heart line imply upsets; like an upset in marriage. Islands in the head line are often there because of a slowdown, may be they have changed their thinking or may be they have g...
In this tutorial, we learn how to use the main menu functions in Photoshop CS3. All of your main menus are up on the top toolbar. There will be a drop down list for each different tab you select. When you create a new document, you will be prompted with a dialogue box that asks you how you want your page to be set up. Change the preferences to fit how you want your page to look. When you have changed all of your different settings, click on "ok" and you will be brought to your new document cr...
See how to create a main page with a drop down menu revealing secondary pages — also known as parent/child or main and sub pages (subpages). Every version of WordPress brings with it new features, new functions and new ways of doing things. Fortunately, the very same technology that allows an open-source blog publishing application like WordPress to exist in the first place also makes it easy for its users to share information about the abovesaid things through videos like this one. Take a look.
Want to know how to play the main riff from "Sweet Home Alabama" on the guitar? Learn how with this free video guitar lesson. While this tutorial is best suited for intermediate players, rock guitarists of all skill levels can play along given a little sticktoitiveness. For more information, and to get started playing this southern rock anthem on your own guitar, watch this how-to!
To sort data in Excel spreadsheets, have each category (for example, first and last names) in a single column. Click on any cell in the column you wish to sort. Be careful not to highlight the entire column, or results will be sorted only in that column. Click on DATA on the ribbon at the top. To sort in descending order, click on the z-a button. For more detail, click on the main SORT button, and you can specify which columns you want sorted and how. For instance, you can sort by descending ...
The Dahlia Guy is going to explain the importance of disbudding dahlias. He explains that when you disbud a dahlia it allows the main flower to blossom to its fullest potential. When you don't disbud, the other buds that grow out of the flower can stunt the growth of the main flower. Now, when you disbud you want to locate the main flower of the group (3 buds usually, sometimes 2) and then just pull out the buds that are growing next to it. There is no true right or wrong way to disbud so any...
Check out this strategy video for Prince of Persia's The Ruined Citadel Boss: The Hunter. Machinima.com holds your hand through the 1st of 5 Prince of Persia Walkthrus.
Learn how to tie a Klemheist Hitch - This is a gripping knot made using a loop of small diameter rope applied to the main line or object. It greatly resists slipping when the pull is parallel to the main line. This is a good knot for sailing, boating, general outdoors and even bondage.
New to electric guitar? You needn't sound that way. This nine-part video guitar lesson series is aimed at those who have never played electric guitar before and would like to try it for the first time. By the end of this series, you'll be playing the main riffs from Deep Purple's "Smoke on the Water," "Satisfaction" by the Rolling Stones, Roy Orbison's "Pretty Woman," and "Stairway to Heaven" by Led Zeppelin. To get started playing any, or all, above the above riffs on your own guitar, take a...
Take a look at this instructional video and learn how to string your tennis racket by the box pattern. When using this pattern, you'll want a certain number of mains unstrung. Technically it makes more sense to begin the box pattern on the mains rather than the crosses.
Take a look at this instructional video and learn how to start your mains on your tennis racket with a flying clamp, but without the double pull. This isn't a perfect replacement to starting with a starting clamp, but it's close.
So you just picked up a tennis racket. Have any idea what main skips are? How about cross weaving? These are two things you'll need to know if you decide to restring your tennis racket. Take a look at this instructional video and learn how to tell when to skip by counting the grommets. This tutorial also covers cross weaving.
The strings on your tennis racket can become less taut and efficient over long term use. It may be time to get some new strings. Take a look at this instructional video and learn how to start the mains on the tennis racket.
If you're playing through Dark Souls and find yourself going head to head with the Gaping Dragon boss fight, take a look at this video guide on how to defeat him. You'll need to aim for those puny chicken legs if you want to kill the dragon boss.
This tutorial is aimed at users of Pro Tools, but anyone interested in improving their computers' performance can use it, too. It's possible that an incompatible network adapter might give you an error message in Pro Tools, and this tutorial shows you how to disable it.
Aimed at Flash developers who like making games or other applications, this tutorial shows you how to use keyboard mapping so users can control the game using specific keys. This is also useful for photo galleries or slide shows, so users can navigate using their keyboard.
In this video, we learn how to walk through the flash game "I Remain". First you will go through the main floor and pick up the basement key, which you will use to go into the basement. In here, you will pick up a box of nails and return to the main floor. From here, you will go into the bathroom and pick up the extension cord. Go back into the main floor to the guest room, then pick up any tools you see in this room. Next, go to the main room and place the fuse in the fuse box. Continue to g...
Spice up your next movie project with new and interesting camera angles. In this tutorial, learn all about the different options for aiming your camera that you can use to convey new moods or effects. These instructions are easy to follow and are great for first time filmmakers. So, follow along, grab your camera and start shooting!
Firefighters Al Bennett and Jesse O’Quinn of the Houston Fire Department give instructions on using a fire extinguisher. Most fire extinguishers have a rating of ABC, which are suitable for most fires that occur in the home. There are also D and K fire extinguishers, but these are not commonly used in the home.
This is a video demonstrating how to cure a push shot in golf. To do this proper alignment is necessary. The push shot often happens by aiming too far to the left or right. To prevent the push shot, take a golf club and put it directly behind the golf ball, aiming the club where you want the ball to go. Then, take another club and align it next to that club, parallel. Now remove the club that was behind the ball, and move it parallel to the second club on the other side of the club. This crea...
Check out this walkthrough of Residential Evil 5, Chapter 6-2: Main Deck. Resident Evil 5 (RE 5) is the sequel to 2005's Resident Evil 4. This game guide shows you BSAA emblem locations, treasures, and includes strategies for all 6 missions and boss fights.
This is a Corel Draw video tutorial aimed specifically at beginners. If you're new to Corel Draw, this is a great place to start. Watch to see how to make a smiley face in Corel Draw. Any version of this application will work. You won't believe how easy it is to draw a smiley face. this is a very basic icon, very common.
Check out this music tutorial video that demonstrates how to play a simple guitar boogie in G. This instructional video provides fret diagrams and live action to show how to play a simple boogie in G. This video is aimed at budding fingerstyle guitar players, but can be adapted to a pick. Advanced beginners are also encouraged to watch and learn. Play a simple guitar boogie in G and improve your guitar playing skills!
Check out this instructional lacrosse video that demonstrates how to pass the ball in lacrosse. Passing in lacrosse is similar to pitching in baseball. There are important mechanics and skills required. Learn how to pass in lacrosse in this video.
Oreo, the latest and greatest Android OS, lets you enjoy a ton of new features such as app shortcuts and an improved keyboard. But thanks to a feature that's required of all phones that ship with Android Oreo out of the box, your S9 may be the first Galaxy phone to finally receive timely software updates.
'Shepherding Wolves' is an Act 1 main story quest that evokes everyone's least favorite type of video game mission, the escort mission. It's still bloody fun though, and this pair of videos will walk you through the entire thing. Check out the tips below for supplemental aide.
Watch this video to learn how to cheat on a test with help from your iPod. Ask a trusted friend for their notes/answers the night before. Then at your computer, just type up their notes/answers, or the important parts, and then save it in your computer as "How to make Grandma's Secret Fudge Brownies.txt" . Now plug your iPod into your computer and click Start- My Computer- (someone's iPod- Notes. Now you will need a separate window. Click Start- My Computer. Now find "How to make Grandma's Se...
If you're a violin player who's looking to play the main theme song of Pirates of the Caribbean then look no further. This simple video walks you through the song. You'll likely want or need to pause a few times as you work out the fingering, but hang in there and you'll get it. This song is a catchy little ditty you can whip out at any party or seafaring bash. Memories of Jack Sparrow will soon be floating through your head as you play this song. Now you can play Pirates of the Caribbean the...
Beware of large rooms! The key to defeating the first boss in Dead Space 2 is to shoot the yellow markers on its arms. As long as your aim is good, you'll defeat it easily. Also learn more about Isaac's lack of memory.
Men can style their hair, too! This video is aimed specifically at men who want to learn how a flat iron can help them style their hair. The tutorial also shows a few good products designed specifically for use by men in their hair.
This tutorial is aimed at using Cheat Engine to cheat at games that are not online, such as Need for Speed (demonstrated in this video). Change your stats, add extra inventory items or increase your amount of money or experience points!
This tutorial is for those who want to become better boffer fighters, and shows you how to employ both feints and baits when on the battlefield. This is specially aimed at those who prefer to fight with two weapons, or Florentine style.
Just starting to get into the Society for Creative Anachronism? This tutorial shows you some basic footwork and few useful strategies when you're fighting with just a basic buckler (punch shield) and a sword. Though aimed at the SCA, this tutorial will work for anyone into theatre combat, boffer larps or other reenactment organizations.
