Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create and work with pivot tables (PivotTables) in Microsoft Office Excel. Specifically, this video covers the following topics and examples:
Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 7th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with VLOOKUP function formulas in MS Excel. Specifically, you'll see the following:
Are you stuck somewhere without a can opener? Has this ever happened to you..you move to a new apartment and head to the grocery store.. pick up a bunch of cheap and tasty canned goods for dinner only to arrive home and realize you forgot to buy a can opener along with them? Not to worry!
In this tutorial, Christopher Prince Boucher shows us how to suggest a friend to another friend on Facebook. First, log into your Facebook account and look through your friends. Find the person you want to suggest to your friends and click on their page. On the left hand side will be a button named "suggest to friends". Once you click on this a new window will pop up and you can choose which friends you'd like to suggest this friend to. Once you pick out all friends, click "suggest" and it wi...
Learn how to choose and care for poinsettias with Southwest Yard and Garden's John White. You will be taken through the typical height and specifications for poinsettias, as well as what to look for in the leaves and flowers. One of the most important parts of growing poinsettias is keeping to a specific schedule. Measuring the plants is also important as plants that are too tall or too short are undesirable. Remember to frequently water the plants, but be careful not to overwater. Also, keep...
This video shows us several types of ornamental grass that can be used in landscape projects. Although none of these grasses are appropriate for use in lawns, they are great options for those who are concerned about water conservation. Ricegrass is a bunch grass with long stems and silver heads. It is a cool-season grass and will go dormant in hot weather. Little Bluestem grows quickly in the Spring and is known for its variety of colors including blue, green, and yellow. Giant Sacaton is a g...
This video is a tutorial on how to start growing tomato plants from seeds. The instructor first explains that it is important to make sure your seeds are fresh and within the proper date frame and that you pick a good artificial soil mix for proper growth. The tutorial goes over a few different fertilizer products that you can choose from, yet they are not completely necessary for growth if the soil is of a high quality. The instructor then fills plastic mini pots with soil and then uses a pe...
Southwest Yard and Garden teaches viewers hot to grow blackberries in Southern New Mexico. Blackberries grow in high rain fall areas but they can work in the south west. They will need bee pollination so you need to make sure that you do not spray too much insecticide on them or you will kill of the bees. Make sure you pick the blueberries when they are dull and not when they are shiny. This will give them the maximum sugar content. Blackberries should grow in sandy soil or looser soil. You m...
This video shows how to synchronize our blackberry smartphone with MS outlook. First open up the Blackberry Desktop Manager. Let us start by synchronizing the blackberry. Double click the synchronize button to load the synchronization settings. Here we can specify what we want to synch and where we want to synch firm. Click the configuration tab and select configure synch. Our device configuration menu let us pick which application on the black berry to synch and where to synch. Today we are ...
This video describes the process of changing the audio on a YouTube video that you have already uploaded. The video is presented by Helplines.com and is in their technology series. We start out logged into YouTube and click on Uploaded Videos, then choose the video you would like to change. Click on the Audio Swap button that is just below the video. You can then choose the I'm Feeling Lucky button to have YouTube pick the audio for you. Or browse through the selections to find an appropriate...
In this acoustic guitar video lesson, Scotties, teaches you how to play the song "Landslide" by Fleetwood Mac. He begins the lesson by breaking down the picking pattern for you so that you can follow along, using some useful tablature overlaid on the video for you. Once you have got this down, he moves on to teaching you the chords you need to know to play the song. You will need to have a capo to play this song the way he performs it.
In this electric guitar video lesson, brought to you by GuitarJamz, host Marty Schwarz, will teach you how to play "Smells Like Teen Spirit" by Nirvana, from the Nevermind album. As you follow along with him, he teaches you the progression of the chords used in the song, breaking down each part of the song, teaching you the chords and explaining the strum pattern and picking of the guitar riffs. This is a great video for beginners who are looking to learn power chords and songs to play with t...
In this acoustic guitar video lesson, brought to you by RockGuitarPower, host Mike, will teach you how to play "Stairway To Heaven" by Led Zeppelin. As you follow along with him, he teaches you the progression of the chords used in the song, breaking down each part of the song, teaching you the chords and explaining the strum pattern and picking of the guitar riffs. This tutorial covers the intro, solo, and rhythm patterns used in the song, and illustrates the chords used in tab notation.
This video shows you how to simulate hand coloring in Photoshop. The first step in the process of simulating hand coloring is to turn the image you have chosen into black and white. Following turning the pictures coloring to black and white you must bring up the hue color control panel. The final task includes selecting the object to color within your image as well as picking the color in hue that you wish to use. The coloring must be done manually by the users control of the mouse.
In this electric guitar video lesson, brought to you by GuitarJamz, host Marty Schwarz will teach you how to play "You Give Love a Bad Name" by Bon Jovi. As you follow along with him, he teaches you the progression of the chords used in the song, breaking down each part of the song, teaching you the chords and explaining the strum pattern and picking of the guitar riffs. This video is very easy to follow, and even teaches you the main solo of the song.
In this video Neil Young provides his viewers with some tips on how to correctly apply foundation on the face of a girl. Moreover, he gives advice to the girls out there on how to pick the correct shade of foundation that will be perfect for her; a foundation that will unify the tone of their face and body. Neil also gives tips on which kinds of foundation should be used during different seasons of the year and what one should do on the few months in between.
This video shows how to make a quick pivot table data filtering by using Excel 2010's ‘Slicer’ functionality. ‘Slicer’ delivers enhanced visual filtering method to allow you to get the data you need more quickly. When selecting a cell in the pivot table you will find ‘Slicer’ in the filter group of the ‘Insert’ tab. Click on ‘Slicer’ and an 'Insert Slicer' dialogue shows up where you can pick particular data fields from the slider list. Once you click on ‘OK’, the ‘Slicer’ objects with filter...
This video explains how to play the song "Such Great Heights" by Iron & Wine on guitar. This song requires a capo on the sixth fret of the guitar and knowledge of the basic chord set shown. The key is F# major and the beginning chord is C Major with the song composed using finger picking. The majority of this songs constitution is alternating between F#, A and C major with the enharmonic chords being G and C. This video contains vocal instructions as well as a close up on the fret board of th...
Ways Linn introduces another in her series of acoustic guitar lessons, teaching users how to play "Wherever You Will Go" by The Calling. Before you get started you will need a capo to play this song. Ways Linn starts out by teaching you the chords you need to know to play the song and demonstrating the finger positions for each. She really takes the time to break down the picking sequence so that even a beginner won't have trouble getting it down, then again in French. She finishes up with a ...
Impress your friends and family with this episode of "Do Try This at Home" with Mr. G and learn a brand new card trick that's sure to wow anyone! All you'll need is a deck of cards and a little practice to master this simple trick of forcing your audience to pick the card you want them to choose. You'll be sure to amaze them when you seem to fail, only to watch a video and there on the computer screen is their card! They'll be shocked at the elaborate trick you've set up for them.
This tutorial teaches you how to do the same nail design as Ke$ha from her video "Tik Tok" had her nails done. First you apply a base polish to protect your nails. Apply a gold polish all over the nail, about three solid coats and then let them dry. Paint on a rich wine color to the corner of each nail end. Use a dotting tool and clean polish to pick up the rhinestones. Apply a little bit of nail glue on the seam of the two colors to help the Rhine stones stay put. Take a fine tip brush with ...
If it's an emergency, sometime you just don't have enough time or energy to pick up your mobile phone and call 9-1-1. Sometime you just can't move and the only thing still working is your mouth. Ford's new SYNC system provides an option for hands free 911 Assist. In a crash involving airbag deployment, 911 Assist places a call directly to a 911 operator. Your bluetooth phone must be on and stored somewhere inside the vehicle.
Bowling Buddies is a Facebook game that allows you to... you guessed it... bowl! Watch this video tutorial to learn how to mod Bowling Buddies for perfect games (09/24/09).
There are tens of thousands of iPhone applications out there. Some are fabulous. Some are stinkers. From boredom-busting games to truly useful utilities, Fox News Tapped-In tell you which are worth a place on your iPhone. Their concise video reviews and how-tos let you see the apps before you download. Plus, they show you tips and tricks you never knew were there. If you own an Apple iPhone or iPod, check this vodcast out.
Calculus can be a bit tricky, but don't worry, Watch Math is here to help you out. Watch this math video lesson to learn how to solve quadratic inequalities in calculus. There's no better way to learn mathematics than from an advanced mathematician, like this PhD.
The one card trick that every street magician or street hustler needs to know is 3 Card Monte. With the help of this video tutorial, you'll see exactly how to perform the three-card monte throw. There is no real magic here, it's all just a sleight of hand, which is needed for any magic card trick.
If you're confused in life and completely bored, then it's probably about time you picked up a yo-yo. A yo-yo is a toy that consists of a pair of jointed discs with a large, deep groove between them, where a string is attached and wound, that can be spun alternately downward and upward by its weight and momentum as the string unwinds and rewinds.
If you're confused in life and completely bored, then it's probably about time you picked up a yo-yo. A yo-yo is a toy that consists of a pair of jointed discs with a large, deep groove between them, where a string is attached and wound, that can be spun alternately downward and upward by its weight and momentum as the string unwinds and rewinds.
If you're confused in life and completely bored, then it's probably about time you picked up a yo-yo. A yo-yo is a toy that consists of a pair of jointed discs with a large, deep groove between them, where a string is attached and wound, that can be spun alternately downward and upward by its weight and momentum as the string unwinds and rewinds.
If you're confused in life and completely bored, then it's probably about time you picked up a yo-yo. A yo-yo is a toy that consists of a pair of jointed discs with a large, deep groove between them, where a string is attached and wound, that can be spun alternately downward and upward by its weight and momentum as the string unwinds and rewinds.
If you're confused in life and completely bored, then it's probably about time you picked up a yo-yo. A yo-yo is a toy that consists of a pair of jointed discs with a large, deep groove between them, where a string is attached and wound, that can be spun alternately downward and upward by its weight and momentum as the string unwinds and rewinds.
If you're confused in life and completely bored, then it's probably about time you picked up a yo-yo. A yo-yo is a toy that consists of a pair of jointed discs with a large, deep groove between them, where a string is attached and wound, that can be spun alternately downward and upward by its weight and momentum as the string unwinds and rewinds.
If you're confused in life and completely bored, then it's probably about time you picked up a yo-yo. A yo-yo is a toy that consists of a pair of jointed discs with a large, deep groove between them, where a string is attached and wound, that can be spun alternately downward and upward by its weight and momentum as the string unwinds and rewinds.
If you're confused in life and completely bored, then it's probably about time you picked up a yo-yo. A yo-yo is a toy that consists of a pair of jointed discs with a large, deep groove between them, where a string is attached and wound, that can be spun alternately downward and upward by its weight and momentum as the string unwinds and rewinds.
The videos in this two-part video ukulele tutorial series demonstrate how to play the LocoRoco theme song on the ukulele with a clawhammer picking style! If you are already familiar with the clawhammer style, then skip to part 2 to get straight to the song. For more information, and to get started playing the LocoRoco theme song on your own ukulele, press play!
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?)
This video knitting tutorial shows how to attach an I-Cord onto another knitted piece. Start by picking up stitches along the edge to which the I-cord is to be attached. Break the yarn, and cast 3 stitches onto a double-point needle. Slip these stitches onto the front end of the needle that is holding the edge stitches, such that the working yarn is 3 stitches in, next to the first edge stitch. Begin by knitting 2 stitches, pulling the working yarn across the back, as for regular I-cord. The ...
Master mixologist Chris McMillian walks us through the history and preparation of the Bloody Mary. What a great way to start the day! The Bloody Mary is a classic pick me up reported to have been created in Paris during prohibition. The drink has also been called the Red Snapper, though most people still know it as a Bloody Mary.
Tired of spending $20 at the carnival to get a teddy bear worth $2.99? Here’s how to beat the carnies at their own games.
This guide makes beating the Widowmaker in Times Square easy enough, so picking up the 'In This Together' Resistance 3 trophy shouldn't be that hard either right? If you head to the location of the Chimera you kill at the beginning of the fight and then walk towards the edge of the map, you can actually fight the Widowmaker without it being able to hit you.
