New to 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 Excel tutorial from ExcelIsFun, the 273rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract the top (i.e., max high) 5 values and their associated names from a column allowing for duplicates. This is accomplished with recourse to Excel's TRANSPOSE, COUNTIF, MAX, INDIRECT, IF, COLUMNS, INDEX, SMALL and ROW functions.
New to 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 Excel tutorial from ExcelIsFun, the 236th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a database for keeping carpentry measurements as well as how to use a COUNTIF function formula for calculating how many lumber pieces you'll need to cut for your home improvement project.
New to 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 Excel tutorial from ExcelIsFun, the 270th installment in their series of digital spreadsheet magic tricks, you'll learn how to
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 100th installment in their series of digital spreadsheet magic tricks, you'll learn how to replace a long IF formula with a simple MIN/MAX formula (or an even simpler MEDIAN function). See 3 amazing examples. When you have a hurdle such a Commission Hurdle or a Payroll Taxable Earning Hurdle, and you are using an IF function fo...
New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 518th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, SMALL, IF, COLUMN, COLUMNS, COUNTIF and MIN functions to extract and display vendor names when multiple vendors are ties for a low bid.
In this video tutorial, viewers learn how to take pictures with an iPod Touch. iPod Touch is a portable media player, personal digital assistant, and Wi-Fi mobile platform. The iPod Touch does not have a built-in camera, but it is able to take screenshots. Begin by going to any option or application that you want to take a screen shot of. Then hold power and home button at the same time until you see a white flash. The picture is located in the Saves Photos folder in the Photos application. T...
This video by Architectus777 teaches us how to ink comic book pages. Inking is simply another term for outlining or black lining. This first step is to find an image in black in white. Following this, you may edit the image to be as light or dark as you wish. Afterwards, the shading is left up to your discretion. Moving on, Architectus777 shows other methods of inking, including using various other programs outside of Adobe Photoshop. We are then actually shown the inking process, in which Ar...
Recuva is a freeware data recovery program. Recuva recovers files deleted from your Windows computer, Recycle Bin, digital camera card, or MP3 player. Begin by downloading and installing Recuva. Open up the program and select the type of file you wish to recover. Input the information that is asked and start the scan. It will the provide a list of the files. Simply select the file and click Recover. This video will benefit those viewers who lost or deleted old files and wish to recover them u...
This video describes how to increase battery life on most of the LG phones", for that first we have to enter into the service by typing the numbers "##77647269700" and then clicking the call button. Now it will ask for 6 digit "service code" to enter into the service. Just type "000000" as a code and it will enter into the "services" Menu and from the menu click on the "Network Select" and from that choose "Mode Preference", by default "Digital Only Hybrid" mode will be in selected. Now to sa...
In this video, viewers learn how to add realistic camera movement to a still image using Adobe After Effects CS4. Adobe After Effects is a digital motion graphics and compositing software. This tutorial will go over how to add realistic camera movement to a still image or photo and make it seem that it is an actually video. This tutorial will also teach viewers about motion tracking and basic chroma keying. This video will benefit viewers who enjoy producing videos and creating special effects.
In this video tutorial, viewers will learn how to create the visual effect of being hit by a car, using Adobe After Effects. Adobe After Effects is a digital motion graphics and compositing software. This is not recommended for beginners. This video will show viewers how to make the effect of getting hit by a car and adding realistic camera movement to it to make it believable and convincing. This video will benefit those viewers who enjoy movie making and producing visual special effects.
Create your own animation in Flash with this easy to follow, step by step guide to make a vine grow right before your eyes. He shows you first a simple, less complicated way of doing a basic animation. While it may not look as nice as the later demo, it gives you a good starting point to master the controls that he demonstrates. He then goes on to show a more complicated and magnificent way of making this effect, and in no time flat you'll be creating your own digital plants on your computer....
This video by WirelessZone gives an overview and shows the first steps of setting up a recently unboxed Motorola Barrage. The demonstrator runs through the basic display settings, sound setting, the ring tones (almost all the default ones) and many more. The display settings include the wallpaper, display back light, keypad back light, feeling, icons, clock formats etc. The sound settings include the digital dial readout which reads out the number that was keyed in without looking at the phone.
WirelessZone shows you how to use the Droid multimedia station. The dock station comes with the cord and the plug. When you load your phone into the dock it goes into multimedia mode. On the multimedia home screen you have the time, the date, the temp, and the ability to play music, pictures, and a night light. When in the multimedia lock the phone operates like a desk clock. If you go to your pictures, you can cycle through them as you could with a digital picture frame. You also have an ala...
This clip was filmed as part of a One to One training day with Mike Browne. Focus the camera on a bunch of window panes. There is a row of window panes which cuts across the bottom left hand side corner. There's actually nothing right or wrong with it, only thing that matters is whether or not it works for you. Mike Browne believes that because it is strong and dominant you should crop the image so that it will no longer be visible. You can always remove that in a computer later, thanks to di...
One thing you need to know in particular about Sony Vegas is rendering. If you don't know how to render, you're not going to make a good film or video. So watch this and see how to render video in Sony Vegas.
Digital Painting and Drawing: Learn to draw woman face profile or side view, a knight in armor, facial figure, head and figure slightly step by step with costume step by step. This drawing, painting using Photoshop video tutorial shows you from basic rough sketching to finish drawing quick concept for comics cartoon illustration, manga, anime. The video demonstrates how to quickly create an efficient concept design from concept idea into visual. Video tutorial. Cartoon, illustration, comics, ...
There aren't a lot of Boris Red tutorials out there, so make sure you watch this one on motion tracking. Learn four-corner pin tracking in Boris Red, which is a great compositing and effects program (plug-in) for Sony Vegas. See how to create a fisheye look in Sony Vegas Pro 9. Motion tracking is ability to realistically incorporate an object into a video, matching the movement of the shot.
Creating a curved video look, also known as the fisheye look, is one of the easiest camera tricks possible, and can also be done with your editing software. It's commonly used in skateboarding videos, but be done for any low budget indie film. See how to create a fisheye look in Sony Vegas Pro 9.
If you own Sony Vegas, a good editing technique to learn is tracking motion. Track motion is the ability to rotate, scale, and skew an object in 3D perspective. This is great for making intros, titles, animated pictures in your homemade videos and much, much more. See how to track motion in Sony Vegas Pro 9. These are the basics.
Have Sony Vegas, but don't know all that it can do, like masking? Well, this video tutorial about masking in Vegas Pro 9 will get you started in movie visual effects. As in the video, you can give an illusion that there is a real tank in your backyard with masking. See how to use the mask tool in Sony Vegas Pro 9.
Have you ever wanted to make your own personal coloring book? With the Epson Artisan all-in-one printer, a project like this is a snap. Make some coloring books based on your digital pictures. Have your kids color in their memories of the last trip to Disneyland, or the silly photo of themselves goofing off in the bathtub. These personalized coloring books make great gifts for everyone!
Picture this: the infrared sensor on your TV is not working and you are blaming it on your remote control batteries. Well, to make sure exactly what is going on, try testing TV remote to be sure. To the naked eye, you might not be able to see the infrared light, so you could think it's dead, but try filming with your camera phone or digital camera, which could pick up the IR signal.
After Effects is one of the best digital motion graphics software programs out there. Learn it. Now.
After Effects is one of the best digital motion graphics software programs out there. Learn it. Now.
Let's face it: Most people, even our friends and family, find it pretty boring to open emails with huge photo files attached to them. They're bulky and take forever to load.
New to Ubuntu Linux? This computer operating system could be a bit tricky for beginners, but fret not, help is here. Check out this video tutorial on how to install Frozen Bubble 2 on Ubuntu Linux.
This Adobe Photoshop video tutorial teaches you how to remove or reduce shadows in Adobe Photoshop. This video is from the "Tiling Textures" course. See how to remove or reduce shadows in pictures.
This Maya 7 video tutorial teaches you how to test Photoshop-made textures in Maya 7 from Autodesk. This video is from the "Tiling Textures" course.
This Adobe Photoshop video tutorial teaches you how to create an alternate texture in Adobe Photoshop.
This Maya 7 video tutorial teaches you how to make and use UV space in Maya 7 from Autodesk. This video is from the "Maya Basics" course.
This Maya 7 video tutorial teaches you how to use light and camera choices in Maya 7 from Autodesk. This video is from the "Maya Basics" course.
This Maya 7 video tutorial teaches you how to use four lighting techniques in Maya 7 from Autodesk. This video is from the "Game Lighting and Color" course.
This Maya 7 video tutorial teaches you how to construct a metal shader in Maya 7 from Autodesk. This video is from the "Game Lighting and Color" course.
Hacking into computer systems to steal passwords could be a bit complicated for the average everyday joe, but for all of your tech illiterate folks out there, there's any easy way to get that password, and all it takes is a camera.
Whittling seems hard, but not with this video tutorial... watch to learn how to carve a teeny wooden mouse with a small knife, sander and drill.
Think about how many times a day you touch your keyboard... ready to clean it yet? Check out this Howcast video tutorial on how to clean a computer keyboard.
PCs are quickly becoming the center of our digital universe. With PDAs, cell phones, portable media players and other electronic devices; keeping your content synchronized has been a challenge. With the new feature, Windows® Sync Center in Windows Vista™, you now have a single place to keep all of your devices and information up to date. For detailed instructions on using Sync Center for your own data syncing needs, watch this how-to.
This digital drawing tutorial shows you how to color or ink a manga animation type drawing in Corel Painter. The tutorial assumes you are using a Wacom or Cintiq tablet to work. The tutorial explains the steps taken to digitally color a drawing in Corel Painter and is more about the process than the specific mouse movements.
Want to mix and scratch like a professional DJ? To be a good DJ you need to understand the concepts of mixing tracks, adding cool effects, and of course you need a good sense of rhythm to line up the beats. This how to video explains how to use the features on the set up menu of a Cortex HDC-1000 digital music controller. Improve your DJ skills by watching this tutorial so you can learn how to use the features of the Cortex HDC-1000's set up menu.
