This video demonstrates how to create collapsible and expandable cell ranges in Excel. The first thing that you will have to is to prepare your Excel worksheet that contains the data which you need to be expandable and collapsible. On the first cell under your Running Total column, type in the function, "=SUM". Select the Sales cell corresponding to that cell then type in Shift+Colon. Click on the first value and hit the F4 key to lock your row reference. The result will automatically show. Y...
In this Software video tutorial you will learn how to use the filter & sort feature in Excel. First create a column chart on an excel sheet. In this example, it is a date and sales chart. Click alt+F1 and the chart is displayed. Then click and delete the legend and the horizontal lines. Now go back to the data set, click on a cell and click ctrl+shift+L and that will add the auto filter. ctrl+shift+L is for Excel 07. For earlier versions, see the commands listed in the video. This is a toggle...
This video shows us how to make Mediterranean Couscous.The ingredients are,1 cup couscous,butter,15 pearl onions,15oz can garbanzo beans,2 red potatoes boiled and cubed,1 cup chopped carrots,1/2 cup chopped cilantro,1/4 cup chopped parsley,2 tablespoons minced garlic,1 teaspoon paprika,1/2 teaspoon cayenne pepper,1/2 teaspoon seven spices,1/4 teaspoon nutmeg, salt, 3 cups of tomato sauce,1 chicken bouillion,pepper and water.Heat a quart pot to a medium.Add 1 1/4 cup of water,the bouillion and...
This video shows how to make a recipe for pork potstickers. This recipe utilizes leftover pulled pork which is not made during the video. Some of the pulled pork is placed into a large mixing bowl. Next a table spoon of minced garlic is added to the bowl followed by a pinch of salt and ground black pepper. Afterwards, thinly sliced scallions as well as chopped cilantro are added to the mixing bowl. The mixture is then thoroughly mixed to combine and distribute all of the ingredients; this mix...
How to Sculpt a Sitting Body out of Clay
First of all take a small fimo punch. You can also use decorative buttons because the smaller cutters are not easily available. Now you need to take the sheets that have thickness less than one millimeter. You have to check them because the larger size shall not fit. Pop in the inlet just like a paper and try to fit. If not then use a roller to roll them to reduce their thickness. Now lift it with a ruler and then insert it into the inlet. The best way to do is to drop them in. Once it fits e...
ARHSphysics shows viewers how they can build a simple barometer using household items! First, you need to get a container that is the height of an index card. Your best bet is to get an empty soup can of food can. Make sure you wash the can. Now, you will need a latex glove, cut a semi circle from the glove and attach this to the top of the can using a rubber band. Get two straws and attach them together at the ends. Cut a slit in each one and attach the straws. Attach the straw to the top of...
This video demonstrates how to create an origami ninja star. Prepare a square shaped piece of paper. Lay it down on a table or on a flat surface. Fold the paper right across the middle in a vertical orientation. Fold it once more in the same manner as the first fold, now creating a more slender vertically standing rectangle. Fold the upper portion of the origami diagonally forming a small triangle on top of the rectangle. Do the same on the bottom portion of the origami. Fold the upper portio...
How to make deep fried pickles
Learn how to ‘Paint onto your T-Shirt’ by watching this video. Materials required for this include the following:•Marabu Textil Plus Start Kit – 6 colors included with paint brush•Marabu Metallic Outliner Paints•Crocodile clips•Masking tape•Pencil•Design printed from the computer•Tracing paper•A large cardboard wrapped in cling film•A dark colored T- ShirtBegin by placing a tracing paper over the design and secure it to the table using masking tape. Next, use a pencil to trace the design on t...
This video instructs you how to make Bake Pork Chops with Vegetables in order to get protein and nutrients. Set the stove to 350 degrees to preheat. Set up a glass baking dish with tin foil lining it. Preheating ensures your food will cook evenly! The veggies will vary, but we'll use one medium onion, a red pepper, and whole white mushrooms. First peel and chop your onion, next the red pepper and then the white mushrooms (slowly if you need to!). Remember to remove the core of the pepper! Pla...
This tutorial demonstrates how to make LEGO Menorah which is used for decorative purposes. First a 1/3 angle brick and a transparent red color stud dot are taken. Then three red cans are taken. Now one of the red can is fixed to one side of the angle brick, leaving the middle open, fix one more can on the other side. The red stud is placed on the middle, on top of which the third can is placed. Now the first menorah is formed which can be placed on tables, walls, etc.
Looking for a new way to jazz up your traditional scone recipe? This video might have the solution you've been looking for. The addition of sour cream is sure to mix things up and add a new twist to your baking adventures.
Garden of Imagination shows viewers how to make realistic looking bread loaves for a dollhouse. First, you need a beige ball of clay or a color that looks like that of bread. Take your ball of clay and warm it up in your hand. Lay it on your table. With the center of your palm, press the ball of clay down. This will give you a nice bread shape. Now, take a twisted wire and make a tic tac toe board on your bread to act as creased. Use rolled up tin foil to give the bread texture. Now, use chal...
Decorating using tissue paper is an inexpensive and it is much prettier than streamers. To make tissue paper flower, all that you need is tissue paper of your color. Have two shades of color for contrast to make it more attractive. Cut the tissue paper into half. Take eight sheets and cut them half which gives you sixteen sheets. Take six to eight of those and lay them on top of each other and make corners match up. Now take the tissue paper and fold it over half inch to one inch and then fol...
The video shows us how to make a orange scallops with Rosemary vapor rice. Firstly two tablespoons of olive oil is taken and is poured in a fry pan and is heated. And then add half finely chopped shallot. Then lower the flame and soften it. In the mean while the sea scallops which are padded dry, are taken individually and then it is mixed with a mixture of flour, dry pepper, kian pepper and a little bit of sea salt. It will take about five minutes for the scallops to soften up. Once they are...
In this video Martha Stewart teaches how to cook Brussels sprouts with warm lemon vinaigrette for a Thanksgiving side dish. To do this you need to trim and quarter 20 ounces of Brussels sprouts, cutting off the stem end. In a frying pan heat two table spoons of olive oil then add the Brussels sprouts to that frying pan. Cook for about four minutes until they reach a nice brown color.
In the video, a boy named George explains how to make a paper box for wrapping gifts in it. For that, first we need two square color papers of any color, and a pair of scissors. In the box making procedure, first place a paper on table, face down. Now fold it diagonally, twice. Unfold it. Then fold the sides twice, to make regular square shapes. Unfold it. Mark the center part using a pen. Cut the paper leaving two folds on four parts, fold it in. Then fold the rest of the part of the paper o...
The following are the steps to be followed to organize a linen closet: 1. First, you need to clear a work space. This works really well because you need to remove the contents from the linen closet.
Sunny Anderson shows you how to make chicken stuffed potato puffs. Start by cutting down a store bought rotisserie chicken into the small chunks. Cut some red and green bell peppers into small pieces next. Put the peppers and the chicken into the bowl. Add some Mexican oregano, pepper, and some salt. Use a spoon to toss the ingredients in the bowl. Bake some potatoes in the oven at 375 degrees for 15 minutes and then peel them. Put the potatoes in a bowl and add one egg, some milk, a table sp...
If you want to know how to make a paper heart to give to your love ones, you should watch this video. To make a paper heart: Fold your paper hotdog style twice. Fold these two sides together, making a rectangle half the length. This will help you avoid a lop-sided heart. Fold one of these sides into the center crease, making a right angle. Make sure the side you fold that toward is the open part of the hotdog. This will help you when tucking it all in at the end. Fold the other side to mirror...
In this arts and crafts video tutorial learn how to make a paper piercing using a paper piercing template with June Campbell. The template comes with pre-made holes in varying designs that you will poke through. You will also need a paper piercing tool to create your holes as well as a craft knife to cut out larger holes. In addition, you will also need a piece of paper. Use a hard surface, such as a plastic tray to protect your table and then place a styrofoam sheet on top of that for furthe...
Watch this video to learn how to make a basic honey and sesame seed chicken. This delicious dish will be generating raves around the dinner table. Ingredients: A plate of sesame seeds Dark soy sauce Blossom honey Vegetable oil five pieces of skinless chicken Fresh coriander for garnish Put a frying pan onto the stove top on high. Mix in a bowl stirs equal amounts of dark soy sauce, honey and vegetable oil to make a sticky marinade. The vegetable oil stops the honey from burning. Add in chicke...
Maria teaches the secrets of making French onion soup. An excellent summary is given below. First peel some onions and slice them nicely. Now heat about 10 table spoons of butter in a soup broth and add the sliced onions to it. Cook them on very low heat by stirring occasionally until they turn golden brown(1 hour approximately). Now add some white wine, turn the heat up high and add a bay leaf and handful of flat leaf parsley to it. Cook it till the wine evaporates, add 3 cups of beef stock ...
Prepare your eating area if you're eating crab at home. Lay newspaper or butcher paper on the table to collect juices. Decide if you're going to eat the crab as you crack it or collect all of the meat on a plate before you eat it.
This video teaches you how to make an arrowhead friendship bracelet. The first step is to pick five colors of string. Then cut 2 pieces of string of each color. All 10 strings should be of the same length. Lay out strings adjacent to each other on the table in this color 1, color 2, color 3, color 4, color 5 and then repeat in the same order. Then knot the strings evenly. Now tape the knot onto a hard surface. Separate the strings into two sections, each section should contain 1 of each color...
If you like kung pao chicken then you’ll adore kung pao shrimp. You can really add something special to your next dinner by bringing this flavorful Asian inspired dish to the table. Shrimp quick very quickly and are ready when pink.
The Mr.G Show presents how to make "hot ice" more commonly known as sodium acetate in the kitchen. You start with one liter of white vinegar which you place into a sauce pan. You add four table spoons of baking soda to the pan being very careful because both chemical together will react an may cause a big mess so be prepared to clean up any boil over that may arise. Wait while this mixture boils down for the real fun to starts. The hot ice created will transform from a liquid to a solid befor...
Starting to work at home? With more and more people trying to make a solid living at home, it's important to know the best way to set up a home office – even if you don't have a spare room. Learn how to set-up a solid work environment with tips from this video on how to create the perfect home office.
Eric Scott demonstrates on how to use a pendulum to connect to the spirit. You can get any pendulum you have or use the custom made light plastic pendulum about five and a half inches long which may help to get your response very quickly.
In this video chef Sanjay Thumma shows how to make sweet tamarind chutney in these simple steps:
Do you have old super 8, or 8mm film lying around? In this video, learn how to transfer that film to your computer without spending loads of cash.
Need to cut back on the sodium? Limiting your daily salt intake can help prevent major diseases. Here's how to cut the sodium out from your diet.
There's no Cheat Engine involved in this Bejeweled Blitz hack. This hack relies on Firefox and a certain extension made specifically for Blitz.
Looking for a new DIY project? Follow the steps in this video to get a great view of big blooms and colorful posies with box planters hung beneath your windows.
Worried about your baby or toddler either wrecking or wrecking themselves in your home? Baby proofing time! Make sure your house is safe and secure for your child when they start exploring their turf.
Are you a novice artist looking to up the ante in your drawings? Introduce depth and realism to your drawings with shadows. It all starts with “seeing the light.”
Chronology in Microsoft Word is convenient when it comes to organizing your documents. Thankfully, you don't have to manually edit the document to put things in alphabetical order! This video shows you how to do it in a few clicks.
A cool glitch for Wizard101. The crate glitch. There are plenty of glitches in this game, but the crate glitch is one to look out for.
This is Cheat Engine hacking for Club Penguin. If you want more coins, you have to hack your way to them. And to hack your way to more coins, you're going to need Cheat Engine.
