Always make sure you've formatted your numbers correctly within the proper cells when you're developing a spreadsheet in Microsoft Excel. There are a variety of number formatting functions you can use to make your spreadsheet more readable, and this tutorial explains how to use number formatting 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 8th installment in his series of Excel array formula series, you'll learn how to use the array FREQUNCY function correctly.
The autofocus functions showing up on new DSLR cameras are quite useful if you know how to use them. The Nikon D3100 is no exception, and this video will teach you about the different auto-focus modes and which ones you should use to make your pictures look as good as easily as possible.
Wait, a query within a query? This function is possible within the framework of MySQL. Learn how to correctly implement a subquery or sub select in your next database project and avoid a couple perils that will make your program unstable.
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 658th installment in their series of digital spreadsheet magic tricks, you'll learn see how to use the COUNT & COUNTA functions correctly. COUNT counts numbers. COUNTA counts non-empty cells.
The importance of paint cannot be underestimated when it comes to correctly constructing a reborn baby doll. There are many tutorials showing you how to correctly replicate the hair on your baby doll's head, but what about the eyebrows? This tutorial shows you how to use a variety of paints and fine tip brushes to correctly achieve realistic eyebrows as well as head hair for your next reborn project.
Your grip is a big part of your golf swing, and there are many grips you might not know. Try all the free golf tips for your grip and swing in this video golf lesson series.
Photoshop is great software for manipulating images, and Dreamweaver is great software for making websites. Do you want to combine their powers to create an even more awesome website? This video will show you how to move designs from Photoshop into Dreamweaver properly, enabling you to use them on your website and make it look as snazzy as can be. You'll also learn how to make a good background using CSS as an added bonus. Yes, that means coding. No, it's not scary or hard.
United States Womens Softball Team members discuss and illustrate how to run the bases correctly. The main techniques used are how to lead off then steal each base as the technique is different for each one, and perform the hit and run. The breakdown is great!
If you're a habitual runner - or you want to become one - then it's super important that you run correctly. Even if you don't notice it at first, running with the wrong alignment can cause leg and back issues later on that are extremely painful and difficult to deal with.
If you've recently sharpened your lawn tractor's blade or purchased a new one, it's a sure bet that deck leveling is needed. This makes sure that you get a nice clean cut and know how far you need to lower your deck.
This video describes how to improve your singing technique which is useful for singers, orators and anyone who would like a better sounding voice. In this video one will learn that there are six muscles involved in singing and that there are exercises to improve their function which in turn improves one's singing voice. For example in the first exercise one learns the importance of the cheek muscles and how they can hamper one's voice if they are not moving correctly. Overall this video is in...
This video demonstrates how to use a Nikon SD-80 Battery Pack with a Nikon SB-800 Speedlight. The first step is to identify the different power adaptors on the ends of the cable leading to the battery pack. This pack is powered with AA batteries. Remove the outlet plate on the SD-80 and insert the power cable into the SB-800 Speedlight. Then attach the communication cord to the Speedlight. Now place the Speedlight in the hotshoe of the Nikon camera and let the battery pack dangle or attach it...
In this video, we learn how to say a little poem/joke in Tagalog. When you first want to learn how to say these different poems or jokes, you will want to make sure you understand how to say these words correctly. The vowels are the most important part of the words, so make sure you are pronouncing correctly. Listen to audio to learn how to say the joke correctly, then when you have it down you will get a lot of laughs! This is a great joke to use with friends or family and can be used in Tag...
Using rinse aid with your dishwasher can be a big help with making sure your dishes come out streak free and dry. If you're dishwasher is not properly drying your dishes correctly, you might have a small problem that can be fixed pretty quickly.
Pitching a spinning rod is one of the best ways to catch deep fish for those who use spinning rods. This video features a bass fisherman going through some tips on how to pitch correctly in order to catch the most bass. He may be doing it in his front yard, but the lessons herein are no less valuable out on the water.
Writing papers can be a long, difficult process that can take up any sutdent's Friday night or worse: weekend. It's a common fact that most students need to cit a source when using a direct quote or piece of information obtained from any magazine, book, or even film. But a big problem is that there are some who do not undrstand the basic need to cite correctly in order to avoid plagiarism. Not doing so can result in some bad things happening for that pupil. So sit back, pay attention, and fin...
Breathing Challenges with Erik Dillard and Athan Datu is the name of this video and they will show you the correct way to breathe as you sing. Breathing is everything and the shown "S‚" drill helps you to learn how to exhale the right way. Tips like using a stop watch to help time and how to soften the "S‚" to get more out of your breathing will soon have you being able to exhale much longer and have much more control, which is necessary for singing.
Fold your baby carrier correctly--yes, without folding your baby!
Tennis pro Brad Gilbert gives strategies for serving correctly. Strategies are given as to how to serve in the deuce court and ad court. The types of serve shown are the body serve, middle serve, wide serve and slice serve. Howe to serve and volley is also shown. Summaries and tips appear during the video in the form of sidebars and tips respectively. Easy to understand.
In this Fitness video tutorial you will learn how to do a yoga handstand correctly. Bend forward and place both your hands on the ground. The fingers should be pointing forward and the palms should be flat on the ground. The shoulders should be naturally in to the body. They must not be stretched. Keep both the legs bent at the knees. Now lift one leg and practice kicking slowly with the other leg and pulling the navel in towards the spine. And eventually the full body will lift up and go bac...
This video in the Fitness category will show you how to do squats correctly. This exercise is meant for the legs. The easiest way to do this is to sit down and stand up using a bench. The bench should be about knee height. Technically the line from the ankle to the knee and the line from the hip to the shoulder should be parallel as you go up and down. The legs should be about one and a half feet apart. This is the body weight squat. As you progress, you can do the dumbbell squat. The video ...
This video shows you how to stand correctly when hitting a golf ball. It is very easy. No matter what kind of club you have in your hand, you don't change. The most important thing is to have your arms hang straight down from your shoulders. If you do this correctly then your hands will be directly under your chin when you bend over the ball. Your knees should be slightly flexed over your laces and your shoulders should be over your toes. This gives you an athletic, balanced position and you ...
This tutorial gives a demonstration of a cardio workout. It explains the jump rope exercise and provides tips on how to perform the exercise correctly. Jumping rope is one of the best overall cardio exercises and burns serious calories in a short amount of time. This is one exercise you definitely want to keep in your workout routine to see results.
This tutorial will show you how to apply foundation correctly.
This video provides tips from Tim Horton on how to correctly tie fishing knots.
You can learn how to swing the golf club correctly. You don't have to swing the club straight back and through. You need to swing at an arc.
The front brakes are the brakes that you will be using the most often on your bike, and making sure that you have installed them correctly is crucial. This video walks you through the process of installing the front brakes on you fork, with the handlebar part of the brakes already installed.
Installing trusses requires some important steps to ensure they are centered and lined up correctly. Henry shows you how to do this and make sure your trusses are spaced correctly and level.
In this video, we learn how to adjust the spring tension on a Tremolo. First, find the strings in the back that are parallel to the body of the guitar. Then, unlock the nut and set the fine tuners so you have maximum range of adjustment. Start to twist the tuners at the bottom of the guitar until the tension on the strings is enough for you to play correctly. Then, go to the back of the guitar and adjust the crimp screws that are along it. When finished with tightening your guitar, test it ou...
In this video, we learn how to read numbers in Arabic. Make sure you are looking at the screen while reading the numbers, so you can get a visual key as to how the numbers look. As you start with the first number, you should learn how to say them in Arabic using the correct pronunciation as well. Each of the different numbers have a unique look in Arabic and should be written out correctly, because they can be mistaken for other numbers if not written out correctly. You can also write several...
Christy Lendwehr and Julie Goodnight from the Certified Horsemanship Association explain how to know when you have a fitting and correctly adjusted horse riding helmet. First and foremost, you should wear your helmet every time you ride and you should be sure that is a ASTM SEI helmet approved for equestrian riding, as they also make helmets for sports and those should not be used while riding a horse. When putting on a helmet you should be able to push it and only the wearer's eyebrows shoul...
This video shows us the procedure to use an iPhone with a microscope using iMicroscope. Open the application and focus the object correctly in the microscope. Bring the camera in the phone near the eye piece and click a photo once you get the object correctly focused. Hit 'Use' and put in the magnification of the image. Hit 'Accept' and view the image. You can see a magnification scale, date and an automatically scaled scale bar. You can zoom in the image. Save the picture in the camera roll....
Learn how to use depth of field with help from this photography tutorial. Although it may seem that depth of field is a confusing factor in photography, it's actually quite easy to understand & adjust once you've gotten the hang of it. Depth of field (or, DOF) is a great way to experiment with your photography & improve your skills as a beginner photographer. When taking your photograph using DOF, it is imperative to remember that the shutter speed and aperture (or F-stop) need to change at e...
Mrthoth will show you how to use, count, and mass nouns correctly. Listen to a sample sentence and try to find the grammatical errors in the sentence. A mass noun ca refers to a whole group of objects, for example you would not say a lot of butter you say a lot of butter. A count noun is basically a noun you can count. You can make it plural and you can put a number in front of it. Like you say it was a lot of pencils.
Check out this video tutorial on the very basics of a chess game. In chess the very first thing you need to know is how to move your pieces. That's what this chess video is all about.
This tutorial will show you how to drive and pilot a tank in Battlefield 3 correctly. It also instructs you on which offensive and defensive abilities and upgrades to get, including autoloader, thermal optics, and a coaxial HMG. The tutorial will also give you tips on how to destroy enemy tanks.
League of Legends most fearsome assassin is Talon--the Shadow's Blade. If you want to learn how to build Talon, what runes and masteries to take on him, or how to lane with him correctly, look no further than this champion spotlight from Riot Games.
Does your car engine blow white or blue smoke when your first start it up and then stop? That usually means that your engine valve seals aren't working correctly. Watch this video to learn how to find and fix the problem.
Being able to read an electrical diagram will greatly aide your ability to correctly diagnose car problems. If you need some help with it, watch this video for a detailed explanation of how to read an example map for the clutch start switch on a Toyota.
