Expected Record Search Results

How To: Extract records with an advanced filter in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 95th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the OR, AND, NOT, & COUNTIF functions and Excel's advanced filter tool to extract records from a table of data. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

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: Screen record anything on your desktop with CamStudio

This is a highly informative video tutorial on how to use the software CamStudio to screen record anything on one's desktop. One simply has to open a search engine like Google, type in 'camstudio' and hit the search button. On Google, the official website, camstudio.org, is the first one in the search results. Once that is opened, just scroll down, click on the link camstudio20.exe, and then click 'save file'. Once downloaded, this software can capture all the audio and video activity on the ...

How To: Convert cassette tapes to CDs with Audacity

Dave Andrews gives a simple overview of how to take a cassette tape and convert it to a CD using Audacity. First you will need a cassette tape player, like a boom box, with a microphone jack. Then you'll want to download the free program called Audacity. To begin recording music from the cassette tape simply press the record button on the audacity application while you press the play button on the boom box. You'll want to make sure the audio cable is connected from the boom box to the PC. Fin...

How To: Draw Justin Bieber step-by-step

Justin Bieber is a Canadian pop/R&B sensation. Discovered on YouTube by Scooter Braun, who would later become his manager, Bieber was almost immediately flown out to consult with R&B hit maker Usher after being discovered. Beiber then went on to become one of the youngest artists to ever be signed to reputable record label, Island Records. Besides being known as a singer, Beiber has become quite the heartthrob amongst young tweeny bop girls!

How To: Build a home recording studio

In this series of video clips you’ll learn how to build a music recording studio in your own home. Expert musician and studio engineer Arie Pytel shares tips on the various types of microphones, monitors, headphones, and computer recording software that are available. He takes you step-by-step through the process of connecting the mics, MIDI components and other devices you’ll need to start recording your own music. By following the simple steps in these free videos you can build a home recor...

How To: Become a US citizen with a DUI on record

In this video, we learn how to become a US citizen with a DUI on record. The law says that in order for your to become a citizen, you must show good moral character for five years after your DUI. A DUI is not considered good moral character, but it does not make you ineligible. If you are under probation, then you will not be able to apply to be a US citizen. If you are NOT on probation, then you will have better chances of getting your citizenship. Good luck on your approval and make sure yo...

How To: Use guitar, bass amp, & speaker emulation in Line 6

In this tutorial, we learn how to use guitar, bass amp, & speaker emulation in Line 6. First, plug in your guitar, create an audio track, and add a line 6 amp. The line 6 amp comes with 3 amplifiers. While the bass amp lets you choose between two. When you change the amp, the compute will change cabinets to go with it in the program. To load a combinatory pre-set, click the folder to open up the path browser. The record sound bank includes a lot of sound bank options, so choose the ones that ...

How To: Deal with a traffic ticket & not raise your insurance

In this video tutorial, viewers learn how to deal with a traffic ticket. When you pay for a ticket, don't just ignore it because there is always a hidden cost to a speeding ticket. Speeding tickets may cause insurance rates to go up. To avoid the insurance penalty, users should either go to court or traffic school. Going to traffic school to take the ticket off of your driving record. Another method is to cut a deal with the prosecutor. The key is to keep the points off your record and not al...

How To: Add FX with ScreenDraw during recording in Camtasia 7

A really cool feature in Camtasia 7 is the ability to draw directly on the screen during a recording. This is helpful if you want to circle something onscreen, or if you want to highlight some text during your screencast. There's plenty of other options also in the ScreenDraw feature. To learn out how to use it, watch this video, which will show you all the things you can do.

How To: Resize multiple images in Adobe Photoshop

Here is a simple technique to resize multiple pictures in Photoshop by creating an action, to adjust the image size. The only requirement is for the pictures to more or less the same size. First we go to windows and select action then we open up an image to determine the appropriate size that we require. Then click on the create new action and, give it a name then hit record now go to image the image size resize the image and then save and hit ok .You can see that its still recording your act...

How To: Extract records from non-blank fields 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 152nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter and a TRUE/FALSE formula in a column to extract records that contain a non-blank value in a specified field. (column).

How To: Get the T-Pain effect in FL Studio 8

In this how-to video, you will learn how to get the T-Pain effect with Fruity Loops Studio 8. First, open the program. Insert the sound by clicking on the sampler and opening a recording. Next, click the arrow and select assign a mixer track. Select GSnap for the T-Pain effect. Change the settings, which will allow you to get this particular effect. You can also choose the Autotune effect to get this sound as well. Select this effect and set the effect up. You can save the settings with a pre...

How To: Make stick figure animations using Magix software

Make stick figure animations using Magix softwareFirst, record yourself with a webcam using Magix music maker. This software is used to record, save and edit the entire video. A trial can be downloaded or it can be purchased. Second, edit the video. Third, save the edited video as and AVI file. Open the AVI file with Adobe image ready. This is only available in older versions of Adobe Photoshop. Next, draw stick figures into frames. Add blood. Export each frame as a gif file into a new folder...

How To: Make animated pet dialogue using Crazy Talk software

In this video, we learn how to make an animated dialogue in CrazyTalk6. Once you are in CrazyTalk6, face fit your character then click on "script". You can re-name your characters as you wish. Once you have their names picked out, you can create a script for them. Press the red record button and record what you want the character to say and press "load". Then, choose what you want the facial features to look like. Load another script for the other animal and once you press play, you can see b...

How To: Sync double system sound on Sony Vegas

This video shows the method to sync sound using Sony Vegas. This is important in case of double system sound when audio is recorded separate from the picture. The first step involves opening up the poorer source of audio like the audio from the built in microphone in the laptop. Now open the good quality audio like the one from a camcorder just below the first one. Align the two audio using a reference mark. In the given video, it is the clapping of hands recorded on both audio. So, the spike...

How To: Improve video quality when recording with Camtasia

HelpTube1 teaches you how to improve video quality when recording with Camtasia. The reason some videos don't have the HD version is that it takes 30-40 minutes for YouTube to verify whether the video is in high definition or not. In Camtasia 5 there is a Tools tab at the top of the program window. Click on that and then go to Capture. Check the box that says Save as AVI. Then go to Video, change Manual and change the frame rate to 80. Then click Ok and you will get these options every time. ...

How To: DJ the butterfly scratch

This video is made by a "DJ" with two turntables and a variety of musical equipment. He is showing how to do the "butterfly scratch" which is a type of scratch that DJ doES on vinyl records to create certain sounds while mixing records together. It is often heard in hip hop songs. There are diagrams in the video window showing musical notes and variations. The instructor goes through the entire process of how to do the butterfly scratch, while showing different tips to maximize your performan...

How To: Save music from MySpace or any other website

This video shows you how to easily save music from MySpace or any other website. The first thing you have to do is open your web browser and surf to MySpace. Then, go to MySpace Music. Search for your favorite or desired band in the upper-right side. For the following step, you will need a program called Streaming Audio Recorder, that can be found on Google. Open the program, go to Settings and choose what input method you like and click OK. Then, hit the Record button, go to MySpace and pres...

How To: Set-up side chain compression in Reason Record

Reason Record can be a tough program to master, but with this easy to follow guide you'll be mixing like a pro in no time flat. Set up what's considered a "side chain compression" with this step by step demonstration and add a "pumping" sound to the music for great dance beats. Mix your own music and become the life of the party as this tutorial shows you what dials to adjust on the program and what wires to move to create this amazing sound. It's simple and easy to follow, so with just a few...

How To: Set-up Record in Reason for de-essing

This how-to video shows you how to reduce the "s" sound in a certain recording software program. They play a line a music where the singer emphasizes on her "s" sounds. The tutorial shows you how to reduce the "s" sound so that it clear and sharp. It also shows you how to change the frequency and the compression of the "s" sounds. The video explained that if you make the compression too high, than the "s" sounds will sound like a lisp.

How To: Cue your vinyl records on a turntable

Check out this instructional turntable video to learn how to cue your vinyl records. It's not scratching, but it is cueing. This takes some skill because you want to align two songs perfectly in sync. Remember, this only works if the stop and start time of your platter are the same! It does not matter if your start or stop time is 1 hour, 34 minutes and 48 seconds! Use this method if you need a clean, fast and easy way of starting a vinyl in sync. This video tutorial is great for DJs and anyo...

How To: Edit your podcast using Audacity

After you have your audio podcast recorded or imported into Audacity, you can enhance it by editing out mistakes, shortening long silences, even chopping it into several sections to make multiple shorter episodes rather than one long show. Learn how in this tutorial. 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 ...

How To: Use the scribble when scratching turntables

This instructional turntable video shows you how to use the scribble when scratching turntables. Basically, the scribble entails putting the cross fader on and leaving it on. Then scratch a very small amount of the record as fast as possible. Lift your arm up high and force a spasm-like movement down it in order to move the record a short distance quickly. Show off your scribbling skills at the next DJ event.