Video Clips Search Results

How To: Automatically highlight negative numbers 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 4nd installment of his "YouTubers Love Excel 2007" or YTLE2k7 series of free video MS Excel lessons, you'll learn how to use conditional formatting to add red to negative numbers and green to positive numbers using a single True/False formula!

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: Make an electroscope for static electricty experiments

In this video, learn how to make your own homemade electroscope. An electroscope is an early scientific instrument that is used to detect the presence and magnitude of electric charge on a body and for static electricity experiments. They are easy to make. This electroscope is made from a binder clip and two sheets of plastic (or overhead transparency film), and scissors.

How To: Make an accordion photo album

Want to make a neat gift for a friend? In this Curbly video tutorial, steps are given on how to make an accordion style photo album without any glue or tape. Materials needed include: light to medium weight poster board (24x4.5"), a scoring tool & board, an Exacto knife, scissors, a hole punch, 0.25"x7.5" piece of elastic, and brad clips. Put photos of you, friends, and family on both sides of the accordion to make for a great keepsake.

How To: Apply a filter pack in Final Cut Pro

For this Final Cut Studio video tutorial, Zach King will teach you how to apply a filter pack in Final Cut Pro and Final Cut Express. To apply a filter pack, you'll just click on the clip with all your applied filters, go to effects tab and press Make Favorite Effect. It saves your filters in the Favorites folder with the exact same settings. Let the Final Cut King show you how!

How To: Boogaloo dance with basic popping skills

This is a how to BOOGALOO dance lesson. This tutorial covers the basics. Historically, it has been a difficult style to learn. I started learning online with dance clips, but then got the opportunity to learn from JAZZY J (EBs) and other poppers in NYC. This is another great Russian Tiger tutorial on pop'n'lock dance moves.

How To: Mix audio in Final Cut Express

When your edit is complete, or locked, the next step is to fine tune your audio. Adjust the audio levels of your clips to produce a balanced sound mix. In Final Cut Express, you can control audio levels in the timeline and the viewer. You can even add keyframes to make level changes over time.

How To: Create picture-in-picture & split screens in Premiere

Jeff Schell walks you through simple yet effective methods to show two people having a phone conversation on screen at the same time. Jeff starts by showing you how to quickly make a picture-in-picture effect in Premiere Pro CS3, and then adds on a cross-dissolve transition to fade the video in and out. Jeff then demonstrates how to use the Position property to slide a clip to one side, so the people on the phone are side by side.

How To: Create an animated ring of text around an object in AE

Instructor Brian Maffitt gives a fast-paced recipe for creating a Saturn-like ring of text around an orange. Brian gives the Stroke, Path Text, and Basic 3D filters a good workout, stresses the importance of pre-composing, and tops it all off with an inverted mask. This is a great "fake-3D" effect you'll be glad to add to your arsenal. So come on...orange you going to watch this clip?

How To: Everything You Need to Know About Adding & Editing Audio for Videos in Enlight Videoleap for iPhone

The music and sound effects that play in the background of any videos you edit helps set the tone, so it's essential to get it right. Enlight Videoleap, an extremely powerful and popular mobile video editing tool for iOS, lets you quickly and easily add audio from your iPhone and the cloud, but things can still get a little confusing when you have a timeline full of clips.

How To: Wind a bobbin and thread the needle on a machine

Tracie Cunniliers demonstrates how to wind a bobbin and thread the needle using an automatic needle threader in 'Elna 2800'.To wind a bobbin, place a spool of thread on the holder. Place a thread holder next to the spool of thread. Take the end of the thread and wind it around the clip situated on the other side of the machine. Now take a bobbin and pull the needle through the bobbin inside-out. Now place the bobbin on the holder and click into place. Hold the end of the thread and slowly pre...

How To: Add 20" human hair extensions

Jennifer Pompa suggests that the 20" easiXtend Elite is the extension to start with. It's an 8 piece extension made with human hair that's not been too processed and so looks very natural. Jennifer is wearing a Kim Kardashian look with flowing curls. The extensions can be purchased as Extensions. Blow dryer, flat iron or curling can be done to these extensions because it's real hair. The extensions come in many colors but also can be dyed to match your hair. To remove them, Jennifer unclips t...

How To: Add highlights to your hair without using bleach

This works well for short hair. First of all you need to have artificial hair extensions of golden color or any other color of your choice. You also need a glue gun and hair clips to hold these extensions to your real hair. You can choose to fix these extensions on the left side of your head, just below the hair. Lift your hair at the left sides, add some glue using the glue gun and place the extension. Now add clips to fix it on your hair. Carefully conceal it below your real hair. Take care...