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 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:
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 15th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with tables in Excel 2007. Specifically, you'll see the following:
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 19th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn about using Advanced Filter to extract data from an Excel List/Table/Database. See these 7 Advanced Filter 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 2nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to get started using functions and formulas in MS Excel. Specifically, you'll see the different elements of formulas (the equal sign, cell references, math operator...
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 3rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to name a range of cells; how to use names in formulas;
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 5th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create seven types of charts — X-Y scatter diagrams, pie charts, column charts, bar charts, stacked bar charts, line charts, and column and line chart combined. ...
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 21st installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to add conditional formatting to data bars and icons to show relative size, icons to show relative size, to highlight values within 1 standard deviation, to highli...
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 42nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn ten tricks involving the LOOKUP function:
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 22nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll see a lifetime savings plan using the FV and PMT functions and other formulas. See how to calculate how much you will have at retirement from a basic savings plan. Then see ...
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 22nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create a budget with formula inputs in an assumption area and formulas. Then do what-if analysis by saving and showing scenarios. Also see how to save variables...
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 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use comparative operators; logical TRUE/FALSE formulas, IS functions (ISTEXT, ISNUMBER, ISBLANK, ISERROR, ISNONTEXT); IF functions (1 of 2 words in a cell, 1 of...
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 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to transform bad data into useful data using formulas and text functions such as TRIM, PROPER, SUBSTITUTE, REPLACE, FIND and LEFT. Also see how to use the ampersan...
There are two different ways to draw Pickachu from Pokemon. There is old school Pika, from when Pokemon first debuted, and then there is new school Pika, which is probably the most famous version of this little guy.
In this tutorial you will learn how to determine and work with equivalent fractions. If you do not know what an equivalent fraction is or how to find them, this is the video for you.
In this episode of Acoustic Guitar for Beginners, Rich Maloof shows you how to strum on an acoustic guitar. Strumming is important to a lot of songs and gives you a cool, carefree playing style.
Dead lifts have a great corrective capacity when done properly.The dead lifts can be done just by picking weights off the floor or in a smart and meticulous way.When doing dead lifts there is a lot of rotation in the upper arm,and many people or athletes are not doing the dead lifts properly.When you do an external rotation you automatically force extension and that can put you in a great anatomical position for dead lifts.The exercise itself is simple,you have an iron bar,lift it,draw the sh...
This video shows how to make an inside-out French braid across the front of the head. First divide the hair into three pieces like a normal braid at the very front off to one side. Instead of braiding the normal way, make the middle piece go over the top alternately on the left and right. Keep picking up more hair and adding it in, like you would do for a normal French braid. Continue braiding across the top front of the hair. The braids can be done tightly or loosely however you like, and th...
In this video, we learn how to make a homemade facial mask using durian (a southeast Asian fruit). First, grab some peeled durian and pick out the rich creamy pulp (leave the skin out). If you can't find this at your supermarket, try an Asian market. All you need is 1 tsp of this fruit for your entire face, then apply to your clean face. It will go on smoothly on your whole face. Let it soak in for 20 minutes and when it's done your face will feel tight. After this, rinse of your face and pat...
This video shows you how to shuck an oyster using an oyster knife. First, wear a metal mesh glove, used for protection, in case you slip-in and cut yourself, on your left hand. Then take the oyster shell on your left hand and pick the knife on your right hand. Then point the knife tip towards the shell, dig it and jiggle it in between the shell, and then grab the oyster from the wedge and twist the knife till the upper and lower parts of the shell are separated from each other. Once the two p...
In this video, David teaches us how to clean the inside of windows easily and quickly. You don't need fancy tools, all you need is a terry cloth towel, a squeegee and dish washing detergent. First, put a little bit of the soap into a bucket and wash down the windows. Next, take a squeegee and wipe horizontally making clean lines. The excess water should drip down and you will catch it with your next squeegee wipe. If you have extra wetness on the edges, grab an old t-shirt and wipe the sides ...
This is a "Southwest Yard and Garden" episode that details the proper selection of gardening tools for fighting seasonal weeds. Horticulturist and host Curtis Smith takes us to meet with Ron Jobe, an Albuquerque Master Gardener, to discuss the options available for such a task. Ron covers the various conditions a gardener is faced with, including the soil and the weeds themselves. Some suggested tools are: the Wing Hoe, Skimming Hoe, Raker, Pointed Hoe, and Stirrup Hoe. The use of each is off...
Mike Callahan will show you the tricky process of changing the screen timeout on your Android cell phone. While some people like their screen to black out right after they finish using it others prefer it to stay lit for a while. Mr. Callahan shows you how to change the setting regardless of how you like it. First tap on settings. Next, tap on sound and display. Then, you are going to want to scroll down until you get to screen time out. After selecting the screen time out option, you will ha...
In this video, we learn how to make homemade lip color with palette. First, start off with a mixing bowl and a small amount of Vaseline. Pick any type of color you want, whether it's blush, eyeshadow or foundation, add this to the Vaseline. Mix this together using a small spatula. You can add more colors as you desire to get your wanted colors. Make sure the color is mixed well and is well-blended together. When you're finished, test the lip color out and apply it to your own lips. To save it...
In this tutorial, Andy from TopTenReviews shows us how to restrict internet time usage with Net Nanny. First, open Net Nanny's dashboard and find where it says "time controls". You will see "internet usage", make sure you click on this. Now, a new window will pop up where you can choose time allowance, schedule times and blocks to your specific preferences. Once you pick these, click "ok" and your restrictions will be set and saved! This is a great way to control when your children and others...
This is a video demonstrating how to properly coil a guitar cable. First some incorrect ways of folding the cable are shown. One should not wrap the cable around the forearm, pick it up in a ball, or wrap it like a lasso around the hand. The correct way is demonstrated by taking a section between the thumb and index finger, rolling the index finger toward you, then making another loop by rolling the index finger away from you. This process is repeated until the entire cable is coiled. Folding...
Yanik Chauvin continues his online photo school with this video on how to change eye color in Photoshop. Yanik makes this complicated program seem simple as he shows exactly what steps to take to make realistic color change in the eyes of a person. He creates a layer that will be used to edit the eyes, then zooms in on and selects them. He picks a nice green color to use, shows what settings to use to make it look realistic, then applies final touches by changing the opacity of the new color....
This video from Danny Lipford explains how to make a cover for raked leaves so that the wind won't blow them away. Get a tarp and cut it to the right size. Get two wooden dowel rods and put them along two ends of the tarp. Turn the tarp edge over the dowel rods and tape them down with duct tape. The cover can be used to cover leaves that are in a wheelbarrow or on the ground. You can also lay the tarp on the ground, rake the leaves into the tarp, drag them where you want them and pick up the ...
Many of us have grown up being wary about using pressure cookers, thinking the food doesn't come out tasting as good as it does through other cooking methods. No need to worry! Gourmet Magazine explains that it's not the pressure cooker that's the problem; you just need to pick recipes that benefit from the use of the pressure cooker. Here to show us how with a simple and delicious lamb and bean recipe, you will be taken through the recipe step-by-step. The ingredients are simple, including l...
Are you interested in 2D animation in Flash? First import a image in flash. Then create a new layer and choose oval tool and take a radial gradient. In the middle of the shape, we need to have zero alpha value and pick the colors from the background of the image. Create the shape over the image and take another frame at no.10 and increase alpha. Then create another keyframe and convert it to movie clip. Then create shape and motion tween. On the new layer, write a stop command in action scrip...
This video is an acoustic guitar lesson from scottious. In this video, he teaches you how to play the song "We're Gonna Be Friends" by White Stripes. He begins by showing you which chords you need to know to get started on learning the song, and demonstrates how to finger them. He then moves on to the progression of the chords through the song in the verse and the chorus. You will learn the G, C, D, and A chords in this lesson, as well as how to finger pick the notes.
[url=http://www.youtube.com/watch?v=wo3tzkZLsWs] Bobbycrispy teaches you fingerboard tapping.[/url] Bobby crispy teaches you the basics of fretboard tapping. Learn through doing several basic exercises demonstrated by bobby at a learner's pace. Also pick up beginner's tips like where not to put your hands while tapping on the fret board to stop interruptions while tapping. Tabs are included to keep you on the level with bobby at all times from a musical point of view along with the video for ...
In this electric guitar video lesson brought to you by GuitarJamz, host Marty Schwarz will teach you how to play "Beat It" by Michael Jackson. As you follow along with him, he breaks down the picking of the notes used in the song by breaking down each part of the song. He then teaches you the chords and explains the strum pattern. This video is very easy to follow and will have any beginner ready to play in a relatively short time.
In Part 1 of this electric guitar video lesson, brought to you by GuitarJamz, host Marty Schwarz will teach you how to play "Sir Duke" by Stevie Wonder. As you follow along with him, he teaches you the intro of the song, breaking it down slowly so that you can follow along with him. Then he moves on to 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. You will learn the...
Aaloo cholay sabzi or potato chickpea is a traditional Pakistani dish. It is a delicious, spicy concoction that is actually quite easy to prepare. No matter where in the world you are from, you will love this healthy dish with a Middle Eastern flair.
When it comes to knitting patterns, simple algorithms can have very aesthetically pleasing results. Take the simple color-graded hat. See how to knit a color-graded hat with this easy, up close demonstration by Judy Graham, Knitter to the Stars.
This video starts off with a neat optical illusion that he uses to demonstrate the effectiveness of force card tricks. He shows a piece of paper with "Paris in the the spring" written on it, most people's mind will skip over the second "the" and will read it, "Paris in the spring." He then goes on to demonstrate a shuffling trick that allows you keep a hold of a given card while shuffling. Finally the presenter explains the difference between asking someone to "Pick a card" and asking someone...
Sick of your flowers dying after just a few short days? Want to give your sweetie a bouquet, but can't afford the high florist prices? Make flowers out of duct tape! That's right, duct tape. This instructional video shows you step by step how to go from household material to decorative flowers. With some colored duct tape, a straw, and a pair of scissors you to can make custom flowers out of something you can pick up at the hardware store.
If you're looking to cheer up someone who is sick with a homemade Get Well Card, follow this video for steps on how to make a Get Well card with Stampin' Up. Crafter Dawn takes us through the steps of how to create this card with the Pick-a-Petal stamp set. Be creative and use whatever color stamp pads you want to add a personal touch. By following Dawn's simple arts and crafts steps, you can cheer up anyone with this Get Well card with a smile and a thoughtful, handmade gift.
This video goes through the steps needed to cook a hard boiled egg. Firstly, you will need to boil some water in a saucepan. You can then add the egg and boil for exactly 7 minutes; this will give you a slightly soft egg. Then, drain the water off and toss the egg around in the pan, which will crack the shell. Add some cold water to the pan and let the egg cool down, until you can pick it up. An easy way of peeling the egg is to roll it between your hand and a hard surface; you will now be ab...
This how-to video is about how to create a simple text effect in Photoshop.
