Return Policies Search Results

How To: Build and use array formulas 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've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.

How To: Work with Microsoft Excel's LOOKUP function

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 42nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn ten tricks involving the LOOKUP function:

How To: Pull an Excel cell value from the first non-blank row

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 365th installment in their series of digital spreadsheet magic tricks, you'll learn how to use an amazing non-array formula to return the cell content from the first non-blank cell in a specified row.

How To: Use Excel's VLOOKUP with dates to retrieve the season

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 353rd installment in their series of digital spreadsheet magic tricks, you'll learn how to make date calculations with Excel's VLOOKUP formula (e.g., finding approximate matches and returning a season for a date within a given range).

How To: Solve the blinking "FEE" error message on a Nikon DSLR

In this video, it is demonstrated how to get rid of a "FEE" error message on a Nikon DSLR camera. The solution is fairly simple and quick to do. First you will want to turn your camera on to where you see the "FEE" error message on the LCD screen. Next, you will set the camera's aperture ring to the highest number available. After this, the last step is to lock the aperture ring by using the switch. After doing this step, your camera should return back to normal working order and the "FEE" er...

How To: Install any app for free using Installous on an iPhone

In this video tutorial, viewers learn how to install the Installous application for the iPhone or iPod Touch. Users will need to have their iPod device jailbroken before installing. Begin by opening Cydia and select manage. Click sources and select edit. Add this source: Select your new source (Hackulo.us) and install AppSync for your device's firmware, Then install Installous. Return to your home screen and run your new application (Installous. Now users are able ...

How To: Bake molten chocolate cake

To begin making a molten chocolate cake, a stick of butter and ten ounces of semi-sweet chocolate chips are added to a double boiler. Meanwhile in a stand mixer, four whole eggs plus one yolk are whisked together with one cup of sugar until it triples in volume. As this mixes, the insides of eight ramekins are lightly buttered and sugared to ensure the cakes do not stick. Now turn off the mixer and return to the double boiler where the chocolate should be melted into a smooth consistency. Add...

How To: Put together small Merengue combinations

Learn how to put together a small Merengue dance combination & get your Merengue on with help from this dance tutorial! When putting together combinations, it's important to start with bending one's knees & extending the leg and foot before returning to the starting position.

How To: Cast on using a circular loom

Learn how to cast on to knit using a circular loom. Start at the beginning with an empty loom and wrap your yarn around the beginning peg. Working to the right, wrap the yarn behind each peg, and around in a clockwise fashion. Do the same on the next peg, until you have returned to the beginning again. Repeat this process for the second row. Take your tool, which will come with the loom, and lift the bottom stitch over the top stitch and off the peg. Work all the way around the loom to the be...

How To: Add a contact to the address book of a Nokia N97

Here you will see how to add a contact to the address book of a Nokia N97. Follow these steps to add a contact to your Nokia M97's address book: From the home screen, tap the "Contacts" icon and then tap "Add New Contact". Enter in the contact information and tap "Done". Tap "Exit" to return to the home screen. To set a contact as one of your favorite contacts, tap "Add to Favorites", and select the contact you wish to add as a favorite. Tap "OK" You can also do things such as add a called ID...

How To: Create super saturated color images in Photoshop

This Adobe Photoshop CS3 tutorial teaches you how perform slight photo retouching to supersaturate a photo without the distortion and bleeding. This adds a slight but noticeable saturated look of a photo which enhances the color quality. First the graphic artist adjusts the saturation. Then he creates a version copy using the lab mode versus the RGB mode. He then adjusts the contrast of the Lab mode image. Once you return the photo back to the RGB mode, you can continue altering the photo.

How To: Understand compound & continuous interest

In this video the instructor talks about compound and continuous interest formula calculations. You need to understand the concepts of simple and compound interest. Only then you can understand what the bank is doing to your money which are in your bank account. Simple interest is a method where when returning a borrowed sum to some one you pay additional price for using the money all this time. Compound interest is a similar concept where you pay interest on the original sum borrowed, and al...

How To: Do back compound exercises

Work out multiple back muscles with compound exercises. Learn tips and techniques for working out the chest, back, shoulders, and arms in this free weightlifting video. Take action: grip handles on the outsides, cross legs, bring chin to top of the bar, and return slowly, but don't swing legs. Lance, the instructor in this how-to video, is certified personal trainer through American Fitness Association of America. He graduated from UNC with a biology degree and currently works for a gym. He s...

How To: Kiss with Confidence and Passion

Learn how to kiss someone in a way that guarantees they'll come back for more. If they return with some tongue action your know you are on the right path. So watch this how to video and learn how to kiss with confidence and passion every time. If you aren't single then maybe these kissing tips will spice up the relationship. Work on this and you'll soon be able to perform a torrid kiss!

How To: Use Cheat Engine to hack the game Perfect World International

Tired of grinding out endless, boring quests for meager returns when you're playing Perfect World International? Want to rocket to high level and immense piles of treasure immediately? Cheat Engine is your answer! This free game hacking program frees you from having to hunt for cheat codes or exploit glitches to get ahead in PWI. Just follow along with this easy and quick hacking tutorial, which shows you how to use this program to change many of the values of your character and in the game.

How To: Plan bathroom renovations on a budget

Times are tight, but no one deserves to stare at an old, fugly bathroom day after day. If you simply can't stand the hot pink paint the previous owners left on the walls anymore or your linoleum floor is falling apart, check out this video to learn how to plan bathroom renovations wisely and on a budget.

How To: Wrap your hands for boxing and kickboxing

The first step to wrap your hands for boxing and kick boxing is to place the hoop at the end of the wrap around your thumb. After the hoop is around the thumb the fabric is wrapped around the hand four times slowly moving towards the wrist. The fabric is then tied in an X formation around the thumb and returning back down to the base of the wrist. The fabric is then wrapped around each knuckle until all of the fingers have been wrapped correctly. The last step involved is wrapping the fabric ...

How To: Boot into safe mode in Windows XP operating system

This video will show you how to boot in safe mode on Windows XP. Just follow these instructions from the video. Now go to Start -> Run and type in msconfig. and click OK. Now select the BOOT.INI tab and select /SAFEBOOT, click apply and close and then it will prompt you to restart. After you restart a message will appear. Click Yes and you will notice that your screen resolution is small and you will have the classic theme. To return to normal mode just repeat the steps and uncheck the BOOT.I...

How To: Perform knee replacement surgery

In this video we learn how to perform knee replacement surgery. The knee joint is accessed with an incision. Then, a number of different surgical tools will be used to perform the procedure. The part of the knee joint is removed first with surgical saws. Then, the artificial joint is put back into the area. Once this part is secured with screws, an insert will be joined in with it to keep it in place. The artificial joint is checked for the last time, then sutures are used to closed the joint...

How To: Meditate & achieve deep relaxation & awareness

In this video we learn how to meditate & achieve deep relaxation & awareness. Imagine you are on the beach and completely alone, nobody is around for a while. It's nice weather outside and you can hear the waves rolling in. The sun is going down and you are just focusing on your breathing. Take in four very deep breaths and with each one you will get more and more relaxed. Imagine your lungs filling up with air, clean and crisp air. Let your stresses go and then return your breathing to norma...

How To: Strategically buy stocks in a bear market

In this video we learn how to strategically buy stocks in a bear market. In the last bear market, we were able to buy high quality stocks for a great price. These are great times for value investors to purchase cheap stocks and see their share prices go up as the economy becomes better. You also want the company to rise and become more popular so you are getting more of a return after the stocks that you have bough in the first place. When you do this, you can reinvest after this and get a lo...

How To: Perform boleos and sacadas in tango

In this video, we learn how to perform boleos and sacadas in tango. When you are learning this song, you need to first make sure you are following along to the beat. Work the combination of both of these dances, they go very well together. They will usually be first the boleo which will transition into the five step sacada. Do a good and strong ocho using your ocho factory and make sure to embrace your steps. Work the timing of the ocho into the point of no return and make sure you are standi...

How To: Do a side by side video effect in Sony Vegas

In this tutorial, we learn how to do a side by side video effect in Sony Vegas. First, open up Sony Vegas and open up a couple of clips to your time line. After this, make the two clips the same length by pressing down on the control key and moving them with the mouse. From here, return the videos to the start and then right click the track motion button. Reduce the width and the height to half of what they were before. Then, move the X position of one to -180 and the other to 180. Now both w...

How To: Eject a CD from a Mac computer through a terminal

In this tutorial, we learn how to eject a CD from a Mac computer through a terminal. Now, go to the finder and click on the applications folder. Scroll down to the bottom and open up utilities, then the terminal. Once you are inside this new screen, type in "drutil tray eject". Now, when you press return the icons will disappear and your disc will pop out of your computer. This will work most of the time and help your computer eject the CD without you having to restart your computer and losin...

How To: Apply provisional cast-ons to your knitting project

Hard edged cast-ons in knitting are difficult to remove, so it's important to also know how to complete loose cast-ons that easily remove themselves from your knitting project. Loose cast-ons allow you to hold a knit in place so you can return to it later (so, for instance, you want to knit the sleeve of a sweater first and want the chest area, which you are currently knitting, to stay in place).

How To: Open .zip files

In this tutorial, we learn how to open .zip files. First, go to the start menu and search for "regedit.exe", then press enter. After this, a new window will pop up, open the computer icon, then open "current user", "software", "Microsoft", "Windows", then "current version". Now, click on the explorer folder, then the "file exts" folder and ".zip" folder. You should now see three different folders, right click on "user choice", then delete it. Exit this program, and now return to your zip fold...

How To: Get install0us v2.5 for iPod Touch or iPhone

This video tutorial is in the Electronics category which will show you how to get install0us v2.5 for iPod Touch or iPhone. Click on Cydia and let it open up. Once it is open, click on manage > sources > hackulo.us > installous > modify > remove. Then go back to sources > edit > add. In the URL box, type in cydia.install0us.com and then click 'add source'. Then click return to Cydia and click 'done'. Then go back to manage > sources > install0us repository and here you will see the install0us...

How To: Do a yoga sequence to center the mind and regain focus

In this video tutorial, viewers learn how to do a mind centering yoga sequence. Begin by sitting back on your heels and brings your hands together in front of your chest. Inhale as you bring the arms out and above your head. Exhale as you place the right hand on the floor and extend the left foot out. Then as you inhale, reach upward with your left hand. Now exhale and return to the starting position. Do this on the opposite side as well. This video will benefit those viewers who are interest...

How To: Do a yoga arm balance crow pose

In this video tutorial, viewers learn how to do a arm balance crow yoga pose. Begin by twisting your wrist back to face your fingers to your knees. Feel a deep stretch and take about 5-8 deep breathes. Then go into an easy forward bend, with your hip-width apart and your knees bent. Place your hands flat onto the floor and tuck your chin into your chest. In that position, move forward by looking up and going onto the balls of your feet. Then return to the starting position. This video will be...

How To: Do a yoga boat pose with a twist for power

In this tutorial, Dina Prioste shows us how to do a yoga boat pose with a twist for power. First, begin in a boat pose raising your legs up and facing forward. Interlace your hands together and inhale. Exhale and twist to the left and right side while pushing your legs forward and back. Next, place your hands on the floor and fall into a reverse tabletop position. Inhale and exhale several times in this position, then return to the boat twists and do quicker for twelve times each side. Rememb...

How To: Sort data with sorting functions 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 16th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to sort data in MS Excel. Specifically, you'll see the following:

How To: Do normal probability calculations on a calculator

Probability computation is a complex process and even using a calculator can be difficult. But normal probability calculations can be performed quickly with the help of calculator once you know how to use it. So when you have to calculate a probability from a normal distribution you can use the functions on your scientific calculator. You can use the normal CDF function from you calculator to compute the area under a normal curve. The function requires lower band and upper band values, the me...