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.
Whether you're new to Adobe InDesign or a seasoned graphic arts professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to create compelling eBooks with enhanced support for the EPUB file format with CS5 Design Premium and Digital Editions.
Whether you're new to Adobe After Effects or a seasoned digital film professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to turn spoken dialogue into searchable text either by synchronizing content with your Adobe Story script, or by using reference scripts that are optimized for your content. Also see how to accelerate editing by marking in and out points in t...
Whether you're new to Adobe After Effects or a seasoned digital film professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to isolate moving foreground elements from their backgrounds faster using the revolutionary new Roto Brush approach that works much like the Quick Select tool in Photoshop.
This video demonstrates how to make your own Wiccan runes. You need ordinary, commercially grown lima beans. You can also make smaller ones using smaller beans or you can use river stones. Use a rune chart. These can be found in most New Age shops or you can download one for free online. Choose beans without cracks. Use a marker pen, or a "Sharpie" to mark each rune on one stone or bean. Copy the whole chart. When you have done this you can bless the runes. They can be kept with some sacred s...
Looking very much like an outsized iPod Touch, it's only natural that the Apple iPad be a great device for music. With this official video guide from Apple, you'll learn how to use Apple's free iPod app to browse, manage and listen to your digital music library.
Kevin Hnatiuk (the Digital Dad) shows you how to convert your old Super 8 film reels to DVD, easily at home. Knatiuk goes over how to get started, what you need, and what to expect when digitaizing your super 8mm movies.
Kipkay from Make Magazine shows us how to create a photographic illusion, making things look smaller than they really are with tilt-shift photography. Materials needed include rubber plunger, an oversized lens, a plastic body cap, a single lens (or digital single lens) camera, a hot glue gun, a sanding file, and a disposable object for a plastic backing, such as a VHS tape case. With this great tutorial and a little work, create the illusion of a miniaturized world with this photographic tech...
PixelPerfect teaches you everything you need to know about being a digital artist. Learn tips and tricks to turn your regular vacation photos into works of art worthy of museums.
Everything you need to enjoy your new digital library is in iTunes. iTunes organizes all your music and video into categories you can browse easily.
Ted from Red Digital, and Michael from PlasterCITY, shows how to take a 4k source file, edit in real time, and make dailies in Final Cut Pro.
Learn how to create a 3D anaglyph image (the kind of 3D image you see with 3D glasses) using Adobe Photoshop and a digital camera.
This tutorial shows you how to make a picture frame using a Mattel Juicebox media player.
Send in the clones! Steve Nelson teaches you how to create a digital cloning effect for your films. Create duplicates of your actors on screen.
Looking to create great special FX for you films using a green screen. Steve from Indy Mogul teaches you how to shoot using a blue screen or a green screen and also how to add in your own digital backgrounds.
Final Cut Pro X has all new effects and transitions that no other video editing software has. This is your video guide to all of the things you can with FCP X on your Apple computer. Learn about the adding Boca effects, aged paper effects, and more.
You don't need a ten-figure budget to make a great movie! With nothing more than iMovie, a camera, and your imagination you can make a stop motion animation. With stop motion, you can bring anything to life. This is a really fun project for aspiring directors of all ages.
The tyrannosaurus rex, or T-Rex, was the original king of the jungle (king of the world, to be more accurate) during the age of the dinosaurs. They were gigantic, intimidating, and extremely strong.
You can use this trick on either a Mac or PC, and you don't need any of the DLC to do it. Get an expensive item, which makes the glitch work faster. Clicking on both mouse buttons lets you sell an item twice - then buy it back and resell!
The best crossbow in the game is without a doubt the Imperial Crossow, which you can find early in the game, in Lothering (before it gets overrun by darkspawn!) Find the merchant who is overcharging (across from the Chantry) and then pickpocket him after you run off the sisters.
A hardened Alistair makes it easier for you to achieve your goals - whether it's making him king, having him marry Anora or marrying him yourself. He also disapproves less of certain actions. Here's the right dialogue options to pick when you're meeting Goldanna.
Everyone has an iPod or other mp3 player nowadays, and of course you always want to listen to your music. However, if you're not careful, you could end up damaging your hearing. Follow these tips, and you'll be enjoying your music to a ripe old age!
You can easily copy the aged look on old brass jewelry and hardware. Brass, an alloy of copper and zinc, oxides naturally. But you can encourage the process to go faster by using vinegar and salt water, or a rag soaked in ammonia. Use these techniques to mimic an antique patina.
Learn how to multiply decimal numbers with this free video math lesson. With mathematics, as with anything else, not everyone progresses at the same rate. Happily, in the age of Internet video tutorials, this isn't a problem. Those who progress quickly can go beyond what's being taught them and those who are struggling likewise have all the time in the world to catch up.
The best way to make sure you don't throw your back out when moving a heavy television and that your body stays lithe and strong even as you age is to do push ups, chest exercises that work out your entire body at once while focusing on strengthening your back and core.
Throwing a Halloween party or looking to send some treats to school with you kids? Look no further! In this video, learn how to make really cool mummy themed Halloween cookies that everyone will love. These little crowd pleasers are perfect for any age and will soon become a holiday tradition in your household.
Three kindergarten aged girls with superpowers? Who wouldn't be a fan! Learn how to draw Bubbles from the Powerpuff Girls series with help from Drawing Now. Search WonderHowTo for more videos rom Drawing Now to learn how to draw a variety of characters and cartoons!
Have fun with your kids this weekend and incorporate an arts & crafts project into your weekend activities! In this Simple Kid's Crafts tutorial, learn how to make a teddy bear out of pom poms, perfect for children kindergarden age and up. Get your children's creative juices pumping with fun arts & crafts projects like this one!
So you shot a deer, now what? Time to field dress the animal and make the most of your prize. Throughout the process it is important to keep your incisions precise, so as to avoid any messy mistakes. This instructional video will also teach you how to tell the age of the deer by the condition of its teeth.
Chocolate Pot de Crème is a grownup version of an age old favorite -- fancy chocolate pudding! This dessert will have your mouth watering!
Making fresh pasta is an age old process that every home cook should know how do. It's simple, fast, and fun, and homemade noodles take just a minute to cook!
Buying a digital camera doesn't mean your old prints, slides, or negatives are obsolete. You can easily convert them with a scanner to bring them into the 21st century. Watch this video to learn how to convert photos to digital.
iPod and iPhone home automation remote control using Girder is only an install away. Run the lights, heat, security system among other things in your space age home for the 21st century. Make your home a modern marvel with this app for iPhone.
In this software tutorial Lindsay Adler will show you how to add an extra dimension to your images in Photoshop: texture. Adding texture to images can help create the appearance of an image being old, tattered or worn. Texture can also add an emotional dimension to a photograph, making it moody and more expressive. Watch this tutorial to see how easy it is to add textures to your images and make them look older using Photoshop.
Doc Brown is back for another Adobe Photoshop lesson. This time, he shows us how to destroy text, the pirate way. Learn how to create text that follows the form of a crumpled piece of paper and looks aged, just like on a pirate treasure map, all within Photoshop.
The Canon EOS 7D digital SLR is the first Canon EOS camera that can trigger off-camera Speedlites with the cameras build in flash. The integrated Speedlite transmitter is fully compatible with the Wireless E-TTL Flash System. See exactly how all this works and how to use your flash functions.
