The autofocus functions showing up on new DSLR cameras are quite useful if you know how to use them. The Nikon D3100 is no exception, and this video will teach you about the different auto-focus modes and which ones you should use to make your pictures look as good as easily as possible.
The flash is one of the most useful camera accessories you can have, but they also have a tendency to ruin perfectly good pictures, especially with digital cameras. This video will show you how to take shots with great depth and dimension even with a digital camera and flash by setting the flash length manually.
Time lapse videos can be used to distort a sense of time around your subject, which makes them very useful special effects in documentaries. By using time lapse, you can show the transition from sunrise to sunset in just a few seconds, or slow down a drop of water hitting a table. The tools in Adobe Premiere can be used to create this effect, and the following tutorial shows you how to take your raw footage and turn it into a time lapse shot.
Three disparate but useful indie filmmaking techniques, one video. One stop shopping just in time for the holidays. This video will teach you how to make day into night with editing, normal things giant with filming, and make actors fall from high places without hurting themselves unduly.
The shrink ray as always been one of the oddest and least-useful sci-fi guns, but alien invaders seem to love them and so we'll keep seeing them. If you want to use a shrink ray in a film you're working on, watch this video. It will teach you how to first make a generic ray / laser gun, and then how to make an object shrink in After Effects.
Now here's a useful trick! Ever had to make an application window smaller just to drag something to your Windows desktop? No more! In Windows 7, you can drag files directly to the Show Desktop button in the Windows taskbar.
Magic tricks that will work well in crowd on drunk people are some of the most useful ones you can learn, and this trick is that in spades. It's called Healed n' Sealed, requires the construction of a trick can, and you will learn how to do it in this video.
Hardened steel is a very useful material, but working with it is tough because it is nearly impossible to cut with simple tools. What you really need is an angle grinder, and this video will show you how to use one of the powerful power tools to cut a hardened steel ring.
The continuity test is one of the least well-known but useful functions on a multi-meter. It allow you to determine whether a fuse works by touching the contacts to it, which allows you to diagnose all sorts of electrical problems. This video will show you how continuity tests work and give you some examples of using them to find problems in household devices like a lawnmower.
Angle grinders are very powerful and useful tools, but like many such power tools they are extremely dangerous if you don't know how to use them. This video goes over a variety of must-know safety precautions that you should take before using an angle grinder to grind for your own construction projects. It covers proper eyewear, fire protection, and setting up the device for use.
While Google Maps is useful for finding addresses and calculating directions, it's not, strictly speaking, very fun. Unless, of course, you know how to hack it. This hacker's how-to from Tekzilla will show you how to access a number of Easter eggs and hidden features like a geography quiz game.
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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to allocate $950 across 7 days including the extra penny with a single formula.
Need an introduction to Excel's useful TODAY & NOW time functions? You're in luck as this clip provides just that. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2007 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.
Learn how to use the ever-useful Quick Properties tool in AutoCad 2011. This clip will teach you everything you'll need to know. Whether you're new to Autodesk's popular 3D drafting application or a seasoned professional just looking to better acquaint yourself with the newest iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
If you're going to know how any phrase in a foreign language, "Do you know English?" is a useful one. In this free video language lesson, you'll learn how to ask someone if they speak English in Spanish: "¿Habla inglés?" For more information, including an example of the proper pronunciation, watch this free video Spanish lesson.
Round lashing refers to a knot that you can use to hold two poles together easily and securely. This is useful for constructing a flagpole, as the creators of the video did here and building a-frames. This video will show you how to use round lashing quickly and easily for your next outdoor project.
X-Ray vision is one of the most memorable of Superman's many distinctive powers (he was so unfairly strong wasn't he?) and one that would be very useful to modern spies and voyeurs. This video will show you how to create an X-Ray vision special effect for your movie using After Effects. Whether your characters are looking into a girls' locker room or a secret Soviet meeting, the effect at least will be very cool.
Virtual cameras enable you to add all sorts of cool effects to your animations by making it seem like they were filmed with a camera that could move and focus. This video will show you where to acquire and how to use the vcam software plugin for Flash CS4 to create all of the aforementioned effects and more! This can also be useful for video games.
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 618th installment in their series of digital spreadsheet magic tricks, you'll learn about a handy key command that will allow you to enter both today's time and date into a single Excel cell.
Though the Google home page may appear simple, its search tool is anything but. This quick clip from the folks at CNET TV demonstrates a number of the search engine's most obscure and most useful features, all certain to help you to find your desired information more quickly. For specifics, and to get started using these great search hacks yourself, give this guide a look.
Know your knots! Learn how to tie a twisted dropper loop knot with this free video tutorial. The twisted dropper loop is great for fishing line and requires about 10 twists to get the right feel. For an easy-to-follow, step-by-step overview of how to tie this useful fisherman's knot in a minute's time or less, watch this free video knot tyer's guide.
Know your knots! With this free video tutorial, you'll learn how to tie a round-turn two half-hitch knot. The two half-hitch knot with a round turn is a great hitch knot that has a sliding quality to it that still won't release. For an easy-to-follow, step-by-step overview of how to tie this useful fisherman's knot in a minute's time or less, watch this free video knot tyer's guide.
Learn how to tie a release-hitch knot! The release hitch knot was developed to overcome the shortcomings of the Prusik knot, making it perfect for rock and mountain climbers. For an easy-to-follow, step-by-step overview of how to tie this useful climber's knot in a minute's time or less, watch this free video knot tyer's guide.
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 6th installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting to a whole row of data in an Excel sheet.
In this quick video, learn how to import music to iTunes from elsewhere on your computer, and then add that music to your iPod or MP3 player. This tutorial contains very useful information that will allow you to take full advantage of your iPod and also help to keep all of your tunes in one place.
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 288th installment in their series of digital spreadsheet magic tricks, you'll learn how to count the number of characters or numbers in a text string with a formula that is case sensitive.
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 292nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first and last names from an Excel spreadsheet and rearrange them using a formula.
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 241st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a data validation drop-down cell list where the list shrinks as you select values.
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 230th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the Excel List Table feature to make a dynamic stock price line chart.
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.
Its a flavor explosion! Take some cilantro, add in a little Calcium Chloride and Sodium Alginate, and give some crab cakes a new twist! The pearl is one of the most useful treats of Molecular Gastronomy. Learn how to make corn cake with bbq crab and cilantro pearls.
Use erasers to make a crafty casing that'll hide and protect your thumb drive. You will need two beveled pink erasers, a cutting board, a large chef's knife, a 1 gig USB flash drive, a pencil, a rotary tool, and a utility knife. This pink eraser USB drive is cute & useful.
This how-to video provides very detailed, useful information on propagation. Watch this instructional video for tips on grafting a watermelon plant. For horticulture and how-to video enthusiasts.
When creating an aesthetically pleasing image, sometimes more is more. Blending images together and blurring the edges is a great method for creating desktops featuring multiple photos of hottie Sam Worthington, or simply for creating a pretty website background.
In this episode you will learn useful relationship phrases and phrasal verbs (such as move in, break up, and slow down)in the English language. This video is great for advanced, intermediate, and beginner learning to speak the English as a second language (ESL).
If you ran out of clips to close all those half-eaten bags of chips leftover from the weekend barbecue, this video demonstrates super-easy and useful chip-clip-no-more bag fold.
So much information exists online that it's easy to get lost in data while researching. Understanding the bigger picture can take a lot of time and energy, but narrowing the question to one that's easy to answer is the first step of any investigation. That's why analysts use open-source intelligence (OSINT) tools like Maltego — to help refine raw data into a complete understanding of a situation.
With hordes of games populating the Google Play Store, it's grown increasingly difficult to find trending, non-gaming apps that you might find useful on your Android device. There are a few in the Top Charts pages, peppered in among the various games you'll never play, but other than that you'll have to do some serious searching to discover any new apps.
A messaging app that blows your mind doesn't come along very often. Yeah, there's WhatsApp and Facebook Messenger, which are both good for what they are (web-based messaging platforms), but when it comes to interesting or unique features, they're somewhat lacking.
This video will show you 4 useful tricks related to you windows7 operating system. This video includes areas like speedier mouse, preventing display rotation, restore previous versions and monitoring of audio recording. Watch the video and follow these computer support tips.
