Standard Tips Search Results

How To: Extract records from a table to a column in MS Excel

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 137th installment in their series of digital spreadsheet magic tricks, you'll learn how to extract records from standard table and put a record in a column using the VLOOKUP, IF and ROWS functions.

How To: Find averages & standard deviation in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 243rd installment in their series of digital spreadsheet magic tricks, you'll learn how to find typical values, or averages – a single value that allows you to talk about all the data points in a given spreadsheet. Specifically, you'll learn how to find the mean, median, mode and standard deviation for a set of numbers.

How To: Use the STDDEV IF function in Microsoft Excel

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 145th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that will calculate the standard deviation when you have more than 1 criterion.

How To: Use non-standard page protectors when scrapbooking

In this Arts & Crafts video tutorial you will learn how to use non-standard page protectors when scrapbooking. It is a tip on getting a large number of photos in an album without taking up too much space or using too many supplies. You can get 12 x 12 page protectors in terms of size but with pockets for 4 x 6 photos. This way you will have 6 photos on each side of the protector. Or maybe you put 5 photos and a card on one side. If you don't want to mess around with extra page protectors, you...

How To: Make your Android phone feel faster

If you're looking to get a faster Android phone without resorting to installing a custom ROM, check out this helpful video to learn seven tips for speeding up an Android smartphone. There are a number of easy adjustments to the standard Android settings that will make the phone seem much faster.

How To: Use the auto-complete feature in MS Office Excel 2007

Microsoft Office Excel 2007 Tip - Using Formula Auto-Complete - Microsoft® Office Excel® 2007 is truly at its best when it's working hard behind the scenes to execute complex calculations, working with any of a number of standard formulas. When we're creating spreadsheets, formulas should be easy to replicate again and again, but human error can sometimes get in the way.

How To: Make an Aquarius fall in love with you

Aquariuses have high standards, but anyone with the right drive can meet them. Use your creativity, knowledge of art and music, and good social skills to trap that Aquarius. Learn how to use astrology advice in dating, by watching this how-to video. Pick up astrology tips on making a relationship with a Aquarius work.

How To: Celebrate the 8 days of Hanukkah with the standard Jewish traditions

If you don't know exactly what goes on during Hanukkah, this series of videos will set you straight. Hanukkah is the most recognized Jewish holiday, right around Christmastime, and Chaim from Maoz Israel is going to show you some traditional customs that are performed during the eight days of Hanukkah 2010. Learn about the menorah, sufgaiyots, the mysterious dreidel and the traditional Chanukah songs.

How To: Create nested unique lists in Excel via array formulas

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 251st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a unique list of customers within a unique list of sales reps using a series of standard formulas in tandem with a few array formulas.

How To: Use the Empirical Rule w/ standard normal distribution

In this video tutorial the instructor explains about the concepts of standard normal distribution and the empirical rule and how to use it to solve an exercise. He starts by explaining about standard normal deviation saying that in a standard normal deviation the value of mean is zero and the value of standard deviation is one. Now he draws the standard normal deviation by drawing a bell curve on an axis. Now he points the mean and standard deviations on it. Now using these concepts he goes o...

How To: Use AGGREGATE instead of SUBTOTAL in MS Excel 2010

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 664th installment in their series of digital spreadsheet magic tricks, you'll learn how about how the new Excel 2010 AGGREGATE function that can calculate these 19 different functions depending on what number you put into the 1st argument of the AGGREGATE function. This is an improvement over the SUBTOTAL function wh...

How To: Calculate sums in standard form

When a number is expressed in the form of x multiplied by 10^y such that, x < 10 and y is an integer, the number is said to be in standard form. Standard form of expressing numbers finds its use in scientific and statistical fields. This video demostrates how to express, as well as perform basic mathematical operations namely, addition/subtraction, multiplication and division of numbers in the standard form using four examples/mathematical problems. The first two examples demostrate multiplic...

How To: Know standard deviation in your financial portfoli

In this tutorial, we learn how to know what standard deviation is in your portfolio. Standard deviation is the amount of risk you have inside your portfolio, this will show you how much fluctuation you have in your portfolio. Depending on the expected return of your portfolio over an amount of time, you could have a different range of standard deviation. Knowing what your standard deviation can help you do the math to see what your chances of a return or loss will be for certain. This will he...

How To: Convert numbers in and out of standard form

In this video, we learn how to convert numbers in and out of standard form. Standard form is a useful way of writing down very large numbers and very small numbers. To do this, you will look at the number you have and ignore the zeros that are just at the end. Then, write down the basic numbers. Put a decimal point in this number to make it between one and ten. Now, write down x 10 and put the power for how many places the decimal point moved to get to the new number. This will help you write...

How To: Activate Microsoft Office standard 2007 with key

Chances are if you've used a computer in the last decade or so, you've probably used Microsoft Office at some point. Activating Microsoft Office standard 2007 will give you access to functions you might not have even known existed that can increase your productivity and improve your work flow. This video will show you to activate Microsoft Office standard 2007.

How To: Calculate standard deviation

Looking to find the standard deviation of your set of values? Standard deviation quantifies how diverse the values of your data set are, and is useful in determining how different your numbers are from each other.

How To: Perform the Slow Flight maneuver

In this AeroCast episode, UND Aerospace discusses the Slow Flight maneuver as performed in the Piper Warrior (PA-28-161), referencing the procedures and standards outlined in the UND Warrior Standardization Manual. All performance tolerances are based on the performance standards set forth by the FAA Private Pilot Practical Test Standards. Since the most critical phases of flight occur at airspeeds less than cruise, a pilot must always be comfortable with his or her airplane’s handling charac...

How To: Perform Power On Stall maneuvers

In this AeroCast episode, Anthony Bottini discusses the Power On Stall maneuver as performed in the Piper Warrior (PA-28-161), referencing the procedures and standards outlined in the UND Aerospace Warrior Standardization Manual. All performance tolerances are based on the performance standards set forth by the FAA Private Pilot Practical Test Standards. Power On Stall practice is vital in increasing a pilot’s proficiency in regards to stall recognition and stall recovery techniques during an...

How To: Compare 2 distributions with the Z-Score formula

This is a video tutorial in the Education category where you are going to learn how to compare 2 distributions with the Z-Score formula. In this example Doug's class has X bar as 71 and a standard deviation of 4. Corey's class has X bar as 68 and a standard deviation of 11. If both Doug and Corey beat the class average and have the same standard score, will Doug have a lower grade than Corey? If both of them have a standard score of 1.5, then Doug will get 77 marks and Corey will get 84.5 mar...

How To: Create a new standard user & admin in Windows 7

In this video tutorial, viewers learn how to create a new standard user and administrator account. Begin by clicking on the Start menu and select Control Panel. Then click on User Accounts and Family Safety and click on User Accounts. Now select the "Manage another account" option and click on "Create a new account". Users are able to name the account and select the account type (Standard or Administrator). Finish by clicking on Create Account. Users are then able to make changes to the accou...

How To: Find the standard error of the mean

In this video the tutor explains about the standard error of the mean. He starts explaining by drawing the diagram of a distribution and now he takes ten samples from the distribution and starts plotting them. He says that in theory if we do it infinite times then we can obtain the sampling distribution of the sampling mean. For the example he takes the number of samples as 10. Now depending on these values of n we can get different sampling distributions. Now he intends to find the mean of t...

How To: Navigate Gmail like a pro

There are many tips and tricks on the best way to use your Gmail. In order to use the tips provided you will need to have the newest version of Firefox or Google Chrome for them to work. There are three tips that can help you maximize your Gmail funtionalities and help you save time.

How To: Do basic statistical analysis in Microsoft Excel

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 to do basic statistical analysis in Excel. Specifically, this video covers the following topics:

How To: Understand mean and standard deviation

Keith M. Bower explains the meaning of mean and standard deviation. This educational video gives insight in the basics of statistics. The relations between population mean and sample mean and between population standard deviation and sample standard deviation are explained. The mean gives an idea on the central tendency. Standard deviation gives an idea about how spread out the data are. Keith also explains how these two parameters, the joint sufficient statistics, define a normal distributio...

How To: Make a miniature baby bottle

In order to make a miniature baby doll bottle to be used in a dollhouse, you will need the following: orange paint, white paint, a paintbrush, and a light bulb from a string of white Christmas lights. The light bulb must be a standard light bulb. It can't be a replacement bulb, because it needs to be clear. The wires do not need to be removed.

How To: Install an exhaust on a Ford F150

In this Autos, Motorcycles & Planes video tutorial you will learn how to install a Borla exhaust on a Ford F150. For this you will need a 15mm and a 10mm wrench, a 15mm deep socket, a 10mm standard socket, a ratchet, safety goggles and work gloves. First remove the spare tire and the heat shield. Using the 15mm wrench loosen the nut on the clamp on the muffler. Unbolt the hangers from the vehicle and remove the kit by turning it counterclockwise. Next put the new exhaust in place, take the sh...

How To: Add conditional formatting to data bars/icons in Excel

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 21st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to add conditional formatting to data bars and icons to show relative size, icons to show relative size, to highlight values within 1 standard deviation, to highli...

Prev Page