hether 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 38th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the TRANSPOSE & FREQUENCY functions.
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 18th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to calculate (and sum) subtotals in Excel. See how to do subtotaling with the SUM function.
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 12th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the TODAY, NOW, DATE, YEAR, MONTH, DAY and EDATE functions.
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...
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 ...
One of the nicest things you can do on someone's big day is to make them a homemade cake. In this tutorial, learn exactly how to frost that cake you just made so that it looks beautiful for someone's birthday. By frosting with the proper techniques, your cake will look like a pro designed it, even though you made it at home.
In this tutorial, professional guitar player David Wallimann, demonstrates how to read and understand guitar chords in less than one minute. With this straight forward approach you should be on your way to reading and performing proper chords in no time at all. Follow along and practice finger placement along with David, and start playing like a rock star. Reading chords is very important and is one of the first things you will learn when you start jamming, so get a head start and check out t...
Maybe not everyone's aware of this, but when bought, pointe shoes are incredibly tough and when not broken in, painful to wear. In this video, learn how to break in new pointe shoes to make them easier to dance in. They can be bent, molded, massaged and even scraped to get the proper flexibility and traction. Find out how to safely break new a brand new pair of shoes with helpful instruction from an expert: Mikael Monson is an instructor specializing in ballet and pointe at the Virtuosity Per...
In every ballerina's life, there comes a day when they are awarded permission to buy their first pair of pointe shoes by their instructor. The ribbons and elastic must be sewn onto pointe shoes after they are purchased, and finding the proper placement for each can be tricky. Find out how to properly sew the ribbons on a pair of pointe shoes from someone who knows what she's talking about.
Are you an aspiring ballet teacher? Much of teaching ballet techniques to students comes from demonstration & physical correction so that the student's muscles can learn the proper form. Learn how to teach ballet techniques from a pro teacher!
Get your hips out and start learning how to hula with help from this free lesson! Hula dancing is a traditional folk dance of the Hawaiian islands, and it is similar to belly dancing in the hip and stomach isolation it involves. Learn about the proper techniques for hula dancing from a pro: Rosario Nene Ortega is a ballroom dance instructor at The Goddess Store in Hollywood, Florida. Learn more dance moves from this expert by searching WonderHowTo! You're only practice time away from ruling t...
This video illustrate us how to build a drip irrigation system. Here are the following steps: 1. To build a drip irrigation system you need a pipe, hydro cyclone, screen filter, Pressure building pump and micro filter.step 2: Connect the pipe to the water source and let it pass through the hydro cyclone to settle down all the sand. 3: Now from the hydro cyclone pass it through the pressure gauge for building up the pressure ant then this pipe passes through the network of horizontal and verti...
How to do squats to strengthen your stomach muscles
In this how-to video, you will learn how to replace a broken axle on a Volcano SV. First, take off the wheel. Next, remove the axle piece out with a hex wrench. To get it entirely out, use your hex wrench to move out the long screws. Make sure you take them out at about the same time, or you will break one of the screws. You can remove the screw to free the upper suspension arm. This will make it easier to remove the broken axle. Next, replace it with a new axle. Clean the axle before making ...
In this how-to video, you will learn how to make a paper snowflake. This is great for the winter. The best way to make a good snowflake is with the way you fold it. Start off with a square piece of paper. Fold the paper into a triangle. Now, fold the triangle along the height into another triangle. Take one of the lower corners and fold it 60 degrees. Fold the other side the remaining 30 degrees. Snip off the trails with scissors. Now, cut patterns into the sides of the paper. Unfold and then...
This video illustrate us how to deal with broken tree branches and problems with grapes. Here are the following steps:Step 1: First of all clean the broken branch with water.Step 2; Now apply some tree primer or tree paint on the exposed area for quick healing and to prevent any infection.Step 3: To deal with problems in grapes first of all look for any infection on the leaf, stalk or the fruit.Step 4: If in case there is some infection ,identify the problem and sprinkle the pesticide for tha...
With the proper planning and education constructing your own fence can be a breeze. This video tutorial offers an in depth look at how to build a fence for your own home. Learn the basics of building a fence with the help of The Home Depot.
There are so many different lighting kits out there, but what's the right one for you. Fortunately this video tutorial series demonstrates the different types of lights and picking which ones are the right for your production.
Woodland areas provide a personal forest where you can ramble about and relax. This video tutorial teaches you how to chop down a tree in your woodland area and what to do with trunk afterwards. First, you'll need to have the tools and proper safety equipment. Next, thin the trees to allow more light and encourage growth. Then use your chainsaw to cut a gap on the side of the tree that you want the trunk to fall. Finally, sned the tree by cutting off branches and reducing it to manageable 2 m...
Cindy Mastry explains how yoga exercises can help with the union between mother and child for a woman who is pregnant. The word yoga translates to "union." The first exercise demonstrated is the Hindi Squat. While working strength and balance, the woman holds herself in the perfect position for giving birth. The next exercise Cindy calls "Cat Circling." The woman stands on her hands and knees and rotates her body in a circular motion, anchored my her limbs. This is supposed to put the baby in...
Make sure your neighbors don't mind before you learn to play the drums with Mr.G. In this new four part series, he is going to teach you how to play the drums. You'll start with extreme basics, including your grip, to learning a simple 16th note full measure. Watch this, if your sick of just "banging", whether it be pots and pans or a proper drum set.
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...
There's nothing like milking a dairy cow straight from the teat. Of course, before milking you'll need to sanitize the teat with a sterile solution and paper towel. This video tutorial demonstrates the proper methods of milking cows using a standard milk machine pulsator for professional results.
This humorous video teaches men how to iron a shirt just like Mom did. It walks you through the steps from setting up the ironing board and the iron, to the finished product with easy to follow directions.
Getting into ballet? The arabesque ballet is a fairly difficult move and is usually put off until a dancer is conditioned and ready for such a move, usually around the third year of their training. Find out the proper way to do an arabesque with help from a ballet instructor in this video tutorial.
In this video from FiveSprockets we learn how to light an interior space while filming on a budget. For this you need two Chinese lanterns which he found for $2.95 each. You need 2 light bulbs which he found for $3.95 each. Make sure you get extra ones. Then get a couple of pan lights. They are day light and mood light. They were $7 and $5. You also need a multi colored gel pack which is $6.00. He uses C-stands to hold the lights up but he suggests coming up with other ways if you don't have ...
In this video tutorial, viewers will learn about decorating bag basics. A decorating bag is used to pipe semi-solid foods by pressing them through a narrow opening at one end for many purposes, including cake decoration. Viewers will learn about the types of decorating bags, how to add a coupler to a decorating bag and the proper way to fill a decorating bag with icing. This video introduces three different types of decorating bags. The bags are the feather white bag, the disposable bag and t...
When defining fields in FileMaker Pro 10, one has to choose what type of field to decide for a database. There are two fields that accommodate special handling of data. They are time and time stamp fields. When one decides a field under manage>database,there is a option for "type". Under that, there is time and time stamp. The "time" one determines the time while the "time stamp" determines the time and date. This will help in preparing a proper and detailed database system.
In this acoustic guitar video lesson, brought to you by GuitarJamz, host Marty Schwarz, will teach you how to play "Wish You Were Here" by Pink Floyd. As you follow along with him, he teaches you the progression of the chords used in the song, breaking down each part of the song, teaching you the chords and explaining the strum pattern and picking of the guitar riffs. This tutorial focuses mostly on just the beginning of the song, and does not cover the entire song.
Stampin' Up! with Dawn presents a video on how to make a cute snowman ornament that is perfect for the holiday season. The design was made by one of her viewers and she was able to get all the proper measurements and instructions needed to make this piece. She shows us how to do it step-by-step and shows us which materials and techniques should be used in order for the snowman to come out just right. By following the instructions in the video you can make an adorable magnet yourself without h...
Impress your friends and family with this tasty Filipino shrimp dish with a creamy lemon dill sauce. All you'll need is cooked shrimp, sour cream, mayo, salt, red onions, dill, sugar, and lemon to make this easy dish. He takes you through the preparation step by step and how to add and mix the ingredients in the proper order to get the perfect flavor. No ovens, pots, or pans in this recipe just let it marinate overnight and you're ready serve!
JoAnn from Emerald City Elegance Paper Crafting demonstrates how to make a double accordion photo album. It's a cute and fun way to display your photos, and it's made simple with JoAnn's easy instructions. She takes us through the step-by-step process, indicating the proper tools and measurements needed to make this item. By following the steps in the video, you'll have yourself a beautiful little homemade photo album, made at a fraction of the cost of buying one from the store.
This video demonstrates how to write the letter P in calligraphy copperplate. The technique that is illustrated in this video show you the proper way draw the letter P effectively and beautifully. The video first shows you how to draw the capitalized letter P. The first step is to create a slightly S-curved stroke downward from the top margin to the bottom-middle margin--thickness in the middle. You end the line with a curled tail. To complete the letter you then have to draw a looping, curle...
