New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 191st installment in their series of digital spreadsheet magic tricks, you'll learn how to how to extract part of a text string using a formula with the functions MID, LEFT and FIND.
Kevin shows the different features and options with the program ownspy, which is through OwnSpy and is capable of tracking through phone a persons location as well as texts and phone calls. He first logs in and the first screen that opens is the tracking screen where you can sync how often the program will update the persons location. The second tab is SMS, which will show you all texts and conversations as well as the length, date, and time. The third tab lists all the persons contacts. The ...
Now you can find your IP address if you need it and you don't know it, it very easy. Or if you have problem with a person on the internet, now you can discover who that person is. You can find her/his IP address and after that you can find her/his real name. But after you find the IP that you were looking for, you have to check if the person who own this computer is in your network, because if you want to find his/her name, the program works only if the owner is on your network. So if you are...
A below elbow arm amputee demonstrates how to don and operate his myoelectric prosthetic hook and hand. This is a first hand account of what goes into using prosthetic hands and hooks for individuals with arm amputations. This video is an overview of adaptive equipment for handicapped or disabled persons to assist them. The myoelectric hook and hand are very helpful in assisting persons with arm amputations or otherwise missing limbs.
Survive to Round 40 and beyond! This tutorial focues especially on the Kino Der Toten map in Call of Duty: Black Ops. If you're fond of playing either one person or two person games, this video was made for you!
In this video, we learn how to recruit a great staff for your business. When hiring, you want to find someone that has great thinking ability and that you have really good chemistry with. You want to be able to get alone with the person and make sure they have experience. If they are the right person, work with them even if they don't have the experience in the field. Just make sure to keep a list of what your values are and what type of person you want to work for you. As soon as you do this...
In this tutorial we learn how to ride a motorcycle in a group. You will have each person separated by enough length so you can each safely stop. There should be a trail of one in front of the other, not everyone next to each other. Follow the hand signals that each person gives so you call know where to go. You should have one leader and then other people following with one person in the back. If you are riding into the sun, make sure each person is wearing sunglasses because it will be brigh...
Want to find every instance of a person's name on a particular website? This Googler's guide from the folks at Mahalo will teach you how to do just that. For all of the relevant details, and to get started using this handy Google hack yourself, watch this video tutorial.
In this Googler's guide from the folks at Mahalo, we learn how to use plus and minus signs to force Google to include or not include a word when searching for information about a person online. For all of the relevant details, and to get started using this handy Google hack yourself, watch this video tutorial.
One fun way of showing off your creations to people in Minecraft is to share your save file for the world to see. But once you've downloaded them, figuring out how to use them is the hard part. In this video you will get a basic walkthrough of how to install and run other peoples save files in your copy of Minecraft.
With Americans living longer and longer, more and more of them are remaining at home in their old age. Seniors treasure their independence, but some precautions must be taken to ensure that their fragile bodies aren't put under undue stress. Watch this video to learn some ways that you can make a house safer for an elderly person you care about to live in.
This video shows a very basic magic card trick which was created by the person who made the video. This magic trick is perfect for beginners and is simple. First, you should separate the cards into four piles, asking the other person to pick a card from one of the decks. You then should place their card at the bottom of one of the decks and stack the other three on top of that deck. Then you hand the deck to the other person, making sure that you quickly see the card at the bottom of the deck...
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 video, Peter John teaches us how to palm read the heart and head line on the palm. When you see the heart line come across the mounds of Jupiter, you will be able to tell if someone is going to be wealthy. If the heart line is broken up, this shows the person has extra emotions. The heart line going towards the mounds of Jupiter is someone who is looking for a perfect mate to be with. When the heart line crosses and goes between the first and second person, it means that this person i...
In this Spirituality video tutorial you will learn how to palm read with Peter John. If the heart line, the first line on top of the palm, is well formed and curves around towards the center of the first finger, the person is quite good and balanced. If the head line is quite long along the palm and bends towards the lower part of the palm, the person is more practical and mathematical. When you see more than one line on the mount of Apollo or the mount of Sun, the person could take more than...
In this Language video tutorial you will learn how to report another person's words. In other words how to restate what someone else said. This video focuses on two aspects. #1. What's the difference between quoted and reported speech? #2. When can we use say and tell? In quoted speech you quote the exact words spoken by a person within inverted commas or quotation marks. It is also called direct speech. Here is an example. Jennifer said, "I like birthdays." Whereas, reported speech does not ...
In this tutorial, we learn how to read your friend's minds with the book test. First, sit by two friends and have three books with you. Have them pick a book, then write a 3 digit number on a card, then have the other person flip the numbers and subtract them. Now have the other person reverse the digits and add numbers again and add them all together. Now, have the other person circle the lat digit and open the page and word of the digit. Have the people think of the word they come up with a...
In this tutorial, we learn how to read body language and how to flirt with your own body language. The first way to attract someone's interest is to look them in the eye, without glaring or staring at them. When you get eye contact for a short period of time, you will get the other person's attention. If you want to get attention from another person, face towards them and adjust your hair. Another way to show someone you are interested in them is to lean towards them and point towards them wi...
Draw a persons face with this lesson by a professional artist. Start with a basic oval shape. Draw a light guideline through the middle of the face, then a cross line where the eyes might go. Then, draw a line for the nose and mouth. This will leave your drawling divided in three sections. Next, you begin the eyes. Draw oval shapes on the eye line. Then, draw the circles for the middle of the eyes. Then draw in the brows. Next, begin drawing the nose then the mouth. Now you're ready to draw t...
There are many unwanted things that can affect a person's health or how they look. One of the most common thing is warts. These nasty little bumps can hurt over time and if not treated properly, can result in a possible infection. So in this tutorial, you'll find out how to get rid of warts that are found on your skin. Good luck!
If you've ever had a friend who was unable to make a birthday party or graduation due to scheduling, sometimes it can depressing. Especially if you always take pictures with each other for any occasion. Well in this tutorial, you will find out how to Photoshop a person into a picture easily. It's just a cheap, easy way to show that no matter what, nothing can seperate you two. Enjoy!
This quick, beginner tutorial will show you how to use the cloning tool in Photoshop version CS4. This is really simple to do and is pretty fun to play around with. You can add more eyes to a person's face, create another dog that looks exactly like your own, and make dozen batches of bread with just using one loaf. So sit back and enjoy!
Are you "just not a math person"? Hogwash. Everyone seems to think that at one point in their life. With a little practice and study, math will become more and more easy to understand. Start your journey towards become a "math person" with help from this video, which teaches how to graph a linear equation using slope-intercept form.
This video shows you how to use the online file delivery service YouSenditIt.com to send a file to someone. There are two ways to do this. One is to register for an account and send a file, and the other is to do it directly from the interface that you'll find on the website. You don't have to register, but generally if your file is going to be larger than 20 MB the person on the receiving end will need to register. But in this video we're shown how to send a file from the interface you're pr...
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 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 ...
One of the best ways to monitor your diet is by measuring your body fat content. In this three part tutorial, learn how to measure body fat using a caliper. A caliper is a device used to pinch and measure the fat on your body. A caliper is cheap, fast and accurate and makes an excellent alternative to electronic devices. Check out this video and stay on top of your new workout regime - mind the scale and use the caliper to know what's muscle and what's excess.
In this how-to video the person gives a detailed evaluation of the functions of the ti-89 calculator. The video is a short but informative look at the Ti-89 calculator. During the video the person shows a difficult math problem and shows how to use the Ti-89 calculator to solve that problem. The video uses some of the functions on the calculator and shows a display of where the buttons are located on the calculator. It also shows how to properly use the calculator to solve the problem while w...
Once you master drawing bodies and faces, you will need to start accessorizing your people. One of the most important parts of a person's face is their hair. Hair can tell you a lot about someone's personality and define their face. This video tutorial will take you through the steps you need to start drawing realistic looking hair. Start by observing hair in real life and then gather your supplies and start sketching!
One of the easiest ways to measure body fat is by using hydrostatic weighing. It is based on Archimedes' principle, the law of buoyancy. It works by calculating body fat from measuring the amount of displaced water after a person has been immersed under water. Since muscle is denser than body fat, a person who has more muscle will displace less water than a person of the same weight with more body fat. This test is usually performed for a couple times for averaging accuracy. If the test is do...
For anyone looking to edit a picture with one or more persons down to just a single person in the picture, you can use GIMP. This video tutorial goes over how to utilize the paths (or pen) tool and foreground select tool. The paths tool allows a person to select a part of an image to create a series of lines, or paths, that allow you to create a path around whatever you want to select in a picture. This item can then be moved and copied to a completely different photo. The foreground select t...
Get wild and let loose with the timeless game of Leapfrog. Step 1: Find open space
Want to learn what it really means to put your faith in someone else? Try a trust fall, where one person falls backward, depending upon another to catch them.
Learn how to tell if you’re turning someone on — or off — by watching the way their body involuntarily reacts to you. Did you know? If a person you're flirting with develops pigeon feet (their toes start pointing inward towards one another), that person is both attracted to you and intimidated by you.
Studying to be a nurse? Then follow along with this how-to video to learn how to start an IV on a live person. IVs are an important part of a nurse's everyday routine. When inserting an IV needle, be sure to enter at a 30 degree angle. The nursing students in this video, Moe and Drew, insert the needle at 10 to 20 degrees.
If you travel a lot for work and give presentations, you know that, sometimes, you're forced to use another person's computer system. And sometimes your Keynote presentation just doesn't look right. In this video tutorial from Apple, you'll learn how to save a Keynote presentation so you can assure that the look and feel is consistent across platforms.
This instructional dating video demonstrates how to improve your French kissing skills. Pay attention to these tips to formulate the perfect kiss. Keep your eyes closed, watch your hand movements, and pick a side of the face to aim for. Make sure to do a little lip locking and kiss that lovely person's face before moving in for a serious French kiss.
Jordan shows us his own technique to remove even the most serious cases of acne from a photo using Photoshop. This tutorial takes photo retouching one step further to really remove acne without ruining the person's skin texture and color.
Call any number you like and have any number show up on that person's caller ID. You can call from any phone in the World! Great for calling someone who does not want to answer the phone, checking up on your boyfriend or girlfriend, or just having fun with practical jokes. Learn how to change your phone number on caller ID to prank call your friends by watching this video tutorial.
In this English tutorial we look at fame and words connected with it. There are many words to describe a person who is famous or a "star." This ESL video lesson teaches you how to talk about well known people in the English language.
