New to Microsoft Excel 2010? Looking for a few good tips and tricks? Look no further. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 8th installment in his series of Excel 2010 video tutorials, you'll learn how to use the Excel's new T functions — namely, T.INV, T.INV.2T, T.DIST, T.DIST.RT and T.DIST.2T.
New to Microsoft Excel 2010? Looking for a few good tips and tricks? Look no further. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 3rd installment in his series of Excel 2010 video tutorials, you'll learn how to use Excel's new percentile function, PERCENTILE.EXC.
Take full of Photoshop CS5's HDR Toning Adjustment Tool with this free video lesson. Whether you're new to Adobe's Creative Suite or a seasoned graphic design professional after a general overview of Photoshop CS5's most vital new features, you're sure to be well served by this video tutorial from the folks at Brusheezy. In it, you'll learn how to take advantage of Photoshop's new HDR (high dynamic range) Toning Adjustment Tool.
Looking for a guide on how to create pages within Flash Catalyst CS5? Whether you're new to Adobe Flash or merely unfamiliar with Creative Suite 5, you're sure to benefit from this free video software tutorial from Lynda, which presents a thorough, step-by-step overview on how to add pages in Adobe Flash Catalyst CS5 Essential.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to write a formal analytical proof of the quadratic formula.
There comes a time, in every young child's life, in which they need to have "the talk" with their parents... about how to tie their shoes! Learn how to teach your children how to tie their shoes with guidance from this free tutorial! Make your son or daughter an independent shoe tying expert in no time at all!
Ready to make your brain hurt? In this free video jazz guitar lesson from Justin Sandercoe, you'll learn about dimished/7b9 chord substitution. In short, if you have a functioning 5 chord, you can substitute a diminished chord (with one of the root notes a semitone above the root). For more information, and to get started using this substitution in your own jazz playing, watch this helpful tutorial.
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 6th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create worksheet and workbook references in formulas.
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 37th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with MS Excel's SUMPRODUCT function.
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 10th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create projections for sales numbers from a database using the SUMIF, VLOOKUP and COLUMNS functions and a percentage increase formula.
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 61st installment in his "Excel Business Math" series of free video lessons, you'll learn how to use the Excel functions PV and PMT to make a present value calculation for an annuity.
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 35.2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to use Excel's GEOMEAN function to find geometric mean.
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 44th installment in his "Excel Business Math" series of free video lessons, you'll learn how to work with series trade discounts 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 38th installment in his "Excel Business Math" series of free video lessons, you'll learn how to calculate gross and overtime pay 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 41st installment in his "Excel Business Math" series of free video lessons, you'll learn how to calculate deductions from paychecks when there is a ceiling or max taxable amount or hurdle.
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 42nd installment in his "Excel Business Math" series of free video lessons, you'll learn about the wage bracket and percentage methods for calculating federal income tax payroll deductions.
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 17th installment in his "Excel Business Math" series of free video lessons, you'll learn how to define prime numbers, determine prime factors, reduce fractions (i.e., write fractions in their lowest terms) and convert mixed numbers to imp...
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.
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.
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.)
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.
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 10th installment in his series of Excel name tricks, you'll learn how to store lookup tables in memory using a named array.
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.
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.
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...
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.
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).
video tutorial from ExcelIsFun, the 64th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to Excel's D (i.e., database) functions such as DSUM, DAVERAGE, and DMAX.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps. With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to perform a geometric proof of the Pythagorean theorem.
Want to create neon-tube style text in Photoshop? It's easier than you might think. Watch this graphic designer's guide, which presents a full, step-by-step guide to accomplishing just that. For more information on how to create your own custom neon-style logos and headers, watch this free video software tutorial.
Want to attach an appliqué with a whipstitch? It's easy. So easy, in fact, that this guide can present a complete and thorough overview of the stitching process in just over two minutes' time. For more information, as well as to get started applying your own appliqués by whipstitch, watch this free video guide.
Looking for your next craft project? Look no further. This crafty person's guide will walk you through the process of making a custom felt flower pin with supplies from your local craft store and about 45 minutes of labor. For more information, including a list of necessary materials and step-by-step instructions for making your own floral pin, watch this free video tutorial.
Want to make your own electromagnet? It's easier than you'd think. It's so easy, in fact, that this video guide can present a complete and thorough overview of the entire magnet making process in just over two minutes. For complete instructions and a list of necessary materials, watch this free home science how-to.
Need to iron a shirt for an important occasion? Smooth out your ironing technique with this housekeeper's how-to, which demonstrates the proper technique for pressing a men's dress or sport shirt using an electric iron and ironing board. For more information, including a step-by-step breakdown of the process, watch this free video tutorial.
Want to slim down? Feel the burn with this easy, five-minute exercise sure to help you trim or otherwise tighten up your hips. For complete instructions, including a step-by-step overview of this simple exercise, watch this home fitness how-to. Lose weight and feel great with the routine demonstrated in this free video guide from Brooke Burke.
While big parts of copyright protection are applied automatically to creative works like songs and beats (hence the need for orginizations like the Creative Commons), registering your work with Copyright Office is useful to the extent that it can allow you to seek greater damages in the event of an infringement. For more information, including how to register your own songs with the US Copyright Office, watch this free video tutorial.
Spice up your repertory of knitting stitches with the twisted cross stich demonstrated in this clever crafter's how-to. The stitch, though it might sound difficult, is much simpler than you would think and can be used anywhere a traditional cross stitch might be. Learn how to do twisted cross stitching with this free knitting lesson.
Windows 7 is fairly similar to Mac OS X out of the box. But what if it's not similar enough for your tastes? Then you follow this free video guide, that's what: with its help, you'll learn how to use Snow Leopard-style file stacks on Microsoft Windows 7 desktop. For complete instructions, watch this tutorial.
Sure, carbon and oxygen are two of very most fundamental building blocks of all life on Earth — but what have they done for you lately? With this free video guide, you'll learn how to build a safe, simple carbon-dioxide-powered bottle rocket with baking soda and a spent soft plastic waterball.
You wouldn't think it would take much to make "gloop" from Elmer's glue but, as it happens, it's an art. And with this family-oriented video tutorial, you'll learn just how to make the goopy stuff for yourself. For more information, and to get started making icky, sticky gloop for yourself (or for your kids) watch this free how-to.