Microsoft excel is a powerful tool used to work with numbers and data by filling them down in rows and columns of a table. Excels also supports macros, which are small scripts to automate certain functions. In Microsoft Excel you can select entire rows and columns using the range property. You can also use macros to select individual rows and columns as well as multiple variations of rows, columns, and individual cells all at once. In Excel a horizontal line of data is called as row and a ver...
It is of course, non-toxic, and usable on just about anything, from counter tops to pots and pans. To make the basic scrub, you simply need baking soda, as well as essential oil for scent. The advantage of this is that there are a variety of different essential oils out there--if you're tired of the typical commercial cleaner smells, you can make your cleaning scrub smell just about any way you want. To make a more powerful scrub, you can add Borax to the baking soda mixture. The result is a ...
Ever hear of MoneyWell? There's a whole slew of personal budgeting softwares available today, but figuring out which one is right for you is extremely difficult. This video tutorial will help you understand the concepts behind MoneyWell and how easy it is to manage your cash flow.
Check out this masterclass on Houdini 9.5 and how to rebuild the fire simulator. Houdini's Fluid Tools offer a powerful simulation environment for visual effects artists. Senior Mathematician Jeff Lait introduces you to the basic building blocks for generating fluids and low level tools that make it easier to control the simulations.
Want to know how to use the Pyro FX tools in Houdini 10? This masterclass will tell you everything you need to know about using Pyro FX fire and smoke tools in Houdini 10. The discussion covers the addition of exciting new fire and smoke tools. Topics covered include a powerful new fluid up-resing technique, advanced noise and turbulence control, and a highly tweakable custom fire and smoke shader.
Find out a quick and easy way to level up in Ninja Warz. It's pretty simple and no cheating app like Cheat Engine is required.
See how to merge two DVDs into one using DvdReMake Pro. With DvdReMake Pro, you can easily merge two DVDs together onto one disc while even keeping the original DVD menus and without loss of quality.
SAS: Zombie Assault 2 is flash game from Ninja Kiwi. Learn how to hack Zombie Assault 2 with tricks and cheats. Watch this video tutorial to learn how to hack Zombie Assault 2 with Cheat Engine (09/13/09).
Linux comes with a powerful built-in firewall, although the interface can be a little intimidating. With this multipart GNU/Linux networking video tutorial, you'll master basic and not-so-basic IPTables functionality and create the perfect firewall for your home network. For detailed, step-by-step instructions, watch this Linux how-to.
In this video series, learn how to create a simple dynamic simulation by creating a procedural pre-vis avalanche in Houdini 9. Rigid body dynamics (RBD's) are a powerful and important part of creating visual effects in 3D. This tutorial shows you how to use them in Houdini 9 to create a procedural pre-vis avalanche.
In this video tutorial you will learn about a very powerful feature in Houdini called Copy Stamping.
This small but very powerful electrolyzer produces gas that increases the fuel mileage of your car. The elctrolyzer runs on baking soda (4 volts/cell) and produces hydrogen. Electrolyzers in general are machines that uses a direct electric current to drive a chemical reaction that would otherwise not occur on its own.
Part of the fun of an online game is being able to chat with your friends! This tutorial goes over how you can use the in-game chat system to join a chat channel. It also gives you a few channels useful for everyone to join, especially new players. Or create your own channel. Avoid pirate corporations!
Know what's out there! You can send out probes to explore the area surrounding your ship. This tutorial shows you how to send out five probes and manipulate them in order to quickly and easily scan the local territory.
Quickly turn a profit during a combat mission by ratting - killing NPC enemies who spawn in asteroid belts. The difficulty of rats depends on how secure your system is - the lower security, the harder the rats are to kill. This tutorial shows you the best way, as a new player, to earn money by ratting.
In League of Legends, you play the role of a powerful summoner, who may bring other champions to do battle on your behalf at the Fields of Justice. This short video explains how you can track your game stats and maintain your stable of champions using the summoner screens in the game.
This video tutorial shows how to use arborists and farmhands in FarmVille (07/02/10). Farmhands and arborists are two of the most powerful helper tools that you can employ on a large FarmVille farm, allowing you to take care of all of your plants of a particular type with a single mouse click! That beats clicking all over your whole dang farm right? This video will show you how to use farmhands and arborists properly to achieve maximum FarmVille success.
Maya is one of the most powerful 3D asset creation programs in the world. It is also fantastically difficult to use. This seven-part video will teach you how to model an interior environment using Maya. All this video covers is modeling, nothing on lighting or any of the other features in Maya, but it is very detailed and should have you modeling like a pro!
Tornados are a force of nature, and very fun to draw. This tutorial from the fine folks at Drawing Now demonstrates how to draw a tornado surrounded by flying cars and trees. Here are their step-by-step instructions:
This level in God of War 3 has you trying to find and get Apollo's powerful bow. Can you find this weapon? Or does your "God of War" status defy you? Find out for yourself and watch the steps needed to win. Watch the walkthrough for acquiring Apollo's Bow in God of War III for PS3.
HP TouchSmart comes with a lot of inbuilt powerful features. Voice notes is one of them. To use this feature tap on the notes icon on the HP TouchSmart home page. Now tap on the microphone icon which is present at the bottom left of the screen. The TouchSmart contains two microphones that are integrated into you computer and are present on the either side of you web cam at the top of the screen. To record a voice message tap the record button and speak into the microphone. Tap the stop button...
HP TouchSmart is a powerful PC with innovative features. Using the HP TouchSmart Recipe box you can set up the blue tooth headset. The recipe box provides an easy way to work with you recipes using voice commands. You can set up your blue tooth head set to use the voice command feature of the recipe box. This gives the freedom to walk around your kitchen while cooking. The microphones embedded in the TouchSmart can also be used for this purpose but the blue tooth head set gives a better voice...
HP TouchSmart PC is a powerful computer with various features. You can use you PC to connect to other hardware devices like printer, scanner etc. A hardware device might not even work with you computer because the connecting cables might not match. So if you want a printer to connect to your computer you will need a USB connector. If your printer has a normal pin connector, you cannot work with it directly. In this case the other option is to print wireless, provided your printer supports it....
This video takes us through the procedure of creating a transform effect in Illustrator. First, choose a rectangular box and fill color in it. Input some text inside the box. The font and the color of the text can also be changed. Then position the text properly. Make a group of the shape and text. Now go to effect and choose transform. Transform is a very powerful effect which lets us create duplicates. Now select the number of copies, for example, one copy. Select preview. Now set the point...
Are you ready for the last boss fight in the Xbox 360 game Darksiders? Once you fight Abaddon in the Destroyer, you win, unless you lose. You'll now have to face Abaddon in his "normal" form. He is a powerful swordsman so you'll want to take the defensive route as he can block most of your basic attacks. Instead of attacking him, be patient and stand near him. You'll need to perform a Block Counter but simple tapping the Dash button (without hitting the directional stick) the moment before Ab...
Keep your crossblade near for this level of the Xbox 360 game Darksiders, In the sub-boss fight in Twilight Cathedral - The Jailor, make sure to target the sores. This grotesque monstrosity towers over War. It is almost as wide as it is tall. You'll want to keep your distance from the Jailer as it has a powerful attack in which it slams the cage it carries onto the ground. You'll want to spend most of you time here with the monster targeted while you backpedal away from it. The biggest annoya...
Get ready to battle Uriel in the Xbox 360 game Darksiders. Uriel is an incredibly quick and powerful Angel. Follow the tunnel to the sewer then take a left. At the end of this straight away, swim down into the hole and through the tunnels below. You'll emerge in another sewer section. Climb the Demonic Growth along the right wall but avoid the glowing orange bits (they explode). Climb to the ledge up above then leap to the cable in the middle then shimmy across it to the far side of the gap. ...
The Battle of Forli: This is downloadable content that fills in the missing pieces and has Ezio defending the town of Forli from the Orsi Brothers. There are six new memories and Leonardo's flying machine makes a return allowing players to fly it across Romagna. Ezio is joined by Machiavelli and Caterina Sforza to protect a Piece of Eden from the Templars. For more info, watch the whole gameplay.
No need to figure out the 20th puzzle, entitled "The Origin of the Species", in Assassin's Creed 2. Here's the answers! Puzzle wheel: Start by turning the fifth ring right ten times, then turn the fourth ring left twice. Then rotate the third (and first) rings right twice, the second ring right five times and the first ring left three times. Image 1: Highlight the eye at the top of the painting. Code wheel puzzle: Ignore the numbers and focus on the Assassin motto: “Nothing is true, everythin...
Here's the answers to the 19th puzzle, titled "The Fourth Day", in Assassin's Creed 2. Image set: What used to be worshipped by every primitive culture under the…? That’s right, the sun. Pick the five images that focus on it. Image: Find the tiny image of Earth in the lower-left quadrant of the sun. For more info, watch the whole gameplay.
The 18th puzzle is called "Synapses". See how to solve it in Assassin's Creed 2. Code wheel puzzle: Your first clue is to line up 5 with a single tree-looking symbol. The key here is the weird-looking equation on the left, which offers a hint as to the progression of the symbols.
Figure out the 17th puzzle, entitled "The Bunker", in Assassin's Creed 2. Code wheel puzzle: Here’s a tricky one; your clues are “<” and “2,” and the only advice you’ll get from your handlers is that maybe there’s “something we can count” on the strange symbols. In this case that “something” is the number of times each symbol bends sharply. Don’t expect consistency across the wheel on this one; just take a look at what symbols flank the blank spaces and pick a shape with the number of bends t...
This one's pretty easy. Here's the solution to the 16th puzzle, entitled "The Cavalry", in Assassin's Creed 2. Image 1: Just move the cursor to the word “Tunguska.” Image 2: Move the cursor onto the staff and drag it onto Tesla’s photo. For more info, watch the whole gameplay.
Get all of the info on the 15th puzzle, entitled "Guardians", in Assassin's Creed 2. Puzzle wheel: Seemingly every other ring is linked here, so we’ll cut straight to the chase: Turn the third (and fourth) rings right twice, the fifth (and first) right four times, the fourth (and first) right five times, the fifth (and first) left five times and the second left five times. Finally, move the fifth (and second) rings right five times. Image: Another gimme – just move the Assassin logo over the ...
The 14th puzzle, entitled "Bloodlines", isn't really that hard in Assassin's Creed 2. Set 1: Highlight the images that depict women and gods in amorous entanglements (especially if those gods are disguised as animals). For more info, watch the whole gameplay.
Solve the challenging 13th puzzle, entitled "I Am Become Death, the Destroyer of Worlds", in Assassin's Creed 2. Code wheel puzzle: This one’s even trickier than the last one; starting with the hint that 9 (next to the tower) equals “triangle” (up and to the left from the bomb), you need to figure out which symbols would fill in the blank spots on the wheel, going by the symbols next to them. Image 1: Just hit the button. It’s not hard. Image 2: Use the Geiger-counter clicks to guide you. For...
This is the 12th puzzle, entitled "Titans of Industry", in Assassin's Creed 2. Code wheel puzzle 1: The key here is in the “4=1” on the blueprint at the left of the screen. Line up the red 4 over the gray 1 and input the following code: 917240. Image 1: This one’s the opposite of the light-bulb “puzzle” from before – just move the dollar sign over the bulbs to extinguish them. Image 2: Highlight the glowing ball at the center of the image. Code wheel puzzle 2: Your hints here are the “2” on t...
Find out how to solve the 11th puzzle, entitled "The Inventor", in Assassin's Creed 2. Image 1: Just move the lightning bolt over the bulbs to bring them to life. Image 2: Highlight the area just at the base of the tower, between the two windows, to find this hidden image. Image 3: Move the pointer onto Tesla’s lap. For more info, watch the whole gameplay.
Figure out the 10th puzzle, Apollo, in Assassin's Creed 2. Image 1: Highlight the lunar lander just down and to the left of the moon. Puzzle wheel: Another linked-ring rotation puzzle. Your job here is to align all the channels; do this by moving the fifth ring to the left six times, the second ring to the left four times, the fourth ring to the right three times and the third ring to the left five times. Then snap the first ring into place. Image 2: Move the cursor down between the flag and ...
Execute the 9th puzzle, called Hat Trick, in Assassin's Creed 2. Image 1: Move the cursor onto Houdini’s torso. Image 2: Move the cursor over Gandhi’s heart. Code wheel puzzle: Your hint here is pretty obvious; there’s a big, glaring “6=1” next to Oswald’s picture. So move the red wheel so that the 6 is over the gray 1, and plug in the corresponding numbers. For more info, watch the whole gameplay.
