Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 39th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the RIGHT, LEN, FIND & REPLACE functions in a formula to deliver a sheet tab name to a cell!
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 34th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to hide columns, select visible cells only, and then copy and paste just those visible cells (all with and without the use of formulas). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 33rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to sort by color in Excel 2007 as well as how to use the copy and paste tools to extract records. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Sony Vegas is a cool new video editing program. In this tutorial, you will learn some simple editing techniques in Sony Vegas. You will learn to detach the sound from your movie clip, as well as how to split your movie to remove any unwanted footage. You will learn how to merge both clips and use the fade in and fade out tool to create a smooth transition.
Brand new to Microsoft Office Access? This seven-minute free video lessson, which presents a general orientation to using the popular database program, will see that that you're well versed in all of the fundamentals. Learn how to create databases and forms, how to run queries and more. For the specifics, watch this free MS Access video tutorial.
Wind down with the simple yoga relaxation exercise outlined in this free video lesson. As an added bonus, unlike most yoga exercises, which require some bare minimum of athleticism, the "goddess pose" demonstrated in this tutorial is as simple as reclining. Find out how to do the goddess pose with help from a yoga instructor in this free video on yoga relaxation exercises.
Having trouble figuring out percentages? If so, you'd be well served to give this free math lesson 100% of your attention. After watching it, you'll be able to answer questions like, "What's 25% of 38?" or "What's 38% of 25?" For more information on calculating percentages with simple arithmetic, watch this free video guide.
Isn't it annoying when you sit down at a public computer and all of your favorite sites are blocked with a filter? You can use proxies to get around these blocks, but those don't always work.
In this video tutorial, viewers learn how to install the Installous application for the iPhone or iPod Touch. Users will need to have their iPod device jailbroken before installing. Begin by opening Cydia and select manage. Click sources and select edit. Add this source: Select your new source (Hackulo.us) and install AppSync for your device's firmware, Then install Installous. Return to your home screen and run your new application (Installous. Now users are able ...
You can add full iso roms on your PSP to play on the go, for free! This video will demonstrate exactly how to download and enter full free PSP games onto our handheld.
This video instructs the viewer on how to do a powerful Driven Free kick for soccer. First, you will need to come on to the ball and strike it with your in-step. Your in step is the inner part of your foot that is right next to the laces. The most important tip is that when you do strike the ball, come through the ball and not around it! Finish with a hop at the end which will create more power! You'll want to kick the ball just under the center for proper height and maximum power. Kick the b...
This video shows the viewer how to take a ‘Trivela’ free kick. This is where the player kicks the ball with the outside of their foot. This makes the ball curve towards the foot that the player kicked the ball with – a right footed shot will curve to the right and vice versus. The main point the video makes seems to be to make good contact with the ball. This is very crucial. The video also contains other tips and tricks as well as some footage of successful ‘Trivela’ free kicks taken by the ...
Tasktutorial teaches you how to create a scrolling text box using buttons and ActionScript in Flash. Create a dynamic text field and then right click and make it scrollable. Create scroll buttons using two simple rectangles. Convert those to buttons using shortcut F8. Click the button and go to Window - ActionScript. Copy the text from the video to make the buttons scroll the text. You can test the movie by going to Control and then Test Movie. This will bring up a new window and you can see ...
In this how-to, viewers will learn how to create a presentation which fades in and out among still photographs using Flash animation. First, each image is given its own layer in Flash. Then the images are converted into movie clips. A motion tween is created among each image and a few blank frames, to create the affect of a slow fade in and out. Then the layers are distributed sequentially on the Flash timeline so that as each layer fades out, the next fades in. The finished movie is tested, ...
This how-to video is about how to enable the commenting tools in the free Adobe Reader using Acrobat 9 Pro and Acrobat 9 Pro Extended.
This video shows step by step instructions on how to make a movie poster on Photoshop. The author merges two pictures together beautifully of a newly wedded couple on the beach. It goes very into debt and is easy to follow, even for beginners. This Photoshop tutorial is mostly for Mac users. The language is very simple and not very complicated. The video is not that long, around seven minutes. At the end he even puts in his own finishing touches of color that makes the poster come alive.
You can make a rollover button in Flash by following the instructions shown. You start by opening up Flash to work on your project. You then follow along and draw a shape for the actual button. Then follow the steps given to turn your shape into a button that is click-able and links to your movie clip. This is great for placing on a website instead of placing a bulky video clip on the site. If you complete the directions correctly you will have a fully working click-able button that will link...
Use these steps and you will be able to open up a pomegranate, mess-free! *Select pomegranates by weight not color!* Remember the heavier they are the more juice they contain! Here is how to open a pomegranate: mess free! Cut the crown of the pomegranate off - (the top of it). Take your knife and cut through the membrane of the pomegranate (the middle). Get a bowl of water and separate the seeds from the membrane inside the bowl. The seeds will sink to the bottom, and scoop out the membrane w...
In this video the author explains the various concepts like speed, velocity, free fall speed etc., Speed tells you how fast you are going, i.e. it is distance divided by time taken to travel it. Velocity is nothing but speed along with direction. Now she tells that acceleration is used to measure the rate of change in velocity. So she says that acceleration is difference in velocity divided by the time. She also explains that there can be acceleration with out change is speed as there can be ...
Tasktutorial.com shows us how to create drag and drop functionality into a flash program. Start off by making a few shapes in flash and then add color to each of them, a different one for each shape in order to differentiate between them. After doing this select all the shapes by dragging the cursor over them, once done distribute the shapes into layers by going into the 'modify' drop-down button at the top, then timeline and there will be the option to distribute. Now we have to turn the sha...
Put PS1 games or PSX games on your PSP for free with help from this video tutorial. You must make sure you have custom firware on your PSP in order to complete this.
A great special effect for any film or movie is the space warp effect, like this bleach bypass effect. It's a little tricky to make, but once you know, fairly simple. Learn how to create a bleach bypass effect in Sony Vegas.
Need internet but don't want to pay? Well, try lusting of those around you by picking up their Wi-Fi signal. Live out in the boondocks? No problem… if you have an old satellite dish laying around.
It's medieval mayhem and you need a sword prop. Maybe you're larping, or maybe you just need a fake, dull movie prop blade for your action epic. Either way, this is a great weapons build project for a cool replica wooden sword. Watch this video tutorial to learn how to build a fake sword prop.
Forgot to take a few production stills on set? No problem, work with what you have... the actual video footage. See how to get photos from video with iMovie or Final Cut Pro 6.
Check out Systm's calibration lesson to make your HDTV a great as it was intended. PCMag's HDTV expert, Robert Heron, teaches us top notch HDTV calibration tricks using tools anybody can afford!
Synchronize and backup your Microsoft Office Documents using Google Docs and Docsyncer. This is a great tutorial from Tinkernut on how to backup your files and Word docs using the free Google software.
This is a great tutorial on cracking the iphone to record more than 30 seconds on the iPhone 3G's video camera. This is a hack of the previously still camera that comes stock with all of Apple's phones. Enable your iPhone to shoot video instantly and free!
Are you going INSANE cause you don't have a costume yet for Halloween? Worry no more, because this video tutorial from Thread Banger, Rob shows us a crazy tutorial on how to make your very own straitjacket.
This simple software tutorial shows you how to create characters by drawing them in MS Paint and then pulling them into Windows Movie Maker to animate them. Create your own cartoons with two Microsoft softwares: Paint and Movie Maker.
Say you're interested in using Photoshop for your photography, but you don't want to spend the money on Photoshop Elements or CS3. What to do? Well, Adobe has a solution for you! It's called Photoshop Express, and it's free. Check out our interview with Tom Hogarty of Adobe, as well as a preview of what you can do today with Photoshop Express.
Today's word is "pause". This is both a noun and a verb. As a verb, it means to stop an action temporarily.
Handy tip, to release your car from slipping sand. Release tire pressure 40-50% to free car.
This is a quick Q&A between Reggie Bush, an American footballer and David Beckham, soccer or European footballer now of LA Galaxy. Beckham shows Bush how to kick a free kick. Bend it like Beckham!
Last weekend, some unlucky Gmail users inadvertently had their email accounts wiped out. Actually, it was 0.02 percent of all Gmail users—or roughly 40,000 of the 200 million who use the email service, due to an "unexpected bug" which affected copies of the data. Gmail does make backup files of everything, so eventually everyone will reclaim their email history. In fact, as of yesterday, Google has successfully restored all information from their backup tapes and has started returning everyon...
If you've got a free version of Fallout: New Vegas and you are looking to update, you've come to the right place. Watch this video and learn how to download and install the Fallout: New Vegas update for Windows.
Have you heard? Probably not, if you don't have Skype, the free global calling service that enables video chat over wireless. Download Skype and follow the instructions of this helpful video to learn how to install it, so you can start making calls.
Drafting your own patterns isn't difficult - and it's a great way to get not only a free pattern, but to make sure that your pattern is custom fit to your own measurements. This video shows you how to draft a basic shirt pattern from scratch.
Mmm, free beer. Win some with this coin stack trick! Can you move the coins so that the silver coin ends up second from the top? Yes you can if you watch this video and see how it's done. Cool!
Beat level 2-2 of the iOS version of Angry Birds Free with three stars! On January 5th, 2011, Rovio released a free version of Angry Birds for iPhone, iPod Touch and iPad users. Stuck? No problem: YouTube's FujiToast has pledged to post a three-star walkthrough for each of the game's levels. In this installment, we learn how to beat level 2 of theme 2.
