Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 80th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to highlight an entire record (row) in a database that matches a bounced email addresss. 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 69th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use Excel's Auto Fill tool.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 45th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the SUMPRODUCT & TEXT functions together in 1 formula to sum the month's sales. 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 39th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the RIGHT, LEN, FIND & REPLACE functions in a formula to deliver a sheet tab name to a cell!
Want to create a time-lapse video montage from photos shot on a DSLR? This tutorial presents a general overview of the equipment, settings and post procedures (e.g., cropping & color correction) necessary to create beautiful, finished-looking time-lapse clips. Get started shooting your own time-lapse segments with this free video guide.
Ever wish you could embed a YouTube video into a Microsoft Office PowerPoint 2007 presentation? If you have a live Internet connection when designing your presentation, and will have one when showing it, you can. And it's an easy process to boot. For complete instructions on how to put a YouTube clip into a presentation in PowerPoint 2007, watch this helpful video tutorial.
TaskTutorial gives us an in-depth instruction on how to use Flash to create stop and play buttons. This is a great find if you are interested in creating videos with Flash program. These programs can also be downloaded for free on the website indicated on the videos page. Learn quick and easily how to use Frames and button applications on this easy to follow video.
In this video tutorial the performer demonstrates the slant gainer, also known as the cheat gainer. Basically, it involves hurling yourself away from the ground, spinning in the air for a while and then trying to land without busting your ankles and/or head. If accomplished successfully, it looks extremely cool. If it ends in failure, at least you might get a hit YouTube clip out of it.
This video tutorial from IndyMogul shows you how to create a hand stab effect and Halo Portal Gun.
Do you ever wish you had a way to jot down an idea, and then illustrate it with a page from a document, a photo and a sound clip, all without opening multiple applications? Microsoft Office OneNote 2007 note-taking program is that advanced notepad, and is better than ever with new additions to the interface that make it even easier to organize yourself. For more on using MS Office OneNote, watch this video tutorial.
This software tutorial shows you how to use some of the more advanced tools of the Colorista plug-in for Final Cut Pro. Colorista is a color correction plugin. You will learn how to fix a bad clip using Colorista in Final Cut Pro.
This video editing software tutorial outlines using keyframes in Final Cut Pro. Keyframes enable a video editor to have different properties of a clip change over time (a la animation). If you are new to animating in software packages or Final Cut Pro, this tutorial will help get you started.
This video editing software tutorial covers using timeline and clip-based markers in the Final Cut Pro timeline. This is a very useful tutorial for Final Cut Pro newbies. Watch and learn how to use markers as a way to organize and manage navigation within Final Cut Pro.
Check out this instructional recording video that shows you how to mic a drum kit for a live performance. This uses a minimalist set up with the Shure drum microphone kit. The kit includes six mics and three clips. Record your drum kit during a live performance by learning how to mike it with this recording tutorial video.
Check out this instructional tennis video that demonstrates how to hit an angle shot. Angle shots are hard to hit in tennis. Learn how to hit angle shots in tennis with this video clip.
Need tennis tips? Check out this instructional tennis video that demonstrates how to hold a tennis racquet. Learn about tennis fundamentals including the proper way to hold a tennis racquet in this video clip.
This video shows you how to upgrade your consumer camcorder sound capabilities using a camcorder XLR adapter, a simple device that mounts to the bottom of the camera. It then tests and compares the various types of microphones that can be attached, including the lavalier, sennheiser, handheld interview, and the wireless clip-on microphone. WAtch this helpful instructional video, and boost the sound on your camcorder for professional audio.
Watch this video to learn to do power yoga. In Ashtanga yoga, also known as power yoga, the yoga postures flow with an emphasis on strength and agility. In this video clip learn step by step yoga moves that will help you unite your body, mind and breath. And remember each pose can be modified to suit the practitioner's level of skill.
This video clip shows you how you cannot fool any candy machine and debunks the mythical paper hacks in detail. Some say it works, some say it doesn't. Well, check out this video tutorial and decide for yourself what believe. It might just be easier to steal candy from a baby.
This video will give you shocking results. Find out how to make a couple of alterations using paper clips and a screwdriver to turn a disposable camera into a taser.
A hack for your PDA. Use your PDA as a 13" LCD Wall Projector. Use Pocket PC, videoPod,PSP or others! Watch Youtube clips if you have wireless! Step by Step. Make in under 5 mins!
Using a paper clip and rubber band, you can rig a trick envelope to prank your friends.
Sosh and Gina continue your Lindy Hop education. This clip will teach you how to communicate with your partner. The front to front, the sling shot, the scissor kick, the swing out, the big turn, are all dance moves distinct to the Lindy Hop. It was named for Charles Lindbergh and his Atlantic crossing in 1927. Black communities invented the moves, and the popularity spread throughout the world.
What Is Needed? Marker Caps, about 4 or 5
In this podcast tutorial, Creative Cow leader Aharon Rabinowitz shows you how to export your video as Adobe Clip Notes. Part 1 will show you how to prepare and export your After Effects composition so your notes appear in a PDF document alongside the video. Part two shows you how to use them and export them back to After Effects. Work with Adobe Clip Notes in After Effects - Part 1 of 2.
This video shows you how to work with independent timelines, specifically the main timeline and movie clip timelines. You learn about how multiple timelines can interact, and how to navigate using the edit bar when you have multiple timelines. You nest movie clips and learn how they interact, and nest instances to create effective animations. Use multiple timelines in Flash CS3 Professional.
In this video, we learn how to make video clips into animated gifts. First, open Windows Movie maker and import a video file. Now, shorten the video to four seconds or less and save it. Now, go to the website gif ninja. Once on this site, you will see a section that says "tools", then click the button to convert your image to GIF. Once on this, you can browse and upload the file that you just created. Next, click "make my gif!" and a status bar will load on the bottom. When this is done loadi...
In this clip, learn how to make a perfect citrus cake for summertime. This orange sponge goes great with warm weather cocktails, coffee or even as breakfast. Follow along with this clip and learn how to make this deliciously moist dessert.
In this video by PI Classroom you get to learn how to remove the sim chip from an i-phone. The video provides a step by step process for removing the sim chip. The only tool required is a paper clip.
Byrd Designs Hair Accessories and Jewelry brings you this video tutorial on how to style your hair in a French Twist updo. This simple updo works in all types of hair.
What's better than one prank? Five pranks! This video from the notorious Kipkay provides five fantastic, funny, and facile pranks to pull off on your friends and family… maybe even your enemies.
Check out this informative video tutorial from Apple on how to trim edits between video clips in iMovie '09.
The Galaxy S9's Super Slow-mo feature comes packed with tools that help you tweak your slow motion clips like a pro. Among these is the ability to convert your slow motion videos into GIFs with a user-friendly interface. As a result, it's incredibly easy to go from recording to GIF conversion and on to sharing in a few taps.
Introduced along with the iPhone X, Animoji are animated characters, mostly animals, that are rendered from the user's facial expressions using the device's TrueDepth camera system to track the user's facial movements.
Adobe Premiere Clip is a great mobile app for users with little to no editing experience. Its automatic editor will sort your clips into a fun video in seconds, leaving you to just choose the music. But what if you're looking for more than automatic settings? What if you want some serious control over your project, from the editing to the way the image looks?
If you've seen ParaNorman or Fantastic Mr. Fox, then you have some kind of idea of what stop-motion animation is. Basically, these artists make objects, or small figures, appear to be moving on their own by manipulating and repositioning them in the smallest increments, then capturing each frame after doing so. When all the frames are compiled together, the final product is something spectacular like The Nightmare Before Christmas, which took roughly 109,440 frames in all.
How heavy is a plastic bag? Not very heavy at all, but in order to use a plastic bag to help me karate chop a thin wooden stick, I don't need weight—I need air pressure. Below, the "Quick Clip" demonstrates the power of air pressure via the vacuum created between a plastic bag and the countertop.
In this "Quick Clip," I tried dunking inflated balloons into a container filled with liquid nitrogen until they were completely flattened and seemingly destroyed. Once out of the liquid nitrogen, the balloons come back to life and reinflate on their own—without even touching them!
Plastic bread clips, which are primarily used to keep bread bags closed, can also be used to add new life to your old flip-flops, scrape gunk off your nonstick pans, keep matching socks together before laundering, label your cable cords, and more.
Learn how to make your very own Japanese Yamaha paper craft motorcycle YZR-M1! These easy-to-follow instructional paper craft video clips explain everything from basic paper craft techniques and how to make major parts of the realistic paper crafts, right up to the final assembly of your Yamaha motorcycle YZR-M1. These paper craft videos are full of useful tips for efficient construction and superb finish! Watch it, and you'll want to make a realistic paper craft motorcycle yourself!
