Learn how to round to a given interval when making time-based calculations in MS Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2007 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.
Looking for a primer on how to use the DATEDIF function in MS Excel 2007? You're in luck. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2007 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.
Need an introduction to Excel's useful TODAY & NOW time functions? You're in luck as this clip provides just that. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2007 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.
Multiplicity photography is a type of photography where you take multiple images of the same subject in different parts of the same frame, then combine them digitally to create a photo with multiple different images of the same person, animal, or object in the same setting. This is also called sequence photography when it's used in sports. This video will show you how to do it with a digital camera and Photoshop, creating amazingly cool-looking results.
Imagine your own time-lapsed footage in a 360 degree pan. You don't need an expensive Hollywood-style pan mount to get this effect. You can easily do this rotating pan mount on the cheap, with something you would never suspect— a kitchen timer.
Gambit is one of the coolest X-Men, and his kinetic energy powers are awesomely powerful. If you want to depict them using special effects in a film, this video will show you how to do it using three free pieces of digital editing software:
Prank calls are almost as old as the phone itself, but have entered a beautiful renaissance in the digital era. No need for the phonebook or a pay phone service anymore! This video will show you how to make really good, funny prank calls in the 21st century, including a rundown of necessary equipment and help with technique.
In this tutorial, we learn how to use Nikon digiscopes. This means taking digital pictures with a digital camera through a lens. You can use two different versions of lenses with the Nikon Coolpix camera. You will need an eyepiece to use the camera with these lenses. You can get up to 75x magnification while using these, but risk of camera shake is greater. First, mount the camera on the triPod and apply the lens adapter, then the Coolpix camera. After this, use the view finder to see through...
This video from accredited Maya 3D instructor Andrew Klein is a part of his wonderful series of videos covering different aspects of 3D digital art. It covers how to use Photoshop and Maya together to create, align, and sync image planes properly. Take some pictures of your cell phone and get started!
Generate lace from scratch with Adobe Photoshop CS4 or CS5! Whether you're new to computer graphics, new to Adobe Photoshop CS4 or a seasoned design professional just looking to pick up a few new tips and tricks, you're certain to like this free video software tutorial. For more information, including detailed, step-by-step instructions, and to get started using this trick in your own Photoshop projects, watch this guide!
Learn how to make beautiful, wavy, realistic hair in Adobe Photoshop using custom brushes. Whether you're new to computer graphics, new to Adobe Photoshop CS4 or a seasoned design professional just looking to pick up a few new tips and tricks, you're certain to like this free video software tutorial. For more information, including detailed, step-by-step instructions, and to get started making your own digital hair in Photoshop, watch this guide!
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 618th installment in their series of digital spreadsheet magic tricks, you'll learn about a handy key command that will allow you to enter both today's time and date into a single Excel cell.
Looking for an easy way to polish your digital images in Photoshop? Whether you're new to Adobe's popular image editing software or a seasoned graphic design professional just looking to better acquaint yourself with the unique features of Photoshop CS5, you're sure to find something of value in this free video tutorial.
Adobe apparently did not plan for it's AIR protocol to lead to people turning their websites into programs, but it turns out that it is fairly easy to do. This video tutorial explains in great detail how to create an AIR application using Flash CS4. Topics include how to create a digital signature and .swf files that you will need to create the program.
If you're thinking about venturing into the world of using Camera Raw in Photoshop, you've come to the right place. The camera raw function in Adobe Photoshop provides easy access to raw image formats produced by many digital cameras. In this video, learn all about how to get started using the Camera Raw Utility plug-in for Adobe Photoshop.
Want to separate a foreground object from its background? Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from TutVids. For more information, including step-by-step instructions on how get started doing digital tattoo removal yourself, watch this graphic designer's guide.
Touch up your digital photographs for studio-quality images. Whether you're new to Adobe's popular image editing software or simply looking to pick up a few new tips and tricks, you're sure to benefit from this free video tutorial from Tutvid. For more information, and to get started creating pixel-perfect images yourself, watch this graphic designer's guide.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 6th installment in their series of digital spreadsheet magic tricks, you'll learn how to add conditional formatting to a whole row of data in an Excel sheet.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 288th installment in their series of digital spreadsheet magic tricks, you'll learn how to count the number of characters or numbers in a text string with a formula that is case sensitive.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 292nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first and last names from an Excel spreadsheet and rearrange them using a formula.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 241st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a data validation drop-down cell list where the list shrinks as you select values.
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 230th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the Excel List Table feature to make a dynamic stock price line chart.
New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 264th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a recorded macro to take a data set and add a new column, concatenate data from 3 columns, and delete unwanted columns.
Whether you're new to Adobe InDesign or a seasoned graphic arts professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to create compelling eBooks with enhanced support for the EPUB file format with CS5 Design Premium and Digital Editions.
Whether you're new to Adobe After Effects or a seasoned digital film professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to turn spoken dialogue into searchable text either by synchronizing content with your Adobe Story script, or by using reference scripts that are optimized for your content. Also see how to accelerate editing by marking in and out points in t...
Whether you're new to Adobe After Effects or a seasoned digital film professional after a general overview of CS5's most vital new features, you're sure to be well served by this official video tutorial from the folks at Adobe TV. In it, you'll learn how to isolate moving foreground elements from their backgrounds faster using the revolutionary new Roto Brush approach that works much like the Quick Select tool in Photoshop.
How to Make Anything demonstrates how to make a freeze frame in Sony Vegas. You can go to the preview window and click on save snapshot to file. The program will then create a jpeg which you can lay into your video to create a freeze frame. You can also use Vegas' velocity envelopes to create a freeze frame. First, zoom into your video in the timeline so that you see each individual frame. Make sure that quantize to frames is toggled in the options menu. Then, hit S to split the video. Right ...
Advance Photoshop shows viewers how to make the Photoshop CS3 icon in Photoshop. First in Photoshop go to File and then click New. Make a new blank at 500 x 500 pixels. Go to your layer button and create a new layer. Next, go to your rectangular marquee tool, hold down shift, and make the rectangle slightly smaller than the canvas itself. Set it from foreground to background and change the background color to a dark blue, enter 15396F for the color. Click on foreground color and enter 3070CA ...
Looking very much like an outsized iPod Touch, it's only natural that the Apple iPad be a great device for music. With this official video guide from Apple, you'll learn how to use Apple's free iPod app to browse, manage and listen to your digital music library.
Kevin Hnatiuk (the Digital Dad) shows you how to convert your old Super 8 film reels to DVD, easily at home. Knatiuk goes over how to get started, what you need, and what to expect when digitaizing your super 8mm movies.
Kipkay from Make Magazine shows us how to create a photographic illusion, making things look smaller than they really are with tilt-shift photography. Materials needed include rubber plunger, an oversized lens, a plastic body cap, a single lens (or digital single lens) camera, a hot glue gun, a sanding file, and a disposable object for a plastic backing, such as a VHS tape case. With this great tutorial and a little work, create the illusion of a miniaturized world with this photographic tech...
PixelPerfect teaches you everything you need to know about being a digital artist. Learn tips and tricks to turn your regular vacation photos into works of art worthy of museums.
Everything you need to enjoy your new digital library is in iTunes. iTunes organizes all your music and video into categories you can browse easily.
Watch this to see how to hookup a digital to analog television converter. When analog broadcasting ends in February 2009, you're either going to have to buy a new TV, pay for cable, or get a converter box.
Ted from Red Digital, and Michael from PlasterCITY, shows how to take a 4k source file, edit in real time, and make dailies in Final Cut Pro.
Need some smooth pan shots for your indie film? How about a cool dolly zoom effect? Well, you don't need to be a professional filmmaker to use such a device, but you do need the money for the gear. But—if you can work your way around the workshop, you can probably build your own camera dolly and track just fine. And for under $100! This video shows you how to build your own DIY dolly and dolly track, and all you need are the parts listed below. Then you just need to learn the art of the dolly...
Learn how to create a 3D anaglyph image (the kind of 3D image you see with 3D glasses) using Adobe Photoshop and a digital camera.
This tutorial shows you how to make a picture frame using a Mattel Juicebox media player.
Send in the clones! Steve Nelson teaches you how to create a digital cloning effect for your films. Create duplicates of your actors on screen.
Looking to create great special FX for you films using a green screen. Steve from Indy Mogul teaches you how to shoot using a blue screen or a green screen and also how to add in your own digital backgrounds.
