Digital Video Search Results

How To: Create and use hyperlinks in Microsoft Excel 2011

Need to know how to create and use hyperlinks in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started splitting and freezing rows and columns in your own MS Excel '11 projects, watch the video.

How To: Create a line chart in Microsoft Excel 2011

Want to generate a line chart in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started creating and using line charts to visualize data in your own MS Excel '11 projects, watch the video.

How To: Manage Office themes when using Microsoft Excel 2011

Need some help figuring out how to handle Office themes from within Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started better managing Office theme settings yourself, watch the video.

How To: Create a formula to count cells in Microsoft Excel 2011

Want to create a formula to count cells in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started counting cells by formula in your own MS Excel '11 projects, watch the video.

How To: Create an AutoSum formula in Microsoft Excel 2010

Want to create an AutoSum formula in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started using AutoSum formulas in your own MS Excel '11 projects, watch the video.

How To: Turn a Ctrl + Shift + Enter formula into an Enter array formula 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 and Mr. Excel, the 52nd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the INDEX function to turn a Ctrl + Shift + Enter array formula into just an Enter array formula. Avoid Ctrl + Shift + Enter by using the INDEX function and a blank as the row argument.

How To: Calculate how much you'll need for retirement 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, part of his "Excel Finance Class" series of free video lessons, you'll learn how to use the PV and PMT functions together to decide how much you need at retirement and how much you should deposit each month during your working years.

How To: Use Camera Raw in Photoshop

In this video, we learn how to use Camera Raw in Photoshop. This is a great program to use with your SLR digital camera that will make your photos come through more clear than ever before. After you have downloaded this application, you will load your photos to it and open up your desired on to edit. On the right hand side you will see a toolbar allowing you to edit and change different effects on the photo. Move the bars from left to right to edit how the photo looks to your liking. On the t...

How To: Prepare a wall for drilling

In this video we learn how to prepare a wall for drilling. First, check for pipes and cables in the wall using a digital detector. After this, it's a good idea to tape some masking tape with an envelope on the wall to catch and dust and debris that falls off while you are drilling. When you're finished drilling the hole, remove the envelope from the section you are on and continue on to the next part of the wall. It's just that easy to drill a hole in the wall once you know you won't be hitti...

How To: Calculate hours worked in a shift with a lunchbreak 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 727th installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the hours worked in a night or day shift with a break for lunch given time number inputs using the MOD function.

How To: Calculate weekly gross pay from time values 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 722nd installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate gross pay for the week from time values using the SUMPRODUCT function. Also see what to do if you get a #VALUE! error from blanks in cell using the IF function and an array logical test.

How To: Avoid double-counting duplicates within a list 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 726th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SIGN, COUNTIF and SUMPRODUCT functions to count 1 for each item in a first list that's also contained in a second list.

How To: Compare a list of numbers where one group is entered as text in 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 719th installment in their series of digital spreadsheet magic tricks, you'll learn how to compare two list of numbers and see what happens when one list is numbers is aligned right and the other list is numbers as text.

How To: Rotate and crop a digital photo in Adobe Photoshop CS5

Need some help figuring out how to rotate and crop images 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: Create a data validation drop-down list from a table with duplicates 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 608th installment in their series of digital spreadsheet magic tricks, you'll learn how to to create an expanding data validation drop-down list from table with duplicates using a number of different tricks.

How To: Use a macro to arrange a data set in a column 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 644th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a recorded macro that uses formulas to rearrange a proper data set to one listed in a column.

How To: Create a widescreen letterbox effect in Sony Vegas Pro

In this tutorial, you'll see how to create a widescreen letterbox effect, removing and company logos or TV icons which appear at the bottom of the screen. This technique also comes in handy to remove any unwanted element or to zoom in on a particular object. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. F...

How To: Adjust the pitch of a human voice in Sony Vegas

Whether you want to drop the pitch of your voice and sound older or increase it to sound like a chipmunk, with Sony Vegas, pitch-shifting vocals is an easy thing to do. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.

How To: Use the TV simulation effect in Sony Vegas Pro

Want to make a video clip appear as though it's being displayed by an old CRT television set? With Sony Vegas Movie Studio or Sony Vegas Pro, it's an easy thing to do. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.

How To: Render Sony Vegas clips in 1080p HD for use on YouTube

Want to export a movie from Sony Vegas Pro to YouTube while preserving its quality? This clip will teach you what you'll need to know. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detailed, step-by-step instructions, take a look.

How To: Apply simple camera-ready makeup

Every time an actor or actress goes in for an audition for a film role, no matter if it's an indie film, school film or Hollywood blockbuster, most auditions use digital video cameras to record them for future reference. You want to make sure your makeup is just perfect for the camera. Not too much and not too little. The point is just to accentuate the face. Watch this two-parter to learn how to apply suitable make-up for these auditions.

How To: Create a color splash effect in Sony Vegas Pro 9

This is a quick tutorial on how to create kind of a cool looking color splash on your videos using Sony Vegas Pro 9. Choose a certain color to stand out in the video all while the rest of the video is in black and white. Whether you're completely new to Sony's popular nonlinear editor (NLE) or are a seasoned digital video professional simply looking to pick up a few new tips and tricks, you're sure to be well served by this free video software tutorial. For more information, including detaile...

How To: Use polygon modeling in 3D Studio MAX

Almost every 3D image depicted on a digital screen is made from thousands of tiny polygons. Modeling with them is the most fundamental part of 3D modeling. This video will introduce you to the basics of 3D polygon modeling, helping you to create a 3D shape that is smooth and cool-looking, if not terribly similar to any real-world object.

How To: Model an axe using 3D Studio Max

3D modeling is one of the most challenging and lucrative things that can be done on a computer. If you can do it well, someone will most likely pay you good money to do so. This video will help you start by teaching you how to model using 3D Studio Max, using an axe as an example. Over three videos, this creator will give you step-by-step instructions and help you create your very own digital axe. Model on!

How To: Create wind using Blender 3D modeling software

The wind is one of the most dynamic of all natural forces, and rendering it properly in a digital environment is important and challenging. This video will show you how to create and animate wind in the 3D graphics suite Blender by showing you how to make a flag, then make it wave realistically. Unless you want to make a replica of the flag planted on the moon, you're going to need some wind in your 3D flag model, and this video will show you how to make it so.

How To: Create a talking smiley face animation in Motion 4

Have Motion 4, a little bit of spare time and a sense of humor? This clip demonstrates how to generate a simple talking animated smiley face. Whether you're new to the Apple's popular motion graphics editor/compositing application or are a seasoned digital video professional simply wishing to get better acquainted with Motion 4, you're sure to find value in this tutorial. For more information, and to get started creating a talking smiley of your very own, take a look.

How To: Find APR, EAR & amortization for payday loans 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 623rd installment in their series of digital spreadsheet magic tricks, you'll learn how to see the pain that pay day loans inflict on people using Excel. Learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate), an Amortization Table and the EAR for a loan that takes a fee out up front. Learn ...

How To: Rip music from MySpace through Audacity without a mic

Want to download a song from MySpace or YouTube? With Audacity, it's an easy process. And this clip will show you precisely what to do. Whether you're new to computer recording, new to the Audacity DAW (digital audio workstation) or just looking to pick up a few new tricks, you're sure to benefit from this video software tutorial. For more information, including detailed, step-by-step instructions, watch this free video Audacity lesson.

How To: Make a voice sound deeper or higher in Audacity

Want to sound a little bit older? As if you've just inhaled helium? With Audacity, it's easy to manipulate or even entirely disguise a human voice. And this clip will show you just how it's done. Whether you're new to computer recording, new to the Audacity DAW (digital audio workstation) or just looking to pick up a few new tricks, you're sure to benefit from this video software tutorial. For more information, including detailed, step-by-step instructions, watch this free video Audacity lesson.

How To: Convert an mp3 file to wav format with Audacity

Want to convert an MP3 to a WAV? With Audacity, it's easy! And this clip will show you just how it's done. Whether you're new to computer recording, new to the Audacity DAW (digital audio workstation) or just looking to pick up a few new tricks, you're sure to benefit from this video software tutorial. For more information, including detailed, step-by-step instructions, watch this free video Audacity lesson.

How To: Sound older by changing your voice's pitch in Audacity

Wish there were a way to change the pitch of your voice to sound a little bit older than you actually are? With Audacity, there is. See how it's done with this clip. Whether you're new to computer recording, new to the Audacity DAW (digital audio workstation) or just looking to pick up a few new tricks, you're sure to benefit from this video software tutorial. For more information, including detailed, step-by-step instructions, watch this free video Audacity lesson.

How To: Tell whether your iPod Video is 5G or 5.5G

If you have a moderately old iPod and wish to perform some digital manipulation on it, you'll want to know exactly what version of the device it is. This video demonstrates a trick for determining simply and quickly whether an iPod video is the 5G or 5.5G version of the unit. All you have to do is open the music folder and see if there is a search tool or not! Who knew it was so easy?

How To: Add title clips from the Library feature in Camtasia 7

Camtasia 7 has a new feature, and it's called the Library. The Library section in Camtasia contains audio files, and effects like digital radius, fiber waves, rounded angles, silver streaks, sound effects, and a thing called target blue. You can use some of those visual effects to create title clips for your screencasts. The effects make the video look like Flash, even though it's obviously not. See how to add a Flash title clip from the library folder.

How To: Load music onto a Nintendo DSi

One of the Nintendo DSi's advantages over the standard DS is that it has an SD slot, allowing you to put all sorts of files on it, including music. Unfortunately, it doesn't play MP3 files. This video will demonstrate how to transfer the music files from your computer to you DSi by converting them to the appropriate format and thus putting them on an SD card, turning your DSi into a a combination digital music player / portable game console. Now if you want, you can download music to your dsi...

How To: Create mood with the Gaussian blur tool in Photoshop

Learn how to use the Gaussian blur tool to add mood to your digital photos while maintaining sharpness and detail. Meet the Adobe Photoshop pen tool! 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, which presents a complete overview of how to use the Gaussian blur filter when touching up a photo. For more information, and to get started using the Gaussian blur tool yourse...