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 238th installment in their series of digital spreadsheet magic tricks, you'll learn how to round times to 5 minutes intervals using the CEILING and MROUND 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 233rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create an efficient checkbook balance formula and see when to use the ROUND function on a sales invoice.
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 229th installment in their series of digital spreadsheet magic tricks, you'll learn how to dump data from a pivot table by macro in Microsoft Excel.
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 225th installment in their series of digital spreadsheet magic tricks, you'll learn how to do a two-variable lookup when there are duplicates using the INDEX, IF, ROW and MAX 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 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.
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.
Yuri Elkaim, author of "Eating for Energy", explains how to begin a raw food diet. First, understand what you want. If you want to lose weight, be healthy or have more energy, the raw food diet will be great for you. If you take a simple approach to incorporating more fresh foods into your diet, it will be easier to manage and more sustainable. Keep it simple and fresh. Don't focus on recipes that require complicated preparation. To transition from a cooked food diet, just add in one more fru...
Suffer from an upset stomach more often than not? Put down that donut. Tweak a few unhealthy habits, and you can beat those chronic stomach problems before they flare up.
Chef Keith Floyd is in Northumberland to learn how to cook a traditional pheasant honey and cream dish. Contains images of food preparation that some viewers may find disturbing. Great recipe idea from BBC cookery show 'Floyd on Britain & Ireland'.
Learn how to properly dices and mince food. If done right, dicing an onion ensures even cooking and makes your dish look professional. If you've never attended cooking school, chances are that you've never learned this easy method. It only takes two simple cuts. To dice and mince food, you'll need a sharp knife and your food of choice.
Outdoor Bum teaches you how to package your favorite Chinese or Indian food for dinner at the hut.
Learn how to turn rough agate into a beautiful drop shape cabochon by hand from a qualified lapidary at Holts, London. A cabochon is a gemstone which has been shaped and polished as opposed to facetted. The resulting form is usually a convex top with a flat bottom. Use this technique of forming softer stones into smooth oval shapes for fine jewelry.
Making your own baby food is easier than it sounds—and it’ll save you money, too. You will need fresh fruits and vegetables, lean beef, lamb, poultry, or pork, a vegetable brush, a vegetable peeler or paring knife, a chef's knife, a cutting board and a food mill, processor or a blender. Watch this video tutorial and learn how to make baby food.
Check out this Korean language tutorial video that shows you how to pronounce street food vocabulary in Korean. Street food in Korea is one of the staples of Korean cuisine. It is loved by Koreans, and non-Koreans world-wide! Have you ever tried tteokbokki? mandu twigim? Gimbap? If you haven't, watch this instructional language video and learn some Korean street food vocabulary!
Check out this home repair tutorial video that demonstrates how to change the filters, prefilters and the happy filter on a Dyson DC01 vacuum cleaner. Follow the step by step instructions in this domestic appliance repair video to properly troubleshoot the Dyson vacuum's filters. Please note that all work should be performed by a qualified person. Make sure to take the necessary precautions to ensure a safe repair of your Dyson vacuum cleaner's filters.
Check out this home repair tutorial video that demonstrates how to change a Dyson DC01 vacuum cleaner hose. Follow the step by step instructions in this domestic appliance repair video to properly troubleshoot the Dyson vacuum's lack of suction. Please note that all work should be performed by a qualified person. Make sure to take the necessary precautions to ensure a safe removal of your Dyson vacuum cleaner hose.
Check out this home repair tutorial video that demonstrates how to fit and replace a Hotpoint, Belling, Cannon, Creda, Homark, Indesit, & Jackson fan oven element. Follow the step by step instructions in this domestic appliance repair video to remove your fan oven element. Please note that all work should be performed by a qualified engineer. Make sure to take the necessary precautions to ensure a safe removal of the fan oven element.
Check out this home repair tutorial video that demonstrates how to fit and replace your fan oven element in a Neff & Bosch appliance. Follow the step by step instructions in this domestic appliance repair video to remove the fan oven element. Please note that all work should be performed by a qualified person. Make sure to take the necessary precautions to ensure a safe removal of the fan oven element.
Check out this home repair tutorial video that demonstrates how to fit and replace your grill oven element in a Bosch and Neff. Follow the step by step instructions in this domestic appliance repair video to remove your oven grill element. Please note that all work should be performed by a qualified person. Make sure to take the necessary precautions to ensure a safe removal of the Bosch oven grill element.
Check out this home repair tutorial video that demonstrates how to fit and replace your grill oven element in a Bosch and Neff. Follow the step by step instructions in this domestic appliance repair video to remove your oven grill element. Please note that all work should be performed by a qualified person. Make sure to take the necessary precautions to ensure a safe removal of the oven grill element.
Check out this home repair tutorial video that demonstrates how to replace your Creda carbon brushes in your washing machine's motor. Follow the step by step instructions in this domestic appliance repair video to remove your washing machine's Creda carbon motor brush. Please note that all work should be performed by a qualified engineer. Make sure to take the necessary precautions to ensure a safe removal of the carbon motor brush in your washing machine.
Check out this home repair tutorial video that demonstrates how to replace your fan oven element and your fan motor. Follow the step by step instructions in this domestic appliance repair video to remove your cooker's parts. Please note that all work should be performed by a qualified person. Make sure to take the necessary precautions to ensure a safe removal of your fan oven element and fan motor.
If you're trying to get pregnant there are foods you should avoid. Certain foods can decrease your chances of conceiving. Watch this how to video to learn more about what foods to avoid when you are trying to get pregnant.
Garnishes may sometimes feel as something that we thinks is too difficult to do. Don't fear in this how to video Chef Paul talks about food presentation and how to garnish your dishes. Watch and learn how to make a great tasting dish stand out even more with fresh food and herbs.
This short three-part video tutorial series shows how to store food in buckets for long term storage. From peak oil to survival and basic disaster preparation, this is the way to do it. Watch these survival training videos and learn how to store up and save a food reserve for an emergency or disaster situation.
Vacuum seal your food without a vacuum machine. Use a microwave and a ziplock bag to make leftover food last longer. Watch this how to video to learn how simple it is to vacuum seal food.
This martial arts video demonstrates basic karate techniques for kids and beginners. No one should attempt to try these techniques without being trained and supervised by a qualified karate instructor.
This video shows how to use a PASG, a.k.a military anti-shock trousers. This should only be done by qualified personnel.