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 187th installment in their series of digital spreadsheet magic tricks, you'll learn two different array formula types for creating a unique list of items for a large list containing duplicates.
The only people who should read your emails are you and your intended recipients. Protect your privacy with this simple crytography guide, which shows how to obtain a free certificate for signing and encrypting email messages, how to download and install the certificate on Mac OS X 10.5, and how to use the newly installed certificate in Apple Mail.
This is a video tutorial showing its audience how to install Super Nintendo onto an Ipod Touch or an IPhone. The first step is to open Cydia and click on packages. Scroll down and click on Open SSH, install the program and then open it. Then go to games and you can install the Super Nintendo application. Next install SSH Client on your computer and open it. Next plug your IPhone/IPod into your computer and transfer your Super Ninentdo game onto your IPhone/IPod. When you are finished transfer...
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 381st installment in their series of digital spreadsheet magic tricks, you'll learn how to merge two lists into one list while keeping unique items from list 1 and list 2 and removing duplicates.
In this Computers & Programming video tutorial you will learn how to update websites from Firefox with the FireFTP add-on. Go to the Firefox add-ons page, search for FireFTP, add it to Firefox and install it. Restart Firefox to activate the add-on. Go to tools and click on FireFTP and that will open up a new tab with the FTP client. To configure the FTP to your account, create a new account by giving it a name. The host will be your domainname.com and use the login and the password for the ho...
What better way to display flowers in your home than in an adorable personalized vase? In this tutorial, learn how to make a flower vase with your kids and make a unique centerpiece for any table. Your kids will have fun with this project and will delight in seeing their masterpiece on display for everyone to admire. So let's get crafting, shall we?
In this tutorial, Kameron Kay, expert jewelry designer, demonstrates how to make a stretch bracelet using extra beads. This is a quick and easy piece of jewelery that anyone can make. Watch this video for tips on how to turn those extra beads into something unique. This bracelet makes both a great gift and a wonderful fashion accessory.
A cool way to accessorize your scrapbook is with distressed ink. In this tutorial, learn how to take beautiful inks from the folks at Stampin UP and distress them for a very cool effect.
Fall is coming and in this tutorial, learn how to use those pesky pine cones in your yard and make something very unique for your home decor. In this video, learn to put together a crafty wreath out of pine cones.
Looking for a unique Christmas decoration? In this tutorial, see just how easy it is to make a wreath out of Christmas ball ornaments. This video makes it incredibly easy to do and you will be able to craft a beautiful hanger in no time. No other homes on the street will have a wreath that looks this shiny and one of a kind.
Looking for a quick but unique snack? Try this on for size. In this video learn how to make Indian style chips out of classic tortillas. These snacks are fresh, healthy and quick and sure to please everyone you serve them to. Enjoy!
Learn from Dawn of Stampin' Up! how to make a paper bead for either decoration or for a homemade necklace! You can make these beads out of newspaper, magazines, or designer paper. Get creative this weekend and make a pile of paper beads to create a unique jewelry piece perfect for any crafter.
Some data can be very confidential. In such case you need to encrypt the data so that it does not go into the wrong hands. There are lots of encryption software available to encrypt the data. But to use them first you need to install then and this can take lot of time. You can also use Windows built in compression client to encrypt information. To use this feature you need not install any software and it is a fairly simple process. So select a file that you want to encrypt, right click on it ...
This video tutorial from JdudeTutorials presents how to download a torrent for the first time.To start, open your Internet browser. Browse to utorrent web page.Download and install uTorrent client version, suitable for your operating system (MacOS or Windows).Once you've installed application, browse to The Pirate Bay.This is the largest torrent source in the world.Check Video option under the search bar and type family guy (as an example).Click Enter. A list of torrents connected to family g...
Torrents are a wonderful technology to share your files over the internet. If the data that you are sharing is confidential you may need to encrypt these files before sharing. To encrypt torrents in Azereus, go to tools and select options. From the left hand side menu select the connection option. Select the 'Transport Encryption' option from the connection sub menu. This section is intended for intermediate mode or higher and it is not available in beginner mode. So go to mode and select the...
In this video Mr.G puts a new spin on magnets and bare copper wire with just a simple battery. Motion via magic? Not quite, but pretty darn close! Join Mr. G, and build your own motor with its own unique new spin. This is a fun, easy, do it at home experiment.
Nick from Greyscale Gorilla explains how he did a certain timelapse technique in conjunction with certin in-camera effects for the "Every Photo Shot for the Conan O'Brien Title Sequence" video.
This is a fantastic tutorial for creating a very unique coffin-shaped purse from cardboard. In a few easy steps, you'll be rocking the coolest non-designer, DIY purse on the street.
Enabling Telnet in Windows Vista is a little bit more difficult than its predecessors but it still can be done. This video will demonstrate exactly how to enable Telnet in Windows 7 and Vista.
This is a presentation of how to face toughest interview questions. During most of the job interview, the interviewer is trying to find out your capabilities if the job. They want the client to explore why they want to be working here. They know that you want a job. But more specifically they need to know why you want to work in their firm and also your capabilities. So, you must be prepared to answer for this common question for most of the interviews. First of all you should understand why ...
When people go to your Facebook page they are automatically sent to your wall. If you have a landing page you have an opportunity to: introduce who you are or what your business is about, have an opt-in area for a newsletter or email list, and give a call to action to become a fan! Learn how to use the Facebook application "Static FBML" to create an exciting and attractive landing page. This video contains everything you need to know to leave a lasting impression on your friends, colleagues, ...
In this video, the instructor shows how to use Outlook Express in Windows XP. This software comes bundled with Microsoft Windows XP, which is a part of Microsoft Office package. Outlook is an e-mail client that allows you to view your e-mails on your computer without the help of any web interface to your mail host. To use Outlook Express, you need to configure it first. Open the Outlook Express program. Outlook will then take you through a wizard to help you to configure your email host. Ente...
dubstepfm brings you this instructional video on how to create a peace sign design using tie dye techniques. Your host for this video takes you through the entire process from laying out the peace sign design on your shirt, to how to fold the shirt and band it properly to create this unique look. Whether you are an experienced tie dyer, or a newbie to the art, you will appreciate the level of detail dubstepfm provides in this great how-to video.
So now that you've read your Wired cover to cover (And back again) what are you going to do? You're going to turn it into a photo frame for your favorite geek! Just follow the steps in this video and you'll have your very own unique photo finish.
Have you ever wondered how to make a brochure in Microsoft Word? Is your job requiring you to learn how to create a brochure in Microsoft Word? This tutorial will teach you step by step how to find templates online, transfer them into Word, and how to open the blank template in Word. This will enable you to create a successful brochure with a highly professional look to give to your clients. This step-by-step tutorial is guaranteed to tell you everything you need to know about creating brochu...
Chrischee explains to us why the first take went wrong. Then he goes on to give us detailed instructions on how to prep the hard boiled egg in order to be able to blow the shell off. Make sure to pay close attention as he cracks a hole at the top and bottom of the egg. Kids will enjoy this unique way of getting the egg shell off a hard boiled egg.
No breakfast is complete without the hollandaise sauce! This sauce makes a delicious eggs benedict, and can also be used on many different dinner dishes. Check out this tutorial for a step by step on making this creamy sauce. In this tutorial, we will be using emulsifying butter and yolks for a unique taste. Enjoy!
This video is for those of you looking for unique and different styles to paint your finger nails with. The author takes us through the entire process to create a fantastic looking United States flag on our nails, just in time for Independence Day! From starting with a red base, adding the stripes and even creating actual stars on your nails with the appropriate nail brushes. What a great way to show your patriotism, love and support for Old Glory!
This video shows you how to combine two unique photographs in Adobe Photoshop. Using the mask tool, you can define the level of blur and blending between the two photographs. This is great for slick, professional quality composites.
Using a potato peeler on ceramics is fast, simple and gives your piece a unique look. While your pot is still soft, take a potato peeler and "peel" your pot in small sections working around the pot. You don't want to press too light or too firm, it might take some practice. Keep your cuts random to add to the charm.
Anime is a unique drawing style, whose origins are based in Japan. In this video tutorial, you will be taken through how to draw anime boys.
Looking to change your iPhone's magnifier? In this hack tutorial, learn how to make your iPhone look more unique with your own personally-picked iPhone magnifier from Cydia after jail breaking your iPhone.
Are you a makeup artist with a messy makeup station? Many pro makeup artists are looking for the answer to the best set-up to achieve quick turn-over on brushes, specially when working with multiple clients or models. Koren from EnKoreMakeup shows us how he organizes his makeup brush station for hectic gigs with the mission to help!
Stick Figures, a Jerk dance crew, show JusJerk their famous variation of the Stick Walk by mixing an older move known as the "Clown Walk" with "the Reject". Quickly going through a step by step instructional, study fast to steal the Stick Figures' unique family recipe.
Twitter has consumed the world, so make sure you're up to date on your Tweets. One way to do that is with Gwibber 2.0 on Ubuntu Linux, the computer operating system that could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to retrieve unlimited tweets with Gwibber 2.0 on Ubuntu Linux.
Changing the hold music piped into your company phone is a prank some callers will appreciate—depending on what you replace it with.
Learn how to apply makeup to create dramatic white and gold eyes with Lauren Luke's tutorial. This unique Arabic-inspired look is sure to turn heads. Watch this video if you want to look like an exotic Arabian princess.
Hak5 isn't your ordinary tech show. It's hacking in the old-school sense, covering everything from network security, open source and forensics, to DIY modding and the homebrew scene. Damn the warranties, it's time to Trust your Technolust. In this episode, see how to install a Wii homebrew hack using the Twilight Hack.
Hak5 isn't your ordinary tech show. It's hacking in the old-school sense, covering everything from network security, open source and forensics, to DIY modding and the homebrew scene. Damn the warranties, it's time to Trust your Technolust. In this episode, see how to secure remote desktop.
Dawn Wells, aka Mary Ann from Gilligan's Island, demonstrates a unique way to peel an Idaho potato...without the use of a potato peeler! Watch this video tutorial from Idaho Potatoes to learn how to use a knife to peel a potato, but not just a knife... you'll boil the potato then dunk it in ice cold water. Then the peel just slides off!