Lessons Search Results

How To: Calculate weighted & geometric mean 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 35th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate weighted and geometric means and see how to use the GEOMEAN function.

How To: Use the MEAN, PERCENTILE & RANK 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 33rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use the AVEARGE, MEDIAN, MODE, PERCENTILE, QUARTILE and PERCENTILERANK functions to measure location.

How To: Create a percentage frequency table 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 4th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a frequency table and percentage frequency table using a Pivot Table (PivotTable).

How To: Use Microsoft Excel's Goal Seek tool to modify inputs

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 103rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use Goal Seek to change a formula input number so that the formula is a desired result. Also learn how to use the PMT function.

How To: Create an average with multiple criteria 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 91st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an average with multiple criteria using pivot tables (PivotTable). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Create an Excel inventory template with running totals

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Evaluate vendors with array formulas 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 63rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an array formula to find the vendor with the maximum rating and the lowest cost Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Count unique records exceeding a hurdle 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 54th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count records exceeding a given hurdle using Excel's advanced filter tool. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Prevent duplicate entries in an Excel spreadsheet

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.

How To: Calculate plate cost for a print shop 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 47th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to calculate total plate cost for a print shop using the VLOOKUP function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Use a VLOOKUP function inside a text formula in Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 51st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a VLOOKUP function inside a Text Formula to add a variable word (e.g., Annual, Semi-Annual, Quarterly, Monthly, or Weekly).

How To: Drop the racket on a tennis serve

Welcome to a tennis lesson from FuzzyYellowBalls, the the best place to learn how to play tennis online. Our free video tennis lessons teach you how to play the game in a new way that combines technical analysis, visual learning, and step-by-step progressions.

How To: Practice the leg push in tennis serve

Welcome to a tennis lesson from FuzzyYellowBalls, the the best place to learn how to play tennis online. Our free video tennis lessons teach you how to play the game in a new way that combines technical analysis, visual learning, and step-by-step progressions.

How To: Model a stingray in Houdini 9

These two Houdini 9 lessons illustrate a valuable and efficient means of modeling an animated surface in a manner not generally considered. It provides an explanation of the advantages to this approach and compares it to a more traditional means of animating a surface. So watch the tutorial and learn how to animate a stingray in Houdini 9 using newer style animation methods.

How To: Calculate liquidity ratios in Microsoft Excel 2010

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 16th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate liquidity ratios including current ratio, times interest earned and cash Ratio. Also see how current ratio changes when certain trans...

How To: Create and play blues-style solos on the ukulele

Want to make your ukulele sing the blues? In this clip, you'll learn how to create and play blues-style solos on the uke. If you want to get really good at playing the ukulele, it stands to reason that you'll need to practice. Happily, the Internet is awash in high-quality video lessons like this one from the folks at Ukulele Underground. For more information, including a step-by-step overview, watch this free video ukulele tutorial.

How To: Warm up your thumb and index finger when playing the ukulele

In this clip, you'll learn how to warm up your thumb and pointer fingers with a simple scale-based picking exercise for the uke. If you want to get really good at playing the ukulele, it stands to reason that you'll need to practice. Happily, the Internet is awash in high-quality video lessons like this one from the folks at Ukulele Underground. For more information, including a step-by-step overview, watch this free video ukulele tutorial.

How To: Count from 0 to 10 in Spanish

In this free video language lesson, you'll learn how to ask how to say the Spanish words for the numbers zero, one, two, three, four, five, six, seven, eight, nine and ten. Interested in learning Spanish but haven't got the time to take a weekly class? No problemo! The Internet is awash in free, high-quality video lessons like this one. For more information, and to get started using this phrase yourself, watch this helpful video guide for Spanish students.

How To: Tell someone that it's nice to meet them in Spanish

In this free video language lesson, you'll learn how to ask how to tell someone that it's nice to meet him or her. Interested in learning Spanish but haven't got the time to take a weekly class? No problemo! The Internet is awash in free, high-quality video lessons like this one. For more information, and to get started using this phrase yourself, watch this helpful video guide for Spanish students.

How To: Ask someone what his or her name is in Spanish

In this free video language lesson, you'll learn how to ask how someone what his or her name is in perfect Spanish. Interested in learning Spanish but haven't got the time to take a weekly class? No problemo! The Internet is awash in free, high-quality video lessons like this one. For more information, and to get started using this phrase yourself, watch this helpful video guide for Spanish students.

How To: Say "I don't understand" in Spanish ("No entiendo")

In this free video spanish lesson, you'll learn how to say and properly pronounce the Spanish words for "I don't understand": "No entiendo." Interested in learning Spanish but haven't got the time to take a weekly language class? No problemo! The Internet is awash in free, high-quality video lessons like this one. For more information, and to get started using this phrase yourself, watch this helpful video guide for Spanish students.

How To: Play all 12 major scales on the piano

As adults who were forced through numerous piano lessons as a child, we know one thing's for sure: Major scales are often the easiest to learn, and they're also the most commonly used scales in major songs. Which is why knowing how to play minor scales is so important to improving your skills as a piano artist.

How To: Play the C major scale on the piano

After taking piano lessons for most of our anguished childhood, we realized one of the most effective ways to increase finger dexterity and speed was simply to play scales. Over and over and over and over again. While churning them out an infinite number of times is tres boring (especially because we could have been at the mall with our friends watching Mulan), scales are vital for becoming a good piano player.

How To: Play an easy Hawaiian picking vamp in F on the ukulele

Learn to play a Hawaiian picking vamp in F (with a low G string). There's no getting around it: if you want to get good at playing the ukulele or any other instrument, you'll need to practice. Fortunately, the Internet is awash in free uke lessons, like this one from Ukulele Live, which make the task not only easy but fun. For more information, and to get started playing this vamp on your own ukulele, take a look.

How To: Play common 4/4-time strumming patterns on the ukulele

There's no getting around it: if you want to get good at playing the ukulele or any other instrument, you'll need to practice. Fortunately, the Internet is awash in free, high-quality uke lessons, like this one from YouTube's preeminent tropical tutor, Ukulele Mike. This particular tutorial provides a detailed, step-by-step overview of how to play a number of useful 4/4 time strumming patterns. For more information, and to get started playing quarter time strumming patterns on your own uke, w...