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 726th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SIGN, COUNTIF and SUMPRODUCT functions to count 1 for each item in a first list that's also contained in a second list.
In this clip, you'll learn how to create and set up a company file QuickBooks Pro 2010. Whether you're new to Intuit's popular business accounting application or just looking to pick up a few new tips and tricks, you're sure to enjoy this free video software tutorial. Take a look.
This Dwarf Fortress tutorial will show you how to brew drinks, change dwarf labor options to make dwarves do different jobs, and dump stone from your stockpile to make room for more important items.
Go to your Joomla admin page. Now go to extensions, module manager. Now on that page, click on new. Now select login button and click on next. Now type the name and set the position, it depends on the template you use like if you have the help file of that template, you can figure it out by checking that but many free template does not contain the help file. So for now, set the position left and click on save. You can arrange the order of your modules just by clicking the up icon or just by e...
Want to create netted necklaces, earrings, purse decorations or any other netted designs. This video demonstrates and explains how to create a netted bead. However, the basic procedures which are
Here it is! The final chapter in Monkey Island 2! Dinky Island! A very anti-climactic name for a final chapter if I ever heard one. It's the final showdown with LeChuck, and we find out some great secrets about their relationship! If you're a little lost, or if you're wondering if you missed anything, you're in luck! This video is a complete walkthrough of chapter 3 "Dinky Island" and contains all the items available as well as the ending of the game.
Vortex is a puzzle-platformer in the Braid / Limbo vein, except with the somewhat selfish mission of getting yourself into a sauna. This video will show you how to beat all of the game's many levels, ensuring maximum sauna enjoyment.
Sloppy Joes, an American classic. Fed to more kids in more cafeteria's around the nation than anything else, besides those cardboard pizzas (ick). If you want to make one, don't run out to the store and buy the pre-made stuff, make your own! It'll taste a lot better and you will still feel the same nostalgia you would if you bought the canned stuff! In this great video you will watch as she shows you how to prepare the sauce and the meats into a delicious lunch item straight from your childhood!
In this video, we learn how to remove water spots from chrome. This is one of the hardest surfaces to get water stains off of, but it can be done easily. First, grab an empty spray bottle, vinegar, water, a rag, and a paper towel. Now, mix two parts of vinegar to one part of water and spray it onto the chrome item. Use the rag to wipe off the mixture, then continue to spray on once more. Do this around five times total, then use a paper towel at the end for the finishing look! You can use thi...
In this video, we learn how to save time and money at the grocery store. At holiday time, grocery shopping can be extra tough. First, make sure you bring your own reusable bags. Then, place in your soda and water in the cart first so you don't have to re-arrange. Make a list before you go to the grocery store so you don't wander around the store. Also, see if you can place your deli order ahead of time so you don't have to wait around. Have your grocery clerk group like items together so unpa...
In this video, Jeff gives some tips to frequent travelers on how to avoid bringing bed bugs home with them. First, you should begin with inspections of a hotel room, making sure to bring a flashlight and looking carefully in the bed for any bugs. After a stay at a hotel, you should always check yourself for bed bugs before going home. This includes methods such as placing your suitcases in bags in order to avoid infesting your car and emptying your clothes from your luggage outside your home ...
If you have trouble emptying your trash on your Mac computer, you will need to launch the Terminal first, in order to begin troubleshooting the issue. The trash will often fail to accept items, if it believes that a program or object is in use. Move the application that you can't delete onto your desktop. Add a line of code to the terminal. Add the application to the code, by dragging it to the code. It will ask for your code. Enter your password. Press enter. You will need to use a Sudo code...
Shopping is any tourists dream. Buying local and ethnic items is on everybody's travel itinerary, so make sure if you're traveling to China, you know some basic words and phrases in Mandarin Chinese to help you shop and bargain your way to success. Learn how to ask a shop assistant if you can you try something on in Mandarin Chinese. You'll also learn about the currency called RMB or Yuan, and you'll learn how to haggle for a bargain.
When traveling abroad, the one thing you're going to need is how to quench your thirst. Ordering a simple cup of coffee or a hot cup of tea could be impossible if you don't know the local language. This video will show you how to order a drink in Mandarin Chinese. You'll also learn how to point to any snack item that you might want, even if you don't know what it's called in Mandarin! You'll see that communicating with a waiter or waitress need not be too difficult in China.
Bug War 2 is a great Flash strategy game where you control one type of bug against all the others. This video will show you how to beat the game easily.
If you love Mario games, but desperately wish Nintendo would get their rears in gear and develop some new IP, then Enough Plumbers should be right up your alley. It is a loving Mario spoof platformer, and these videos will walk you through all 25 levels.
Shrink It: Falling is a Flash game on BubbleBox where you control the size of a ball and try to make the smiley block fall in each level. This video will walk you through all 20 levels.
King of Bridges is a Flash game that challenges the player to connect increasingly ornate series of islands with bridges. This video will give you a walkthrough of all 30 levels.
LighBot 2 is a great little puzzle game from Armor Games, and this video will show you how to beat all 24 levels in the smallest number of moves possible, 310.
Red Remover Player Pack is a collection of levels for Red Remover in which the player must try to eliminate all the red blocks while preserving the others.
Crush the Castle 2 is a trebuchet-based physics puzzler where the goal is to use the trebuchet to destroy the castles of your enemies. This video will walk you through each of the game's six world with all Golds.
Pipol Smasher is a fun little Flash game where the player tries to kill as many people as possible with their car without driving off a cliff. This video series will show you how to beat the first 30 levels.
Crazy Craft is an awesome puzzle game on A Game where players have to maneuver a, well Crazy Craft across platform levels. This video series will show you how to beat it.
Ink Ball is a puzzle game on Bubblebox where you navigate small balls into bowls. Pretty simple. This video will show you how to beat the whole game.
Epic War 4 is an action strategy game on Kongregate where you lead massive fantasy battles. This video will show you how to get all four achievements and beat the last level.
Build the Bridge is a puzzle game on A Game where the player tries to build the right bridges to allow their train to pass over obstacles. This video will walk you through levels 1-24.
If you can get past it's somewhat unappetizing name, the you'll find a fun free puzzler in Blockage. This video will show you how to beat levels 1-20 of the game.
Achievement Unlocked 2 is a puzzle-platformer on armor games where you have a dizzying 250 achievements to complete in as little time as possible. This video will show you how to do it in 12:41.
Satanorium is a Flash old-school point-and-click horror adventure game (say that three times fast) hosted on PlayHub. This video will walk you through the entire thing, which looks pretty darn cool for a free game.
In this tutorial, we learn how to draw a variety of prom dresses. First, you will need to start out by drawing the dresses on different body shapes. Make dresses that are long, short, and knee-length. After this, use a marker to draw the outline of the body and the dress, then start to add in the pleats and the dress details. Add on scarves and other items to the different types of dresses, then continue doing this for the different types of dresses and body shapes. When you are done, draw in...
Who knew that that mess of random old clothes and knick knacks piled on your bedroom floor that makes it seem like a tornado just rolled on through could actually help you clean up the mess? Often when we see such clutter (and actually decide to do something about it) the natural and easy thing to do is simply to pick up the junk and toss.
Make homemade trading cards of your family! These won't look exactly like baseball cards, or even feel like them, but they're cute and somewhat artsy depictions of your favorite photographs. You only need a few items (listed below), but make sure you have a nice photograph to transfer over. It won't look exactly like the picture, but it will look roughly hand drawn, but not quite. Definitely an interesting paper craft. Try it out. Experiment.
Many of today's cleaning products contain chemicals that can be harmful to pets, children, and even adults. Sure it can get the job done, but what's more important the health of others or your stuff?
Filters are an important item to vacuum cleaners nowadays. Unlike the older models, these filters help catch any damaging dust or particles from re-entering the air or floor. They also help protect the inside of the vacuum cleaner and ensure that it will work for years.
In this tutorial, we learn how to make knit stitch markers. First, knit to the middle, doing two stitches together, then flip stitch over. When you get to the middle of your item, place your marker on the stitch to keep track of where the loops are at. You can purchase a knit stitch marker from a variety of different craft stores. Use this as often as you'd like, especially if you need help finding the gap when you are creating something. Set this aside when you are finished, and make sure yo...
In this tutorial, we learn how to replace spark plugs in a 2005 Jeep Grand Cherokee. First, prop your hood up and leave it open. Next, remove the hoses around the spark plugs and use a wrench to remove the casing around the plugs. After this, squeeze the top of the connector and unplug the wires. Next, remove the spark plugs and replace the new ones back inside. When you are finished, you will need to replace all the items that you removed, making sure to replace everything where it was origi...
This video tutorial belongs to the Electronics category which is going to show you how to make a hack pack. This is basically turning a notebook in to something that you can take literally anywhere. Here you will learn how to create a video streaming hack pack to carry around with you and be able to do live internet shows anywhere. For this you will need a netbook, Sony PSP, mobile Wi-Fi thumbstick, microphone and a webcam with Velcro or adhesive. Plug in the mobile Wi-Fi stick for internet c...
In this tutorial, we learn how to demonstrate the difference between land & sea ice. First, fill up two large aquariums with water, then add in a glacier to one aquarium and an iceberg in the other. This will see how the water level changes based on the melted of each different ice item. Draw a line at the water line where it started at, then when the ice melts, check the water levels. When finished, see what the water levels have ended up at. Now you will be able to show this to your student...
If you're having a hard time with flying the helicopter in Battlefield: Bad Company 2, this tutorial should help.
If you're one of those crazy completionists who just has to find and exploit every glitch in every game that you get, you've found friends here. This video will show you how to find and exploit one wall glitch in the Atacama Desert level of Battlefield: Bad Company 2 for the XBox 360.
