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...
If you frequently use Camtasia software for Windows this is a great video for you! Camtasia is a screen video software program made for both Windows and Mac This video shows step-by-step how to upload a photo and create a moving profile image. It shows how you can upload your photo, how to open the photo in Camtasia, and how you can use Camtasia to create a moving profile picture. Also discussed is how you can upload your Camtasia videos onto Youtube! Just a wonderful video for those who use ...
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.
Commercial hair conditioners aren’t just expensive, they’re loaded with chemicals. Why don’t you whip up something more natural at home?
Holography is the scattering of light from an object, which is recorded and reconstructed to create the hologram. As the viewer or viewing mechanism moves, the image appears three dimensional. This instructional video shows how to craft 3 dimensional holograms using scratched arcs on a reflective surface. Using a compass, a picture, and Plexiglas, you can create glowing images that shift and turn inside of a 2 dimensional plane. Who would of thought? Now you can make your very own holograms a...
Most people don't use their cameras to make movies (really bad quality and a sort of user-generated content feel are probably the culprits) but cameras with a record function are great for those impromptu memory-making moments when your dog tries to do a handstand or your grandma unloads the biggest belch ever.
Watch this in-depth video tutorial on how to animate LEGOs for stop motion animated brickfilms. This is a detailed peek behind the scenes of stop-motion animation from the director of the "Circle Circle Dot Dot" music video, Blunty3000.
This tutorial shows you how to install Audacity and install the LAME mp3 encoder to make Audacity ready to export mp3s. Part two goes over editing basics using the free recording software Audacity. By the end of this tutorial, you will be able to create mp3 podcasts in Audacity.
This tutorial on the companion Tech Ease for Mac site shows you how to use Inspiredata to collect, organize, and visualize data using several types of diagrams supported by the program. The movies were recorded on a Mac, but Inspiredata is a cross-platform program so the steps shown should work on the Windows version of the program as well. Inspiredata works like a database system that allows you to add notes and more.
This tutorial on the companion Tech Ease for Mac site shows you how to use Inspiration to create concept maps that help you brainstorm and organize your ideas. The movies were recorded on a Mac, but Inspiration is a cross-platform program so the steps shown should work on the Windows version of the program as well. Watch and learn how to use Inspiration to create concept maps.
Many educators and institutions are already integrating podcasting successfully into their curricula — with great results. Podcasting enables educators to use music and recorded audio to enhance learning. The addition of photos and video to podcasting allows educators to add a wide range of visual content to their teaching and address even more learning styles.
Like most of us, you probably recorded some of your favorite memories onto a VHS tape. Preserve the good times by transferring the tape to a DVD.
Another type of exotic flower arrangement is the right angle design. This technique is very professional looking and by following along with this tutorial from Flowergod, you will be able to create your very own. Store bought bouquets are expensive, so why not practice and make the next one on your own?
In this podcast tutorial Randall Bennett and Adam Nielson look at Sony's Vegas, Color Correcting and insight into some expensive storage and how much Randall hates P2 cards (he really does.) Stay tuned and learn how to color correct in Sony Vegas, amongst other things.
Remodeling your bathroom can be expensive unless you know know how to do things yourself. This how to video is a quick excerpt from a DIY show. Watch and learn how to build a support system for a whirlpool bathtub.
Redoing your floors can be expensive unless you know how to do it yourself. Learn the basics for installing a new engineered wood floor in this how to video. Watch the short DIY show clip and follow along so that you too can install a new engineered floor in your kitchen.
In this quick DIY video excerpt we can see the process for installing a custom maple countertop. Remodeling a kitchen with a new counter top can be expensive, unless you know how to do it yourself. Watch this how to video to learn how to build and install a maple countertop in your own kitchen.
You don't need to rent an expensive pressure washer to get your deck clean. Learn how to clean your deck without using a pressure washer with this tutorial. You can get a beautiful, shiny wood deck with the steps from this how to video.
Water is becoming more scarce and more expensive. Most of the water used in your house is used outside the house. This how to video teaches you tips for conserving water around your yard. Watch this eco-friendly tutorial and you can be saving water and money in your home in no time.
The pull cord on a chainsaw can easily be repaired with a bit of brass tubing and some epoxy glue. Simple repairs are easy to perform yourself, without expensive replacements. Watch this video home repair tutorial and learn how to fix the pull cord on a chainsaw.
Frozen yogurt is delicious but it can be expensive to buy. Luckily in this how-to video we show you how to make frozen yogurt at home. You don't need a fancy ice cream maker for his recipe. Grab your favorite yogurt, a plastic bag, and your favorite toppings. Chill the yogurt in the plastic bag, attach a pastry tip and dispense into a bowl. Enjoy
Like anime and manga? Cosplay? Naruto? Then go no further then this here video tutorial.
You love your bike and it was stolen. Although, this is not a good scenario, you still may be able to retrieve it. Sketch the serial number or means of identification into the bike and then when it is stolen you can really get the word out to all the places that it might turn up.
A dirty or dusty record can pop or skip. Learn how clean vinyl records in this free record player maintenance lesson from an experienced disc jockey.
Antique store owner Jan Braunstein has seen her share of rare records. In this series, she shows you her very own copy of one of the rarest, the infamous “butcher cover” of the Beatles’ “Yesterday and Today” album. She gives you an overview of record collecting in general and talks about some albums by Bob Dylan, Elvis and the Beach Boys which you should snatch up whenever you see them.
Learn all about Combinator controller instruments within Reason 5. This official video guide from James Bernard of Propellerhead will teach you everything you'll need to know. Whether you're new to Propellerhead's virtual music studio application, Reason, or their newer DAW app, Record, you're sure to find much to take away from this brief video software tutorial.
Taking minutes is the single most important thing you can do at a meeting to record what happened at a business meeting- ideas discussed, new directions for certain departments, etc. But taking minutes isn't as easy as scribbling down notes like you did in 5th grade. Check out this video to learn how to take clear and informative minutes.
In this video from clickherephotography we learn how to take great photos by using depth of field. In a picture of a bird he used an aperture of about 5.6 which increased the shutter speed on a 300mm Canon lens. With depth of field you can blow your background out. If you used a higher aperture, a lot more of the bird would have been in focus and a bit of the background would have been in focus. By using an F-stop and this aperture, you really bring the bird or whatever object is in the foreg...
There are many, many playable characters in Naruto Shippuden: Ultimate Ninja Storm 2, some more hidden / secret than others. In this video you'll learn how to unlock two of the more difficult characters to unlock: Lars Alexandersson and Minato Yamikaze.
In this tutorial, we learn how to cheat on any test by wearing a fake bandage. You will need: a phone, ear buds for your phone, bandages, and transparent tape. First you will need to use your phone to record yourself saying the information you need to hear. Read this off your book or notes so all the information is perfectly correct. Now, plug the ear phone into your phone and then slip it through your sleeve before school. Now place it in your hand and wrap the bandage around it. When you ne...
