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 264th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a recorded macro to take a data set and add a new column, concatenate data from 3 columns, and delete unwanted columns.
In this video, viewers will be watching the performance of the "whispers" card trick. The magician begins by shuffling the deck and asks the spectator to select 3 cards. Then they are laid face down and the magician takes all 4 of the queens out of the deck. He uses the queens as a guide and is able to tell the spectator the 3 faced down cards. Then he waves a queen over the 3 cards and places it down. The cards in his hands become the selection and the face down cards become the 4 aces. This...
Freelance web developer and Internet marketer David Frosdick offers some tips and tricks in this video tutorial on how to get the best Camtasia settings for YouTube widescreen.
Have you been trying to figure out a way to record your Xbox 360 and broadcast it into Final Cut Pro? Using the DV Passthrough method, you can take an analog signal, pass it through your camcorder, and send it to Final Cut Pro.
Hello ladies and gentlemen, Greg Solomon is here today in this video tutorial to teach you how to perform the "Best Card Trick in the World". He will show for you, and perform for you what many have referred to as the best card trick there is. See the performance of this illusion! Greg will reveal to you, and explain to you how the color change card illusion is performed.
Hello ladies and gentlemen, Greg Solomon is here today in this video tutorial to teach you how to perform the "Best Coin Trick in the World". He will show for you, and perform for you what many have referred to as the best coin trick there is. Immediately following the performance of this illusion, Greg will reveal to you, and explain to you how the coin illusion is performed.
Learn how to play the Manhattan Timbrel percussion instrument. This is a step by step that also includes parts with music and non-music instruction. The timbrel is used in military performances.
Check out this video tutorial to show you how to use a Marantz digital audio recorder. This video was made by the equipment room at CUNY Journalism School in New York.
You don't need a band to play and record your own songs. With Garageband and your Mac, you'll be making music right away.
Use old vinyl plates to craft this retro DVD or CD case rack.
Watch this video to learn how to make puppets from stuffed toys. In this video, Barbara Dewey converts Pink Panther, Bugs Bunny and several others into ventriloquist figures. Barbara also gives some tips for caring for your puppets and some ideas for modifying them. Stay tuned for the amazing performance in the last video of this three part video series!
Listen to conversations over long distances with a homemade laser listening device. All you'll need is a laser pointer, tripod, old pair of headphones, photocell, a recording device, and the step-by-step instructions in this how-to video. The creator of this video tutorial does not mention the need for sophisticated software. But the principle is quite sound. If you can figure it out, you can eavesdrop and spy on whoever.
Here Christopher Walken shows us how to roast a chicken with pears. It is a simple recipe, recorded supposedly as an audition tape for Food Network. We cannot confirm.
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.
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.
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 ...
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...
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!
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...
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 ...
In this video tutorial, you'll learn how to increase your Windows performance by adjusting your virtual memory settings. This tweak applies to computers running Windows Vista or XP. If you are running a lot of applications, especially large resource hogs that eat huge amount of memory, your system may become unstable or even crash.
There is a built-in tool in Windows Vista that allows you to clean up your hard drive and system, and it could be found by simply searching for "disk cleanup" in the start menu. But this provides a really basic cleanup, so for all of you who want something more extensive, there are free alternatives available on the web. Once is called CCleaner, which is a lot better. It's the number-one tool for cleaning your Windows PC.
In this clip, you'll learn how to utilize the WinMend Registry Defrag app to defragment and tidy up your Windows Registry, improving system performance. 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 five minutes. For more information, including step-by-step instructions, take a look.
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...
You don't need to be a professional sports coach to get your child geared up for basketball season. There's some simple basketball drills anyone can learn and teach to children playing basketball. Even if your child is prodigy or doesn't plan on playing for the school team, these are still worthwhile drills to use to help better your child's performance on the basketball court.
Pitching might not come natural to every baseball pitcher. That's why it's important to hone and develop a young pitcher's skills and performance while they're young, because once they learn the fundamentals of pitching great fastballs or curveballs, they'll have greater success as they mature into an adult athlete. In this video, join Jonathan Hurst, the pitching coach of the Savannah Sand Gnats, about coaching young players and developing their pitching talents.
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.
In this how to video, you will learn how to set up a tone arm on a record player. First, you will notice the counter weight at the other end of the tone arm. Remove this first. Set the dial set to zero and have the lever pushed forward. Slide it on and lift the arm off of its rest. Play around with it until the arm floats. The next thing to do is to balance the cartridge. Many cartridges have different weight requirements. If you do not have the weight set up behind the arm, you cannot use di...
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...
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).
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...
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...
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...
Good Housekeeping is known for its helpful tips for women. It brings useful tips for women who are dieting. In the following some tips are given to loose weight:
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...
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. ...
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...
In this tutorial, learn how to increase the speed of your computer by incresing the virtual memory stored on your PC. Virtual memory is simulated by RAM and at times, when the RAM has been used up by your computer, your computer will slow. In this video, learn how to increase you virtual memory, which is essentially increasing the empty space reserved for your RAM.
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...
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.
