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 562nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first, middle and last names when the list contains names where some have a middle name and some do not using the LEFT, SEARCH, LEN, SUBSTITUTE, LEN, MID and IF functions.
In this video, we learn how to cover up dark circles and blemishes using foundation. Start off by applying an eye cream underneath your eyes, which will make a base and remove puffy-ness. Next, you will need to apply your favorite concealer in your color over where you applied your eye cream. Go ahead and apply this foundation wherever you have blemishes, using a makeup tool. Now grab your favorite foundation and brush, and brush the foundation on your face making an even coat to cover and re...
In Part 6 of a series of video clips, `ClickHerePhotography` gives tips on how to select the right tripod for various outdoor environments and conditions like snow, rain (hail and thunderstorms), mud, dirt (dust) and waterbodies (river,streams or oceans). It is important to use a sturdy tripod designed to withstand the elements. After using the tripod for the day, it is essential to clean it. For instance, sand or salt water will weardown the legs of the tripod if left for long periods of tim...
In this video, we learn how to prepare a meal for a Crested Gecko with Wally. The complete nutrition for gecko's is the two-part MRP pre-packaged meals. All you have to do for these is mix with water. These are the only meals that combine all proper nutrition for your gecko and avoid killing insects that don't last long and don't provide all nutrition they need. These packages come in two parts that can be store in Ziplock bags that will last for 6 months when stored in the fridge. Not much e...
You can do simple decimal calculation with out using a calculator once you understand the basic concept of decimals. In decimal equations when you have various operations between decimal numbers, you have to go by the order of operations in simplifying it. The order of operations states that you have to first divide, then multiply and at last add or subtract the remaining terms. You have to work the operations from left to right. Use a calculator only when you are required to multiply or divi...
YouTube contributor, Sommerwetter, demonstrates how to make a paper lantern (also known as a luminaria or farolito) using only scissors, a glue stick and a standard sheet of paper (and a candle or the recommended tea light, of course.) Multiple symmetrical folds in origami-like construction and some well-placed slices in the paper create decorative cube or accordion style lantern. She notes that the process is very easy but you must follow it exactly. The author notes that the last several se...
If you ever find yourself in the woods after a long day of hunting or fishing, you're going to need a fire. So in this two part video tutorial you'll find out how to build an upside down fire and make it last longer than the traditional method of making a fire. Enjoy!
We all know if you want to make sure your vehicle will last a long time and run smoothly, make sure you perform the required maintenance. That includes changing the oil. So to help make sure your motorcycle will last a long time, we have a two part video tutorial on how to change the oil to a 2008 Kawasaki 250R. Good luck and remember to check the owner's manual for the necessary tools required to perform this task. Oh and please be careful.
To make a Mario avatar begin by going to change my features. Under hair go to pate three of ten and select the middle one. For color, go to page two of three and pick the bottom middle one. For the eyes, he used the right middle one, but says that you can use really any one you like. As for eye color, again just choose whichever you like. For the eyebrows, go to page three of three and select the bottom middle one and color them brown. For the ears, use the first one available. For the noses,...
The first advice in this video on how to choose a camping tent is to consider the size of your family. You may want one tent for the whole family or one for the kids and one for the adults. Take time to choose a good camping tent that will last. You may need to spend some money to get a good investment in a tent, one that will last. Do you need the tent for car camping or carry camping? For carry camping you need lightweight materials that will be easy to carry. Large tents may have several r...
A purple chongo drink, better known as a "Jay Tee Splash" consists of 4 main ingredients. If you can afford it, Bombay gin is the best. Otherwise, just a basic Seagram's gin or grocery store gin is ok. Next, Ocean Spray Cran-grape, which is cranberry and grape juice. Last two ingredients are Minute Maid orange juice and of course, ice. Get a basic 8 oz. glass and fill half way with ice. Cover the ice with the gin, let it melt down a few minutes. Then you can fill the rest of the glass with th...
In this video tutorial, viewers learn how to draw the character Sokka, from the show Avatar and the Last Airbender. Begin by drawing a circle for the head and a rectangular torso. Add the arms and a boomerang in one hand. Now add the legs and feet. Draw some guidelines on the face and add the hair. Draw the face and start outlining the whole image. Add the details while you outline. Erase the guidelines and start adding the color. This video will benefit those viewers who enjoy drawing in the...
This video questions whether or not the writer should stay with her boyfriend who is living with his last girlfriend. The advice given is it's dangerous. If you truly love this guy then you want a personal relationship with him. It’s going to be hard with him living with his last girlfriend. He may be truthful about not wanting to be with her. On the other side of the coin it would be so easy for him to accidentally slip up. Since the ex-girlfriend and he have been down that road before it wo...
Open After Effects. Create a new composition by selecting "Composition" and "New" from main menu. Use default NTSC DV preset. Keep 30-sec default duration unless you need more time for the video scene to edit. Import several video clips by selecting "File," then "Import" from menu. Navigate to video files you want. Import at least 3 different video files using Import File dialog box. Double click on 1st video file you want to add to your timeline. The file will now open in a video monitor win...
This video is an acoustic guitar lesson from TboneWilson1978. In this video, he teaches you how to play the song "Where Did You Sleep Last Night" by Leadbelly, as covered by Nirvana. He begins by showing you which chords you need to know to play the song. He then moves on to the progression of the chords through the song, and the strum pattern he uses to play it. The chords you will learn in this lesson are the E, A, G, and B chords.
This video teaches the viewer how to do a knitted bind-off on the back side of the piece, the side that this is not usually done on. In other words, it is a pearled bind-off. First, do two pearl stitches, then go into the first of the two stitches and pull it into the second of the two. Repeat the procedure with another pearl stitch and putting the needle into the stitch before it and pulling the yarn through the second one. On the last stitch, use a crochet hook to pull the yarn through the ...
This video demonstrates a way to hack a vending machine for change. First, you should press the top selection button four times, and then press the very last button three times. Then, hold the fourth button from the top and press the last button once more. If done correctly, the vending machine will return four quarters (one dollar) in change. This video may be helpful for people who want to hack a vending machine or who need some quick change.
Doug tries to teach us some basic math fractions. In this particular case, Doug teaches how to do polynomial operations. He uses a chalk board and step by step shows his work on how to do this math. He uses the PEMDAS method but does not explain it. That is parenthesis first, exponents second, multiplication third, division fourth, addition fifth and subtraction last. A straight forward video and well explained mathematically. Doug includes links to the next few videos in order to see the las...
The video shows us how to perform a knitted bind-off on the right side of your work. It is recommended to use a cross hair hook for the right hand needle to make it easier but here is used with the normal needles. Firstly you need to knit the first few stitches and using the left needle take the first stitch and pull it over the second stitch. Then you knit it and again pull the first stitch over it. It is repeated in the same pattern till then end of all the stitches are knit. And after knit...
In this three part video series, learn how to steal the distinguished English Rose makeup look seen all over the red carpet. Part one goes over how to apply the base and foundation. In part two, eye application is gone over, and in the last video, learn how to apply makeup to your lips that will last. Learn how to achieve the flawless, luminous skin, captivating eyes, & soft sexy lips to achieve the English Rose look.
Eleusis is a fun card game that is pretty easy to learn how to play. Grab a few buddies, and check out this video tutorial!
Keep foods fresher longer with these tricks. Learn how to make your food last longer. You Will Need:
Try solving Erno Rubik's brain-teasingly fun classic puzzle... the Rubik's Cube. This puzzle cube mystifies everyone, but not everyone can solve it, unless you watch this three-part video tutorial. See how to solve the classic Rubik's Cube puzzle, step-by-step. You'll learn about the notation, the three different layers, going from the F2L (First Two Layers) to OLL (Orientation of the Last Layer) to PLL (Permutation of the Last Layer). Just learn a few algorithms and you too can solve the Rub...
Learn how to sculpt a mask using 'slab construction' techniques. I use mixed studio clay from scrap. A small segment about ear placement and animal perception are included in the video.
With iOS 12, Apple is making up for mistakes from the past, with iPhone batteries being no exception. The new update builds upon both battery health and performance throttling tools introduced in iOS 11.3 by offering users more information about your iPhone's battery usage than ever before.
When to throw meat away is a common question, and one I often ask when faced with meat sitting in the fridge after a few days. With vegetables, you can usually tell on sight (or with this guide) when they're past due, but meat is not as simple.
When your iPhone can't be found, Find My iPhone is a true lifesaver. When you use the feature, you can ping your iPhone and even see its current location on a real-time map. But what happens when your iPhone runs out of battery? Find My iPhone can't locate a dead iPhone, can it? You might be surprised to know it can, to a certain degree.
Learn how to put together outfits for back-to-school. 1. Pick your wardrobe items from a semi-trendy store (Gap, JC Penny, Bakers, etc.). 2. Match the items based upon body style and individual tastes. 3. Jeans are easily matched with various blouses/shirts. 4. Layer your clothing for added look and feel. 5. Pick shoes that are comfortable to wear and add a little height if you're short. 6. Pick neutral colors for maximum versatility. 7. Mix and match items so it gives the perception you have...
You don't need to spend an hour on your hair before you hit a club or go on a date to look absolutely ravishing. In fact, even if you start out the day in your PJs and don't decide until the last minute to go out, you can still look great with one of these simple updos.
When you first buy a corset from a retailer, you will need to give the thread and fabric the chance to shape itself according to your own personal shape. Here is the best way to break in or season a new corset to make it last longer.
Are you sitting in class just a few minutes before the bell rings, and you swear every time you look at the clock that minute hand keeps going backwards or getting stuck rather than moving forward to your freedom?
Cards that fold open from the front? Pssh, that's SO last year. Make 2011 novel and interesting by sending this funky trifold Valentine's Day card to your lover.
We can bet that the first time you tasted a thick, chocolatey Mississippi mud pie certainly wasn't your last. Made with Paula Deen-approved portions of chocolate chunks, marshmallows, candied pecans, and even more chocoalte, Mississippi mud pie is famous for its utter decadence.
Install this new add-on for Mozilla Firefox and show full-size images from Flickr or Facebook just by hovering over the thumbnail or link. This add-on shows the full-size images in a floating panel without having to open a brand new browser page. Thumbnail Zoom also works on MySpace, Amazon, Picassa, Twitter, LinkedIn, Hi5, Twitpic, deviantART, PhotoBUcket, Tagged, last.fm and Wikipedia. Veronica from Tekzilla Daily demonstrates all the cool features.
The Roku Digital Video Player is one of the best of the net-video-streaming boxes to come out over the last few years, and now is partnered with Hulu to offer Huluplus on it's devices. This video will show you how to use Huluplus on a Roku to watch all your favorite Hulu content quickly and easily.
Braid is a short game, but can be baffling until you get your mind around it's ever-expanding logic. This video is a complete walkthrough of the last level that will get you through the rough spots, but also shows the ending so SPOILER ALERT!
With the first installment of the last "Harry Potter" movie coming out in just a few days, now is the time to break out your "Harry Potter" paraphernalia and paint your face with the colors of your favorite house.
If you're trying to get in some last minute Halloween costume ideas, or have something that you're looking to do with one of your films involving knights armor, zombies, or giant Jim Henson style talking heads, this video from Indy Mogul might just be what you're looking for! Learn how to make all these costumes and effects on the cheap!
Dr. Dre has only ever released two albums, and it's been 11 years since the last one, 2001. But it's lead single "Forgot About Dre" is still a classic, largely because it introduced Eminem to everyone who didn't already know him in '99. This video will teach you how to play the song on piano, complete with long runs and chords that will make your version sounds much better than most of the other ones out there.
Pizza for breakfast? No, we're not talking about nomming on that moldy last slice of pepperoni pizza from three nights ago. Breakfast pizza is a specialty creation that tops pizza dough off with breakfast staples rather than your typical pizza toppings.