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.
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.
Final Touch TV shows viewers how to remove scratches from the car with wet sanding. This is for fine scratches that may be on your vehicle. First, you need to use 3,000 grit sand paper with a block and scuff up the clear coat first with this. You should dip your block in some soap and water in and up and down motion. You need to make sure you do not go all the way through the paint. Most scratches are on the clear unless it appears deep. Now, take a 3 compound, spray it on and rub it in. Next...
In this video tutorial, viewers learn how to burn ISO-format disc images to a DVD from Windows. Users will need to download the program, DVD Decrypter. Download it from this link: DVD Exact Copy/] and double-click the file to install it. Users will also need a blank DVD disc. Open the program, go to ISO and select Write. Now click on the folder icon to locate your ISO file. Now click on the disc image and wait for the decryption to finish. This video will benefit those viewers who have downlo...
In this Video Games video tutorial you will learn how to repair a broken PS3. For this you got to put the PS3 into stand by mode. Press down the button located at the top end of the console for 7-10 seconds and listen for 3 beeps. It may not work the 1st time. So, do it again. Then this message is flashed on the TV screen – ‘connect the controller using a USB cable etc’. Once you connect the USB cable the trouble shooter prompt comes up displaying 6 options. If you are not using HDTV this wil...
In this Video Games video tutorial you will learn how to fix a PS3 Black Screen of Death. For this you got to put the PS3 into stand by mode. Press down the button located at the top end of the console for 7-10 seconds and listen for 3 beeps. Repeat this step again. Then this message is flashed on the TV screen – ‘connect the controller using a USB cable etc’. Once you connect the USB cable, the trouble shooter prompt comes up displaying 6 options. You can use the 6 options to troubleshoot yo...
Hairtalk TV demonstrates how to instantly get color highlights with hair extensions. Put On Pieces offers Clip In Color which is a very thin, nine inch wide, sixteen inches long weft of hair that clips into your hair to give you highlights, low lights or bright, fun colors. The weft contains three pressure sensitive clips which slide into your own hair without causing damage. Unlike permanent coloring, Clip in Color causes no damage to your hair, does not fade over time and provides the versa...
This series shows you a quick and effective core strength and stretch routine you can do in a chair anywhere, anytime, with Sadie Nardini, founder of Core Strength Vinyasa Yoga. After watching this you'll be able to stretch right from your desk at work.
This video will show you how to connect to XBox Live through a laptop or PC’s Wi-Fi. Connect your XBox Ethernet cable and the other end of the cable you connect it to the Ethernet port of your laptop. On Vista and XP, open control panel and go to Network Connections. Right click on any one of the ‘LAN or High-Speed Internet’ icons and select ‘Bridge Connections’. After a little while bridge connection will be enabled. Close the window and go to your Xbox. Ensure all connections are in place, ...
Time to start salsa dancing! In this two part video series, Clara takes you through all of the basics. From your feet all the way up to the tips of your fingers, after watching this tutorial, your whole body will be in the Latin groove.
Oftentimes during performances, the battery on the tuner will run out. Fortunately this tutorial video series shows you how to use your hear and harmonics to quickly keep your guitar in tune.
This is a great video series for all you serious knitters out there. If you've ever wanted to learn how to make a bonnet, follow the detailed instructions in these two videos and you'll be doing it yourself in no time!
This Sports video tutorial will show you how to practice away from the golf course. This video is from Golf Link. Sandy LaBauve presents this video tutorial. You can work on your grip while watching TV. Sitting on your sofa, take your golf club and keep on practicing on the correct grip. Make sure the face is square, use the visual check points, lower your hand and feel the grip. Check your posture in the mirror. Use your backyard to practice your arm swing. And finally you can work on your p...
Learn to play one of Robert Johnson's best songs, "Kindhearted Woman Blues", on the guitar. This blues guitar songs from Johnson is a great song to start learning the blues, and is structured in a typical 12-bar blues in the key of A. "Kindhearted Woman Blues" was written in the late '20's, early '30's.
Learn how to make traditional maple syrup with expert Bill Hiller. This great tutorial series shows you what to look for in the trees as well as how to process it.
This is a great series of videos showing you how to solve simple algebraic equations. The first video demonstrates solving equations using addition or subtraction, the second deals with solving equations using multiplication or division, and the third shows how to solve multistep equations.
This great video series how to do a hack for your wireless XBox 360 controller. This mod will enable you to have a rapid fire for shooter games so you don't have to continually depress the button for every shot.
This is a great video series from Yanik Chauvin demonstrating how to use Photoshop Express online for free. This great tool is a wonderful resource for those who can't afford Photoshop but still need to do basic photo editing.
This series of videos demonstrates how to do conversions of recurring decimal numbers to fractions. In a few simple steps, you'll be able to transfer these repeating numbers to simple fractions.
This is a great series of videos demonstrating how to care for Phalaenopsis orchids. You'll learn how to best plant in order to get full bloom and growth.
This great video series from the experts at RTTI shows you how to make a custom subwoofer box for your car. They do a great job of teaching you how to measure, cut, and finish so your car is bumping.
In this video from lunawebs we learn how to use an external monitor with a camcorder. The best way is to use an HDTV and use your HDMI output on the TV. The sound can also come through the monitor if you have a headphone port on the monitor. If you want to go outdoors, it will be more of a challenge. If you do not have an HDMI out on your camera, there is a component you can use. Composite AV outs are cheaper when it comes to monitors and camcorders. If you have a composite monitor, assign th...
In this video tutorial, viewers learn how to play MKV and AVI files on an Xbox 360. Before beginning, users will need a Windows 7 computer and your computer and Xbox must be sharing the same network. Begin by downloading and installing the DivX 7 Pro bundle. Users will also need to download the DivX Tech Preview. Open Windows Media Player and click on Organize. Go to Manage Library and select Videos. Add the files that contain the files. On the Xbox dashboard, go to the Windows Media Center a...
Ilysa Bierer and Kira Slye with Polymer Clay TV demonstrate how to make polymer clay business card holders. You can work cabochons into polymer clay to create business card holders. Stamp on clay and use clay with inclusions in it for a different look. First, get a plain business card case and work the clay over it. Add pigment inks, textured stamps and canes to dress up your business card holder. The clay can be baked right onto the metal and will adhere to it. Polymer clay adheres better to...
blip.tv Juarez Goncalves De Azevedo (master chef at Wildfire at Crowne Plaza Today in Gurgaon, India) shows how to prepare Brazilian-style fish stew. Ingredients: 450 g of fish, 3 tbsp of fresh lime juice, 1/2 tsp of salt, 500 ml of coconut milk, 1/2 cup olive oil, 2 large onions, halved and thinly sliced, 1 large garlic clove, crushed and minced ,15 g of cloves, 1 medium green pepper, seeded and sliced, 2 tbsp paste of raw tomato, 3 stalks of spring onions, sliced thin up to green, 1 tsp fre...
This video will show you how to calculate the total savings on a transaction where there are two percentage series discounts and two dollar discounts. This video shows frugal bargain hunters how to simplify with an Excel sheet and find the total saving percentage. It teaches functions that can be used in the Excel sheet, plus useful tweaks and formulas.
Ilysa and Kira with Polymer Clay TV demonstrate how to make an incense burner out of clay. An incense burner is a great way to use up a lot of your scrap clay. You can also use molds, embellishments and pigments to create your incense burner. You can roll up your clay in a swirl to create the incense burner or use any other desired shape. You can also do pinch pot type shapes. To make an incense burner, you'll need a ball of scrap clay, a blade, and a rod. Use the rod to flatten pieces of a c...
