Record Prize Search Results

How To: Monitor Cellular & Wi-Fi Data Speeds from Your Samsung Galaxy Note 2's Status Bar or Notification Tray

Whether you're pressed against your bedroom window, hidden deep inside your linen closet, or lounging on the rooftop, finding that area of maximum Internet speed around your house is usually just trial and error. And when you finally find the sweet spot, apps like Speedtest.net can help you determine how fast your Wi-Fi or cellular connection is overall on your computer or smartphone, so you know your full capabilities. But, if you want to know exactly how fast your Samsung Galaxy Note 2 is u...

How To: Silence the Annoying Camera Shutter Sound on Your Samsung Galaxy S3

SNAP. That's the sound of your Samsung Galaxy S3's camera going off. Not that big of deal, unless you're trying to take some top secret pics or some candid shots of your friends. The shutter sound gives you away, and the next thing you know, you're deleting pictures. On most other smartphones, if the users turns the phone on silent or vibrate, the shutter sound is killed. If that doesn't do the trick, usually muting the shutter sound itself in the settings will do the trick. But for some of y...

How To: Make a scary voice effect on Adobe Audition

In this video we learn how to make a scary voice effect on Adobe Audition. First, record an audio that you made and open up Adobe Audition. From here, open up any other audio that you want to hear for the beat. Then, go to "generate" and then "silence. Put this to 1.5 seconds, then go to the end of your sound and do the same thing. This will make a good effect when you are editing and adding in echo. First, reverse the audio by going to "effects" and then "reverse". This will make it a lot ea...

How To: Break an arm in half & blow up a head in film

In this tutorial, we learn how to break an arm in half & blow up a head in film. To do this, you will need: a tripod, after effects, and actors. First, you need to record a shot with the background and the person whose head you want to blow up. After this, put the clean plate clip over the head of your actor. Now, you will be able to clear out the person and add a mask that is exploding in the frame instead of the head. Add in some fake blood and sound effects, then you will be finished with ...

How To: Get a job as a freelance bounty hunter

To become a bounty hunter, you will want to first check your state's laws to see if you need to be a licensed private investigator. If you live in Florida, South Carolina, Oregon, Wisconsin, or Kentucky, don't even try it--bounty hunting is not allowed! Otherwise, your first step is to find a client who needs a target to be caught. Bail bond agents employ bounty hunters to track down people who have refused to show up to court. Find out who your target is. Assemble a file, look into any recor...

How To: DJ the 1 click flare scratch

In this video, we learn how to DJ the 1 click flare scratch. When you are ready to DJ, you must first make sure you have all the proper equipment. You will want to put an album into the player and then learn the proper technique on how to scratch the music without hurting it. As you do this, you will want to push the album back and fort on the spinning table as you are using the knob on the right hand side to control the level of sound while scratching. Record this to use when switching up mu...

How To: Extract inconsistent name & e-mail data from a one-column list in 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 712th installment in their series of digital spreadsheet magic tricks, you'll learn how to take bad data set up in one column and make a proper table of data for a mail merge as well as how to extract name and e-mail data from a list in one column where records are entered inconsistently.

How To: Use the iMovie app on your iPhone 4G HD

One of the many apps that is currently only available on iPhone 4G HD is iMovie. This app is just like the program on your computer and offers all of the same capabilities. You can even record clips at the last minute with your phone and add them into your Timeline. You can edit a whole movie in the palm of your hand - how cool is that? This app will NOT work on iPhone 3G, 3GS, 2G or iPod Touch, so do not waste your money if you haven't bought the new iPhone 4. Have fun!

How To: Converting a WAV file to an MP3 file using Audacity

This is a quick tutorial on how to convert files with a .wav extension to .mp3 files using the free, open-source audio editor Audacity. It also includes instructions on how to install the LAME MP3 encoder required by Audacity to process the MP3 files. Whether you're new to computer recording, new to the Audacity DAW (digital audio workstation) or just looking to pick up a few new tricks, you're sure to benefit from this video software tutorial. For more information, including detailed, step-b...

How To: Find a weighted average cost ending inventory value

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 and Mr. Excel, the 43rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to calculate weighted average cost ending inventory value from transactional records on 2 different sheets using the COUNTIF, SUMIF and SUMPRODUCT functions.

How To: Use the Advanced Filter tool to extract data in 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 19th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about using Advanced Filter to extract data from an Excel List/Table/Database. See these 7 Advanced Filter examples:

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: Sort and extract by cell color in Microsoft Excel 2007

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 33rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to sort by color in Excel 2007 as well as how to use the copy and paste tools to extract records. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Cunduct a viscous remanent magnetization experiment

In this Education video tutorial you will learn how to conduct a viscous remanent magnetization (VRM) experiment. The purpose of this experiment is to measure the VRM decay vs time. You have to take two Orbo rotor magnets and mount them on a base. Mount two samples of the ferromagnetic tore used in the Orbo motor for the stator coils on a rotating disk. The disk can be rotated by a simple brushless motor. When the ferromagnetic core moves in front of the static magnet, an optical sensor detec...

How To: Create a dynamic range with Excel's OFFSET function

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 219th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic range with the OFFSET function so a macro to create a pivot table will work even when new records are added.

How To: Automatically create pivot tables in Excel 2007

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 218th installment in their series of digital spreadsheet magic tricks, you'll learn how to an Excel 2007 table to create a dynamic range so a macro to create a pivot table will work even when new records are added.

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: Use an advanced filter to extract table data in 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 244th installment in their series of digital spreadsheet magic tricks, you'll learn how to use advanced filtering to extract records from a database (table or list) based on 1 criterion (criteria) and place reesults on a new sheet worksheet.

How To: Dynamically count unique words in a column in MS Excel

New to 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 Excel tutorial from ExcelIsFun, the 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF f...

How To: Pack a backpack for Europe as a male traveler

Backpacking through Europe is a great way to see a new country. This video tutorial shows male travelers what to include in a travel backpack and offers insightful tips on enjoying a trip through Europe. As a general rule, you'll want to reach a balance between light packing and thorough preparedness. Create a packing system based on item demand, dividing items into the bottom, middle, and top sections of your bag. Finally, bring a journal to record important information and for writing down ...

How To: Fold a paper fortune teller

Predicting the future is always cool.. what if you could do it with just a piece of paper? With this tutorial, learn how to fold an origami fortune teller and at least pretend you can predict what will happen! All you need is a single sheet of paper and some pens or markers to record your fortunes and you are on your way. This is a great little thing to make anytime you are bored with friends - work, school, on the bus, anywhere!

How To: Tie a Rorschach knot

If you have ever wondered how to create a Rorschach knot, this tutorial will show you how to do it in no time. A Rorschach knot is indicative to the blotchy silhouette of Rorschach inkblots, which are primarily used during psychological evaluations. A subject's perception of inkblots are recorded using these. This video is going to be walking you through the process of tying your Rorschach knot, as well as the ways in which it needs to be adjusted while being tied. You will also learn a bit m...

How To: Use date fields with FileMaker Pro 10

Whenever deciding to use fields in FileMaker Pro 10, some fields require special handling like the date field. Date field is able to store any date between 1/1/0001 to 12/31/4000. It stores dates in the form of whole numbers. Now, to create a date field, it shows at the bottom of your data and date can be stored. The format of the date can also be changed. One can add dates as well as get the number of days elapsed. This is quite flexible in terms of format as well as keeping records.

How To: Make a good basic Youtube video

Rick teaches the secrets of making a good basic YouTube video in easy steps. Some tips are given below. When creating a YouTube video first assume that your audience has a 10 second attention time. If your introduction takes more than 10 second cut out the part while editing, keep it to 10 seconds only. The second tip is to go for a good lighting, always shoot indoors using your indoor lights itself. If you are using a microphone in the camera to record, always stay very close to the camera. ...

How To: Set up a Canon 7D for slow motion

In this video, learn how to set-up a Canon EOS 7D camera for slow motion. Learn about the settings you need to use to prepare to shoot in one of the high speed modes. To see more of the videos on this subject, check out the parts below, especially on processing the slow motion film.

How To: Use Pyro FX fire and smoke tools in Houdini 10

Want to know how to use the Pyro FX tools in Houdini 10? This masterclass will tell you everything you need to know about using Pyro FX fire and smoke tools in Houdini 10. The discussion covers the addition of exciting new fire and smoke tools. Topics covered include a powerful new fluid up-resing technique, advanced noise and turbulence control, and a highly tweakable custom fire and smoke shader.

How To: Convert VHS tapes to DVD with Roxio Easy VHS to DVD

This easy-to-follow video tutorial walks you through steps of converting old VHS tapes to DVD. Roxio Easy VHS to DVD is a combination of software and hardware that allows you to easily and quickly digitize old analog recordings. You simply attach the included hardware to a free USB 2.0 port on your computer, then capture from virtually any analog video or audio source.

How To: Make your own scratch holograms

Holography is the scattering of light from an object, which is recorded and reconstructed to create the hologram. As the viewer or viewing mechanism moves, the image appears three dimensional. This instructional video shows how to craft 3 dimensional holograms using scratched arcs on a reflective surface. Using a compass, a picture, and Plexiglas, you can create glowing images that shift and turn inside of a 2 dimensional plane. Who would of thought? Now you can make your very own holograms a...

How To: Collect, organize, and visualize data in InspireData

This tutorial on the companion Tech Ease for Mac site shows you how to use Inspiredata to collect, organize, and visualize data using several types of diagrams supported by the program. The movies were recorded on a Mac, but Inspiredata is a cross-platform program so the steps shown should work on the Windows version of the program as well. Inspiredata works like a database system that allows you to add notes and more.

How To: Create concept maps in Inspiration 8

This tutorial on the companion Tech Ease for Mac site shows you how to use Inspiration to create concept maps that help you brainstorm and organize your ideas. The movies were recorded on a Mac, but Inspiration is a cross-platform program so the steps shown should work on the Windows version of the program as well. Watch and learn how to use Inspiration to create concept maps.