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.

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.

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.

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!

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.

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...

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.

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...

Regression functions are a vital part of statistical analysis of populations, and if you're involved in business, science, or nearly any academic field you should understand how it works. This series of videos will show you how standard regression functions, ANOVA, ordinary least squares, and everything else you need to know.

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.

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.

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.

Excel 2008 for Mac makes it easy to create formulas for cells. You could always do it before, but now with the new Formula Builder feature, building formulas just got one step closer to simple. The Microsoft Office for Mac team shows you just how to build formulas by using the new Formula Builder in this how-to video.

In this video the instructor shows how to graph a piecewise defined function. A piecewise defined function is a function that is defined in separate pieces. In these kind of functions, for different ranges of the value of x, you are given different small functions, all of which together make the whole function. This means your equation of the function is given in the form of smaller functions. Now to graph these kind of equations all you have to do is graph the individual equations in the sam...

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...

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.

In this video the instructor teaches about inverse functions. Normally in inverse functions problems you are given a function that has a set of points and you are asked to find the inverse of that function. So if the function has a point in the form (x, y) then the inverse function has its points in the form of (y, x). Now when you are given a function f(x) that is in the form of x and asked to find its inverse, equate the function to y. Solve the equation to get the value of variable x in th...

MapForce includes a powerful visual function builder that lets you create new data processing functions in a graphical way using existing functions and libraries. Learn how to combine multiple separate functions that returns a single result with this tutorial.

In this clip, you'll learn how to create and call simple functions when coding in Python 3. Whether you're new to the Python Software Foundation's popular general purpose programming language or a seasoned developer looking to better acquaint yourself with the new features and functions of Python 3.0, you're sure to benefit from this free video programming lesson. For more information, including detailed, step-by-step instructions, watch this video guide.

On Yay Math, Robert Ahdoot, founder of Yay Math, will show you some square root functions and some inequalities. He begins with the problem y=x². Then he makes a sketch with two intersecting lines in a t shape. The problem is illustrated by a curved U shape, the U's bottom resting on the horizontal bar, which represents x, while the center takes the vertical line. The vertical bar represents y. This U is directed up because the x² is a positive number. If the number were negative, the U would...

Need to know how to solve function problems in algebra? From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar Salman Khan's series of free math tutorials, you'll learn how to work with and solve functions.

What does f(x) mean? What does g(4) mean? We explore this and more in this 3-part series, "Understanding Math Functions."

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.

In this video, we learn how to play Jazz guitar: Functioning & Static Dominant Chords. When you play an A7 going to a D chord, you are playing a functioning dominant, because a five chord always wants to go to a one chord. This is because of the tension in the five chord and how it resolves to the one chord. You will hear that the chord wants to go to a different chord, so make sure you understand this concept as you are playing. If the chord does go to the other, it's referred to as a functi...

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 694th installment in their series of digital spreadsheet magic tricks, you'll learn how the SUMIF function (and COUNTIF, etc.) cannot accept arrays. If you need to sum by year from transactional data the SUMIF and YEAR functions cannot be used together. Instead we can use the SUMPRODUCT 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 31st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to build frequency tables and simple histogram charts in Microsoft Excel. Specifically, this video addresses the following subjects:

This test can be used to determine whether the given graph is a function or not.

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.

Exponential functions are functions which contains terms which are integers raised to the power of variables. Note that the variables are not raised to the power of integers, but the integers are raised to the power of variables. Variables raised to the power of integers are called as polynomials and are a different class of functions. But exponential functions grow very fast than polynomials with the increase in the value of the variable. To understand the growth of these functions take a si...

This video teaches us to draw the graph of a piecewise function. This is shown using two examples. In the first example we have 'y' equal to 'x + 2' for x less than zero and '1 - x' for x greater than equal to zero. We plot two points on the function for x less than zero and do the same for the function with x greater than equal to zero. The graph for the first function is erased for x greater than equal to zero, and the same is done for the second function for x less than zero. Note that the...