Favorite Scents Search Results

How To: Find range and interquartile range 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 40th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate range & interquartile range for variability using the MAX, MIN, QUARTILE functions.

How To: Create a basic array formula in Microsoft Excel

Looking for a primer on how to create and work with arrays 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 very first installment in his series of Excel array formula series, you'll learn how to create a basic array formula. Learn about the syntax, the Ctrl + Shift + Enter method of formula entry and the curly brackets that get entered automatically by Excel.

How To: Count the number of characters in an Excel cell range

Looking for a primer on how to create and work with array formulas 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 9th installment in his series of Excel array formula series, you'll learn create array formula that counts all the characters in a range of cells.

How To: Multiply matrices with the MMULT function in MS Excel

Looking for a primer on how to create and work with array formulas 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 12th installment in his series of Excel array formula series, you'll learn how to use the array function MMULT to multiply multiple matrices in matrix algebra. (NB: This is an array function that requires the Ctrl + Shift + Enter trick.)

How To: Use dynamic range names in Excel 2007 tables

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 12th installment in his series of Excel name tricks, you'll learn how to use the built-in dynamic range names in Excel 2007 Tables.

How To: Name cell ranges with relative references in MS Excel

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 8th installment in his series of Excel name tricks, you'll learn how to name cell ranges with relative cell references instead of the default absolute cell references.

How To: Create confidence intervals for proportions in 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 86th installment in his "Excel Statistics" series of free video lessons, you'll learn how to construct confidence intervals for proportions using NORMSINV function and other formulas.

How To: Find the sample size for confidence intervals in 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 87th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate sample size (n) for confidence intervals.

How To: Plot data with Microsoft Excel's REPT & COUNTIF tools

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 27th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create a quantitative data dot plot chart using the REPT and COUNTIF functions.

How To: Create a cumulative 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 26th installment in his "Excel Statistics" series of free video lessons, you'll learn how to create quantitative data cumulative frequency distributions with pivot tables.

How To: Cross tabulate categorical data 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 16th installment in his "Excel Statistics" series of free video lessons, you'll learn how to cross tabulate & do percentage cross tabulation for categorical data using a pivot table (PivotTable).

How To: Group categories in an Excel frequency distribution

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 19th installment in his "Excel Statistics" series of free video lessons, you'll learn how to group categories in a frequency distribution with a formula (2 COUNTIF) and the pivot table (PivotTable) grouping fea...

How To: Cross tabulate categorical data with formulas in 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 17th installment in his "Excel Statistics" series of free video lessons, you'll learn how to cross tabulate & do percentage cross tabulation for categorical data using formulas rather than pivot tables.

How To: Use Microsoft Excel's sort and pivot table tools

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 3rd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Excel's sorting and pivot tables (PivotTables) data analysis tools.

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 the new features in Adobe Flash Catalyst CS5

Whether you're new to Adobe's Creative Suite or a seasoned graphic design professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, Terry White discusses his five favorite features of the newest addition to Adobe's CS, Flash Catalyst, an application which allows you to create dynamic web pages without coding. Learn how to create dynamic scrolling content and functional Flash buttons ...

How To: Use new features in Adobe Photoshop CS5

Whether you're new to Adobe Photoshop or a seasoned graphic arts professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll join Terry White as he runs through his 5 favorite Photoshop CS5 features, including the new enhanced selection abilities and noise reduction tools.

How To: Create and manage text in Final Cut Pro

For this Final Cut Studio video tutorial, Zach King will teach you how to create and manage text in Final Cut Pro. To create and manage text, just go to the Video Generators Tab in the Viewer window, go to Text, and choose your favorite option, or just the plain old Text. Check out the rest of the process in Final Cut. Let the Final Cut King show you how!

How To: Use Knoll Light Factory Pro After Effects plugin

This software tutorial shows you how to use the Knoll Light Factory Pro plug-in for After Effects. Knoll Light Factory Pro is the industry's favorite tool for creating lens flares, sunsets, photon torpedoes, stars and other effects. It offers a custom lens editor, auto tracking, alpha channel support, and pinpoint control over dozens of settings. If you haven't used the Knoll Light Factory Pro plug-in yet, watch this After Effects tutorial and get started.

How To: Play "Sweet Home Alabama"

Learn how to play guitar with this classic Lynyrd Skynyrd song from our favorite guitar teacher Justin Sandercoe. This is the first video but make sure you watch the second one so you can play all of "Sweet Home Alabama". This is really for advanced players.

How To: Connect PS3 Controller to a PC computer

Are you tired of always having your hand in an akward position when playing your favorite games on the PC? Do you think it would be much easier on both your fingers and wrists to have them holding onto one thing? Well then, this tutorial is what you're looking for! Introducing, how to connect a PS3 controller to a PC computer tutorial! In this video you'll find out what it takes to use the sleek, sexy, black PS3 controller to play some of your favorite games. So check out the video above to f...

How To: Get fuller sexy thicker hair

In this video, Sharon Connolly shows us hot to get fuller, sexier and thicker hair. First, add a heat protector to your hair and brush it through. Next, add your favorite mousse and spread throughout your hair mixing it in well up to the roots. Now, take your hair dryer and brush your hair in the opposite direction as your dry it. This will cause your hair to almost stand up, but create great volume. Do this for all sides of your hair including sides and front to back. Now, grab a round brush...

How To: Put the Chumby guts kit together

Chumby is the dream toy of hackers and tinkerers everywhere. Made up of a few simple parts, Chumby takes your favorite parts of the Internet and streams it so that you'll always have access to your favorite podcasts, music, photos, games and more. What's great is that you can put together the Chumby yourself. In this video MAKE shows us how to put the Chumby guts kit together. Be sure to make sure you have all the required parts.

How To: Play "Jump" by Van Halen on guitar

There are few projects that are so simple, and so immediately rewarding, as learning to play a favorite song on the guitar. Not only is it a wonderful way to pass the time but, by learning to play your favorite songs and riffs, you'll be better able to articulate (and otherwise translate) your musical ideas into great-sounding songs. In this guitar lesson, you'll learn how to play "Girls Got Rhythm" by Van Halen. While this tutorial is geared towards intermediate players, guitarists of all sk...

How To: Play the dirty, or distorted parts, from "Dream On"

There are few projects that are so simple, and so immediately rewarding, as learning to play a favorite song on the guitar. Not only is it a wonderful way to pass the time but, by learning to play your favorite songs and riffs, you'll be better able to articulate (and otherwise translate) your musical ideas into great-sounding songs. In this guitar lesson, you'll learn how to play the dirty, or distorted, parts from "Dream On" by AC/DC. While this tutorial is geared towards intermediate playe...

How To: Play "Dream On" by Aerosmith on electric guitar

There are few projects that are so simple, and so immediately rewarding, as learning to play a favorite song on the guitar. Not only is it a wonderful way to pass the time but, by learning to play your favorite songs and riffs, you'll be better able to articulate (and otherwise translate) your musical ideas into great-sounding songs. In this guitar lesson, you'll learn how to play "Dream On" by Aerosmith. While this tutorial is geared towards intermediate players, guitarists of all skill leve...