Falling Asleep Search Results

How To: Count dates falling within a given year in MS Excel

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 632nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula using the SUMPRODUCT and YEAR function to count instances of the year 2009 or 2010 from a list of dates with different years.

How To: Highlight dates falling within a given year in Excel

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 633rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create conditional formatting that will highlight the dates within a given year using the Year Function and Mixed Cell References in a logical TRUE-FALSE formula.

How To: "Ice a Bro" with Smirnoff Ice

In this tutorial, learn how to play the new drinking game that is sweeping the nation, Bros Icing Bros. Bros Icing Bros started as an Internet phenomenon and has carried its way across the country. If you have a bro that needs to be iced, check out this clip. Take that bro down with a healthy dose of on-his-knees chugging, but watch your back! You don't want to fall victim to an ice-back!

How To: Play the bassline for "Soul Man" by Sam & Dave

"Soul Man" was one of the biggest hits of 1967, and still holds its ground in success. Sam & Dave's hit single, written by Isaac Hayes and David Porter, will forever live on in the music world, and through you… if you play bass. This video is a beginner's lesson to bass guitar, which teaches you how to play the baseline for "Soul Man" by Sam & Dave, with the baseline perfected by Duck Dunn. This is a good bass line for beginners who've played for a bit to get their fingers around.

How To: Make comforting homemade chicken noodle soup

In this tutorial, we learn how to make homemade chicken noodle soup. First, take 3 1/2 lbs of chicken breast into a slow cooker with enough water to cover the chicken. Now, let slow cook until the chicken is done and falls apart. Once finished, take out of the slow cooker and cut the chicken into small pieces. Now, take 2 bouillon cubes and add them to the hot water in the slow cooker. Then, add any veggies that you like as well as garlic, salt, pepper, lemon pepper, basil, thyme and sage. Le...

How To: Choose colorful flowers & shrubs for the garden

This video makes suggestions in how to choose colorful flowers and shrubs in your garden. Bowle’s Mauve is a purple flowering plant that will grow and bloom until fall. It will become bushy. Another colorful choice is the Rock Rose, a pinkish flower. The Blue Salvia has blue flowers. A Bank’s Rose, only bloom for a short time. It has yellow or white flowers. Aphids tend to attack it, but it is hearty.

How To: Ollie on a skateboard, for beginners

It takes most everyone a long time to do an ollie but once you have it done it happens all the time. When first starting out it is a good idea to learn the technique in the grass or on some carpet so the board doesn’t roll around. It’s also a good idea to fully learn the ollie in place before you start doing it in motion. Next is foot placement, have your front foot right behind the front bolts on your skateboard and you back foot on the tail. When you press the back foot into the ground lift...

How To: Grow blackberries in southern New Mexico

Southwest Yard and Garden teaches viewers hot to grow blackberries in Southern New Mexico. Blackberries grow in high rain fall areas but they can work in the south west. They will need bee pollination so you need to make sure that you do not spray too much insecticide on them or you will kill of the bees. Make sure you pick the blueberries when they are dull and not when they are shiny. This will give them the maximum sugar content. Blackberries should grow in sandy soil or looser soil. You m...

How To: Install a fan on your Xbox 360 power brick

In this video, you will learn how to install a fan on your XBox 360 power brick. In order to do that, just follow these steps exactly like in the video: The first thing to do is to buy an 8mm fan and to clear the power brick. Now make a hole in the power brick case and glue the fan to it. Connect the negative and the positive wires like in the video and turn it on. If you follow these steps right, you will get the correct result. Your power brick will get more cold air and the risk of a RROD ...

How To: Care for a lawn in drought conditions

Regardless of where you are, there will probably be a period when your lawn will turn brown and possibly go dormant when there is a drought. Contrary to popular belief, it is okay to use fertilizer on your lawn when there is a drought. Using a higher setting on your lawnmower will allow the grass blades to be longer, allowing them to retain more moisture. When you are finally able to water your lawn again, make sure to water it twice a day, hopefully in the early morning to avoid the heat of ...

How To: Water Evergreens in the fall

First of all, he explains that evergreens will have problems if you don't water them late enough into the season. He introduces Ken Mayer who compares two types of evergreens. He shows a tree which has lost its coloration and explains that that tree lost water over the winter. Its roots have been frozen and if the roots are frozen the water cannot circulate where it is needed. When the spring comes, the plant will need water and it will not be able to be supplied with it. It then gives tips o...

How To: Create a green smoky eye with your makeup

Get that very "right now" green smoky eye with some help from the professionals at Smashbox Cosmetics. By starting with cream liner Midnight Green and applying little smudges along the line, go back to smudge with your brush to create a smoky effect. Stand our this fall with vivid color and this soft, not-so-innocent makeup look.

How To: Do the bunny hop trick on a bicycle

Check out this cycling video tutorial to see how to do the bunny hop trick on a bicycle. Your BMX instructor for the day goes through the very basic steps with demonstrations on the bike bunny hop, along with some out-takes at the end to ease the pain of falling on your ass.

How To: Perform the dime in a bottle bar trick

Bar tricks, gotta love em. This is an easy trick that's hard for someone to win unless they know the secret. Place a small coin on a business card and the business card on a bottle. Now remove the business so that the coin falls into the bottle. business card trick. Unless you know this business card trick it is very hard to figure out. Make a bet and you can win with this business card trick.

How To: Install a vanity and sink with Lowe's

In this video, we learn how to install a vanity and sink with Lowe's. A great way to give your bathroom a makeover is to give it a new vanity and sink. First, turn off the water from the water line, then take down the pipes from under the sink. Use a bucket to catch extra water that's falling out. Next, separate the top from the base and then remove the old vanity. Remove the old base unit from the bathroom and then install the new vanity. Measure out the area to make sure it will fit. Place ...

How To: Master basic mobility on your snowboard

In this video we learn how to master basic mobility on your snowboard. Look and point in the direction you want to travel then transfer weight onto your back foot and slide the snowboard forward. Transfer weight onto your front foot to enable the board to glide forward. Change direction by lifting the snowboard and pivoting on the back of your feet. To climb, place your snowboard perpendicular to the fall line. Then, step your free foot over the snowboard and dig your toe edge into the snow. ...

How To: Make scrambled eggs using a flashlight

This video tutorial is in the Food category which will show you how to make scrambled eggs using a flashlight. Break an egg and pour it in to a small metal container. Clamp a Wicked Lasers torch in an upright position so that the bulb end is facing upwards. Now switch on the torch and place the container over it. After sometime as the container gets heated, the egg will start to cook. Mix the egg with a spoon while holding the container with the other hand to prevent it from falling over. Don...

How To: Make roast beef easily with Mahalo

There's no better way to warm up after a nippy fall day outdoors than by taking a bite into a delicious slice of tender and moist roast beef. Served with a side of green beans and mashed potatoes it truly is an incomparable comfort food and one we will never get tired of.