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.
Hello! My name is Nicole Valentine and on behalf of Expert Village, I'm here to talk to you about how to coordinate birthday games for a birthday party. Now we're going to discuss the game can you read my mind. This game has a little bit of mystery flavor to it. You'll see what I mean. In this game, you need to utilize 2 rooms. In the first main room, you have all the guests of your party. Then later we'll instruct the guests we're going to play a game called can you read my mind and the goal...
On Thursday, Magic Leap decided to step up its efforts to foster its developer community by launching the Independent Creator Program.
While some in the augmented reality space are tweeting about future amazing immersive experiences and others are showing off cool experiments, Microsoft continues to move forward with tangible business solutions right now that show how the HoloLens can improve business.
It's about time people acknowledged that judging drug users would do nothing productive to help them. In the US this week, two new programs are launching that should help addicts be a little safer: Walgreens Healthcare Clinic will begin offering to test for HIV and hepatitis C next week, and Las Vegas is set to introduce clean syringe vending machines to stop infections from dirty needles.
The Null Byte community is all about learning white hat hacking skills. In part, this is because I believe that hacking skills will become the most valuable and important skill set of the 21st century.
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 tutorial, we learn how to file a player complaint with Microsoft (Xbox 101). There is no tolerance for file complaints, cheating, rude remarks, and anything of that nature. The file complaint feature should only be used if someone really violated the code of conduct. When you feel someone has crossed the line, you will tap the guide button, then select friends. From here, choose the person from the group and identify the complaint. View the profile of that person, then you will be fin...
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...
"Bad Day" by Daniel Powter is one of those songs that can turn a person's whole life around if they hear it at the right time. IN this video you'll learn how to play a cover of "Bad Day" on the piano from a really gifted teacher.
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.
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...
This prank has it all. It's easy to do, requires few materials, won't cause physical harm to anyone or anything (hopefully), and will absolutely terrify your victim while amusing you for days. All you need is a securely passed-out person and a big box (flat piece of plywood optional). You cut out one side of the box so that it will cover the sleeping person like a coffin, then pound on the top to wake them. They will likely think that they have been buried alive and flip out like the guy in t...
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...
When you're examining a patient's chest, you start out by simply looking at them— by inspection. It will be hard to count the respirations visually on a healthy person's chest because it moves so little, but in a patient with respiratory distress, the chest might be overactive and strain may show in the neck muscles. Eve Bargmann, M.D., will also teach doctors about palpation, percussion, and auscultation of the chest and back.
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!
From this video, learn a proper way to fold a letter professionally and place it an envelope. Basically take the letter and lay it in a flat surface, then find a spot in the paper which is almost a certain way up and then fold from bottom to that spot and crease it. Then fold from the top above the previous fold and then crease it so that it is a three fold letter. Make sure that the letter head is up when you place it inside the envelope. So that when a person opens the letter the letter hea...
If someone violates a protective order, there are — the remedy would be the police would be involved. You'll get arrested. So, basically, a protective order is usually good for two years, and it has all the specific things you cannot do. For instance, you can't go by that person's — within 200 feet of them or their residence or their employer. So it has some very specific things. A restraining order is different. It's a standard thing that's given that's a mutual thing where it just says be n...
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 ...
Brian explains us how to use Twitter, one of the best social media networks out there. One thing to notice is that Twitter allows you to send text messages up to 140 characters. In the right corner you can see you account name and your avatar which can be changed from the settings menu. Twitter allows you to follow people and be followed by people. Basically when you follow people you will be able to see messages they post and when people follow you, they will see what you post. Twitter is a ...
This video shows the method to solve word problems using proportions. In the given problem, we have to find the time taken by a person to type 390 words if the person takes 1 minute to type 30 words. This can be solved using proportions. We take two fractions which are equal. We type '30 words' in the numerator of the first fraction and 1 minute in its denominator. This fraction must be proportional to the second fraction. The second fraction has '390 words' in the numerator and the variable ...
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...
