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 580th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the REPLACE, MID, COLUMNS and SEARCH functions to extract numbers to the right of a decimal into their individual cells.
This six minute video shows you how to sell your car on craigslist. First, go to craigslist.com and click on the nearest city (or country). Follow the links to list an ad for a car for sale. You will want to put the kind of car in the posting title because that is used in sorting search results. In the posting description it is important to be as specific as possible - again describing the car, giving some history of the car like if it has ever been in an accident and if you have had any work...
This instructional video Nehal Kazim from Site shows you how to make a complete Facebook fan page. Before creating a fan page evaluate the reasons of making a fan page. A fan page lets you connect with your future clients and fans and keeps them updated and gives them a platform to talk about your organization. To create a fan page go to the bottom of any page and click 'Advertising', select pages and click create a page. Select a suitable category and a suitable name make sure to select it c...
Veronica of Tekzilla shows you how to browse iTunes without launching the application on this episode of Tekzilla Daily. To check the availability of a specific song without launching iTunes go to URL given which is located on the Apple website and browse the artists that are available in the iTunes store. Although there is no search feature you can hover over a desired song. A play icon pops up; click it to hear a 30 second preview of the song. You'll have to launch iTunes if you want to pur...
Sometimes it can be difficult to find information essential to a citation on a webpage, like an author or a date. Here are some steps you can take to make up for this lack of information.
Want to turn an old ceiling into something new? Why not try a sunken or recessed ceiling look? Otherwise known as a coffered ceiling, create a more spacious feeling enviornment with this ceiling tutorial hosted by DIY home guru Ron Hazleton.
Sometimes pairing your mobile phone with your car is a difficult and unwritten chore to accomplish. But now with Ford's new SYNC system, you can easily pair your cell phone. It's as easy as pressing the Phone button. Let it search for already stored bluetooth devices, and if none are stored, simply press the Arrow buttons until you see the Add Bluetooth Device option. It's that easy!
Adobe Bridge -- why should you use it? That is one of the most frequent questions for Adobe Design users. Most don't even know what it is. This entire video explains some of the great reasons why you should actually use the Bridge. By the end of the video, you should be a die-hard Bridge user. Don't use the plain old regular file browser!
Check out these tips on the Adobe Bridge Center. Not only does the Bridge have excellent features for file browsing and file organization, but it also has the central area, consider it the hub, where you will find features that will further streamline your workflow. In this video tutorial, learn how to use the Adobe Bridge Center, which is a default favorite in the Favorites pane.
Here, see some tips on the collections and smart collections in the Adobe Bridge. Bridge has a lot to offer and is a great organization tool. Collections and smart collections are great workflow features available to you. In this video tutorial, learn about organizing your files without messing up your folder structure and automatically bringing files in that you want based on your settings you assign to that collection. Check them out and learn a great new feature of Adobe Bridge CS4.
Today, see how to use GoLive CS2 to create pure CSS layouts. That's using CSS to lay your website out, which is a really nice way to layout your webpages. It's laying it out without tables, and allows the site to change based on the users resolution. In this video tutorial, see how to create website layouts made entirely of CSS using GoLive's new CSS tools and the new liquid layouts available in GoLive CS2.
Using GoLive CS2, you'll learn how to create some CSS-based rollovers. This is really an easy way to create some rollovers, using CSS, which is an incredibly useful and powerful way to style and design your website pages. In this GoLive video tutorial, learn how to style not only your links, visited links, and active links using CSS, but you will also see how to give your links a rollover or hover style as well. You will quickly see how much more you can achieve by styling your links using CSS.
Wondering how to get that dropped shadow, smoky eye? In this tutorial presented by the experts at Smashbox Cosmetics, learn how to get that smoky effect on your bottom lids, while leaving your top lid clear, creating the "drop shadow effect". This wearable look is stylish, sexy and sleek perfect for big occasions.
Get a sexy rock 'n' roll look that would be seen on the likes of such stylish celebs as Katy Perry and Gwen Stefani. In this makeup tutorial hosted by the experts at Smashbox Cosmetics, get tips, tricks and secrets to achieving this look without paying for a stylist. With dark, deep lips and a black pussy cat eye applied to your lids, you'll be ready to take center stage!
Your wedding day is vastly important and every bride would like the wedding pictures to reflect how beautiful they felt that day. In this tutorial presented by Smashbox Cosmetics, learn how to get the perfect camera-ready makeup look, perfect for your special occasion.
Steal this look: The metallic smoky eye! With the help of Smashbox Cosmetics, this video goes through the step-by-step process of taking this look into your own home and making it your own. Using Smoke Box from Smash Box, a metallic smoky is born that will leave you look sultry and sexy for your next special event.
Looking to emulate the vixens of the 20's and 30's? In this makeup tutorial hosted by Smashbox Cosmetics, embrace your inner vixen with these tips and tricks on how to steal this look with your makeup. With a clean face, a natural matted eye with nude shades, and a dark winged out liner, you'll be channeling Betty Page in no time!
Embrace your sassiness with a sexy, smoky cat eye with the use of your makeup. In this short how-to video presented by Smashbox Cosmetics, learn how to get that seductive look with some help from the makeup pros.
Nothing is more beautiful than a girl with naturally pretty skin, without all the help of the makeup... but who are we kidding? Everyone needs a little touch up and color up to make them look alive and well! In this makeup tutorial presented by Smashbox Cosmetics, learn how to get that fresh, natural look with your makeup.
Get that very "right now" green smoky eye with some help from the professionals at Smashbox Cosmetics. By starting with cream liner Midnight Green and applying little smudges along the line, go back to smudge with your brush to create a smoky effect. Stand our this fall with vivid color and this soft, not-so-innocent makeup look.
This spring, go with a lighter look and keep it sweet & simple. Dewy skin, luscious lashes and lightly stained lips & cheeks will up your ante, leaving you feel beautiful and ready to strut your stuff this spring.
Upgrade your look this spring with these makeup tips inspired by the sexy style featured on the television show, Gossip Girl. Bronze your skin, add golds to your eyes and contours, and apply a high shine peachy gloss to your lips to achieve this sexy look for your next big outing.
Want to learn how to get that high fashion kind of smoky eye you see on the fashion runways? Smashbox Studios has a new name for it and it's called the "Smoldering Eye". The smoldering eye is a more diffused version of the smoky eye, with less definition. In this video, learn step-by-step, how to get that beautiful, sultry look with a little help from our friends called: the professionals.
Shatter glass with your mind!… Um, no… with speakers! This little video shows you how to shatter wine glasses with your own speakers. Yep, those normal, everyday home speakers that you have can break a wine glass just like a jackhammer.
The trucker's hitch is a good, strong knot with many uses. It's ideal for securing a load in a vehicle, and was used that way dating back to the days of wagons hauled by horses. In this video the folks at ITS Tactical teach you how to tie a trucker's hitch, quick and easy.
You're a prisoner of some dangerous people, and they tell you to hold out your wrists so they can bind them together using zip ties. What you do next could mean the difference between life and death. This tutorial from the folks at ITS Tactical will teach you how to strategically get your wrists tied in a way that's easy to escape from.
You've been captured, and your wrists are bound together with zip ties. Fortunately you prepared for this situation, and you have a bit of 550 cord in your shoe. Using the cord, you can escape the zip ties using the friction saw method. This tutorial from the folks at ITS Tactical will teach you how.
The odds are that you'll never find yourself being held prisoner with your hands bound together with zip ties. But if you ever are, you'll be very grateful for the info you learned from this video. In this tutorial from the folks at ITS Tactical, you'll learn how to escape from zip ties using shims. You can use all sorts of things for shimming, from professional equipment to your own fingernails.
You're being held prisoner, and your hands are tied behind your back with zip ties. You're helpless to escape… Or you would be, if you hadn't watched this tutorial. The helpful folks at ITS Tactical explain how you can quickly escape from zip ties tied behind your back.
Zip ties are stronger than they look, and escaping from them is tricky. In this tutorial from the folks at ITS Tactical, you'll learn how to quickly escape from zip ties. If you should ever find yourself kidnapped by terrorists, held for ransom or kept prisoner in a serial killer's basement, you'll be very glad you watched this video!
You're underwater, and you need to tie a knot. (Hey, it could happen!) What do you do? In this tutorial from the folks at ITS Tactical, you'll learn how to tie a right angle knot. This is a knot used by navy SEALs, and if you ever end up needing to tie a knot underwater, you'll be very glad you watched this video.
Make-up artist/costume extraordinaire, Kandee Johnson recreates the look of the beloved spunky little fairy from Walt Disney's Peter Pan, Tinkerbell! Complete with blonde wig, spirit gum, glued "pixie" dust... and loads of green eyeshadow!
In this tutorial, make-up artist, Kandee Johnson shows how to get Walt Disney's Snow White look down next Halloween! The following products were used of achieve this look: Ruby Woo lipstick by MAC, Chesnut lipliner by MAC, Lise Watier Concealer, false eyelashes, any white eye shadow, Copperplate eyeshadow by MAC, Cork (warm brown) eyeshadow by MAC, rice paper by MAC, and liquid black eye liner.
Watch as amazing make-up artist, Kandee Johnson transforms herself into Barbie with this step-by-step tutorial on how to apply the make-up and look of this famous blond bombshell doll! The following eyeshadows were used to achieve this look: MAC in Pen & Ink, Da Blng, Carbon, Vibrant Grape, Indian Ink, Fig 1, and Deep Damson. LARENIM mineral eye shadows in Bedazzle & Lust and Urban Decay's eyeshadow in Grifter were also used. Additionally used: Hot pink blush as eye shadow, Make-Up Forever ho...
Systm is the Do-It-Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. In this episode, you'll learn how to make ice cream in udder a minute, using the wonders of liquid nitrogen. (You will also learn how to do this safely, so you don't risk giving your fingers a case of instant frostbite.)
In this episode of the popular web series Systm, you'll learn how to make your very own lightsaber prop from the "Star Wars" movies. Many of the components are surprisingly simple - old flashlights, windshield wiper blades, etc. But when you them together, you can have an effective prop for a lot less than you'd pay for a reproduction.
In this episode of the popular web series Systm, RoboGames founder and SFSU School of Engineering instructor David Calkins shows you how to create your own combat robot using a kit from RoboGames.
These Apple Shake 4.1 tutorials shows you the basics how to use the Stabilize Node in Shake 4.1 for match moving. Apple Shake 4.1 is a high-end compositing and visual effects package, which can help you make your graphics look as professional as possible. This tutorial also shows you how to use Shake 4.1's color correction to make the image blend. For more advice on using Apple Shake 4.1, search for Shake 4.1 on WonderHowTo.
If you want to transfer files to or from your iPhone at ease, check out this video on how to SSH / SFTP into your iPhone. SSH (Secure Shell) and SFTP (Secure File Transfer Protocol) all can be used to safely transfer files to your iPhone!
Systm is the Do It Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. We will help you avoid pitfalls and get your project up and running fast.
