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 173rd installment in their series of digital spreadsheet magic tricks, you'll learn how to show negative time with the "Use 1904 date system" as well as how to create a formula that will show the time over or under a given hurdle.
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 159th installment in their series of digital spreadsheet magic tricks, you'll learn how to solve Duplicate VLOOKUP function problems with a COUNTIF formula that creates a column of unique values for the first column in the lookup table.
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 158th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP function to retrieve data and the OFFSET function to look at just part of the desired table.
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 152nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter and a TRUE/FALSE formula in a column to extract records that contain a non-blank value in a specified field. (column).
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 145.75th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AVERAGEIF (AVERAGE IF) function to create a formula that will calculate the average when you have more than 1 criterion.
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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply custom number formatting as well as how to conditionally format dates and weekends using a TRUE FALSE formula with the AND and WEEKDAY 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 141st installment in their series of digital spreadsheet magic tricks, you'll learn how to take the number 1 (for day one of the month) and use the DATE function to convert it to a serial number formatted as a date.
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 99th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF, MAX and the MIN functions to solve a basic problem in three different ways! See how to calculate the excess amount over a hurdle with three different methods!
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 92nd installment in their series of digital spreadsheet magic tricks, you'll learn how to add data series to a chart, change the chart type for just one data series and see an excellent copy data to chart trick.
Layers are very important component of Photoshop. Without knowing how to use the layers correctly, one can not utilize the maximum what Photoshop offers to designers and digital artists. For a beginner, this video provides a good basic knowledge about Photoshop layers. Layers enable you to arrange different parts of a picture and manipulate them without effecting the content of other layers. Layers are added by using layers panel. Each layer is named accordingly. We can change the order of la...
Photoshop is an amazing piece of software that can be used for so many reasons. Whether it be recreational or for business it has many different helpful tools. This tutorial shows you how to make a cool looking 3D film strip. Enjoy!
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 182nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create formulas with workbook references. See how to make a formula that looks at a range of cells in another workbook.
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 165th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a logical formula to extract values associated with dates occurring in the next two weeks.
In this how-to video, you will learn how to hook up your TB X41 Headset to your Xbox 360. First, hook up the HDMI cable. From there, you must have a fiber optic cable and an Xbox 360 audio adapter. All you have to do is plug it in right above the HDMI connector. The black input is where the digital audio input goes. This is where you install the fiber optic cable. Run that into the transmitter. The transmitter sends the signal to your headset. By viewing this video, you will learn how to easi...
This video tutorial from toptenreviews presents how to import media from a hard drive into Corel Video Studio library.First you need to start the application.From top menu click on Capture tab. Normally you would select one of the four options to capture media: Capture video, DV quick scan, Import digital media, Import from mobile device.These options are below the library. But in this case you will need to click on the folder icon above the library.This action will bring up a dialogue box wh...
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. With this video tutorial from ExcelIsFun, the 376th installment in their series of digital spreadsheet video tutorials, you'll learn how to an array formula for a stem and leaf chart for numbers that have more than two digits. This is accomplished through use of the IF, COLUMNS, SUMPRODUCT, LEFT, RIGHT, FIXED, INDEX, SMALL 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 202nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that calculates the number of vacation days an employee gets based on hire date using the TODAY, YEAR and IF 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 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.
