Stress Free Real Search Results

How To: Count unique values greater than a hurdle in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Add a workbook reference to an Excel VLOOKUP formula

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 52nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to have one workbook look into another workbook using a workbook reference. See also how to update workbook references. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Look up a time value with Excel's VLOOKUP function

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 48th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the VLOOKUP, ISTEXT, ISBLANK, OR and IF functions in one formula to look up a time value. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Use a VLOOKUP function inside a text formula in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 51st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a VLOOKUP function inside a Text Formula to add a variable word (e.g., Annual, Semi-Annual, Quarterly, Monthly, or Weekly).

How To: Remove the LCD display from a G5 iMac

In this Computers & Programming video tutorial you will learn how to remove the LCD display from a G5 iMac. This video is from powerbookmedic.com. First, loosen the rubber band around the display by inserting a pointed object and freeing it slightly with your fingers. On the bottom, free the lower end of the sheet and lift it up. Now remove the two screws and dismantle the part as shown in the video. Then on the top of the display unstuck the two stick pads and remove four screws from the fro...

How To: Make sugar-free organic chocolate truffles

In this tutorial, we learn how to make guilt free chocolate truffles at home. Cocoa powder, coconut oil, Stevia, dates, coconut oil and apple sauce are used in this recipe. First, take your sugar free chocolate truffles you created and chill them in the fridge for a few hours, so they are hard. Once your truffles are made, you can now dip them into your choice of toppings. You can choose chopped nuts, coconut or any other topping that you enjoy. Once you're done dipping, you can place into tr...

How To: Clean your car windows so they are streak free

In this Autos, Motorcycles & Planes video tutorial you are going to learn how to clean your car windows so they are streak free. You will need ammonia solution and a mixing bottle. Mix one part ammonia with ten parts of water in the mixing bottle. Make sure you take sufficient quantity of ammonia. Then get a spray bottle and pour the solution into it. Get a piece of rag and a micro fiber towel. Spray the window liberally with the solution and wipe with the rag. Now wipe with the micro fiber t...

News: Fully Functional DIY Pump Action Shotgun Made Out of Paper

This is no paper gun like you've ever seen before. Seriously. Tacome1942's homemade paper shotgun is a life-sized, fully functional Remington 870 replica. It would be hard to tell it apart from the real deal, not to mention it practically sounds like an authentic shotgun, too. The shotgun is made of approximately 97% paper, the remaining 3% consisting of pins, wires, and springs. Check out all the videos below to see the finer details, including the trigger group, shell stop, and disassembly ...

How To: Use Google Hacks to access free media

Watch this instructional video to learn how to use Google Hacks. Google Hacks is a collection of software that explores Google's search function. Hacks is meant in this definition. "A Hack is a modification of a program or device to give the user access to features otherwise were unavailable to them. Watch this how-to video and find out how to use Google to access free media.

How To: Get free electricity from a phone jack

Learn how to get free electricity from your home telephone line just by watching this video. Save money on your power bill, and hack into the electricity coming out of the phone jack. The phone company doesn't monitor electricity usage, so you can probably get away with this con. Check out this video tutorial and learn how to tap into the electrical energy source in your phone line.

Windows Security: Software Level

As many of you know Windows is not the most secure Operating System in the world, but then again no OS is really secure if the user doesn't know how to protect themselves. Later I will show you how to lower the risk even more on your (the user's) end.

News: Pro Flight Simulater

Try this amazing flight simulator used for commercial training, fighter pilot training purposes. Real life like With several realistic sceneries with night and day. With full functioning gadgets. Also you can experience life like combat. Many planes to chose from helicopters, fighter planes passenger cargo planes etc. If your afraid of flying rest at ease this is !00% safe.

News: Welcome to Math Craft

I'll be putting up a real welcome post along with a quick project idea in a couple of hours, but if you managed to navigate to here before that time, I just want to say thanks for coming and wish that you return in a few hours.

Smartphone Challenge: Bubblegum Alley

Like Rachel, I cannot win this week's challenge, but I thought it would be fun to post a picture I took with my iPhone. Actually, I'm not a big fan of taking pics with my smartphone—I rarely do it. But I didn't happen to have my real camera on me when taking a stroll through Bubblegum Alley in San Luis Obispo. This is the only image I ended up snapping with my iPhone.