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 218th installment in their series of digital spreadsheet magic tricks, you'll learn how to an Excel 2007 table to create a dynamic range so a macro to create a pivot table will work even when new records are added.
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 216th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a pivot table (PivotTable) with 4-variable cross tabulation. Learn to use multiple fields in a pivot table with this free video tutorial.
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 168th installment in their series of digital spreadsheet magic tricks, you'll learn how to summarize survey results with a pivot table (PivotTable) or a formula. See how to create a Pivot Table in Excel 2003 or 2007.
This video demonstrates how to caulk windows. For this project, you will need the following: a tube caulk, a putty knife, scraper, a knife or scissors, paper towels, a long hanger or a nail, a caulk gun, a small plastic spoon or a popsicle stick.
This is a demonstration of how to upholster full an occasion chair. First the seat upholster is removed carefully. The new cloth is cut accordingly to the shape. The edges are folded and stitched. The cloth is spread over the seat, tucked under the hand rest stretched to the bottom and nailed. For the hand rest a rectangular cloth of required color is cut. A piece of foam is spread over the hand rest and covered with the upholstery cloth and stapled at the sides and bottom. The back rest is r...
In this video tutorial, viewers learn how to remove and replace vinyl siding. Users will need a siding removal tool (zip tool). Insert this tool beneath the bottom edge of the overlap and pull down while sliding the tool horizontally. Remove the nails underneath and simply pull down the siding. Now measure the length of the siding. With the new siding, connect it on the exterior wall and reinforce it with some nails. This video will help those viewers who need to learn how to replace a vinyl ...
In this "Math Made Easy" geometry episode, you learn how to prove that two triangles are congruent (equal) by using the "side-side-side" evidence. By using "side-side-side" to prove that two triangles are congruent, you are stating that all the respective corresponding sides of two triangles are equal in length thus proving the triangles are congruent. The narrator in this tutorial provides you with definitions about statements, proofs, and congruency. This becomes useful when setting up a ta...
This short video is about melting a styro cup without fire. It's magical. Anyone watching it would wonder what had happened to the Styrofoam cup which was dipped in Acetone, nothing but common nail polish remover. This is a short and cute video and watching this could be fun for kids. The fun element comes at the later part of the video. This would kindle the interest of kids in trying out the reaction of different substances in various solvents.
In this six-part video tutorial, learn how to create an access database. The following six parts go over the following:
Watch this origami how to video and learn how to make an origami table and chair. If you are a fan or origami, this instructional video will surely satisfy your origami needs. This origami video goes a little fast, but the table and chair are really cute! Just pause the video as you go along.
Microsoft Word tables serve as an attractive way to organize information. See how to create and edit tables in Word.
It's no secret, artists are broke. That's why they're referred to as "starving artists". One day these artists will achieve unimaginable success, but for most of their lives, they'll be struggling to survive… struggling to keep their vision alive. That's why they need to work cheap. And that's why they stretch their own canvases, not buy pre-made ones or have the hobby shop do it. If you’re a starving artist, save a few bucks, hone your carpentry skills, and stretch your own canvas.
The key to becoming a competent white hat is knowing how the technology that you are trying to exploit actually works. SQL injection is one of the most common methods of attack used today and also one of the easiest to learn. In order to understand how this attack works, you need to have a solid grasp of ... you've guessed it ... SQL.
How to make simple doll tables using cardboard and craft sticks. Easy and cheap to make.
As sure as death and taxes, sitting at a wobbly table at one time or another is inescapable. With your weight on it, the table shifts from one end to the other, lifting one leg in the air and then the other; a parade of seesaws, especially if you have someone sitting on the other end.
This is a very simple and easy basic pearl nail design video that I wanted to share with you all! Hope you like it!
Learn how you can apply fun and easy designs to your nails with this manicure tutorial. You will need nail image plates, scraper, stamper, base coat, top coat, nail polishes and image plate holder. Watch this how to video and you can create beautiful nail art in your own home.
In this quick tutorial you will learn how to achieve a tiger stripe inspired nail look. You will need yellow nail polish, black nail polish, French Tip stickers, glitter nail polish, and clear top coat polish.
Nothing decorates a dinner table better than a napkin swan. It's cute and it makes dinnertime feel like a celebratory event. So, if you want to learn how to make a napkin swan, just follow the folding instructions in the video. Follow along and see what your napkin swan looks like!
Party centerpieces are something of a lost art, but this video will show you how to make a really original one quickly and easily. It looks like a hot air balloon, and requires only a basket, a balloon, some ribbon, and flowers.
This video tutorial shows you step by step how to fold a cloth napkin into a chicken. No, it's not a live chicken, it looks like one you would buy at the grocery store. Just grab your napkin and follow along to impress your friends at the dinner table.
Having a dinner party or just want to impress a date? Use this video to show your good manners and find out how to properly set the table and fold a paper napkin.
Ever wonder which side of the plate to put a fork? This video will show you piece-by-piece how to create a formal place setting for two different meal sizes. This is useful if you are hosting a fancy dinner, or are just having friends over for a nice meal. Some people even enjoy having a formal setting on their dining room table all the time.
Got the winter blahs? We dont' blame you. After all, getting snowed in with four feet of snow outside your front door gets old, fast.
This video begins by showing what a folding painting canvas looks like and what the final stretched canvas should look like. The first step shown is to make sure the bars are measured and marked with a simple A and B for easy measurement recall. After a wood frame is added over the canvas you must fold the material over the back of the wood and nail in place. Once the canvas is nailed to the frame you must add A, B, C and D markings to continue proper alignment procedure. The last step shown ...
Want to know how to style tables in Microsoft Word for Mac 2011? It's easy and this video will show you how it's done. Whether you're new to Microsoft's popular word processing application, new to MS Word 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 using table styles in your own Office for Mac 2011 projects, watch the video.
In this video, we learn how to get the Happy Birthday trophy in Heavy Rain. To start, you will first need to complete your drawing, set the table, and then play with your kids. You play the game as an architect, so this will be fun if you like to draw. Draw in the picture by pressing the buttons on the remote as they come up on the screen. Do the draw over and over until it's final. Then, as you set the table press the buttons on the remote to correspond. When you finish playing with the kids...
In this tutorial, we learn how to install crown molding to your room. First, choose the right size and style of molding for the room, then measure your room to find out how much you need. After this, you will need to buy a saw to cut the molding when you're ready to install. After you have the pieces cut, you will need to place these against the wall and then nail them in with a nail gun. Secure the molding to the joints in the ceiling and to the studs in the wall. To finish, putty the holes ...
In this video, we learn how to prepare surfaces before painting with Lowe's. First, you will need to place a drop cloth on the floor and apply painter's tape to all the outlets and spots you don't want paint to touch. After this, clean off the walls and remove all the dust and debris, including nails. Next, grab the paint you need along with brushes and paint rollers. Remove any wallpaper that is on your wall, then start to paint. Pour the paint into the tray, then use the roller dipped in pa...
You can create a free website using HTML. HTML is hyper text mark up language. Create a folder "my webpage" with all of the images and information for the webpage. Use notepad to write the HTML for the website. Notepad plus is the best which can be found on Sourceforge. Open the browser and the notepad and begin to construct. These codes will help in the creation of the page: <html> opens instructions </html> closes instructions. These are called tags. One opens the commands or instructions a...
In this Education video tutorial you will learn how to make a light bulb from a pickle. Pickles are high in ions in the form of acids and salts. These are electrolytes and they will transfer energy through the pickle. Place a pickle on a glass plate and hook it up with an AC power cord with a nail on each end as shown in the video. You must have protective gloves on. Poke the nails on each end of the pickle and hook up the cord to the power source. The pickle will start emitting light which i...
In this tutorial, we learn how to build your own lunar city model. You will need: toilet paper tube, bottle caps, CDs, sheets, and scissors. Now, cover your table area with the bed sheet so it's completely covered. Now, star tot arrange your lunar city model. Place the CDs on the table and stack them, placing bottle caps in between. After this, cut the toilet paper rolls in half and lay them flat on the ground. After this, place cups lid down on the table and then add CDs on top of them. Now ...
You should encrypt everything. These are what you need: BackTrack 4,0, modify IP tables, Python and ARPspoofing. Program the PC to flip to forwarding mode. Adjust the programming in the IP tables. You are convincing the host and the client that the man (PC) in the middle is the host and capture passwords, user names and other information from unsuspecting clients. This program strips the "S" from "https" which make your computer vulnerable to hackers. You need to observe the address bar and m...
Great pranks, like death and various other phenomena, come in threes. This video is a perfect example of that, and will teach you three awesome pranks that you can pull on a roommate, friend, or mortal enemy. First, you'll learn about placing a table over a sleeping persons head and waking them with an airhorn. Second, you'll learn how to rig a squirting toilet. Lastly, there's the fake tire explosion balloon trick. All classics, all easy, all things you should go try.
If you enjoy spending your time outdoors and tend to a garden, then you need a workspace to call your own. Don't have one, then either buy one or build it. Buying one may be easy, but if you build it you'll appreaciate more.
There's no better time to hang outdoors than during the summer. Hanging out indoors can cause you to sweat up a storm and spend quite a bit of money thanks to constant use of your AC.
Pool is an amazingly challenging game that one can spend a lifetime mastering. If you're bored with it, however, and want to try a new game on your pool table that uses the same skills, this video will show you one. It explains the rules to a game called Carom Pool, which is a hybrid between pocket pool and more traditionally carom billiard games. Even if you don't' enjoy the game, the spread-out nature of the table makes it great for working on your long shots and banks, so rack 'em up!
In order to make your own hangers for your American Girl Dolls' clothes, you will need the following: wood, nails, a hammer, a marker, one American Doll hanger (to be used as a pattern), 14 gauge wire, pliers, and wire cutters.
In this video tutorial, viewers learn how to create a drawing space. A good drawing table has an incline and plenty of space for drawing on. But if you can't afford or don't have enough room for a drawing table, buy a piece of Masonite from the hardware store. Then simply lean the board on a desk or table. To hold the paper onto the board, use some tape and stick it onto the board. This video will benefit those viewers who are interested in art and drawing, and would like to learn how to crea...
They may not come in sparkly, 24K packages like department store brands, but drugstore beauty goodies can often perform just as beautifully for a fraction of the price. You just have to know which particular drugstore products work.
