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).
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...
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 new sync lock feature in Premiere Pro CS4 is a very useful tool that will maintain the relationship between clips in multiple tracks so that when you are editing you make changes to one clip, Premiere will keep your edits in place by adjusting the other clips in the timeline. Sync lock is a new feature added to Premiere Pro CS4 and this tutorial shows you how and when to use it as it pertains to your normal editing workflow in Premiere Pro. This is especially helpful when ripple editing. ...
If you've taken the time to edit a video on your iPhone or Android phone, you probably have a purpose for it. Maybe you want to share it to YouTube in hopes of making the next viral sensation. Maybe you just want to save the video to your phone to show off to friends and family when you can.
This is a great little rainy day project you can make for almost no money, or a fun party trick you can use at the next office Christmas party! You will need two disposable drinking cups (stiff plastic or paper will work best), a fairly thick straw, a sturdy paper clip, a thick rubber band, a cocktail stick, a bead and a plastic ring you can get from the neck of a soda bottle. Assemble as shown, and then let it go!
This tutorial covers the basics of manipulating audio in Final Cut Pro by using keyframes. Add fade outs, fade ins, adjust the volume up or down, and even edit out the sounds of breathing or other small flaws in sound.
This clip offers a whirligig tour of the best and brightest new features of Apple's iOS 4.2, the latest version of the mobile operating system that runs on the iPhone, iPad and iPod Touch. Learn how to get the most out of your iOS 4.2 Apple mobile device with this video guide.
Don't be suckered into buying two separate data plans! In this clip, you'll learn how to share your rooted Motorola Droid Android smartphone's 3G data connection with a Samsung Galaxy Tab over WiFi! For more information, including detailed, step-by-step instructions, take a look.
Watch all of your favorite television shows over 3G or WiFi with the official Hulu Plus web app. (Note that, as of November 17, 2010, the subscription rate has dropped from $9.99/month to $7.99/month.) In this clip, you'll learn how to navigate and use the Hulu Plus app on an Apple iOS mobile device like an iPhone, iPad or iPod Touch.
Ever wish you could watch your favorite Hulu shows on your TV using your Roku media player? Before November 17th, 2010, you were out of luck — now, in most cases, it's as easy as running a software update! This clip will show you what to do you get Hulu Plus up and running on your own television using your Roku set-top box.
Now this is a DIY microphone. It turns out all you need to make a quasi-functional mic is a pair of razor blades, a pencil, some tupperware, and clips to run the signal from the razor blades to a resistor. Watch this video to learn how to make this awesome DIY mic and never find yourself silenced again.
Eager to try the Firesheep Firefox extension yourself? It stands to reason that you'll need to download and install it from its official GitHub page first. You'll find all the details, including easy-to-follow, step-by-step instructions on how to find and run the Firesheep XPI installer, in the clip. Get started capturing your friends' Facebook passwords with this video guide.
Here's a fun hack! In this clip, we learn of a bug that will permit you to circumvent the passcode lock screen on any iOS 4.1 iPhone 4. For detailed, step-by-step instructions, and to get started using this exploit yourself, watch this video guide.
