Cordyceps Extract Search Results

How To: Unzip a file in Microsoft Windows 7

In this video tutorial, viewers learn how to unzip a file in a Microsoft Windows 7 computer. Begin by going to a website that you would like to download the file from. Right-click the link and select Save Link As. Selection the Desktop as the save destination and click Save. On the desktop, right-click the on the zipped file and click Extract All. Now click Extract. A new folder with the same folder name is now created. Inside the folder is the desired file. This video will benefit those view...

How To: Make almond biscotti

Biscotti is a tasty afternoon snack and also goes great with a steaming cup of coffee. Learn how to make almond biscotti at home. You will need almonds, baking powder, salt, flour, sugar, eggs, vanilla extract, and almont extract. Happy coffee break. This is an Italian snack.

How To: Extract audio from CD with Sony Vegas Movie Studio

In this tutorial, we learn how to extract audio from CD with Vegas Movie Studio. First, open up Vegas Movie Studio and open up the audio from the drive you prefer by going into "project" then "audio cd". Once you do this, a new window will pop up showing all the different audio tracks that you can open. Play them before you open them, then when you find it click "ok" and then save it to the place it suggests. Now that selection will show up in your media pool, put this on your timeline. After...

How To: Make cotton candy without a machine at home

Okay, so just as a safety precaution before you dive right in and make yourself a batch of cotton candy at home, remember that melting sugar and corn syrup requires very high temperatures, so you could get burned if you're not careful. Make sure you keep a bowl of cool water next to you at all times just in case any of the hot stuff gets on your skin.

How To: Extract records with 1 criterion via Excel's AGGREGATE

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 670th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with one criterion. This is a lookup problem where you want to return multiple records from one lookup value. This formula is not an array formula because it...

How To: Extract records with 2 criteria with Excel's AGGREGATE

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 671st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to create a formula for extracting records with two criteria. This is a lookup problem where you want to return multiple records from two lookup values. This formula is not an array formula because it...

How To: Extract the word that occurs most frequently 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 592nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract word that occurs most frequently from a column of survey results that contain customer preferences for a product using the INDEX, MATCH, MAX and COUNTIF functions. This is a way to get the MODE for data that is made up ...

How To: Extract only numbers from a text string array forumla

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 489th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract only the numbers from a text string. This is accomplished with recourse to Excel's LEN, INDIRECT, ROW, MID, ISNUMBER, INDEX, LARGE, SUMPRODUCT, and SUM functions.

How To: Extract digits to the right of a decimal 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 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.

How To: Extract data to a new Excel workbook by array formula

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. With this video tutorial from ExcelIsFun, the 308th installment in their series of digital spreadsheet video tutorials, you'll learn how to extract data to a new workbook by array formula. Functions used include IF, ROWS, INDEX, TEXT, ROW and SUMPRODUCT.

How To: Create a studio background in Photoshop

This video by photoshopuniverse shows you how to make any photo seem as it was taken in a studio. Take the working photo and add a new layer over it and fill it in black as shown. Add a newer layer over that and add the filter> render> clouds effect. Increase the opacity of the cloud layer and merge it with the black layer as shown. Add the splatter effect and the sprayed stoke effect as shown onto the merged layer and add a hue and saturation adjustment layer and colorize it as desired. Go t...

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: 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: Ditch the Extract & Get Serious About Baking with Vanilla Beans

Most home bakers rely on vanilla extract as a flavor component to their cakes and cookies, but little do they know what they are missing until they trade in their extract for whole vanilla beans. The rich complexity and different notes of flavor of a true vanilla bean are often washed out and distilled into a one-note sweetness, especially if the extract is cheap or imitation. If you want to get more serious about baking, you need to get serious about using vanilla beans.

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...