Digital Realm Search Results

How To: Make sure entries are unique in Microsoft Excel 2010

Looking for a way to ensure your entries are unique in Microsoft Excel 2010? This clip will teach you what you'll need to know. 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, watch this free video guide.

How To: Use the Google Mobile App for the iPhone to search better

Google has it fingers in just about every digital pie there is, including the App Store of their leading smartphone OS competitor, Apple. This video will show you how to use the Google Mobile App for the iPhone, a great app that allows you to do Google voice searches and all sorts of other handy search tasks. Apple is pretty sweet, but Apple and Google together is a huge mobile phone combo.

How To: Take a picture with a BlackBerry Curve 8520 phone

Learn how to use the digital camera in your BlackBerry Curve 8520 phone to take pictures. This clip will show you how it's done. Whether you're the proud owner of a BlackBerry smartphone or are merely considering picking one up, you're sure to be well served by this video guide. For detailed information, including step-by-step instructions, take a look.

How To: Calculate the difference between two dates in Microsoft Excel 2010

Learn how to find the difference between two dates with MS Excel 2010's DATEDIF function. 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.

How To: Use the TODAY and NOW functions in Microsoft Excel 2010

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.

How To: Round when making time calculations in Microsoft Excel 2007

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.

How To: Use the DATEDIF function in Microsoft Excel 2007

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.

How To: Use the TODAY and NOW functions in Microsoft Excel 2007

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.

How To: Take multiplicity or sequence photographs

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.

How To: Use Nikon digiscopes or telescopic lenses

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...

How To: Wrap a model in digital lace in Adobe Photoshop CS4

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!

How To: Create hair with highlights in Adobe Photoshop CS4/CS5

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!

How To: Add today's date & time via keyboard shortcut in Excel

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.

How To: Enhance your digital photos in Adobe Photoshop CS5

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.

How To: Use Adobe Camera Raw in Photoshop

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.

How To: Add or remove tattoos in 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.

How To: Sharpen and smooth skin in Photoshop CS4

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.

How To: Count characters & numbers within a string in MS Excel

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.

How To: Reverse first & last names by formula in MS Excel

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.

How To: Make a shrinking data validation list in MS Excel

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.

How To: Use an Excel macro with relative & absolute references

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.

How To: Design compelling eBooks in Adobe InDesign CS5

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.

How To: Edit with enhanced speech analysis in Premiere Pro CS5

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...

How To: Rotoscope with Roto Brush in After Effects CS5

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: Use the iPod app on an Apple iPad

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.

How To: Tilt-shift photography to create a miniature effect

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...