Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 75th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use name, the INDIRECT function and data validation drop-down lists to create DV lists based on DV lists.
return a descending sorted list of country names based on the values in a row using an array formula that itself makes use of Excel's INDEX, MATCH, RANK, COLUMN and COLUMNS functions.
This video shows you how to make a tech deck quarter pipe. You will need the following materials: wood pieces, cardboard, a small metal bar, glue, and scissors. The first thing you will need to do is cut out the base, this requires cutting out three equal parts (as seen in the video). The base pieces are then glued onto a back board for support. Small slits are then cut in each base to allow space for the metal bar. Glue the bar onto the base, making sure that only the bottom of the bar gets ...
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...
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?
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.
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 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.
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.
In Minecraft, one cool way of getting around those larger fortresses and bases is to set up a minecart. If you're looking for fun or efficient new ways of setting up your minecart station, adding booster carts to make it faster, and adding floor tile switches, check out this video series! There's a plethora of information in here that'll give you the inspiration to have more fun with your base building!
Google is the biggest and best search engine on Earth, and if you are a webmaster and want your website to be a big success it would really behoove you to know as much about how it works as possible. The Google Webmasters series of videos and website were created to teach webmasters, SEO professionals, and others how Google works by answering their questions and giving them insights into how they can best integrate and utilize Google's functionality to improve their business. This video will ...
After 12 years Starcraft 2 is finally here to blow your mind. If you're looking for help with the game, you've come to the right place. We have tons of videos about how to do just about everything in the game. We have strategies for winning campaign and multiplayer games. We have guides to using the immensely powerful level editor. We'll even teach you how to build a Terran Barracks out of Legos. This video will show you how to you can make a mobile wall of supply depots on your Terran base's...
Unless you're an actual mermaid or a member of the Na'vi, this insane mermaid look probably won't get you any propositions on the street.
This 2 part video will show you to make a classic Victoria sandwich sponge cake. Follow along as this sweet afternoon tea snack is put together. Fans of raspberry jam will be delighted to get a nice sweet filling. It's a lot easier than it looks! Just follow the recipe and the video!
Purple cabbage is a natural indicator and this video teaches you how to easily prepare purple cabbage in the comfort of your own home to be used as an acid and base indicator. Take one leaf of your purple cabbage, tear it into smaller pieces and place all the pieces into a beaker or bowl of boiling water for an hour. Collect the liquid from your mixture into a bottle. You’ll notice that the liquid is now dark blue or purple at which point is neutral. It is ready to be used as an indicator. ...
In this video, Anne Marie teaches us how to make soap cupcakes with whipped frosting! This recipe will make 16 soap cupcakes, which is perfect for parties. For the cupcake base you will need: 40 oz white melt & pour soap, 1 1/2 oz vanilla select fragrance, 1 1/2 oz vanilla color stabilizer, 6 ml canary LabColor (diluted), SoapyLove scalloped round mold and spray bottle with rubbing alcohol. For the soap frosting you will need: 16 oz white melt & pour soap, 8 tbsp natural castile liquid soap, ...
A percent problem is one in which you are given a quantity and asked to compute the value of a percent of it. You may also be given the whole quantity and a part of it and asked to compute the percentage of the part in the whole. To do these kind of problems you need to use the rule which states that the ratio of the part to the base it equal to the ratio of the percent to hundred. That is part/base = percent/100. This comes from the definition of percentage which states that percentage is eq...
In this tutorial, you will learn exactly how to make a router-based inlay. And inlay is made up of small cut out sections of wood, and looks like a stencil or pattern when you are finished.
This video demonstrates how to make edible fruit bouquets and arrangements. you can use any fruit and chocolate. Start with a ceramic base. Also, you'll need a Styrofoam ball about 2 inches larger than the base, a hot glue gun, flower shaped cookie cutters, a pack of toothpicks, wire cutters. The video demonstration plans a layer of dates, topped by a layer of chocolate truffles, pineapple and then apricots. Begin by placing artificial leaves to the base, gluing them on. Then hot glue the Sty...
The ancient art of Japanese paper folding is broken down and explained clearly in this video. The video teaches how to create a beautiful bookmark of your own design from a simple single sheet of paper. The instructions use the square base as a jumping off point for showing you how to easily make a custom book mark. There are a few simple beginning steps, and after you complete those you will be able to fold and crease your way to a gorgeous custom origami book mark.
Ingredients for Hiyashi Chuka (serves 2)
