Guild Extracts Search Results

How To: Turn a flashlight into a laser

Kipkay demonstrates how to extract the laser from a DVD burner and mount it in a small flashlight to create a handheld laser burner that can light matches and burst balloons, all in this how-to video. All you need is a 16x DVD burner, a laser housing, and a flashlight. Watch this video tutorial and learn how to modify a flashlight into a relatively strong laser.

How To: Reverse first & last names by formula in MS Excel

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 292nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first and last names from an Excel spreadsheet and rearrange them using a formula.

How To: Make a delicious hot chocolate mix

This hot chocolate mix recipe from chef Jason Hill is a decadent Valentine's Day treat or winter drink. Hot cocoa is a hit for adults and children alike. The ingredients are milk, chocolate chips, vanilla extract, whipped cream, and chocolate shavings. Learn how to prepare this sweet cocoa drink by watching this video beverage-making tutorial.

How To: Extract inconsistent name & e-mail data from a one-column list in Excel

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 712th installment in their series of digital spreadsheet magic tricks, you'll learn how to take bad data set up in one column and make a proper table of data for a mail merge as well as how to extract name and e-mail data from a list in one column where records are entered inconsistently.

How To: Extract records with an advanced filter in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 95th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the OR, AND, NOT, & COUNTIF functions and Excel's advanced filter tool to extract records from a table of data. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Extract the top 5 values from a given list in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 40th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the filter and advanced filter tools to extract the top 5 values from a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Sort and extract by cell color in Microsoft Excel 2007

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 33rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to sort by color in Excel 2007 as well as how to use the copy and paste tools to extract records. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Make coconut cupcakes with cream cheese frosting

Pat and Gina Neely show us how to make delicious coconut cupcakes with cream cheese coconut frosting. Start by mixing the butter and sugar together well. Then add the eggs, vanilla, coconut extract and buttermilk. In a separate bowl mix the cake flour, baking powder, baking soda and salt. Add the dry ingredients into the wet ingredients, and finally some coconut flakes. Blend all the ingredients well but don’t overbeat.

How To: Extract a unique list from a huge data set in MS Excel

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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter tool with criteria to extract a unique list of employees for each department from a huge data set with transactional records.

How To: Use an advanced filter to extract table data in Excel

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 244th installment in their series of digital spreadsheet magic tricks, you'll learn how to use advanced filtering to extract records from a database (table or list) based on 1 criterion (criteria) and place reesults on a new sheet worksheet.

How To: Group duplicates & extract unique records in MS Excel

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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.

How To: Make pomegranate juice

In this video, Sheba is demonstrating how to make pomegranate juice. She is mixing the juices of pomegranate and oranges. It is just an option. If you want you can drink pure pomegranate juice also. Pomegranate is very good for heart and has cancer fighting abilities. So pomegranate juice is a very healthy drink. You have to cut the pomegranate into two halves and then extract the juice in a citrus juicer. Further you can also extract juice out of oranges and have a mix juice ready. If you pr...

How To: Unzip a file with Microsoft Windows XP

This video from scrapwow shows how to unzip a file in Microsoft Windows XP.Firstly, open Windows Explorer application and navigate the file you want to unzip. Once you've located the file, double click on it. A new window will open. Here you will have Extract all files option which you can choose from menu to the left.Clicking the button allows you to extract a single file or a zipped folder, containing a number of files. In this case Extraction Wizard will open, leading you through the extra...

How To: Get rid of ugly scars

Scars can make you feel self conscious. Luckily, there are steps we can take to reduce their appearance without surgery. So, avoid the operating room and check out this video - its full of useful tips for hiding and eliminating your scars.

How To: Make fake blood

In this video, we learn how to make fake blood. Ingredients are: water, corn starch, corn syrup, red food coloring, green food coloring, and peppermint extract. First, you will need to mix in 1/3 of a bottle of water with the corn starch and corn syrup. Add in ingredients until it's the consistency that you want it to be. Then, drop in some red food coloring and mix it together. After this, add in the green color until it's the color of blood that you would like. From here, add in some pepper...

How To: Make fortune cookies from scratch

In this tutorial, we learn how to make fortune cookies from scratch. You will need: 2 large egg whites, 1/2 tsp vanilla extract, 1/2 tsp pure almond extract, 3 tbsp vegetable oil, 8 tbsp flour, 1.5 tsp corn starch, 1/4 tsp salt, 8 tbsp sugar, and 3 tsp water. First, write out your fortunes on small pieces of paper. After this, heat the oven to 300 degrees and grease two baking sheets. From here, combine all of your dry and wet ingredients, then combine them both together. Spoon the batter ont...

How To: Make Toasted Rice cereal puppy chow

In this tutorial, we learn how to make toasted rice cereal puppy chow. You will need: 9 c toasted rice cereal, a spoon, powdered sugar, 2 caps of vanilla extract, 1/2 stick butter, 1/2 c peanut butter, 1 c chocolate chips, and three bags. First, pour your cereal into a large bowl and then combine chocolate chips, peanut butter, and butter in bowl. Then, microwave the mixture for a couple minutes until it's melted, stirring every few seconds. After it's melted, pour into your bowl of cereal an...

How To: Extract sodium to make sodium metal

In this video, we learn how to extract sodium to make sodium metal. First place soup can in a pot of water and place the sodium mixture into the can. Place a cap on top and leave it on while the can is cooling off. It should create a tight seal until you will be able to open it. Once you can open it, pour mineral oil on top of the sodium. Filter out this mixture to find the chunks of sodium that is in the mixture. While wearing gloves, take out the sodium and place it into water to see if it ...

How To: Use the Magic Extractor tool to extract an image in Photoshop Elements

Have you ever tried to erase the background on an image so you can use the object image to layer with another document? You can do it in Adobe Photoshop, but if you don't know what you're doing, it could take hours… days to extract that image you want. But with Photoshop Elements, there's a handy tool called Magic Extractor that helps you get some of the dirty work out of the way, so you can concentrate on the finer details. Watch this video to see how it's done.

How To: Open RAR & ZIP files

In this video tutorial, viewers learn how to open RAR and ZIP files. This task is very easy, fast and simple to do. Begin by downloading the 7-Zip program. Then open the downloaded file and follow the instructions to install the program. Once installed, right-click on the zipped file, go to 7-Zip and select Open Archive or Extract Files. Once opened or extracted, users will be able to access the zipped content. This video will benefit those viewers who have received or downloaded a zipped fil...

How To: Make a orange, strawberry, banana, and lime smoothie

There are a lot of different fruit smoothie recipes out there. This particularly delicious-looking recipe includes the traditional smoothie fruits strawberries, bananas, and oranges, with a bit of lime and salt to give it a bit of a kick that many of the other recipes out there lack. Cool yourself off and get healthy at the same time with this delicious recipe.

How To: Use the cPanel CMS to upload files to your website

NeaceDesign explains an easy method of setting up a website online without having to use FTP programs. He begins with correcting an error made previously in which the main web page was name 'Home'. This should be renamed to 'Index' and the file re-exported. NeaceDesign suggests going with well-known web-page hosting services such as 'hostmonster'. The first step is to go to File Manager and upload the image files to a new folder. This is done by sending all the files to a zip folder and then ...

How To: Extract the nth word from a text string in Excel

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 559th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the first, last or nth word from a text string using Excel's SUBSTITUTE, LEN, SEARCH, REPLACE, LEFT, RIGHT and MID functions.

How To: Extract first, middle, & last names in Microsoft Excel

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 562nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first, middle and last names when the list contains names where some have a middle name and some do not using the LEFT, SEARCH, LEN, SUBSTITUTE, LEN, MID and IF functions.

How To: Extract dates and times from a database field in Excel

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 312th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the DATE, MID, LEFT and TIME functions to extract dates and times from a database field that stores dates and times as a text string.

How To: Make sticky toffee bread pudding

This video illustrate us how to make sticky bread pudding. Here are the following steps: Step 1: The ingredients required for te pudding are boiling water, chopped dates,soda ,vanilla extract,margarine ,brown sugar,ripe banana, baking powder,plain flour.

How To: Extract records from non-blank fields in MS Excel

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 152nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter and a TRUE/FALSE formula in a column to extract records that contain a non-blank value in a specified field. (column).

How To: Get ESET Nod32 or Smart Security Forever

In this video you will learn how to Get ESET Nod32 or Smart Security forever. First make sure you have the trial for ESET Nod32or Smart Security. To do this go into the description of the video, download that file and put in the trial username and password. The downloaded file its called ESET Box4Ever.Before you extract the file open your ESET window and press F5.Uncheck self defense and restart computer. After you restarted the computer extract the files from ESET Box4Ever and run the file, ...

How To: Get the copy and move to folder function in Windows

Steps taken to get the Copy to and Move to folder function in Windows 7 are:1. Go into the description and click the download link, to download the files2. After downloading the registry file you will see a zip file, which you need to extract using the software called Win Zip.3. After extracting the zip file, you will see two registry file (copy to and move to) execute both the registry file and give Yes, so that the file gets installed successfully.4. After successful installation, it is rec...

How To: Extract the top five records from a table in Excel

New to 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 Excel tutorial from ExcelIsFun, the 273rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the top (i.e., max high) 5 values and their associated names from a column allowing for duplicates. This is accomplished with recourse to Excel's TRANSPOSE, COUNTIF, MAX, INDIRECT, IF, COLUMNS, INDEX, SMALL and ROW functions.

How To: Make honey butter

This tip provided by The Food Channel shows you how to quickly make some delicious honey butter. To make some great tasting honey butter, do the following: You will need a 1/2 pound of butter, 1/8 cup of honey, 1/4 teaspoon of vanilla extract and some cinnamon to garnish. Slice the butter into small cubes and allow to warm to room temperature. Whisk until creamy. Add the honey to the butter and mix well. Pour in the vanilla extract and blend. Spoon the butter into a ramekin and sprinkle with ...

How To: Make Windows 7 look & feel like Mac OSX

So you bought a PC and now you want a Mac... You don't necessarily have to shell out the couple thousand bucks it takes to buy a new Mac. In this tutorial, learn how to make your Windows 7 operating system look & feel like a Mac OSX operating system. To complete this tutorial, follow these steps:

How To: Zip and unzip files in Windows XP

In this video tutorial, viewers learn how to unzip and zip files. The ZIP file format is a data compression and archive format. To unzip a file, right click on the file and select "Extract All". Continue by pressing "Next" and wait for the file to extract. To zip a file, right click on the file, select "Send To" and click on "Compressed (zipped)" folder. This video contains voice narration and a visual demonstration for viewers to easily understand and follow along. This video will benefit th...

How To: Easily download FLV video from within Firefox

This tutorial video is extremely short and to the point. The author of the video ( Fattwam) will show you the quickest and easiest way to download a video grabber program that will be able to extract videos from YouTube or your favorite online video website. The program being downloaded is a plug-in (Mozilla Firefox Add-on) called Video Downloadhelper. This plug-in will add an icon into your Mozilla Firefox browser. Fattwam then shows you how to utilize the plug-in to extract your favorite vi...

How To: Make a key lime pie martini

This video illustrates how to make a key lime pie martini and the ingredients needed. Ingredients: 2 oz vanilla vodka 1 oz Midori liqueur 2 oz pineapple juice 1 cup whipped cream, dash of almond extract, fresh lime wedge, crushed vanilla wafers procedure: Take a martini glass. Put some ice cubes in the cocktail shaker. Add 2 oz of vanilla vodka in the shaker and 1 oz of Midori liqueur, then add 2 oz of Pineapple juice. Shake the cream before use and spray it in the shaker. Put a dash of almon...