Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using nested IF functions to calculate a grade from an average mark. For more information on using conditional statements, watch this MS Excel how-to.
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:
Watch this video to learn how to use the switch statement in C++.
This C++ programming tutorial goes through loops, switch statements, if else statements and applying them to another fairly simple program that creates a calculator.
A C# (C sharp) programming tutorial on creating if, else, and elseif statements as well as boolean tests.
I'm back! We're learning Java WhileLoops today.
Lady Gaga is known for her outrageous looks and everything she wears makes a statement. Perhaps her biggest statement of all is her video screen sunglasses. Gaga wears these glasses often and now you can make your own! Best of all, this look can be completed for about 20 bucks!
This moped maintenance tutorial shows you how to check the valve gap on a Honda Ruckus scooter. If you need to do a gap check on a Ruckus watch this video and then go check your scooter valves.
In this Business & Money video tutorial you will learn how to read a balance sheet in accounting. Yu can learn to read it quickly and easily as to where the company’s came from, where it went and where it is now. There are four main financial statements; balance sheets, income statements, cash flow statements and statements of shareholder equity. In the balance sheet, under assets are listed things that the company owns that have value. Liabilities are amounts of money company owes to other...
This quick little video teaches you about the switch statement and ternary operator for use with your PHP programming. It's quick so you may want to take notes to ensure it's all sticking in your gray matter hard drive. Go!
In this tutorial, we learn how to do a cohesive personal statement. If you are a student and need to write your personal statement, get started on it early so you have a while to work on it! Start out by working backwards, which means to start with your life now and then building up to how you plan to achieve further goals. You need to make sure this is short and you also need to make sure you don't brag about yourself. If you are wanting to travel abroad, make yourself stand out from other p...
Learn to program If & Switch Statements in Java. This tutorial uses Java 1.6 with NetBeans 5.5.1 beta
Welcome back, my greenhorn hackers! I recently began a series on scripting and have received such positive feedback that I'm going to keep this series going. As I've said before, to graduate from the script kiddie to the pro hacker, you'll need to have some scripting skills. The better you are at scripting, the more advanced your hacking. Ultimately, we are leading up to developing the skills to build your own zero day exploits.
In this video we learn how to write a personal statement to finish your application. This should not be a listing of all your qualities, it should be a story. This should have a lot of information about yourself to show how great you are. Write about anything that makes you different and focus on a strength you have. Think about everything you do outside of the classroom and be honest, because these people don't know you. Write with your heart and don't brag about yourself. Think about your a...
As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the very first installment in his "Beauty of Excel" series of free video lessons, you'll learn how to create a contribution margin income statement across various units sold.
In this "Math Made Easy" geometry episode, you learn how to prove that two triangles are congruent (equal) by using the "side-side-side" evidence. By using "side-side-side" to prove that two triangles are congruent, you are stating that all the respective corresponding sides of two triangles are equal in length thus proving the triangles are congruent. The narrator in this tutorial provides you with definitions about statements, proofs, and congruency. This becomes useful when setting up a ta...
Tim Carter demonstrates how to get professional painting results by caulking all cracks between woodwork and walls before painting.
A potholder loom is a square-shaped loom that allows you to weave thickly woven fabric, but often if you're not careful you can create gaps in between the yarn. But that problem will be completely solved in this video, in which you'll learn how to bypass the gaps. The result will be a basket weave-type fabric that's thick yet lightweight enough for summer scarves.
Stay tuned for this knitting instructional video on how to turn a heel when making a knitted sock. This knitting process is a lot less mystifying after you've done it once. (Isn't everything?)
Learn how to easily gap a spark plug for a car,truck,ATV, motorcycle, lawnmower or pretty much any vehicle. This tutorial will show you hoe easy it is to do.
Learn some more advanced formula uses in Microsoft Excel including the "IF" statement. For example, "IF someone earned over $200 then charge them $20... otherwise charge them $40."
In this video we learn how to tie a half Windsor knot. First, bring the tie around your neck and position the small side by your belt. Next, bring the big side over the little side, then bring it underneath the little side. After this, take the big side through the gap on the right side only. Take the big side back over the top of the little side and bring the big side through the gap once again. During this, make a little hole with your right hand and tuck the big side into this hole. Push t...
In this tutorial, we learn how to say "I have brown hair" & other statements in Hindi. First, learn the basic body parts in Hindi. For example, "I have brown hair" and "I have blue eyes" would translate to, "mere baal bhure hain" and "meri aankhein neeli hain". These sound a bit different when they are translated into English, but that is the proper way to say them in Hindi. Once you have learned how to say the basic body parts and keywords in Hindi, then you will be able to better have basic...
As a Zerg, you'll be facing Terran armies, time and time again. But how do you beat them? How do you beat a Mech unit? This video will give you some strategic advantages to defeating a Terran Mech army unit as a Zerg in StarCraft 2: Wings of Liberty. For the Zerg, positioning is your largest factor in winning a battle. Can you surround, flank, can you sneak in, can you drop on them? Any of those allow your shorter ranged troops to close the gap and get into range of your enemies troops faster...
In this tutorial, we learn how to speak English with conditionals. Conditional statements need special attention and usually start with the word "if". An example of a conditional statement is "if you want, we'll go out to dinner". This has two parts, a condition, and a result. The condition is expressed by "if". To report them, don't change the verbs unless you're dealing with a real condition. Look and see if verb tenses can change depending on how the sentence is structured. Try to remember...
A thesis statement can be one of the most difficult parts when it comes to writing a paper. Not only can it be confusing, but it can drive a person mad! Okay well not mad, but it can certainly casue some people to get a tad bit irritated. So to avoid that negative feeling, watch this tutorial on how to write one. You'll thank us by writing your own paper about how we are so cool!
In this video tutorial, viewers learn how to improvise on the guitar. This video lesson will cover how you can make a study of the fretboard layout of notes and then move on to applying scale patterns on top of, "octave templates," to gain a better working knowledge of the guitar neck. Soloing skills have a lot to do with having a great connection between left and right hand techniques. This means that phrasing devices are of the utmost importance. Learning to phrase lines can help you achiev...
In this tutorial the instructor shows how to solve percent equations. The general form of a percent equations is that a is b% of c. As there can be three kinds of variables a, b, c, the questions involving percent equations can be of three types having one of the three variables unknown. These kind of percent statements can be solved easily by setting up an equation. So, to convert percent statement into a equation replace the unknown term with n, the 'is' term with equals sign and the '%' si...
The future perfect tense describes a situation which is finished in the future. This video tells us how we can use future perfect tense easily. It gives us a deep insight through the grammatical aspect of future perfect tense. It shows us how to use the helping verb i.e "will" with the third form of verb to form a statement in future perfect tense. the basic formula for making a correct statement in future perfect tense is "subject + helping verb + past participle (v3). It's easy to remember ...
In this video the author talks about the basic concepts in propositional logic, explaining how important this concept is to understanding the basic concept of logic. He says that propositional logic is also called "sentential logic" or "statement logic". He states that a proposition is synonymous to claim, statement or insertion. He states that propositional logic deals with logical relationships between propositions taken as wholes. He states that in proposition logic the proposition is deal...
Bucky from The New Boston serves up this Python video tutorial on how to program else and elif statements in Python. This is the program you use to write all of your Python code down. Else and elif (elseif)!
In this tutorial, we learn how to solder jump rings. This will give the rings more strength if you are doing a chain or a bracelet, and it won't break on thread. You will need a flame, wick candle with a number four tip, and something to light the torch. Start out by closing the gap in your jump ring until it's aligned and there is no gap left. Then light the fire for your solder and use it to cover over the jump ring. Once a few seconds have passed, you will be finished with the soldering of...
In this video tutorial, viewers learn how to tie a necktie. Begin by placing the tie around your neck, with the wider end 2 times lower than the narrow end. Then cross the wider end over and under the narrow end. Now bring the wide end through the V gap between the neck and . Wrap it once more over and under. This time, create a small loop. Bring the tie through the V gap and through the loop. Finish by tighten and adjusting the tie. This video will benefit those viewers who are attending a s...
In this Computers & Programming video tutorial you will learn how to intersect roofs on Google SketchUp house. This demonstration tutorial opens up a project where the building is already constructed and slanting roof is to be added. The building is in 'L' shape. Hence, the slanting roofs are in different directions and both have to intersect at one point on the center line. First the roof of the longer section of the house is made. Then that of the shorter section is made with a gap between ...
All around your house there small cracks and spaces that are letting air out of the house. You can stop the air leaks through an inexpensive way saving money from being wasted, it's called caulk. You have to select the right one for what you need, there are many different types for different applications so be sure to pick the right one. Clean the area you want to apply the caulk in and then put the caulk in the device with which you're going to use it. Push the plunger until it stops and cut...
This video describes the process of tuning a tattoo machine. The video starts by explaining the different parts of the tattoo gun. The presenter shows the different settings for the contact screw. For doing outlines the contact screw should have a gap the width of a dime. If you are filling a tattoo in with shading, then adjust the gap to the width of a nickel. The presenter then hooks up the tattoo gun to the power supply and adjusts the voltage to eight volts.
Have an old bike combination lock that you can't remember the code for? If it's a simply four-digit cable lock, you can easily figure out the combination with a quick peck-and-go method. Best of all, this technique doesn't require any tools or special know-how, and let's you reuse the cable lock again versus just damaging it with bolt cutters. All you need is a bit of patience and you'll have your figure out your combo in no time.
In this Business & Money video tutorial you will learn how to make a successful curriculum vitae or resume. This is the first step in getting your dream job. A well written CV captures the interest of the person who is reading it. Think yourself as a product and the CV is a piece of paper that is going to sell you. Don't be afraid to sell your skills and abilities. If you don't do it, nobody else is going to do it for you. First thing on top is to put your name; centered and bold. Then leave ...
In this video from FaceworksUK we learn how to get luscious full lips with exercises and no procedures. Make a pout with your lips so there is small gap between them. Push the pout outwards so both lips are extended as far as they can go equally. Keep pushing as far and as hard as you can. The focus point in the gap between your lips. Keep you lips slightly apart. Relax your lips. Make a pout and push out as far as it can and keep pushing out. Don't relax. Hold for 10. Now relax. Pout with th...
Are you getting a little tired of getting the same boring French manicure every single time at the salon? Then whip out that tin of rhinestones and crystals left over from your Halloween fairy costume makeup stash and get to work doing this beautiful crystal and rhienstone manicure!
