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 154th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a personal budget based on past data via the SUM function, cell references, subtraction and the VLOOKUP function.
This video helps you to draw a boat. First draw the base with double lines. Then draw a cabin and a wheel. Next draw small circles on the base. Now paint the entire lines with black. Next draw spokes on the wheel. Shade the base of the boat with a lighter brown color and over-coat it with a dark brown. Paint the cabin with orange and brown color as shown in the video. Give a dark brown to the outer area of the circles in the base and fill the inner areas with black color. Give a white line to...
Parallelogram is a quadrilateral in which both pairs of the opposites are parallel. To find the area of a parallelogram first draw the diagram of a parallelogram. Parallelogram can be further divided into squares and rectangles. To calculate the area of both of these kinds of parallelograms multiply the length of the parallelogram with its height. In general the area of a parallelogram in obtained by multiplying the base of a parallelogram with its altitude. In square and rectangle cases, the...
This video demonstrates how to make a catapult out of popsicle sticks. For this project, you will need the following: 7” rubber bands, a box of popsicle sticks, a hot glue gun, a Dixie cup, and tape.
This wordless video shows how to draw a staircase in 3d. Start by drawing the steps in one dimension. Extend two lines at the top of the stairs the width you want the steps to be. Draw another line between them to make a square. This creates a landing. Draw two lines downward and parallel to the steps from the line at the top of the stairs. This will create a rail and a second base. Then extend lines from each jut of the one dimensional steps, stretching the lines alternately to the base and ...
This is a short, very fast paced (6x normal speed) demonstration of how to arrange a floral and green head table piece. The 54 seconds shows the designer how to complete an arrangement from beginning to end. It is difficult to see what the shape of the base is, but it is fresh flowers going into the design. The designer places long greens into the center of the base, adding some long white stemmed flowers. Red carnation heads are then placed around the base along with some additional greenery...
A video to help calculator users find the natural logarithm (log base e, or "ln") and standard logarithm (log base 10, or simply "log") of any number using a TI-83 calculator (works for any issue of the TI-83 calculator or even a TI-84 calculator). Turn on your calculator. To find the natural log of a number, press the "ln" button (the third button from the bottom left), enter the number you want to find the natural log of, press the ")" (closed parenthesis) button, then press enter. The same...
If you're designing a website but are uncomfortable slicing your interface up and reassembling it with CSS, or if you'd like to add easter-egg content to your site, then an image map might be a good option. And with Dreamweaver, the process is simple.
This video shows you how to easily find the area of a parallelogram and the area of a triangle. The first part of the video teaches you how to find the area of a paralellogram. The area of a parallelogram is BxH, where B is the base and H is the height. The height is obtained by drawing a perpendicular line from one corner to the base. The second part of the video teaches you how to find the area of a triangle. The area of a triangle is (BxH)/2, where B is the base and H is the height. That's...
In this video the instructor shows how to solve logarithmic equations. To solve a logarithmic equation, the first thing you have to do is try to get one logarithmic term if possible. To subtract two logarithmic terms use the formula Log (a) – Log (b) = Log (a/b). Now to get rid of logs, perform exponentiation of the base. Exponentiation of the base is raising a number to the power of the logarithmic term where the number is the base of the logarithmic term. Here the value turns out to be the ...
Want to retrieve a value in a given Excel column based on criteria from multiple other external columns? You can. And it's not so very hard provided you know what to do (hint: you'll use the LOOKUP function). Get in the know with this, the 541st installment of ExcelIsFun's series of Excel magic tricks.
Julie teaches the secrets of creating tiger print nails inspired by Rihanna. You will need: a base coat, top coat, nail polish of gold, black and copper colors. First apply a base coat of your choice to the nails and let it dry. Now apply a gold color nail polish on the base coat. Use a copper color nail polish and fill in the tip of your nails as shown. Now use a black color nail polish to draw the tiger stripes. Start drawing a triangle and end up with a line in crooked directions to get ti...
In this tutorial the author shows how to draw a rectangle with given base b and height h values. First she uses a ruler to draw a horizontal base line of b cm. Now she uses a protractor and marks a 90 degree angle at one end of the line, then draws a straight line of h cm which is the height of the rectangle. Now she finishes the remaining part of the rectangle by drawing similar lines of the other sides. This video clearly explains how to draw a rectangle given the values of its base and hei...
Did you know there's a difference between "semiformal" and "dressy casual"? Here are the finer points of proper dress.
Check out this cool hack from The Emo Lab. This video tutorial will show you how to speed up Internet Explorer!
Check out this cool hack from The Emo Lab. This video tutorial will show you how to boost performance in Window XP!
GetConnected host Mike Agerbo talks to Jamie Brigden about installing the Mac OS X operating system on a Windows-based Dell Mini 9 Netbook. The Dell Inspiron Mini 9 Laptop Netbook is a hot item these days with its portability, so why do Apple users have to be left out to dry?
Learn how to spot a dishonest contractor for home repair. It’s no accident contractors have such a bad reputation – they get more fraud complaints than any other workers! Here’s how to find a reputable one – and skip the scammers.
This is a walkthrough of Halo Wars so you can beat it before your friends do. This is the first chapter of Halo Wars for XBOX 360. Check it out, a cheat walkthrough from Mahalo Gaming.
After finishing up your paint job, you're going to want to clean the paint of your brushes and rollers to save money on replacement. Depending on the paint you used, either oil-based or water-based, you're going to need either water or turpentine to clean off the paint. Watch this video home improvement tutorial and learn how to clean paint off of paint brushes and rollers.
In this clip, we're going to be talking about how to massage away a headache. There are certain different types of headache. So after you've asked your body where the headache is specifically, if it's on the left side or on the right side, if its starting from the base of the neck, maybe even the shoulders, then that way it will gear you to where you need to be a little bit more specifically. Try massage for headache relief. Learn to treat headaches with massage in this health how-to video.
Humus is healthy and vegetarian and is mostly eaten as an appetizer. This cooking how to video tutorial shows you how to prepare a simple base recipe for hummus. Serve it as a snack, for dinner, with pita bread or other breads.
Linus Torvalds, creator of the Linux operating system, often raises eyebrows with a name that may not flow easily off the tongue. As a finlandsvenskar/suomenruotsalainen, or a Swedish-speaking Finn and as a sought-after international engineer, Linus is used to pronouncing his name in at least three different languages. Watch this video language tutorial and learn how to correctly say Linus Torvalds's name in his mother tongue of Swedish, his homeland's language of Finnish, and the internation...
Backstreet Boys Black and Blue album cover is the inspiration for this smoky eyed look. The cosmetic products used to create this makeup effect are a blue eyeshadow base, a blue eyeliner, a blue eye pigment, a blue eyeshadow, a navy eyeshadow, a black eyeshadow base, and a black eyeshadow. Watch this video makeup application tutorial and learn how to do a black and blue Backstreet Boys album cover inspired eye makeup look.
This weekend, take some time to escape from the business and stress of your daily grind. Make a hammock and lay around in it. Fit for a city and you can make it even without much knowledge of sewing machines.
A tried and true idea for getting your photography business going, or just making some extra cash.
This video shows you how to apply your natural food-based dye, set your dye, and remove your dye. Perfect for an arts and crafts project or a handmade fashion statement!
Watch this cooking tutorial to learn how to make coconut soup which is also know as tom kha gai. For this dish, you can either stir fry your meat or boil the coconut cream first.
Here's a Halo 2 trick for playing multiplayer Capture the Flag. Learn how to get the flag quickly and get blasted out of the base so you get a greater chance of getting it back to your base.
Do you need to install a sign for your business? This video segment will show you how to install self-adhesive vinyl graphics for a professional look.
SEO specialist Aaron Wall shares tips on using date based search filters to help you improve your search engine optimization knowledge.
A good stain and varnish can add shine and luster to any piece of wood furniture. Check out these simple steps for staining wood. You will need a painter drop cloth, 2 or 3 1 inch foam brushes, fine grit sandpaper, tack cloth, couple of towels or rags, oil base wood stain and oil base satin varnish.
Watch the lab rats as they breakdown their way of choosing the right mp3 player for you. Maybe its based on flashram or harddrive, the choice is based on your use. These guys explain how they work and what criteria to use to choose the one thats right for you.
Google My Business lets you connect with customers across Google Search and Maps through a unique business profile. The web app allows you to connect and chat with customers in real-time and provides rich analytics to help you manage and grow your company.
Smartglasses startup Nreal enjoyed some highs and endured some lows this week, as the company landed a product placement with Kevin Bacon but then faced production issues related to the coronavirus outbreak.
We may or may not see Apple's long-awaited take on AR smartglasses this year, but the company is more than getting its practice swings in with its current wearables business, which hit record revenue in 2019 according to financial results released this week.
You've probably heard of RCS messaging. The new standard has been promoted by Google as their answer to iMessage and is the backbone behind the new "Chat" features in Android Messages. With RCS, Android phones will now enjoy enhanced messaging like iPhone users have had for years — but is it really the same?
While Magic Leap turned heads at the Game Developers Conference with AR experiences at the Unity and Unreal Engine booths, news broke that the company was the winning bidder for ODG's patents.
The week of the annual Consumer Electronics Show is supposed to be filled with good news for the augmented reality industry as AR headset and smartglasses makers show off their new wares.
Mixed reviews of Magic Leap One aside, it would be hard to deny that Magic Leap has had a big year. And the AR unicorn isn't coasting to the finish line, with a number of new apps dropping and prescription frames finally arriving to bring relief to those who wear eyeglasses.
