Btus Range Search Results

How To: The Trick to Keeping Your Home Warm During Winter for Cheap

When temperatures drop and hit new lows during the cold, winter months, it's hard not to crank the heat up. That means increased energy bills each month, no matter if you rely on gas, electric, or another fuel for heating.

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: 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: 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: 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: 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: Practice mid range game with Sam Cassell

Sam Cassell teaches you how to master your mid range shooting by creating space from your dribble and posting up, and lastly how to shoot a clutch jumper. These are NBA Fundamentals from TNT. These skill drills and tips will help you win in the mid range game.

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: Accurately fire cannons in the game Minecraft

This tutorial shows you how to easily find an accurate range for your cannons when you're playing Minecraft. Calibrate your cannons just so, to make sure you score a hit every time you fire them. Works with short range and long range cannons both.

How To: Create an in-cell dropdown menu in Excel 2003

1. Select the cell for which the dropdown menu is to be applied. 2. once the cell is selected goto DATA menu select VALIDATION.Data validation dialog box will be displayed.

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: Do passive range of motion on a patient in nursing

Studying to be a nurse? Then here is a nursing how-to video that teaches you how to do passive range of motion a patient. Every nurse should know the basics of this technique, follow along and see how easy it is to to exercise a bed ridden patient with passive range of motion. These medical tips are sure to help you pass your nursing exam with flying colors.

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

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 SUMIF & SUMPRODUCT functions in MS 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 315th installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use the SUMIF & SUMPRODUCT functions.

How To: Build a remote control with a two mile range for your digital camera

A remote control for a camera? Why not! You won't have to worry about racing the timer function any more! Build a remote control for your digital camera that will take the picture whenever you want. The range is as far as two miles!

How To: Create high-dynamic range images in MAXON Cinema 4D

This tutorial presents a lesson in generating high-dynamic range images (HDRI) within MAXON C4D. Whether you're new to MAXON's popular 3D modeling application or are just looking to get better acquainted with Cinema 4D and its various features and functions, you're sure to enjoy this free video software tutorial. For more information, including complete instructions, watch this 3D modeler's guide.

How To: Count the number of characters in an Excel cell range

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 9th installment in his series of Excel array formula series, you'll learn create array formula that counts all the characters in a range of cells.

How To: Use dynamic range names in Excel 2007 tables

Looking for a primer on how to create and work with names 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 12th installment in his series of Excel name tricks, you'll learn how to use the built-in dynamic range names in Excel 2007 Tables.

How To: Name cell ranges with relative references in MS Excel

Looking for a primer on how to create and work with names 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 name tricks, you'll learn how to name cell ranges with relative cell references instead of the default absolute cell references.

How To: Invert a range of values 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 307th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX, ROWS, COLUMNS, LARGE, SMALL functions to create 4 different formulas that will invert a range of values.

How To: Increase the dynamic range of the Canon 5D and 7D

This is an excellent video showing you how to open up the dynamic range of your Canon DSLR camera in order to see into the highlights and shadows better. By giving you a flatter image, you have more ability to manipulate the image in post-production, having lost less available information.

How To: Use the sparkline function in Microsoft Excel 2010

There is a new function in MS Excel 2010 called ‘Sparkline’ which helps you quickly find trends associated with a set of data. To create Sparkline, you can go to ‘Insert’ tab and then select ‘Sparkline’ section and then select the graph type. After you enter the data range and location range, the Sparkline will show up indicating the trend based on the data range you identified earlier. You can change the types and styles of your Sparkline easily. As the video demonstrates, whenever you use E...

How To: Make a paper blowgun with a 50 foot range

Training to be a deadly assassin? Why not practice on something a little less dangerous, and make a homemade paper blowgun to begin with? In this two-part video tutorial, learn how to make a sturdy paper blowgun that shoots steel-top darts, and can shoot up to fifty feet. To make this paper weaponry, you will need: An old school notebook, scissors, tape, a hot glue gun, a soda bottle, and 2 paper clips.

How To: Use ranging rook tactics on the chess-like game Shogi

Do you like chess? How about Japanese chess? Aren't there different chess variants in Japan though? Maybe, but this specific chess variant is called Shogi. The chess-like game Shogi is won by capturing the king, just like chess, but defeat is conceded at mate, or when mate becomes unavoidable.

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: Figure out the domain & range of a piecewise function

Need to calculate the domain and range of a graphed piecewise function? Learn how with this free video 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).

How To: Use a written cell range in a function 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 252nd installment in their series of digital spreadsheet magic tricks, you'll learn how to use a cell range typed into a cell in a function.

How To: Measure dispersion with range, variance & std dev

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 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 use statistical range, variance and standard deviation to measure dispersion in a data set.

How To: Read the histogram on a digital camera

Ever wonder what those bars and lines on the LCD screen on your digital camera do? In this great tutorial, Ethan Wilding demonstrates how to read one of the most useful features on your camera: the histogram.

How To: Increase the range of a remote control

Kipkay shows you how to increase the range of your remote control for your television. You use electrical tape to make sure that the leads do not come into contact with the reflector.

How To: Increase the WiFi range of your jailbroken iDevice

Check out this video guide to WiFiFoFum, an app available through Cydia that will extend the WiFi range of your iPhone, iPod Touch, or iPad. If you have a jailbroken iDevice and you want to be able to use it in more places, watch this video.

How To: Become a better player in Call of Duty: Black Ops multiplayer on Firing Range

This video goes in depth in to the map Firing Range on Call of Duty: Black Ops multiplayer mode. Maximize your strategy and master your tactics when you use this map, probably second in popularity only to the Nuketown map.

How To: Set your GE range for self clean

Nowadays, most ranges come equipped with a self clean option. This is great for those who don't have the necessary time need to clean their appliance or have any kind of health problems.

How To: Fix a range burner on your GE cooktop

If you're range burner isn't working properly, there may be a number of reasons for this. One of the most obvious and easiest problems to take care of, is that it might be clogged. Overflowing liquids and other food materials can get into the burners and cause them to become clogged. This leads to an insufficient working burner that needs to be fixed soon.

How To: Copy an Excel formula through a range via the keyboard

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 630th installment in their series of digital spreadsheet magic tricks, you'll learn how to copy formula through a huge range using keyboard shortcuts.

Prev Page