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 42nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn ten tricks involving the LOOKUP 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 22nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll see a lifetime savings plan using the FV and PMT functions and other formulas. See how to calculate how much you will have at retirement from a basic savings plan. Then see ...
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 22nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a budget with formula inputs in an assumption area and formulas. Then do what-if analysis by saving and showing scenarios. Also see how to save variables...
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 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use comparative operators; logical TRUE/FALSE formulas, IS functions (ISTEXT, ISNUMBER, ISBLANK, ISERROR, ISNONTEXT); IF functions (1 of 2 words in a cell, 1 of...
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 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to transform bad data into useful data using formulas and text functions such as TRIM, PROPER, SUBSTITUTE, REPLACE, FIND and LEFT. Also see how to use the ampersan...
In this how to video, you will learn how to teach your dog to retrieve. First, you should teach your dog the a regular retrieve. You will toss the object so that the dog sees where it lands. Next, give it the command to retrieve. Next, attempt the semi blind retrieve. This involves tossing the object, allowing your dog to see where it has gone. Next, distract the dog for a bit before giving it the command to retrieve. The full blind retrieve should now be attempted. This is done by hiding the...
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!
Confused by the equations in chemistry class? This tutorial is here to help! Clark College Tutoring and Writing Center tutors Kevin Martin and Joey Smokey explain how to balance chemical equations, providing examples and tips in this two part video series. You will definitely improve your test scores after watching this step by step program.
In this video from modernmom, Nancy Stone, a parenting coach teaches how to teach your toddler the days of the week. There's a few simple and easy tips to do this. Music and songs are some favorites. Also rhyming things with the days of the week is a great idea. Or make a calendar and have them trace the letters. Another example is to speak to them and say things like on Saturday we don't go to school and Sundays we go to church. Another thing to say is when they wake up work in the day of th...
In this Outdoor Recreation video tutorial you will learn how to teach a horse to back up under saddle. Teaching a horse to do anything under saddle usually starts on the ground. If your horse knows how to back up on ground then you can do it under saddle. On ground put a little bit of pressure on his nose with your hand and he will backup. Then put a little pressure on the rein and speak and tell him ‘back’ and he will. Then once you get on the saddle, pull the reins slightly and say ‘back’. ...
In this video you learn how to teach your horse how to pick up your hat. The host says that horses are mouthy and they tend to pick things up such as an empty food bucket, they'll pick up paper, they'll pick up things that are curious. He says that horses are fairly easy to teach this. He says that his horse used to pick up his grain bucket when it was empty. He says that when his horse would pick it up he would say hat and give the horse a treat, and after a while the horse would use this co...
Algebra – The Distance Formula.
This video is an acoustic guitar lesson from yourguitarsage. In this video, he teaches you how to play the song "Eleanor Rigby" by The Beatles. He begins by showing you which chords you need to know to get started on learning the song, and demonstrates them for users who may be still learning. He then moves on to the progression of the chords through the song, teaching you the intro, verse, bridge and chorus parts of the song. The C, E minor, and variations of the E minor chord are taught in ...
This video describes how to create a jumping letters in Flash, first create the text for example "JUMP" and using Break the letters each and then make the layer and now convert the letters into "Movie clips" and now we should add the key frames to our "time line”. Then moves the letters up by using the up arrow now copy the key frames from font end and paste on the back again for go up and come down the letters again and add the "motion between" for each letters and now skip the key frames by...
In Part 1 of this electric guitar video lesson, brought to you by GuitarJamz, host Marty Schwarz will teach you how to play "Sir Duke" by Stevie Wonder. As you follow along with him, he teaches you the intro of the song, breaking it down slowly so that you can follow along with him. Then he moves on to 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. You will learn the...
In this video are the Afro-Cuban Percussion Class at Grossmont College, with instructor Manny Cepeda to show us how to play a Meringue rhythm on the Conga Drums. He starts off with a slow beat by beat demonstration and then moves on to a faster beat. The camera changes the view so that you can see both a front and back view of him drumming. Once he has shown the basics he shows the different variations you can use and the various counts that you can start on.
An educational video from Math Problem Generator that shows how to multiply variables. It is a very short video - about 1 min in length.
This is an interesting mathematical instructional video on how to make a quartile diagram. This example is about 34 grades obtained by chemistry class students. We need a minimum value, a maximum value, Q1, Q2 and Q3 values to make a quartile diagram. The minimum is 43 and the maximum is 92. To calculate Q2 median formula (n+1 over 2)is used. The Q2 median is 17.5. So the average of 69 and 71 is 70 and hence Q2 70. Similarly Q1 is calculated as 61 and Q3 is calculated as 79. Now you can draw ...
This lynda.com video tutorial shows how to use container fields with FileMaker Pro 10. When you want to create fields in FileMaker database you have the choice on what kind of fields you want to make. Many general fields are self explanatory like text, date etc., but there is a special kind of field called the container field. FileMaker Pro container field is a versatile data type in that it can store any kind of binary data. Container fields can be used to hold binary data in four broad clas...
Want to know how to use the Pyro FX tools in Houdini 10? This masterclass will tell you everything you need to know about using Pyro FX fire and smoke tools in Houdini 10. The discussion covers the addition of exciting new fire and smoke tools. Topics covered include a powerful new fluid up-resing technique, advanced noise and turbulence control, and a highly tweakable custom fire and smoke shader.
Did you sleep all semester in your Calculus class? Are you just waking up now to realize you have a test on Monday and that you're totally screwed? Well, luckily you can learn an entire semester worth of Calculus in just twenty minutes... or at leasts that's the hope.
Fit for a Feast hosts a kids cardio workout including Salsa steps, sit-ups, jumping jacks and more. This is a great warm-up for kids on their way to sports or dance class; it can also be used for Q.D.F. (Quality Daily Fitness) at school. With a Latin American cd in your stereo and this tutorial, you're child will be working up a sweat in no time! Be sure to stretch before you begin!
Are you a Hairspray fan? Why not learn the routine for, "Nicest Kids in Town" from one of Hairspray actors? Tabitha Lupien, who played Becky in Hairspray gives a dance lesson for a class of youngsters for Fit for a Feast, a children's video site full of kid cooking and kid fitness videos. Incorporating jazz dance, leaps, turns, and kicks, this lesson from Tabitha is sure to get your blood pumping and your body sweating! A great way to get some exercise! this afternoon!
The loud pop and a flying cork are not the goals. This video from CHOW.com shows you how to open a bottle of bubbly without showering your guests or wasting the lovely contents of the bottle. You need to have a knife to cut off the foil. Cover with a towel to keep it safe. You don't want to pull the cork. You want to twist it for the faint hissing sound. No pops here!
What else can you do with a deck of cards besides play games? Magic! There's nothing better for a magician's repertoire than a few great card tricks, so make sure you watch this video tutorial on how to perform the "year game" magic card trick. This is a lengthy trick, but it's sure to amaze and baffle anyone. To do this year game card trick, a little mathematics goes a long way, so don't fall asleep in math class.
What else can you do with a deck of cards besides play games? Magic! There's nothing better for a magician's repertoire than a few great card tricks, so make sure you watch this video tutorial on how to perform the "impossible card location" magic trick. This is a lengthy trick, but it's sure to amaze and baffle anyone. To do this impossible card location card trick, a little mathematics goes a long way, so don't fall asleep in math class.
Need to shoot a film for class and realized you don't have a Fisher Dolly and your cinematographer's hands are a little to shaky for what you would consider good filmmaking? Well, this video tutorial will show you how to make your very own steadycam. Check out how a nautilus design transforms into a more suitable steadycam; the gimbal is the key, and gimbals are very hard to find, especially the right one.
Learn how to ski by watching "The way to better skiing." This skiing tutorial sequence consists of 11 professional teaching videos taught by six of the best Danish ski instructors for all levels in all terrain: Lasse Lyck, Klavs Klavsen, Rasmus Lundby, Tue Bak, Martin Hulten and Pernille Hornhaver. In the ninth lesson, learn to ski powder and master the bumps. Mastering bumps or moguls and powder skiing are most skiiers ultimate dream.
Work on turns for skiing over bumps or moguls. Learn skiing tips and techniques in this video lesson from a ski instructor. Take action: re-center on uphill foot, practice ouch, tip, drift, and flatten skis, don't rush middle of turns, and be patient. Bill, the host of this how-to video from Live Strong, is a former world-class freestyle competitor and elite coach. He is now the indoor ski simulator coach at the Aspen Club and Spa at John Clendenin's Ski Doctors. Laurie is a long-time aspen r...
In this tutorial Lindsay Adler will teach you how to add makeup to your models in Photoshop. Sometimes you do not have access to a makeup artist, or after the shoot decide you want a splash of color. Lindsay will teach you to add makeup in a few quick steps in Photoshop.
Birds can be taught to perform tricks, just like dogs. This video tutorial shows techniques for how instruct a pet cockatiel to follow simple commands. Learn how to train a Cockatiel to do tricks by watching a professional parrot trainer show you step-by-step how he taught his Cockatiel the "How To Flex" trick.
Teaching a dog a new trick can be simple with practice, patience, and proper procedure. Learn how to teach a dog the which one trick, in which the dog paws at the hand holding the treat, by watching and following the step by step directions in this video tutorial.
This video teaches you the basic yet fundamental rolls of banjo. Among the rolls taught are the forward roll, the backward roll, the forward backward roll, and the alternating thumb roll. Enjoy.
Larry Keim, the host of "Rolling R's", teaches Junior High School Spanish in Mesa, Arizona. He has a passion for Spanish and he's created this video podcast to give away Spanish lessons for free. In this episode, Larry will teach you how to tell time in Spanish.
While we haven't covered Amazon Web Services, or AWS, on Null Byte before, Amazon's cloud computing platform is ripe for attack by hackers, pentesters, and cybersecurity researchers. It's also an excellent cloud hosting service to build or use vulnerable-by-design AWS setups and frameworks.
If your students are having trouble with density, check out this tutorial. In this entertaining video, teacher Mr. Edmonds goes through all the steps to find the density of an irregular solid object to the tune of "Afternoon Delight". This song should help your kids remember how to solve these problems quicker and easier.. just don't be surprised if you get this catchy tune stuck in your head!
Alicia from Unico Creations teaches you how to make crocheted jewelry.
Bird speech CDs may not be as effective as intended as the repetition may actually bore the bird. Cockatiels are receptive to learning, but need to be approached correctly. This video tutorial covers some simple basics of how to train a cockatiel to talk by following the "heightened state of emotion" principle which can teach cockatiels to talk faster, using any training CD properly.
Don't worry, you won't look like a smurfette if you wear blue mascara instead of black. Blue mascara sounds kind of like something only teenage punks in art class wear, but in fact it's a great alternative for black for any girl.
"Everytime We Touch" by Cascada is one of the all-time classic of mainstream house music, and can still be heard at clubs and parties around the world. If you want to class the song up a bit, watch this video to learn how to play a cover of it on solo piano.
