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 621st installment in their series of digital spreadsheet magic tricks, you'll learn how to write a logical formula using the AND and COUNTIFS functions with mixed cell references in the conditional formatting dialog box to highlight entire row (whole record) in data set (table) when record is unique and matches the s...
This survival cache is made for adventurers who, if lost, may stumble upon this handy little tube and immediately get some food and knowledge of their geographic location.
"Sex and the City 2" is about to take the box office by storm and bring everyone's favorite foursome back into our lives. Get ready for this fun, sexy movie with a makeup look inspired by Sarah Jessica Parker.
Punk rock seems to be coming back, or at least the look is. With daring stars like Lady Gaga and Ke$ha on the scene, and movies like The Runaways sweeping the box office, it seems everyone is trying to recapture the glory days of David Bowie.
Want to write Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will help you on your merry way to accomplishing just that. Specifically, this lesson will demonstrate how to create and work with GUI check boxes (checkboxes). For more information, including detailed, step-by-step instructions, watch this programmer's guide.
Learn how to glass your surfboard by watching this video. You will be an expert after witnessing this master artisan Ian Berenger at work. A glassed on fin is an alternative to fins that sit in boxes like FCS or Future Fins. This is a detail common with classic boards and shouldn't be something you do unless you are an intermediate surfer. Repair your glassed-on fin with these simple steps.
To prevent sliced fruits like apples and pears from oxidizing and turning brown before serving, start by juicing one lemon.
In this Computers & Programming video tutorial you will learn how to enable or disable cookies in Mozilla Firefox. Open up Mozilla Firefox, go to tools > options and click on ‘privacy’ tab. Under the cookies section uncheck ‘accept cookies from sites’ and click OK. This will disable cookies. To remove cookies from your computer, open up Mozilla Firefox, go to tools > options and click on ‘privacy’ tab. Under the cookies section, click on ‘show cookies’. All the cookies will be...
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 557th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHOOSE function look up a formula or function depending on your drop-down selection. See also how to create combo box form controls and data validation lists with the VLOOKUP function.
To play off Gertrude Stein's famous quote, a rose is a rose is a magic paper cube. And with this paper folder's guide, you'll learn how to make your very own magic rose cube from paper using the Japanese art of origami. This design by Valerie Vann, and folded by YouTuber German Fernandez, is great for Valentine's Day or any other day where a paper puzzle rose is needed. Just be prepared... it's a not just a puzzle origami rose, it's a puzzle folding it.
Facebook is a social networking website where you can stay in touch with your friends and even make new friends. Using Facebook you can suggest your friend to some one else on Facebook. To do this first open the profile of the person you want to suggest. Scroll down and to the left you will find a link which says suggest friends to others. Click on it and this brings up a list of people who are in your friends list. Now select all the people you want to suggest this person. You can select mul...
Learn how to submit your website to the Google search engine in simple steps. 1. First go the Google home page and type in the address bar '/addurl'. 2. Now type the URL of your website in the text box correctly and enter some details about your website in the Comments area. 3. Now type in the verification code to finish and add your website to Google. 4. You can even submit your website to many other search engines like Google.
This is a Computers & Programming video tutorial where you will learn how to hack Google to find anything. There are no audio instructions; only a demonstration of the steps to follow. Go to Google and type into the search box: intitle:”index.of” (type anything here) and search. For example, type in: intitle:”index.of”Shakira mp3. And click search. Then you will get the search results. Now you can click on Index of…/songs and it will take you to the songs index page. From there you can downlo...
Users will need to use Cheat Engine version 5.5. This hack will increase the gold and food amount. Begin the game and play at least 2 levels to earn some gold and food. Open Cheat Engine, click one the computer icon and select the internet icon. Multiply the amount of gold or food by 8. Type the number in the Value bar and click First Scan. Buy anything in the game, multiply the new amount by 8 and put the number in Values. Check the frozen box below and add a new value (should be a divisible...
Open Jungle Magic and then open up Cheat Engine, click Browse and find the process that is running Jungle Magic (ex. firefox.exe). Click Open and in Value Type change to Array of Bytes, copy the cheat code in Hex box and press First Scan. Select the value from the left area, now in the bottom area change the value to the cheat value. Go to the game and start to play, you will see that now you have unlimited time. Go back to Cheat Engine and click New Scan, change the value type to 4 bytes, un...
In this video tutorial, viewers learn how to hack the flash game, Palisade Guardian 2: Modern Combat with Cheat Engine. Begin the game by entering your name and play the first level. After that, open up Cheat Engine and select your internet in the process list. Change the Value Type to Double and Truncated to Rounded (default). Enter in the value of your cash and press First Scan. Then buy something to lower your cash and enter in your new value. There should be only 1 address. Check the froz...
Hard economic times making it tricky to buy all that cat litter? Now you can make your own using old newspaper and baking soda. It might be a little time consuming but if you have an evening to kill, spend it making some homemade cat litter.
Couture designer Kenneth D. King is an expert in what you would need to fill up your sewing box. Here, he discusses buttonhole scissors. Buttonhole scissors are made for making buttonholes without stretching or damaging the fabric. By watching this video you can learn how to adjust your buttonhole scissors so that you can make different size holes. Make sure to never to use these scissors to cut through paper as it will make the scissors dull and make it a lot harder to cut through fabric.
PrimeLoops teaches you how to use loops on Garageband. There are 2 different types of loops - regular and Apple. The last come in .aiff proprietary file format and the information contained has more information than a regular .wav file. To access them click on the small eye symbol in the lower part of the program window. You can switch to music, podcast and all loops. You also have a Favorites tab and you will see the loops that you mark as a favorite. You can also search for all loops in the...
This video will teach you how to increase your PC's virtual memory. Or in other terms, the Random Access Memory space to be used when doing something with your computer. 1. Press CTRL+ALT+DEL. Go to Performance tab. 2. Check the Commit Charge which is also the amount of virtual memory used. 3. Right-click the My Computer shortcut on your desktop. 4. Go to Advanced tab. 5. On the Performance box, click Settings button. 6. Click the Advanced tab. 7. At Virtual Memory box, click Change button. 8...
The Buchla Electric Music Box is a system developed for people who are looking to control a lot of aspects of their sound at the same time. The color-coded connections make it easy for users to distinguish what is controlling different elements. The system is already set up for use with computers and lets you control the voltage of all musical parameters. You can configure it to have a variety of applications. This video will show you to patch a Buchla 200.
This is an informative video tutorial on how to search graphics, tables and charts using MS Word 2010. The author informs that the earlier MS Word editions had fast and easy search options, but the same feature built into the 2010 edition is vastly improved. One simply has to click the ‘Find’ option at the top right-hand corner and a navigation pane opens on the left-hand side. In the search box, the keyword is typed in and all the instances of that word in the document are highlighted, while...
Tracy Hepler and Jaclyn Mullen of YDT TV demonstrate how to gift-wrap your presents in an environmentally conscious way. You will need: newspapers, scissors, tape, and lace or ribbon. Use a daily newspaper page instead of wrapping paper. A lot of paper is usually wasted around the holidays, and recycling newspapers is a great way to minimize this waste. Cut the newspaper to fit the size of your gift and place your gift in the middle of the sheet, as you normally would with ordinary wrapping p...
As of March 2nd, 2010, YouTube began rolling out a new layout for video pages, and one of the things that seems to be missing in the new version, compared to the old, is the option to send a video response. The video response is some YouTuber's favorite option, but now where is it?
Photoshop is a place where we can edit the image in different styles. One of the features is adjustment layer of a photo that is also called as filter correction. It is an easy step to color filtering of a photo. Open a picture in a Photoshop, and select add layer option that present at the right bottom of the screen, then a pop up menu appears. Select filters from the options available, then dialogue box appears consisting of sub options filters and colors. then select the main color from fi...
In this tutorial Photoshopuniverse describes how to create dotted lines in Adobe Photoshop using the brush palette. First create a new blank document in Adobe Photoshop. To open brushes palette, go to menu Window - Brushes. By adjusting spacing and hardness of brush under Brush Tip Shapes menu you can draw desirable dotted lines. To get uniform circled dots uncheck Shape Dynamics box. By holding the shift key click and drag to get a straight dotted line. To create bullet holes or perforated h...
You can have a garden in less than 30 minutes. The key is a product called garden socks. They are two cubic feet long and they have one cubic foot of compost inside of them. One thing that makes this product useful is that they are very light and easy to carry around and they provide a weed free garden. All you have to do is build your raised box and then fill it with these lightweight two-foot socks of compost. Next take the plants that you are going to plant and arrange them in the box in t...
If you're wondering what FoWsc stands for in Guild Wars and what it's all about, here's your lesson. Dooom Box teaches us everything we need to know when it comes to Fissure of Wo Speed Clear: The basics, the parts, the teams, and more.
Wondering how you can finally use that Paragon? Dooom Box shows how to finally start using the Paragon using the Imbagon build in Guild Wars in what he calls the "Imbaguide".
In this video, Dooom Box shows us how to farm raptors quickly an easily using a warrior necro. Clear the raptor cave in under a minute in hard mode using a WARRIOR! Farm.
Curious about the Norn Fighting Tournament? In this video, Dooom Box gives some great tips on the Norn Fighting Tournament in Guild Wars, and some great insight on how to beat Magni The Bison.
Aluminum cans are useful for various DIY projects, but they can be tricky to take apart. In this video you'll learn how to easily disassemble cans.
Welcome to a tennis lesson from FuzzyYellowBalls, the the best place to learn how to play tennis online. Our free video tennis lessons teach you how to play the game in a new way that combines technical analysis, visual learning, and step-by-step progressions.
Want to make a Rubik's Cube just like Erno Rubik? Of course you do, but before you start making all of the intrinsic mechanisms of the classic Cube, maybe you should start out a little simpler.
Watch this automotive video tutorial to see how to clean the mass air flow sensor in a Toyota FJ Cruiser. These detailed instructions will show you exactly how to remove and clean the MAF (mass air flow) sensor in the FJ Crusier, to ensure that your engine runs at peak performance.
Sure, you can buy one, but making an Advent calendar is a nice family project—and you can use better treats!
Need to spruce up (or wreath up) your trailer for the holidays? For this Christmas in your trailer park, let Jolene Sugarbaker show you how to make a classic trailer park Christmas craft... the wreath. This video will show you how to turn ordinary dryer sheets into a festive holiday wreath.
Check out this Autodesk Maya 8.5 two-part video tutorial on how to move objects around. You'll learn about the channel box and how to use your mouse to move around those animated 3D characters. You'll see how to rotate and flip objects and be the best 3D Maya modeler around. Yep, that's right.
Get the shoulders of a boxer without ever entering the ring. This exercise builds your shoulders with a series of classic boxing moves, with weights in each hand to up the ante. Learn how to do dumbbell punches (the four types are: side-to-side, cross up, cross down, and hooks). Presented by Real Jock Gay Fitness Health & Life.
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. We're going to now talk about how to play the game think fast. This is a very simple game. Just use a ball that you have at home, go to your kids room, go to the toy box and choose an easy ball and you would like to line the guest of the party in a circle. Choose a theme. If it's a boy's party, you might want to go with Power Rangers, or spor...
