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 use simple charts in MS Excel as well as see how to use Excel's SUMIFS & AVERAGEIFS functions. Specifically, this video covers the following topics:
Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 13th installment in his series of Excel array formula series, you'll learn how to do multiple regression and linear algebra problems with Excel's LINEST array function. Also see how to use the SLOPE, INTERCEPT and the FORECAST functions for linear algebra and how to create a s...
Trussing a chicken can be a tedious task but YouTube user EasyAsPieRecipes is here to show you how to Truss a chicken the easy way. First put the chicken on it's back. Notice that the wings are sticking out, your going to want to tuck them into its sides as demonstrated. Next, you want to have a piece of twine to tie it around the chicken, and the way your going to want to tie it under the legs(or drumsticks) and make an "X" and then pull it back down and pull it under the legs so it'll actua...
Khanacademy teaches us how to handle simple inequalities (less than or more than). In an equation, we usually have one solution. In problems involving inequalities, there is a whole set of answers. For instance, x minus five is less than 35. The answer for x is a whole series of numbers that when five is taken away from it, is less than 35. This equation is handled like any other equation involving an equal sign. We add five on both sides of the equation and the answer for x is any number tha...
"Blah, I vant to suck your blood!" One of the most common and overused vampire lines out there! But who could blame them? Vampires are pretty interesting and cool creatures that have been around for centuries. What makes them so unique and different is that instead of preying on victims during the day, they use the night to hunt and attack its prey, feeding off their fear of the dark. Well at least in movies. In real life vampires don't exist. But it doesn't mean you can't dress or look like ...
This video from Liaison College demonstrates how to make coconut macaroons. The ingredients needed are egg whites, granulated sugar, salt, vanilla, sifted cake flour and sweetened shredded coconut.
This video shows us how to make a homemade jewellery box out of a Christmas card.For that you need a pair of scissors,a tape,a christmas card,a marker and another card to draw your X with.First take the card and cut it straight down the middle into two pieces.Now take the back side piece of the card and cut off 1/4 of an inch from the left and the bottom portions.This will help to fit the cards together.Next use the extra card and trace an X on both sides of your card piece,in the middle.Take...
In order to prepare Cappuccino with your home espresso machine, you will need the following: milk, coffee, an espresso machine. Fill steamed milk container 2/3 full of milk. Submerge the milk underneath the spinner, before you turn it on. Allow it to steam the milk, until it is warm and frothy. Keep an eye on it, judging the consistency for your self. Remove, when the milk is warm and frothy. Turn the machine off, before you remove the cup. Clean your wand.
Break out the conga dance at your next party or special occasion with help from this free lesson. The conga dance is a celebratory dance that many do in a line involving three steps and a tap to the side. Get tips and tricks on how to stay away from having two left feet with a pro: Rosario Nene Ortega is a ballroom dance instructor at The Goddess Store in Hollywood, Florida. Learn more dance moves from this expert by searching WonderHowTo! You're only practice time away from ruling the dance ...
We’ve all had the problem of a toilet that just won’t stop running. You can fix this problem yourself with a few tools from the local hardware store. The part that is causing the excess running is an old fill tube and stopper valve. You will want to shut the water off to your toilet and then flush the toiled to drain out the water. You will have to unscrew the supply line so that you can replace the fill valve. The process only takes a few minutes and it will save you money from wasted water ...
This video shows how to enter values into cells using Excel macros and Visual Basic. This includes a sample Expense Report that is used in this demonstration. In this demonstration, we will create the macro that inputs a title as "Expense Report", Three columns i.e. "Date", "Item" & "Amount", and the summery field as "Total Expenses", as well as the formulas located at the respective cells. Now, we're going to use two keyboard shortcuts i.e. "Alt + F11" to open-up the VBA window and "Alt + F8...
Childcareland demonstrates how to make a Thanksgiving book of thanks with kids in this video. A book of thanks can be done by a group or an individual. It begins a title page which can be labeled to reflect whether it is an individual book called "My Book of Thanks" or an group book called "Our Book of Thanks" or a general book called "Book of Thanks". The back page is a blank match of the cover page. In the middle are five pages labeled "I'm thankful for" with a line for older children to wr...
This video illustrate how to draw a 3D fanged fish. Here are the following steps.Step 1: Take a sheet of paper and pencil and start drawing a circle forming the face of the fish.Step 2: Now in the middle of the circle draw an wavy line showing the jaws of the fish.Step 3:Now draw two small circle on the boundary of the circle forming the eyes of the fish.Step 4: Now from the jaws draw two fins in opposite direction to each other.Step 5: Now draw Two fans beneath the face showing the back fins...
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 ...
Lillis only flower for one day. They look ugly when dead you can use your finger nail to pop them off. Trim your trees often. Pull your dead leaves. Heat is not good for your plants. When your cutting you crab trees back go down a few branches of leaves before you cut. Yellow breasted sap suckers are not good for your trees. They also cut in a straight line. Crab apple trees have barks that naturally peel off, there is nothing wrong with that tree. Just watch out for the bugs because they can...
The bookmarklet tool lets you send Gmail messages with the click of a button so you don't have to visit your Gmail account. It's an application called GmailThis! From the developer's website, drag the GmailThis! link to the browser's toolbar. Then, if you are already logged into Gmail, just click on the bookmark and a Gmail applet will pop up with a link to the website you were visiting, along with any text you may have been highlighting. You may notice that the subject line is already filled...
This is episode 3 of the series. You will learn how to hack a basic combination lock. Using some basic household items such as a can of soda, scissors and the lock. He demonstrates and takes you through 7 steps, such as cutting the top of the can off, cutting a rectangle size of the aluminum from the can, cut some lines and shapes into it, fold the tops inward and back. He then uses this contraption on the combination lock arm to slip the aluminum piece down into the lock to release the lock....
How to pick the right RAM for your computer
This video is about formatting the charts in Excel especially the x and y axes. The video begins by selecting a chart and right clicking the dates at the bottom of the data points. The format axis window pops up and by making changes to the style, color and the weight of lines given in the patterns tab, you can change the way the x-axis looks like. You can also change appearance of characters appearing close to the x-axis by selecting options in the font menu. You can also change the format o...
Skype continues to be one of the most convenient and widely used methods of keeping in touch with people all over the world. For those of you on the go, having Skype on your Blackberry could prove to be an invaluable communication resource.
In this video Tara Stiles gives an introduction to basic meditation. Meditation can be done while doing the physical yoga poses, or really any time when you have a few moments. Even while you are in line at the grocery store you can practice simple meditation by bringing your attention to your breath. Observe your thoughts and focus on breathing in and out. The intent is to bring yourself back to yourself. Tara leads a guided meditation which begins by encouraging the listener to find a comfo...
In this video tutorial, viewers learn how to put on a Baboosh. Baboosh is a wrap that is made out of nylon and neoprene, which promotes intense sweating to help lose fat quickly from the waist. It is typically for women who have been pregnant. Make sure that the wrap is against your skin and never over your clothes. You want to make it low as possible. Line up the seams against your back. Stretch it and make it fit comfortably. This video will benefit those viewers who have a Baboosh product ...
Make sure you have the appropriate lens for your digital camera. Look for markers on the lens that correspond with any mark on the camera body. Different brands have different markers. Some have square dots while some have red dots. Line these marks In one hand, hold your camera body firmly pointing to you. While holding it, push the lens button. Firmly hold the bottom of the lens (where the lens meets the camera body), and twist. Some cameras let you twist clockwise, others counterclockwise....
Are you a fan of the hot new pop icon Kesha? This video will teach you how to create her loose scrunched waves look. This instructional video requires you to use both a flat iron and blow dryer. The first step is to put volume product into the hair before blow drying it completely dry. Next, part the hair off to the side, making sure to not use your natural part line. Third, section off the hair into manageable strips. Then, place the strip into the flat iron and bend the hair around the iron...
In this video the instructor shows how to change views in Microsoft word 2007 and navigate around the documents. In Microsoft word 2007 in the ribbon there is a view tab to the extreme right. Open the tab. Now in that bar the default layout selected is the Print Layout which is 'What you see is what you get' layout. Next to it the full screen reading option and clicking on it, the documents opens up as a two page book with all the other tool bars hidden. The next is web layout which is ideal ...
In this video tutorial, viewers learn how to make a batch render in Sony Vegas. Sony Vegas is a professional non-linear editing system. Viewers will learn how to use the batch render. At default, it is located on the toolbar. Begin by importing your clips or images into the time line. One of the batch render's features is to render regions. Begin putting regions around the clips by highlighting the clip, press R and press Enter. The add the Add Regions To Event script to automatically set reg...
This humorous video teaches men how to iron a shirt just like Mom did. It walks you through the steps from setting up the ironing board and the iron, to the finished product with easy to follow directions.
Learn the right way to draw a wolf with its full body, by watching this video. The artist begins by drawing three circles faintly and connecting them with a line, representing the head and body of the wolf. Next, the skeletal structures of the legs are outlined. The tail and ears are faintly outlined next. The artist then begins outlining the face in detail, adding the eyes, nose, mouth, ears etc to the wolf’s head. The body is now outlined adding rough edges to indicate fur. The legs of the ...
This video tutorial is going to show you how to make miniature ghost animals. For this you will need some animal figures, cheese puff and some fabric stiffener. Take the cheese puff, put it over the animal figure and measure how much you need. Cut off the cheese puff and put it over the animal; covering it fully. Then, take the fabric stiffener, apply it over the cheese puff and put it over the animal. Wrap it up nicely and let it stand for sometime to dry. But, don’t put it under the animal....
You can ice cakes using a spatula and put a “crumb coat” on the cake to seal in the crumbs prior to decorating. Start by putting a large dollop of icing on top of the cake, spreading it completely over the top with a spatula. Use enough icing that you don't pull the crumbs into the icing as you work.
In this video tutorial, viewers will learn how to change text alignment and formatting in Microsoft Word 2007. To format or align the text, you must high light it first. Once highlighted, users are able format the text in many ways. The formatting options are: font type, font size, bold, italics, underline, strike-through, subscript, superscript and change case. The alignment options are: right align, center, left align and line spacing. Users also learn how to add pictures and position the t...
This is a video from HelpVids.com that discusses how to set and adjust tab stops and indents in Microsoft Word 2007. The video starts off with a Word 2007 document open on the screen. First the presenter shows how to show and hide the rulers. This is accomplished by clicking on a small icon above the vertical scroll bar. Tab Stops are only applied to text that has been selected and not the entire document (unless you select the entire document). The sliders on the ruler control the amount of ...
Swirloflight teaches you how to draw a vase with flowers using a colored pencil. Start with a regular black pencil to sketch the flowers and base. You want to start off with basic shape and draw only what you need. You will now go to the next part, using the colored pencils. Don't go into great detail and don't be afraid of going outside of the lines while coloring in. The colored pencils are good for creating rich areas of color. After you're done with the vase and flowers, create a blended ...
This video shows a quick way to lift your sagging jowls with face exercises. This video targets the platysma and sternomastoid muscles at the front of
In this video the instructor shows how to create charts and graphs in Microsoft Word. First, open the Word document and select an area to insert the charts. Now go to the Insert tab in the ribbon and select the Chart icon. The Insert Chart window opens up with various chart templates. There are various categories of charts like Line, Pie, Bar in the left hand side. In the right hand side you can see the sample charts available and you can select any of them that you want. Now it transfers you...
This is a video tutorial showing you how to make animated letters in the program Macromedia Flash. It shows you how to open up a text box and then separate the letters and add them into an animation sequence. Then it shows you how to set up the animation by setting the letters in different places in the time-line. The outcome is that your letters become animated into a word. This video is helpful for people who want to use animated letters in flash.
Open Xara 3D. Hit show or hide cursor. Type the name JRR Tolkien. Open Animation Options. Set to swing 2. 4 frames per cycle. 1 frame per second. No pause. Angle 0. Select the second "R" and change the animation. Flip the "R" around so it is a mirror image. Go from frame one to frame two. Select the "J". Move the line spacing down to the middle. This yields the JRR Tolkien logo in Xara 3d. You can also flip around the logo using the view menu.
Learn how to make layered spumoni cookies for the holiday season in this simple tutorial. First, melt 1 oz of unsweetened chocolate and soften two sticks of butter. Cream butter together with one egg, half a cup of sugar, and a teaspoon of vanilla. Add in 2 1/4 cups of flour and a pinch of salt. Divide the dough into three parts. Mix candied cherries in one part, 1/4 chopped nuts in the second part, and the chocolate into the third. Press the layers into a loaf pan lined with parchment paper....
This video describes how to create a jumping letters in Flash, first create the text for example "JUMP" and using Break the letters each and then make the layer and now convert the letters into "Movie clips" and now we should add the key frames to our "time line”. Then moves the letters up by using the up arrow now copy the key frames from font end and paste on the back again for go up and come down the letters again and add the "motion between" for each letters and now skip the key frames by...
"How to Tie a Decorative Diamond Knot: Tying It All Together" explains how to tie a decorative diamond knot. The diamond knot is a decorative cylindrical knot, which is also known as the lanyard knot and the knife lanyard knot. Make a loop with one end of the string, and fold the other end parallel in the center of the loop. Feed the end of the right string over the left string and pull down. Fold the right string over and feed through the left side of the loop. Pull a second loop behind the ...
