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 168th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a simple dynamic database in Excel using lists in Excel 2003 and tables in 2007.
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 177th installment in their series of digital spreadsheet magic tricks, you'll learn how to format a column as text numbers to avoid data validation trouble.
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 169th installment in their series of digital spreadsheet magic tricks, you'll learn how to randomly select an employee from a list using the INDEX and RAND and INT functions (also RANDBETWEEN).
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 155th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the TRIM function to get rid of extra spaces when a VLOOKUP function should work but doesn't.
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 154th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a personal budget based on past data via the SUM function, cell references, subtraction and the VLOOKUP function.
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.5th installment in their series of digital spreadsheet magic tricks, you'll learn how to a formula that will calculate the mode 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 140th installment in their series of digital spreadsheet magic tricks, you'll learn how to save time in updating a system of data and information by using sheet cell references in formulas.
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 138th installment in their series of digital spreadsheet magic tricks, you'll learn how to name individual cells after their cell content (i.e., the name of the cell is in the cell).
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 136th installment in their series of digital spreadsheet magic tricks, you'll learn how to do two-way lookups with the VLOOKUP & MATCH 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 98th installment in their series of digital spreadsheet magic tricks, you'll learn how to use a TRUE/FALSE formula and the TODAY function to format a calendar within a two-week period.
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 91st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the FORECAST function to solve linear algebra problems.
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 Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to import data from Microsoft Access as well as how to use the VLOOKUP function to populate data into a printable form.
Have you ever wanted to give a Podcast maker a piece of your mind? Did they say something that really irked you, or how about something that really inspired you? In this video, learn how to write a review for a podcast in iTunes. Tell that person what you think!
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 294th installment in their series of digital spreadsheet magic tricks, you'll learn how to filter a pie chart.
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 371st installment in their series of digital spreadsheet magic tricks, you'll learn how to calculate the average time between customer orders by adding a new column to a data set with an IF function formula.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to work with the quadratic formula on your graphing calculator.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to rationalize a denominator.
From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to solve a complex radical equation in algebra.
Photoshop Universe presents a step-by-step tutorial on how to mask images over text. First and foremost you'll need to have a poem or some other block of text in mind to use. Once you've selected your text you'll use methods such as copying and pasting, using clipping masks, and mild typeface editing. By the end of this tutorial you will have the abilities you need in Photoshop to make your very own text based image!
A cool trick bar to do with your friends. The Delpitos 5 Toothpicks and a Star trick is a mind teaser style trick that involves creative and innovative thinking. Can you rearrange the toothpicks and achieve the goal?
Keep private info from prying eyes and earn some peace of mind when you safeguard your PC or Mac against nosy intruders. You will need several great passwords, virtual desktop software, snoopware blockers, a screen filter, a mirror, a healthy sense of paranoia, WPA encryption, and an understanding IT specialist.
Just keep in mind this is made for a compulsion trainer that was new to clicker training, so there is a lot of luring going on in this video because it might be easier to explain. Shapers you have been warned! Splash was 6 months old in the 'how to' part of this video.
Watch this video tutorial to see how to make a colorful density bottle. To do this science lab experiment, you'll need food coloring, a plastic bottle, clear baby oil and extra things to put into the bottle, like glitter or sparkles.
This web building software tutorial shows you how to use XSitePro to change an existing XSitePro website template with a new XSitePro template. Don't worry if clients, or you, change your mind about what you want your XSitePro website to look like. This tutorial will show you how easy it is to change from one template to another for an existing website in XSitePro.
Suffering from a clogged drainpipe? In this video tutorial, you'll learn how to clear a choked basin the smart way. Keep in mind, however, that this method requires that you confront the things clogging your sink. As such you should be prepared to dirty your hands and smell and see terrible things! To learn how to clear a choked basin, watch this simple plumbing how-to.
As a follow-up video to inference locking, this Google SketchUp tutorial shows how to combine a series of roof forms together using inference locking. You will also use arrays and copying to create dormers. Please keep in mind, this isn't a video on roofs, but an example of various inference locking techniques and how they work in Google SketchUp.
Meditation requires a lot of reflecting from within. Effective meditation requires proper posture and alignment. In this motivation and self help how-to video our host gives you tips and tricks for suitable posture that does not produce many aches and pains while you are trying to focus your mind.
Take a look at this instructional video and learn how to use the eraser tool in Google SketchUp. Keep in mind that the eraser tool only works for edges in SketchUp, and you won't be able to erase surfaces with the eraser tool. This tutorial covers how to erase single or multiple edges easily and how to soften or hide edges with the eraser.
You just found out you are pregnant and you are anxious to calculate your due date. Learn how to calculate your due date even before going to see your doctor by watching this maternity how-to video. Keep in mind that most pregnancies last about forty weeks.
To play music, your hands should be able to do anything your mind asks of them – and rudimental technique is one great way of making sure that can happen. In this installment from his video tutorial series dedicated to rudimental techniques, Mark Wessels will teach you how to play accented 16ths, which are great for the beginner wanting to gain consistency over the sound of the inner beats.
Take a look at this instructional video and learn how to build a custom iPod and iPhone cable that'll simultaneously charge the Apple device and give an audio line out connection. Keep in mind that this process requires some soldering and since the pins on the Apple dock connector are really tiny, this can be a very strenuous process.
You'll sell your house faster — and for more money — if you avoid these common pitfalls. You will need a thorough housecleaning, and open mind, and some home improvements. Watch this video real estate tutorial and learn how to sell your house quickly.
Do you play basketball? Take a look at this instructional video and learn how to steal the ball on the court with Kansas senior point guard Russell Robinson. To this you, first you need to apply pressure. As you do this you force your opponent to make mistakes and this will give you a window of opportunity to exploit the situation. Keep in mind that you need to maintain defensive principles.
Take a look at this instructional video and learn how to perform a tornado kick. Before learning the tornado kick, you can practice with inside crescent kicks. Remember to mind your arms, you don't want them flaying around when you're executing this kick.
Take a look at this instructional video and learn how to start your crosses(two-piece) with a starting clamp when stringing your tennis racket. Keep in mind that when you get to the other side where the knot's going to be, make sure that there's enough string sticking out to get through your tension head and then clamp it on the outside with the starting clamp.
Take a look at this instructional video and learn how to tie a bulky knot. This is a starting know and tension can be pulled directly to it. Keep in mind that this knot is not for the end of your mains and crosses.
Take a look at this instructional video and learn how to tie a double half hitch while stringing your tennis racket. Keep in mind that this knot should only used to finish off mains or crosses. Because of this, tension should not be pulled directly to it.
Leaving visible revision marks and comments in a document that you thought was "final" can be embarrassing. In this instructional video, a Microsoft employee demystifies what's going on with those tracked changes that you thought were gone from your Microsoft Office Word 2007 document. He also shows you how to banish those markings permanently in two ways and gain peace of mind.
Take a look at this instructional video and learn how to create an effects montage through Sony Vegas 6.0. Keep in mind that you can't reproduce the same effect in Sony Vegas Movie Studio or Platinum because these programs don't have the masking option.
Watch this how to video and learn how to cook up a classic Italian meat sauce. This ragu sauce recipe is very versatile and can be used as the base for many other sauces. Use this ragu sauce for cottage pie, spaghetti, or anything else you have in mind.
