Centro Digital Search Results

How To: Set up & solve simple word problems in Microsoft 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 14th installment in his "Business Math" series of free video lessons, you'll learn how to set up and solve and write conclusions for simple word problems in Excel.

How To: Conditionally format a vertical histogram in Excel 07

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 199th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply conditional formatting to a vertical histogram based on a frequency distribution in Microsoft Excel 2007.

How To: Backup your photos in Apple iPhoto

Backing up your digital photos with Apple iPhoto while running Mac OS X can give you peace of mind of knowing that you will not accidentally lose your precious photos. In this video tutorial, you'll learn how. For more, or to get started backing up your own photos in Apple iPhoto, watch this how-to.

How To: Optimize your Windows PC

Has your Windows PC grown increasingly sluggish over time? In this how-to, Digital Connector James Vargas (recalling a young Jean-Pierre Léaud) guides users through speeding up and optimizing a Windows PC. Take a look. Whether you run XP, 2000 or Vista, you're certain to benefit from this tutorial.

How To: Draw a caricature in a different way

This is one of the ways that artist Merrill Kazanjian makes his caricatures. He shows the viewer how to make a traditional/digital hybrid (tradigital) collage portrait. Look for interesting eyes, noses and mouths from different photographs. Make an oval for the head and paste down the facial features. Watch to learn more.

How To: Adjust color in iMovie '08

iMovie allows the average computer user the ability to quickly make movies out of your digital video footage or home movies. This is not the most professional way to color correct your footage, but it should be sufficient for the average Mac user. Follow along and see how to adjust color using iMovie.

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.

News: Mindful relaxation video

Enjoy this relaxing video and use it as a path to meditation. Forget your problems for 3 minutes and let you mind wander in the clouds. The digital enhancements applied to some of the skyscape scenes will allow you to see all kinds on shapes as your mind is let free to interpret.

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: Photoshop digital bokeh

Ash Davies teaches us how to Photoshop digital bokeh with this tutorial. First, open up Photoshop and create a new canvas with your width at 1920 and your height at 1200. Now, create a new layer and set your background layer as invisible. Now create a medium size circle and reduce the fill to 50%. Now enter blending options and add a stroke of 10 pixels to the inside with the color set to black. Now define the shape as a brush and then click "edit" and "define brush preset" name this, "bokeh"...

How To: Rip DVDs and convert videos with HandBrake

Everybody is going digital these days, so everybody has a reason for software like HandBrake. You can save your entire DVD collection on your computer in digital files, and you can convert videos into different formats. Check out this video tutorial on how to rip DVDs and convert videos on Ubuntu Linux, Windows, and Mac.

How To: Retouch or add digital makeup using Photoshop

If you want to retouch or add digital make up using Photoshop you should first erase and cover up any blemishes you see on the surface of the skin. This can be bruises, blemishes, or even acne marks and bumps. Do this anywhere you feel necessary such as the face or on the body. Using the lighten tool, you can also lighten the eye color as well as the whites of the eyes. Next, you can also adjust the texture and color of the lips. You can also shift the color saturation of the picture to add r...

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.