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 316th installment in their series of digital spreadsheet magic tricks, you'll learn how to count & list unique values as well as how to concatenate a range of values with a separator.
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 189th installment in their series of digital spreadsheet magic tricks, you'll learn how to count all the days except for Sunday using an array formula for a given date range with a specified start and end date.
See how to make a very tall, simple, yet elegant centerpiece for weddings and other events. You first need a tube and a base that it will fit into. Placing the tube in the base, use a hot glue gun to secure the tube into the base. You can then fill up the balloons with air using an air pump and tie pairs of balloons together. Twisting together four balloons, place the cluster of balloons around the base of the tube. Repeat with an additional 8 balloons and place this cluster at the top of the...
Paper rolls in a circle to close modem will help to increase the interference WiFi up a lot. This helps to increase your WiFI range and signal strength is low. This is a parabolic antenna to reflect the signal in the direction of your laptop.
The Centauri Knot works well with a wide range of line diameters and should regain around 90 percent of the lines breaking strength. The centauri knot is also fairly easy to tie and is therefor a popular choice by many anglers. The knot is ideal for small hooks, rings and swivels. Watch this video knot-tying tutorial and learn how to tie a centauri not for fishing.
Don't use your magic wand tool. Donny shows you how to create a picture perfect beach scape with a hammock.
Power Armor that isn't faction based, mostly around the Brotherhood of Steel, is very hard to come by in Fallout New Vegas. Wearing faction based armor can have negative effects if you're traveling in the territory of a faction that doesn't like that faction, regardless of your standing with that faction. Now THAT's a mouthful! But, there is a suit of Enclave Remnant Power Armor laying at the crashed Enclave Vertibird. Check out this video for the location of the Power Armor!
Raise the Jolly Roger and set sail on the high seas! Seafight is a free to play, browser based game in which you assume the role of a pirate and sail about the world, killing monsters and collecting plunder. This video shows you how to start playing!
Windows 7 has a ton of new features available, and a lot of them are accessible right from the desktop! With features like Aero Shake, Peek and Snap, it's easy clear a cluttered desktop. There's cool wallpapers to add, a newer and more efficient taskbar, improved gadgets, and more. See for yourself.
There are zillions of fun and cool things you can do with guitars, including riffs, hammer down, and so on. But in order to unleash the rock star that we know is hidden deep within you, you have to start with the basics first.
Conceptually, what is node-based compositing and what do nodes do? This clip uses the factory analogy to convey the concept. Blender can process video, images, sequences, and families of images in a directory. Then you'll fire up Blender and talk about threading nodes and how images are duplicated and routed through the compositing network ("noodle"), how threads are created between sockets. Creating threads, cut threads. The clip also points out common threading errors and misrouting threads...
A major Hollywood player since she was a preteen, Vanessa Hudgens knows what looks on the red carpet and what doesn't. And, like most girls, she's found that the smokey eye never fails to make your eyes pop and to the make the eyes of nearby cartoon wolves pop out.
This is a video that explains to a person how to write their name in Japanese. The woman shows two ways as to how to translate your name in Japanese. The first is how the name is pronounced, and the second way is to translate your name based on the meaning. Usually the name is translated based on pronunciation in the native language. The name is pronounced similarly but not exactly the same. For example Rachel is pronounced "Reicheru". She also shows a website where more information can be fo...
This video describes how to make a "no calorie" birthday cake centerpiece with carnations in soft and sweet hues of pink, yellow, white and cantaloupe. first a flower foam was taken. Then the toothpicks were used to join the flower foam together. Then trace out a circle from the foam using a kitchen knife. Add some water to the base of the cake. With equal size flowers decorate the base of the cake. Then the cake is beautifully covered with different types of flowers. decorate with as many fl...
In this video tutorial, viewers learn how to make a Midori based "Green Iguana" cocktail. The video lists all the required ingredients to make a "Green Iguana" cocktail. The ingredients include: an ounce of Midori, half an ounce of tequila and 2 ounces of homemade sweet sour mix. To make the "Green Iguana" cocktail, follow these steps: mix all three ingredients in a cup, mix ingredients by shaking and add ice. This video will benefit those adult viewers who enjoy alcoholic beverages and are w...
This video teaches the secrets of applying flawless false lashes. An excellent summary is given below. First hold the lashes with tweezers to your eyelash to check the size of it. Cut it off a bit if the false lashes are big compared to your eyelashes. Now apply some glue carefully to the base of the false eyelash. Close your eyes and stick the false lashes to the base of your eyelash and hold it for a few seconds to let it dry. After the glue gets dried blend the false lashes to match with y...
New to the Ruby programming language or simply looking to brush up on your skills? In this installation from his Rubyology series of Ruby tutorials, YouTube user cmatthieu demonstrates how to use SOAP-based web services with Ruby. To learn more, take a look!
From brute force hardware-based solutions like pointing a camcorder at your monitor to more elegant, software-based solutions like (the free and open source) Xvidcap, there are no shortage of ways to create a screencast while running Linux. In this how-to from Linux Journal Online, Shawn Powers offers a comparative look at many of the most popular techniques employed by Linux users.
Check out this video tutorial to see how to use the BD Genie Safety Lancet blood sampler device. BD Genie Lancets are high quality, safety-engineered, single-use capillary blood sampling devices. They offer a permanently retractable blade or needle feature that minimizes the possibility of injury or reuse. BD offers a full range of blade depth and needle gauges for sufficient blood volume in multiple sample requirements. All Genie's can be used in conjunction with BD Microtainer Tubes.
This video crocheting tutorial, brought to you by thecrochetside.com, demonstrates how to crochet a double crochet base chain. Learn how to crochet by watching this instructional video.
It's fun to put on makeup. IT's not fun to take makeup off. This tutorial video will show you how to get rid off all those products on your face.
In this video tutorial, Chris Pels will show several aspects of defining and using master pages in an ASP.NET web site. First, see how to create master pages declaratively using the ASP.NET master page model and learn what information is best suited to a master page compared to an individual content page. Next, see how to programmatically assign master pages on-the-fly in an individual content page. Also learn how to create a base page class which assigns a master page programmatically for al...
Learn how to open a wooden cremation urn. Most have four screws that retain the base or inset base. These screws can be removed with a Phillips Screwdriver or electric screwdriver.
Learn how to blend between two textures based on distance from a surface in Unreal Tournament 3 Editor.
This tutorial shows you how to add flag bases to capture the flag maps in Unreal Tournament 3 Editor.
Check out how to make this Italian fruit cake. This is the base for the cake.
Italian salsa verde is a parsley-based sauce flavored with salty seasonings like anchovies and capers. You can enjoy this easy salsa verde over pasta, meat, or fish. You will need anchovy filets, capers, canned tuna, olive oil, parsley, lemon, pepper and a galic clove. This sauce is like a parsley-based pesto and can be served with meat, fish, or pasta. You can store extra salsa verde in the freezer.
Learn how to make this origami creation which can be used as either a base or can be filled with water.
You can learn the 60 football base defense. It is a great defense for youth football, but everything changes when you blitz. Corners stay at home, linebackers take a step back, and safeties play pass only.
Check out this video if you are interested in learning about improving your jailbroken iPhone's wireless signal reception. This video explains Wifi booster, an app available in Cydia, which removes Apple's barrier against weak wireless signals, giving you more range.
If you are looking to replace your old microwave with a new one, or making your first foray into the world of microwave cookery, this video can be your guide to installing you microwave in the wall. The Panasonic NN-SD277WR is used as an example.
Wheel pose, also known as Chakrasana is one the most famous poses in yoga. It is well known because it delivers many benefits, ranging from improved strength and flexibility of the back, legs and arms to relief of hormonal imbalances.
Take your cartooning to the next level! This video will show you how you can make your cartoon characters more expressing and emotive with outrageous facial expressions. Watch the artist demonstrate a full range of facial expressions and you will learn how to draw.
Looking for a way to boost your iTouch device's wifi signal at home? The answer is rather simple - all you need is an Asian cooking wok! The shape of the pan functions like a satellite dish, boosting your signal!
Optimize vehicle performance by knowing the differences between the different tires available for your RC vehicle. Each type of tire (commonly referred to by the red dot, blue dot or green dot) is optimized for a specific operating temperature range. Knowing about the different temperatures and what tires are best suited for them could be the difference between first place and second. Find out more in this instructional video.
Multiband processing allows you to apply an effect to only those parts of a track that fall within a certain frequency range. This official video guide from James Bernard of Propellerhead will teach you everything you'll need to know to use multiband processing (like multiband compression) in your own Reason & Record sessions. Whether you're new to Propellerhead's virtual music studio application, Reason, or their newer DAW app, Record, you're sure to find much to take away from this brief vi...
Sniping is a good skill to pick up when playing war games, since it allows you to kill enemies with great accuracy at long range. You'll need to find good spots with decent cover that give you access to enemy targets without revealing your own location.
It's not just for playing video games! Strap a Kinect to a Roomba and wire it together with an embedded wireless-N computer, a range finder, voltage distribution board and an external Li-Poly battery. And voila, you have your own custom made robot!
The boomerang wielding Nomad is good at both ranged stun attacks and crowd control, and can be adapted to fit a variety of play styles. Here's how to integrate Nomad into your own team matches when you play Bloodline Champions.
This tutorial shows you firstly what a boffer spear is (and is not), and then goes over the basic stances and techniques you can use when you're on the battlefield and fighting with a foam spear. Learn how to overcome an entire phalanx with a ranged weapon!
