Want to play Burt Bacharach and Hal David's "Close to You" on your ukulele? Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing this ...
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 650th installment in their series of digital spreadsheet magic tricks, you'll learn see how to take all records from a data set and place them into one column using the INDEX, INT, ROWS and MOD functions.
If you want to have any kind of impact in the discussion of video games online (and that is one big and jaded discussion) it will behoove you to be able to capture images of the games you're playing, be they console or PC. It's easy for the PC, but many people have no idea how to capture screenshots or videos of their console gameplay that they can share later on their computer. This video is here to clear up that confusion, showing you how to install a PCI TV card in your PC that will allow ...
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 631st installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting to a transactional record when the date is 90 days past due using the TODAY function and mixed cell references in a logical TRUE-FALSE formula.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 56th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use an array formula and the COUNTIF function to count unique records that are greater than a given hurdle (in this case, $30). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Want to play "My Blue Heaven" by Walter Donaldson and George A. Whiting on your ukulele? Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started ...
Want to play the Beatles' "Mother Nature's Son" on your ukulele? Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing "Mother Nature's...
In this video tutorial from Get Connected TV, hosts AJ Vickery and Mike Agerbo, will show you how to extend Widows Media Center to your XBox 360 using Windows 7. This video assumes that your XBox is already connected to your home network, so you may want to be sure to do that first. With this configuration, you will be able to not only watch movies, but view, pause and record TV on your personal computer, as well. You will learn how to access the Media Center section of your XBox, and get the...
MAKE and Kipkay brings the do-it-yourself mindset to all the technology in your life. Make Magazine celebrates your right to tweak, hack, and bend any technology to your own will.
John Park from Make Magazine hacks a Nintendo Wii controller and turns it into a personal flight recorder that can sense and measure the stomach-churning G forces of roller coasters and other high-speed, high-risk activities.
How to easily fix the missing tags in your MP3 collection using free software called Fixtunes. The tags on an MP3 file identify things like the Song Title, Recording Artist, Album Name, Genre, Track Number, etc. When you buy songs from places like the iTunes Music Store or MP3.com these tags are complete. Some of the songs in your iTunes library may have incomplete tags. This is how you fix them.
In this how-to video, you will learn how to use a microphone in order to rap or record speech. A mic can be used for instruments, vocals, and other things. There is a proper way to hold the microphone. First, do not the hold the mic with your hand over the mouth piece. Do not hold it up too close or too far. Holding it too far will cause an echo. Holding the microphone too close will muffle the sound. Keep it about an inch or more away. Make sure you hold it at an angle to hit the soft spot o...
How do I dub from my VCR to the recorder? Check out this video tutorial on how to dub from a VCR to a Panasonic DMR-ES15 (ES25) DVD Recorder. This Panasonic DMR-ES15 (ES25) DVD Recorder is easy to operate and great to record with.
How do I dub from my VCR to the recorder? Check out this video tutorial on how to dub from a VCR to a Panasonic DMR-EH55 DVD Recorder. This Panasonic DMR-EH55 DVD Recorder is easy to operate and great to record with.
If you've never done it before, making a podcast can be tricky, with multiple programs to use and multiple file types to deal with. But, this video series helps you through the complete process of creating a podcast, everything including recording, editing, images, exporting, converting, uploading, and finally… sharing. Watch this whole series to learn how to make podcasts using GarageBand, iWeb, iTunes, and Fugu.
MY IDEA FOR YOU GUYS IS TO RECREATE THE SCENE IN MATRIX WHERE AGENT SMITH AND NEO HAVE A BUST UP AND ICONICLY LAUNCH TOWARDS EACH OTHER IN SLOW MO SHOOTING AT EACH OTHER THEN IT GOES INTO BULLET TIME AND PANS ROUND. YOU GUYS COULD COME UP WITH A WAY OF LAUNCHING EACH OTHER TOWARDS EACH OTHER WITH PAINTBALL GUNS AND A LOAD OF CAMERAS SET UP IN A CIRCLE AROUND YOU RECORD IT. I HAVE FAITH THAT YOU GUYS CAN DO THIS AND IT WILL BE EPIC.
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...
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 ...
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...
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...
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.
Follow your dreams. That's the best advice anyone can give you, and Chief Ninja Padraig Hyland tells you just that with this motivational video.
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!
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...
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.
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:
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.
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.
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...
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.
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.
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.
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.
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...
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 ...
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!
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...
Looking for a new song to play on your acoustic guitar? Justin Sandercoe's instrumental ballad, "From Katie's Window," might be just the ticket. Learn how to play it in this exhaustively thorough four-part guitar lesson.
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.
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. ...
