Favourite Designers Search Results

How To: Play "Odd" by Julia Nunes on a ukulele

Want to play "Odd" by YouTube ukulele senstation Julia Nunes on the ukulele? Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing Juli...

How To: Play "Sweet Child of Mine" on the ukulele

Want to play "Sweet Child of Mine" on your ukulele? Of course you do! Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing this classi...

How To: Play B.O.B's "Nothin' on You" on ukulele

Want to play B.O.B.'s "Nothing on You" on the ukulele? Learn how with this free video ukulele lesson. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing "Nothin' on You" on your own uke, watch this...

How To: Add album artwork to iTunes music

Almost anybody who owns an Apple product, especially an iPod or iPhone, has iTunes downloaded on their computer. It's a great piece of software that gives you easy access to all your favorite songs, shuffles your music in certain categories, and even updates you on the latest music out. But when it comes to downloading music from another source that is not iTunes, certain information may be missing. In this particular case: album artwork. It's nice to see what the album is playing without hav...

How To: Get rid of a soar throat with a home remedy

Sore throats are terrible, aren't they? You can't talk, you can't swallow and even eating your favorite comfort foods is painful. If you are looking for an all natural way to clear up that scratchy throat fast, check out this tutorial. In it, you will learn a very simple home remedy than anyone can do. You will need to take this elixer once a day, around bedtime. Get well soon!

How To: Use your PS3 controller on your PC

Face it, playing your favorite games on the PC can be sometimes difficult. The most annoying things about PC gaming is the fact that most of the time you're using two different tools to control your character in the game. Using a single controller like the PS3s would be much easier, right? Well if you said yes, this tutorial is exactly what you need. Find out how to use your PS3 controller on your PC. Enjoy!

How To: Find mean, median, & mode (averages)

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 34th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use MEAN, MEDIAN, MODE. These measures give us a typical value, a measure of central tendency one value that can repr...

How To: Find outliers using the Z-score method

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 49th installment in his "Excel Statistics" series of free video lessons, you'll learn how to find outliers with the +/- 3 Z-score rule and the ABS function. See how to do a box plot by hand and in Excel. For th...

How To: Calculate simple and compound interest in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 2nd installment in his "Excel Finance Trick" series of free video lessons, you'll learn how to use the FV function. See the math formula for calculating future value and for calculating the effective interest rate. Also see long hand how c...

How To: Compare loans with a spreadsheet in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 45th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to perform debt analysis with the following input variables: % Down Payment, APR, Years, Points, Extra Fee. See how to calculate Amount to Borrow, Monthly Pay...

How To: Sort data with sorting functions in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 16th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to sort data in MS Excel. Specifically, you'll see the following:

How To: Use database functions in Microsoft Excel 1997-2003

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 3rd installment in his "Excel Formula Efficiency" series, you'll see how the Excel 2003, 2002, 2001, 1997 Database D functions (DSUM, DAVERAGE, DCOUNT) are much faster than SUMPRODUCT and SUM array formulas.

How To: Speed up calculations with helper cells in MS Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll learn how to use a helper cell to remove a time-consuming (expensive) section of your formula to speed up calculations.

How To: Use helper columns with concatenated fields in Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 7th installment in his "Excel Formula Efficiency" series, you'll see how a helper column with concatenated fields can dramatically reduce the time a formula takes to calculate.

How To: Calculate running total by formula in Microsoft Excel

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 9th installment in his "Excel Formula Efficiency" series, you'll learn see two running total formulas, one that is faster than the other.

How To: Create fast formulas for huge Excel spreadsheets

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 10th installment in his "Excel Formula Efficiency" series, you'll learn how to use Manual Calculation for huge spreadsheets so that recalculation only occurs when you want it to occur.

How To: Find confidence intervals without a sigma in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 84th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma is NOT known using the Descriptive Statistics data analysis add-in.

How To: Format whole & decimal numbers in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 8th installment in his "Excel Business Math" series of free video lessons, you'll learn how to work with whole and decimal numbers. See how to write words to represent numbers (for checks). See how formatting can hide decimals.

How To: Solve markup & markdown math problems in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 32nd installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve simple markup (mark-up) & markdown (mark-down) business math problems.

How To: Use the RANK and PERCENTRANK functions in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 38th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the RANK and PERCENTRANK functions as well as the Data Analysis add-in's Rank & Percentile tools.

How To: Use names and wildcards with Excel's COUNTIF function

Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 6th installment in his series of Excel name tricks, you'll learn how to use the Names & Wildcards with the COUNTIF function. Specifically, see how to search through a list of addresses and count just the ones on Birch Street in this free video lesson.

How To: Group quantitative data into classes in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 20th installment in his "Excel Statistics" series of free video lessons, you'll learn how to take raw quantitative (numerical) data and figure out how to group it into classes so that you can have categories an...

How To: Build confidence intervals given the sigma in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 81st installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals when the sigma (population standard deviation) is known. See how the CONFIDENCE and NO...

How To: Work with skew and histograms in Microsoft Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 23rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to work with skew in histograms for quantitative Data. Learn how to skew left (negative) and skew right (positive) with ...

How To: Create a relative frequency distribution in MS Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 14th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create relative & percent & frequency distributions with formulas for categorical data. See, too, how to create a per...

How To: Make calculations in Excel with formulas & references

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...

How To: Play "Hotel California" by the Eagles on the ukulele

Want to play the Eagles' "Hotel California" on your ukulele? Learn how with this free video ukulele lesson. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing "Hotel California" on your own uke, wa...

How To: Be less quiet and more talkative

Marie was asked by a viewer how to go about being more orally engaging with other people, as most attention he gets is attributed to the fact that he is very quiet, which doesn't sit well with him. Just like anyone else, he would like to get attention for the things he says, not for being quiet! He is under the impression that "cramming," or being knowledgeable on current events and other trivia will give him more to talk about and thus help him to be more talkative. Marie suggests, though, t...

How To: Put Youtube videos on your iPod touch

Whether you have YouTube favorites or want to keep track of your own uploads on the run, check out this video and learn how to put YouTube videos onto your iPod or iPhone. This video will explain how to use a free program called KeepVid that you can download online and use to rip videos and save them anywhere. This is useful if you are interested in offline viewing, or saving your best clips.

How To: Recover a chair with custom fabric

If that old chair is covered in holes or stains, or boasts a pattern that can best be described as "70s chic" it may be time to update it a bit. In this video learn how to save your favorite comfy chair and recover or reupholster it like a pro. By recovering your furniture yourself you can avoid the cost of buying a new one or paying a professional, with the added bonus of holding on to a long-loved piece of decor.

How To: Play the Beatles' "Penny Lane" on the ukulele

Want to play the Beatles' "Penny Lane" on your ukulele? Learn how with this free video ukulele lesson from Ukulele Mike. Whether you play the ukulele or bass kazoo, there is no better way to improve your chops than by learning to play your favorite songs. Not only is it more fun and much easier than running drills or memorizing a chord book by wrote, it's obviously also a wonderful way to build your repertory of songs. For more information, and to get started playing "Penny Lane" by Paul McCa...

How To: Make Cajun-style fried shrimp with crab étouffée

In this tutorial, Beryl Stokes shows us how to make fried shrimp with crab etouffe. First, make some crab etouffee from any favorite recipe you have. Once you've made this, prepare your batter for your fresh shrimp. First, take a package of Fish Fry and add in a spoonful of flour, 1 tsp of seasoning, 1 tbsp sea salt and mix this together. Now crack 1 egg and milk into a separate bowl for an egg wash. After this, grab your fresh shrimp and dip it into the egg wash then the dry flour and then f...

How To: Make a caper garlic butter sauce

In this video, we learn how to make a caper garlic butter sauce. First, take a white butter sauce (preferably a homemade fresh white butter sauce) and mix in chopped parsley, tomatoes and garlic. Mix all of these together until they are well combined with the white sauce. Pour the mixture into a serving dish and serve on top of your favorite dish. It works well with fish dishes and tastes great when it is made fresh. Make sure you use warm and fresh ingredients. To store this, keep in a tight...

How To: Toast walnuts to bring out their flavor

In this video, we learn how to toast walnuts to place into your favorite recipes. First, you want to put the walnuts on a single layer of a baking sheet so they bake nice and evenly. Now, place the walnuts in a preheated 350 degree oven for about 7-10 minutes until they are golden brown. When finished, remove from the oven and let these cool. You can now place these walnuts into any recipe you like! This will bring out the most flavor that is in your walnuts and taste much better than using u...

How To: Create custom screensavers from movies in Windows

This video is a tutorial on how to create your own custom screen savers from your favorite movies on a Windows computer. The first step is to download the Movie Screen Saver Software from www.vijusoft.com. When the program is finished downloading from the website then you will have to open the installer package and follow the instructions. The download should only take a few minutes and then you might have to restart your computer when it is finished. The second step, once the program is down...

How To: Make chocolate truffles with Ina Garten

In this tutorial, Barefoot Contessa shows us how to make chocolate truffles at home. First, take a 1/2 cup of heavy cream and heat it up in a saucepan. Now, chop up bars of semi-sweet and bitter sweet chocolate (6 oz together) and put into a mixing bowl. Now, pour your warm cream into a strainer onto the chocolate. Stir the mixture until the chocolate melts the chocolate all the way. Now, add 1 1/2 tbsp of Frangelico liquer, 1 tbsp coffee and 1/2 tsp vanilla extract and stir. Chill this for a...