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 604th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a budgeted income statement that utilized mixed cell references.
Want to program your own Java games and applications but don't know beans about object-oriented programming? Never you fear. This free video tutorial from TheNewBoston will have you coding your own Java apps in no time flat. Specifically, this free discusses how to use if statements Java programming language. For more information, including detailed, step-by-step instructions, watch this helpful programmer's guide.
An English teacher shows some of the differences between the present tense and the present continuous tense in making statements, negatives, and questions. For ESL students. If you are learning to speak English, watch this video on present tense vs. present continuous tense.
Designing a data mapping project in MapForce? The output functions in MapForce let you preview textual or XML output, save it to disk, or look at SQL statements for database output before committing them to the database server. Learn how in this tutorial.
Eco...in this case also meaning 'economize' as we take an item that would normally have been thrown away & use it to make a cool fashion statement piece! This project is dedicated to the Green Guru Challenge and just uses household scraps headed for the trash, and turns them into a stylish bracelet. Learn how to craft this bejeweled cuff bracelet by watching this video jewelry-making tutorial.
AppleScript is quite an easy scripting language to use. In this guide, I will be showing you several commands. Near the end, I will show how these can be used to create a fake virus that actually does no harm.
It is often said that the best hackers remain unknown, and the greatest attacks are left undiscovered, but it's hard for an up-and-coming penetration tester or white hat to learn anything unless one of those factors is actually known or discovered. But the end goal here in our SQL injection lessons is to make that statement as true as possible for us when performing our hacks.
The Widowmaker boss in Resistance 3 is fairly intimidating. You'll need to properly locate her weak spots while avoiding getting destroyed by her acid. To beat the Widowmaker, you'll also need to move rapidly through the environment using cover and the zipline in the area. Use this boss fight guide to find out how to take her down.
Who doesn't like waffles? Waffles are actually fairly easy to make from scratch. To make waffle batter, you will need flour, sugar, baking powder, salt, oil or butter, milk, eggs and vanilla. And of course, a waffle iron and butter and syrup!
Including a teleporter scene in your science fiction movie? This tutorial shows you how to use a compositing effect so you can replicate the look of the Star Trek transporter. It's fairly easy - all you need are three separate, easy to work with layers.
Windows 7 is fairly similar to Mac OS X out of the box. But what if it's not similar enough for your tastes? Then you follow this free video guide, that's what: with its help, you'll learn how to use Snow Leopard-style file stacks on Microsoft Windows 7 desktop. For complete instructions, watch this tutorial.
Japanese manga characters often look fairly simple, but that simplicity make them surprisingly simple to draw correctly. When you have fewer details to work with, every little detail counts. In this video, "Miki Falls" manga creator Mark Crilley shows how to draw manga head shapes and facial features.
In this tutorial, you'll learn how to use the ancient Japanese art form of origami to make a butterfly. This is a fairly simple design that's good for beginners, taking only a few minutes to learn. But the results are impressive, making for an elegant decorative item or small gift.
One of the best features of Apple's Final Cut Studio is the graphics interface feature Motion. With its ability to create and edit motion graphics, you can easily create title sequences for your indie film, or maybe even a professional movie, with 2D or 3D visual effects compositing.
In this Houdini 9 video series, you will take a look at the new dynamics shelf tools and see how easy it is to create fairly complex simulations very quickly.
Make a statement when you pull out your iPhone with a shiny bedazzled case. Learn how to add a little bling, or a lot of bling, to your iPhone case. This can be done to any iPhone case, from iPhone 3gs to iPhone 4.
Besides crushed velvet clothing and accessories and anything with a lot of sparkly sequins, tribal jewelry is very in this holiday season. While it isn't necessarily as festive or as glitzy as the other fashion trends, it's uniquely, naturally beautiful and really makes a statement.
As you might guess, one of the domains in which Microsoft Excel really excels is finance 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 11th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate cash flow from assets, cash flow to creditors and cash flow to shareholders using accounting financial statements.
In this clip, you'll learn how to use "True" and "False" statements in your VB code. Whether you're new to Microsoft's popular event-driven program language & IDE or a seasoned developer merely looking to improve your chops, you're sure to find benefit in this free Visual Basic programming lesson. For more information, including a complete demonstration and detailed, step-by-step instructions, take a look.
In this free video language lesson, you'll learn how to turn a statement into a question in Japanese. With Japanese, as with any other language, a few key nouns and phrases (and knowing how to properly pronounce them) can go a long way. For more information, and to get started speaking Japanese yourself, watch this video tutorial.
If you've ever heard of a little artist named Banksy, you know that street art has the unique power of combining whimsy with sociopolitical commentary, all done with mind-blowing efficiency.
This video illustrate us how to tie an ascot. Here are the following steps:Step 1: Take a scarf and hang it around the neck so that it is parted into two equal halves.Step 2: Now take one end and move it towards the other.Step 3: Now bring this end under the first half of the scarf and taking it out from above ,this will form a loop like structure.Step 4: Now bring it out from the loop formed and pull the end downwards to form a knot.Step 5: Now move this knot sideways for a better fashion st...
Just because you're going to the beach doesn't mean you can't go in style. This video fashion design tutorial shows how to make a quick and easy bikini cover-up out of an old t-shirt with the help of Gianny L. The sexy GiannyL demonstrates this DIY closet hack that's simple and cheap. This bikini cover-up is an easy to put together, affordable summer fashion statement.
Whether you're making a punk fashion statement or you really need to cover up an embarrassing hole, sewing a patch on your favorite jeans is a project that you can get done in a snap.
Watch this video to learn how to use void functions with C++. The video also covers the use of more than one return statement, immediate return, and variable scope/visibility.
Today's word is "hyperbole". This is a noun which means an exaggerated statement.
This video shows you how to apply your natural food-based dye, set your dye, and remove your dye. Perfect for an arts and crafts project or a handmade fashion statement!
This video shows you how to make fabric dye using ingredients you can find in your kitchen. Perfect for an arts and crafts project or a handmade fashion statement!
This VB.Net tutorial demonstrates popup boxes with variable input as well as the 'If' statement
You can connect your Nintendo Wii Wiimote to your PC using GlovePie input emulation software and a bluetooth connection. Learn how to program conditionals - if, if/then, and if/else statements - in GlovePie.
Welcome back! In the last round of python training, we talked about tuples and dictionaries. We'll be diverging again and talking about logical operators as well as membership operators. These are used very similiar to booleans, so if you haven't read that, I suggest you do so first.
The Ornstein and Smough boss fight is fairly long, but if you're hoping to defeat the Dark Souls boss fight, you'll need to pull out all the tricks. The Dragon Slayer and Executioner are tough opponents, but this gameplay video should help you defeat them.
Let's face it, pro gamers make a ton of money, and that money is only increasing every year. If you're fairly good at Call of Duty: Black Ops and want to try your hand at the tournament scene, find out how to connect with other professional gamers and organizations and land become a pro Call of Duty player.
This is a great little rainy day project you can make for almost no money, or a fun party trick you can use at the next office Christmas party! You will need two disposable drinking cups (stiff plastic or paper will work best), a fairly thick straw, a sturdy paper clip, a thick rubber band, a cocktail stick, a bead and a plastic ring you can get from the neck of a soda bottle. Assemble as shown, and then let it go!
If you've got an Android phone, you may have wondered if there is a way to manually update your Android applications. There is and it's fairly easy to do. So easy, in fact, that this video guide from Butterscotch can present a complete, step-by-step overview of the process in just under two minutes. For complete instructions, and to get started updating the applications on your own Android phone, take a look.
This DIY guide focuses on pillowing ebony pegs, an adornment commonly found in Greene & Greene style furniture. Though it might seem like a daunting task, it's actually fairly straightforward. So straightforward, in fact, that this guide can presenta complete overview of the process in just over six and a half minutes' time. For complete instructions, and to get started making your own ebony plugs, take a look.
In this tutorial, you'll see how to create a fairly realistic-looking eyeball within Blender. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely on the lookout for new tips and tricks, you're sure to be well served by this free video software tutorial from the folks at CG Cookie. For more information, including step-by-step instructions, take a look!
In the old days, you needed a crank puller to get the crank off of your bike. This video demonstrates how to remove modern self-extracting cranks, that do not require a crank puller to remove, from a square tapered bracket. This is a fairly complicated piece of maintenance, so if you're new to biking you may want to leave this to the professionals.
In this very basic but informative tutorial, you'll learn how to build a follow focus for your Canon 5D Mark. This method has the virtue of being very cheap, using just a clamp, nuts and bolts, a bit of wire, a rubber band and some shrink wrap. But used well, you can probably achieve some fairly professional looking results with this rig.
The Centauri Knot works well with a wide range of line diameters and should regain around 90 percent of the lines breaking strength. The centauri knot is also fairly easy to tie and is therefor a popular choice by many anglers. The knot is ideal for small hooks, rings and swivels. Watch this video knot-tying tutorial and learn how to tie a centauri not for fishing.
