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 697th installment in their series of digital spreadsheet magic tricks, you'll learn how to allocate $950 across 7 days including the extra penny with a single formula.
Avenged Sevenfold has been one of the biggest rock bands in the world for a long time, but their most recent single "Nightmare" might be their biggest hit yet. It's a beautiful, haunting song, and like much of A7X's work it translates well to some furious piano playing. This video will show you how to play the song on piano or keyboard in the simplest terms possible, but it's a hard song if you are new to piano you might want to look elsewhere.
If you're interested in writing pop songs these days, you pretty much have to know how to create a sick beat on your computer. What better way to practice than replicating the beat of a popular song and learning it's tricks? This video will teach you how to make the beat to the Nicki Minaj hit single "Your Love" using Sony ACID. Watch and learn!
If you've seen Sin City, what you probably remember most is the way color isolation was used throughout the film to reveal single colors in otherwise black-and-white scenes. This video will show you how to create the same effect for your own film in After Effects. Using this beautiful bunch of roses an an example, you will learn how to apply color isolation to film and maybe, just maybe, give Robert Rodriguez a run for his money.
In this tutorial, learn all about how to use a Barnes and Noble Nook e-reader from top to bottom. This helpful clip will walk you through every single feature so that you will be reading wirelessly in no time. Not only is the Nook easy to use and carry around, it is also inexpensive (as of June 2010), why not give it a try?
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 618th installment in their series of digital spreadsheet magic tricks, you'll learn about a handy key command that will allow you to enter both today's time and date into a single Excel cell.
In this video tutorial, find out how to copy and paste HTML links embedded in the text with a breeze. No longer will you have to worry about re-entering every single link one by one. This video will give you a quick and easy solution to solving your most worrisome problem. Enjoy!
Are you in college? Too lazy to make a proper meal? Too cheap or poor to go out to dinner? But, still have that sophisticated pallet, this video will show you exactly how to eat like you deserve and make yummy super cheesy stuffed burgers to enjoy any night of week. Don't be afraid to enter the kitchen, after watching this video you'll be eager to have dinner guest.
Are you in college? Too lazy to make a proper meal? Too cheap or poor to go out to dinner? But, still have that sophisticated pallet, this video will show you exactly how to eat like a king and make a perfectly juicy meatloaf to enjoy any night of week. Don't be afraid to enter the kitchen after watching this video you'll be eager to have dinner guest.
We don't know about you, but making selections around oddly shaped areas of an image is one of the most frustrating single tasks in Photoshop. Odd shapes are really hard to navigate around by hand and often you can't get a perfect cut. Luckily, this Photoshop tutorial will guide you through how to make complex selections easily in Adobe Photoshop CS5.
This is a very lengthy explanation on BTD playing. There's a lot to actually know about the strategy of Bloons Tower Defense.
This square dance video teaches the following plus level square dance calls: Track II, Single Circle to an Ocean Wave, Spin Chain the Gears.
This square dance video teaches the following square dance calls on the mainstream list: Cross Run, Left Swing Thru, Single Hinge, Separate, Trade By, Wheel & Deal (Lines of 4).
The following square dance video teaches these square dance calls: Defines Heads, Sides, Positions 1,2,3,4; Learn to Circle Left/Right, Do Sa Do, Forward & Back, Swing, Promenade, Promenade 1/2, Single File Promenade.
Couching is another easy embroidery stitch in hand embroidery, and a great way to create decorative line stitches that scroll and twirl about. It's also widely used for filling areas, and historically was used to great effect during the Middle Ages and Renaissance in a technique called Or Nue. Here's a video from Needle 'n Thread that demonstrates couching a single thread for an outline.
The BristleBot is a simple and tiny robot with an agenda. The ingredients? One toothbrush, a battery, and a pager motor. The result? Serious fun. The BristleBot is our take on the popular vibrobot, a simple category of robot that is controlled by a single vibrating (eccentric) motor.
Most of the time, when I’m bored during math class, I play with my calculator to satisfy my boredom. Recently, I've discovered that when multiplying any number by 11, 111, or any number similar to it, that it has a pattern (though I guess everything in math has a pattern). I don't know if this technique is original, because I didn't read anything about this. It's just mere observation. If it’s a tried and true technique, let me know.
In this two part segment, all of the eBook collectibles locations in Deus Ex: Human Revolution are revealed. Reading all 29 of the books in a single play through of the game allows you to unlock the 'Doctorate' achievement on the Xbox 360--so find those books and get to reading!
In this tutorial, we learn how to increase and decrease half double crochet. First, work a half double crochet in your stitches. Do this to create the first row, drawing through the loops and inside the first row. To increase a half double crochet, you will do the same thing as a single crochet, except you will skip on loop. Double crochet to the other end and then you will be ready to decrease. To do this, you will simply remove one of the crochet loops while you are crocheting and you are d...
If you're in gymnastics, you probably know what a Webster is, but for all you parkour and freerunners out there, a Webster is a type of acrobatic flip, sometimes referred to as a front aerial flip. This advance video tutorial will show you wannabe flipsters the correct way of performing a high Webster (or single Webster) off one leg, which is quite the feat if you can master it. Superstar Andrea Catozzi shows you his acrobat charm and wit. Be careful though!
Taylor Swift is one of the most talented and most beautiful musicians to grace the pop stage in quite some time. Her latest single "Mine" lives up to the legacy of her past hits by being insanely catchy and having really clever, deep lyrics. If you liked the makeup look she rocked in the music video, watch this. It will show you how to recreate that look yourself. No word on how to replicate the blonde guy though...
Every single Rihanna released these days is a hit, and "Distubia" is no exception. If you like the song and hip-hop dance, you've come to the right place. This video will show you how to do a dance to the song that is sexy, easy enough for beginners, and really cool.
Silent Hill might be the single scariest game of all time, and it has spawned many sequels and films of wide-ranging quality. If you like the games and want to cosplay as one of the sexy yet demonic nurses from Silent Hill 1 and the film, this video will teach you everything you need to know, from what fabric to get to the pattern and how to put it all together.
After 12 years Starcraft 2 is finally here to blow your mind. If you're looking for help with the game, you've come to the right place. We have tons of videos about how to do just about everything in the game. We have strategies for winning campaign and multiplayer games. We have guides to using the immensely powerful level editor. We'll even teach you how to build a Terran Barracks out of Legos. This video will show you how to get the Raynor's Back achievement in the first mission of the sin...
After 12 years Starcraft 2 is finally here to blow your mind. If you're looking for help with the game, you've come to the right place. We have tons of videos about how to do just about everything in the game. We have strategies for winning campaign and multiplayer games. We have guides to using the immensely powerful level editor. We'll even teach you how to build a Terran Barracks out of Legos. This video will show you how to unlock and beat the secret level in Starcraft 2's campaign mode, ...
After 12 years Starcraft 2 is finally here to blow your mind. If you're looking for help with the game, you've come to the right place. We have tons of videos about how to do just about everything in the game. We have strategies for winning campaign and multiplayer games. We have guides to using the immensely powerful level editor. We'll even teach you how to build a Terran Barracks out of Legos. This video will show you how to beat mission 8: Welcome to the Jungle in the single-player campai...
What's so fun - and risque - about Katy Perry is that she makes as big a fashion statement with her clothes on as she does with her clothes off. Recently, the chanteuse has been engaging in lots of photo shoots and music videos in which she's worn little more than her charming smile and a wildly colored blue or purple wig.
Are you 90% done with your lace shawl but have no idea how to finish the edges so they look rounded, complete, and not raggedy? Then a tubular cast-on may be just what you need to finish up the hems of your project in a professional manner.
If all guitarists did was play chords with a single strum or individually pick notes, the music industry - and guitar music - would be dead as we know it. Some of our favorite songs, both past and present, are so memorable because they vary the articulation of notes on the guitar. This means that rather than boringly stick with the same strumming pattern they include cool sounding tricks like pull-offs and hammer-ons.
Making paper bangers / poppers is one of the most fun and annoying (to others) things that you can do with a single sheet of paper. This video will show you how to make one in very copious detail by the standards of other paper bomb videos. It may take some practice to get the banging motion right, but once you do this little banger will be very loud. It's also reusable, so you can use the same one to annoy people for weeks! Or until someone rips it. But then you can just make another one!
American Apparel is famous for selling articles of clothing that can be worn in multiple ways. Their latest creation is the Le Sac dress. This dress can be tied and twisted all over the place to come up with TWELVE or more styles! You can wear this outfit every single day and everyone would think you were in something new. So, if you are looking for a sexy, Greek-inspired off the shoulder look, check this official tutorial out for the Grecian look. Learn how to wear your Sac and look amazing.
There are a lot of different kinds of locks, and you need different easily accessible household material to pick different kinds. This video focuses on teaching you to pick a padlock, familiar to any who have ever had a locker, with a soda can, something you probably have too many of if you still have a locker. You will make a shim out of the can and then use that to open the lock, either single or double-shackle. Get your history book back out of Jimmy Peterson's locker with the technique yo...
Arguably the single most important aspect to modeling is topology. This overview tutorial takes a look at the topology of the human head, examining each of the main edgeloops, poles, etc. 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 s...
Origami purists will argue that all origami creations, no matter how complex, should be folded from one single sheet of paper, but the rules were made to be broken, right? If you've already mastered the art of one-sheet origami projects like frogs and cranes, challenge yourself to this project: a tetrahedra composed of five intersecting pyramidal shapes.
Learn how to use the FOIL method to distribute two binomial expressions in algebra. The FOIL method — which stands for first, outer, inner, and last — takes two binomials and multiplies them for a single quadratic equation. Solving for binomials with FOIL takes just a few steps. Could you use a little help figuring out how to divide fractions? Watch this free video lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have b...
If you are looking for a bet that you are sure to win, check out this clip. In it, you will learn exactly how to bend a cigarette in half without breaking it! No one will believe you when you say you can crunch a cig so that both ends touch and still have an unbroken smokable cigarette.
The ancient art of Japanese paper folding is broken down and explained clearly in this video. The video teaches how to create a beautiful bookmark of your own design from a simple single sheet of paper. The instructions use the square base as a jumping off point for showing you how to easily make a custom book mark. There are a few simple beginning steps, and after you complete those you will be able to fold and crease your way to a gorgeous custom origami book mark.
Welcome to a tennis lesson from FuzzyYellowBalls, the the best place to learn how to play tennis online. Our free video tennis lessons teach you how to play the game in a new way that combines technical analysis, visual learning, and step-by-step progressions.
Imagine that every time you print a document, it automatically includes a secret code that could be used to identify the printer -- and, potentially, the person who used it. Sounds like something from a spy movie, right?
To get the Guerilla Tactics achievement / trophy in Bulletstorm, you must execute 25 skillshots in a single Echoes map. Skillshots are the most fun part Bulletstorm. This video will give you a handy step-by-step guide to getting the achievement in Collapsed Building.