In this video tutorial, viewers learn how to maintain the guide bar of a chainsaw. Begin by removing the guide bar from the chainsaw. Unscrew the two nuts on the side of the saw and then remove the chain. Now rest the guide bar at an angle and scrape off the metal bur, using a flat file. Simply run the file down the guide bar until it is clear of any bur. Then use a tool to scrape any debris that is inside the groove of the guide bar. This video will benefit those viewers who are in the const...
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn how to use a helper cell to remove a time-consuming (expensive) section of your formula to speed up calculations.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll see how a helper column with concatenated fields can dramatically reduce the time a formula takes to calculate.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 9th installment in his "Excel Formula Efficiency" series, you'll learn see two running total formulas, one that is faster than the other.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 10th installment in his "Excel Formula Efficiency" series, you'll learn how to use Manual Calculation for huge spreadsheets so that recalculation only occurs when you want it to occur.
Friction from the water plays a major role in slowing you down when you are swimming. Without proper form and technique, your body will drag in the water. Decreasing drag can greatly improve your speed in the water.
Looking to install Snow Leopard on your system? Have no fear. Get all your bases covered with help from this three-part video tutorial showing you exactly how to install Snow Leopard on your Mac. Snow Leopard was inroduced by Apple in June 2008 as the new predessesor of Leopard. With suppossed improved efficiency, speed, and less of a "memory footprint" - the reviews have been mixed.
Judy discloses her teeth-whitening secrets in this video. Using Crest Whitestrips: Advanced Seal, Judy shows the proper way to apply the strips in order to achieve maximum efficiency. The advanced seal strips are not as gooey as the original and work better, according to Judy. Simply peel off the strips and apply it to both your top and bottom rows of teeth, making sure that there are no bubbles my pressing the strips against all of your teeth. Only using these strips once a day will ensure t...
Darin Cosgrove, founder of Ecomodder.com, used just cardboard, aluminum and duct tape to make his DIY "boat tail", a mod that creates aerodynamic efficiency. The tail, attached to his 1998 Pontiac Firefly, extends the car by 4.5 feet and increases the fuel economy to 64 MPG.
What would it be like to have clothing that killed microbes? Or paper that repelled pathogens? A research team from Rutgers University has developed a prototype out of metalized paper to zap the bad guys without being super expensive. Sound good? Read on.
You may not realize it, but haveing your seat adjusted properly to the right height and angle, can help prevent any sort of injury. Not only will it keep you and your bike safe, but it will also improve your cycling efficiency.
Out with the old, in with the new—but sometimes that phrase is reversed. Just take a look around and you'll see some high-top fades from the '90s and some hipster wearing his great grandmother's Depression-era reading glasses.
DARPA is at it again. This time, the Defense Advanced Research Projects Agency has announced plans to create nanochips for monitoring troops health on the battlefield.
Here are some easy ways to lower your summer electricity bill and make your home more energy efficient!!
Ever wonder what the most efficient method is for resource gathering in SC2? Yeah, me neither. But someone has come up with a nifty chart that displays how many workers you should have until you start seeing diminishing returns. Serious business these games are.
Augmented reality can be used to fascinate and entertain, but it can be applied in the workplace. While companies on the entertainment end received their votes of confidence via funding, two companies working with enterprises demonstrated their worth by teaming up to pursue customers.
Perhaps in tribute to the season premiere of Game of Thrones, Google Glass is demonstrating that what is dead may never die, as Alphabet's X (formerly Googlex) has revealed that the Enterprise Edition of the smart glasses are now available to businesses.
Feel that chilly draft coming through your doors and windows? It might not be as difficult or costly to solve as you might think!
With gas prices soaring in the US and around the globe, the cost to drive to a vacation destination is becoming a much larger expense item in the overall travel budget. Although it's easy to see that gas prices have risen dramatically in the past several months, it's not nearly as easy to figured out how it will impact that upcoming car trip, so here are the items you need to take into consideration to calculate how much it will cost to drive to a destination.
There are a ton of new features in iOS 11, but some of the best ones, in my opinion, are in the Camera app. They're not huge features, but they're much appreciated to anyone who's ever taken a Live Photo or portrait, or even to those who've needed to scan a QR code quickly.
Watch this science video tutorial from Nurd Rage on how to make copper sulfate from copper and sulfuric acid in three ways. They show you how to make copper sulfate from copper and sulfuric acid using two chemical methods and one electrochemical method.
Although retailers like Mac Cosmetics and Zara have been celebrated for deploying innovative in-store augmented reality experiences in their brick-and-mortar locations, a new report throws cold water on the practice.
Sometimes, ceiling fans just don't cut it. They spin meekly, barely generating any air flow to cool down your sweltering room. Or, when turned up high, they can wobble wildly, shaking and vibrating as if the ceiling is about to come crashing down. If this sounds like your ceiling fan, chances are the solution is a simple as flipping a switch.
Apple's iOS 11 release promises many improvements and fresh ideas. One of those new ideas is an image codec called HEIF (similar to HEVC for videos), designed to reduce the space photos take up on your iPhone. But it's so new that it's already causing issues with compatibility.
For efficiency’s sake, if you’re going to cheat on your girlfriend, you might as well date her roommate. Watch this video for some tips on how to hook up with your girlfriend's roommate. You will need a girlfriend with a jealous roommate and the ability to lie convincingly.
This video tutorial shows how to hack FarmVille (07/02/10).
Systm is the Do It Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. We will help you avoid pitfalls and get your project up and running fast.
Getting the most mileage out of your car is especially important now that gas prices are rising. Learn how you can improve your fuel efficiency and the gas mileage of your car with the tips from this how to video from the DIY network. Save a some money the next time at the pump with this gas saving tutorial.
This creative street vendor has invented not only an innovative recipe, but also hand-built the cookware from bicycle wheels and scrap metal. Another example of Thai ingenuity and efficiency, which often expresses itself in the creation of delicious food.
Moving items in and out of your cafe is the main way to customize your Cafe World experience. Take an active stance on item management, and your cafe will become more productive!
One of the biggest improvements with the Galaxy S9 and S9+ is the redesigned camera, with the latter scoring an impressive 99 overall on DxOMark. But with an abundance of features and enhancements, tweaking the camera's settings for optimal performance can be a little confusing.
Continuity, introduced back when iOS 8 and Mac OS X 10.10 were released, lets users seamlessly connect all of their Apple devices together. With it came a feature known as Handoff that "hands off" an app or task from one Apple device to another, like starting an email on your iPhone and completing it on your Mac.
Are you looking for a way to make your Microsoft Excel formulas more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the very first installment in his "Excel Formula Efficiency" series, you'll learn about the basics of Excel's SUMPRODUCT function — why some people use double negative and why other use times one.
This video tutorial demonstrates tips for how to organize your home office when you are visually impaired. Here a rehabilitation specialist is helping a visually impaired person. The person who is visually impaired should know what is visually important to him/her. Mostly these people obviously need to know where every thing is because they don’t have their eyes to depend anymore. Here visually impaired person is 66 year old Deanne Jackson. She has wet macular degeneration. In order to set up...
This tutorial teaches you how to play the tuba in the high register. Improve your tuba playing with these exercises. Watch this how to video and you will be able to play your tuba in the high register.
Just weeks after revealing plans to port one of its most vital augmented reality products from HoloLens to the smartphone world, Microsoft has finally opened the mobile software floodgates to the public.
Just weeks after officially launching its mobile augmented reality toolkit, Google can now claim one of its first Android and ARCore app exclusives with the Curate app from Sotheby's International Realty.
Augmented reality software maker Upskill has released the latest version of their Skylight platform, adding a number of new tools to ease implementation and improve functionality for enterprises, including a new application builder.
Someone out there is testing an unknown mid-range phone codenamed "Heart," and it has a 16% lead in speed on the Oppo F3 Plus and is just 15% shy of the Samsung Galaxy S8+, according to GSM Arena.
