Guest Running Search Results

How To: Run advanced VLOOKUP queries in Microsoft Excel

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 40th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to perform eleven VLOOKUP tricks including how to use VLOOKUP with the TRIM function to remove spaces from first column of lookup value.

How To: Do 1-, 2- & 3-way lookups with Excel's INDEX & MATCH

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 44th installment in his "Excel Business Math" series of free video lessons, you'll learn how to run 1-way, 2-way & 3-way lookups using the INDEX and MATCH functions.

How To: Organize your life in Microsoft Access

Brand new to Microsoft Office Access? This seven-minute free video lessson, which presents a general orientation to using the popular database program, will see that that you're well versed in all of the fundamentals. Learn how to create databases and forms, how to run queries and more. For the specifics, watch this free MS Access video tutorial.

How To: Do a reverse-order VLOOKUP with Excel's INDEX & MATCH

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 319th installment in their series of digital spreadsheet magic tricks, you'll learn how to run a VLOOKUP in reverse order using the INDEX & MATCH functions and custom number formatting.

How To: Change Windows settings in Windows 7

Now that you've installed Microsoft Windows 7 on your computer or bought a new Windows PC, it's time that you made yourself at home. With this official Windows 7 video tutorial from the folks at Microsoft, you'll learn how to apply custom settings as well as how to keep your Windows 7 PC running smoothly.

How To: Install lighting under kitchen cabinets with Lowe's

In this installment of the Lowe's home improvement series, host, Mike Kraft, one of Lowe's home improvement experts, demonstrates how to install lighting under your kitchen cabinets to make navigating your counter top easier. Mike lists all the necessary tools and materials you will need to complete this do-it-yourself at home project. You will learn tips and tricks for hanging the light fixtures, as well as how to run the wiring, so that the wires remain hidden from plain view.

How To: Upgrade your PS3 hard drive

Looking to expand the storage capacity for your PS3? Look no further. This video will show you how to upgrade your Playstation 3 harddrive. So, if your Playstation 3 is starting to run out of space, it is time for an upgrade. Follow along with this step by step tutorial and learn how to install more room on your gaming system.

How To: SMS or text bomb someone you dislike

Looking to annoy the heck out of someone you dislike? Why not spam their phone a hundred times with a "text bomb" or "SMS bomb"? In this video, learn how to send an SMS bomb by downloading this link. You will need Microsoft's .NET Framework in order to run this program, which you can get at:

How To: Do the 'wall flip' parkour move

There's nothing natural about doing a parkour-style wall flip. The voice in your head telling you not to run at a wall and flip yourself away so you're spinning through the air high above the ground, that's your common sense talking. But like the old saying says, no guts, no glory. In this pretty thorough introduction to the basic wall flip, you'll learn how to do this trick like a pro.

How To: Tie the Plasti Dip Fry

Flashback Max from Alaskaflyfish.net demonstrates how to tie an odd-looking little thing called the Plasti Dip fry. Plasti Dip is a product that can be used to make a rubbery surface. It doesn't run like epoxy, and sets up quickly. As Max puts it, "Dead-drift that puppy, and see what ya get!"

How To: Properly cross a stream in trekking or hiking

A short how to video on how to perform a safe stream crossing or ford using trekking poles when ultralight backpacking. Hiking or trail running often involves crossing or fording rivers and streams. Make sure you cross the water properly so that you don't get caught in a current or injured on rocks.

How To: Use built-in preflight tools in Adobe Acrobat 9 Pro

This Adobe Acrobat 9 Pro tutorial shows you how you can use the built-in preflight tools to identify issues in a PDF like colors, fonts, standards conformance and more. Learn how to analyze and fix an entire PDF, or run single checks and fixups on trouble spots or certain objects. You will also see how to embed an audio trail of the inspection in Acrobat 9 Pro.

How To: Play lacrosse for beginners

Whether you're interested in trying out for the lacrosse team for your school or would like to brush up on basic positions and responsibilities, this video offers a great run through of the most basic elements of lacrosse. The four lacrosse positions will be covered: Midfielders, attack men, goalies, and defensemen.

How To: Run a set offense

Basic lessons covering the set offense. Great for spectators or new players to learn the basics of water polo. Includes setting the hole, driving, RB, strong-side drives, weak-side drives, rotations, and picks.

How To: Make safe drinking water

Using only a plastic bottle, a lighter, a string, and the step-by-step instructions in this how-to video learn how to turn any water into safe, potable drinking water. This is a vital skill for camping, hiking, and even emergency situations when there's something wrong with your running water at home. Check out this video survival training tutorial and learn how to purify water.