News: Get the Dog of Your Dreams with Rumored ARKit App
Dogmented reality might be coming to Apple's ARKit, so get ready to play with your new (AR) pups! Don't Miss: A Breakdown of the What Apple's New ARKit Can Do for iPhones & iPads
Embracing Digital Search Results
News: This Fun HoloLens App Transforms Any Room into the Matrix
If you've ever wanted to live in the Matrix—or at least the iconic digital rain data visualization that Neo saw when realizing he was, indeed, the "one"—you can now do that with the Microsoft HoloLens. Just download The Red Pill.
How To: Pick blackberries and make blackberry jam
These days, with so many digital distractions clogging the cloud - Twitter, Facebook, Blackberries, and iPads just to name a few - very few of us spend quality time just talking and cooking and eating with those we love. Take some time out to remember what it felt like to move without a Wii remote by learning how to pick blackberries and preserve jam.
How To: Avoid blur when taking a digital photo on an iPhone
Here's a quick, easy and useful tip: The next time you go to take a picture on your Apple iPhone, try holding the shutter button down as opposed to tapping it. The reason? Tapping can destabilize the camera, resulting in motion blur. Whereas holding the button will ensure that you get a great shot.
How To: Import video into iMovie as a newcomer to digital video
Learn how to import your videos into iMovie by viewing this video. This tutorial shows the various methods used to import the video clips into iMovie, arranging the clips in the timeline, and optimizing the video footage in the editing environment.
How To: Edit sound and add music to video with Windows Live Movie Maker
When editing digital footage within Windows Live Movie Maker, it's important that you not forget that you're not working in a strictly visual medium—that is, you should also give some consideration to your movie's soundtrack. This clip from Vimeo's excellent Video 101 covers how to do basic sound editing within Movie Maker.
How To: Shoot a time lapse film with a digital camera
Time lapse photography is a common film technique to capture subtle processes, such as star movement or sunst. This tutorial shows you all the equipment you'll need, how to set your camera up properly, and how to string it together for a film.
How To: Use an EOS stabilizer with your digital cameras
Are stabilizers worth the investment? Which one is the best? How can you get the most out of the stabilizer you already have? This tutorial provides the answers to all these questions, and more! Decide which stabilizer is right for your camera and budget.
How To: Use CGI in a live action film
CGI and live action shots get together in almost every big-budget Hollywood movie these days, but combining them in one shot can be challenging for the uninitiated. This video will teach you all about using CGI in live action films, including the use of 3D Studio Max, Blender, and other software to do the animation, rendering, compositing, and other digital steps to making great CGI-live action integration happen.
How To: Cure obesity in Photoshop with the Forward Warp Tool
Obesity is no longer a problem in the world— at least, in the digital world. This Photoshop tutorial will show you an easy trick to making fat and obese people a little bit thinner. You can even make slightly overweight women and men into beautiful and skinny models. Get rid of those love handles!
How To: Use Antares Auto-Tune Evo in Graphical Mode in Pro Tools 8
In this video tutorial, we learn how to use the Antares Auto-Tune Evo pitch-correction plug-in in Graphical Mode when running Pro Tools 8. Whether you're new to Digidesign's popular DAW (digital audio workstation) or simply new to Auto-Tune, you're sure to be well served by this video guide.
How To: Use a vector graphic from Illustrator in an Photoshop CS5 project
In this video tutorial, we learn how to create two separate exposures for the same image with Camera Raw when retouching a digital photograph in Adobe Photoshop CS5. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.
How To: Paint on top of a photograph in Adobe Photoshop CS5
In this video tutorial, we learn how to paint or draw on top of a digital photograph in Adobe Photoshop CS5. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.
How To: Clean up the background when retouching an image in Adobe Photoshop CS5
In this clip, you'll learn how to clean up a background when retouching a digital photograph in Adobe Photoshop CS5. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.
How To: Calculate leverage and solvency ratios in Microsoft Excel
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 17th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the debt ratio, debt to equity ratio, equity multiplier ratio and times interest earned ratio.
How To: Use the SUMIF function with approximate criteria in Microsoft 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 730th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF function with approximate criteria to add when criteria has other content in the cell.
How To: Use the SERIES chart function in Microsoft Excel 2010
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 732nd installment in their series of digital spreadsheet magic tricks, you'll learn how to make use of the Excel SERIES chart function.
How To: Read an epub-format digital book on your iPad
This tutorial will work on any Apple device running iOS 4. Besides finding books through the Apple store, you can also find unlocked epub-format books (such as through Google Books or the Gutenberg Project) and use the iBooks application to read them on your iPad, iPod Touch or iPhone. Even customize your covers!
How To: Create free ringtones for mobile phone with Apple iTunes 10
If you already own a copy of a song, it's silly to pay again for rights to use it as a cell phone. Especially in light of how easy it is to create custom, free ringtones with the latest iteration of Apple's digital music jukebox, iTunes 10. Take a look.
How To: Add movement to a bassline with filter modulation in Logic Pro 8 or 9
In this clip, you'll learn how to add excitement to a bass part by introducing a filter. Whether you're new to computer recording, new to the Ableton Live DAW (digital audio workstation) or just looking to pick up a few new tips and tricks, you're sure to benefit from this free video software tutorial from NextStepAudio. For more information, including detailed, step-by-step instructions, take a look.
How To: Use the Sculpture Physical Modeling Synth in Logic Pro 9
Interested in becoming better acquainted with Logic's built-in physical modeling soft synth, Sculpture? You've come to the right place. Whether you're new to computer recording, new to the Apple Logic DAW (digital audio workstation) or just looking to pick up a few new tricks, you're sure to benefit from this free video software tutorial.
How To: Warp Time with the Flex Time Tool in Logic Pro 9
Learn how to use the Flex Time tool to alter the speed and timing of your tracks without altering their pitch or introducing nasty artifacts. This clip presents an overview of how to use it. Whether you're new to computer recording, new to the Apple Logic DAW (digital audio workstation) or just looking to pick up a few new tricks, you're sure to benefit from this free video software tutorial.
How To: Rank values based on a single criteria in Microsoft Excel 2010
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 707th installment in their series of digital spreadsheet magic tricks, you'll learn how to rank values based on one criteria using the SUMPRODUCT function.
How To: Extract all the letters from a text string in Microsoft Excel 2010
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 699th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract all the letters from a text string with a VLOOKUP function in Excel 2010.
How To: Use the Liquify filter in Adobe Photoshop CS5
In this clip, you'll learn how to use the Liquify tool when editing a digital image in Photoshop CS5. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, watch this video guide.
How To: Make precision mask adjustments in Adobe Photoshop CS5
In this clip, you'll learn how to make micro adjustments to a mask when working with a digital image in Adobe Photoshop CS5. Whether you're new to Adobe's popular raster graphics editor or a seasoned designer looking to better acquaint yourself with the new features and functions of the latest iteration of the application, you're sure to benefit from this free software tutorial. For more information, and to get started making highly detailed mask edits yourself, watch this video guide.
How To: Freeze titles and create split screens in Microsoft Excel 2010
In this clip, you'll learn how to quickl create frozen titles and split screens or splitscreens within 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, watch this free video guide.
How To: Use navigation shortcuts in Microsoft Excel 2010
Looking for a way to speed up your MS Excel workflow? Try these useful navigation shortcuts on for size. 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: Enter data into nonadjacent cells in Microsoft Excel 2010
Looking for a guide on how to enter data into nonadjacent cells in MS Excel 2010? This clip will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned professional looking to become better acquainted with the features and functions of Excel 2010, you're sure to benefit from this free video software lesson. Take a look.
How To: Browse and view pictures on a BlackBerry phone
Learn how to access and display digital images (pictures you've taken, for example) on a BlackBerry phone running version 5 of the BlackBerry OS. 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: Convert a formula to a value in Microsoft Excel 2010
Learn how to convert a formula to a value in a Microsoft Excel 2010 spreadsheet. 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, and to get started converting formulas in your own MS Excel 2010 projects, watch this free video guide.
How To: Extract month and year records from transactional data in Microsoft 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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract month and year data from transactional records by filtering, array formula and non-array formula.
How To: Move picture files from a Windows PC to a BlackBerry smartphone
Learn how to use BlackBerry Media Sync 3.0 to move your digital images from your PC to a BlackBerry smartphone. 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: Digitize old photo prints, slides and negatives with a multifunction printer
Remember the old days when we used to use film negatives? You'd use them to create slides or even prints from the local photo lab. CNET shows you how to updates all your old photo prints, slides and negatives into digital copies on your computer using a multifunction printer, which most nowadays have slide and negative scanners built right in.
How To: Avoid common mistakes when doing financial analysis in Microsoft Excel
Learn how to prevent fallying prey to cmmon careless errors when doing fiscal analysis in MS Excel. 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: Save an Excel 2010 document for use in Excel 2003
Learn how to make your Excel 2010 spreadsheets compatible with Excel 2003. 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 Ribbon and Backstage View in Microsoft Excel 2010
In this clip, you'll learn how to use the Ribbon and Backstage View 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 off date and time calculations in Microsoft Excel 2010
Learn how to round dates and times to a given interval 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: Use textures to create ambiance and light in Adobe Photoshop Elements (PSE)
Interested in using Adobe Photoshop Elements to enhance your digital photos? This clip will teach you what you need to know. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.
How To: Count with Boolean criteria in Microsoft Excel 2010
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 683rd installment in their series of digital spreadsheet magic tricks, you'll learn how to count with Boolean criteria in Excel 2010.