Digital Methods Search Results

How To: Enhance traditional art methods with digital media

Have you ever heard of tradigital art? Tradigital art incorporates traditional materials with digital media. This is a combination of such techniques as illustration with Decocolor Markers, Prismacolor Markers, pencils, and Photoshop. Watch this tutorial to learn how to enhance traditional art methods with digital media. It illustrates the tradigital process step-by-step. Make sure to pause the video after each step and look at the screen every few seconds while you are drawing.

How To: Use Siri on Your Apple Watch

If you have an Apple Watch, it's easier than ever to ask Siri for directions, send a quick text, or locate the nearest Chipotle—because you don't need to pull out your iPhone anymore. Luckily, Apple made it fairly painless to get Siri up and running on the Watch, so let's go over the two quick activation methods.

How To: Filter data in eight different ways in Microsoft Excel

hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 17th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to filter spreadsheet data using eight different methods.

How To: Calculate income tax payroll deductions in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business 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 42nd installment in his "Excel Business Math" series of free video lessons, you'll learn about the wage bracket and percentage methods for calculating federal income tax payroll deductions.

How To: Calculate a bonus 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 and Mr. Excel, the 24th installment in their joint series of digital spreadsheet magic tricks, you'll learn 5 different methods for calculating a bonus using VLOOKUP, MAX, Boolean, and 2 IF formulas.

How To: Use wildcard counts 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 and Mr. Excel, the 3rd installment in their joint series of digital spreadsheet magic tricks, you'll see three methods to count records that contain the letter D.

How To: Convert TRUE & FALSE values to 1 & 0 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 314th installment in their series of digital spreadsheet magic tricks, you'll learn four different methods for converting TRUE and FALSE values to 1 and 0 (zeroes).

How To: Make budget summary tables that add by month 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 642nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a budget summary table that adds by month and payee. See the benefits and drawbacks of the SUMIFS & EOMONTH functions method or the PivotTable method. Also learn about the Excel Table feature for adding dynamic ranges.

How To: Count with more than 1 criteria 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 and Mr. Excel, the 27th installment in their joint series of digital spreadsheet magic tricks, you'll see ten different methods counting with more than 1 criteria.

How To: Decrease values 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 and Mr. Excel, the 2nd installment in their joint series of digital spreadsheet magic tricks, you'll see two methods for subtracting 35% from a column of values.

How To: Verify an ID prefix 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 311th installment in their series of digital spreadsheet magic tricks, you'll learn three different methods for determing whether a Produt ID prefix matches a second specified prefix.

How To: Count data without an upper limit 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 198th installment in their series of digital spreadsheet magic tricks, you'll learn three different methods for counting quantitative data in categories that include a lower limit but not an upper limit.

How To: Make a heart-shaped scrapbook album

This heart-shaped chipboard scrapbook is a hybrid album using both digital and traditional scrapbooking methods. This video scrapbooking tutorial shows how to make a heart-shaped scrapbook mixing different scrapbooking techniques. Learn how to make this scrapbook photo album by watching this instructional video.

How To: Model complex organic forms (ears) in 3ds Max 8

In this 3ds Max video tutorial you'll see how the spline method can be used to model a very complex form, such as the ear, in Autodesk's 3D Studio Max digital graphic modeling software. You'll see several tools found in EditPoly for creating overhangs, and also look at attaching the ear seamlessly with an existing head. This process works directly in conjunction with Adobe Photoshop, specifically topology, just so you know.

How To: Define topology lines on reference images in Photoshop

This video tutorial goes over methods for defining the topology of an organic object in Adobe Photoshop. This is helpful as a planning stage before you begin your 3ds Max 8 digital 3D modeling to make sure that your have proper distribution of faces and your target mesh will deform nicely. So, if you're using Autodesk's 3D Studio Max for awesome 3D graphics, this could help you out with Photoshop topology.

How To: Import media from DVDs in Corel VideoStudio

This video shows the method to import digital media in Corel VideoStudio. Click on the 'Capture' tab once the program is open. There are four options available. Click on 'Import Digital Media'. Now a dialog box opens asking you for the location of the place where you would be importing files. Keep the disk with the file in your drive. Click on 'Import'. You are now asked the file you want to import. Select the file and click 'Import'. The import can take time depending on its size. After the ...

How To: Use color correction 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 use color correction in Photoshop.

How To: Use AGGREGATE instead of SUBTOTAL in MS 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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...

How To: Manually focus a Panasonic G1 or GH1 digital camera

Learn how to manually adjust lens focus when using a Panasonic G1 or GH1 digital camera. Whether you're the proud owner of a Panasonic Lumix DMC-G1 or DMC-GH1 micro four thirds digital camera or perhaps just considering picking one up, you're sure to like this free video tutorial, which presents a complete overview of how to focus a G1 or GH1 camera by hand. For more information, including detailed instructions, watch this digital camera user's guide.

How To: Shoot sunsets on a Panasonic G1 or GH1 digital camera

Learn how to optimize a Panasonic G1 or GH1 digital camera for sunset photography. Whether you're the proud owner of a Panasonic Lumix DMC-G1 or DMC-GH1 micro four thirds digital camera or perhaps just considering picking one up, you're sure to like this free video tutorial, which presents a complete overview of how to get terrific sunscapes shots with a G1 or GH1 camera. For more information, including detailed instructions, watch this digital camera user's guide.

How To: Make a 3D scanner with free software

Scanners have been around for a while. They allow us scan photos and documents into digital versions that are a lot less susceptible to damage over time. But what if you want to digitize the memories of something that isn't 2D? With this hacker's how-to, you'll learn a method for making a 3D scanner. To follow along, you'll need a computer, a printer, a web cam, white foam board and a laser pointer.

Prev Page