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 677th installment in their series of digital spreadsheet magic tricks, you'll learn how to average the last three scores eneterd for any Player using the functions: AVERAGE, IF, ROW, COUNTIF, MIN, LARGE.
What time is it? Time to fold yourself an adorable origami wrist watch! Though watches are now almost obsolete because we check the time via more recent innovations like the iPhone and our mp3 players, they're a fashion accessory that'll be around until the end of things.
Want to play "Mele Kalikamaka" (or "Pooka Shells") Hawaiian Christmas carol on your ukulele? See how it's done with this free video ukulele lesson, which presents a complete breakdown of the song and it chords. While this tutorial is geared toward those who already have some knowledge of the ukulele, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing this tropical X-mas carol on your own ukulele, take a look!
If you're looking to buy a game that doesn't cost too much and offers great looking visuals, then Limbo is for you. This puzzle-platform game is a sidescroller that has you controlling an unnamed boy who is searching for his sister. There's no soundtrack, it's in greyscale, and features some pretty gruesome deaths for your character.
Want to play the "Sleigh Ride" Christmas carol on your ukulele? See how it's done with this free video ukulele lesson, which presents a complete breakdown of the song and it chords. While this tutorial is geared toward those who already have some knowledge of the ukulele, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing this classic winter holiday song on your own ukulele, take a look!
Want to play an unplugged verison of "With or Without You" by U2? See how it's done with this free video guitar lesson, which presents a complete breakdown of the song and its chords. While this tutorial is geared toward those who already have some knowledge of the guitar, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing "With or Without You" on your own acoustic guitar, take a look!
Want to perform Tom Petty's "Learning to Fly"? See how it's done with this free video guitar lesson, which presents a complete breakdown of the song and it chords. While this tutorial is geared toward those who already have some knowledge of the guitar, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing "Learn to Fly" on your own acoustic guitar, take a look!
Want to play "Don't Look Back in Anger" by Oasis? See how it's done with this free video guitar lesson, which presents a complete breakdown of the song and it chords. While this tutorial is geared toward those who already have some knowledge of the guitar, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing "Don't Look Back in Anger" on your own acoustic guitar, take a look!
Want to play "Use Somebody" by Kings of Leon? See how it's done with this free video guitar lesson, which presents a complete breakdown of the song and it chords. While this tutorial is geared toward those who already have some knowledge of the guitar, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing "Use Somebody" on your own acoustic guitar, take a look!
Want to play "The Only Exception" by Paramore? See how it's done with this free video guitar lesson, which presents a complete breakdown of the song and it chords. While this tutorial is geared toward those who already have some knowledge of the guitar, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing "The Only Exception" on your own acoustic guitar, take a look!
Want to play an unplugged version of "Smells Like Teen Spirit" by Nirvana? See how it's done with this free video guitar lesson, which presents a complete breakdown of the song and it chords. While this tutorial is geared toward those who already have some knowledge of the guitar, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing "Smells Like Teen Spirit" by Kurt Cobain on your own acoustic guitar, take a...
Want to play "Hey There Delilah" by Plain White T's? See how it's done with this free video guitar lesson, which presents a complete breakdown of the song and it chords. While this tutorial is geared toward those who already have some knowledge of the guitar, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing "Hey There Delilah" on your own acoustic guitar, take a look!
Interested in performing an unplugged version of Coldplay's "Viva la Vida"? See how it's done with this free video guitar lesson, which presents a complete breakdown of the song and it chords. While this tutorial is geared toward those who already have some knowledge of the guitar, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing "Viva la Vida" on your own acoustic guitar, take a look!
Want to play "I'm Yours" by Jason Mraz? See how it's done with this free video guitar lesson, which presents a complete breakdown of the song and it chords. While this tutorial is geared toward those who already have some knowledge of the guitar, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing "I'm Yours" on your own acoustic guitar, take a look!
Want to perform an unplugged version of "TiK ToK" by Ke$ha on your acoustic guitar? See how it's done with this free video guitar lesson, which presents a complete breakdown of the song and it chords. While this tutorial is geared toward those who already have some knowledge of the guitar, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing "TiK ToK" on your own acoustic guitar, take a look!
Want to play "21 Guns" by Green Day (or Mott the Hoople's "All the Young Dudes" or, uh, ELO's "Telephone Line" for that matter)? See how it's done with this free video guitar lesson, which presents a complete breakdown of the song and it chords. While this tutorial is geared toward those who already have some knowledge of the guitar, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing "21 Guns" on your own ...
Google is one of the most powerful forces on the Internet, and their technology can be the key to helping you find success in whatever your online endeavor might be, from web design to filmmaking. This video is a part of their Google Webmaster Series, offering help to webmasters the world over on how to best utilize Google in their work. This video will show you how to restore your Google ranking after your website has been hacked. Hopefully you never will be, but if you are this video is her...
Jazz music, along the lines of jazz greats like Coltrane and Thelonius Monk, is usually associated with the piano and the sax (as well as backup clarinets, oboes, etc.). But an equally fit instrument for playing jazz tunes is the acoustic guitar, which offers a light contrast to the larger, deeper toned instruments.
After taking piano lessons for most of our anguished childhood, we realized one of the most effective ways to increase finger dexterity and speed was simply to play scales. Over and over and over and over again. While churning them out an infinite number of times is tres boring (especially because we could have been at the mall with our friends watching Mulan), scales are vital for becoming a good piano player.
Unlike being a square, being a square knot means you're multifaceted, fun, and unique. Of course, we're talking about square knots in friendship bracelet/jewelry making, in which you utilize two different colors of string to create a tight zig zag knot pattern followed by loops.
Love playing Zelda? The video game itself is awesome, but next time you're cruising around dungeons pay attention to the music in the background. The soundtrack for Zelda is well known and created by a master composer.
With learning any instrument, often the hardest part to gaining any fluency is being able to bend your fingers to stretch out even to the furthest notes and do so with finesse. So if you wish to become a famous bass player in a rock band, one of the best things you can do to help with finger fluency is simply practicing a few drills.
In this tutorial, we learn how to download mathematical applets using Wolfram Alpha. First, go to the website Wolfram Demonstrations. Once on this site, use the search bar to type in whatever topic you are interested in, and press enter. After this, you can scroll through and see several different applets. Next, you can click "watch web preview" to get a brief idea of what the applet does. When you find one you like, download the Mathematica Player, which you will only have to download once. ...
AGC ruining your takes? This Canon EOS DSLR user's guide offers a trick for disabling it entirely. It's simpler than you might think. So simple, in fact, that this clip can present a complete overview of the process in just over 5 minutes' time. For more information, and to get started disabling auto gain control on your own Canon t2i/550D or 7D camera, take a look.
Want to play the "Game Over" and "Lost Life" themes from Nintendo's Super Mario Brothers? See how it's done with this free video ukulele lesson, which presents a complete breakdown of the song and it chords. While this tutorial is geared toward those who already have some knowledge of the guitar, players of all skill level should be able to follow along given adequate time and effort. For more information, and to get started playing this video game song on your own ukulele, watch this video t...
The number of Korean people that still make kimchi (or Kim Chee) from scratch is dwindling, but no store bought brand will ever taste as great as homemade. In this tutorial, take a trip to New York and visit Yu Um Chon, a great grandmother who has made kimchi over 10,000 times for her family. She will show you exactly how to make this tasty salad and offer you a few tips she has developed over the years (like adding a bit of artificial sweetener to make the salad less slimy). Follow along wit...
Photoshop offers lots of tools for automating selections, but two stand out from the pack: The first, Refine Edge, lets you modify your selection using five different parameters and preview the results in five different ways. Whether you're new to Adobe's popular raster graphics editing software or a seasoned professional just looking to better acquaint yourself with the program and its various features and filters, you're sure to be well served by this video tutorial. For more information, i...
Doing a hobby such as crochet usually offers no instant gratification - in fact, that's probably why we have this stereotypical image of a grandma sitting in her rocking chair, knitting endless bunches of scarves for her grandkids for hours on end.
So.. you spent 200, 300 or even 600 bucks on your new iPhone and now you have no reception! It seems as though Apple was so busy developing cool new apps for it's latest creation that it forgot about the fact that its.. oh right.. also a PHONE. If your new iPhone 4 cuts out every time you hold it, check out this clip. This tutorial will offer some awesome tips and speedy solutions to this annoying problem. So, if you are about to run up to Cupertino and tell Steve Jobs where he can stuff his ...
Kids love Cheetos. There's nothing better than those crispy sticks and the joy of licking your orange fingertips when you finish. Or is there? Watch this Food Facts tutorial and learn why you should keep your family far away from Cheese doodles and other types of puffs. This clip will give you a basic rundown of all the mysterious ingredients inside these snacks and offer advice on finding much healthier alternatives for your family.
The Nook from Barnes and Noble is a revolutionary new e-reader. Not only is the Nook slim, useful and touch screen, it is also the most inexpensive one on the market. This colorful, customizable reader is great anywhere in America, but what about if you live elsewhere?
There are a zillion ways to make stuffing for your Thanksgiving bird, but only one way to make it Martha Stewart-style. If you're cooking for a big party this year of 20 people or more, Martha offers a delicious, buttery recipe for stuffing that'll satiate all the mouths you'll have to feed while still having leftover for casserole.
This Blender 2.5 video tutorial offers a lesson in how to create an easy chain with nothing more than a single link, a array modifier and a curve modifier. Then see the process of using the freshly created chain in a simple scene. 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 C...
This Blender 2.5 video tutorial offers a demonstration and overview of clean hand topology. The tutorial includes tips on how to structure your mesh, including clean topology, mesh flow and edgeloop density. 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 info...
This clip offers instruction on how to export a model from Blender to Unity 3D and import it into a game. The tutorial also demonstrates how to bake a normal map and a color map from a highpoly model to the lowpoly counterpart, real-time display of the color/normal maps in the Blender viewport with GLSL shading, and real-time updating of assets in Unity. Whether you're new to the Blender Foundation's popular open-source 3D computer graphics application or are a seasoned digital artist merely ...
This clip offers a look at how to create non-photorealistic cumulus clouds in Blender. These techniques are taken from a Siggraph 2009 paper titled “Painting with Objects,” created by Isaac Botkin. 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, i...
Blender's constraint system offers a very powerful feature-set. In this video tutorial we will look at how to rig a piston using several constraints. 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 this tutorial, pet expert Marc Morrone will tell you all about how to take care of more than one cat at once and help them get along with each other. In this clip, Marc will walk you through all the stages of cat care and offer advice on how to introduce a new kitten into your home and to your already existing cats. If you think like a cat, you will be able to better raise your cats, so check out this clip for tips on how to do so.
This video offers instructions on how to use a wire wrap (or wirewrap) tool, an excellent and underrated alternative to soldering. It's particularly useful when prototyping as wirewraps can be undone quickly using the short end of the tool (though this particular process isn't demonstrated in the video). See how to connect a 4-legged RGB LED to header pins, a job that is particularly obnoxious to accomplish using solder and an iron, using 30-gauge wire and the tool. For more information, and ...
This Cinema 4D tutorial offers a lesson in creating a very fast and easy comedy title sequence using MoGraph, MoGraph Spline Effector and a bit of compositing in After Effects. 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 detailed, step-by-step instructions, watch this 3D modeler's guide.
