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.
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...
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.
You have a ton of options and extensive possibilities on the Canon EOS 7D to configure different buttons and controls. You can change just about anything on this digital SLR camera. Watch this video for info on customizing operations.
You can easily share and transport your photo and videos on the Canon EOS 7D by using the wireless file transmission option. See exactly how sharing and downloading your files to computers and other devices works in this video. When the digital SLR camera is combined with the WFT-E5A Wireless File Transmitter, transmitting is easy.
There's a new LCD viewfinder on the Canon EOS 7D, and in this video, you get to see all about it. See how you can change your viewfinder options on this digital SLR camera with ease. You can display almost any information you want.
The EOS 7D has an accurate level display, which you can activate on either the read LCD monitor or in the viewfinder. See how to work the electronic display on the Canon digital SLR camera. This is great for getting a steady shot wherever you need it.
See the workings of memorizing AF points on the Canon EOS 7D digital SLR camera. It's easy to memorize points and come back to them whenever you want, by just pressing a button. See how to use the memorization option in the video.
You can gain even greater precision on the Canon EOS 7D digital SLR camera by using Spot AF or AF Point Expansion. When you manually choose one AF point, you also have the option of changing its size. You focus point will be exactly what you want. Very specific.
Let your Canon EOS 7D do all the hard work. With the AF Point Selection option, the digital SLR camera will do all the focusing for you. It's easy to compose and shoot in just one step.
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.
Live View wit the EOS 7D camera from Canon, lets you compose and view your subjects with the LCD monitor as your viewfinder. This is great for a multiple of reasons. See how to use live view on this digital SLR camera.
In video shooting, it's always best to select manual focusing on the Canon OES 7D digital SLR camera. If you need to adjust focus during filming, then you can manually refocus when needed, but there are also powerful autofocus options available. Watch this to see how to change the movie mode settings for your needs.
The new Canon EOS 7D digital SLR camera uses a powerful lithium-ion battery called the Canon LP-E6. You can manage your battery's capabilities with the battery display in your camera. See how in this video.
If you're not one to trust you digital SLR camera's automatic focus options, then the only thing you have to do is go to manual mode. With the Canon EOS 7D, select the Manual AF Point Selection and take control. It allows you to pick the area you want to focus on.
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.
Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to create realistic reflections in Photoshop.
Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to animate a 3D plane in Photoshop.
Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to create flooring in Photoshop.
Pixel Perfect is the "perfect" show to help you with your Photoshop skills. Be amazed and learn as master digital artist Bert Monroy takes a stylus and a digital pad and treats it as Monet and Picasso do with oil and canvas. Learn the tips and tricks you need to whip those digital pictures into shape with Adobe Photoshop and Illustrator. In this episode, Ben shows you how to create fabrics in Photoshop.
