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.
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.
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.
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.
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...
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...
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 729th installment in their series of digital spreadsheet magic tricks, you'll learn how to lookup an item when multiple lookup items are in a single cell with the LOOKUP and SEARCH 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 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.
Shooting home video is fun, and is a great way to get started on the path to a film career. But one thing that can kill your video is poor lighting. Not everyone is rich enough to a professional light kit, so what do you do to compensate? In this video you will get some great low budget, and even some free, tips on how to create proper lighting both in-doors and outdoors and tips on what to avoid in your scenes.
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.
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.
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 718th installment in their series of digital spreadsheet magic tricks, you'll learn how to find the Absolute Value Max of a set of integers (positive, zero and negative) using the MAX and ABS 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 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.
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.
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 713th installment in their series of digital spreadsheet magic tricks, you'll learn how to count the max number of items in succession in a column of data using the FREQUENCY, IF, MAX and ROW 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 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.
It doesn't matter how great a photographer if you don't have the right tools. Even Annie Liebvitz would get only average shots with a lower grade digital camera because it's very limited in terms of settings that you can control.
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.
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...
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.
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.
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.
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.
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...
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.
In this video, I match move a 3D virtual object on top of a movie which is set as the background image. This tutorial will show you how to integrate your CG objects into a real-world video. Whether you're new to the Blender Foundation's popular 3D modeling program or a seasoned graphic artist just interested in better acquainting yourself with the application, you're sure to be well served by this free video tutorial. For more information, including detailed instructions, take a look!
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!
Creating a realistic human face in any artistic medium is the greatest of all art's challenges. This video will teach you how to make a model of a face using the popular 3D Studio Max 6 3D modeling software. The video's five parts cover all phases of the process, and should have you well on you way to mastering the hardest part of digital art in no time.
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.
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.
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 ...
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.
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.
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.
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.
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?
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.
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...
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...
In the digital age, old fashioned film processing and developing may seem outmoded and obsolete. However, for professional and aspiring professional photographer who want o make classic-looking prints, this is far from the case. This three-part video describes how to do tray processing yourself for large-format sheets. It breaks down the equipment you will need, the advantages and disadvantages, and of course how to go about processing you own film sheets. The dark room is back!
