New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 488th installment in their series of digital spreadsheet magic tricks, you'll learn how to use VLOOKUP with multiple lookup values. You'll also learn how to add an extra column with a unique identifier to data set using ampersand concatenate.
In this video from middiablo we learn how to combine multiple PDF files into one document on a Mac. Navigate to where the PDF files are in the finder and command click on them and then open with preview. Make sure the thumbnails button is checked at the bottom right. In order to select them all, click on one page, hold down shift and then click on the last page. It will select every page. Now click and drag and you can put the pages anywhere you want. Now go to File and Save. An even easier w...
Koizu brings you another lesson in how to draw manga. He describes how he begins with the eyes as guidelines that are used as the base for each facial expression. This immediately begins to capture and illustrate the specific expression for which you are going. Multiple facial features are illustrated in the manga style of drawing and range anywhere from angry to happy and beyond. This video will definitely either teach you how to draw the facial expressions using simple features or help you ...
Most dogs will be able to tell the difference between a pill and, let's say… a piece of cheese. They aren't as stupid as you think. One is for eating and one is for spitting out. Well, this is a short video tutorial to teach you how to feed your dog multiple pills without fuss.
When one hoop just isn't enough, multi-hoop moves are the only way to cure hula hoop boredom. Spinning four rings around your body is no easy trick, but fortunately there are some tips to help you work up to multiple ring hula hooping. Safire, expert hula hoop dancer, walks through the steps of working your way up to multi hoop hula hoop moves, covering everything from how to practice to how to just get all those hoops on your body. Watch this video hula hoop tutorial and learn how to perform...
Ever wanted to perform a magic trick but didn't really have the hand eye skills most magicians seem to have? Always thought magic can be performed only by face-to-face and not long distance (say over the phone)? Well think again as I teach you how to do the Mathematical card trick "The Power of Three"
Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to work with layers in Photoshop.
Well, you've got your friends & family email account, your email account for buying junk and that little secret email you keep for all other reasons. If you've been looking for a way to get them all onto your AT&T BlackBerry, here's a clear & concise tutorial teaching you how to do just that.
Got a fireplace? Then you'll be doing it injustice if you don't festoon it and dress it to the nines for the holiday season. But don't take the easy way out and purchase cheapo plastic ornaments and fake greenery at the store. Instead, check out this video to learn how to make it simply drip with glamour.
One of the new areas that you can access in Dwarf Fortress 2010 is Hell itself. This video will show you how to get there and what to do when you do.
This video will show you how to build and use hospitals to take care of your dwarves in Dwarf Fortress 2010. It also discusses what happens when you abandon and then reclaim your fortress.
In this video, you'll learn about the basics of using your military to defend your fortress, in this case against a dinosaur attack, in Dwarf Fortress.
This Dwarf Fortress 2010 video will show you how to design a basic, effective fort, and also explain how channeling and farming work.
The release of Dwarf Fortress 2010 introduced many great changes to Dwarf Fortress, and this video will bring you up to speed on them. It also covers the beginning of a game, including preparing your dwarves, choosing a fortress site, and getting into caves.
This video will give you an overview of a successful endgame fortress from Dwarf Fortress, giving you tips on achieving a similarly successful fortress throughout.
In this video you will see the results of the creator's preivous attempts to use a cave-in to trap demons in their peculiar chamber, then learn how the Justice and Economy systems work in Dwarf Fortress.
The best way to deal with demons in Dwarf Fortress in to seal them in their peculiar chamber by creating a cave-in above it. This video will show you how to do just that.
This video will show you how to make and use siege weapons and disarm enemies in Dwarf Fortress. It also includes an arena battle at the end for kicks.
Magma is valuable but dangerous stuff in Dwarf Fortress, and this video will teach you still more about how to handle it. It also covers how to build bridges, floodgates, and levers that will link up and create effective dwarven infrastructure.
Water and magma can both destroy even a sturdy dwarf fortress very quickly. This video is all about liquid safety, teaching you how to channel water and magma using u-tubes and other tools without flooding your fortress and killing your dwarves.
This video starts with a new Dwarf Fortress fortress, and will show you how to deal with underground rivers and magma pipes.
At this point in the game, Dwarf Fortress is starting to get serious. This video will show you how to defend against a goblin ambush and deal with graveyards and coffins, the resting places of your dead dwarves.
In this video you'll learn how to make a wide variety of leather items, including bags, waterskins, backpacks, and quivers, as well as dig wells for your dwarves drinking water in Dwarf Fortress.
This video covers a wide variety of Dwarf Fortress topics, including moods, making crossbows, smoothing stones, herbalism, and engraving.
This video will show you how to set up an effective fortress defense, deal with Elven traders, and make use of your migrants in Dwarf Fortress.
Finger tutting and digitz are related, but as different as two dance styles that both have words that mean finger in their name can be. This video will show you how to do a sick, fairly basic dance combo that integrates aspects of tutting, finger tutting, and digitz into a sick little move.
In this video, you'll learn how to use military patrols to repel invaders, make secure entrances to your fortress, and create bins in Dwarf Fortress.
In this video you'll learn how to have your dwarves make crafts, how to encrust those crafts with gems, and then get them to the trade depot so you can sell them in Dwarf Fortress. It also discusses the game's many hot keys.
Tecktonik dance combines aspects of disco, glowsticking, and hip-hop dance to create a funky, fast, futuristic hybrid style that has become quite fashionable in the electro house scene (which has itself become very fashionable over the same period). This pair of videos will teach you many of the basic and more advanced steps to Tecktonik dancing at a very manageable pace, and should help you sharpen your moves before your next big Dirty South or D Ramirez party.
After you generate the world and choose a location for your fortress in Dwarf Fortress, it's time to prepare your party of seven dwarves to journey there. This video will show you how to assign their skill points and choose the right items to help you reach the fortress and succeed there.
If you've never played Dwarf Fortress before, you've come to the right video. It will show you how to start the game, generate the world on which you will play, then choose a good location for your fortress.
If you have an iPhone 3G or iPod Touch 2G, you're probably having problems with iOS 4 of multiple kinds. If you have just jailbroken one of those Apple devices and want to activate some of the sexy new options available to you, watch this video. It will show you how to enable multitasking and homescreen wallpaper on your jailbroken iPhone 3G or iPod Touch 2G with iOS 4 using winterboard.
The Contacts application on Android-powered cell phones provides a powerful way to manage your address books and keep in touch with friends and family. You can even add and manage multiple accounts from various sources. Watch these tips from Google to learn who to get the most of the Contacts Android app.
Arguably the single most important aspect to modeling is topology. This overview tutorial takes a look at the topology of the human head, examining each of the main edgeloops, poles, etc. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including s...
Expert bartender Jason Griffin from quickstrain.com has tons of helpful tips for all you aspiring bartender out there. Jason will show how a pro does the little things that separate the good ones from great ones. Watch this video to learn how to pour multiple drinks, upsell to customers and so much more!
Watch this video to learn something short and simple just for you to mix it in to your other salsa dancing moves. Remember, it is not about having multiple long combos, but about putting smaller salsa moves together in different orders that will make you a versatile dancer. That will keep your salsa moves fresh and keep the ladies guessing what you will do next.
In this video tutorial you will learn about the basics of using Smart Objects in Photoshop. Smart objects can consist of pixel-based content or vector-based content. These smart objects also remember their original size and can be transformed multiple times without loss.
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.
Here they are used to find anime episodes and movies, but you can use advanced Google commands to perform more dynamic searches on Youtube. Learn how to narrow or expand your searches and search for multiple items simultaneously.
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 729th installment in their series of digital spreadsheet magic tricks, you'll learn how to lookup an item when multiple lookup items are in a single cell with the LOOKUP and SEARCH functions.
