Extract Receive Search Results

How To: Extract seeds from tomatoes

If you've grown tomatoes from seed, perhaps you've wondered how the seed company extracts those seeds. In this episode of Growing Wisdom, Dave Epstein walks you through a process known as sluicing. Using sluicing, you can extract vegetable seeds yourself.

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: 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 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: Send and receive text messages in Gmail

Want to know how to send and receive SMS text messages from your Google Gmail account? It's easy. So easy, in fact, that this home computing how-to from the folks at CNET TV can present a complete (and somewhat talky) overview of the process in just over a minute's time. For the specifics, watch this handy how-to.