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 6th installment in his "Excel Business Math" series of free video lessons, you'll learn about the importance of cell References in Excel formulas and functions. Learn about a relative and absolute cell references in Excel formulas with th...
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 9th installment in his "Excel Business Math" series of free video lessons, you'll learn about when you must use the ROUND function in Excel. Round to the penny or dollar with this free video lesson.
In this Electronics video tutorial you will learn how to tether a laptop to a Droid Smartphone for free Wi-Fi. For this you will need the android wifi tether application. Download the version for your device from here and install it. Then launch the app and press the icon to start tethering. In your laptop, go to settings and then to wi-fi. You will see a new network called android tether. Connect to the network and you will see that it works. As with any other network, you can change the nam...
First step in a free throw is when the ref passes you the ball. At this point you should step back and take a breath, this will slow you down and help you concentrate. You have 10 seconds to shoot so there is no rush. Next, approach the line. You will find a nail, dot, or spot of paint. This shows you where the center of the court is. Line your shoulders up with the dot, to prevent the ball from going to the left or right of the hoop. Next, you should use a routine you've established to get y...
Linux is a fully functioning free operating system that you can download online. Just because you are using Linux Ubuntu doesn't mean your projects have to suffer or look less professional that those made on traditional operating systems like Windows or Mac OS X. In this tutorial, learn how to download and add fonts to the GIMP photo program on a Linux Ubuntu system.
Make your transition into the Hip-Hop world a tad smoother with help from this free lesson. Hip-hop dance is a form of dance that can be seen on the streets or in the studios, and its incredibly important to listen and move with the beat of a song. Discover the importance of paying close attention to the music when hip-hop dancing with help from this free lesson.
Entering into the world of hip-hop dancing? Impress the rest with pulling off an impressive slide glide taught in this video for free. The basic form of slide gliding begins with getting the hands loose and the feet a little wider than shoulder-width apart. Find out how to manipulate the heels and toes and slide glide like Usher with help from this free lesson.
Throw yourself into the world of hip-hop with help from this free lesson. Hip-hop foot work can be broken down into simplified movements or moves that are abstract and contrived to the music being used. Find out how to do a hip-hop combination with help from this free lesson.
In this Computers & Programming video tutorial you will learn how to create a virtual machine for free using the virtual box in Mac. Open the virtual box and click on new. Click next, put in a name for the virtual machine and click next. In the next window, it gives a recommended memory, increase it slightly with the slider and click next. Click next in the subsequent 4 windows that come up and finally click ‘finish’ and click ‘finish’ again on the next window. In the next window click CD/DVD...
Is the spacebar on your keyboard out of whack? This simple video will show you how to re-seat it in less than two minutes. Start by using your fingers (or a small screwdriver or spudger if needed) to gently pry up along the top of the spacebar, working from one direction to another. Continue working along the top until the key is free from its mounting clips. Observe the location of the mounting clips. After the key is free from the keyboard, you can also remove the metal support bar from the...
In this Arts & Crafts video tutorial you will learn how to baste a quilt for free-motion quilting patterns. This video is presented by craftygemini. This method of loading your quilt onto your quilting frame is known as floating where the quilt top and the batting are floated. Neither the top nor the batting are rolled and pinned onto leaders like a backing fabric. First go to the top center point of the quilt top, put the pressure foot down and take a stitch. Bring the bottom thread up, hold...
Initially, it is explained what an animated GIF is: a series of frames that are shown in sequence, and are looped 'forever'. There is an example of one of them in the background, and it is stated that it was created in around a minute, using nothing else than a webcam and a free software, found at TagJag.
When conducting covert mobile surveillance with video it is vital to have a good bag that will contain and allow you to get footage in an inconspicuous manner. Always take into consideration the lighting and distance you’ll be at.
Learn the right way of tying the ‘Decorative Trilobite Knot’, by watching this video. Take a rope and form two bends, as shown. Now pass each bend over a hook to form two loops at the center, resembling number eight. The free end of the rope on the right side is then passed over the lower loop of the eight, to the left. The free end of the rope on the left side is then passed under the rope, just passed from the right. Thereafter, it is passed under the lower loop of the eight, and pulled thr...
In this video, Raw food author and chef Jennifer Cornbleet shows you to make a great gluten-free raw granola, which is then topped with raw almond milk. She starts out by showing you have to make the almond milk by putting the almonds and water mixture into the blender. After she strains the milk and you are left with almond milk, which lasts up to five days in the refrigerator. Next she shows you how to prepare the gluten-free granola. She combines three different nuts and a date mixture int...
When learning to play a piece on the guitar, nothing can really compete with a good tutorial video. Sure, you could have someone show you in person — once or twice, mayb — but you can only ask someone to repeat something so many times before embarrassment sets in. With this particular three-part free video guitar lesson, you'll learn how to play the solos to Pink Floyd's song "Money" from their seminal 1973 album, The Dark Side of the Moon. Enjoy! (And feel free to rewind as necessary.)
In this video from VvCompHelpvV we learn how to get a free redirecting domain name which would be any one of these: .co, .cc, .co, .nr, and .tk. This is basically a redirection URL that brings you to the same site but with better words o more professional looking. The first way he shows is and then the next one is [http://www.freedomain.co.nr] and the final one he shows is [http://www.dot.tk]. He recommends using the co.cc domain because those get indexed apparently.
The guy in this video shows us how to permanently delete files on a Mac. First one would click on your desktop so the finder pops up and one would go to "utilities" and click "disk utilities". Next, one would click on the disk which they would like to clear, then click "erase" and then click "erase free space". After clicking, a box will pop up asking if you want to erase 0 times which clears the disk 1 time, 7 times which clears the disk 7 times to delete unwanted files, or 35 times, which r...
Just by moving one match you can turn the math problem into a correct answer. Definitely use this to get some free drinks. And you already know the answer, so it won't be hard. If you want to try and figure this one out for yourself, pause the video before the reveal.
This video will show you how to do a great bar trick puzzle. Connect the boxes to win some bets and free drinks. Once you know how to do it, it's very easy to accomplish. This involves some drawing, but you'll impress friends with this intersecting lines trick.
You are not having a good day. You've been abducted by sinister folks, and your hands are tied by a pair of zip ties bound together. How will you escape? In this tutorial, the guys at ITS Tactical show you how to escape from these bound cable ties, which are frequently used as makeshift handcuffs by police and military personnel, along with mischievous kidnappers. To break free, believe it or not, all you need is a little force.
Learn how to crash a wedding. If you have a free Saturday, we have a way for you to score free food, free cocktails, free dancing—and maybe even a hook-up.
This video tutorial from IndyMogul shows you how to make a robotic arm and create cheap lighting for shoots.
Don’t squeeze that blackhead! There’s a gentler way to get rid of it, and several steps you can take to prevent new ones from forming.
"Free Weezy" is the catchphrase no longer necessary, unless you're talking about making November 4th Free Weezy Day, to celebrate Lil' Wayne's release from Rikers Island in New York City.
If you've never replaces a CV joint in a front wheel drive vehicle, it may seem like an intimidating task. But it can actually be easy if you have a good place to perform the work and have all the tools necessary to complete the task. And some good instructions, of course. Watch below for all the tools you'll need to properly change CV joints on a car, then hit up the link below to see the rest of the videos in this free series.
If you want to instantly resize your active window so that it fills any extra window space on your screen, try the free utility WinMaximumize featured in this Tekzilla segment. Hit the default hotkey (Ctrl+F1) or remap it to whatever keybind you want.
Check out this free Windows utility that allows you to print files directly from the file system by dragging and dropping them onto an icon conveniently placed on your desktop.
Copying a file's path on your Mac isn't always an easy task. Thankfully, this cool little OSX utility called Copy Path Finder helps solve this problem and lets you copy the path of a file in your file system to the clipboard so that you can paste it into a text editor later.
Photoscape is a piece of free, photo editing software to use instead of more costly programs such as Photoshop. The program is pretty cool but you may want to install more fonts than what it comes with. If so, check out this video and you'll find out how to get it done. You'll need a zip program like winzip or winrar and you'll of course need Photoscape which you can get here.
If you're a loyal Nokia customer and proud owner of their N900 smartphone, you may be wondering how to get the most out of it since there's so much more info out there about Android and iOS platform devices. This video will show you how to download custom wallpapers, use tethering, free up RootFs, and change the LED pattern on your N900, among other things.
Todd Wilbur of Top Secret Recipes is at it again. In this installment, Todd shows us how to make an Oreo cookie from scratch. For all of the delicious details, including a complete recipe, watch this free video cooking lesson.
Here's a card trick that looks like you screwed up, but in reality, it's all part of the gag. It's got a great twist at the end that will put those smug viewers in their place. Do it at a bar and win a free drink.
Elder Dragon Highlander is one of the more imaginative and fun Magic: The Gathering variations, played with 100-card decks in which no card can be repeated and free Legend creatures for all players. This video will teach you how to play it, but not how to build a deck. You need to check out it's companion video for that.
Dead or hot pixels are one of those annoying camera problems that won't make you buy a new camera but will piss you off for years. There's a free solution that may work for you though if you have a Canon 5D or 7D, and this video will show you how to do it with the sensor cleaning function.
Pre-production is a much less complex process for an indie film than a big-budget one that needs stars and permits and such, but it's still vital to shooting a good film in a timely fashion. This video will walk you through Ryan from Film Riot's entire pre-production process, including script breakdowns, free casting calls, budgeting, getting a crew and locations.
Want to know how to perform the bass part to the Beatles' "Come Together"? Learn how to lay it down with this free video bass lesson, which presents a complete breakdown of the song's bass line. This tutorial is best suited for beginning players. For more information, and to get started playing this classic Beatles song on your own bass guitar, watch this how-to!
Interested in playing Sir Elton John's "Candle in the Wind" on a piano or other keyboard instrument? Let this free video music lesson be your guide. While this tutorial is best suited for intermediate or advanced piano players, players of all skill levels can play along. Watch this tutorial to get started playing "Candle in the Wind"!
Want to perform an unplugged version of Weezer's "Memories"? 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 "Memories" on your own acoustic guitar, take a look!