We're on sheet, tab, filter. We want to talk about filter, but we also want to talk about an Excel table or list. It is simply a data set with field names at the top, records in rows, no blanks anywhere and no other data sets touching this data set. When we convert to a table, it does a lot of amazing things. The new keyboard shortcut is "Ctrl T". If data is set up correctly, it will work. Click Ok. You can build a function based on a column of data, i.e. "Alt =" which is the shortcut for sum...
We all love muffins and this is a recipe for really spongy, fluffy and moist raspberry muffins that will make the perfect addition at the breakfast table. This video will make baking delicious muffins easy for anyone and any occasion.
This Lowe's video shows you how add warmth and beauty to your home by installing hardwood floors step by step. First you must prepare the sub-floor. You will need engineered hardwood planks, transitions, and moldings. You will also need flooring adhesive, trowel, hardwood floor cleaner, circular saw and table saw, hammer, nylon tapping block, pry bar and pull bar, wood glue, pencil and tape measure, nails, knee pads, dust mask and safety glasses. You should read the instructions. It should ta...
Ingredients required: 1)3 eggs
This video shows Joanne McKenzie working at her table talking about making her oversized/giant photo corners for her paper cutting projects. Using an assortment of different sized and colored punches, she explains how to use the punches, saying the smaller one is the better one to start with. She talks about using the next size up and then centering the paper to be cut from corner to corner and layering the different cut out corners for decoration. Very clear and professional.
This video describes how to improve one's skill when performing home based projects with wood which is a useful skill if one wants to build a table, chair or even a box. In this video one will learn how to sink a nail, cover the hole and leave a sanded finish. For example it is important to drive all nails 1/8 an inch into the surface of the wood so the filler can cover the hole properly and avoid leaving sharp edges or uneven surfaces. Overall this video is simple, easy to follow and useful ...
This bar trick that will be sure to win you some beers. Plucking at the table cloth will slowly, but surely, pull the penny out from under the glass. Try this "coin limbo" party trick out yourself by watching this reveal.
A bar trick is just the thing to win a few bucks… or a few beers. With this "icebreaker" matchbox trick, you can do just that, until you're too drunk to do it anymore, and start losing beer and money. Anyways, the challenge is to put the bottom matchbox on the top while keeping your middle finger on the table at all times.
If you don't have Stampin' Up's Big Shot yet, you will definitely want one after watching this video! In this video you will learn to make a rosette using this machine. You can make them out of paper, fabric or any of a number of mediums. These rosettes are great embellishments for many things such as scrapbooks or gift cards. If you are really adventurous you can even use fabric to make rosettes to adorn your table or maybe make hair decorations for a special little girl.
A-BnC Parties and More, Inc. demonstrates how to construct a do-it-yourself music guitar cut out for your musical theme party centerpieces. The guitar is accented with guitar strings made from black yard, heavy black card stock and clear push pins. Judy shows how to take a plain white polystyrene guitar cut out, paint and add these lovely accents. She puts it on another budget Just Add Sand centerpiece base and accents with two pieces of onion grass. Add balloons, a table name and table place...
Judy of A-BnC Parties and More, Inc. shows you how to make an economical do it yourself music note centerpiece. Three music notes are attached to wooden dowels which are added to a budget Just Add Sand centerpiece base. The centerpiece is accented with two pieces of onion grass. Add balloons, a table name and table place cards for an economical musical themed music note centerpiece for your Bat Mitzvah, Bar Mitzvah, wedding, special event or party!
Watch this instructional quilting video to quilt a pantograph pattern with a longarm sewing machine. A pantograph is a mechanical linkage connected in a special manner so that the movement of one specified point is an amplified version of the movement of another point. If a a line drawing is traced by the first point, an enlarged copy will be drawn by a pen fixed to the other. Take note of the proper way to stand and move one's body when stitching out pantographs. It's best not to move one's ...
Use the Excel Vlookup function in Microsoft Excel 2007 to look up data in a table. This tutorial looks up the level and value of a product from a stock list using the Vlookup function in Excel.
Are you the one scraping sticky marshmallowed yams and congealed gravy off the dishes every Thanksgiving? Shame someone else into doing it this year. Avoid doing the Thanksgiving dishes.
Make a table lamp from home with some tools, wood, and woodworking knowledge. Learn how to make a table lamp base out of wood in this free video on home decor and lighting.
Make a folding puppet theater that stores easily and comes alive with your own designs, including decoupage, stencils, and stickers in this free craft video series.
While augmented reality is a means for presenting news to their audiences to some media outlets, Bloomberg is interested in how the technology can improve the way journalists work.
With augmented reality comes an infinite realm of possibilities for storytelling. We have seen it through wineries telling their history with interactive AR experiences and through authors that use augmented reality to bring portions of their books to life. However, filmmaker Peter Jackson might take the cake on creating an incredible new way of storytelling.
Hi everyone, I have been working on some videos and tips about restoring antique furniture, in this tutorial, I will be showing you how to remove a scratch from a wooden table.
Hello all. It's time for level 6 all, password encrypting. Step 1: Looking for ASCII Table
We don't typically cover games here on softModder, unless they have some special feature to offer like unlocking your device, but sometimes you've just gotta game. When you've only got a few minutes to do so, you've gotta choose the right game, and I've got just the thing for you.
This is just a simple survival light source. You can use a cheap outdoor solar yard light like the one in the video from walmart. There only about 3 to 5 bucks but you can use them not only as a light source but a way to recharge AA rechargeable batteries.
Here's how to make a simple form of a slow burning fuse from materials around the house. WARNING: Ignition of an incendiary or explosive material may not be legal in your area, so check local laws before attempting. Use of this video content is at your own risk.
Playing Angry Birds on a computer just got a lot more interesting. Design students Andrew Spitz and Hideaki Matsui made this awesome slingshot controller for one of their classes at the Copenhagen Institute of Interaction Design.
Need some wrapping paper? Want to go beyond the basic and bland Christmas wrapping paper in stores? There's one solution that's in everyone's pockets— money— cold hard cash— paper bills— money. We're talking George Washington (because Franklin might be a little extreme).
If your family isn't quite the size of the Duggars yet and you're planning what to put on the menu for Thanksgiving, a 30 pound bird is probably not the best choice. Yeah, we know that having a big fat bird in the center of your table is tradition and whatnot, but we seriously doubt a family of five or six could finish all that PLUS side dishes and desserts.
In this video techniques are shown to add ice letters using only butter cream icing. The reason butter cream icing is used is because of the ease of use when writing ice letters. Once your icing bag has been filled with the butter cream icing you must make sure all air has been removed from the bag before beginning. having your desert item on a turn table makes writing with butter cream much easier. Keeping a steady hand and moving at a slow place will give you the best result. The narrator e...
In this tutorial, we learn how to create super hero cape party favors. First, take a plastic red table cover and remove it from the package. Next, open it up and fold it in half twice, so you end up with a rectangle. Then, take scissors and cut a large triangle shape out of the material. When finished, open up the cover and it will be in the shape of a cape! Then, cut out some "s" for Superman signs and tape it on the back of the cape. Then, tie string around the top so it can be worn and you...
In this video from ItalianLessons101 we learn some words that are useful while at a park in Italian. A disclaimer before the video states that this video is designed to teach non Italian speakers some basic phrases. Here are the words that are learned in this lesson:
This video begins with an unfolded painter's canvas unfolded on a table and a frame which will be used to stretch and mend the canvas. The canvas needs to be laid beneath the wooden frame. The canvas must then be stretched over the sides of the wooden frame and then stapled into place. After the canvas has been stretched and stapled over the wooden frame you can pull the corners to tighten the canvas fabric. After the canvas is being stretched within the frame you must let it sit until it bec...
Looking for a quick primer on how to use PivotTable (or Pivot Table) reporting in Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started employing PT reports in your own MS Excel '11 projects, watch the video.
In this tutorial, we learn how to recycle an old t-shirt into a no-sew head scarf. First, lay your shirt out flat on a table and download the paper pattern from the video. From here, measure sixteen inches from side to side on the t-shirt that you are using. After this, follow the paper pattern on the shirt and cut out the pattern with scissors. Once you have finished this, use a fabric bonding agent to make the edges less frayed and fold them into each other. This is great for the environmen...
In this tutorial, we learn how to meet guys everywhere by changing your body language. If you are sitting down with a woman during an afternoon, you need to change your body language to attract men. Don't get too close to the girl and move away from the open edge of the table. You want to notice the surroundings near you and keep your body opened up to people coming up to speak with you. Invite energy over to you and keep a smile on your face. You can carry on a conversation but also invite a...
In this video we learn how to entice more opportunities with feng shui at home. First, find your focus room with an energy map to find the career area. This room is from the front door walking in. Use water, because this is the element for positive career changes. Put a painting of depth that makes you feel like the wall is not right in front of you. Also, add a table with rounded corners and musical instruments or something that you need for your career. This will ensure that you walk into a...
In this video we learn how to recycle plastic bottles and make a decorative mobile. Start off by cutting the strips off of the water bottle then pinning them down to a table. After this, you will start to cross each of these with another piece to make a checkered effect. Nail them down on the sides as well to make it stick to where you want it. When finished, you will remove the nails and then place in a needle with beads and shells attached to it on each of the holes. Once you are finished w...
The quality of the turkey you roast in the oven on Thanksgiving day is tantamount to how successful your Thanksgiving table will be - turkey is, after all, the center of the celebration for most families (unless, of course, you're going the tofurky route).
This mummy-shaped cupcake will be a ka-razy big hit on your Halloween buffet table. Flat, noodle-like layers of icing create a bandaged mummy effect, while an assortment of blue and red candies mimic the mummy's creepy eyes and mouth.
This video shows us how to graph & shade a polygon of constraints. Start out by finding the non zero constraints and the other constraints and inequalities. You will need to know how to graph before you begin to do this equation. Look at the first constraint and then fill in the X and Y sign in your table. Continue on to do this for the other two constraints that you have. Once you have these written down and in front of you, it's just a matter of graphing. Start to graph with the given coord...
In this tutorial, we learn how to maintain your tools for extended usage. First, get a good sturdy brush to clean off all the crusted on dirt from your tool. The dirt will promote rust and deteriorate your tools. Once it's cleaned, also make sure it's dried off from anything that is wet. Also set the tool on a flat surface or table to remove rust off of the tool. You can also sharpen the sides of the tools or shovels so you are pulling out any kinks and making it sharp and more useful. Once f...
This video tutorial is in the Food category which will show you how to make really easy cookie dough. This is the one that is eaten raw, no need to bake and can be prepared in under 5 minutes. You will need a bowl, plain flour, white sugar, margarine, a table spoon, one cup measuring cup and a half cup measuring cup. Put half a cup of margarine in the bowl, add half a cup of white sugar and mix thoroughly. Add one cup of plain flour and mix it. It doesn't have to become like a paste. So, don'...