Money Advances Search Results

How To: Save energy by installing a solar water heater

Saving energy in your home is as easy as pie. There are many areas of the home that you can tackle. One area that can be helpful is the water heater. There are a couple of water heaters that you can use to not only save energy but money. One way is by using an active or passive solar water heating system.

How To: Install insulation for a water heater

There are many ways that you can lose energy and heat in your home, and one of the most common ways is by the water heater. It may not seem like it, but you can lose a lot of money and energy when using your water heater. So it's important to take the necessary steps when you want to save energy and money. In this tutorial, you'll find out how to install an insulation jacket for your electric or gas water heater. Good luck, be safe, and enjoy!

How To: Use the Mail email app on an Apple iPad

If you want to send and receive email on your Apple iPad, unless you're an advanced user, you'll most likely want to go through Apple's official Mail app. Fortunately, it's easy to use. So easy, in fact, that this guide can present a complete, step-by-step overview of the process in just over three and a half minutes' time. For detailed instructions, and to get started reading and composing email on your own iPad, take a look!

How To: Do a yoga flow into a handstand with Tara Stiles

Despite common misconception, yoga is extremely intensive and a challenge for core stability and muscle stability, especially when you encounter poses like handstands. Not easily done by even the most experienced yoga experts, handstands are a true test of your yoga prowess and ability to say "ohm" with two feet up in the air, arms aching and trembling.

How To: Install the Window Seal Onto a VW Bug Window

Restoring any car can be a difficult task for even the most advanced mechanics. It takes time and patience to turn an old pile of junk into something new and beautiful. So in this tutorial, you'll find out how to install new window seal and trim onto a classic VW Beetle Bug. It's fairly easy to do and in the end, will result in a great looking vehicle. Good luck and enjoy!

How To: Adjust the brightness on your Android phone

Some people like their screens to be dim while others like theirs to be bright. Some like brightness to automatically adjust, while others like a constant level. One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial will show you how to adjust the brightness of the d...

How To: Map a walking route with MapMyWalks on Android

Take walks for exercise, to roam around your neighborhood, or just to get outside? Want to know how far you walked? Well, it's easy to do with MapMyWalks and Google Maps! One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial will show you how to map out your walks us...

How To: Manage running services on your Android phone

With some mobile devices you can't be certain exactly what's running and it can be difficult to stop programs. Not true on your Android device. You can easily look at running services and stop them if desired. One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial, in...

How To: Use location and security settings in Android

Many applications, especially those found in the Android Market are more effective when they know your physical location; like an app that's going to find the nearest gas station, restaurant or ATM. One of the salient advantages of a Google Android smartphone over, say, an Apple iPhone, is the inherent extendibility of the open-source Android mobile OS. There are a seemingly infinite number of settings to tweak and advanced features to discover and use. This free video tutorial, in particular...

How To: Extract email extensions with filters in MS Excel

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 338th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the REPLACE and FIND functions in a new column to extract e-mail extensions, and then use Filter or Advanced Filter to Extract records according to e-mail extension.

How To: Extract the top 5 values from a given list 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 40th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the filter and advanced filter tools to extract the top 5 values from a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Build a mini fridge

In order to build your own mini fridge, you will need the following supplies: a heatsink, a cardboard box, a petier unit, popsicle sticks, standoffs, an AC adapter, scissors, and on/off switch.

How To: Do hip pushups

In this Fitness video tutorial you will learn how to do hip pushups. This one is for advanced body builders and not for beginners. You can use push up stands or use towel to cushion your fists while doing hip push ups. This is not to be done with palms open. Keep your elbows on your sides and you will be pushing from your hips. Stretch your body with the weight on the fists and toes. Keep your torso straight, abs flexed tight, then go down slow and come up slow. The body should be straight. D...

How To: Apply cologne properly

In order to apply cologne properly, you will need to choose the best cologne for you in advance. The cologne will need to mix well with your own natural scent. It is important to avoid overuse. Stick to a three (3) spray rule: never exceed 3 sprays. The distance from the body is important. Therefore, you should spray a distance from your body.

How To: Extract a unique list from a huge data set in MS Excel

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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter tool with criteria to extract a unique list of employees for each department from a huge data set with transactional records.

How To: Do the "air chair" in breakdance

Have you mastered the beginning break dancing tricks and are looking for something a bit harder? Try the "air chair". To do the air chair in breakdance, you'll need to already know how to do a chair, because the air chair is an advanced version of the chair. Get the air chair down with help from an expert.

How To: Group duplicates & extract unique records in MS Excel

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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.

How To: Create a daily Gantt Chart in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this two-part Excel tutorial from ExcelIsFun, the 564th installment in their series of Excel magic tricks, you'll learn how to create a cell chart using conditional formatting with Logical TRUE FALSE formulas to create a Gantt Chart. Functions used include WORKDAY, AND, NOT, NETWORKDAY.

How To: Use VLOOKUP with multiple lookup values in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 488th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP with multiple lookup values. You'll also learn how to add an extra column with a unique identifier to data set using ampersand concatenate.

How To: Find the percentage of total from a DB set in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 480th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate a percentage of total from a database data set when the variable of interest is text (word). This is accomplished with recourse to the COUNTIF, SUM & COUNTA functions.

How To: Summarize data from multiple sheets in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 506th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize data from multiple sheets. For example, you'll see how take checkbook register data from multiple banks accounts and summarize it based on account names.

How To: Make date & time calculations (sans weekends) in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 533rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to calculate the difference between start date/time & end date/time excluding holidays and weekends. This is accomplished with recourse to Excel's NETWORKINGDAYS and MOD functions.

How To: Format dates with the WEEKDAY function in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 534th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OR and WEEKDAY functions to create a logical true/false formula that will automatically apply formatting to dates that are either weekends or holidays.

How To: Create dynamic sub tables in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.

How To: Create an Excel Gantt Chart by conditional formatting

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 477th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt cell chart using conditional formatting. This is accomplished with recourse to the WORKDAY.INTL, AND, NOT & NETWORKDAYS.INT functions.

How To: Extract records that meet certain criteria in Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two conditions (criteria) and list them in order with no extra rows between records as well as how to create a formula to extract part of a table from a larger table based on two criteria. (All of this is accomplished through us...

How To: Configure & check the firewall in Windows 7

In this video, it demonstrate how to check and configure Windows firewall. In order to check to see if firewall is enable or not. You would click on start which locate bottom left corner of the screen. Then you would click on control panel. On this screen you would see an option for firewall, and click on it. When you click on firewall, it will let you view all the description about firewall configuration. There are also many other option which locate on the left hand side. If you are an adva...

How To: Change the color of any object in Photoshop

The video explains how to change the background color of objects using Photoshop in a simple manner. This way is better quick mask mode, because this way is more efficient and more advanced. First you click control G, Image control color and then you take the Image samples. The tutorial shows how the oranges are changed from their original color into a reddish color. Then it shows you how it adjusts the shadows of the oranges and the color of the leafs. The video is quick and it explains full...

How To: Defragment the hard drive in Windows 7

De-fragmenting a hard drive improves the performance of a hard drive and it is recommended to de-fragment your hard drive from time to time as shown in this video. In Windows 7 you can use the Disk De-fragmentation tool. To do this go to the start menu and open the Control Panel. In the right column select the Performance Information and Tools. Now in that window in the left hand column select the Advanced tools option. In that new window scroll down to the Open Disk De-fragmenter link. Click...

How To: Sort table contents in MS Word 2007

This is another HelpVids.com technology video. This video will teach us how to sort table contents in Microsoft Word 2007. The video starts out with a Word 2007 document with a sample table. When you click on the table, you will see the Table Tools tab appear above the ribbon. Click the Table Tools button, then click Layout and finally the Sort Button. The sort dialog box allows you to choose which column to sort by, which direction you would like to sort, and any secondary sorting you would ...

How To: Hack Space Attack with Cheat Engine (01/26/10)

Trevor4Ever595 teaches you how to hack the game Space Attack using Cheat Engine. You start the game, select a level and pause it using P. Open up Cheat Engine, open the process list, select Firefox or whatever internet browser you are using. Then you will want to use the search box to search for the amount of money you have in the game. A lot of values will come up to the left of the search box. Go back to the game, earn more money and then search for that new amount. Cheat Engine will only r...

How To: Play "Band on the Run" by Wings / Paul McCartney

This video is an acoustic guitar lesson from yourguitarsage. In this video, he teaches you how to play the song "Band on the Run" by Wings & Paul McCartney. He begins by playing the song for more advanced players to watch and learn from. Then follows up by showing you which chords you need to know to get started on learning the song, and demonstrates them for users who may be still learning. He then moves on to the progression of the chords through the song, teaching you the intro, verse, bri...