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.
Scientific Validation Search Results
How To: Look up formulas in Excel with the CHOOSE function
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 557th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHOOSE function look up a formula or function depending on your drop-down selection. See also how to create combo box form controls and data validation lists with the VLOOKUP function.
How To: Perform 10 awesome science magic party tricks
The best part of science class for many was the awesome demonstrations and experiments teachers use to demonstrate scientific principles. This video will teach you how to capture some of that magic by performing ten awesome science party / magic tricks, like relighting a match with smoke and rolling a can around on it's rim.
How To: Make a point contact transistor with germanium and phosphor bronze contacts
The transistor has changed the world since 1947, and the old point contact transistor isn't the scientific darling it's always been. It's still vital to the modern world though, and in this video you'll learn how to make your own point contact transistor with germanium and phosphor bronze contacts.
How To: Make a model of a space comet
Are you an active or aspiring scientist? In this free educational video from National High Magnetic Field Laboratory, learn how to make a model of a comet, and why models are important to scientists. Get started on a scientific road to discovery with help from this excellent video on how to make a model of a space comet.
How To: Enter Excel data into cells with drop down menus
In this video tutorial, viewers learn how to create drop down menus in Microsoft Excel. This task is very easy, fast and easy to do. Begin by highlighting a desired cell. Then click on the Data tab and click on Data Validation under Data Tools. When the Data Validates window opens, click on the Error tab and deselect "Show error alert after invalid data is entered". Then click on OK. Now simply type in the data into the selected cell. This video will benefit those viewers who use Microsoft Ex...
How To: Run a chart lookup with defined names 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 637th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a dynamic two data series line chart for blood pressures — how to look up a chart using defined names, a data validation list, and a formula using the INDIRECT function inside a picture of a chart.
How To: Keep track of projects with a Gantt chart 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 626th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Gantt Chart to show the amount of time a project takes during a day.
How To: Validate data & look up 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 5th installment in their series of digital spreadsheet magic tricks, you'll learn how to name a cell range, use data validation to add a drop-down list, and how to use the VLOOKUP function to look up values.
How To: Create a dynamic weekly chart 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.
How To: Change the operator in formula from drop-down in Excel
In this Excel magic trick video the tutor shows how to change operator in a formula from a drop down using Choose function. He shows a basic work book which can be downloaded from the internet for hands-on to the tutorial. In this trick the tutor shows how to include some operators in a drop down box of a cell and based on this drop down value change the operators in equations that are using this cell there by dynamically altering the equation and the value produced using the equation. For th...
How To: Use IF Statements in Visual Basic 2005 & 2008
In this Visual Basic tutorial, you'll learn to use conditional statements for the push-button validation of a designated text string. The code used in this example is as follows:
How To: Pass info from one page to another with a query string
In this video tutorial, Chris Pels will show how information can be passed from one page to another using a query string. First, see how to construct a query string including variable names and values from information on a data entry form. Next, see how to access the query string information when the page is posted including how multiple query string variables are handled. As part of the server side processing of query string information, see how to implement validation for existence of query...
How To: Perform various candle tricks based on scientific techniques
Here are some simple and fun tricks you can do at home with candles to astound and impress your friends and family. Create an extinguisher using baking soda and vinegar, use smoke to relight a candle and create a vacuum using a candle.
How To: Make an electroscope for static electricty experiments
In this video, learn how to make your own homemade electroscope. An electroscope is an early scientific instrument that is used to detect the presence and magnitude of electric charge on a body and for static electricity experiments. They are easy to make. This electroscope is made from a binder clip and two sheets of plastic (or overhead transparency film), and scissors.
How To: Read electrical resistor color codes
This video describes Resistor Color Codes and how to read them. It relates Resistor Color Codes to scientific numbers and engineering notation.
How To: Make an overhead water bottle rocket launcher
A (harmless) explosion a day keeps the police away. Indulge your rambunctious little boy in some scientific fun by helping him build an overhead water rocket launcher, which shoots recycled plastic bottles.
How To: Collect antique binoculars
This is a short video about collecting old or antique binoculars. This binocular video is helpful if you are interested in buying, selling, collecting or just learning about these old scientific instruments. This can help with all kinds of binoculars like Ross, Barr and Stroud, prismatic, or Galilean types.
SQL Injection 101: Common Defense Methods Hackers Should Be Aware Of
Database technology has vastly improved the way we handle vast amounts of data, and almost every modern application utilizes it in one way or another. But the widespread use of databases naturally invites a slew of vulnerabilities and attacks to occur. SQL injection has been around for awhile, and as such, there are many defense methods in place to safeguard against these types of attacks.
How To: The history and technology of batteries
Learn about the history and technology of batteries in this informative video, and learn how to make your own voltaic cells at home, along with other scientific experiments. Jeri Ellsworth demonstrates how and provides several informative facts about the history and technology about the battery.
How To: Impress people during the holidays with scientific tricks
Magically get a hardboiled egg into (and out of) a bottle, make a star using toothpicks and challenge someone in a brain teaser using wooden matches. Mr. G demonstrates how in this video tutorial and, for all the eager students whose brains are brimming with curiosity, explains the science behind it all.
How To: Jailbreak a PS3 using a TI-84 calculator
Not only can you jailbreak your PS3, you can do it just by using a TI-84 silver edition scientific calculator! You'll need to download a simple app first, and this will certainly void your PS3 warranty, but if that's okay with you, here's how to do it!
How To: Measure cooking ingredients
Learn how to measure cooking ingredients. Some home cooks approach cooking as an art form, a splash of this, a dash of that, and soon each culinary creation is deliciously unique. Bakers are more likely to appreciate the scientific side of cooking, relying on the careful measuring of ingredients to ensure consistent results every time they prepare a recipe. To measure cooking ingredients, you'll need a glass measuring cup for liquids, and a dry measure for powders.
How To: Create a color explosion with this cool science experiement
Soap is an incredible thing and this how-to shows some of its incredible qualities. You'll need a plate, some whole mile, some food coloring, some Q-tips and some dish detergent. It's an explosion of color! Some very unusual things happen when you mix a little milk, food coloring, and a drop of liquid soap. Use the experiment to amaze your friends and uncover the scientific secrets of soap.
How To: Master weight and balance concepts with NASA
Join NASA (National Aeronautics and Space Administration) as they give the basics on the concepts of weight and balance as applied to aerospace. There's no better place to learn about aviation theory than NASA, the United States government's most infamous agency--the powerhouse of space exploration.
How To: Determine enthalpy in the hydration of MgSO4
C For Chemistry delves into the chemistry of science experiments. This chemist knows what he's talking about. These chemistry experiments are not only fun, but very educational for all of those interested in scientific chemical reactions and properties.
How To: Determine math proportions with the Square-Cube Law
Ever watch a cheesy movie and say "That monster is so FAKE!" but not really understand why? Well monstrous monsters are governed by a little biological rule called the Square-Cube Law, a scientific term combining math, anatomy and physics into one educational tool to recognize theatrical baloney when you see it. Just watch this video to see the explanation of the Cube-Square Rule, how it works and its ramifications for our favorite B-Movie pet monsters.
How To: Illustrate the scientific idea of conservation of mass
Try out this science experiment... watch this video tutorial to learn how to illustrate the scientific concept of conservation of mass. This is purely educational, and not as exciting as some other demonstrations, but this does clearly illustrate the concept of conservation of mass.
How To: Understand the Mayan calendar
Dovid Krafchow, the author of Kabbalistic Tarot, explains the meaning behind the Mayan calendar according to Jewish knowledge and scientific investigation. Check out this video to learn how to understand the Mayan calendar.
How To: Get liquid from a bowl into a glass with just a candle
This is an amazing, scientific, rise effect with just a candle, a cup, and a Coke. Anybody can do it, so why not?
How To: There's a Hidden Scientific Calculator on Your iPhone
The Calculator app on your iPhone may seem boring and basic, but there are a few interesting tricks worth knowing. You can ask Siri to perform calculations for you, long-press on results to copy them, long-press the field to paste numbers in, and swipe left or right above the keypad to delete digits one by one. The app can also be used as a scientific calculator with just a simple maneuver.
How To: Evaluate factorials with a TI-83 calculator
The factorial of a number n can be defined as the product of all positive integers that are greater than 0 but less than or equal to n.
How To: Do three exercise moves to firm your butt
Every gal has her trouble areas, but it seems that most girls cite their belly and butt as the hardest areas to tone. After all, scientific studies have shown that these areas are the first place to gain weight and the last place that gets smaller when you're exercising to lose weight. Sad but true facts.
How To: Do a flaming ice experiment
In this fascinating "how to" video, you will see how a simple process creates the illusion of ice that is burning. Only a few items are needed to enact this scientific experiment. As the narrator describes, "Calcium carbide reacts with water to form acetylene gas." To illustrate, the video shows a bowl of ice cubes, to which the special ingredient is added. As the ice melts into water, it reacts with the calcium carbide, forming the high flammable acetylene gas, which is often used in welding...
How To: Do three balloon science experiments
This video describes how to perform a three balloon science experiment which is a good way for children to learn scientific principles and could make a good science project for school. In this video one will learn key elements of each project and the logic behind the fun. For example in the first experiment one learns about air pressure and how changes from hot to cold cause amazing effects. Overall this video is simple and useful for anyone who would like to teach, entertain or help children...
How To: Dissect a human to see the nasal cavity and sinuses
In this human anatomy video tutorial, you learn how to dissect a human cadaver to get a better look at the nasal cavity and sinuses. You'll see the paranasal, which is alongside or near the nose, and the paranasal sinuses are the mucosa-lined air cavities in the bones of the skull, communicating with the nasal cavity.
How To: Create a non-Newtonian fluid
On this episode of Scientific Tuesdays, Dylan shows you how to create a non-Newtonian fluid using corn starch and a little water. A non-Newtonian fluid is any fluid that does not follow the laws of physics.
How To: Fold a prize-winning origami SST paper airplane
To make this origami SST paper airplane, begin with a square. The origami SST (supersonic transport) was designed by Dr. James Sakota. The plane was first featured in the 1960's book The Great International Paper Airplane Book, a documentation of the Scientific American first International Paper Airplane Competition. It won first place for origami/nonprofessional. This plane flies excellently in a fast, long distance glide! Learn how to make the origami SST paper airplane by watching this ins...
How To: Understand Ruby on Rails fundamentals for programming
This is an intensive one-day overview video tutorial of the fundamental concepts of the Ruby on Rails Web programming framework, presented by the UC Berkeley RAD Lab. The overview consists of six sections of approximately one hour each. Click through the video chapters to go through the Ruby on Rails programming course.
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...