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.
Learn how to set up a basic home recording studio. Teaches about different types of microphones and other equipment.
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...
You've boxed up and shipped all your other possessions for the big move and all you're left with is the little issue of how your getting your car there. There are companies out there that will ship your car to you, just make sure your car is prepped for the journey.
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 ...
Missing out on a good night’s sleep can leave your feeling groggy and unproductive. Make sure your always get the z’s you need by creating a good sleeping environment, avoiding stimulants and getting enough exercise.
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. ...
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.
Access auto tune for your Audacity recording software with help from this video tutorial. Step-by-step instructions are gone over, and the following links will be needed:
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.
Get creative with an old disposable camera by setting up an aerial photography rig using akite! Get a new perspective by taking pictures from a bird's eye view.
See how to repair invalid DVD navigation and structure with FixVTS. With FixVTS, you can easily repair the internal structure of a DVD. This is good for DVD menu correction, invalid DVD file structure and invalid navigation error messages.
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.
