Automatically Calculate Search Results

How To: Quiet Noisy Apps Automatically with This Ingenious App

You can do practically anything with a modern smartphone or tablet, so it stands to reason that the apps you have installed may serve vastly different purposes. Picture a game and a video player sitting right next to each other in your app drawer—odds are, you want the sound turned up while you're watching videos, but would prefer that the game was muted or a little lower. As a result, we're constantly tweaking volume levels to get the best experience.

How To: Automatically swap out your wallpaper on a PC with John's Background Switcher

Ever wanted to use a slideshow of images as your desktop background? With John's Background Switcher—a free application for Microsoft Windows PCs—, it's easy! So easy, in fact, that this home-computing how-to from the folks at Britec can present a complete overview of the process in just over four minutes. For complete details, including step-by-step instructions, watch this video guide.

How To: Make watching YouTube faster with Firefox

We're sure you can relate to those awful experiences when you seem to be waiting an awfully long time for your YouTube video to load, especially on Firefox. Well, now there's an easy fix for that. Check out this video from Tekzilla to learn about Auto Buffer, a Greasemonkey script that will automatically play your video in HD if available, remove ads, and buffers the video without autoplaying. Watching YouTube does not get any easier than this!

How To: Merge spreadsheets in Excel

If you've ever entered a lot of data into an Excel spreadsheet before, then you know that putting together even one spreadsheet is a pain in the butt. So if you are required to place all the data on one spreadsheet onto another spreadsheet, don't slave away for hours copying and pasting.

How To: Set Google Online Timer

This video will describe you how to set Google online timer. Now you don't have to bother about the timer or stopwatch. You can bring a timer in your Google.com home page. You have to type a command "Google timer 50 seconds" and a timer will start automatically. You can stop and reset the timer whenever you want. Watch the video and employ it yourself.

How To: Rotate your Windows desktop images with photos from Flickr with a free utility

Having cool photos as your desktop can make your computer a welcome sight, but having to find a fresh one every so often can get pretty stale fast. Thankfully, freeware utility Flickr Wallpaper Rotator for Windows PC's can import images for your desktop from Flickr automatically at intervals you set. You can even set it to use photos from a Flickr search or show favorites from a specific user.

How To: Save money, energy and power with your XBox 360

In this tutorial, we learn how to save power with your Xbox 360 (Xbox 101). This can save you money on your energy bill as well! First, turn on your console and then go to the guide button. Scroll to settings and then choose 'system settings'. From here, choose 'console settings' and then scroll down and select 'shutdown'. Make sure 'auto off' is enabled and then your console will automatically power down after six hours of inactivity. With this setting, you will never have to worry about tur...

How To: Record HD video footage of XBox 360 games using an HD PVR

If you read a lot of video game press on the internet, you've probably salivated at the high-quality HD video footage of console games that reviewers are able to record and use to illustrate their points about games. If you too want to be able to record HD footage of XBox 360 and Playstation 3 games and put them on your computer for editing and distribution, this video will show you how to do it. All you need is a $200 device called an HD PVR, which is an external device that records your gam...

How To: Use the Android App My Tracks to time yourself and save your running route

This video represent a bit of a digression for the Google Webmaster series of videos, spotlighting a cool Google-designed Android app and how to use it. The app in question is My Tracks, a free app that allows runner, bikers, and other distance exercisers to keep track of their distance, pace, splits, elevation, and all sorts of other information automatically with their phone. It will even create and save a map of your course, which you can then share online.

How To: Use punctuation when texting with Swype on your cell

You might be confused when using Swype and need to use punctuation marks. Have no fear! It is actually quite easy. Swype is a revolutionary new app that is available for lots of newer smartphones that allows you to type messages without ever lifting your finger from the keypad. You literally "swype" from letter to letter. Check out this clip for info on how to include proper punctuation marks in your texts.

How To: Shop iTunes on the Apple iPhone 3G

Right out of the box, iPhone is incredibly easy to use. If you want to get the most out of every feature, you’ve come to the right place. This video tutorial straight from Apple will teach you how to shop iTunes on the Apple iPhone 3G. The iPhone redefines what a mobile phone can do.

How To: Use the bibliography feature in MS Word 2007

In order to use the bibliography feature in Microsoft Word 2007, you will need to begin by opening your document in Word. Find the place where you would like to add a reference. Place your cursor in that spot. Then, go to the tool bar. Click on "Insert Citation". Click on "Add New Source". When the pop-up opens, enter the information about the periodical or book that you are citing. Fill it in completely. Make sure you choose the type of material you are referencing in the top drop down menu....

How To: Measure stones, bezels, and mounts with brass measuring calipers

If your idea of jewelry making is simply strining on glass beads and vintage knick knacks onto a string and then adding a clasp, then you have some serious learning to do. While in the end creativity trumps all, it's important for many intricate projects that you calculate exactly how much of one particular stone or filigree stamp you need. And in order to do that, you must measure them.

How To: Use AGGREGATE instead of SUBTOTAL in MS Excel 2010

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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...

How To: Build a worm composting bin

Leigh Ramsdell and Hal Brindley with The Environmentals discuss how to build a worm composting bin. To build a worm composting bin, you will need a plastic tub or a box with a lid. Calculate one square foot of surface area per pound of worms. A pound of worms can process a half a pound of food per day. Worms need air so put holes in your bin on the top and sides. Also put holes on the bottom for drainage so your worms don't drown and die. Add screens to cover the holes. Put bricks on the bott...

How To: Create collapsible and expandable cell ranges in Excel

This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...