Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel name tricks, you'll learn apply names to formulas using Excel's built-in Apply Name Feature.
Well, Apple has finally gotten up to date and added cut, copy and paste to your iPhone. This sounds like a tiny addition, but is actually making the iPhone much more functional and user-friendly.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 58th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the Excel 2007 table dynamic range feature with a data validation drop-down list without using the table name!
Now that you've got your Nikon SB-900 professional-grade speedlight, make sure that you get the most out of it with this free photographer's guide, which will walk you through the flash unit's basic features and functionalities.
Want to move quickly from indoor to outdoor shooting environments without having to futz with the manual controls on your video camera to adjust for the disparate light levels? If so, you should give your camera's automatic exposure feature a whirl. For more information on using your digital camera's auto exposure tool, watch this free cinematographer's guide.
In this video tutorial, we learn how to navigate and use the basic functions and features of a Verizon LG Touch cell phone. Whether you own a LG Octane Touch phone or are merely curious to see how they work, you're sure to enjoy this brief clip. For detailed, step-by-step instructions, take a look.
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 21st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the BINOMDIST function to calculate probabilities for a binomial experiment - binomial distribution!
Want to design your very own custom YouTube background but lack either the money or desire to buy a full-featured graphic design suite like Adobe Photoshop? You're in luck. This designer's video tutorial will walk you through how to make a YouTube background using the free GIMP image editing program from the free software folks at GNU.
Adding formatting to plain Excel spreadsheet is a wonderful way of increasing the readability and improving the overall look and feel of your data. With this software how-to from ExcelIsFun, you'll learn all about using the Microsoft Office program's formatting features. As an added bonus, you'll learn about the ROUND function, which is also useful for cleaning up charts where great precision isn't required.
Nick from Greyscale Gorilla demonstrates how to use the ever-useful CS Tools plug-in (Daylight) for Cinema 4D. This feature enables you to fine-tune your key light and other precise ambient settings.
Nick from Greyscale Gorilla show you how to use the CS Tools plug-in "Cubes" in Cinema 4D. This feature is especially helpful for random shape arrays.
Understanding the EV Compensation feature on Nikon DSLR's is extremely valuable when shooting with a flash. Adjustments enable you to fine-tune exposure, flash settings, as well as more general settings.
Need to compare two datasets and extract the new values? In this the 539th installment of ExcelIsFun's series of Excel magic tricks, you'll see how to use the MATCH function, the Join Symbol (& Ampersand), and the Filter feature to check two 2 lists of transactoinal records and extract only the new records (records that are in new list but not in old list).
Excel dilettantes and seasoned Microsoft Office professionals alike may be surprised to learn that in Excel one can make a drop down list based upon a second drop down list (or, similarly, data validation list that is based on a second validation list).
For moviemakers new to the editing process, this video tutorial outlines the steps to using Adobe Premiere Pro to edit movies. The tutorial shows us how to navigate through the various windows containing tools and other applications. The tutorial breaks down different, basic features of the software for the beginner. Learn various tips in this video tutorial on how to navigate and use Adobe Premiere to figure out how to edit any movie.
If you're new to the Internet, or just new to the Safari web browser, you might also be new to the concept of Bookmarks Bar. Happily, this video tutorial from MacMost will teach you everything you need to know about using this handy feature.
In this installment of home improvement do-it-yourself videos, brought to you by Lowe's, host Mike Kraft, one of Lowe's home improvement experts, demonstrates a landscaping technique that shows you how to create a retaining wall with interlocking wall blocks, that features a raised planter bed. Mike gives you a list of all the tools and materials you will need to create the retaining wall, and offers some tips on creating curved lines when laying out the wall.
In this how-to video TechVW shows you how to watch Hulu, Netflix and more on a Wii home gaming system. He shows by using a web program called PlayOn that can be accessed through Wii Opera, you can connect to your computer to play videos streamed over the network. He goes on to show the different services offered and how to access each of them and a brief display of how they are used and what features they have.
This video tutorial shows both the basic features and more in-depth uses of the Blackberry Curve II camera's capabilities. The tutorial goes through many options, providing a good description of how to access and use each. The viewer will learn the specifications of the camera including its mega-pixels, zooming capabilities, and so forth. Manipulation of lighting effects, color effects, and options when saving and deleting pictures are just some of the components reviewed.
Anna Saccone shows which colors to wear if you are a brunette, pale, with cool undertones, having any eye color. She explains about some basic colors such as white, cream, and mint green, which work best with your skin undertones and hair color to best accentuate your features and look. Anna gives this general guide as a good base, though depending on specifics that work for you, may change a little since each person is different.
This video gives a tour of the Motorola Droid software. The video begins with the user turning on the cell phone and guides you through navigating the gui (graphic user interface). The easy to use Youtube desktop widget is featured as well as the scrolling desktop that's moved by a flick of the finger tip in either a left to right or right to left direction.
Melvin from QZPStudios takes you on a quick tutorial in which he creates an embedded text effect in Photoshop. This could be a useful trick for website designers who want to create banners containing text which have a shadow effect.
In Call of Duty: WAW, perhaps the most addictive multiplayer mode is Nazi Zombies, featuring unending hordes of Nazi and Imperial Japanese zombies. Learn how to spawn inside of a wall, and you will be untouchable.
Automixing in Virtual DJ is basically a jukebox function that will attempt to mix two songs together, without you having to do it manually. Discover how it works in this video. Download a free trial of Virtual DJ and start mixing.
Big fan of the Oscar winning movie, Slumdog Millionaire? In this video, learn a few moves from the original Jai Ho dance that was featured in the movie, plus a short dance created by the videomaker that can be repeated four times throughout the "Jai Ho" song. Good luck, and don't forget to have fun!
In this video, learn about the different functions of the Canon EOS 7D, which features an 8 frame per second shooting speed. This video goes over menu options & configuring the buttons, AF point selection, AF focus, & the flash functions.
In this video, get to know the Verizon Droid from Verizon Wireless. In this video, learn about the useful features and functions behind this phone, like watching YouTube videos in high quality, and getting alerts while browsing.
So, you've downloaded Boxee... Experience TV in a brand new way! This video will help you get started.
This is a short but thorough guide to how to throw and catch a boomerang. We focus on boomerang grip, throwing technique, and more. The presentation is no-frills but informative, featuring a lot of diagrams and a brief demonstration at the end.
If you have to deal with piles of snow outside every year, you've probably dreamed about owning a snowblower. But how do they work, and how do you know which one to buy? In this video tutorial, Ask the Builder host Tim Carter will show you how to use a John Deere snowblower, and he'll walk you through what features to look for when you're buying your own blower.
When German mathematician August Ferdinand Möbius (also known as Moebius) discovered the weird, seemingly parodoxical shape that would later be known as the Möbius strip, he surely never imagined it would go on to be featured everywhere from the work of artist M.C. Escher to the recycling logo we now see on the back of milk cartons. In this video, we watch as a scarf is knitted based on the Möbius strip. This interesting and eye-catching scarf design looks more complicated than it really is.
Do you have so many Firefox bookmarks that you start forgetting what's what? Well, conveniently, there's a utility in Firefox that most people don't know about: Smart Bookmarks!
This tutorial covers the basics of creating homemade CGI with PFTrack, a Swiss Army knife of visual effects software. Using PFTrack, PictureBandit takes you through the different features of PFTrack, and shows you how to use it to match move your scene. Make your video project look as professional as possible with this PFTrack tutorial.
This tutorial is a great eye-opener into the world of Microsoft Word. If you thought you could just open Microsoft Word and type, you are not taking full advantage of what the system has to offer. Iain Broome shows you how to use the Document Map feature on Micosoft Word to your best advantage for any writing project. For more video tips on Microsoft Word, search for Microsoft Word on WonderHowTo.
Whether you want to save money by making your own clothes or you just enjoy working with fabrics, choose the best sewing machine so your projects turn out great.
Windows 7 is awesome, and here are four super cool secret tips to make it look even better. Say hello to your new operating system! Learn how to use aero shake, jump lists, libraries, and more. Watch this video and learn how to use some of the new features on Windows 7.
Find out more: http://www.bbc.co.uk/realhustle VOTE for the best hustle of all time! Pick your favourite scam and cast your vote at http://www.bbc.co.uk/realhustle/besth...
Check out this cinematography video tutorial on how to use the Panasonic HPX500 broadcast camera. The Panasonic professional digital camcorder HPX500 is an awesome camera for the new age.
Check out John Jacobs' Golf School's video tip on playing golf in sand hazards. This sand play lesson, featuring Brad Moore, John Jacobs' Golf School instructor will help you improve your golf game and lower your score!
Collected tutorial video from the "Ottawa's Eddy Matzger Weekend" event. Featuring Barry Publow and Eddy Matzger, this tutorial goes over the double push. This is a hill skating technique necessary to keep competitive in inline speed skating.
