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.
Freelance web developer and Internet marketer David Frosdick offers some tips and tricks in this video tutorial on how to get the best Camtasia settings for YouTube widescreen.
Have you been trying to figure out a way to record your Xbox 360 and broadcast it into Final Cut Pro? Using the DV Passthrough method, you can take an analog signal, pass it through your camcorder, and send it to Final Cut Pro.
Check out this video tutorial to show you how to use a Marantz digital audio recorder. This video was made by the equipment room at CUNY Journalism School in New York.
You don't need a band to play and record your own songs. With Garageband and your Mac, you'll be making music right away.
Use old vinyl plates to craft this retro DVD or CD case rack.
Listen to conversations over long distances with a homemade laser listening device. All you'll need is a laser pointer, tripod, old pair of headphones, photocell, a recording device, and the step-by-step instructions in this how-to video. The creator of this video tutorial does not mention the need for sophisticated software. But the principle is quite sound. If you can figure it out, you can eavesdrop and spy on whoever.
Here Christopher Walken shows us how to roast a chicken with pears. It is a simple recipe, recorded supposedly as an audition tape for Food Network. We cannot confirm.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 95th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the OR, AND, NOT, & COUNTIF functions and Excel's advanced filter tool to extract records from a table of data. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.
This is a highly informative video tutorial on how to use the software CamStudio to screen record anything on one's desktop. One simply has to open a search engine like Google, type in 'camstudio' and hit the search button. On Google, the official website, camstudio.org, is the first one in the search results. Once that is opened, just scroll down, click on the link camstudio20.exe, and then click 'save file'. Once downloaded, this software can capture all the audio and video activity on the ...
Dave Andrews gives a simple overview of how to take a cassette tape and convert it to a CD using Audacity. First you will need a cassette tape player, like a boom box, with a microphone jack. Then you'll want to download the free program called Audacity. To begin recording music from the cassette tape simply press the record button on the audacity application while you press the play button on the boom box. You'll want to make sure the audio cable is connected from the boom box to the PC. Fin...
Justin Bieber is a Canadian pop/R&B sensation. Discovered on YouTube by Scooter Braun, who would later become his manager, Bieber was almost immediately flown out to consult with R&B hit maker Usher after being discovered. Beiber then went on to become one of the youngest artists to ever be signed to reputable record label, Island Records. Besides being known as a singer, Beiber has become quite the heartthrob amongst young tweeny bop girls!
One of the many reasons for the Fallout series enduring popularity is the wide variety of creative and retro-futuristic weapons available for the player to lay waste with. Most of them are not real, but by gumption this girl has made one of them so! This video will show you how to make something like, but probably not as good-looking as, this amazing replica of the dart gun from Fallout 3. It's made of pretty much the same materials you make it out of in the game, and might be the single best...
The Nokia N900 smartphone comes with a wide variety of apps including e-mail, a browser, and more. Browsing, opening, and switching between these apps is an easy task when you know the right gestures and taps to make on phone's screen.
If you are looking to get into DIY auto repair, this video is a great place to start. Learning to remove and reinstall a rear door panel will allow you to pursue a variety of auto repair projects. This video shows you how to get started on a 1998-2004 Dodge Intrepid.
PowerPoint is currently not available for iPad. However, there are ways of being able to view your PowerPoint presentation on the iPad. This informative video shows you some of the many alternatives that you can use to view your presentations on the iPad, ranging from YouTube, PDF files to a variety of other options.
If you've ever gone Christmas tree shopping before at a Christmas tree lot, then you're probably more than familiar with Noble Firs, Douglas Firs, Grand Firs, and maybe even Blue Spruce and boxwood (used for wreaths). But have you ever considered using other varieties of evergreens in your decorating?
The infinity scarf is the hottest accessory this season. It'll keep you warm and toasty all through winter. In this video, you'll be shown a variety of ways you can wear this scarf. It's versatile, and goes with just about anything in your closet.
Your Christmas tree isn't the only place ornaments belong. Add ornaments to your cupcakes this holiday season as well by creating these adorable holiday ornament cupcakes. All you need is some icing, sprinkles, and imagination to create all varieties of sparkly Christmas ornament cupcakes.
Eyes can be used for a variety of expressions, especially in manga or anime where they tend to be very large and round. This tutorial shows you a way to quickly and easily draw one hundred eyes for your manga or anime characters.
In this video, we learn how to become a US citizen with a DUI on record. The law says that in order for your to become a citizen, you must show good moral character for five years after your DUI. A DUI is not considered good moral character, but it does not make you ineligible. If you are under probation, then you will not be able to apply to be a US citizen. If you are NOT on probation, then you will have better chances of getting your citizenship. Good luck on your approval and make sure yo...
Out of time and/or money to put together a costume for Halloween? Don't give up! You can make a variety of interesting and creepy Halloween costumes just by raiding your closet. Here are a couple good ideas for simple but effective costumes.
In this tutorial, we learn how to use guitar, bass amp, & speaker emulation in Line 6. First, plug in your guitar, create an audio track, and add a line 6 amp. The line 6 amp comes with 3 amplifiers. While the bass amp lets you choose between two. When you change the amp, the compute will change cabinets to go with it in the program. To load a combinatory pre-set, click the folder to open up the path browser. The record sound bank includes a lot of sound bank options, so choose the ones that ...
Scones are one of the best and most diverse of the breakfast pastries. The Scottish variety lacks the sweetness of some others but is still hearty and delicious with a coffee. This video will show you how to make a perfect batch of Scottish Scones.
Do you have children, but not want that fact to define your style and what other people think of you? This video has help. It will give you a variety of tips for mothers who don't want to dress like mothers, but still want clothing that will accommodate their active lifestyle.
Want to change your iPod background to something cool? This video shows you how to hack a click-wheel model to reset your iPod and gain access to the system center so you have the option to set a variety of different backgrounds and wallpapers for your iPod.
This video shows you a variety of hacks and mods for your Xbox 360, AppleTV and how to boost your wifi. You're shown how to make an antenna booster for your router, stream content to your Apple TV and upgrade the hard drive.
Pipe cleaners are for more than just cleaning. They're a perfect craft item that can be used to make a variety of different things, thanks to their flexibility. And that's all you need to make some wonderful, colorful butterflies. A butterfly pipe cleaner is the perfect project for you and your kids! You will need:
In this video tutorial, viewers learn how to deal with a traffic ticket. When you pay for a ticket, don't just ignore it because there is always a hidden cost to a speeding ticket. Speeding tickets may cause insurance rates to go up. To avoid the insurance penalty, users should either go to court or traffic school. Going to traffic school to take the ticket off of your driving record. Another method is to cut a deal with the prosecutor. The key is to keep the points off your record and not al...
Called a "crazy paper thing" by the owner, the description is perhaps a little too vague to describe the sheer genius of this transforming paper module of cubes.
Google Chrome is the hottest new browser to hit the market, and it's got a variety of new features that you won't find anywhere else. Follow along in this video to learn how you can install Google Chrome, and also add different extensions to modify the functionality of the Google Chrome browser to your liking.
A really cool feature in Camtasia 7 is the ability to draw directly on the screen during a recording. This is helpful if you want to circle something onscreen, or if you want to highlight some text during your screencast. There's plenty of other options also in the ScreenDraw feature. To learn out how to use it, watch this video, which will show you all the things you can do.
If you've been using the internet for many years, chances are you've come across Internet Explorer at some point. Nowadays there are a whole wide variety of Web Browsers including Google Chrome and Mozilla Firefox. So if don't have IE downloaded on your computer this tutorial will help you. Check it out and understand how to download and install Internet Explorer 8 on your computer. Enjoy!
Take your favorite cartoon characters from the television to your very own bedroom walls! Learn how to draw Pon and Zi, the two cute little emo cartoon characters created by Azuzephre with help from Drawing Now. Search WonderHowTo for more videos from Drawing Now to learn how to draw a variety of characters and cartoons!
Big fan of hugely popular Japanese manga series? You're definitely not alone. In this drawing tutorial, learn how to draw Chibi Kakashi with help from Drawing Now. Search WonderHowTo for more videos from Drawing Now to learn how to draw a variety of characters and cartoons!
Bring the lovable characters of Looney Toons home to your bedroom walls with help from this drawing tutorial! Learn how to draw Bugs Bunny from Looney Tunes with help from Drawing Now. Search WonderHowTo for more videos from Drawing Now to learn how to draw a variety of characters and cartoons!
Hang the King of Pop on your wall with help from this video! Learn how to draw Michael Jackson doing one of his famous dance moves with help from Drawing Now. Search WonderHowTo for more videos from Drawing Now to learn how to draw a variety of characters and cartoons!
Big fan of Japanese manga series, Astro Boy? Learn how to draw the main character from this anime manga series with help from Drawing Now. Search WonderHowTo for more videos from Drawing Now to learn how to draw a variety of characters and cartoons!
Legend of Zelda fans unite! Learn how to draw Zelda toon characters with help from Drawing Now. Search WonderHowTo for more videos from Drawing Now to learn how to draw a variety of characters and cartoons!