This video is a tutorial on how to create drop-down menus in Excel 2007. Select a cell on your spreadsheet and click on the “Data” tab. Go to the “Data Tools” section and select “Data Validation”. In the window that opens select "Allow" and choose "List". You will create a list of the values you want to allow. Type in the values, separated by commas, and click OK. Now you will see your selected cell has an icon to right that indicates there is a drop-down menu containing the value...
In this video, we learn how to cover up dark circles and blemishes using foundation. Start off by applying an eye cream underneath your eyes, which will make a base and remove puffy-ness. Next, you will need to apply your favorite concealer in your color over where you applied your eye cream. Go ahead and apply this foundation wherever you have blemishes, using a makeup tool. Now grab your favorite foundation and brush, and brush the foundation on your face making an even coat to cover and re...
Some computers might now have a working DVD drive and in such cases you can use a USB pen drive to install Windows 7 on it. To do this first connect the USB drive to your computer. Now go to the command prompt and run the 'diskpart' command to find the details of the hard drive. Use the 'List Disk' command to list all the drives on you computer. You can also find the USB drive in the list. Now use the Select disk command to select the disk. Perform a clean command of the disk. Next create a p...
Marie Dubuque offers tips on keeping a conversation flowing and avoiding awkward silences. She suggests asking the other person about themselves. Everyone loves to talk about themselves, and sometimes if you ask one question they go on and on. Ask about their favorite food, favorite restaurant, how they get along with relatives. Questions about in-laws can lead to some interesting dialog and can get the conversation going better than it was before.
In this tutorial, we learn how to make crock pot chicken fajitas. First, you will need 1 1/4 pounds of chicken, 2 onions, 3 cups salsa, crock pot, 1 large red pepper, 1 package of tortillas and your favorite condiments. First, chop up the onions and pepper into thin slices. After this, trim the chicken and cut it into thin slices. Now, you will take the veggies, chicken and salsa and place into a crock pot for 6 hours at low heat. Make sure you stir well to cover all of the veggies and chicke...
This video presents how to defragment and shrink a Windows Vista partition using Perfect Disk 2008 Professional program.First you need to download and install software application named Perfect Disk 2008.Type Perfect Disk 2008 into Google search engine, choose first link from the list.On the Raxco software home page choose Free Evaluation option from the list to the right.Download and install Perfect Disk 2008 Professional.Once it is installed, run the application. From Menu choose Analyze op...
In this demonstration, we learn how to make a phone call on the iPhone. 1. Tap the phone icon. 2. Tap the keypad icon. 3. Tap the number you wish to dial. 4. Tap "Call. "5. To end the call, tap "End Call. "6. If you wish to call one of your contacts, tap the "Contacts" icon, tap the contact and the number you wish to dial. 7. To call one of your favorites, tap the "Favorites" icon, and tap the contact you wish to dial.
This video shows you how to make a custom Facebook Fan Page for your favorite Celebrity, Club, activity or anything you choose! First thing you must do is activate a Facebook account. Its really simple, just go to www.facebook.com and create a profile. After that type in FBML in your search bar and click on Static FBML. That application will enable you to create many different settings for your Fan page including ads and different looks and security measures for your profile. Now get to creat...
This video shows us how to make a healthy artichoke guacamole. Prepare 6 cooked large fresh artichoke. Remove the hearts and bottoms from the artichoke and place in a medium-sized bowl. Mash it with a fork or simply use a food processor. Add the juice of a lime or a lemon, 4 tbsp of reduced-fat mayonnaise and 1/2 cup of fat-free sour cream. Put garlic, salt and pepper to taste and 1/2 cup of your favorite salsa. Blend all the ingredients. Finally, serve together with the artichoke leaves or y...
First you take a glass, then put 3 ounces of your favorite gin into it. Then, choose 2 of your favorite tea bags (and tea leaves if you want) drop it in the gin. Let this fuse together for 2 to 2 1/2 hours. Gin will turn a dark gray color when done fusing together. Grab a lemon wedge with a slit in it and rim the edge of a martini glass, the dip the martini glass into the granulated sugar to make a fine rim of sugar. Then take 1 1/2 ounces of Tea Infused Gin, 1 1/2 ounce of lemon juice and 1o...
Chances are that there are videos on YouTube that you wish you could download to your Mac or PC in order to transfer them to your iPod or other media player so you can watch them on-the-go. Whether it be your favorite music video or the new and hilarious comedy skit from your favorite comedians, this video will show you exactly how to do that, simply and safely in just a few steps. The video is only a minute and thirty seconds long, which is nothing compared to how many minutes you could be a...
Tank tops are relatively cheap, and cutesy bags can be expensive from designer shops and street vendors, so your only solution for saving money is… using your tanks for homemade bags. See how to transform a tank top into a magazine bag in this video from GiannyL.
This how-to video explains how to fix DVD/CD player related issues with error code 31,32 or 19 in the computer that is having either Windows Vista or Windows 7 as their operating system.
Are you a young aspiring actress? A triple threat? Many top singers and entertainers today got their start on the Disney Channel. In this video, learn how to get that audition with the Disney Channel... Who knows, it could be your big break!
If you want to stop telemarketers from calling, use this guide and try a multi-pronged approach. You Will Need
Herbs are an incredible addition to your garden. This week, Meg talks about some of her favorite herbs and shows us how-to make a new moon herb tincture! Follow along with the advice in this video gardening lesson and start incorporating fresh herbs into your cooking!
This week on Threadbanger , we have T shirt reconstruction guru Megan Nicolay on the show. Just in time for summer, the author of Generation-T gives us one of her favorite t shirt lessons from her world renowned book.Learn how to make a halter top in minutes plus a look at some Threadbanger viewer creations.
Paula and Bobby Deen create frozen pops from a ready-made cheesecake. Follow along and learn how absolutely easy these cheesecake surprise pops are to put together. This cooking how-to video is part of Paula's Best Dishes show hosted by Paula Deen. What happens when America's favorite southern cook opens up her kitchen to family, friends, viewers and the best home cooks in the country? It's anyone's guess! Paula Deen is cooking up something new as she rescues viewer recipes, shares stories an...
Paula combines two favorites, coffee and chocolate, in a yummy mousse. This cooking how-to video is part of Paula's Best Dishes show hosted by Paula Deen. What happens when America's favorite southern cook opens up her kitchen to family, friends, viewers and the best home cooks in the country? It's anyone's guess! Paula Deen is cooking up something new as she rescues viewer recipes, shares stories and traditions with friends and strangers alike, while learning the secrets of some of America's...
There are few projects that are so simple, and so immediately rewarding, as learning to play a favorite song on the guitar. Not only is it a wonderful way to pass the time but, by learning to play your favorite songs and riffs, you'll be better able to articulate (and otherwise translate) your musical ideas into great-sounding songs. In this guitar lesson, you'll learn how to play "Girls Got Rhythm" by AC/DC. While this tutorial is geared towards intermediate players, guitarists of all skill ...
Watch this how to video and let the BBQ Pit Boys show you how to barbecue up two tender and juicy 4lb. chickens on the grill, Beer Butt Chicken Style. This chicken recipe is super easy to do. All you need for this barbecue chicken recipe favorite is two cans of beer (or water if you must), salad oil dressing, 1 onion, salt, pepper, and any favorite basting sauce, such as our garlic butter with soy sauce. Fire up your grill to 325-350f, and in as little as 2 hours you will be dancing right alo...
Memory Loss is an app on your iPhone that you can use to help you remember things, like grocery lists or people's names. This tutorial shows you how to set up the app so you will become less forgetful as you play!
Block Facebook scripts on sites that you visit with Safari, Chrome and Firefox by installing an add-on called Facebook Blocker. This removes the "Like" buttons, "Recommended" lists and prevents Facebook scripts from tracking your browsing history. Veronica from Tekzilla Daily demonstrates the features of this new add-on.
Some film makers fall into a few pitfalls when working with a green screen. This video lists a few common problems, such as having your talent wear costumes in similar color keys or using uneven lighting, and how to avoid them completely.
Turkey is the focal point and A-list star of your Thanksgiving table, so it only makes sense to make the bird as delicious as possible, right? Eschew the tired method of roasting and basting your turkey in the oven for hours on end and try out a new method of cooking it this year: deep frying.
In our opinion, the best kind of curly hair is the kind that looks the most natural. So rather than tight ringlets that look like they've obviously been twirled around a curling iron, we're talking about loose, carefree waves that are slightly undone.
After a long dry spell, Katy Perry has officially breathed new life into multicolored hair extensions. Once only the playthings of prepubescent girls who thought it made them look all cool and rebellious like, extensions are now favored by several A-list stars.
A blind carbon copy (or BCC) is a way to send a mass email without letting your recipient see the other email addresses on your list. This computer skill is important in the business world, where privacy is prized. Hiding the addresses when sending your secret message is a useful technique you can use for any email program.
Learn how to easily create a CSS photo gallery with a unordered list and a little bit of CSS. Whether you're using a fancy WYSIWYG (or what-you-see-is-what-you-get) page editor like Adobe Dreamweaver CS5 or a barebones text editor like Notepad, if you want to build websites, you'll need to have some understanding of HTML (for the structure of your web pages) and CSS (for their style). And this free coder's guide will get you started along that path.
Absinthe and caviar have extremely strong, distinctive flavors that many folks can't handle easily on their own, but adrenaline rush connoisseurs will get a kick out of the recipe presented in this video. Combining absinthe with caviar, you'll make a distinctive tasting caviar.
Want to program your own Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will have you coding your own Java apps in no time flat. Specifically, this lesson discusses how to build a list of display modes. For more information, including detailed, step-by-step instructions, watch this helpful programmer's guide.
Want to program your own Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will have you coding your own Java apps in no time flat. Specifically, this lesson discusses how to use the Collection framework when writing code in the Java programming language. For more information, including detailed, step-by-step instructions, watch this helpful programmer's guide.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 41st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a true/false formula with the COUNTIF function to prevent duplicate entries in a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Looking for your next craft project? Look no further. This crafty person's guide will walk you through the process of making a custom felt flower pin with supplies from your local craft store and about 45 minutes of labor. For more information, including a list of necessary materials and step-by-step instructions for making your own floral pin, watch this free video tutorial.
Want to make your own electromagnet? It's easier than you'd think. It's so easy, in fact, that this video guide can present a complete and thorough overview of the entire magnet making process in just over two minutes. For complete instructions and a list of necessary materials, watch this free home science how-to.
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 249th installment in their series of digital spreadsheet magic tricks, you'll learn how to use Advanced Filter to extract records from a database (table or list) to a new workbook.
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 94th installment in their series of digital spreadsheet magic tricks, you'll learn how to use and link a currency web query to a data validation cell drop-down list for money conversion.
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.
What's more fun than a Go Kart? Here is a complete tutorial on how to make a nice Go Kart. Easy and fun. Its a good, solid Go Kart & it should take you 2 to 4 hours to make it. Go to Storm The Castle for a list of all the parts, more instructions and plans.
A short demonstration of using an electric chainsaw to split a large block of ice used for ice carving. This is a basic technique in ice carving. Boston-style ice tongs are also used. Demo by Dawson List IceCarvingSecrets.com He gives you the steps to making a block of ice the size you need to start carving ice sculptures.
