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!
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.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 85th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to isolate unique records with the OR function.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 74th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to fix bad data with the CLEAN & TRIM functions.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 81st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to a chart by creating a new column of data with a formula.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 72nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to turn off auto formatting so that column and row formatting or formulas are not automatically created.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 101st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use conditional formatting AND custom number formatting to add styling to a cell.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 87th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to quickly remove rows of a table where the row has a blank in column A.
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.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 86th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create a TRUE/FALSE formula to change the function of pivot table as well as how to filter one.
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.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to pull data from a table on one worksheet to a second worksheet using the VLOOKUP and DGET functions.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 66.5th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll see 3 different ways to hide formula errors.
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.
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.
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.
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.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 106th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use two alternatives to pivot tables.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 102nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count the number of days between two dates using an array formula.
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).
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.
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.
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!
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.
When there isn't space in a garden for favorite plants, they can be planted in containers and placed on a patio or deck. This how-to clip provides instructions for how to plant a beautiful and functional container garden.
Check out this clip courtesy of National Geographic Channel's new series, What Would Happen If? You could be a master of the board game Monopoly (or at least the UK version of Monopoly) just by watching this video tutorial. Money and hotels and jail spells fun!
Learn how you can open handcuffs using common items such as paper clips and more. This can come in handy for those late nights at bars.
The easiest way to make a movie is with magic iMovie. Magic iMovie imports clips from your video camera, inserts a title and transitions, and sets the music, so you can create a movie with the click of a button.
One of the best ways to spice up your movie is to apply a visual effect to it, such as speeding up your clip, reversing the direction, or adjusting the color.
Final Cut Express makes it easy to convert or capture your videotapes into digital video files. All you need to do is set the desired capture format and destination for your clips. The Final Cut Express menu also provides an Easy Setup function.
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.
This clip explains the necessary means to surviving the prison system in Chicago. Excerpted from "The Heart Broken in Half", an anthropological documentary about a Chicago street gang, the Latin Kings.
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.
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?
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.
Think of all the times you've ever copied and pasted a string of text on your device. At least once, I bet you've wanted to see your copy history.
Cars are quite different than they used to be. Sure, modern cars have some cool things, but repairing them are becoming difficult. Even simple things like changing a headlight bulb.
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...
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...
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...