Digital Realm Search Results

How To: Sell your stuff on eBay

Turn your possessions into cash and become an online selling machine. You will need: Something to sell, a computer with internet access, an eBay account, a digital camera, shipping supplies, something to sell,a computer with internet access, an eBay account, a digital camera, & shipping supplies.

How To: Use the JVC GY-DV5100U professional camcorder

Check out this cinematography tutorial video that demonstrates how to use the GY-DV5100U Professional DV Camcorder. JVC has upgraded the camera's features and digital processing circuits to meet the requirements of a growing number of broadcasters looking for cost effective alternatives to the over-priced tapeless solutions of other manufacturers. This video is great for cinematographers and filmmaking aficionados alike. Learn all the functions and settings on the GY-DV5100U with this instruc...

How To: Make a high-tech spy stethoscope

A stethoscope, often considered the symbol of a doctor's profession, but also used by safe-crackers and auto mechanics to hear sounds that otherwise couldn't be heard. Well, it's time to make a high-tech electronic spy stethoscope with Kip Kay in this gadget video tutorial, for only twenty-five bucks! You can hear and record heartbeats with this spy gadget, or even listen through walls!

Coinbase 101: Fees & Fine Print You Need to Know Before Trading Bitcoins & Other Cryptocurrencies

Coinbase is the primary go-to for many users when it comes to investing in Bitcoin (BTC), Ethereum (ETH), Litecoin (LTC), Ripple (XRP), and more, due to its user-friendly interface. But before you join them, know that the ease of use comes with a price. Coinbase charges fees for each transaction, and your bank might even add charges on top of that. Plus, there is some fine print to be aware of.

Hack Like a Pro: Digital Forensics for the Aspiring Hacker, Part 16 (Extracting EXIF Data from Image Files)

Welcome back, my greenhorn hackers! In many cases when a computer, phone, or mobile device is seized for evidence, the system will have graphic images that might be used as evidence. Obviously, in some cases these graphic images may be the evidence such as in child pornography cases. In other situations, the graphic images may tell us something about where and when the suspect was somewhere specific.

Hack Like a Pro: Digital Forensics for the Aspiring Hacker, Part 5 (Windows Registry Forensics)

Welcome back, my aspiring hackers! As I mentioned in earlier posts, the best hackers (or at least those not behind bars) have a keen understanding of digital forensics. If I am tasked to intrude upon an enemy's file server to retrieve war plans, such as in this tutorial, it is essential to my country's (and my own) well-being that it not be traced back to me. Understanding digital forensics helps us to leave without a trace and never have a trail back to us or our employer.

How To: Calculate liquidity ratios in Microsoft Excel 2010

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 16th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate liquidity ratios including current ratio, times interest earned and cash Ratio. Also see how current ratio changes when certain trans...

How To: Make a DIY video remote for Canon DSLR cameras for under 10 bucks

If you have a Canon digital camera and plan on shooting video with it using a camera rig, then you'll want a good way to control your recordings with a start/stop button. A remote control is the way to go, but don't spend all that money— make your own! The remote in the video is hardwire into the camera and onto the rig for easy handling. You'll need your Canon 5D MK II HD DSLR (but it will work on other Canon models, too), a Canon RC-6 Remote Control (or generic brand), fiber optics cable, w...

How To: Make high-quality home music recordings on a shoestring budget

If you're a musician, but can't cover the cost of an expensive recording studio to get your song onto a playable media, then this video is what you need. It will show you how to make your own high-quality home music recording studio on a shoestring budget! If you're trying to get the attention of big music record labels, you need some hgih-quality sounds, but you don't need the high-quality costs! The setup is pretty simple— a microphone, MP3 player, sound mixer, headphones and a good-quality...

How To: Make smart contact sheets with Photoshop

In this photography tutorial, you learn how to create a contact sheet using Photoshop for your digital photography prints. In order to create this contact sheet, you can open Photoshop, go to File, find the subfolder called "Automate" and then choose to create a contact sheet. If your version of Photoshop does not appear to have this setting, your version of Photoshop should have come with a secondary disk which has this feature. You can also find the file from Adobe if you do not have the go...

How To: Edit a beat in Logic Pro Studio 8 or 9

In this two-part lesson, you'll learn how to edit a simple beat when writing electronic music in Logic Pro. 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 from NextStepAudio.

How To: Extract numbers from a text string with Excel's LEFT, SEARCH & TRIM functions

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 706th installment in their series of digital spreadsheet magic tricks, you'll learn how to to use the LEFT, SEARCH and TRIM function to eaxtract numbers from a text string that can then be used in a calculating formula.

How To: Use Photoshop CS5's content-aware fill tool to remove an element from an image

Want to know how to remove unwanted objects from a digital photo with the content-aware fill tool in Adobe Photoshop CS5? It's easy. And this clip will show you precisely how it's done. 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: Increment numbers in formulas 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 692nd installment in their series of digital spreadsheet magic tricks, you'll learn how to increment numbers in formulas to get 2,2,2,2,4,4,4,4 or 1,1,1,1,3,3,3,3 or 1,2,3,4,1,2,3,4 or 11,22,33,44 using the ROWS, INT, MOD and COLUMNS functions.

How To: Identify the first occurrence of a value in a column 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 create a column of 1s and 0s (ones and zeroes) where 1 indicates the first occurrence and 0 indicates any remaining duplicates.

How To: Create a vivid eye color effect in Adobe Photoshop CS5

Looking for a quick guide on how to really make your model's eyes pop when retouching a digital photo in Adobe Photoshop CS5? 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 ...

How To: Clean up a photo of a newborn in Adobe Photoshop Elements

Interested in using Photoshop Elements to touch up a digital photograph of a newborn baby? 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: Retouch and edit portraits in Adobe Photoshop CS4

Want to touch up a digital portrait in Photoshop CS4 but need some help getting started? 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: Calculate Commission Based on Varying Rates 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 673rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT formula to calculate commission amounts based on varying commission rates based on cumulative sales totals for each month.

How To: Count with OR 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 674th installment in their series of digital spreadsheet magic tricks, you'll learn four different methods for counting OR criteria in Microsoft Excel 2010:

How To: Validate data with dynamic VLOOKUP functions 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 675th installment in their series of digital spreadsheet magic tricks, you'll learn how to do data validation using a custom logical formula with 2 VLOOKUP functions that will change when different products are entered. For example, if shirt product is entered, the data validation will let only values between $50 and...

How To: Create a defined name for a dynamic range 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 676th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Defined Name formula for a dynamic range (columns can vary) using the INDEX and MATCH functions. This formula works when there are no column headers (field names).

How To: Average the last three values for an entity 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 677th installment in their series of digital spreadsheet magic tricks, you'll learn how to average the last three scores eneterd for any Player using the functions: AVERAGE, IF, ROW, COUNTIF, MIN, LARGE.

How To: Sum values after a deadline 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 678th installment in their series of digital spreadsheet magic tricks, you'll learn how to SUM only the values after a deadline using a dynamic range formula using INDEX Function. Also see a SUMPRODUCT function method.

How To: Add yearly totals from monthly data 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 679th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize yearly totals from monthly totals when there Year Criteria is entered as a serial date. See the SUMPRODUCT and SUMIFS functions. Learn about criteria and how to enter it into the SUMIFS functions.