Learn how to make time-based calculations with the TODAY and NOW functions in MS Excel 2010. 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 2010 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.
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.
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.
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.
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.
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.
Looking to make use—if not necessarily good use—of your old hard drives? This how-to presents instructions for creating a hard drive speaker system to use in conjunction with an MP3 player. To follow along, you'll need an MP3 player (e.g., the Samsung YP-S3), at least one spare hard disk, wire, a soldering iron, and a screwdriver. For step-by-step instructions on hacking together your own hard drive sound system, take a look.
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.
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.
In this tutorial, we learn how to make a family photo album from digital photos. iPhoto from Apple has a ton of different options for you to make a great photo album. You can first start out with loading these on your computer and then creating them into a book. After this, you can choose the borders and text that you want to include in this, then drag the pictures in. After this, you can add in captions for each of the photos and then design the layouts of the different pages. After this, yo...
System Restore is a great and valuable feature in Windows XP and Vista. If you haven't taken advantage of System Restore yet, what in the heck are you waiting for?!? Using System Restore will allow you to make a backup of all your system files at a specified point in time. You can create checkpoints in case your system gets corrupted or has problems because of a recent change you may have made to Windows. Watch and see how to backup your PC… now! And click here for more information.
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.
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...
The Zone AF option on the Canon EOD 7D is a brand new feature, and it lets you select a cluster of AF points, which could be in center or off-center. In this video, see how to actually use the Zone AF selection on your digital SLR camera.
