See how to create value-based formatting using data bars and color scales in Excel 2007. See how to use the Format Cells dialog box and the pop-up mini-toolbar in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, w...
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 48th installment in his "Excel Business Math" series of free video lessons, you'll learn about the basics of markup on cost and markup on selling price. Markup on cost uses the base cost. Markup on selling price uses the base selling price.
You all the know the scene from Ghost? Where Patrick Swayze and Demi Moore are sitting and they are trying to make something using the machine? It's one of the most iconic scenes out there. Anyways, this video isn't about ghosts, or either of those actors, but rather that machine and what it can do. This tutorial will show you how to throw a lamp base easily. Enjoy!
Area of a triangle can be calculated when you have the length of its base and height. In this case the area is 1/2 times the base and its height. If you do not know the height of the triangle but know the lengths of all the sides of the triangle then you can calculate its area using the Herons formula. First to use it you need to computer the semi perimeter of the triangle S, which is S = (a + b + c)/2, where a, b, c are the lengths of the sides of the triangle. Now the area of the triangle i...
New to 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 Excel tutorial from ExcelIsFun, the 194th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUM, VLOOKUP and ROUND functions to create a gradebook based on percentage scores that will calculate grade for you automatically. See also how the VLOOKUP and the percentage format can deliver the wrong grade when you dont use the ...
Ballinguy556 shows you how to play "Tears in Heaven" by Eric Clapton. You need an acoustic guitar to begin. You will be learning the main riff. Take your thumb and play the open E string, hammer thumb on E string and then play the open the A string. Then play the A cord bar. Then pluck E, G, E strings. Move your D cord up a step and low E. Play a F cord together and the base next. Then play an open E the same. Then play a D in the same together, base pattern while lowering your index down a h...
If you're into arts and crafts then you know that there is more that you can do with a long piece of string than just tie your shoes. On this TyingitAllTogether video you have the opportunity to tie the teacup decorative knot using one long piece of string folded in half. The author of the video first shows you what the end product will look like then methodically begins to walk you through setting up the string in Y-configuration to "crossing each bights crook" which involves overlapping and...
This tutorial shows how to make tiny molded roses and leaves that you could put on cupcakes. To start you only need a few ingredients: icing sugar, water, paste coloring, fondant icing sugar, and a piping bag (optional). Mix all ingredients together, then put them in a bag so they stay soft. Make the color of the rose or petals any color you want. Knead the dough so that you will have the color you would like. Next, break off a piece of the kneaded dough and form it into a cone shape. Break o...
In this tutorial, the instructor shows how to compute the surface area of a regular pyramid. A regular pyramid has four equal sides which are in triangle form, and the base in square form. Its surface area is four times the area of its side plus the area of its base. He goes on and takes an example with sample values and demonstrates how to compute the final value using the formula. He reminds the viewer to use square units in the final answer, as square units equal the area. To find out the ...
These are some great tips for improving speed on FarmVille. If you want to learn how to harvest and plow and plant faster, then these tricks will definitely help you out.
Is a cow up for adoption on FarmVille? Using this simple hack, change the cow's color in a snap! This video tutorial shows how to do the FarmVille pink-to-brown cow hack (10/14/09). Using this simple hack, one can change an adopted cow's color from pink to brown, and vice versa. To find out how and see it in action, watch the video.
Speed up that egg production in FarmVille by speeding up your chicken coop harvesting skills. No cheating, just some normal everyday tips for getting better at egg harvesting.
The quickest way to get a gorgeous lawn is to lay sod, uniform patches of grass-covered soil held together by matted roots. It will go more smoothly if you know a few landscaping tricks. Learn how to lay sod for a perfect lawn with this how to video.
Clicker train your pup to limp with this training video. This is a video on how to teach your dog to limp using the clicker training method.
This robot is BEAM bot inspired. First we build up the Motor Drive, an excellent and cheap Robot Bot-Base. We start with the Tamiya kit, get it going, then strap on a battery and a drag wheel, center the drag wheel. Tape it all in place with bright yellow tape and make a BEAM Bot with batteries. Plans for this BEAM framework are to add smarts.
What happens when you combine Super Mario Land with Minecraft? Maybe some awesome pixel art, but how about if you go a step further? What if you add the computer game within a computer game idea and throw in a little stop motion?
Generally, summer is a slow time for video games, but not when it comes to Xbox Live Arcade where it's harvest season! In the last month, there have been at least four great games released on XBLA, with Bastion getting the lion's share of the attention. But the remaining three are pretty awesome, as well, and should help you while away the time spent indoors away from the brain frying heat sweeping the U.S.
1 Walk into a corner in any online level while crouching. Continue crouching once you make it into the corner.
Apple's Reminders app is essential for those of us with a forgetful memory. But a standard Reminders entry isn't foolproof. They aren't great if you need to do something right when you get somewhere, since it can be tricky to set a specific time for that reminder. That's why Apple's location-based reminders are so darn useful.
During the recent Augmented World Expo (AWE), we had a chance to try out the Lenovo ThinkReality A6 AR headset. Unfortunately, the experience was all downhill from there.
While Microsoft dominated the augmented reality news at this year's Mobile World Congress, a small AR startup we've covered in the past arrived in Barcelona, Spain, to unveil the next phase of its mission.
Last week, Twilio showed off how avatar-based chat communications will work on the Magic Leap One, and now a new startup has unveiled yet another way that augmented reality telepresence and remote collaboration can take place on the device.
When traversing the web, you'll regularly come across websites that require you to create an account. With the majority of these accounts, protection is limited to a simple password. Despite this, many people are still using weak passwords such "123456." For these reasons, you really need a password manager, and our research has shown that LastPass is still your best bet.
This technique goes with a project that I have already made - This shows how to make a paper weaved background for your cards, scrapbook books etc as shown in the picture below.
This video talks about how one can create a burger from a simple play doh set. This video is for kids and for everyone who loves playing with playdoh.
How to make a Lego key holder with note board. Tired of loosing your keys? Well keep them safe and in one place with this fun Lego key holder.
I can imagine you sitting there thinking to yourself, "I've played a lot of games! I bet he won't have any that I don't know about!" Well, that's entirely possible. I'm only drawing from my own personal experience here, so you may, in fact, know of all these games.
This gambling video show you some of the worst bets to make on a craps table and how to avoid them.
302 introduces a new physically based daylight sky and sun model. Learn how to create a realistic sun automatically. modo 302 is a service update, free for all modo 301 users. Create physically based skies in modo 302.
Staining wood is an exciting and fun step in your refinishing process. Staining brings out and enhances the patterns in the wood grain and it unifies an overall color. At this stage your project piece begins to look more finished. Allow enough time to complete this task from start to finish to ensure continuity of color. You have the choice of using either water or oil-based stain, and each offers advantages and disadvantages.
This collection of instructional videos from BaseballRox focuses on the big three footwork positions for the catcher. Coach Luckhurst explains the Big 3 footwork, the jump-shift, the rocket throw and much more as a catcher in the sport of baseball.
The SOFLAM is a gadget that you can use in Battlefield 3. It is a team based gadget that you deploy and use to laser target. It is different than a mortar and can be a little hard to use. This guide will show you how to get the most out of a SOFLAM so that you can tear up the other team.
Ke$ha is a music and style icon, for better or worse, and her look in the her most recent music video "We R Who We R" will further the latter. Watch this video to learn how to recreate her hot blue-based look from the video at home
If you've haven't tried Elder Dragon Highlander, check it out. It's an awesome variation of Magic: The Gathering. This video will teach you how to make a powerful deck for it based around the Reaper King card and an army of scarecrows.
Every proper Mario game need at least one level, probably more, based on jumping between platforms moving around on tracks. New Super Mario Bros Wii is no exception, and this video will teach you how to get all of the Star Coins in World 1-5, just such a level.
Your mom probably told you not to play with matches, but now that you're a little older it's time to start breaking that rule. Watch this video to learn how to play a fun trick on / mind game with people at a bar or other social occasion using matches.
"We Like Sportz" is one of the more divisive tunes by The Lonely Island, probably because it mocks a huge chunk of the group's fan base. Watch this video to learn how to produce the song's odd hip-hop beat using Reason 4.
Electro pop is everywhere in these 1980's-obsessed 2000's, and if you can churn out a solid dancable electro pop beat on your PC you're well on your way to some musical success. Watch this video to learn how to make a cool dance electro pop beat in Reason 4 based on the song "Midnight Movie" by The Secret Handshake.
In this tutorial we learn how to install a toilet bowl for your bathroom. First you will apply the ring around the bottom of the toilet and on the floor where the toilet base will go. Apply plumbers wax to make sure this is sealed. Then, flip the toilet over and line up the holes. After this, slowly let it down and push it when you know the holes are in place. Next, you can push down and screw the bolts onto the base of the toilet. When finished, you will be able to connect the water and get ...
In this tutorial, we learn how to make a pair of great looking earrings. To start, you will take the base of your earring that has the hook on it and then take the wire for your beads. Pick out any beads that you want to attach to the wire, then string them onto it. You can add different colors and any type of bead you want to make these unique. From here, use wire cutters to bend and cut the excess wire from the bead. From here, you will bend the extra piece into a loop that you will hook to...