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 651st installment in their series of digital spreadsheet magic tricks, you'll learn see how to replace your IF function with a shorter Boolean Math formula! TRUE = 1, FALSE = 0, TRUE*2000 = 2000 and FASLE*2000 = 0.
Looking to make your Google Nexus One or HTC Evo smartphone even better? Unlock your phone's full computational potential while following in a tried-and-true geek tradition: Install Linux on it! This video guide presents a complete, step-by-step walkthrough of the process. For more information, and to get started installing the Ubuntu Linux distribution on your own Android smart phone (without blowing out your phone's Android installation), take a look!
Blow the heads off your friends when you serve them this amazing chili con carne. Learn how to make it the right way, in true TexMex style. This spicy, hearty dish will knock your socks off and please even the pickiest dinner guest. Yum!
Regular hexagons are so blah, so amp up the tried and true geometric shape (and kindergarten building blocks toy) by adding a whole new dimension!
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use comparative operators; logical TRUE/FALSE formulas, IS functions (ISTEXT, ISNUMBER, ISBLANK, ISERROR, ISNONTEXT); IF functions (1 of 2 words in a cell, 1 of...
Now that Kratos had made it past the Palace of Hades, he must confront none other than Hades himself. This is the ultimate boss fight in the Realm of Hades, so be prepared. Try stealing the Claws of Hades to help. Watch the walkthrough for the Hades Boss Fight in God of War III on PS3.
Zeus. He's one of the worst. Can you defeat Zeus on your own? If not, you may need help — you may need a walkthrough to guide you along the ultimate battle against the boss Zeus. Watch the walkthrough for the Zeus Boss Fight in God of War III on PS3.
Check out this L4D2 walkthrough for some tips on Campaign 5: The Parish - Park. Stock up on items and exit via the door right next to the one you entered. Clear out any zombies and work your way up the large staircase into the park. Be prepared to deal with a likely Crescendo event in the plaza here. Pick a one of the staircases to climb up and enter the park. The restrooms near the entrance of the park usually contain a throwable item or two. For more info, watch the whole gameplay.
This last campaign is the hardest one. In the first part of campaign five, try not to drown and watch this L4D2 walkthrough for some tips on Campaign 5: The Parish - Waterfront. You are dropped off on the waterfront and told to make your way to the bridge. Pick up weapons and medpacks and head up the staircase. Go through the gate and clear a path to the Waterfront Market directly in front of you. There should be an open door for you to walk into. You may encounter a SWAT zombie at this point...
And just when you thought it was safe in town, you come back and find out it's like you were never there. Zombies everywhere. Watch this L4D2 walkthrough to play Campaign 4: Hard Rain - Return to Town. Gather any equipment and head out of the safehouse. The suburban neighborhood you travelled through last time is now flooded. You will want to spend as little time as possible wading through water. Try to look for rooftops or makeshift walkways to maximize your maneuverability. After dropping d...
Learn your way around the saccharine and bloody land of the sugar mill in L4D2. See the whole gameplay for Campaign 4: Hard Rain - Sugarmill. Stock up on weapons and head down the stairs to open the door of the safehouse. Clear out any zombies on the street and go across through the open window into the sugar mill. Once in the building, head to the left. There should be an open door leading back outside. For more info, watch the whole gameplay.
Make your way through the deadly plantation in L4D2. See the gameplay for Campaign 3: Swamp Fever - Plantation. Gear up and go outside of the safehouse. It will be light out. Mop up any zombies here and head straight ahead, bearing to the left. You will climb a small hill and see an opening in the fence. Check the sundries building on your left for items. Make your way through the rows of houses here towards the red two-story house at the end. Don't go inside the house, turn left right before...
Don't let L4D2 get the best of you. Take control by checking out this video on Campaign 2: Dark Carnival - Concert. Grab your guns and go out the door. There is really only one path to follow, so move right around the venue until you reach the stage. Feel free to use up your ammo as there will be a refill when you reach the end. There are bathrooms to your right and left, but it isn't worth your time to search them. Clear out any zombies in the stage area. You must then flip the switch on the...
Having some trouble beating L4D2? No problem, watch this which shows you around and gives tips on Campaign 2: Dark Carnival - Coaster. Restock your gear and head out the door. If you have any pipe bombs or pick up any throughout the level, try and save them for the roller coaster chase sequence at the end. Climb up the stairs and continue forward until you reach the swans at the start of the ride. Turn right, and follow the water pathway forward. You can safely ignore most of the tiny backdro...
Prepare to delve into the world of L4D2 and check out the gameplay for Campaign 1: Dead Center - Streets. Stock up and open the safe house door. You should see a bunch of infected milling about here. Kill them and make your way straight up the hill past the port-o-potties. Turn right at the fence and take the street down. Watch out for zombie attacks from the walls to the left and right of you. They will drop down from above. Duck into the building on the right when you reach the fence at the...
L4D2: One of the best horror video games of all time. Check out the tips and gameplay for Campaign 1: Dead Center - Mall. Restock on supplies and head out of the safehouse. Feel free to kill any zombies trying to reach in the door before you unlock it. Hang right and make your way up the giant escalator in the middle of the floor. Loop around and exit Kappel's department store. Go down the first escalator you see. Watch out for zombie attacks from the floor above. They will jump down and catc...
Learn about the L4D2 gameplay for Campaign 1: Dead Center - Atrium. Get the goodies and walk out of the safe house. Turn right and go down the hallway, making another right through the door at the end. You will find yourself back in the mall. Continue on the makeshift walkway, bearing left at the end until you reach an elevator. The blue door across from you is a dead end. For more info, watch the whole gameplay.
Windows 7 is the hot, new operating system replacing the past XP and Vista systems. Windows 7 is the most simplified, user-friendly version that Microsoft has developed - ever. Get acquainted with your new version of Windows straight from Microsoft.
Check out this Scam School video on leanring the ultimate strength tricks. Bend frying pans and horseshoes with your bare hands! Watch Brian make you think he can use his bare hands to bend a horseshoe and to roll a frying pan!
Watch a 4 part series on Spore's Cell Stage. This is the first stage in this new hit game of evolution and creation! How will you create the universe?
Developed by the same team of engineers responsible for LightWave 3D, modo, lowercase, delivers the next evolution of 3D modeling, painting and rendering in a single integrated and accelerated package for the Mac and PC. And now, modo is a true end-to-end solution that includes true 3D sculpting tools, animation and network rendering! More than just features, modo is a truly elegant integration of technology, raw horsepower and refined workflow. With such a wealth of inbuilt features, however...
Devolped by the same team of engineers responsible for LightWave 3D, modo, lowercase, delivers the next evolution of 3D modeling, painting and rendering in a single integrated and accelerated package for the Mac and PC. And now, modo is a true end-to-end solution that includes true 3D sculpting tools, animation and network rendering! More than just features, modo is a truly elegant integration of technology, raw horsepower and refined workflow. With such a wealth of inbuilt features, however,...
Devolped by the same team of engineers responsible for LightWave 3D, modo, lowercase, delivers the next evolution of 3D modeling, painting and rendering in a single integrated and accelerated package for the Mac and PC. And now, modo is a true end-to-end solution that includes true 3D sculpting tools, animation and network rendering! More than just features, modo is a truly elegant integration of technology, raw horsepower and refined workflow. With such a wealth of inbuilt features, however,...
Devolped by the same team of engineers responsible for LightWave 3D, modo, lowercase, delivers the next evolution of 3D modeling, painting and rendering in a single integrated and accelerated package for the Mac and PC. And now, modo is a true end-to-end solution that includes true 3D sculpting tools, animation and network rendering! More than just features, modo is a truly elegant integration of technology, raw horsepower and refined workflow. With such a wealth of inbuilt features, however,...
Devolped by the same team of engineers responsible for LightWave 3D, modo, lowercase, delivers the next evolution of 3D modeling, painting and rendering in a single integrated and accelerated package for the Mac and PC. And now, modo is a true end-to-end solution that includes true 3D sculpting tools, animation and network rendering! More than just features, modo is a truly elegant integration of technology, raw horsepower and refined workflow. With such a wealth of inbuilt features, however,...
Devolped by the same team of engineers responsible for LightWave 3D, modo, lowercase, delivers the next evolution of 3D modeling, painting and rendering in a single integrated and accelerated package for the Mac and PC. And now, modo is a true end-to-end solution that includes true 3D sculpting tools, animation and network rendering! More than just features, modo is a truly elegant integration of technology, raw horsepower and refined workflow. With such a wealth of inbuilt features, however,...
Of all the hand embroidery stitches that exist, one of the most beautiful, when done well, is the satin stitch. It does take a little practice to get the hang of satin stitching, and it is true that it is not a very "forgiving" stitch. Watch the video from Needle 'n Thread to see how it's done.
This is a quick BBoy tutorial put together to show hand hopping techniques. You don't need one arm handstands to do hand hops. Remember to try at your own risk.
A video on how to make the ultimate shaving cream bomb, great to use on your friend's locker or desk at work. Use this as inspiration for one of your April Fools Day pranks!
Did you know that you could learn all the fundamentals of web development for less than $35? Set yourself up for your new coding career in 2021 with The Ultimate 2021 Web Developer & Designer Super Bundle, which is on sale for just $34.99 right now — a huge 98% off the regular price of $1,886.
Quesadillas are great, don't get me wrong. Cheese, tortillas, meat... what's not to like? But I'm going to take a stand: your regular old quesadilla is boring. It's time to step it up a notch and get out of your quesadilla comfort zone.
I'm back! We're learning Java WhileLoops today.
I'm back. School's an ass. On my quest for knowledge, which started approximately 3 years ago, I can upon an interesting little artifact. It is called the Arduino.
Well, first things firsts, it's been awhile! I'm sorry the series has been dead for a little bit, but I recently hit some personal relationship issues and needed to take some time to think. But, now that it's all said and done, the dust can settle and we can start training again!
When summer rolls around, I think of two things: grilling and ice-cold beverages. To me, nothing beats loading up the grill with charcoal, letting the smell of smoke get stuck to your clothing, and imbibing the most refreshing drink you can find.
When setting up a new Mac, there can be a bunch of settings that need to be changed in order to get the system running the way you like it. That usually involves going through tons of System Preferences panes and app settings—but it doesn't have to.
Sometimes you need more than just your brain to split the bill at a restaurant or to calculate how much your cable company is ripping you off.
How awesome would it feel to be a sexy undead ruler of a vast vampire kingdom? Only Sophie-Anne LeClerq, played by Evan Rachel Wood, would know, though she seems pretty happy in her position. The teenage vampire queen of "True Blood" is one sexy diva, wearing very retro makeup and hair.
We're the ultimate foodies, but when it comes to preparing shellfish we get more than a little intimidated. Requiring heavy duty shell removal using knives and knick knacks that look like they belong in a doctor's office, the task is usually one who choose to skip.