Free Ebooks Search Results

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: Geometrically prove the Pythagorean theorem

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.

How To: Photoshop neon text

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.

How To: Get candle wax out of your carpet

Want to remove dried wax from a carpet? You'll need four items: a white towel, a regular electric iron, a carpet cleaning solution and a hot-water extraction machine. For a complete, step-by-step demonstration of how to remove pesky paraffin wax stains from your own carpet, watch this free housekeeping video tutorial.

How To: Do whipstitch applique

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.

How To: Make a felt flower pin

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.

How To: Iron a dress or sport shirt

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.

How To: Do exercises to trim your hips with Brooke Burke

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.

How To: Do standing abdominal exercises while pregnant

Want to maintain strong abs during your pregnancy? You've come to the right place. This free maternity fitness guide demonstrates a simple standing exercise routine that will strengthen your abdominal muscles without putting pressure on your vena cava. Learn how to keep your abs strong during pregnancy with this video exercise lessson.

How To: Copyright your music or beats

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.

How To: Re-paint old furniture

If your furniture has seen better days but is nevertheless structurally sound, restoring it might be as simple as applying a fresh layer of paint or wood stain. This free video tutorial demonstrates a method for refinishing furniture with a power sander. For more information, and to get started rejuvenating your own antique furniture, watch this video tutorial.

How To: Do a twisted cross stitch

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.

How To: Origami a rose petal or leaf

With this video guide, you'll learn how to make rose pedals and leaves from folded paper with origami, the traditional Japanese art of paper folding. For a step-by-step overview of the folding process, as well as to get started making your own paper leaves and petals, watch this free origami lesson.

How To: Make a CO2 powered bottle rocket

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.

How To: Make goop out of Elmer's glue

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.

How To: Dual boot Windows 7 & save YouTube videos

Patrick Norton and Veronica Belmont from Tekzilla will show you how to dual boot Windows 7 and download videos from YouTube. The hosts show viewers how to dual boot Windows XP Pro32 bit and Windows 7 RC 1 64 bit. In the first step as always you will want to back up your hard drive and at the very least they recommend to back up your most important files. In the case that something goes terribly wrong you can use a free program called EASEUS to make a complete image of your whole drive, this a...

How To: Avoid dry "airplane skin"

Learn how to avoid dry skin that develops on extended airplane flights. 1 Buy a small sprayer (under three and a third ounces, due to airplane security) and lip balm. 2 Every hour that you are on the airplane, spray your face once with the sprayer's fine mist setting. 3 Do not wipe off the water and apply a thin layer of oil free moisturizer. 4 Apply lip balm every hour.

How To: Create a photo background in Photoshop

Have you ever wanted to create a background with one of your photos? This video shows you how to use one of your photos to create a photo background using Adobe Photoshop. It will show you how to use the free transform tool, overlay blend modes, hue and saturation, drop shadows, and other cool effects. Learn all about creating photo backgrounds with this video tutorial.

How To: Resize photos with automation in Photoshop

In this video tutorial by photoshopuniverse, from Free Photoshop Video Tutorials, shows you how to automate the process of resizing images using Photoshop, primarily for sending over the internet. The guide takes you through the step by step process of creating a new action to record the process of resizing an image. Using this recorded action, you will learn how to go about applying that action to an entire folder, which will resize all the images contained in that folder.

How To: Escape from a zip tie and open locked doors

If for some strange reason you find your hands bound together by a zip tie, check out this video to learn how to escape from one! Using a little bit of slight of hand, you'll learn how to break free from a tight zip tie, and as an added bonus, how to open up a locked door using a zip tie. Remember: Don't cut off your circulation by tightening it too much.

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.