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 323rd installment in their series of digital spreadsheet magic tricks, you'll learn how to run a partial text lookup query using a VLOOKUP function with wild card criteria.
Selling your old iPhone to make way for the latest generation? Before you get all Ebay happy, make sure to take a quick look at this video, which will demonstrate how to completely erase all data from your iPhone - including your contacts from the SIM card. Your friends will thank you for it.
Joann from Paper Crafting shares her tips in this video for filing and saving her scrap paper and card stock. She has created a new system where she uses "paper protectors". They must be clear and they should be intended to use more than one piece of paper. She then puts the scraps coordinated by color and paper type in the clear plastic protectors in a basket so they are always handy.
Accidentally deleted your address book? Got some sneaking suspicions you want to clear up? Got something to hide - permanently? In this video you'll learn what hardware and software you need and how to use it to recover deleted text messages, or, conversely, how to delete data permanently from your SIM card. Don't worry - we won't judge.
Watch this video to learn how to upload and play video on your LG enV3 phone. Now you can watch your favorite videos at the gym, on the bus, or share them with friends. You'll have to first compress your video to about 400MB, format it, and use a card reader to move the files from your computer to your phone, but once they're on there, you'll never have to part with them again. The quality ain't so bad either!
Butterflies are beautiful, even when they aren't real, but merely decorative. In this video, learn how to rainbow glitter a butterfly with Barbara Trombley from Art Glitter. This is a fantastic craft project developed by Barbara. They're simple to make and you only need a few craftsy materials, like opals and card stock.
Go to the US Money Factory store to get sheet money http://www.moneyfactory.gov/ This is a a quick folding demonstration. It shows exactly how you would fold bills to make a billfold simple wallet with sheets of dollar bills. This will provide great camoflague for your money and credit cards.
This short video demonstrates how to make a simple flower press from common materials you can find at home: cardboard, paper, rubberbands. Pressed flowers are beautiful keepsakes or gifts. You can attach them to paper and make homemade cards.
In this hacker's how-to, you'll learn how to softmod your old Playstation 2 to enable you to run third party software and how to use CogSwapLoader and HDLoader to backup your PS2 games and play them either from a burned DVD or off your hard drive. This will let you hack the PS2 to play pirated games. Remember, pirating software is illegal! This will let you unlock your PS2 to play games if you copy them from somewhere else.
Learn how to build an environmentally friendly directional WiFi antenna with this simple video guide. To follow along at home, you'll need the following things: a copper wedge, an N-type connector, some screws, a clamp-on N plug, a pigtail, and a wireless card. You'll also need a drill, screwdriver, and soldering iron. For comprehensive, step-by-step instructions on hacking your own directional WiFi antenna from a tin can, watch this video tutorial.
Photo albums and cards can get to be a boring way to display or share photos. This tutorial shows you how to create a calendar out of your photos using iPhoto '08. Hang it on your own wall at work or home, or send it to grandparents and family members. You will have to pay for Apple to print and ship your finished product.
Create gorgeous, sparkly motifs and embellishments out of beads to give your greetings a bit of bling. Corinne Bradd shows how easy it is to combine stunning gems, bright sequins and coloured wire for a unique, eye-catching effect. The finished bead decorations can be applied to cards, tags or gift-bags.
Turn an old computer into a DVR that you can use to watch TV and record shows from over the internet using a TV card and free software.
These decorative paper butterflies make the perfect fall arts and crafts project and year-round ornament to decorate your home. Learn how to use a template, cut out the design, and then score it to give the butterflies their unique 3 dimensional look. You can also add this butterflies to a scrapbook or a personalized card.
This beautiful Kirigami captures the moment a hummingbird kisses a blossom. Just download, print, cut and assemble, it's easy. It's better than giving a card, it's giving a piece of art. Best of all, you can make them again and again. Download a pattern at http://www.easycutpopup.com.
Steve Spangler shows a science experiment in which a glass of water is able to suspend a card in mid air.
How to install nVidia graphics card video drivers in Ubuntu Linux 7.10.
Can you recognize the nuts after the flop in Texas Hold'em? If you are a beginner poker player this how to video is an excellent way to learn how to tell which poker hand is the best (the nuts) after the flop cards have been dealt. Learn to recognize the best possible hand and never be fooled again with this Texas Hold'em poker tutorial.
Learn a card trick that lets you find any card your spectator chooses based on the location of one upturned card in the deck (which you can use as a red herring in the trick).
The nose is the most prominent feature of the face, and cannot be obscured by sunglasses or hats like the eyes and hair. This two-part video will show you how to add detail to the nose of a 3D model of a human head using 3D Studio Max. You have to have a face already for this to really matter, but if you are up to the task of modeling a basic face in 3D, this video will help you make it look a lot better.
In this series of online video magic lessons you’ll learn how to predict the future using a variety of methods. Expert magician Joe Marshall reveals his secrets and demonstrates several cool and easy card tricks and number tricks, including three digit number prediction, odd number mind reading, and predicting a roll of the dice.
The Nokia Social hub is a fairly useful piece of software available to owners of the Nokia Booklet 3G netbook. From the Social hub, you can connect to facebook and access several of the social network's functions, including posting an update. If you have a SIM card inserted with an active 3G connection, you can even send a text message from the netbook.
If you hit the FN + F10 keys on your Nokia Booklet 3G, you'll see the available internet connections methods for your netbook including Bluetooth, wifi, and 3G.
We admit that 99% of the time we write notes wherever we can: On scratch paper, on post-it notes, and often times on the back of our hands. But consider how lovely it would be if you could whisper little nothings on these pretty notecards.
This video represents a union between two spheres of crafting - sewing and cardmaking. You can create some decorative stitching on your handmade greeting cards by using your sewing machine. Here's how you can sew on paper without ruining the paper or cardstock.
Now that Valentine's Day is only a month away, it's time to start thinking about how you're going to be surprising your sweetheart. While a bouquet of red roses and a box o' chocolates is always a good call, you can make your gift much more personal by adorning a package or a card with one of these origami roses.
What's this mysterious .thm file? Why are they cluttering up your SD card? Can they be safely deleted? This video has the answers! A .thm file is created specifically by Canon cameras when you're filming a movie, and this video shows you how to use your .thm files.
This video starts off by showing you how to complete this quest. Start in one of the casinos, and distribute four cards to different NPCs you can find on the Strip. The benefit of thsi quest is that it gets you more money!
For this tutorial to work, you will need the Homebrew channel already loaded onto your Wii, an SD card (preferably one with more than 64 MB of storage) and your chosen homebrew application. Then just follow the steps in this video to load your apps!
All you need is some stiff paper, like craft paper or card stock. Then follow this video to fold two pieces (make sure they are roughly the same size) into a lovely and easy gift box. Then wrap it and stick it under the tree!
The basket in this tutorial says 'Give Thanks', but you can always change the lettering and turn it into a place card instead. It's a mini basket that you can fill with anything, and give away as a favor or use as a table decoration.
For all of you who've snagged the brand new Samsung Galaxy Tab, this video will help you get started enjoying the full benefits of the Android tablet. See how to get started with the Galaxy Tab by inserting your SIM card and get a feel for the new features it comes equipped with.
In this video from ironman333333 we learn how to unlock an iPhone 3G. You need 2.2 firmware for this. Go into Cydia which you need for this. Go to the Manage tab. Tap into Sources, Edit, Add. Then type in atp9.yellowsn0w.com/ Then click add source. Then click Done in the top right. In sources look for the source you just typed in. Tap into that. Now Install Yellowsn0w. This will take a few minutes to download. Once downloaded, restart your iPhone. With your phone turned off, take the unlock t...
Squashini is a difficult boss to beat, found at the end of the Treat Land level in Kirby's Epic Yarn. He's a giant slot machine, but you can defeat him easily by throwing back the cards that he flings at you.
Here's a fun technique you can use to create a unique background for your next greeting card, scrap book or other paper crafting project. All you need is some bubble solution and a few drops of re-inker in your favorite color.
Everything's going HD these days, even blockbuster movies. So, make sure your editing system is up to date, because working with high-definition video footage is a pain if you don't have the right equipment. This video will show you how you can build the ultimate graphics and multimedia workstation with blazing performance for real-time HD video editing. Use a Nvidia Quadro FX4800 card with 192 cores and you're set!
In this tutorial, we learn how to draw Stitchpunk. Start out by drawing the outline of the entire body. After you do this, draw in the details of the feet and the hand. Next, start to draw in further details of the hands so you can clearly see the claws and the hand area. Once finished with this, draw in the details of the face. After you do this, you can erase any reference lines that you drew and fill in further details. Draw in any other details needed throughout the character, then erase ...
Are you taking your first trip to New York City? Intimidated because you're unfamiliar with how the subway system works? This video explains how to find a subway station, plan you route and get a metro card so you can find your way around Manhattan.
In this clip, you'll learn how to create a master-detail overview of data with the Silverlight DataGrid control. Whether you're new to Microsoft's popular web application framework or a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free MS Silverlight programming lesson. For more information, including a complete demonstration and detailed, step-by-step instructions, take a look.
Looking for an easy way to make certain that your sensitive personal information is secure? With Identity Finder, it's easy! So easy, in fact, that this home-computing how-to from the folks at TekZilla can present a complete overview of the process in just over three minutes. For more information, including step-by-step instructions, take a look.
