Extensive Range Search Results

How To: Program methods in Python

Bucky from The New Boston serves up this Python video tutorial on how to program methods in Python. This is the program you use to write all of your Python code down. Fun with methods! Learn what methods are and how to use them.

How To: Track the Super Storm Hurricane Sandy Live

As Hurricane Sandy barrels towards the East Coast, 50 million people are expected to be affected in the nation's most populated corridor. The behemoth super storm is a cause for concern, evident by the massive evacuations. The picture above is an eerie snap of the mostly crowded Times Square subway station in New York. Government officials have warned over half a million people to evacuate their homes and head to higher grounds. To help prepare for this storm, the internet has provided severa...

How To: Make an Excel dynamic named range across multiple rows

Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added information. Ctrl + F3 is the name manager shortcut and the F3 is the paste name shortcut. Use the name manager and highlight the named range. Delete the absolute cell references and type in offset. Then, select the fir...

How To: Find range and interquartile range in Microsoft Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 40th installment in his "Excel Statistics" series of free video lessons, you'll learn how to calculate range & interquartile range for variability using the MAX, MIN, QUARTILE functions.

How to Train Your Python: Part 1, Introduction

Recently I've been looking around our wonderful community and I've seen some absolutely hands-down fantastic python scripting articles. But, in the end, these series weren't very extensive. I've been wanting to do a series on teaching python for a while now, and I don't mean just the basics, I mean to make an extensive series that takes it all the way from "Hello, World!" to popular third party modules, and everything in between!

How To: Make Your Xbox 360 Games Region Free

You've had your Xbox 360 for a few years now and your game collection is pretty extensive. Maybe it's not that extensive, but it's still substantial. Now imagine that you live in Europe and you're moving to the United States. I don't know why—maybe your dad got a job offer. Don't ask me, ask your parents. They're the ones that are making you move. Anyways, as most Xbox users know, games are coded by region. Games that work in Europe might not work in the United States. Does this mean you shou...

How To: Solve word problems involving domain and range

See how to find the domain and range of a function implied by a word problem with this free video math lesson. 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 tutor...

How To: Turn a range of cells upside down 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 and Mr. Excel, the 10th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to invert a range (turn a range of cells upside down) with two different INDEX formulas.

How To: Apply names to formulas & replace cell ranges in 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 226th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply names to formulas and replace existing cell ranges as well as how to name ranges from selections.

How To: Return the needle settings on a HBI 21BB engine

In this video tutorial, viewers learn how to return the base settings on a HPI 21BB engine. The engine has 3 needles carburetor: high speed, mid-range and low speed. Begin by turning the high speed needle clockwise until it is closed. Then turn it 3 1/2 turn counterclockwise. Then turn the mid-range needle clockwise until it is closed. Then turn it 3 1/4 turn counterclockwise. When adjusting the low range, make sure to hold the mid-rang with a screwdriver to prevent it from turning. Now turn ...

How To: Measure current, voltage, resistance, and continuity using a multimeter

If you own or have access to an auto-ranging or manual-ranging multimeter you can measure several different aspects of circuits, resistors, and the like. For example, you can determine the resistance, voltage, continuity, and current with the multimeter to help you determine the precision of a resistor. This guide will help you learn how to use a multimeter to perform these tasks.

How To: Increase the range of a USB Bluetooth adapter with a high performance antenna

Watch this amazing USB Bluetooth adapter hack from Kipkay. It's easy and effective, plus it will work with other wireless devices, too. Bluetooth works on a 2.4GHz short wavelength radio frequency, but it's only effective over short distances. Well, Kipkay's going to show you how to increase the range by swapping out the antenna in the bluetooth adapter with a HyperGain 2.4GHz high performance antenna.

How To: Remedy potential earthquake hazards in the workplace

Washington State has a history of large earthquakes, as does California. More than 1,000 earthquakes are registered in Washington State each year. More than 10,000 are recorded in California each year. In an earthquake, non-structural elements, which is anything that does not actually hold the building up, may become unhooked, dislodged, thrown about, and tipped over. this can cause extensive damage, interruption of operation, injury and even death.

How To: Sort a range in Excel

Using Excel, sorting large or small pools of data has never been easier. In this Excel tutorial, learn how to sort a range of data in Excel and what steps to do so, from start to finish. Sort totals, percentages, or decimals in a range in descending or acsending order with help from this video.

How To: Select cells in a spreadsheet using hot keys in Excel

This video is an Excel magic trick which shows how to select cells in Excel through keyboard shortcuts. He starts by the basics where he shows how to select a range of cells in excel work book. He shows how to jump to the top and bottom of the selection area. He even shows how to use shift key to select the whole range. Finally he shows how to hold control, shift and click to select the whole ranges. He even shows how to select ranges top to bottom and from left to right. This video shows how...

How To: Sing high notes

Check out this instructional voice lesson that shows you how to sing high notes! This is a video for those who want to learn to sing in a higher range. This information has worked with the instructor since she started singing higher-ranged songs and hopes it does the same for you! Improve your vocal abilities by watching this voice tutorial and practice singing higher range notes!

How To: Find the median & inter-quartile range

This video shows us the method to find the median and the inter-quartile range. The first step involves the arrangement of the numbers in the ascending order. Median is the middle number. The middle number is the number at (number of numbers + 1)/2 if the number of numbers is odd or the (number of number)/2 if the number of numbers is even. In the example the number is located at [(11+1)/2] or the 6th number. The inter-quartile range is higher quartile - lower quartile. The higher quartile is...

How To: Make a dynamic named range in Excel (left to right)

Teach Excel describes how to create a dynamically updating named range that goes from left to right using Excel. First, you define the named range by highlighting the cells containing numbers in a certain row. In the name box to the left of the formula bar, type the name of the data. In this example, the numbers correspond to sales, so type "sales." To check if the named range works, click on an empty cell and enter =sum(sales). That should return the sum of the highlighted cells. However, as...

How To: Use the preview range in CINEMA 4D

If you use After Effects you have become familiar with the Work Area, a range of time that allows you to focus on a specific range of time. You can work exclusively in this area, or work in the larger time of the composition, only to preview or render that area of time when you go out to final. In CINEMA 4D, users can achieve similar results using the Preview Range. This tutorial will show you how.