Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 92nd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how the AVERAGE function sees zeroes and uses them in calculating an average but does not see blanks.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 77th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to do a complicated payroll formula when tax data must be retrieved from multiple tables. See how to use the INDEX, INDIRECT AND MATCH functions in one big formula to retrieve tax data from multiple tables on multiple sheets. Learn to love digital spreadshe...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 70th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to clean up a bad data set with the TRIM function before building a pivot table (PivotTable) to calculate an average. 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 46th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the DOLLAR, VLOOKUP, INDEX and MATCH functions and a previous bracket commission formula trick to calculate total commissions when you have variable commissions paid out. Learn to love digital spreadsheets more perfectly with the tricks outlined in t...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 69th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use Excel's Auto Fill tool.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 44th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use 4 different tricks to convert a text formula or function to a number. Also see how to convert text to numbers. 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 40th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the filter and advanced filter tools to extract the top 5 values from a list. 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 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.
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 ...
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.
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 ...
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.
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.
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!
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.
Here's how to find and use Free Public Domain Movies and old TV commercials in your work. Also in this episode, a few inexpensive utilities that will convert video formats so they are ready for editing in your editing program of choice.
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!
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.
Start with the free Google Docs, which you can get with any Gmail account. Then get one of the free web form templates (this video uses the Contact Us form as an example) and then edit and embed it on your own website.
Are you tired of using other people's services to create Favicon icons for yourself or your clients? This tutorial shows you how to use a nifty (and free) little program called png2ico to do it yourself! Download the software here.
Simulate the look of snapshots in your After Effects video footage with Spy Photo, a free set of presets that dynamically automate and generate the effect. This 17-minute tutorial from Aharon Rabinowitz of All Bets Are Off demonstrates the features of this cool new addition, which includes camera sound effects and viewfinder overlays.
Tired of paying absurd prices for silly ringtones? The solution is simple - just stop paying for them. In this video, you'll learn how to create your own free ringtones from any song in your iTunes music library with GarageBand.
Scratching your head trying to figure out where all of your hard disk space went? Quite a lot of it might be tied up storying temporary files that you don't really need. In this home-computing how-to, the Tekzilla team will teach you how to delete those temp files and free up HD space.
