Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how (and when) to record absolute and relative macros in MS Excel 2007.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 54th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to find, download and use VBA code in your MS Excel projects.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 39th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how if an array or range is put into a function argument that is expecting a single value, the function becomes an array and delivers an array of values instead o...
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 24th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn see exactly how Excel calculates/evaluates formulas including things like intersections, unions, negation, text operators and comparative operators. Knowing the o...
In this tutorial brought to you by the guys at Achievement Hunter, you'll be finding out a secret in the Skate 3 demo. This video shows you how to get out of the map, or in this case demo barrier, into another skating area. This is the main place where you can find the infamous shark that is so difficult to jump. Enjoy!
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 50th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to value an asset as well as perform discounted cash flow analysis with the Excel functions PV, NPV & XNPV.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 40th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to perform eleven VLOOKUP tricks including how to use VLOOKUP with the TRIM function to remove spaces from first column of lookup value.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 14th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to set up data in Excel so sorting, filtering, subtotals and PivotTables (Pivot Tables) can be done easily.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 25th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to interpret and resolve the nine most common Excel formula errors — namely, ####, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Reference, and #NULL!.
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 23rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to import data into Excel from text files, web sites, Excel files and Microsoft Office Access files. Also see how to import currency rates and major indicies from ...
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 13th installment in his series of Excel array formula series, you'll learn how to set up, solve and write conclusions for math word problems in Excel.
Looking for a primer on how to create and work with arrays in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 2nd installment in his series of Excel array formula series, you'll learn how to use the array TRANSPOSE function to transpose a table, switching rows and columns to columns and rows.
Looking for a primer on how to create and work with arrays in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 3rd installment in his series of Excel array formula series, you'll learn how to create an array formula that will calculate the expected return for a given stock.
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 8th installment in his series of Excel array formula series, you'll learn how to create an array formula for Bayes' Theorem.
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 8th installment in his series of Excel array formula series, you'll learn how to use the array FREQUNCY function correctly.
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel array formula series, you'll learn how to create array formulas with the ROW & COLUMN functions that will in turn permit you to create a set of permanently consecutive integers.
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12.66th installment in his series of Excel name tricks, you'll learn how to paste a list of all names in the workbook, both the name and the formula that defines the name.
Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 5th installment in his series of Excel name tricks, you'll learn to use names with pivot tables, data validation & the VLOOKUP & COUNTIF functions and formulas.
This video shows us how to use a cuttlebug and make a congratulations card. Here are the following steps:
This is a tutorial on how to replace the screen on your ipod touch. This video is specific to the third generation ipod touch. You can tell if your ipod is a third generation because it only has two lines of writing on the back bottom. To begin use a safe open pry tool to open the ipod touch. Run the tool between the metal chrome frame and the glass digitizer. There are many clips on all sides and they all need to be released. Begin prying at the bottom and then work your way to the sides. Wh...
Many people ruin a good cigar by a badly placed cut. YouTube user Cigaraficionadovideo is here to help. First in order to understand the cutting mistakes you must first know how a cigar is put together. A hand made cigar is held together a the tip by, what is called, a cap. When cutting this cap you want to do it above the shoulder. Be carful here because a bad cut a little lower could result in the wrapper falling it apart can lead to a mouth full of tobacco which will pretty much ruin your ...
Julie Goodnight guides you through how to safely mount and dismount a horse. First make sure you put the reigns up over the horses head. Keep the reigns in your hands so you always have control of your horse. Check the cinch on the saddle before putting your foot in the stirrup. Make sure the horses feet are square so it can properly brace when you go to mount. Stand to the front of the horse, facing the rear, so you can see the legs at all times. This will also discourage your horse from ste...
Chef John from Food Wishes demonstrates how to make no knead pumpkin bread for the holidays. First, add a half a cup of plain pumpkin puree, a cup of warm water, 1/4 of a teaspoon of yeast, 1 1/4 teaspoons of salt and a dash of pumpkin spice to a mixing bowl. Whisk the ingredients together. Then, add three cups of all purpose flour. Mix the ingredients with a spatula. Cover the bowl with a barely damp towel and let the pumpkin dough rise for 12 to 16 hours. Next, generously cover a baking she...
Purify water 3 different waysThere are three water purification methods demonstrated: Chlor floc tablets, 2% tincture of iodine and a MSR hand filter.Gather water into your plastic bottle. Add one chlor floc tablet to one liter of water. Close the top and shake the bottle for one minute. Wait seven to ten minutes. The floculation agent in the tablet takes the dirt out of the water so that it can be separated. Strain the water using a bandana over the cup to trap all loose sediment. The water ...
First of all you need to know that there are different types of Martingale Fit. In this tutorial you are first shown a running Martingale Fit. It is attached around the neck by wrapping it. You have to make sure to wrap it around the neck in such a way that it fits to come exactly in the middle of the horse’s chest. Here you have to make the connections. Now you have to go underneath the legs and attach it to the girth. You shall notice two rings hanging over from the chest. You have to attac...
In this great 10 minute video you'll learn everything you need to grow the best broccoli sprouts possible. The "sprout people" take you step by step on growing your very own broccoli grain sprouts. After this video you'll be sprouting all over the place.
This wonderful video takes you step by step on growing your very own grain sprouts. You can also use this tutorial to grow all types of grains like, barley, kamut, oats, rye, spelt, triticale or our grain mix. Grain sprouts are so fast and easy that they've included directions for sprouting in both a , mason jar and an easy sprout sprouter in this one video. After this video you'll be sprouting all over the place.
This video will show you how to do a master reset, and a factory reset on your Blackberry. If you ever need to do this, this video tutorial is a great place to start. Just follow along with this tutorial. This is a good idea if you're looking to resell your Blackberry or pass it on to a relative or friend for whatever reason. This tutorial works for any Blackberry device.
1. Use a piece of gum-paste, fondant, or candy clay about the size of a tennis ball 2. I first will roll about 1/2 of the dough through my pasta machine to a medium thickness (#4) or roll your fondant to approx 1/4 in. thickness 3. You could also use a pizza cutter or knife to cut the strips. Take two strips out to be the bow tails and then cut 2 strips in half to make thin little loops for fill-ins 4. Hang the loops over a dowel or large stick such as a broom handle (about 1in wide) 5. Wet t...
This do it yourself centerpiece is brought to you by A-Bnc parties and more. This starts of by making the bow, shown by painting a dowel and letting it dry. Then glue the 'frogs' at the ends of the dowel and glue fishing line to both frogs and trim to fit. Next take a polystyrene cut out of a violin and seal it. This helps paint stick to the surface of the cut out. The violin is painted brown to replicate an actual violin. Using black paint you detail the 'f' holes and allow to dry before pro...
Take bread flour add little sugar salt and baking powder to it. In another bowl take fresh milk add yeast and sugar mix it thoroughly and leave it aside for 10-15 minutes. Mix the dough. to this add egg, melted butter and cooking oil to it and leave it for 10 minutes. To this add the mixture of yeast and milk which was already prepared. Knead the mixture well and by covering the bowl with a cloth leave it aside for an hour. Now on a flat surface put some dry flour and knead it properly. Now m...
This how-to video explains the hydrostatic pressure.
This how-to video is about how to repair a leaky faucet. One of the most common problems with the faucet is the replacement of the rubber washer, which is located on the bottom of the valve unit. First, stop the water supply by turning off the stop valve at the bottom of the sink. Then, turn on the faucet until the water stops flowing. Next, remove the handle. To do this, we first need to remove the decorative cap using a screw driver or sharp pointed knife to expose the screw. Then, remove t...
David, the one pot chef, shows us how to make a hot dog flavored sausage rolls. Firstly, the sausages are browned up using a frying pan but not totally cooked though. They will be later cooked in the oven. To make things easy, puff pastry is taken and is made to defrost and is cut it into two even pieces. Then, the sausages are taken and are lined up on the pastry and can be chopped off if it goes over the edge. Then on the next line you add a little bit of tomato sauce along with the mustard...
Spread several sheets of wax paper on cookie trays, side-by-side. Using a butter knife, spread a teaspoon of peanut butter on each Ritz cracker. Set aside.
In this Photoshop video tutorial, hosted by photoshopuniverse, from Free Photoshop Video Tutorials, you will learn how to create an effect that makes it appear as though text you input into your image has been embossed on a glass surface. As you follow along with the host in this video, you will learn how to insert text, and align it to a plane, so that it will appear to be aligned to the surface you want to place the text on, as well as how to achieve the embossed look when you're finished.
Follow these simple instructions and learn how to ollie with your skateboard. What you need:
Finding your arm going numb under partner? Can't him/her to MOVE! In the wild a wolf will gnaw its own leg off to escape a trap. This is not the wild and you are not a wolf. Get your arm back the human way.
Mmm...barbecue pork shoulder. This oven "smoked" barbecue pulled pork will melt in your mouth. Watch this video to learn how to make a succulent, tender dish, that's great for dinners and parties. All you need to do is put the ingredients in a Dutch oven, and place in the oven for a few hours. You'll be rewarded with the delicious smell and taste of flavorful, tender pulled pork.
Systm is the Do It Yourself show designed for the common geek who wants to quickly and easily learn how to dive into the latest and hottest tech projects. We will help you avoid pitfalls and get your project up and running fast. Search Systm on WonderHowTo for more DIY episodes from this Revision3 show.
